#
# Mise à jour de la table 'agenda'
#

ALTER TABLE agenda ADD nom varchar(128) DEFAULT 'vide' NOT NULL;
ALTER TABLE agenda ADD email varchar(128) DEFAULT 'vide' NOT NULL;
ALTER TABLE agenda ADD telephone varchar(128) DEFAULT 'vide' NOT NULL;
ALTER TABLE agenda ADD fax varchar(128) DEFAULT 'vide' NOT NULL;
ALTER TABLE agenda ADD url varchar(128) DEFAULT 'vide' NOT NULL;


#
# Structure de la table 'comment'
#

CREATE TABLE comment (
   id int(5) NOT NULL auto_increment,
   idevent int(5) NOT NULL,
   pseudo varchar(128) NOT NULL,
   mail varchar(128) NOT NULL,
   comment longtext NOT NULL,
   date int(32) NOT NULL,
   PRIMARY KEY (id)
);