1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| CREATE TABLE `article` (
`idArticle` int(11) NOT NULL auto_increment,
`idSousRubrique` int(11) NOT NULL default '0',
`idUser` int(11) NOT NULL default '0',
`idPriorite` int(11) NOT NULL default '0',
`idStatut` int(11) NOT NULL default '2',
`titreArticle` text,
`dateArticle` timestamp NOT NULL default '0000-00-00 00:00:00',
`accrocheArticle` text,
`texteArticle` text,
`langArticle` int(11) NOT NULL default '1',
`idGrubrique` int(10) unsigned NOT NULL,
`rank` int(10) unsigned NOT NULL default '0',
`latestEdit` timestamp NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`idArticle`),
KEY `sousrubriqueArticle_FK` (`idSousRubrique`),
KEY `idSousRubrique` (`idSousRubrique`),
KEY `dateArticle` (`dateArticle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; |
Partager