-- --------------------------------------------------------
-- Versión del servidor:         8.0.30 - MySQL Community Server - GPL
-- SO del servidor:              Win64
-- HeidiSQL Versión:             12.1.0.6537
-- --------------------------------------------------------


-- Volcando datos para la tabla food_on_wheels.failed_jobs: ~0 rows (aproximadamente)
DELETE FROM `failed_jobs`;

-- Volcando datos para la tabla food_on_wheels.food_categories: ~4 rows (aproximadamente)
DELETE FROM `food_categories`;
INSERT INTO `food_categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
	(1, 'Breakfast', 'desayuno', '2024-08-10 20:16:56', '2024-08-10 20:16:57'),
	(2, 'Luch', 'almuerzo', '2024-08-10 20:16:56', '2024-08-10 20:16:57'),
	(3, 'Dinner', 'comida', '2024-08-10 20:17:48', '2024-08-10 20:17:49'),
	(4, 'By the pound', '\'', '2024-08-25 19:00:01', '2024-08-25 19:00:01');

-- Volcando datos para la tabla food_on_wheels.food_clients: ~4 rows (aproximadamente)
DELETE FROM `food_clients`;
INSERT INTO `food_clients` (`id`, `name`, `email`, `cel`, `address`, `created_at`, `updated_at`) VALUES
	(5, 'q', 'q', 'q', 'q', '2024-08-18 00:49:46', '2024-08-18 00:49:46'),
	(6, 'LAURA', 'POSADA@GMAIL.COM', '2321231', 'ARMENIA', '2024-08-18 04:47:19', '2024-08-18 04:47:19'),
	(7, 'Vanessa', 'posadaa@gmail.co', '3202342', 'montenegro', '2024-08-18 04:52:55', '2024-08-18 04:52:55'),
	(8, 'Laura', 'lau@gmail.com', '3207356688', 'armenia', '2024-08-25 23:40:55', '2024-08-25 23:40:55');

-- Volcando datos para la tabla food_on_wheels.food_ingredients: ~5 rows (aproximadamente)
DELETE FROM `food_ingredients`;
INSERT INTO `food_ingredients` (`id`, `name`, `description`, `carbohydrate`, `proteins`, `fat`, `calories`, `price`, `created_at`, `updated_at`) VALUES
	(1, 'Ropa vieja', NULL, 6.00, 24.00, 51.00, 406.00, 25.00, '2024-08-10 22:19:29', '2024-08-26 00:01:16'),
	(2, 'Grilled steak', NULL, 12.00, 1.00, 1.00, 100.00, 25.00, '2024-08-10 22:22:51', '2024-08-26 00:01:40'),
	(3, 'grilled chicken thinghs over breast', NULL, 12.00, 5.00, 5.00, 5.00, 18.00, '2024-08-10 23:48:31', '2024-08-26 00:02:15'),
	(4, 'Chicken stew', NULL, 0.00, 0.00, 0.00, 0.00, 21.00, '2024-08-26 00:02:37', '2024-08-26 00:02:37'),
	(5, 'BBQ pulled', NULL, 0.00, 0.00, 0.00, 0.00, 20.00, '2024-08-26 00:02:59', '2024-08-26 00:02:59');

-- Volcando datos para la tabla food_on_wheels.food_ingredient_detail: ~3 rows (aproximadamente)
DELETE FROM `food_ingredient_detail`;
INSERT INTO `food_ingredient_detail` (`id`, `food_order_detail_id`, `ingredient_id`, `menu_id`, `quantity`, `unit_price`, `total_price`, `created_at`, `updated_at`) VALUES
	(13, 48, 1, 25, 1, 25.00, 25.00, '2024-09-02 02:19:41', '2024-09-02 02:19:41'),
	(14, 48, 2, 25, 1, 25.00, 25.00, '2024-09-02 02:19:41', '2024-09-02 02:19:41'),
	(15, 50, 1, 25, 6, 25.00, 150.00, '2024-09-02 02:19:41', '2024-09-02 02:19:41');

-- Volcando datos para la tabla food_on_wheels.food_menus: ~22 rows (aproximadamente)
DELETE FROM `food_menus`;
INSERT INTO `food_menus` (`id`, `category_id`, `name`, `description`, `customizable`, `ingredients`, `days`, `carbohydrate`, `proteins`, `fat`, `calories`, `image`, `price`, `status`, `created_at`, `updated_at`, `vegan`) VALUES
	(1, 1, 'overninght oats w/fruits', NULL, 'no', '[]', '["monday"]', 19.00, 31.00, 13.00, 317.00, 'image_menu_66b945cd45747', 15.00, 'hidden', '2024-08-11 01:19:58', '2024-08-26 06:12:28', 'no'),
	(2, 1, 'Chocolate chips proteind pancakes', NULL, 'no', 'null', '["tuesday"]', 34.00, 30.00, 10.00, 346.00, 'image_menu_66b9460b4b096', 20.00, 'public', '2024-08-11 01:20:52', '2024-08-12 04:15:23', 'yes'),
	(3, 1, 'Turkey bacon egg white omelette', NULL, 'no', 'null', '["wednesday"]', 24.00, 35.00, 16.00, 378.00, 'image_menu_66b9464cdf3e8', 5.00, 'public', '2024-08-11 01:21:52', '2024-08-12 04:16:28', 'no'),
	(4, 1, 'Grilled egg & cheese sandwich', NULL, 'no', 'null', '["thursday"]', 14.00, 32.00, 19.00, 388.00, 'image_menu_66b9468863a50', 11.00, 'public', '2024-08-11 01:22:52', '2024-08-12 04:17:28', 'no'),
	(8, 1, 'Tacos', NULL, 'no', 'null', '["friday"]', 15.00, 38.00, 14.00, 374.00, 'image_menu_66b946b07e21f', 12.00, 'public', '2024-08-12 04:18:08', '2024-08-12 04:18:08', 'no'),
	(9, 2, 'Almond crusted salmon w/brown rice', NULL, 'no', 'null', '["monday"]', 49.00, 41.00, 18.00, 522.00, 'image_menu_66b947052c9f4', 25.00, 'public', '2024-08-12 04:19:33', '2024-08-12 04:19:33', 'no'),
	(10, 2, 'Meatballs', NULL, 'no', 'null', '["tuesday"]', 43.00, 41.00, 16.00, 481.00, 'image_menu_66b9472c58dab', 30.00, 'public', '2024-08-12 04:20:12', '2024-08-12 04:20:12', 'no'),
	(11, 2, 'Pork kabobs w/roasted potatoes', NULL, 'no', 'null', '["wednesday"]', 48.00, 39.00, 18.00, 510.00, 'image_menu_66b9476582ba0', 35.00, 'public', '2024-08-12 04:21:09', '2024-08-12 04:23:38', 'no'),
	(12, 2, 'Chicken bacon w/BBQ pinaple sause', NULL, 'no', 'null', '["thursday"]', 47.00, 48.00, 15.00, 515.00, 'image_menu_66b947a2ebbc5', 34.00, 'public', '2024-08-12 04:22:10', '2024-08-12 04:24:01', 'no'),
	(13, 2, 'Chicken fajitas w/cilantro brown lime rice', NULL, 'no', 'null', '["friday"]', 51.00, 43.00, 24.00, 587.00, 'image_menu_66b947f19e9a1', 40.00, 'public', '2024-08-12 04:23:29', '2024-08-12 04:23:29', 'no'),
	(14, 3, 'sweet & sour roasted pork loin', NULL, 'no', 'null', '["monday"]', 48.00, 40.00, 20.00, 532.00, 'image_menu_66b948989d91c', 25.00, 'public', '2024-08-12 04:26:16', '2024-08-12 04:26:16', 'no'),
	(15, 3, 'macarroni  shimp salad', NULL, 'no', 'null', '["tuesday"]', 32.00, 38.00, 17.00, 429.00, 'image_menu_66b948d310187', 20.00, 'public', '2024-08-12 04:27:15', '2024-08-12 04:29:56', 'no'),
	(16, 3, 'grilled chicken thinghs over couscous salad', NULL, 'no', 'null', '["wednesday"]', 39.00, 42.00, 11.00, 427.00, 'image_menu_66b94914477a4', 30.00, 'public', '2024-08-12 04:28:20', '2024-08-12 04:28:20', 'no'),
	(17, 3, 'mediterranean turkey burger', NULL, 'no', 'null', '["thursday"]', 32.00, 42.00, 16.00, 441.00, 'image_menu_66b9494fe6c71', 30.00, 'public', '2024-08-12 04:29:19', '2024-08-12 04:29:19', 'no'),
	(18, 3, 'jack daniels chicken w/coleslaw', NULL, 'no', 'null', '["friday"]', 39.00, 42.00, 18.00, 498.00, 'image_menu_66b949b25e650', 21.00, 'public', '2024-08-12 04:30:58', '2024-08-12 04:30:58', 'no'),
	(19, 2, 'Orange glazed tofu', NULL, 'no', 'null', '["monday"]', 0.00, 0.00, 0.00, 0.00, 'image_menu_66cb643e3257a', 0.00, 'public', '2024-08-25 22:05:02', '2024-08-25 22:05:02', 'yes'),
	(20, 2, 'Beef w/ homemade beans', NULL, 'no', 'null', '["tuesday"]', 0.00, 0.00, 0.00, 0.00, 'image_menu_66cb647f27b59', 0.00, 'public', '2024-08-25 22:06:07', '2024-08-25 22:06:07', 'yes'),
	(21, 2, 'Garlic parmessan meatballs over fired rice', NULL, 'no', 'null', '["wednesday"]', 0.00, 0.00, 0.00, 0.00, 'image_menu_66cb64bc59292', 0.00, 'public', '2024-08-25 22:07:08', '2024-08-25 22:07:08', 'yes'),
	(22, 2, 'Chicken W/rice mix', NULL, 'no', 'null', '["thursday"]', 0.00, 0.00, 0.00, 0.00, 'image_menu_66cb64e901624', 0.00, 'public', '2024-08-25 22:07:53', '2024-08-25 22:07:53', 'yes'),
	(23, 2, 'Colombian pollo guisado w/jasmine rice', NULL, 'no', 'null', '["friday"]', 0.00, 0.00, 0.00, 0.00, 'image_menu_66cb651449ec6', 0.00, 'public', '2024-08-25 22:08:36', '2024-08-25 22:08:36', 'yes'),
	(24, 3, 'Chicken parm over', NULL, 'no', 'null', '["monday"]', 0.00, 0.00, 0.00, 0.00, 'image_menu_66cb6881c1a9c', 0.00, 'public', '2024-08-25 22:23:13', '2024-08-25 22:23:13', 'yes'),
	(25, 4, 'Menu By the pound', NULL, 'yes', '["2", "1"]', '["monday", "tuesday", "wednesday"]', 0.00, 0.00, 0.00, 0.00, NULL, 0.00, 'public', '2024-08-26 00:07:45', '2024-08-27 06:01:52', 'no');

-- Volcando datos para la tabla food_on_wheels.food_orders: ~1 rows (aproximadamente)
DELETE FROM `food_orders`;
INSERT INTO `food_orders` (`id`, `client_id`, `total`, `proof_payment`, `created_at`, `updated_at`) VALUES
	(17, 8, 215.00, 'order_1725225581', '2024-09-02 02:19:41', '2024-09-02 02:19:41');

-- Volcando datos para la tabla food_on_wheels.food_orders_details: ~5 rows (aproximadamente)
DELETE FROM `food_orders_details`;
INSERT INTO `food_orders_details` (`id`, `order_id`, `menu_id`, `quantity`, `unit_price`, `total_price`, `created_at`, `updated_at`) VALUES
	(46, 17, 1, 1, 15.00, 15.00, '2024-09-02 02:19:41', '2024-09-02 02:19:41'),
	(47, 17, 25, 1, 0.00, 0.00, '2024-09-02 02:19:41', '2024-09-02 02:19:41'),
	(48, 17, 25, 1, 0.00, 0.00, '2024-09-02 02:19:41', '2024-09-02 02:19:41'),
	(49, 17, 24, 1, 0.00, 0.00, '2024-09-02 02:19:41', '2024-09-02 02:19:41'),
	(50, 17, 25, 6, 0.00, 0.00, '2024-09-02 02:19:41', '2024-09-02 02:19:41');

-- Volcando datos para la tabla food_on_wheels.forms: ~0 rows (aproximadamente)
DELETE FROM `forms`;

-- Volcando datos para la tabla food_on_wheels.galleries: ~0 rows (aproximadamente)
DELETE FROM `galleries`;

-- Volcando datos para la tabla food_on_wheels.last_posts: ~0 rows (aproximadamente)
DELETE FROM `last_posts`;

-- Volcando datos para la tabla food_on_wheels.migrations: ~26 rows (aproximadamente)
DELETE FROM `migrations`;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_000000_create_users_table', 1),
	(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
	(3, '2019_08_19_000000_create_failed_jobs_table', 1),
	(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(5, '2024_05_30_002855_create_services_table', 1),
	(6, '2024_06_03_161318_create_sliders_table', 1),
	(7, '2024_06_03_194002_add_status_to_sliders_table', 1),
	(8, '2024_06_12_005747_create_forms_table', 1),
	(9, '2024_06_12_200949_add_column_to_users_table', 1),
	(10, '2024_06_12_201129_modify_image2_column_in_services_table', 1),
	(11, '2024_06_12_223417_create_last_posts_table', 1),
	(12, '2024_06_13_125809_change_work_date_to_date_in_your_last_posts', 1),
	(13, '2024_06_13_130201_change_work_date_to_date_in_last_posts', 1),
	(14, '2024_06_14_023255_create_testimonials_table', 1),
	(15, '2024_06_18_003232_create_galleries_table', 1),
	(16, '2024_08_07_165925_create_food_clients_table', 1),
	(17, '2024_08_07_165926_create_food_categories_table', 1),
	(18, '2024_08_07_170007_create_food_ingredients_table', 1),
	(19, '2024_08_07_170008_create_food_menus_table', 1),
	(20, '2024_08_07_170053_create_food_orders_table', 1),
	(21, '2024_08_10_040409_add_image_to_food_menus', 1),
	(22, '2024_08_14_010010_create_food_ingredients_detail_table', 1),
	(23, '2024_08_14_013837_modific_food_orders_table', 1),
	(24, '2024_08_14_013927_create_food_orders_details_table', 1),
	(25, '2024_08_24_011024_add_proof_payment_to_orders', 2),
	(26, '2024_08_25_164428_add_vegan_column_to_food_menus_table', 3);

-- Volcando datos para la tabla food_on_wheels.password_reset_tokens: ~0 rows (aproximadamente)
DELETE FROM `password_reset_tokens`;

-- Volcando datos para la tabla food_on_wheels.personal_access_tokens: ~0 rows (aproximadamente)
DELETE FROM `personal_access_tokens`;

-- Volcando datos para la tabla food_on_wheels.services: ~0 rows (aproximadamente)
DELETE FROM `services`;

-- Volcando datos para la tabla food_on_wheels.sliders: ~0 rows (aproximadamente)
DELETE FROM `sliders`;

-- Volcando datos para la tabla food_on_wheels.testimonials: ~0 rows (aproximadamente)
DELETE FROM `testimonials`;
INSERT INTO `testimonials` (`id`, `name`, `comment`, `status`, `created_at`, `updated_at`) VALUES
	(1, 'Laura', 'Pruebas de comentarios en la pagina', 'public', '2024-08-18 00:58:28', '2024-08-18 00:58:28'),
	(2, 'Mario', 'Prueba', 'public', '2024-08-18 04:33:15', '2024-08-18 04:33:15');

