DROP TABLE IF EXISTS `forum`;

CREATE TABLE `forum` (

  `NumForum` tinyint(3) NOT NULL auto_increment,

  `NomForum` text NOT NULL,

  `LevelForum` tinyint(3) NOT NULL default '0',

  `DescrForum` text NOT NULL,

 PRIMARY KEY(NumForum)

) TYPE=MyISAM AUTO_INCREMENT=1;



DROP TABLE IF EXISTS `sujet`;

CREATE TABLE `sujet` (

  `NumSujet` int(6) NOT NULL auto_increment,

  `NumUser` tinyint(3) NOT NULL,

  `NumForum` tinyint(3) NOT NULL,

  `TitreSujet` text NOT NULL,

  `DerniereReponseSujet` varchar(20) NOT NULL,

  `EtatSujet` tinyint(3) default '1',

  PRIMARY KEY(NumSujet)

) TYPE=MyISAM AUTO_INCREMENT=1;



DROP TABLE IF EXISTS `reponse`;

CREATE TABLE `reponse` (

    `NumReponse` int(6) NOT NULL auto_increment,

    `NumUser` tinyint(3) NOT NULL,

    `Message` text NOT NULL,

    `DateReponse` varchar(20) NOT NULL,

    `NumSujet` int(6) NOT NULL,

    PRIMARY KEY  (`NumReponse`)

) TYPE=MyISAM AUTO_INCREMENT=1;