v86gEfeN

1DROP TABLE IF EXISTS `mealtime_menu`;
2CREATE TABLE  `mealtime_menu` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `date` date NOT NULL,
5  `establishment_id` int(11) NOT NULL,
6  `filled` tinyint(1) NOT NULL DEFAULT '0',
7  PRIMARY KEY (`id`),
8  KEY `mealtime_menu_16c435c4` (`establishment_id`),
9  CONSTRAINT `establishment_id_refs_id_296fb368` FOREIGN KEY (`establishment_id`) REFERENCES `establishment_establishment` (`id`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11
12
13DROP TABLE IF EXISTS `mealtime_menufood`;
14CREATE TABLE  `mealtime_menufood` (
15  `id` int(11) NOT NULL AUTO_INCREMENT,
16  `menu_id` int(11) NOT NULL,
17  `food_id` int(11) NOT NULL,
18  `establishment_group_id` int(11) NOT NULL,
19  `type` smallint(6) NOT NULL DEFAULT '1',
20  `people_count` int(11) DEFAULT '0',
21  PRIMARY KEY (`id`),
22  UNIQUE KEY `mealtime_menufood_menu_id_606f71cd_uniq` (`menu_id`,`food_id`,`establishment_group_id`,`type`),
23  KEY `mealtime_menufood_143efa3` (`menu_id`),
24  KEY `mealtime_menufood_3d259cc` (`food_id`),
25  KEY `mealtime_menufood_45f2f066` (`establishment_group_id`),
26  CONSTRAINT `establishment_group_id_refs_id_50dd902c` FOREIGN KEY (`establishment_group_id`) REFERENCES `establishment_establishmentgroup` (`id`),
27  CONSTRAINT `food_id_refs_id_7299ee20` FOREIGN KEY (`food_id`) REFERENCES `dish_food` (`id`),
28  CONSTRAINT `menu_id_refs_id_4783ad5b` FOREIGN KEY (`menu_id`) REFERENCES `mealtime_menu` (`id`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8;