CREATE TABLE `forum_msg` (
`ID` int(8) NOT NULL auto_increment,
`ID_sujet` int(11) NOT NULL default '0',
`Titre` varchar(100) NOT NULL default '',
`Message` longtext NOT NULL,
`Date` datetime default NULL,
`Membre` varchar(80) NOT NULL default '',
`ID_membre` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `ID_sujet` (`ID_sujet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=101429 ;
CREATE TABLE `forum_sujet` (
`ID` int(8) NOT NULL auto_increment,
`ID_forum` int(3) NOT NULL default '0',
`Referant` int(1) NOT NULL default '0',
`Titre` varchar(100) NOT NULL default '',
`Type` int(11) NOT NULL default '0',
`Clicks` int(5) NOT NULL default '0',
`ID_ss_cat` int(8) NOT NULL,
`Membre` varchar(80) NOT NULL default '',
`Dernier_Date` datetime default NULL,
`Dernier_pseudo` varchar(80) NOT NULL default '',
`Vue` int(1) NOT NULL default '0',
`Date_crea` datetime NOT NULL default '0000-00-00 00:00:00',
`resolu` int(1) NOT NULL default '0',
`ID_membre` int(11) NOT NULL default '0',
`Bloquer` int(1) NOT NULL default '0',
`FAQ` int(1) NOT NULL default '0',
`valid_news` int(1) NOT NULL default '1',
`Delestage_date` date NOT NULL,
`sondage` int(1) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `ID_forum` (`ID_forum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21533 ;
Partager