· 8 years ago · Dec 08, 2017, 01:56 AM
1CREATE TABLE IF NOT EXISTS `images` (
2 `id` int(11) NOT NULL,
3 `recommandation_id` int(11) NOT NULL,
4 `fichier` varchar(128) NOT NULL,
5 `description` varchar(512) NOT NULL,
6 `order` int(11) NOT NULL,
7 `created` datetime NOT NULL,
8 `modified` datetime NOT NULL,
9 PRIMARY KEY (`id`)
10);
11
12CREATE TABLE IF NOT EXISTS `recommandations` (
13 `id` int(11) NOT NULL,
14 `type` enum('reco','juri','pati') NOT NULL,
15 `categorie` varchar(50) NOT NULL default 'Autres',
16 `titre` varchar(255) NOT NULL,
17 `texte` text NOT NULL,
18 `pdf` varchar(512) default NULL,
19 `created` datetime NOT NULL,
20 `modified` datetime NOT NULL,
21 PRIMARY KEY (`id`)
22);