-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `theospoint_database`
--

-- --------------------------------------------------------

--
-- Table structure for table `allergy_lists`
--

CREATE TABLE `allergy_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `allergy_lists`
--

INSERT INTO `allergy_lists` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Soy', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(2, 'Eggs', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(3, 'Dairy', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(4, 'Seafoods', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(5, 'Shrimp', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(6, 'Nuts', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(7, 'Chia', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(8, 'Sesame', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(9, 'Celery', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(10, 'Mushrooms', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(11, 'Eggs/Dairy/Nuts', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(12, 'Nuts/Dairy', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(13, 'Eggs/Dairy', '2022-10-08 12:20:58', '2022-10-08 12:20:58');

-- --------------------------------------------------------

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Dubai', '2021-10-19 09:14:18', '2021-11-01 06:25:08'),
(2, 'Abu Dhabi', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(3, 'Sharjah', '2021-10-19 09:14:19', '2021-11-01 06:25:38'),
(4, 'Ajman', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(5, 'Umm Al Quwain', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(6, 'Al Ain', '2021-10-19 09:14:19', '2022-11-05 05:04:16'),
(7, 'RAK', '2021-10-19 09:14:19', '2021-10-19 09:14:19');

-- --------------------------------------------------------

--
-- Table structure for table `city_districts`
--

CREATE TABLE `city_districts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `city_districts`
--

