1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| CREATE TABLE IF NOT EXISTS `jos_lylo_concerts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_lieu` int(11) NOT NULL,
`date` date NOT NULL,
`heure` time NOT NULL,
`paf` varchar(255) NOT NULL,
`plateau` varchar(255) NOT NULL,
`infos` varchar(255) NOT NULL,
`style` int(5) NOT NULL,
`style_parent` int(5) NOT NULL,
`type_clubbing` int(1) NOT NULL,
`type_jamsession` int(1) NOT NULL,
`type_enfants` int(1) NOT NULL,
`image` varchar(255) NOT NULL,
`description` text NOT NULL,
`code_postal` varchar(20) NOT NULL,
`departement` int(5) NOT NULL,
`region` int(5) NOT NULL,
`checked_out` int(11) NOT NULL,
`checked_out_time` datetime NOT NULL,
`last_update` datetime NOT NULL,
`published` int(11) NOT NULL,
`frontpage` int(1) NOT NULL,
`ordering` int(11) NOT NULL,
`params` text NOT NULL,
`id_filemaker` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_style` (`style`),
KEY `idx_date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='table des concerts' AUTO_INCREMENT=29590 ; |
Partager