#
# Structure de la table 'agenda'
#

CREATE TABLE agenda (
   id smallint(6) NOT NULL auto_increment,
   manif varchar(128) NOT NULL,
   date_deb int(32),
   date_fin int(32),
   lieu varchar(128) NOT NULL,
   description longtext NOT NULL,
   entree longtext NOT NULL,
   etat int(2) NOT NULL,
   rubrique varchar(32) NOT NULL,
   nom varchar(128) DEFAULT 'vide' NOT NULL,
   email varchar(128) DEFAULT 'vide' NOT NULL,
   telephone varchar(128) DEFAULT 'vide' NOT NULL,
   fax varchar(128) DEFAULT 'vide' NOT NULL,
   url varchar(128) DEFAULT 'vide' NOT NULL,
   PRIMARY KEY (id)
);


#
# 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)
);