INSERT INTO `city_districts` (`id`, `city_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 'Dubai Hills', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(2, 1, 'Design District', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(3, 1, 'BurJuma', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(4, 1, 'Deira Duba', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(5, 1, 'Sheikh Zayed Roa', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(6, 1, 'World Trade Center', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(7, 1, 'Liwan', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(8, 1, 'Lifestyle City', '2021-10-19 09:14:19', '2021-10-19 09:14:19'),
(9, 1, 'Arabian Ranches 2', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(10, 1, 'Layan', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(11, 1, 'Abu Hail', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(12, 1, 'Academic City', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(13, 1, 'Al Badaa', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(14, 1, 'Al Baraha', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(15, 1, 'Al Barari', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(16, 1, 'Al Barsha 1', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(17, 1, 'Al Barsha 2', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(18, 1, 'Al Barsha 3', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(19, 1, 'Barsha Heights', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(20, 1, 'Al Barsha South ', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(21, 1, 'Al Furjan', '2021-10-19 09:14:20', '2021-10-19 09:14:20'),
(22, 1, 'Al Garhoud', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(23, 1, 'Al Hudaiba', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(24, 1, 'Al Jaddaf', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(25, 1, 'Al Jafiliya', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(26, 1, 'Al Karama', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(27, 1, 'Al Khabisi', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(28, 1, 'Al Khawaneej 1', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(29, 1, 'Al Khawaneej 2', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(30, 1, 'Al Mamzar', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(31, 1, 'Al Manara', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(32, 1, 'Al Mankhool', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(33, 1, 'Al Mizhar 1', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(34, 1, 'Al Mizhar 2', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(35, 1, 'Al Muntazah Complex', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(36, 1, 'Al Murar', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(37, 1, 'Al Nahda 1', '2021-10-19 09:14:21', '2021-10-19 09:14:21'),
(38, 1, 'Al Nahda 2', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(39, 1, 'Al Quoz 1', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(40, 1, 'Al Quoz 2', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(41, 1, 'Al Quoz 3', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(42, 1, 'Al Quoz 4', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(43, 1, 'Al Qusais 1', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(44, 1, 'Al Qusais 2', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(45, 1, 'Al Raffa', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(46, 1, 'Al Rashidiya', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(47, 1, 'Al Rigga', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(48, 1, 'Al Safa', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(49, 1, 'Al Safouh 1', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(50, 1, 'Al Safouh 2', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(51, 1, 'Al Satwa', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(52, 1, 'Al Twar 1', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(53, 1, 'Al Waha', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(54, 1, 'Al Waheda', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(55, 1, 'Al Warqa 1', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(56, 1, 'Al Warqa 2', '2021-10-19 09:14:22', '2021-10-19 09:14:22'),
(57, 1, 'Al Warqa 3', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(58, 1, 'Al Warqa 4', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(59, 1, 'Al Wasl', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(60, 1, 'Arabian Ranches', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(61, 1, 'Arjan Dubailand', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(62, 1, 'Bluewaters Island', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(63, 1, 'Business Bay', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(64, 1, 'City of Arabia', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(65, 1, 'Damac Hills', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(66, 1, 'Damac Hills Estate', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(67, 1, 'Discovery Gardens', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(68, 1, 'Downtown', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(69, 1, 'Dubai Festival City', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(70, 1, 'Dubai Healthcare City', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(71, 1, 'DIFC', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(72, 1, 'Internet City', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(73, 1, 'Investment park', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(74, 1, 'Knowledge Village', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(75, 1, 'Marina', '2021-10-19 09:14:23', '2021-10-19 09:14:23'),
(76, 1, 'Media City', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(77, 1, 'Studio City', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(78, 1, 'Emirates Hills 1', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(79, 1, 'Emirates Hills 2', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(80, 1, 'Falcon City', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(81, 1, 'Hayat Townhouses', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(82, 1, 'Hor Al Anz', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(83, 1, 'IBN Battuta', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(84, 1, 'IMPZ', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(85, 1, 'International City', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(86, 1, 'Jebel Ali Village', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(87, 1, 'Jumeirah 1', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(88, 1, 'Jumeirah 2', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(89, 1, 'Jumeirah 3', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(90, 1, 'JBR', '2021-10-19 09:14:24', '2021-10-19 09:14:24'),
(91, 1, 'Jumeirah Heights', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(92, 1, 'Jumeirah Island', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(93, 1, 'JLT', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(94, 1, 'Jumeirah Park', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(95, 1, 'JVC', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(96, 1, 'JVT', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(97, 1, 'Majan', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(98, 1, 'Meadows', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(99, 1, 'Meydan', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(100, 1, 'Mira', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(101, 1, 'Mirdif', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(102, 1, 'Motor City', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(103, 1, 'Mudon', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(104, 1, 'Muhaisanah 1', '2021-10-19 09:14:25', '2021-10-19 09:14:25'),
(105, 1, 'Muhaisanah 2', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(106, 1, 'Muhaisanah 3', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(107, 1, 'Muhaisanah 4', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(108, 1, 'Muteena', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(109, 1, 'Nad Al Hammar', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(110, 1, 'Nadd Al Sheba', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(111, 1, 'Naif', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(112, 1, 'Nshama Town Square', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(113, 1, 'Oud Al Muteena', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(114, 1, 'Oud Metha', '2021-10-19 09:14:26', '2021-10-19 09:14:26'),
(115, 1, 'Palm Jumeirah', '2021-10-19 09:14:26', '2021-10-19 09:14:27'),
(116, 1, 'Ras Al Khor', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(117, 1, 'Remraam', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(118, 1, 'Silicon Oasis', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(119, 1, 'Sport City', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(120, 1, 'Springs', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(121, 1, 'Tecom', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(122, 1, 'The Gardens', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(123, 1, 'The Greens', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(124, 1, 'The Lakes', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(125, 1, 'The Sustainable City', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(126, 1, 'The Villa ', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(127, 1, 'Umm Al Sheif', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(128, 1, 'Umm Hurair', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(129, 1, 'Umm Ramool', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(130, 1, 'Umm Suqeim 1', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(131, 1, 'Warsan', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(132, 1, 'Zaabeel', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(133, 1, 'City Walk', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(134, 1, 'Al Twar 2', '2021-10-19 09:14:27', '2021-10-19 09:14:27'),
(135, 1, 'Al Twar 3', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(136, 1, 'Umm Suqeim 2', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(137, 1, 'Umm Suqeim 3', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(138, 1, 'Living Legends', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(139, 1, 'Nad Al Shamma', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(140, 1, 'OTHER', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(141, 2, 'Al Aman', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(142, 2, 'Al Bahya ', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(143, 2, 'Al Bandar', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(144, 2, 'Al Bateen', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(145, 2, 'Al Dana', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(146, 2, 'Al Dhafrah', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(147, 2, 'Al Etihad', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(148, 2, 'Al Falah', '2021-10-19 09:14:28', '2021-10-19 09:14:28'),
(149, 2, 'Al Ghadeer', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(150, 2, 'Al Hisn', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(151, 2, 'Al Kharamah', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(152, 2, 'Al Mannal', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(153, 2, 'Al Maqta', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(154, 2, 'Al Maryah Island', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(155, 2, 'Al Muneera', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(156, 2, 'Al Muntazah', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(157, 2, 'Al Muroor', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(158, 2, 'Al Musalla', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(159, 2, 'Al Mushrif', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(160, 2, 'Al Raha', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(161, 2, 'Al Raha Gardens', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(162, 2, 'Al Rahba', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(163, 2, 'Al Rayhan', '2021-10-19 09:14:29', '2021-10-19 09:14:29'),
(164, 2, 'Al Reef', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(165, 2, 'Al Reem Island', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(166, 2, 'Al Rowdah', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(167, 2, 'Al Saadah', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(168, 2, 'Al Saadiyat', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(169, 2, 'Al Samha', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(170, 2, 'Al Shahama', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(171, 2, 'Al Shamkhah', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(172, 2, 'Al Wahda', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(173, 2, 'Al Zaab', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(174, 2, 'Al Zahiyah', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(175, 2, 'Al Zahraa', '2021-10-19 09:14:30', '2021-10-19 09:14:30'),
(176, 2, 'Al Zeina', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(177, 2, 'Baniyas', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(178, 2, 'Bloom Gardens', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(179, 2, 'Eastern Mangrove', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(180, 2, 'Embassies District', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(181, 2, 'Hills Abu Dhabi', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(182, 2, 'Khalifa City', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(183, 2, 'Khalifa City A', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(184, 2, 'Khalifa City B', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(185, 2, 'Madinat Zayed', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(186, 2, 'Mangrove Village', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(187, 2, 'Masdar City', '2021-10-19 09:14:31', '2021-10-19 09:14:31'),
(188, 2, 'Ministries Area', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(189, 2, 'Mohamed Bin Zayed City', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(190, 2, 'Rowdhat Abu Dhabi', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(191, 2, 'Saadiyat Island', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(192, 2, 'Yas Island', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(193, 2, 'Zayed Sport City', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(194, 2, 'Zayed University', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(195, 2, 'Jazeerat Al Reem', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(196, 2, 'Khalidiya Village', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(197, 2, 'Khalidiyah', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(198, 2, 'Hadbat Al Zafaranah', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(199, 2, 'Al Ras Al Akhdar', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(200, 2, 'Al Marina', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(201, 2, 'Al Kasir', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(202, 2, 'OTHER', '2021-10-19 09:14:32', '2021-10-19 09:14:32'),
(203, 3, 'Al Abar', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(204, 3, 'Al Azra', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(205, 3, 'Al Bu Daniq', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(206, 3, 'Al Darari', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(207, 3, 'Al Falaj', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(208, 3, 'Al Fayha', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(209, 3, 'Al Fisht', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(210, 3, 'Al Ghafia', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(211, 3, 'Al Gharayen', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(212, 3, 'Al Gharb', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(213, 3, 'Al Ghubaiba', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(214, 3, 'Al Goaz', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(215, 3, 'Al Hazannah', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(216, 3, 'Al Heerah Suburb', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(217, 3, 'Al Jazzat', '2021-10-19 09:14:33', '2021-10-19 09:14:33'),
(218, 3, 'Al Jubail', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(219, 3, 'Al Jurainah 1', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(220, 3, 'Al Jurainah 2', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(221, 3, 'Al Jurainah 3', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(222, 3, 'Al Jurainah 4', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(223, 3, 'Al Khaledia Suburb', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(224, 3, 'Al Khan', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(225, 3, 'Al Khezamia', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(226, 3, 'Al Layyeh Suburb', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(227, 3, 'Al Mahatah', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(228, 3, 'Al Majaz 1', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(229, 3, 'Al Majaz 2', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(230, 3, 'Al Majaz 3', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(231, 3, 'Al Manakh', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(232, 3, 'Al Mansoura', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(233, 3, 'Al Mareija', '2021-10-19 09:14:34', '2021-10-19 09:14:34'),
(234, 3, 'Al Mirqab', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(235, 3, 'Al Mujarrah', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(236, 3, 'Al Muntazah', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(237, 3, 'Al Musalla', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(238, 3, 'Al Nabaah', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(239, 3, 'Al Nahda', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(240, 3, 'Al Nasserya', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(241, 3, 'Al Nekhailat', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(242, 3, 'Al Noof 1', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(243, 3, 'Al Noof 2', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(244, 3, 'Al Noof 3', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(245, 3, 'Al Noof 4', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(246, 3, 'Al Nud', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(247, 3, 'Al Qadisiya', '2021-10-19 09:14:35', '2021-10-19 09:14:35'),
(248, 3, 'Al Qasba', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(249, 3, 'Al Qylayaah', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(250, 3, 'Al Ramaqiya', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(251, 3, 'Al Ramla East', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(252, 3, 'Al Ramtha ', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(253, 3, 'Al Rifaah', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(254, 3, 'Al Riqa Suburb', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(255, 3, 'Al Sabkha', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(256, 3, 'Al Seef', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(257, 3, 'Al Shahba', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(258, 3, 'Al Sharq', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(259, 3, 'Al Sweihat', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(260, 3, 'Al Taawun', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(261, 3, 'Al Talaa', '2021-10-19 09:14:36', '2021-10-19 09:14:36'),
(262, 3, ' Al Turfa', '2021-10-19 09:14:37', '2021-10-19 09:14:37'),
(263, 3, 'Al Yarmook', '2021-10-19 09:14:37', '2021-10-19 09:14:37'),
(264, 3, 'Al Yash', '2021-10-19 09:14:37', '2021-10-19 09:14:37'),
(265, 3, 'Barashi', '2021-10-19 09:14:37', '2021-10-19 09:14:37'),
(266, 3, 'Dasman', '2021-10-19 09:14:37', '2021-10-19 09:14:37'),
(267, 3, 'Halwan', '2021-10-19 09:14:37', '2021-10-19 09:14:37'),
(268, 3, 'Halwan Suburb', '2021-10-19 09:14:38', '2021-10-19 09:14:38'),
(269, 3, 'Maysaloon ', '2021-10-19 09:14:38', '2021-10-19 09:14:38'),
(270, 3, 'Muwafjah', '2021-10-19 09:14:38', '2021-10-19 09:14:38'),
(271, 3, 'Muwailih', '2021-10-19 09:14:38', '2021-10-19 09:14:38'),
(272, 3, 'Qarayen 1', '2021-10-19 09:14:38', '2021-10-19 09:14:38'),
(273, 3, 'Qarayen 2', '2021-10-19 09:14:38', '2021-10-19 09:14:38'),
(274, 3, 'Qarayen 3', '2021-10-19 09:14:38', '2021-10-19 09:14:38'),
(275, 3, 'Qarayen 4', '2021-10-19 09:14:38', '2021-10-19 09:14:38'),
(276, 3, 'Qarayen 5', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(277, 3, 'Samnan ', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(278, 3, 'Sharqan ', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(279, 3, 'Al Rahmaniya', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(280, 3, 'OTHER', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(281, 4, 'City Center', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(282, 4, 'Corniche', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(283, 4, 'Marina', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(284, 4, 'Pearl', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(285, 4, 'Uptown', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(286, 4, 'Al Bustan', '2021-10-19 09:14:39', '2021-10-19 09:14:39'),
(287, 4, 'Al Butain', '2021-10-19 09:14:40', '2021-10-19 09:14:40'),
(288, 4, 'Al Hamidiya', '2021-10-19 09:14:40', '2021-10-19 09:14:40'),
(289, 4, 'Al Hamriya', '2021-10-19 09:14:40', '2021-10-19 09:14:40'),
(290, 4, 'Al Helio', '2021-10-19 09:14:40', '2021-10-19 09:14:40'),
(291, 4, 'Al Jurf', '2021-10-19 09:14:40', '2021-10-19 09:14:40'),
(292, 4, 'Al Muntazi', '2021-10-19 09:14:40', '2021-10-19 09:14:40'),
(293, 4, 'Al Mushairef', '2021-10-19 09:14:40', '2021-10-19 09:14:40'),
(294, 4, 'Al Naemiyah', '2021-10-19 09:14:40', '2021-10-19 09:14:40'),
(295, 4, 'Al Nakhil', '2021-10-19 09:14:41', '2021-10-19 09:14:41'),
(296, 4, 'Al Owan', '2021-10-19 09:14:41', '2021-10-19 09:14:41'),
(297, 4, 'Al Rashidiya', '2021-10-19 09:14:41', '2021-10-19 09:14:41'),
(298, 4, 'Al Rowdha', '2021-10-19 09:14:41', '2021-10-19 09:14:41'),
(299, 4, 'Al Rumailah', '2021-10-19 09:14:41', '2021-10-19 09:14:41'),
(300, 4, 'Al Zahra', '2021-10-19 09:14:41', '2021-10-19 09:14:41'),
(301, 4, 'Al Zora', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(302, 4, 'Emirates City', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(303, 4, 'Emirates City Extension', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(304, 4, 'Garden City', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(305, 4, 'Green City', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(306, 5, 'Al Aahad', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(307, 5, 'Al Abrab', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(308, 5, 'Al Dar Al Baida', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(309, 5, 'Al Haditha', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(310, 5, ' Al Hawiyah', '2021-10-19 09:14:42', '2021-10-19 09:14:42'),
(311, 5, 'Al Humrah', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(312, 5, 'Al Limghadar', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(313, 5, 'Al Maidan', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(314, 5, 'Al Raas', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(315, 5, 'Al Ramlah', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(316, 5, 'Al Raudah', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(317, 5, 'Al Riqqah', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(318, 5, 'Al Salamah', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(319, 5, 'Fallaj Al Muwallah', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(320, 5, 'Green Belt', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(321, 5, 'Old Town Area', '2021-10-19 09:14:43', '2021-10-19 09:14:43'),
(322, 5, 'Marina', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(323, 6, 'Al Bateen', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(324, 6, 'Al Dahma', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(325, 6, 'Al Fouah', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(326, 6, 'Al Ghadeer', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(327, 6, 'Al Hili', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(328, 6, 'Al iqabiyyah', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(329, 6, 'Al Jahili', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(330, 6, 'Al Jimi', '2021-10-19 09:14:44', '2021-10-19 09:14:44'),
(331, 6, 'Al Khalidiyah', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(332, 6, 'Al Khibeesi', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(333, 6, 'Al Khrair', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(334, 6, 'Al Maqam', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(335, 6, 'Al Markhaniyyah', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(336, 6, 'Al Masoudi', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(337, 6, 'Al Mnaizfah', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(338, 6, 'Al Mnaizlah', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(339, 6, 'Al Murabaa', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(340, 6, 'Al Mutarid ', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(341, 6, 'Al Mutawah', '2021-10-19 09:14:45', '2021-10-19 09:14:45'),
(342, 6, 'Al Muwaiji', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(343, 6, 'Al Niyadat', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(344, 6, 'Al Owainah', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(345, 6, 'Al Qattarah', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(346, 6, 'Al Ruwaikah', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(347, 6, 'Al Sallan', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(348, 6, 'Al Sarouj', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(349, 6, 'Al Tiwayyah', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(350, 6, 'Al Ugdat', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(351, 6, 'Asharij', '2021-10-19 09:14:46', '2021-10-19 09:14:46'),
(352, 6, 'Bid Bin Ammar', '2021-10-19 09:14:47', '2021-10-19 09:14:47'),
(353, 6, 'Falaj Hazzaa', '2021-10-19 09:14:47', '2021-10-19 09:14:47'),
(354, 6, 'Ghnaymah', '2021-10-19 09:14:47', '2021-10-19 09:14:47'),
(355, 6, 'Hai Khalid', '2021-10-19 09:14:47', '2021-10-19 09:14:47'),
(356, 6, 'Jizat wraigah', '2021-10-19 09:14:47', '2021-10-19 09:14:47'),
(357, 6, 'Majlood', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(358, 6, 'Mreifia', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(359, 6, 'Nimah', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(360, 6, 'Oud Bin Sag-Han', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(361, 6, 'Shabhanet Asher', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(362, 6, 'Shareat Al Muwaiji', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(363, 6, 'Shiab Al Ashkhar', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(364, 6, 'Shibat Al Wutah', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(365, 6, 'Tawam', '2021-10-19 09:14:48', '2021-10-19 09:14:48'),
(366, 7, 'OTHER', '2021-10-19 09:14:48', '2021-10-19 09:14:48');

-- --------------------------------------------------------

--
-- Table structure for table `components`
--

CREATE TABLE `components` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `component_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `component_group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `exclude_list_id` bigint(20) UNSIGNED DEFAULT NULL,
  `allergy_list_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `brand` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Fresh',
  `measuringunit` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchaseunit` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wastage` double DEFAULT '0',
  `increase` double DEFAULT '0',
  `decrease` double DEFAULT '0',
  `minimum` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `cholosterol` double DEFAULT '0',
  `sodium` double DEFAULT '0',
  `fiber` double DEFAULT '0',
  `sugar` double DEFAULT '0',
  `vitaminc` double DEFAULT '0',
  `vitamina` double DEFAULT '0',
  `calcium` double DEFAULT '0',
  `iron` double DEFAULT '0',
  `box_quantity` double DEFAULT '0',
  `quantity` double DEFAULT '0',
  `price` double DEFAULT '0',
  `status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'show',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `component_categories`
--

CREATE TABLE `component_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `purchase_limit` double UNSIGNED DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `component_categories`
--

INSERT INTO `component_categories` (`id`, `name`, `purchase_limit`, `created_at`, `updated_at`) VALUES
(1, 'Baked Foods', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(2, 'Beans and Lentils', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(3, 'Dairy and Egg Products', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(4, 'Fats and Oils', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(5, 'Seafoods', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(6, 'Fruits', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(7, 'Grains and Pasta', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(8, 'Meats', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(9, 'Nuts and Seeds', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(10, 'Prepared Meals', 5000, '2022-10-08 12:20:55', '2022-10-08 12:20:55'),
(11, 'Snacks', 5000, '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(12, 'Soups and Sauces', 5000, '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(13, 'Spices and Herbs', 5000, '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(14, 'Sweets', 5000, '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(15, 'Vegetables', 5000, '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(16, 'Undefined', 5000, '2022-10-08 12:20:56', '2022-10-08 12:20:56');

-- --------------------------------------------------------

--
-- Table structure for table `component_groups`
--

CREATE TABLE `component_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `component_groups`
--

INSERT INTO `component_groups` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Undefined', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(2, 'Carbs', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(3, 'Protein', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(4, 'Dairy', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(5, 'Fats', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(6, 'Fruits', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(7, 'Sugars', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(8, 'Fibers', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(9, 'Sauce', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(10, 'Fats/Protein', '2022-10-08 12:20:56', '2022-10-08 12:20:56');

-- --------------------------------------------------------

--
-- Table structure for table `component_types`
--

CREATE TABLE `component_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `component_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `cholosterol` double DEFAULT '0',
  `sodium` double DEFAULT '0',
  `fiber` double DEFAULT '0',
  `sugar` double DEFAULT '0',
  `vitaminc` double DEFAULT '0',
  `vitamina` double DEFAULT '0',
  `calcium` double DEFAULT '0',
  `iron` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cuisines`
--

CREATE TABLE `cuisines` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_addresses`
--

CREATE TABLE `customer_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `building` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `apartment` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weekdays` text COLLATE utf8mb4_unicode_ci,
  `enabled` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_allergies`
--

CREATE TABLE `customer_allergies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `allergy_list_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_deliveries`
--

CREATE TABLE `customer_deliveries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `delivery_company_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'not delivered',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_drinks`
--

CREATE TABLE `customer_drinks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_plan_drink_id` bigint(20) UNSIGNED DEFAULT NULL,
  `drink_id` bigint(20) UNSIGNED DEFAULT NULL,
  `chef_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_excludes`
--

CREATE TABLE `customer_excludes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `exclude_list_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_lead_addresses`
--

CREATE TABLE `customer_lead_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `building` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `apartment` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weekdays` text COLLATE utf8mb4_unicode_ci,
  `enabled` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_lead_allergies`
--

CREATE TABLE `customer_lead_allergies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `allergy_list_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_lead_excludes`
--

CREATE TABLE `customer_lead_excludes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_lead_id` bigint(20) UNSIGNED DEFAULT NULL,
  `exclude_list_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_meals`
--

CREATE TABLE `customer_meals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_plan_meal_id` bigint(20) UNSIGNED DEFAULT NULL,
  `package_meal_id` bigint(20) UNSIGNED DEFAULT NULL,
  `meal_id` bigint(20) UNSIGNED DEFAULT NULL,
  `chef_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'not started',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_sides`
--

CREATE TABLE `customer_sides` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_plan_side_id` bigint(20) UNSIGNED DEFAULT NULL,
  `side_id` bigint(20) UNSIGNED DEFAULT NULL,
  `chef_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'not started',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `customer_snacks`
--

CREATE TABLE `customer_snacks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_plan_snack_id` bigint(20) UNSIGNED DEFAULT NULL,
  `snack_id` bigint(20) UNSIGNED DEFAULT NULL,
  `chef_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'not started',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `days_offs`
--

CREATE TABLE `days_offs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `delivery_companies`
--

CREATE TABLE `delivery_companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `delivery_times`
--

CREATE TABLE `delivery_times` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `until` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_times`
--

INSERT INTO `delivery_times` (`id`, `name`, `from`, `until`, `created_at`, `updated_at`) VALUES
(1, 'AM', '08:00 AM', '02:00 PM', NULL, NULL),
(2, 'PM', '05:00 PM', '12:00 AM', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `drinks`
--

CREATE TABLE `drinks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cuisine_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'Hot Drink',
  `veg` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'Non-Veg',
  `gluten` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `dairy` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `menu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `vip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `general` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `instructions` text COLLATE utf8mb4_unicode_ci,
  `price` double DEFAULT '0',
  `yield` double DEFAULT '0',
  `serving_number` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `serving_weight` double DEFAULT '0',
  `grams` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `drink_components`
--

CREATE TABLE `drink_components` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `drink_id` bigint(20) UNSIGNED NOT NULL,
  `component_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `drink_packings`
--

CREATE TABLE `drink_packings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `drink_id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `quantity` double UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `drink_portions`
--

CREATE TABLE `drink_portions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `drink_id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `exclude_lists`
--

CREATE TABLE `exclude_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exclude_lists`
--

INSERT INTO `exclude_lists` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Tofu', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(2, 'Beans', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(3, 'Soy', '2022-10-08 12:20:56', '2022-10-08 12:20:56'),
(4, 'Eggs', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(5, 'Seafoods', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(6, 'Avocado', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(7, 'Kiwi', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(8, 'Quinoa', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(9, 'Barley', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(10, 'Oats', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(11, 'Chicken', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(12, 'Red Meat', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(13, 'Turkey', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(14, 'Nuts', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(15, 'Chia', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(16, 'Sesame', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(17, 'Tomato', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(18, 'Cucumber', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(19, 'Zucchini', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(20, 'Onions', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(21, 'Bell Peppers', '2022-10-08 12:20:57', '2022-10-08 12:20:57'),
(22, 'Eggplant', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(23, 'Parsley', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(24, 'Garlic', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(25, 'Beans/Red Meat', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(26, 'Recaito', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(27, 'Shrimp', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(28, 'Cucumber/Parsley', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(29, 'Eggs/Nuts', '2022-10-08 12:20:58', '2022-10-08 12:20:58'),
(30, 'Nuts/Dairy', '2022-10-08 12:20:58', '2022-10-08 12:20:58');

-- --------------------------------------------------------

--
-- Table structure for table `meals`
--

CREATE TABLE `meals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cuisine_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `department` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `validity` int(11) DEFAULT '1',
  `instructions` longtext COLLATE utf8mb4_unicode_ci,
  `gluten` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `dairy` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `source` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `vip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `general` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `serving_desc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `meal_drinks`
--

CREATE TABLE `meal_drinks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meal_id` bigint(20) UNSIGNED NOT NULL,
  `drink_id` bigint(20) UNSIGNED NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `meal_packings`
--

CREATE TABLE `meal_packings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meal_id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `meal_portions`
--

CREATE TABLE `meal_portions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meal_id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `meal_sauces`
--

CREATE TABLE `meal_sauces` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meal_id` bigint(20) UNSIGNED NOT NULL,
  `sauce_id` bigint(20) UNSIGNED NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `meal_sides`
--

CREATE TABLE `meal_sides` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meal_id` bigint(20) UNSIGNED NOT NULL,
  `side_id` bigint(20) UNSIGNED NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `meal_snacks`
--

CREATE TABLE `meal_snacks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meal_id` bigint(20) UNSIGNED NOT NULL,
  `snack_id` bigint(20) UNSIGNED NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `meal_types`
--

CREATE TABLE `meal_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shorthand` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meal_types`
--

INSERT INTO `meal_types` (`id`, `name`, `shorthand`, `created_at`, `updated_at`) VALUES
(1, 'Breakfast', 'B', '2023-03-02 19:32:08', '2023-03-02 19:32:08'),
(2, 'Lunch', 'L', '2023-03-02 19:32:27', '2023-03-02 19:32:27'),
(3, 'Dinner', 'D', '2023-03-02 19:32:28', '2023-03-02 19:32:28'),
(4, 'Lunch Side', 'LS', '2023-03-02 19:32:29', '2023-03-02 19:32:29'),
(5, 'Dinner Side', 'DS', '2023-03-02 19:32:30', '2023-03-02 19:32:30'),
(6, 'Morning Snack 1', 'S1', '2023-03-02 19:32:31', '2023-03-02 19:32:31'),
(7, 'Morning Snack 2', 'S2', '2023-03-02 19:32:31', '2023-03-02 19:32:31'),
(8, 'Afternoon Snack', 'S3', '2023-03-02 19:32:31', '2023-03-02 19:32:31');

-- --------------------------------------------------------

--
-- Table structure for table `meal_type_items`
--

CREATE TABLE `meal_type_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(9, '2014_10_12_000000_create_users_table', 1),
(10, '2014_10_12_100000_create_password_resets_table', 1),
(11, '2019_08_18_000000_create_cities_table', 1),
(12, '2019_08_18_000000_create_city_districts_table', 1),
(13, '2019_08_19_000000_create_allergy_lists_table', 1),
(14, '2019_08_19_000000_create_exclude_lists_table', 1),
(15, '2019_08_19_000000_create_failed_jobs_table', 1),
(16, '2019_08_19_000000_create_units_table', 1),
(17, '2019_08_19_000001_create_promocodes_table', 1),
(18, '2019_08_19_000002_create_delivery_times_table', 1),
(19, '2023_02_21_062351_create_component_categories_table', 1),
(20, '2023_02_21_062351_create_component_groups_table', 1),
(21, '2023_02_21_062352_create_components_table', 1),
(22, '2023_02_21_062353_create_component_types_table', 1),
(23, '2023_02_21_062354_create_cuisines_table', 1),
(24, '2023_02_21_062354_create_meal_types_table', 1),
(25, '2023_02_21_062355_create_meal_type_items_table', 1),
(26, '2023_02_21_062355_create_packages_table', 1),
(27, '2023_02_21_062355_create_portions_table', 1),
(28, '2023_02_21_062356_create_portion_components_table', 1),
(29, '2023_02_21_062356_create_portion_packings_table', 1),
(30, '2023_02_21_062356_create_portion_portions_table', 1),
(31, '2023_02_21_062358_create_sauces_table', 1),
(32, '2023_02_21_062359_create_sauce_components_table', 1),
(33, '2023_02_21_062359_create_sauce_packings_table', 1),
(34, '2023_02_21_062359_create_sauce_portions_table', 1),
(35, '2023_02_21_062368_create_sides_table', 1),
(36, '2023_02_21_062369_create_side_components_table', 1),
(37, '2023_02_21_062369_create_side_packings_table', 1),
(38, '2023_02_21_062369_create_side_portions_table', 1),
(39, '2023_02_21_062378_create_drinks_table', 1),
(40, '2023_02_21_062379_create_drink_components_table', 1),
(41, '2023_02_21_062379_create_drink_packings_table', 1),
(42, '2023_02_21_062379_create_drink_portions_table', 1),
(43, '2023_02_21_062388_create_snacks_table', 1),
(44, '2023_02_21_062389_create_snack_components_table', 1),
(45, '2023_02_21_062389_create_snack_packings_table', 1),
(46, '2023_02_21_062389_create_snack_portions_table', 1),
(47, '2023_02_21_063130_create_package_intakes_table', 1),
(48, '2023_02_21_084518_create_package_intake_meals_table', 1),
(49, '2023_02_21_092356_create_meals_table', 1),
(50, '2023_02_21_095339_create_meal_sauces_table', 1),
(51, '2023_02_21_095622_create_meal_sides_table', 1),
(52, '2023_02_21_095741_create_meal_drinks_table', 1),
(53, '2023_02_21_095922_create_meal_snacks_table', 1),
(54, '2023_02_21_100039_create_meal_portions_table', 1),
(55, '2023_02_21_100040_create_meal_packings_table', 1),
(56, '2023_03_01_070532_create_package_bundles_table', 1),
(57, '2023_03_01_070909_create_package_bundle_types_table', 1),
(58, '2023_03_01_071159_create_package_bundle_days_table', 1),
(59, '2023_03_02_072615_create_package_meals_table', 1),
(60, '2023_03_02_090646_create_package_meal_portions_table', 1),
(61, '2023_03_02_091834_create_package_meal_sauces_table', 1),
(62, '2023_03_02_092429_create_package_meal_snacks_table', 1),
(63, '2023_03_02_092637_create_package_meal_sides_table', 1),
(64, '2023_03_02_093829_create_package_meal_drinks_table', 1),
(65, '2023_03_02_095720_create_package_meal_packings_table', 1),
(66, '2023_03_02_095721_create_package_plans_table', 1),
(67, '2023_03_02_095722_create_package_plan_meals_table', 1),
(68, '2023_03_02_101117_create_package_plan_snacks_table', 1),
(69, '2023_03_02_101445_create_package_plan_sides_table', 1),
(70, '2023_03_02_101642_create_package_plan_drinks_table', 1),
(71, '2023_03_02_104352_create_customer_leads_table', 1),
(72, '2023_03_02_105611_create_customer_lead_addresses_table', 1),
(73, '2023_03_02_113710_create_customer_lead_excludes_table', 1),
(74, '2023_03_02_113741_create_customer_lead_allergies_table', 1),
(75, '2023_03_02_114913_create_customer_lead_subscriptions_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `price` double DEFAULT '0',
  `active` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'true',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_bundles`
--

CREATE TABLE `package_bundles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_bundle_days`
--

CREATE TABLE `package_bundle_days` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_bundle_id` bigint(20) UNSIGNED NOT NULL,
  `days` int(10) UNSIGNED DEFAULT NULL,
  `discount` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_bundle_types`
--

CREATE TABLE `package_bundle_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_bundle_id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_intakes`
--

CREATE TABLE `package_intakes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci,
  `range` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc` text COLLATE utf8mb4_unicode_ci,
  `scale_percentage` double DEFAULT NULL,
  `scale_cals` double DEFAULT NULL,
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `proteins_percentage` double DEFAULT '0',
  `carbs_percentage` double DEFAULT '0',
  `fats_percentage` double DEFAULT '0',
  `price` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_intake_meals`
--

CREATE TABLE `package_intake_meals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_intake_id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_id` bigint(20) UNSIGNED NOT NULL,
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `price` double DEFAULT '0',
  `proteins_percentage` double DEFAULT '0',
  `carbs_percentage` double DEFAULT '0',
  `fats_percentage` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_meals`
--

CREATE TABLE `package_meals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_intake_id` bigint(20) UNSIGNED NOT NULL,
  `meal_id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_id` bigint(20) UNSIGNED NOT NULL,
  `meal_type_item_id` bigint(20) UNSIGNED DEFAULT NULL,
  `scale_calories` double DEFAULT NULL,
  `scale_percentage` double DEFAULT NULL,
  `oneRange` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `price` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `yield` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serving_number` double DEFAULT '0',
  `serving_grams` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_meal_drinks`
--

CREATE TABLE `package_meal_drinks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_meal_id` bigint(20) UNSIGNED NOT NULL,
  `meal_drink_id` bigint(20) UNSIGNED NOT NULL,
  `drink_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` double DEFAULT '0',
  `quantity_grams` double DEFAULT '0',
  `price` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_meal_packings`
--

CREATE TABLE `package_meal_packings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_meal_id` bigint(20) UNSIGNED NOT NULL,
  `meal_packing_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_meal_portions`
--

CREATE TABLE `package_meal_portions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_meal_id` bigint(20) UNSIGNED NOT NULL,
  `meal_portion_id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` double DEFAULT '0',
  `quantity_grams` double DEFAULT '0',
  `price` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_meal_sauces`
--

CREATE TABLE `package_meal_sauces` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_meal_id` bigint(20) UNSIGNED NOT NULL,
  `meal_sauce_id` bigint(20) UNSIGNED NOT NULL,
  `sauce_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` double DEFAULT '0',
  `quantity_grams` double DEFAULT '0',
  `price` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_meal_sides`
--

CREATE TABLE `package_meal_sides` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_meal_id` bigint(20) UNSIGNED NOT NULL,
  `meal_side_id` bigint(20) UNSIGNED NOT NULL,
  `side_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` double DEFAULT '0',
  `quantity_grams` double DEFAULT '0',
  `price` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_meal_snacks`
--

CREATE TABLE `package_meal_snacks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_meal_id` bigint(20) UNSIGNED NOT NULL,
  `meal_snack_id` bigint(20) UNSIGNED NOT NULL,
  `snack_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` double DEFAULT '0',
  `quantity_grams` double DEFAULT '0',
  `price` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_plans`
--

CREATE TABLE `package_plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_intake_id` bigint(20) UNSIGNED NOT NULL,
  `date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_plan_drinks`
--

CREATE TABLE `package_plan_drinks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_intake_id` bigint(20) UNSIGNED NOT NULL,
  `package_plan_id` bigint(20) UNSIGNED DEFAULT NULL,
  `meal_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `drink_id` bigint(20) UNSIGNED DEFAULT NULL,
  `default` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_plan_meals`
--

CREATE TABLE `package_plan_meals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_intake_id` bigint(20) UNSIGNED NOT NULL,
  `package_plan_id` bigint(20) UNSIGNED DEFAULT NULL,
  `package_meal_id` bigint(20) UNSIGNED DEFAULT NULL,
  `meal_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `meal_id` bigint(20) UNSIGNED DEFAULT NULL,
  `default` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_plan_sides`
--

CREATE TABLE `package_plan_sides` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_intake_id` bigint(20) UNSIGNED NOT NULL,
  `package_plan_id` bigint(20) UNSIGNED DEFAULT NULL,
  `meal_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `side_id` bigint(20) UNSIGNED DEFAULT NULL,
  `default` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `package_plan_snacks`
--

CREATE TABLE `package_plan_snacks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `package_intake_id` bigint(20) UNSIGNED NOT NULL,
  `package_plan_id` bigint(20) UNSIGNED DEFAULT NULL,
  `meal_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `snack_id` bigint(20) UNSIGNED DEFAULT NULL,
  `default` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `portions`
--

CREATE TABLE `portions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cuisine_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `source` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `validity` int(11) DEFAULT '1',
  `instructions` text COLLATE utf8mb4_unicode_ci,
  `price` double DEFAULT '0',
  `yield` double DEFAULT '0',
  `serving_number` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `serving_weight` double DEFAULT '0',
  `grams` double DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `portion_components`
--

CREATE TABLE `portion_components` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `component_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `percentage` double DEFAULT NULL,
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `portion_packings`
--

CREATE TABLE `portion_packings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `quantity` double UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `portion_portions`
--

CREATE TABLE `portion_portions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `subportion_id` bigint(20) UNSIGNED DEFAULT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `percentage` double DEFAULT NULL,
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `promocodes`
--

CREATE TABLE `promocodes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `percentage` double DEFAULT '0',
  `limit` int(11) DEFAULT '1',
  `used` int(11) DEFAULT '0',
  `status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sauces`
--

CREATE TABLE `sauces` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cuisine_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `veg` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gluten` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `dairy` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `menu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `vip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `general` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `instructions` text COLLATE utf8mb4_unicode_ci,
  `price` double DEFAULT '0',
  `yield` double DEFAULT '0',
  `serving_number` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `serving_weight` double DEFAULT '0',
  `grams` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sauce_components`
--

CREATE TABLE `sauce_components` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sauce_id` bigint(20) UNSIGNED NOT NULL,
  `component_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sauce_packings`
--

CREATE TABLE `sauce_packings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sauce_id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `quantity` double UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sauce_portions`
--

CREATE TABLE `sauce_portions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sauce_id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `logo` text COLLATE utf8mb4_unicode_ci,
  `bag_price` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `logo`, `bag_price`, `created_at`, `updated_at`) VALUES
(1, '', 100, '2023-03-14 04:52:06', '2023-03-14 04:52:06');

-- --------------------------------------------------------

--
-- Table structure for table `sides`
--

CREATE TABLE `sides` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cuisine_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `veg` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'Non-Veg',
  `gluten` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `dairy` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `menu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `vip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `general` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `instructions` text COLLATE utf8mb4_unicode_ci,
  `price` double DEFAULT '0',
  `yield` double DEFAULT '0',
  `serving_number` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `serving_weight` double DEFAULT '0',
  `grams` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `side_components`
--

CREATE TABLE `side_components` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `side_id` bigint(20) UNSIGNED NOT NULL,
  `component_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `side_packings`
--

CREATE TABLE `side_packings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `side_id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `quantity` double UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `side_portions`
--

CREATE TABLE `side_portions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `side_id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `snacks`
--

CREATE TABLE `snacks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cuisine_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `img` text COLLATE utf8mb4_unicode_ci,
  `veg` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'Non-Veg',
  `gluten` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `dairy` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `menu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `vip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `general` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `instructions` text COLLATE utf8mb4_unicode_ci,
  `price` double DEFAULT '0',
  `yield` double DEFAULT '0',
  `serving_number` double DEFAULT '0',
  `serving_price` double DEFAULT '0',
  `serving_weight` double DEFAULT '0',
  `grams` double DEFAULT '0',
  `cals` double DEFAULT '0',
  `proteins` double DEFAULT '0',
  `carbs` double DEFAULT '0',
  `fats` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `snack_components`
--

CREATE TABLE `snack_components` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `snack_id` bigint(20) UNSIGNED NOT NULL,
  `component_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `snack_packings`
--

CREATE TABLE `snack_packings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `snack_id` bigint(20) UNSIGNED NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `quantity` double UNSIGNED DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `snack_portions`
--

CREATE TABLE `snack_portions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `snack_id` bigint(20) UNSIGNED NOT NULL,
  `portion_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double UNSIGNED DEFAULT '0',
  `quantity_grams` double UNSIGNED DEFAULT '0',
  `cals` double DEFAULT NULL,
  `proteins` double DEFAULT NULL,
  `carbs` double DEFAULT NULL,
  `fats` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `liters` double DEFAULT '0',
  `grams` double DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `allergy_lists`
--
ALTER TABLE `allergy_lists`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `city_districts`
--
ALTER TABLE `city_districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `city_districts_city_id_foreign` (`city_id`);

--
-- Indexes for table `components`
--
ALTER TABLE `components`
  ADD PRIMARY KEY (`id`),
  ADD KEY `components_component_category_id_foreign` (`component_category_id`),
  ADD KEY `components_component_group_id_foreign` (`component_group_id`),
  ADD KEY `components_exclude_list_id_foreign` (`exclude_list_id`),
  ADD KEY `components_allergy_list_id_foreign` (`allergy_list_id`);

--
-- Indexes for table `component_categories`
--
ALTER TABLE `component_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `component_groups`
--
ALTER TABLE `component_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `component_types`
--
ALTER TABLE `component_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `component_types_component_id_foreign` (`component_id`);

--
-- Indexes for table `cuisines`
--
ALTER TABLE `cuisines`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customer_addresses`
--
ALTER TABLE `customer_addresses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_addresses_customer_id_foreign` (`customer_id`),
  ADD KEY `customer_addresses_city_id_foreign` (`city_id`),
  ADD KEY `customer_addresses_city_district_id_foreign` (`city_district_id`);

--
-- Indexes for table `customer_allergies`
--
ALTER TABLE `customer_allergies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_allergies_customer_id_foreign` (`customer_id`),
  ADD KEY `customer_allergies_allergy_list_id_foreign` (`allergy_list_id`);

--
-- Indexes for table `customer_deliveries`
--
ALTER TABLE `customer_deliveries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_deliveries_customer_id_foreign` (`customer_id`),
  ADD KEY `customer_deliveries_delivery_company_id_foreign` (`delivery_company_id`);

--
-- Indexes for table `customer_drinks`
--
ALTER TABLE `customer_drinks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_drinks_customer_id_foreign` (`customer_id`),
  ADD KEY `customer_drinks_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `customer_drinks_package_id_foreign` (`package_id`),
  ADD KEY `customer_drinks_package_plan_drink_id_foreign` (`package_plan_drink_id`),
  ADD KEY `customer_drinks_drink_id_foreign` (`drink_id`),
  ADD KEY `customer_drinks_chef_id_foreign` (`chef_id`);

--
-- Indexes for table `customer_excludes`
--
ALTER TABLE `customer_excludes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_excludes_customer_id_foreign` (`customer_id`),
  ADD KEY `customer_excludes_exclude_list_id_foreign` (`exclude_list_id`);

--
-- Indexes for table `customer_lead_addresses`
--
ALTER TABLE `customer_lead_addresses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_lead_addresses_customer_lead_id_foreign` (`customer_lead_id`),
  ADD KEY `customer_lead_addresses_city_id_foreign` (`city_id`),
  ADD KEY `customer_lead_addresses_city_district_id_foreign` (`city_district_id`);

--
-- Indexes for table `customer_lead_allergies`
--
ALTER TABLE `customer_lead_allergies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_lead_allergies_customer_lead_id_foreign` (`customer_lead_id`),
  ADD KEY `customer_lead_allergies_allergy_list_id_foreign` (`allergy_list_id`);

--
-- Indexes for table `customer_lead_excludes`
--
ALTER TABLE `customer_lead_excludes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_lead_excludes_customer_lead_id_foreign` (`customer_lead_id`),
  ADD KEY `customer_lead_excludes_exclude_list_id_foreign` (`exclude_list_id`);

--
-- Indexes for table `customer_meals`
--
ALTER TABLE `customer_meals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_meals_customer_id_foreign` (`customer_id`),
  ADD KEY `customer_meals_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `customer_meals_package_id_foreign` (`package_id`),
  ADD KEY `customer_meals_package_plan_meal_id_foreign` (`package_plan_meal_id`),
  ADD KEY `customer_meals_package_meal_id_foreign` (`package_meal_id`),
  ADD KEY `customer_meals_meal_id_foreign` (`meal_id`),
  ADD KEY `customer_meals_chef_id_foreign` (`chef_id`);

--
-- Indexes for table `customer_sides`
--
ALTER TABLE `customer_sides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_sides_customer_id_foreign` (`customer_id`),
  ADD KEY `customer_sides_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `customer_sides_package_id_foreign` (`package_id`),
  ADD KEY `customer_sides_package_plan_side_id_foreign` (`package_plan_side_id`),
  ADD KEY `customer_sides_side_id_foreign` (`side_id`),
  ADD KEY `customer_sides_chef_id_foreign` (`chef_id`);

--
-- Indexes for table `customer_snacks`
--
ALTER TABLE `customer_snacks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_snacks_customer_id_foreign` (`customer_id`),
  ADD KEY `customer_snacks_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `customer_snacks_package_id_foreign` (`package_id`),
  ADD KEY `customer_snacks_package_plan_snack_id_foreign` (`package_plan_snack_id`),
  ADD KEY `customer_snacks_snack_id_foreign` (`snack_id`),
  ADD KEY `customer_snacks_chef_id_foreign` (`chef_id`);

--
-- Indexes for table `days_offs`
--
ALTER TABLE `days_offs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `delivery_companies`
--
ALTER TABLE `delivery_companies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `delivery_times`
--
ALTER TABLE `delivery_times`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `drinks`
--
ALTER TABLE `drinks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drinks_cuisine_id_foreign` (`cuisine_id`);

--
-- Indexes for table `drink_components`
--
ALTER TABLE `drink_components`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drink_components_drink_id_foreign` (`drink_id`),
  ADD KEY `drink_components_component_id_foreign` (`component_id`),
  ADD KEY `drink_components_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `drink_packings`
--
ALTER TABLE `drink_packings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drink_packings_drink_id_foreign` (`drink_id`);

--
-- Indexes for table `drink_portions`
--
ALTER TABLE `drink_portions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `drink_portions_drink_id_foreign` (`drink_id`),
  ADD KEY `drink_portions_portion_id_foreign` (`portion_id`),
  ADD KEY `drink_portions_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `exclude_lists`
--
ALTER TABLE `exclude_lists`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `meals`
--
ALTER TABLE `meals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meals_cuisine_id_foreign` (`cuisine_id`);

--
-- Indexes for table `meal_drinks`
--
ALTER TABLE `meal_drinks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meal_drinks_meal_id_foreign` (`meal_id`),
  ADD KEY `meal_drinks_drink_id_foreign` (`drink_id`);

--
-- Indexes for table `meal_packings`
--
ALTER TABLE `meal_packings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meal_packings_meal_id_foreign` (`meal_id`);

--
-- Indexes for table `meal_portions`
--
ALTER TABLE `meal_portions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meal_portions_meal_id_foreign` (`meal_id`),
  ADD KEY `meal_portions_portion_id_foreign` (`portion_id`);

--
-- Indexes for table `meal_sauces`
--
ALTER TABLE `meal_sauces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meal_sauces_meal_id_foreign` (`meal_id`),
  ADD KEY `meal_sauces_sauce_id_foreign` (`sauce_id`);

--
-- Indexes for table `meal_sides`
--
ALTER TABLE `meal_sides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meal_sides_meal_id_foreign` (`meal_id`),
  ADD KEY `meal_sides_side_id_foreign` (`side_id`);

--
-- Indexes for table `meal_snacks`
--
ALTER TABLE `meal_snacks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meal_snacks_meal_id_foreign` (`meal_id`),
  ADD KEY `meal_snacks_snack_id_foreign` (`snack_id`);

--
-- Indexes for table `meal_types`
--
ALTER TABLE `meal_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `meal_type_items`
--
ALTER TABLE `meal_type_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meal_type_items_meal_type_id_foreign` (`meal_type_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `package_bundles`
--
ALTER TABLE `package_bundles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_bundles_package_id_foreign` (`package_id`);

--
-- Indexes for table `package_bundle_days`
--
ALTER TABLE `package_bundle_days`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_bundle_days_package_id_foreign` (`package_id`),
  ADD KEY `package_bundle_days_package_bundle_id_foreign` (`package_bundle_id`);

--
-- Indexes for table `package_bundle_types`
--
ALTER TABLE `package_bundle_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_bundle_types_package_id_foreign` (`package_id`),
  ADD KEY `package_bundle_types_package_bundle_id_foreign` (`package_bundle_id`),
  ADD KEY `package_bundle_types_meal_type_id_foreign` (`meal_type_id`);

--
-- Indexes for table `package_intakes`
--
ALTER TABLE `package_intakes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_intakes_package_id_foreign` (`package_id`);

--
-- Indexes for table `package_intake_meals`
--
ALTER TABLE `package_intake_meals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_intake_meals_package_id_foreign` (`package_id`),
  ADD KEY `package_intake_meals_package_intake_id_foreign` (`package_intake_id`),
  ADD KEY `package_intake_meals_meal_type_id_foreign` (`meal_type_id`);

--
-- Indexes for table `package_meals`
--
ALTER TABLE `package_meals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_meals_package_id_foreign` (`package_id`),
  ADD KEY `package_meals_package_intake_id_foreign` (`package_intake_id`),
  ADD KEY `package_meals_meal_id_foreign` (`meal_id`),
  ADD KEY `package_meals_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `package_meals_meal_type_item_id_foreign` (`meal_type_item_id`);

--
-- Indexes for table `package_meal_drinks`
--
ALTER TABLE `package_meal_drinks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_meal_drinks_package_meal_id_foreign` (`package_meal_id`),
  ADD KEY `package_meal_drinks_meal_drink_id_foreign` (`meal_drink_id`),
  ADD KEY `package_meal_drinks_drink_id_foreign` (`drink_id`),
  ADD KEY `package_meal_drinks_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `package_meal_packings`
--
ALTER TABLE `package_meal_packings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_meal_packings_package_meal_id_foreign` (`package_meal_id`),
  ADD KEY `package_meal_packings_meal_packing_id_foreign` (`meal_packing_id`);

--
-- Indexes for table `package_meal_portions`
--
ALTER TABLE `package_meal_portions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_meal_portions_package_meal_id_foreign` (`package_meal_id`),
  ADD KEY `package_meal_portions_meal_portion_id_foreign` (`meal_portion_id`),
  ADD KEY `package_meal_portions_portion_id_foreign` (`portion_id`),
  ADD KEY `package_meal_portions_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `package_meal_sauces`
--
ALTER TABLE `package_meal_sauces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_meal_sauces_package_meal_id_foreign` (`package_meal_id`),
  ADD KEY `package_meal_sauces_meal_sauce_id_foreign` (`meal_sauce_id`),
  ADD KEY `package_meal_sauces_sauce_id_foreign` (`sauce_id`),
  ADD KEY `package_meal_sauces_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `package_meal_sides`
--
ALTER TABLE `package_meal_sides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_meal_sides_package_meal_id_foreign` (`package_meal_id`),
  ADD KEY `package_meal_sides_meal_side_id_foreign` (`meal_side_id`),
  ADD KEY `package_meal_sides_side_id_foreign` (`side_id`),
  ADD KEY `package_meal_sides_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `package_meal_snacks`
--
ALTER TABLE `package_meal_snacks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_meal_snacks_package_meal_id_foreign` (`package_meal_id`),
  ADD KEY `package_meal_snacks_meal_snack_id_foreign` (`meal_snack_id`),
  ADD KEY `package_meal_snacks_snack_id_foreign` (`snack_id`),
  ADD KEY `package_meal_snacks_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `package_plans`
--
ALTER TABLE `package_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_plans_package_id_foreign` (`package_id`),
  ADD KEY `package_plans_package_intake_id_foreign` (`package_intake_id`);

--
-- Indexes for table `package_plan_drinks`
--
ALTER TABLE `package_plan_drinks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_plan_drinks_package_id_foreign` (`package_id`),
  ADD KEY `package_plan_drinks_package_intake_id_foreign` (`package_intake_id`),
  ADD KEY `package_plan_drinks_package_plan_id_foreign` (`package_plan_id`),
  ADD KEY `package_plan_drinks_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `package_plan_drinks_drink_id_foreign` (`drink_id`);

--
-- Indexes for table `package_plan_meals`
--
ALTER TABLE `package_plan_meals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_plan_meals_package_id_foreign` (`package_id`),
  ADD KEY `package_plan_meals_package_intake_id_foreign` (`package_intake_id`),
  ADD KEY `package_plan_meals_package_plan_id_foreign` (`package_plan_id`),
  ADD KEY `package_plan_meals_package_meal_id_foreign` (`package_meal_id`),
  ADD KEY `package_plan_meals_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `package_plan_meals_meal_id_foreign` (`meal_id`);

--
-- Indexes for table `package_plan_sides`
--
ALTER TABLE `package_plan_sides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_plan_sides_package_id_foreign` (`package_id`),
  ADD KEY `package_plan_sides_package_intake_id_foreign` (`package_intake_id`),
  ADD KEY `package_plan_sides_package_plan_id_foreign` (`package_plan_id`),
  ADD KEY `package_plan_sides_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `package_plan_sides_side_id_foreign` (`side_id`);

--
-- Indexes for table `package_plan_snacks`
--
ALTER TABLE `package_plan_snacks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_plan_snacks_package_id_foreign` (`package_id`),
  ADD KEY `package_plan_snacks_package_intake_id_foreign` (`package_intake_id`),
  ADD KEY `package_plan_snacks_package_plan_id_foreign` (`package_plan_id`),
  ADD KEY `package_plan_snacks_meal_type_id_foreign` (`meal_type_id`),
  ADD KEY `package_plan_snacks_snack_id_foreign` (`snack_id`);

--
-- Indexes for table `portions`
--
ALTER TABLE `portions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `portions_cuisine_id_foreign` (`cuisine_id`);

--
-- Indexes for table `portion_components`
--
ALTER TABLE `portion_components`
  ADD PRIMARY KEY (`id`),
  ADD KEY `portion_components_portion_id_foreign` (`portion_id`),
  ADD KEY `portion_components_component_id_foreign` (`component_id`),
  ADD KEY `portion_components_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `portion_packings`
--
ALTER TABLE `portion_packings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `portion_packings_portion_id_foreign` (`portion_id`);

--
-- Indexes for table `portion_portions`
--
ALTER TABLE `portion_portions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `portion_portions_portion_id_foreign` (`portion_id`),
  ADD KEY `portion_portions_subportion_id_foreign` (`subportion_id`),
  ADD KEY `portion_portions_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `promocodes`
--
ALTER TABLE `promocodes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sauces`
--
ALTER TABLE `sauces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sauces_cuisine_id_foreign` (`cuisine_id`);

--
-- Indexes for table `sauce_components`
--
ALTER TABLE `sauce_components`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sauce_components_sauce_id_foreign` (`sauce_id`),
  ADD KEY `sauce_components_component_id_foreign` (`component_id`),
  ADD KEY `sauce_components_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `sauce_packings`
--
ALTER TABLE `sauce_packings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sauce_packings_sauce_id_foreign` (`sauce_id`);

--
-- Indexes for table `sauce_portions`
--
ALTER TABLE `sauce_portions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sauce_portions_sauce_id_foreign` (`sauce_id`),
  ADD KEY `sauce_portions_portion_id_foreign` (`portion_id`),
  ADD KEY `sauce_portions_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sides`
--
ALTER TABLE `sides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sides_cuisine_id_foreign` (`cuisine_id`);

--
-- Indexes for table `side_components`
--
ALTER TABLE `side_components`
  ADD PRIMARY KEY (`id`),
  ADD KEY `side_components_side_id_foreign` (`side_id`),
  ADD KEY `side_components_component_id_foreign` (`component_id`),
  ADD KEY `side_components_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `side_packings`
--
ALTER TABLE `side_packings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `side_packings_side_id_foreign` (`side_id`);

--
-- Indexes for table `side_portions`
--
ALTER TABLE `side_portions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `side_portions_side_id_foreign` (`side_id`),
  ADD KEY `side_portions_portion_id_foreign` (`portion_id`),
  ADD KEY `side_portions_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `snacks`
--
ALTER TABLE `snacks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `snacks_cuisine_id_foreign` (`cuisine_id`);

--
-- Indexes for table `snack_components`
--
ALTER TABLE `snack_components`
  ADD PRIMARY KEY (`id`),
  ADD KEY `snack_components_snack_id_foreign` (`snack_id`),
  ADD KEY `snack_components_component_id_foreign` (`component_id`),
  ADD KEY `snack_components_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `snack_packings`
--
ALTER TABLE `snack_packings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `snack_packings_snack_id_foreign` (`snack_id`);

--
-- Indexes for table `snack_portions`
--
ALTER TABLE `snack_portions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `snack_portions_snack_id_foreign` (`snack_id`),
  ADD KEY `snack_portions_portion_id_foreign` (`portion_id`),
  ADD KEY `snack_portions_unit_id_foreign` (`unit_id`);

--
-- Indexes for table `units`
--
ALTER TABLE `units`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `allergy_lists`
--
ALTER TABLE `allergy_lists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `city_districts`
--
ALTER TABLE `city_districts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=367;

--
-- AUTO_INCREMENT for table `components`
--
ALTER TABLE `components`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `component_categories`
--
ALTER TABLE `component_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `component_groups`
--
ALTER TABLE `component_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `component_types`
--
ALTER TABLE `component_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cuisines`
--
ALTER TABLE `cuisines`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_addresses`
--
ALTER TABLE `customer_addresses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_allergies`
--
ALTER TABLE `customer_allergies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_deliveries`
--
ALTER TABLE `customer_deliveries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_drinks`
--
ALTER TABLE `customer_drinks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_excludes`
--
ALTER TABLE `customer_excludes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_lead_addresses`
--
ALTER TABLE `customer_lead_addresses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_lead_allergies`
--
ALTER TABLE `customer_lead_allergies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_lead_excludes`
--
ALTER TABLE `customer_lead_excludes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_meals`
--
ALTER TABLE `customer_meals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_sides`
--
ALTER TABLE `customer_sides`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_snacks`
--
ALTER TABLE `customer_snacks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `days_offs`
--
ALTER TABLE `days_offs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `delivery_companies`
--
ALTER TABLE `delivery_companies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `delivery_times`
--
ALTER TABLE `delivery_times`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `drinks`
--
ALTER TABLE `drinks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `drink_components`
--
ALTER TABLE `drink_components`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `drink_packings`
--
ALTER TABLE `drink_packings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `drink_portions`
--
ALTER TABLE `drink_portions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exclude_lists`
--
ALTER TABLE `exclude_lists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `meals`
--
ALTER TABLE `meals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meal_drinks`
--
ALTER TABLE `meal_drinks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meal_packings`
--
ALTER TABLE `meal_packings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meal_portions`
--
ALTER TABLE `meal_portions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meal_sauces`
--
ALTER TABLE `meal_sauces`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meal_sides`
--
ALTER TABLE `meal_sides`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meal_snacks`
--
ALTER TABLE `meal_snacks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meal_types`
--
ALTER TABLE `meal_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `meal_type_items`
--
ALTER TABLE `meal_type_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_bundles`
--
ALTER TABLE `package_bundles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_bundle_days`
--
ALTER TABLE `package_bundle_days`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_bundle_types`
--
ALTER TABLE `package_bundle_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_intakes`
--
ALTER TABLE `package_intakes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_intake_meals`
--
ALTER TABLE `package_intake_meals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_meals`
--
ALTER TABLE `package_meals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_meal_drinks`
--
ALTER TABLE `package_meal_drinks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_meal_packings`
--
ALTER TABLE `package_meal_packings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_meal_portions`
--
ALTER TABLE `package_meal_portions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_meal_sauces`
--
ALTER TABLE `package_meal_sauces`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_meal_sides`
--
ALTER TABLE `package_meal_sides`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_meal_snacks`
--
ALTER TABLE `package_meal_snacks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_plans`
--
ALTER TABLE `package_plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_plan_drinks`
--
ALTER TABLE `package_plan_drinks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_plan_meals`
--
ALTER TABLE `package_plan_meals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_plan_sides`
--
ALTER TABLE `package_plan_sides`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `package_plan_snacks`
--
ALTER TABLE `package_plan_snacks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `portions`
--
ALTER TABLE `portions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `portion_components`
--
ALTER TABLE `portion_components`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `portion_packings`
--
ALTER TABLE `portion_packings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `portion_portions`
--
ALTER TABLE `portion_portions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `promocodes`
--
ALTER TABLE `promocodes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sauces`
--
ALTER TABLE `sauces`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sauce_components`
--
ALTER TABLE `sauce_components`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sauce_packings`
--
ALTER TABLE `sauce_packings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sauce_portions`
--
ALTER TABLE `sauce_portions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sides`
--
ALTER TABLE `sides`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `side_components`
--
ALTER TABLE `side_components`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `side_packings`
--
ALTER TABLE `side_packings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `side_portions`
--
ALTER TABLE `side_portions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `snacks`
--
ALTER TABLE `snacks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `snack_components`
--
ALTER TABLE `snack_components`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `snack_packings`
--
ALTER TABLE `snack_packings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `snack_portions`
--
ALTER TABLE `snack_portions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `units`
--
ALTER TABLE `units`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `city_districts`
--
ALTER TABLE `city_districts`
  ADD CONSTRAINT `city_districts_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `components`
--
ALTER TABLE `components`
  ADD CONSTRAINT `components_allergy_list_id_foreign` FOREIGN KEY (`allergy_list_id`) REFERENCES `allergy_lists` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `components_component_category_id_foreign` FOREIGN KEY (`component_category_id`) REFERENCES `component_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `components_component_group_id_foreign` FOREIGN KEY (`component_group_id`) REFERENCES `component_groups` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `components_exclude_list_id_foreign` FOREIGN KEY (`exclude_list_id`) REFERENCES `exclude_lists` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `component_types`
--
ALTER TABLE `component_types`
  ADD CONSTRAINT `component_types_component_id_foreign` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_addresses`
--
ALTER TABLE `customer_addresses`
  ADD CONSTRAINT `customer_addresses_city_district_id_foreign` FOREIGN KEY (`city_district_id`) REFERENCES `city_districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_addresses_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_addresses_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_allergies`
--
ALTER TABLE `customer_allergies`
  ADD CONSTRAINT `customer_allergies_allergy_list_id_foreign` FOREIGN KEY (`allergy_list_id`) REFERENCES `allergy_lists` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_allergies_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_deliveries`
--
ALTER TABLE `customer_deliveries`
  ADD CONSTRAINT `customer_deliveries_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_deliveries_delivery_company_id_foreign` FOREIGN KEY (`delivery_company_id`) REFERENCES `delivery_companies` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `customer_drinks`
--
ALTER TABLE `customer_drinks`
  ADD CONSTRAINT `customer_drinks_chef_id_foreign` FOREIGN KEY (`chef_id`) REFERENCES `chefs` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_drinks_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_drinks_drink_id_foreign` FOREIGN KEY (`drink_id`) REFERENCES `drinks` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_drinks_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_drinks_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_drinks_package_plan_drink_id_foreign` FOREIGN KEY (`package_plan_drink_id`) REFERENCES `package_plan_drinks` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `customer_excludes`
--
ALTER TABLE `customer_excludes`
  ADD CONSTRAINT `customer_excludes_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_excludes_exclude_list_id_foreign` FOREIGN KEY (`exclude_list_id`) REFERENCES `exclude_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_lead_addresses`
--
ALTER TABLE `customer_lead_addresses`
  ADD CONSTRAINT `customer_lead_addresses_city_district_id_foreign` FOREIGN KEY (`city_district_id`) REFERENCES `city_districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_lead_addresses_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_lead_addresses_customer_lead_id_foreign` FOREIGN KEY (`customer_lead_id`) REFERENCES `customer_leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_lead_allergies`
--
ALTER TABLE `customer_lead_allergies`
  ADD CONSTRAINT `customer_lead_allergies_allergy_list_id_foreign` FOREIGN KEY (`allergy_list_id`) REFERENCES `allergy_lists` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_lead_allergies_customer_lead_id_foreign` FOREIGN KEY (`customer_lead_id`) REFERENCES `customer_leads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_lead_excludes`
--
ALTER TABLE `customer_lead_excludes`
  ADD CONSTRAINT `customer_lead_excludes_customer_lead_id_foreign` FOREIGN KEY (`customer_lead_id`) REFERENCES `customer_leads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_lead_excludes_exclude_list_id_foreign` FOREIGN KEY (`exclude_list_id`) REFERENCES `exclude_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_meals`
--
ALTER TABLE `customer_meals`
  ADD CONSTRAINT `customer_meals_chef_id_foreign` FOREIGN KEY (`chef_id`) REFERENCES `chefs` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_meals_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_meals_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_meals_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_meals_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_meals_package_meal_id_foreign` FOREIGN KEY (`package_meal_id`) REFERENCES `package_meals` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_meals_package_plan_meal_id_foreign` FOREIGN KEY (`package_plan_meal_id`) REFERENCES `package_plan_meals` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `customer_sides`
--
ALTER TABLE `customer_sides`
  ADD CONSTRAINT `customer_sides_chef_id_foreign` FOREIGN KEY (`chef_id`) REFERENCES `chefs` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_sides_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_sides_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_sides_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_sides_package_plan_side_id_foreign` FOREIGN KEY (`package_plan_side_id`) REFERENCES `package_plan_sides` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_sides_side_id_foreign` FOREIGN KEY (`side_id`) REFERENCES `sides` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `customer_snacks`
--
ALTER TABLE `customer_snacks`
  ADD CONSTRAINT `customer_snacks_chef_id_foreign` FOREIGN KEY (`chef_id`) REFERENCES `chefs` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_snacks_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_snacks_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_snacks_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `customer_snacks_package_plan_snack_id_foreign` FOREIGN KEY (`package_plan_snack_id`) REFERENCES `package_plan_snacks` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `customer_snacks_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `drinks`
--
ALTER TABLE `drinks`
  ADD CONSTRAINT `drinks_cuisine_id_foreign` FOREIGN KEY (`cuisine_id`) REFERENCES `cuisines` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `drink_components`
--
ALTER TABLE `drink_components`
  ADD CONSTRAINT `drink_components_component_id_foreign` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `drink_components_drink_id_foreign` FOREIGN KEY (`drink_id`) REFERENCES `drinks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `drink_components_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `drink_packings`
--
ALTER TABLE `drink_packings`
  ADD CONSTRAINT `drink_packings_drink_id_foreign` FOREIGN KEY (`drink_id`) REFERENCES `drinks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `drink_portions`
--
ALTER TABLE `drink_portions`
  ADD CONSTRAINT `drink_portions_drink_id_foreign` FOREIGN KEY (`drink_id`) REFERENCES `drinks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `drink_portions_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `drink_portions_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meals`
--
ALTER TABLE `meals`
  ADD CONSTRAINT `meals_cuisine_id_foreign` FOREIGN KEY (`cuisine_id`) REFERENCES `cuisines` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `meal_drinks`
--
ALTER TABLE `meal_drinks`
  ADD CONSTRAINT `meal_drinks_drink_id_foreign` FOREIGN KEY (`drink_id`) REFERENCES `drinks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `meal_drinks_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meal_packings`
--
ALTER TABLE `meal_packings`
  ADD CONSTRAINT `meal_packings_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meal_portions`
--
ALTER TABLE `meal_portions`
  ADD CONSTRAINT `meal_portions_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `meal_portions_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meal_sauces`
--
ALTER TABLE `meal_sauces`
  ADD CONSTRAINT `meal_sauces_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `meal_sauces_sauce_id_foreign` FOREIGN KEY (`sauce_id`) REFERENCES `sauces` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meal_sides`
--
ALTER TABLE `meal_sides`
  ADD CONSTRAINT `meal_sides_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `meal_sides_side_id_foreign` FOREIGN KEY (`side_id`) REFERENCES `sides` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meal_snacks`
--
ALTER TABLE `meal_snacks`
  ADD CONSTRAINT `meal_snacks_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `meal_snacks_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meal_type_items`
--
ALTER TABLE `meal_type_items`
  ADD CONSTRAINT `meal_type_items_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_bundles`
--
ALTER TABLE `package_bundles`
  ADD CONSTRAINT `package_bundles_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_bundle_days`
--
ALTER TABLE `package_bundle_days`
  ADD CONSTRAINT `package_bundle_days_package_bundle_id_foreign` FOREIGN KEY (`package_bundle_id`) REFERENCES `package_bundles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_bundle_days_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_bundle_types`
--
ALTER TABLE `package_bundle_types`
  ADD CONSTRAINT `package_bundle_types_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_bundle_types_package_bundle_id_foreign` FOREIGN KEY (`package_bundle_id`) REFERENCES `package_bundles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_bundle_types_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_intakes`
--
ALTER TABLE `package_intakes`
  ADD CONSTRAINT `package_intakes_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_intake_meals`
--
ALTER TABLE `package_intake_meals`
  ADD CONSTRAINT `package_intake_meals_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_intake_meals_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_intake_meals_package_intake_id_foreign` FOREIGN KEY (`package_intake_id`) REFERENCES `package_intakes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_meals`
--
ALTER TABLE `package_meals`
  ADD CONSTRAINT `package_meals_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meals_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meals_meal_type_item_id_foreign` FOREIGN KEY (`meal_type_item_id`) REFERENCES `meal_type_items` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `package_meals_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meals_package_intake_id_foreign` FOREIGN KEY (`package_intake_id`) REFERENCES `package_intakes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_meal_drinks`
--
ALTER TABLE `package_meal_drinks`
  ADD CONSTRAINT `package_meal_drinks_drink_id_foreign` FOREIGN KEY (`drink_id`) REFERENCES `drinks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_drinks_meal_drink_id_foreign` FOREIGN KEY (`meal_drink_id`) REFERENCES `meal_drinks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_drinks_package_meal_id_foreign` FOREIGN KEY (`package_meal_id`) REFERENCES `package_meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_drinks_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_meal_packings`
--
ALTER TABLE `package_meal_packings`
  ADD CONSTRAINT `package_meal_packings_meal_packing_id_foreign` FOREIGN KEY (`meal_packing_id`) REFERENCES `meal_packings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_packings_package_meal_id_foreign` FOREIGN KEY (`package_meal_id`) REFERENCES `package_meals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_meal_portions`
--
ALTER TABLE `package_meal_portions`
  ADD CONSTRAINT `package_meal_portions_meal_portion_id_foreign` FOREIGN KEY (`meal_portion_id`) REFERENCES `meal_portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_portions_package_meal_id_foreign` FOREIGN KEY (`package_meal_id`) REFERENCES `package_meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_portions_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_portions_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_meal_sauces`
--
ALTER TABLE `package_meal_sauces`
  ADD CONSTRAINT `package_meal_sauces_meal_sauce_id_foreign` FOREIGN KEY (`meal_sauce_id`) REFERENCES `meal_sauces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_sauces_package_meal_id_foreign` FOREIGN KEY (`package_meal_id`) REFERENCES `package_meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_sauces_sauce_id_foreign` FOREIGN KEY (`sauce_id`) REFERENCES `sauces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_sauces_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_meal_sides`
--
ALTER TABLE `package_meal_sides`
  ADD CONSTRAINT `package_meal_sides_meal_side_id_foreign` FOREIGN KEY (`meal_side_id`) REFERENCES `meal_sides` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_sides_package_meal_id_foreign` FOREIGN KEY (`package_meal_id`) REFERENCES `package_meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_sides_side_id_foreign` FOREIGN KEY (`side_id`) REFERENCES `sides` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_sides_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_meal_snacks`
--
ALTER TABLE `package_meal_snacks`
  ADD CONSTRAINT `package_meal_snacks_meal_snack_id_foreign` FOREIGN KEY (`meal_snack_id`) REFERENCES `meal_snacks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_snacks_package_meal_id_foreign` FOREIGN KEY (`package_meal_id`) REFERENCES `package_meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_snacks_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_meal_snacks_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_plans`
--
ALTER TABLE `package_plans`
  ADD CONSTRAINT `package_plans_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plans_package_intake_id_foreign` FOREIGN KEY (`package_intake_id`) REFERENCES `package_intakes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_plan_drinks`
--
ALTER TABLE `package_plan_drinks`
  ADD CONSTRAINT `package_plan_drinks_drink_id_foreign` FOREIGN KEY (`drink_id`) REFERENCES `drinks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_drinks_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_drinks_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_drinks_package_intake_id_foreign` FOREIGN KEY (`package_intake_id`) REFERENCES `package_intakes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_drinks_package_plan_id_foreign` FOREIGN KEY (`package_plan_id`) REFERENCES `package_plans` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_plan_meals`
--
ALTER TABLE `package_plan_meals`
  ADD CONSTRAINT `package_plan_meals_meal_id_foreign` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_meals_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_meals_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_meals_package_intake_id_foreign` FOREIGN KEY (`package_intake_id`) REFERENCES `package_intakes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_meals_package_meal_id_foreign` FOREIGN KEY (`package_meal_id`) REFERENCES `package_meals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_meals_package_plan_id_foreign` FOREIGN KEY (`package_plan_id`) REFERENCES `package_plans` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_plan_sides`
--
ALTER TABLE `package_plan_sides`
  ADD CONSTRAINT `package_plan_sides_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_sides_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_sides_package_intake_id_foreign` FOREIGN KEY (`package_intake_id`) REFERENCES `package_intakes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_sides_package_plan_id_foreign` FOREIGN KEY (`package_plan_id`) REFERENCES `package_plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_sides_side_id_foreign` FOREIGN KEY (`side_id`) REFERENCES `sides` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_plan_snacks`
--
ALTER TABLE `package_plan_snacks`
  ADD CONSTRAINT `package_plan_snacks_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_snacks_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_snacks_package_intake_id_foreign` FOREIGN KEY (`package_intake_id`) REFERENCES `package_intakes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_snacks_package_plan_id_foreign` FOREIGN KEY (`package_plan_id`) REFERENCES `package_plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_plan_snacks_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `portions`
--
ALTER TABLE `portions`
  ADD CONSTRAINT `portions_cuisine_id_foreign` FOREIGN KEY (`cuisine_id`) REFERENCES `cuisines` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `portion_components`
--
ALTER TABLE `portion_components`
  ADD CONSTRAINT `portion_components_component_id_foreign` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `portion_components_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `portion_components_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `portion_packings`
--
ALTER TABLE `portion_packings`
  ADD CONSTRAINT `portion_packings_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `portion_portions`
--
ALTER TABLE `portion_portions`
  ADD CONSTRAINT `portion_portions_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `portion_portions_subportion_id_foreign` FOREIGN KEY (`subportion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `portion_portions_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sauces`
--
ALTER TABLE `sauces`
  ADD CONSTRAINT `sauces_cuisine_id_foreign` FOREIGN KEY (`cuisine_id`) REFERENCES `cuisines` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `sauce_components`
--
ALTER TABLE `sauce_components`
  ADD CONSTRAINT `sauce_components_component_id_foreign` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sauce_components_sauce_id_foreign` FOREIGN KEY (`sauce_id`) REFERENCES `sauces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sauce_components_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sauce_packings`
--
ALTER TABLE `sauce_packings`
  ADD CONSTRAINT `sauce_packings_sauce_id_foreign` FOREIGN KEY (`sauce_id`) REFERENCES `sauces` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sauce_portions`
--
ALTER TABLE `sauce_portions`
  ADD CONSTRAINT `sauce_portions_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sauce_portions_sauce_id_foreign` FOREIGN KEY (`sauce_id`) REFERENCES `sauces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sauce_portions_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sides`
--
ALTER TABLE `sides`
  ADD CONSTRAINT `sides_cuisine_id_foreign` FOREIGN KEY (`cuisine_id`) REFERENCES `cuisines` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `side_components`
--
ALTER TABLE `side_components`
  ADD CONSTRAINT `side_components_component_id_foreign` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `side_components_side_id_foreign` FOREIGN KEY (`side_id`) REFERENCES `sides` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `side_components_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `side_packings`
--
ALTER TABLE `side_packings`
  ADD CONSTRAINT `side_packings_side_id_foreign` FOREIGN KEY (`side_id`) REFERENCES `sides` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `side_portions`
--
ALTER TABLE `side_portions`
  ADD CONSTRAINT `side_portions_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `side_portions_side_id_foreign` FOREIGN KEY (`side_id`) REFERENCES `sides` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `side_portions_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `snacks`
--
ALTER TABLE `snacks`
  ADD CONSTRAINT `snacks_cuisine_id_foreign` FOREIGN KEY (`cuisine_id`) REFERENCES `cuisines` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `snack_components`
--
ALTER TABLE `snack_components`
  ADD CONSTRAINT `snack_components_component_id_foreign` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `snack_components_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `snack_components_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `snack_packings`
--
ALTER TABLE `snack_packings`
  ADD CONSTRAINT `snack_packings_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `snack_portions`
--
ALTER TABLE `snack_portions`
  ADD CONSTRAINT `snack_portions_portion_id_foreign` FOREIGN KEY (`portion_id`) REFERENCES `portions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `snack_portions_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `snack_portions_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE;
COMMIT;

