1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| CREATE TABLE `news` (
`id_news` int(10) unsigned NOT NULL auto_increment,
`type_news` tinyint(3) unsigned NOT NULL default '0',
`type_lieu` tinyint(4) default NULL,
`date_debut` datetime NOT NULL default '0000-00-00 00:00:00',
`date_fin` datetime default NULL,
`validate` tinyint(1) unsigned NOT NULL default '0',
`titre_news` varchar(150) default NULL,
`vignette` varchar(30) default NULL,
`resume_news` text,
`texte` text,
`lien` varchar(200) default NULL,
`resultat` text,
`image_url` varchar(200) default NULL,
`image_titre` varchar(100) default NULL,
PRIMARY KEY (`id_news`,`id_news`),
UNIQUE KEY `id_action` (`id_news`),
FULLTEXT KEY `titre_news` (`titre_news`),
FULLTEXT KEY `resume_news` (`resume_news`),
FULLTEXT KEY `texte` (`texte`),
FULLTEXT KEY `resultat` (`resultat`)
) TYPE=MyISAM AUTO_INCREMENT=140 ; |
Partager