

-- restaurant info 


INSERT INTO `restaurant_infos` (`id`, `user_id`, `mobile_country_code`, `mobile`, `whatsapp_number`, `address`, `address_description`, `logo`, `cover`, `latest_status_note`, `status`, `created_at`, `updated_at`  , `city_id`) VALUES
(1, 3, '20', '1067880450', '+971 50 123 4567','https://www.google.com/maps/place/25.276987,55.296249', 'UAE, Dubai', 'default-images/restauran.png', 'default-images/restaurant-cover.jpg', NULL, 'approved', '2025-04-22 08:40:28', '2025-04-22 08:59:36' , 1);


INSERT INTO `restaurant_info_regions` (`id`, `user_id`, `region_id`, `created_at`, `updated_at`) VALUES
(1, 3, 1, NULL, NULL);
-- restaurant info  translates


INSERT INTO `restaurant_info_translates` (`id`, `restaurant_info_id`, `lang`, `description`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 'ar', 'برجر هاوس هو المكان المثالي لعشاق البرجر! نقدملك مجموعة متنوعة من البرجر المحضّر من أجود المكونات وبأطعم وصفات، جو مريح وخدمة سريعة تضمنلك تجربة أكل ولا أروع', 'برجر هاوس', NULL, NULL),
(2, 1, 'en', 'Burger House is the perfect spot for burger lovers! We serve a variety of burgers made from the finest ingredients and delicious recipes, all in a cozy atmosphere with fast and friendly service.', 'Burger House', NULL, NULL);


-- restaurant services

INSERT INTO `restaurant_services` (`id`, `user_id`, `booking_service`, `delivery_service`, `pickup_service`, `booking_period`, `status`, `latest_status_note`, `license`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 1, 1, 60, 'approved', NULL, 'default-images/license.png', '2025-04-22 08:47:29', '2025-04-22 08:59:56');


-- working hours

INSERT INTO `working_hours` (`id`, `user_id`, `status`, `latest_status_note`, `created_at`, `updated_at`) VALUES
(1, 3, 'approved', NULL, '2025-04-22 08:40:59', '2025-04-22 08:59:47');

-- working hours info 

INSERT INTO `working_hour_infos` (`id`, `working_hour_id`, `day`, `is_open`, `start_time`, `end_time`, `created_at`, `updated_at`) VALUES
(1, 1, 'saturday', 1, '12:00:00', '23:00:00', '2025-04-22 08:40:59', '2025-04-22 08:43:41'),
(2, 1, 'sunday', 0, NULL, NULL, '2025-04-22 08:40:59', '2025-04-22 08:43:41'),
(3, 1, 'monday', 1, '11:30:00', '23:30:00', '2025-04-22 08:40:59', '2025-04-22 08:43:41'),
(4, 1, 'tuesday', 1, '11:30:00', '23:30:00', '2025-04-22 08:40:59', '2025-04-22 08:43:41'),
(5, 1, 'wednesday', 1, '11:30:00', '23:30:00', '2025-04-22 08:40:59', '2025-04-22 08:43:41'),
(6, 1, 'thursday', 1, '11:30:00', '23:30:00', '2025-04-22 08:40:59', '2025-04-22 08:43:41'),
(7, 1, 'friday', 1, '11:30:00', '23:30:00', '2025-04-22 08:40:59', '2025-04-22 08:43:41');




-- Tables 
INSERT INTO `restaurant_tables` (`id`, `user_id`, `name`, `individuals`, `is_active`, `created_at`, `updated_at`) VALUES
(2, 3, 'Table 1', 5, 1, '2025-04-22 14:12:41', '2025-04-22 14:12:41'),
(3, 3, 'Table 2', 5, 1, '2025-04-22 14:12:47', '2025-04-22 14:12:47'),
(4, 3, 'Table 3', 8, 1, '2025-04-22 14:12:53', '2025-04-22 14:12:53'),
(5, 3, 'Table 4', 8, 1, '2025-04-22 14:12:57', '2025-04-22 14:12:57');
INSERT INTO `restaurant_tables` (`id`, `user_id`, `name`, `individuals`, `is_active`, `created_at`, `updated_at`) VALUES
(6, 3, 'Table 5', 8, 1, '2025-04-26 14:00:00', '2025-04-26 14:00:00'),
(7, 3, 'Table 6', 8, 1, '2025-04-26 14:00:10', '2025-04-26 14:00:10'),
(8, 3, 'Table 7', 8, 1, '2025-04-26 14:00:20', '2025-04-26 14:00:20'),
(9, 3, 'Table 8', 8, 1, '2025-04-26 14:00:30', '2025-04-26 14:00:30'),
(10, 3, 'Table 9', 8, 1, '2025-04-26 14:00:40', '2025-04-26 14:00:40'),
(11, 3, 'Table 10', 8, 1, '2025-04-26 14:00:50', '2025-04-26 14:00:50'),
(12, 3, 'Table 11', 8, 1, '2025-04-26 14:01:00', '2025-04-26 14:01:00'),
(13, 3, 'Table 12', 8, 1, '2025-04-26 14:01:10', '2025-04-26 14:01:10'),
(14, 3, 'Table 13', 8, 1, '2025-04-26 14:01:20', '2025-04-26 14:01:20'),
(15, 3, 'Table 14', 8, 1, '2025-04-26 14:01:30', '2025-04-26 14:01:30'),
(16, 3, 'Table 15', 8, 1, '2025-04-26 14:01:40', '2025-04-26 14:01:40'),
(17, 3, 'Table 16', 8, 1, '2025-04-26 14:01:50', '2025-04-26 14:01:50'),
(18, 3, 'Table 17', 8, 1, '2025-04-26 14:02:00', '2025-04-26 14:02:00'),
(19, 3, 'Table 18', 8, 1, '2025-04-26 14:02:10', '2025-04-26 14:02:10'),
(20, 3, 'Table 19', 8, 1, '2025-04-26 14:02:20', '2025-04-26 14:02:20'),
(21, 3, 'Table 20', 8, 1, '2025-04-26 14:02:30', '2025-04-26 14:02:30'),
(22, 3, 'Table 21', 8, 1, '2025-04-26 14:02:40', '2025-04-26 14:02:40'),
(23, 3, 'Table 22', 8, 1, '2025-04-26 14:02:50', '2025-04-26 14:02:50'),
(24, 3, 'Table 23', 8, 1, '2025-04-26 14:03:00', '2025-04-26 14:03:00'),
(25, 3, 'Table 24', 8, 1, '2025-04-26 14:03:10', '2025-04-26 14:03:10'),
(26, 3, 'Table 25', 8, 1, '2025-04-26 14:03:20', '2025-04-26 14:03:20'),
(27, 3, 'Table 26', 8, 1, '2025-04-26 14:03:30', '2025-04-26 14:03:30'),
(28, 3, 'Table 27', 8, 1, '2025-04-26 14:03:40', '2025-04-26 14:03:40'),
(29, 3, 'Table 28', 8, 1, '2025-04-26 14:03:50', '2025-04-26 14:03:50'),
(30, 3, 'Table 29', 8, 1, '2025-04-26 14:04:00', '2025-04-26 14:04:00'),
(31, 3, 'Table 30', 8, 1, '2025-04-26 14:04:10', '2025-04-26 14:04:10'),
(32, 3, 'Table 31', 8, 1, '2025-04-26 14:04:20', '2025-04-26 14:04:20'),
(33, 3, 'Table 32', 8, 1, '2025-04-26 14:04:30', '2025-04-26 14:04:30'),
(34, 3, 'Table 33', 8, 1, '2025-04-26 14:04:40', '2025-04-26 14:04:40'),
(35, 3, 'Table 34', 8, 1, '2025-04-26 14:04:50', '2025-04-26 14:04:50'),
(36, 3, 'Table 35', 8, 1, '2025-04-26 14:05:00', '2025-04-26 14:05:00'),
(37, 3, 'Table 36', 8, 1, '2025-04-26 14:05:10', '2025-04-26 14:05:10'),
(38, 3, 'Table 37', 8, 1, '2025-04-26 14:05:20', '2025-04-26 14:05:20'),
(39, 3, 'Table 38', 8, 1, '2025-04-26 14:05:30', '2025-04-26 14:05:30'),
(40, 3, 'Table 39', 8, 1, '2025-04-26 14:05:40', '2025-04-26 14:05:40'),
(41, 3, 'Table 40', 8, 1, '2025-04-26 14:05:50', '2025-04-26 14:05:50'),
(42, 3, 'Table 41', 8, 1, '2025-04-26 14:06:00', '2025-04-26 14:06:00'),
(43, 3, 'Table 42', 8, 1, '2025-04-26 14:06:10', '2025-04-26 14:06:10'),
(44, 3, 'Table 43', 8, 1, '2025-04-26 14:06:20', '2025-04-26 14:06:20'),
(45, 3, 'Table 44', 8, 1, '2025-04-26 14:06:30', '2025-04-26 14:06:30'),
(46, 3, 'Table 45', 8, 1, '2025-04-26 14:06:40', '2025-04-26 14:06:40'),
(47, 3, 'Table 46', 8, 1, '2025-04-26 14:06:50', '2025-04-26 14:06:50'),
(48, 3, 'Table 47', 8, 1, '2025-04-26 14:07:00', '2025-04-26 14:07:00'),
(49, 3, 'Table 48', 8, 1, '2025-04-26 14:07:10', '2025-04-26 14:07:10'),
(50, 3, 'Table 49', 8, 1, '2025-04-26 14:07:20', '2025-04-26 14:07:20'),
(51, 3, 'Table 50', 8, 1, '2025-04-26 14:07:30', '2025-04-26 14:07:30');


-- coupons 

INSERT INTO `coupons` (`id`, `user_id`, `name`, `code`, `start_date`, `end_date`, `number_of_users`, `percentage`, `is_active`, `created_at`, `updated_at`) VALUES
(6, 3, 'Coupon 1', 'CP1', '2025-04-22', '2025-04-25', NULL, 30.00, 1, '2025-04-22 14:14:51', '2025-04-22 14:14:51'),
(7, 3, 'Coupon 2', 'CP2', '2025-04-30', '2025-05-30', 50, 30.00, 1, '2025-04-22 14:15:13', '2025-04-22 14:15:13'),
(8, 3, 'Coupon 3', 'CP3', '2025-04-30', '2025-05-30', 20, 55.00, 1, '2025-04-22 14:15:29', '2025-04-22 14:15:29');

INSERT INTO `coupons` (`id`, `user_id`, `name`, `code`, `start_date`, `end_date`, `number_of_users`, `percentage`, `is_active`, `created_at`, `updated_at`) VALUES
(9, 3, 'Coupon 4', 'CP4', '2025-04-30', '2025-05-30', 15, 10.00, 1, '2025-04-22 14:16:00', '2025-04-22 14:16:00'),
(10, 3, 'Coupon 5', 'CP5', '2025-04-30', '2025-05-30', 25, 20.00, 1, '2025-04-22 14:16:01', '2025-04-22 14:16:01'),
(11, 3, 'Coupon 6', 'CP6', '2025-04-30', '2025-05-30', NULL, 5.00, 1, '2025-04-22 14:16:02', '2025-04-22 14:16:02'),
(12, 3, 'Coupon 7', 'CP7', '2025-04-30', '2025-05-30', 10, 15.00, 1, '2025-04-22 14:16:03', '2025-04-22 14:16:03'),
(13, 3, 'Coupon 8', 'CP8', '2025-04-30', '2025-05-30', 30, 25.00, 1, '2025-04-22 14:16:04', '2025-04-22 14:16:04'),
(14, 3, 'Coupon 9', 'CP9', '2025-04-30', '2025-05-30', NULL, 50.00, 1, '2025-04-22 14:16:05', '2025-04-22 14:16:05'),
(15, 3, 'Coupon 10', 'CP10', '2025-04-30', '2025-05-30', 40, 35.00, 1, '2025-04-22 14:16:06', '2025-04-22 14:16:06'),
(16, 3, 'Coupon 11', 'CP11', '2025-04-30', '2025-05-30', 60, 30.00, 1, '2025-04-22 14:16:07', '2025-04-22 14:16:07'),
(17, 3, 'Coupon 12', 'CP12', '2025-04-30', '2025-05-30', 20, 10.00, 1, '2025-04-22 14:16:08', '2025-04-22 14:16:08'),
(18, 3, 'Coupon 13', 'CP13', '2025-04-30', '2025-05-30', NULL, 15.00, 1, '2025-04-22 14:16:09', '2025-04-22 14:16:09'),
(19, 3, 'Coupon 14', 'CP14', '2025-04-30', '2025-05-30', 50, 45.00, 1, '2025-04-22 14:16:10', '2025-04-22 14:16:10'),
(20, 3, 'Coupon 15', 'CP15', '2025-04-30', '2025-05-30', 30, 25.00, 1, '2025-04-22 14:16:11', '2025-04-22 14:16:11'),
(21, 3, 'Coupon 16', 'CP16', '2025-04-30', '2025-05-30', 35, 35.00, 1, '2025-04-22 14:16:12', '2025-04-22 14:16:12'),
(22, 3, 'Coupon 17', 'CP17', '2025-04-30', '2025-05-30', 20, 40.00, 1, '2025-04-22 14:16:13', '2025-04-22 14:16:13'),
(23, 3, 'Coupon 18', 'CP18', '2025-04-30', '2025-05-30', 10, 50.00, 1, '2025-04-22 14:16:14', '2025-04-22 14:16:14'),
(24, 3, 'Coupon 19', 'CP19', '2025-04-30', '2025-05-30', NULL, 55.00, 1, '2025-04-22 14:16:15', '2025-04-22 14:16:15'),
(25, 3, 'Coupon 20', 'CP20', '2025-04-30', '2025-05-30', 45, 60.00, 1, '2025-04-22 14:16:16', '2025-04-22 14:16:16'),
-- ... تابع بنفس النمط حتى (50, 3, 'Coupon 45', 'CP45', ...)
(26, 3, 'Coupon 21', 'CP21', '2025-04-30', '2025-05-30', 15, 5.00, 1, '2025-04-22 14:16:17', '2025-04-22 14:16:17'),
(27, 3, 'Coupon 22', 'CP22', '2025-04-30', '2025-05-30', 25, 10.00, 1, '2025-04-22 14:16:18', '2025-04-22 14:16:18'),
(28, 3, 'Coupon 23', 'CP23', '2025-04-30', '2025-05-30', 35, 20.00, 1, '2025-04-22 14:16:19', '2025-04-22 14:16:19'),
(29, 3, 'Coupon 24', 'CP24', '2025-04-30', '2025-05-30', 45, 30.00, 1, '2025-04-22 14:16:20', '2025-04-22 14:16:20'),
(30, 3, 'Coupon 25', 'CP25', '2025-04-30', '2025-05-30', NULL, 35.00, 1, '2025-04-22 14:16:21', '2025-04-22 14:16:21'),
(31, 3, 'Coupon 26', 'CP26', '2025-04-30', '2025-05-30', 20, 10.00, 1, '2025-04-22 14:16:22', '2025-04-22 14:16:22'),
(32, 3, 'Coupon 27', 'CP27', '2025-04-30', '2025-05-30', 10, 15.00, 1, '2025-04-22 14:16:23', '2025-04-22 14:16:23'),
(33, 3, 'Coupon 28', 'CP28', '2025-04-30', '2025-05-30', 30, 25.00, 1, '2025-04-22 14:16:24', '2025-04-22 14:16:24'),
(34, 3, 'Coupon 29', 'CP29', '2025-04-30', '2025-05-30', 40, 30.00, 1, '2025-04-22 14:16:25', '2025-04-22 14:16:25'),
(35, 3, 'Coupon 30', 'CP30', '2025-04-30', '2025-05-30', 50, 20.00, 1, '2025-04-22 14:16:26', '2025-04-22 14:16:26');

INSERT INTO `coupons` (`id`, `user_id`, `name`, `code`, `start_date`, `end_date`, `number_of_users`, `percentage`, `is_active`, `created_at`, `updated_at`) VALUES
(36, 3, 'Coupon 31', 'CP31', '2025-04-30', '2025-05-30', 20, 5.00, 1, '2025-04-22 14:16:27', '2025-04-22 14:16:27'),
(37, 3, 'Coupon 32', 'CP32', '2025-04-30', '2025-05-30', NULL, 10.00, 1, '2025-04-22 14:16:28', '2025-04-22 14:16:28'),
(38, 3, 'Coupon 33', 'CP33', '2025-04-30', '2025-05-30', 15, 15.00, 1, '2025-04-22 14:16:29', '2025-04-22 14:16:29'),
(39, 3, 'Coupon 34', 'CP34', '2025-04-30', '2025-05-30', 25, 20.00, 1, '2025-04-22 14:16:30', '2025-04-22 14:16:30'),
(40, 3, 'Coupon 35', 'CP35', '2025-04-30', '2025-05-30', 30, 25.00, 1, '2025-04-22 14:16:31', '2025-04-22 14:16:31'),
(41, 3, 'Coupon 36', 'CP36', '2025-04-30', '2025-05-30', NULL, 30.00, 1, '2025-04-22 14:16:32', '2025-04-22 14:16:32'),
(42, 3, 'Coupon 37', 'CP37', '2025-04-30', '2025-05-30', 10, 35.00, 1, '2025-04-22 14:16:33', '2025-04-22 14:16:33'),
(43, 3, 'Coupon 38', 'CP38', '2025-04-30', '2025-05-30', 20, 40.00, 1, '2025-04-22 14:16:34', '2025-04-22 14:16:34'),
(44, 3, 'Coupon 39', 'CP39', '2025-04-30', '2025-05-30', 35, 45.00, 1, '2025-04-22 14:16:35', '2025-04-22 14:16:35'),
(45, 3, 'Coupon 40', 'CP40', '2025-04-30', '2025-05-30', 50, 50.00, 1, '2025-04-22 14:16:36', '2025-04-22 14:16:36'),
(46, 3, 'Coupon 41', 'CP41', '2025-04-30', '2025-05-30', 60, 55.00, 1, '2025-04-22 14:16:37', '2025-04-22 14:16:37'),
(47, 3, 'Coupon 42', 'CP42', '2025-04-30', '2025-05-30', NULL, 60.00, 1, '2025-04-22 14:16:38', '2025-04-22 14:16:38'),
(48, 3, 'Coupon 43', 'CP43', '2025-04-30', '2025-05-30', 40, 20.00, 1, '2025-04-22 14:16:39', '2025-04-22 14:16:39'),
(49, 3, 'Coupon 44', 'CP44', '2025-04-30', '2025-05-30', 30, 15.00, 1, '2025-04-22 14:16:40', '2025-04-22 14:16:40'),
(50, 3, 'Coupon 45', 'CP45', '2025-04-30', '2025-05-30', 25, 10.00, 1, '2025-04-22 14:16:41', '2025-04-22 14:16:41'),
(51, 3, 'Coupon 46', 'CP46', '2025-04-30', '2025-05-30', 15, 5.00, 1, '2025-04-22 14:16:42', '2025-04-22 14:16:42'),
(52, 3, 'Coupon 47', 'CP47', '2025-04-30', '2025-05-30', 20, 35.00, 1, '2025-04-22 14:16:43', '2025-04-22 14:16:43'),
(53, 3, 'Coupon 48', 'CP48', '2025-04-30', '2025-05-30', 10, 25.00, 1, '2025-04-22 14:16:44', '2025-04-22 14:16:44'),
(54, 3, 'Coupon 49', 'CP49', '2025-04-30', '2025-05-30', NULL, 20.00, 1, '2025-04-22 14:16:45', '2025-04-22 14:16:45'),
(55, 3, 'Coupon 50', 'CP50', '2025-04-30', '2025-05-30', 30, 15.00, 1, '2025-04-22 14:16:46', '2025-04-22 14:16:46');




-- delivery fees
INSERT INTO `restaurant_cities` (`id`, `user_id`, `city_id`, `created_at`, `updated_at`) VALUES
(1, 3, 1, '2025-04-22 14:17:55', '2025-04-22 14:17:55'),
(2, 3, 2, '2025-04-22 14:18:12', '2025-04-22 14:18:12');


INSERT INTO `delivery_fees` (`id`, `user_id`, `restaurant_city_id`, `region_id`, `amount`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 1, 90.00, NULL, NULL),
(2, 3, 1, 2, 120.00, NULL, NULL),
(3, 3, 2, 9, 30.00, NULL, NULL),
(4, 3, 2, 10, 50.00, NULL, NULL);














-- restaurant accountants

INSERT INTO `restaurant_accountants` (`id`, `user_id`, `amount`, `transaction_date`, `created_at`, `updated_at` , `created_by`) VALUES
(1, 3, 51.5, '2025-04-25', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(2, 3, 53.0, '2025-04-24', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(3, 3, 54.5, '2025-04-23', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(4, 3, 56.0, '2025-04-22', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(5, 3, 57.5, '2025-04-21', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(6, 3, 59.0, '2025-04-20', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(7, 3, 60.5, '2025-04-19', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(8, 3, 62.0, '2025-04-18', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(9, 3, 63.5, '2025-04-17', '2025-04-26 00:00:00', '2025-04-26 00:00:00'  , 1),
(10, 3, 65.0, '2025-04-16', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(11, 3, 66.5, '2025-04-15', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(12, 3, 68.0, '2025-04-14', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(13, 3, 69.5, '2025-04-13', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(14, 3, 71.0, '2025-04-12', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(15, 3, 72.5, '2025-04-11', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(16, 3, 74.0, '2025-04-10', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(17, 3, 75.5, '2025-04-09', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(18, 3, 77.0, '2025-04-08', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(19, 3, 78.5, '2025-04-07', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(20, 3, 80.0, '2025-04-06', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(21, 3, 81.5, '2025-04-05', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(22, 3, 83.0, '2025-04-04', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(23, 3, 84.5, '2025-04-03', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(24, 3, 86.0, '2025-04-02', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(25, 3, 87.5, '2025-04-01', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(26, 3, 89.0, '2025-03-31', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(27, 3, 90.5, '2025-03-30', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(28, 3, 92.0, '2025-03-29', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(29, 3, 93.5, '2025-03-28', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(30, 3, 95.0, '2025-03-27', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(31, 3, 96.5, '2025-03-26', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(32, 3, 98.0, '2025-03-25', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(33, 3, 99.5, '2025-03-24', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(34, 3, 101.0, '2025-03-23', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(35, 3, 102.5, '2025-03-22', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(36, 3, 104.0, '2025-03-21', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(37, 3, 105.5, '2025-03-20', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(38, 3, 107.0, '2025-03-19', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(39, 3, 108.5, '2025-03-18', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(40, 3, 110.0, '2025-03-17', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(41, 3, 111.5, '2025-03-16', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(42, 3, 113.0, '2025-03-15', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(43, 3, 114.5, '2025-03-14', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(44, 3, 116.0, '2025-03-13', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(45, 3, 117.5, '2025-03-12', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(46, 3, 119.0, '2025-03-11', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(47, 3, 120.5, '2025-03-10', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(48, 3, 122.0, '2025-03-09', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(49, 3, 123.5, '2025-03-08', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1),
(50, 3, 125.0, '2025-03-07', '2025-04-26 00:00:00', '2025-04-26 00:00:00', 1);




--  restaurant ratings


INSERT INTO `restaurant_ratings` (`id`, `user_id`, `restaurant_id`, `rate`, `comment`, `created_at`, `updated_at`) VALUES
(1, 4, 3, 5, 'Amazing food and friendly staff!', '2025-03-15 14:23:45', '2025-03-15 14:23:45'),
(2, 5, 3, 3, 'The service was a bit slow, but the food made up for it.', '2025-02-10 11:12:30', '2025-02-10 11:12:30'),
(3, 6, 3, 4, 'Best restaurant experience I have had in a while.', '2025-03-01 16:45:12', '2025-03-01 16:45:12'),
(4, 7, 3, 2, 'Good atmosphere, but the food was just okay.', '2025-01-25 18:22:05', '2025-01-25 18:22:05'),
(5, 8, 3, 5, 'Absolutely loved the desserts here!', '2025-02-20 13:50:22', '2025-02-20 13:50:22'),
(6, 9, 3, 1, 'Would definitely come back again.', '2025-03-05 09:15:38', '2025-03-05 09:15:38'),
(7, 10, 3, 4, 'The steak was cooked to perfection.', '2025-03-12 15:07:41', '2025-03-12 15:07:41'),
(8, 11, 3, 3, 'Affordable prices and generous portions.', '2025-03-22 10:30:19', '2025-03-22 10:30:19'),
(9, 12, 3, 5, 'The seafood platter was fresh and delicious.', '2025-02-28 19:45:33', '2025-02-28 19:45:33'),
(10, 13, 3, 2, 'Nice place but a bit noisy during peak hours.', '2025-02-12 08:55:10', '2025-02-12 08:55:10'),
(11, 14, 3, 5, 'Loved the pizza here!', '2025-02-05 17:40:00', '2025-02-05 17:40:00'),
(12, 15, 3, 4, 'Delicious meals and cozy environment.', '2025-01-30 12:25:40', '2025-01-30 12:25:40'),
(13, 16, 3, 1, 'Not impressed with the service.', '2025-03-03 10:10:15', '2025-03-03 10:10:15'),
(14, 17, 3, 5, 'Five stars for the chef!', '2025-02-14 20:20:20', '2025-02-14 20:20:20'),
(15, 18, 3, 2, 'Overpriced menu.', '2025-01-20 14:00:00', '2025-01-20 14:00:00'),
(16, 19, 3, 4, 'Warm and inviting space.', '2025-03-10 11:30:00', '2025-03-10 11:30:00'),
(17, 20, 3, 3, 'Friendly waiters.', '2025-02-24 15:15:15', '2025-02-24 15:15:15'),
(18, 21, 3, 5, 'Will definitely recommend to friends.', '2025-03-08 09:09:09', '2025-03-08 09:09:09'),
(19, 22, 3, 2, 'Slow service.', '2025-01-18 18:18:18', '2025-01-18 18:18:18'),
(20, 23, 3, 4, 'Loved the ambiance and design.', '2025-02-27 13:13:13', '2025-02-27 13:13:13'),
(21, 24, 3, 5, 'The best burger I have ever tasted.', '2025-03-04 16:16:16', '2025-03-04 16:16:16'),
(22, 25, 3, 3, 'Nice location.', '2025-02-06 10:10:10', '2025-02-06 10:10:10'),
(23, 26, 3, 4, 'Cozy and friendly.', '2025-03-02 12:12:12', '2025-03-02 12:12:12'),
(24, 27, 3, 1, 'Not coming again.', '2025-01-29 19:19:19', '2025-01-29 19:19:19'),
(25, 28, 3, 5, 'Wonderful experience overall.', '2025-03-13 11:11:11', '2025-03-13 11:11:11'),
(26, 29, 3, 4, 'Good selection of wines.', '2025-02-18 14:14:14', '2025-02-18 14:14:14'),
(27, 30, 3, 2, 'Disappointing desserts.', '2025-01-27 15:15:15', '2025-01-27 15:15:15'),
(28, 31, 3, 5, 'Everything was perfect!', '2025-02-16 12:12:12', '2025-02-16 12:12:12'),
(29, 32, 3, 4, 'The pasta was incredible.', '2025-03-11 18:18:18', '2025-03-11 18:18:18'),
(30, 33, 3, 3, 'Decent place for families.', '2025-01-31 16:16:16', '2025-01-31 16:16:16'),
(31, 34, 3, 2, 'Not worth the hype.', '2025-02-09 10:10:10', '2025-02-09 10:10:10'),
(32, 35, 3, 5, 'Fantastic cocktails.', '2025-03-07 19:19:19', '2025-03-07 19:19:19'),
(33, 36, 3, 3, 'Could improve the lighting.', '2025-02-04 17:17:17', '2025-02-04 17:17:17'),
(34, 37, 3, 4, 'Very professional service.', '2025-02-11 11:11:11', '2025-02-11 11:11:11'),
(35, 38, 3, 5, 'Highly recommended.', '2025-03-09 13:13:13', '2025-03-09 13:13:13'),
(36, 39, 3, 2, 'Overpriced drinks.', '2025-02-17 20:20:20', '2025-02-17 20:20:20'),
(37, 40, 3, 3, 'Tables too close.', '2025-01-26 09:09:09', '2025-01-26 09:09:09'),
(38, 41, 3, 4, 'Good value for money.', '2025-02-13 14:14:14', '2025-02-13 14:14:14'),
(39, 42, 3, 5, 'Perfect for date nights.', '2025-02-19 19:19:19', '2025-02-19 19:19:19'),
(40, 43, 3, 4, 'Lovely interior design.', '2025-03-06 11:11:11', '2025-03-06 11:11:11'),
(41, 44, 3, 3, 'Menu could use more options.', '2025-01-24 15:15:15', '2025-01-24 15:15:15'),
(42, 45, 3, 5, 'Everything tasted amazing!', '2025-03-14 13:13:13', '2025-03-14 13:13:13'),
(43, 46, 3, 2, 'Needs better ventilation.', '2025-01-23 10:10:10', '2025-01-23 10:10:10'),
(44, 47, 3, 4, 'Good service overall.', '2025-02-21 12:12:12', '2025-02-21 12:12:12'),
(45, 48, 3, 5, 'Impressive menu selection.', '2025-02-15 18:18:18', '2025-02-15 18:18:18'),
(46, 49, 3, 3, 'Comfortable seating.', '2025-01-22 11:11:11', '2025-01-22 11:11:11'),
(47, 50, 3, 4, 'Would definitely return!', '2025-02-25 14:14:14', '2025-02-25 14:14:14'),
(48, 51, 3, 5, 'Amazing appetizers.', '2025-02-08 17:17:17', '2025-02-08 17:17:17'),
(49, 52, 3, 2, 'Slow kitchen service.', '2025-01-21 16:16:16', '2025-01-21 16:16:16'),
(50, 53, 3, 5, 'Highly recommend this place!', '2025-02-23 10:10:10', '2025-02-23 10:10:10');






-- add_ons
INSERT INTO `add_ons` (`id`, `user_id`, `price`, `created_at`, `updated_at`) VALUES
(1, 3, 5.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(2, 3, 7.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(3, 3, 10.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(4, 3, 4.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(5, 3, 3.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(6, 3, 6.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(7, 3, 8.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(8, 3, 2.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(9, 3, 5.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(10, 3, 4.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(11, 3, 6.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(12, 3, 9.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(13, 3, 3.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(14, 3, 7.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(15, 3, 6.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(16, 3, 8.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(17, 3, 5.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(18, 3, 4.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(19, 3, 7.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(20, 3, 3.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(21, 3, 4.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(22, 3, 3.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(23, 3, 6.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(24, 3, 2.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(25, 3, 7.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(26, 3, 5.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(27, 3, 4.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(28, 3, 6.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(29, 3, 3.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(30, 3, 8.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(31, 3, 5.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(32, 3, 7.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(33, 3, 2.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(34, 3, 6.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(35, 3, 4.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(36, 3, 5.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(37, 3, 7.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(38, 3, 3.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(39, 3, 6.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(40, 3, 5.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(41, 3, 2.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(42, 3, 3.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(43, 3, 8.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(44, 3, 6.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(45, 3, 7.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(46, 3, 5.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(47, 3, 4.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(48, 3, 3.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(49, 3, 5.00, '2025-04-26 08:06:26', '2025-04-26 08:06:26'),
(50, 3, 2.50, '2025-04-26 08:06:26', '2025-04-26 08:06:26');


INSERT INTO `add_on_translates` (`id`, `add_on_id`, `lang`, `name`) VALUES
(1, 1, 'ar', 'جبنة إضافية'), (2, 1, 'en', 'Extra Cheese'),
(3, 2, 'ar', 'صلصة حارة'), (4, 2, 'en', 'Hot Sauce'),
(5, 3, 'ar', 'بطاطس مقلية'), (6, 3, 'en', 'French Fries'),
(7, 4, 'ar', 'خبز إضافي'), (8, 4, 'en', 'Extra Bread'),
(9, 5, 'ar', 'مشروب غازي'), (10, 5, 'en', 'Soft Drink'),
(11, 6, 'ar', 'مياه معدنية'), (12, 6, 'en', 'Mineral Water'),
(13, 7, 'ar', 'سلطة جانبية'), (14, 7, 'en', 'Side Salad'),
(15, 8, 'ar', 'صلصة باربكيو'), (16, 8, 'en', 'BBQ Sauce'),
(17, 9, 'ar', 'إضافة لحم'), (18, 9, 'en', 'Extra Meat'),
(19, 10, 'ar', 'جبنة شيدر'), (20, 10, 'en', 'Cheddar Cheese'),
(21, 11, 'ar', 'خبز بالثوم'), (22, 11, 'en', 'Garlic Bread'),
(23, 12, 'ar', 'وجبة أطفال'), (24, 12, 'en', 'Kids Meal'),
(25, 13, 'ar', 'صوص رانش'), (26, 13, 'en', 'Ranch Sauce'),
(27, 14, 'ar', 'مشروب طاقة'), (28, 14, 'en', 'Energy Drink'),
(29, 15, 'ar', 'حلقات بصل'), (30, 15, 'en', 'Onion Rings'),
(31, 16, 'ar', 'عصير فريش'), (32, 16, 'en', 'Fresh Juice'),
(33, 17, 'ar', 'جبنة موزاريلا'), (34, 17, 'en', 'Mozzarella Cheese'),
(35, 18, 'ar', 'كعكة صغيرة'), (36, 18, 'en', 'Cupcake'),
(37, 19, 'ar', 'آيس كريم'), (38, 19, 'en', 'Ice Cream'),
(39, 20, 'ar', 'صوص كاراميل'), (40, 20, 'en', 'Caramel Sauce'),
(41, 21, 'ar', 'زيتون إضافي'), (42, 21, 'en', 'Extra Olives'),
(43, 22, 'ar', 'هالبينو'), (44, 22, 'en', 'Jalapeños'),
(45, 23, 'ar', 'إضافة خبز توست'), (46, 23, 'en', 'Extra Toast Bread'),
(47, 24, 'ar', 'شرائح لحم بقري'), (48, 24, 'en', 'Beef Slices'),
(49, 25, 'ar', 'بيض مسلوق'), (50, 25, 'en', 'Boiled Egg'),
(51, 26, 'ar', 'جبنة زرقاء'), (52, 26, 'en', 'Blue Cheese'),
(53, 27, 'ar', 'مشروم مشوي'), (54, 27, 'en', 'Grilled Mushrooms'),
(55, 28, 'ar', 'قطع دجاج إضافية'), (56, 28, 'en', 'Extra Chicken Pieces'),
(57, 29, 'ar', 'صوص العسل والخردل'), (58, 29, 'en', 'Honey Mustard Sauce'),
(59, 30, 'ar', 'بطاطس مهروسة'), (60, 30, 'en', 'Mashed Potatoes'),
(61, 31, 'ar', 'خضار مشوي'), (62, 31, 'en', 'Grilled Vegetables'),
(63, 32, 'ar', 'جبنة فيتا'), (64, 32, 'en', 'Feta Cheese'),
(65, 33, 'ar', 'شرائح سلمون'), (66, 33, 'en', 'Salmon Slices'),
(67, 34, 'ar', 'جبنة بارميزان'), (68, 34, 'en', 'Parmesan Cheese'),
(69, 35, 'ar', 'مكعبات لحم ضأن'), (70, 35, 'en', 'Lamb Cubes'),
(71, 36, 'ar', 'صوص زبادي'), (72, 36, 'en', 'Yogurt Sauce'),
(73, 37, 'ar', 'جبنة كريمية'), (74, 37, 'en', 'Cream Cheese'),
(75, 38, 'ar', 'مكسرات مشكلة'), (76, 38, 'en', 'Mixed Nuts'),
(77, 39, 'ar', 'شوكولاتة إضافية'), (78, 39, 'en', 'Extra Chocolate'),
(79, 40, 'ar', 'فواكه طازجة'), (80, 40, 'en', 'Fresh Fruits'),
(81, 41, 'ar', 'مربى الفراولة'), (82, 41, 'en', 'Strawberry Jam'),
(83, 42, 'ar', 'كريمة خفق'), (84, 42, 'en', 'Whipped Cream'),
(85, 43, 'ar', 'صلصة البيتزا'), (86, 43, 'en', 'Pizza Sauce'),
(87, 44, 'ar', 'مخلل مشكل'), (88, 44, 'en', 'Mixed Pickles'),
(89, 45, 'ar', 'رغيف عربي إضافي'), (90, 45, 'en', 'Extra Arabic Bread'),
(91, 46, 'ar', 'ماء جوز الهند'), (92, 46, 'en', 'Coconut Water'),
(93, 47, 'ar', 'ليمون إضافي'), (94, 47, 'en', 'Extra Lemon'),
(95, 48, 'ar', 'حلقات كاليماري'), (96, 48, 'en', 'Calamari Rings'),
(97, 49, 'ar', 'كورن فليكس'), (98, 49, 'en', 'Cornflakes'),
(99, 50, 'ar', 'زبدة فول سوداني'), (100, 50, 'en', 'Peanut Butter');



INSERT INTO `products` (`id`, `user_id`, `price`, `price_before_discount`, `is_active`, `status_approved`, `avg_rate`, `count_rate`) VALUES
(12, 3, 15.00, 18.00, 1, 'waiting', 0.00, 0),
(13, 3, 20.00, NULL, 1, 'approved', 5.00, 1),
(14, 3, 12.50, 14.00, 1, 'rejected', 0.00, 0),
(15, 3, 18.75, 22.00, 1, 'approved', 4.00, 1),
(16, 3, 25.00, 28.00, 1, 'waiting', 0.00, 0),
(17, 3, 9.99, NULL, 1, 'approved', 0.00, 0),
(18, 3, 11.50, 13.00, 1, 'rejected', 0.00, 0),
(19, 3, 30.00, 35.00, 1, 'approved', 0.00, 0),
(20, 3, 16.00, 20.00, 1, 'waiting', 0.00, 0),
(21, 3, 22.00, NULL, 1, 'approved', 0.00, 0);



INSERT INTO `product_rates` (`id`, `product_id`, `user_id`, `rate`, `comment`, `created_at`, `updated_at`) VALUES
(1, 13, 4, 5, 'This meal really stood out! The flavors are well-balanced and the portion size is just right. An excellent experience — definitely worth more than 5 stars 🔥\n\n', '2025-05-13 09:31:55', '2025-05-13 09:31:55'),
(2, 15, 4, 4, 'From the very first bite, I knew I’d come back for this! The quality shows in every detail. Thanks for such a satisfying and well-prepared meal 👌\n\n', '2025-05-13 09:34:27', '2025-05-13 09:34:27');



INSERT INTO `product_translates` (`product_id`, `lang`, `description`, `name`) VALUES
(12, 'ar', 'وجبة الفطور السريعة', 'فطور سريع'),
(12, 'en', 'Quick Breakfast Meal', 'Quick Breakfast'),
(13, 'ar', 'وجبة غداء دسمة', 'غداء دسم'),
(13, 'en', 'Heavy Lunch Meal', 'Heavy Lunch'),
(14, 'ar', 'سناك عصري', 'سناك عصري'),
(14, 'en', 'Trendy Snack', 'Trendy Snack'),
(15, 'ar', 'وجبة نباتية صحية', 'نباتي صحي'),
(15, 'en', 'Healthy Vegan Meal', 'Vegan Healthy'),
(16, 'ar', 'عشاء فاخر', 'عشاء فاخر'),
(16, 'en', 'Luxury Dinner', 'Luxury Dinner'),
(17, 'ar', 'سندوتش دجاج مشوي', 'دجاج مشوي'),
(17, 'en', 'Grilled Chicken Sandwich', 'Grilled Chicken'),
(18, 'ar', 'وجبة أطفال مميزة', 'وجبة أطفال'),
(18, 'en', 'Special Kids Meal', 'Kids Meal'),
(19, 'ar', 'وجبة دايت خفيفة', 'دايت خفيف'),
(19, 'en', 'Light Diet Meal', 'Light Diet'),
(20, 'ar', 'بيتزا مارجريتا', 'بيتزا مارجريتا'),
(20, 'en', 'Margherita Pizza', 'Margherita Pizza'),
(21, 'ar', 'مكرونة بالجبنة', 'مكرونة جبنة'),
(21, 'en', 'Mac and Cheese', 'Mac and Cheese');

INSERT INTO `product_add_ons` (`product_id`, `add_on_id`) VALUES
(12, 5),
(13, 12),
(14, 7),
(15, 20),
(16, 3),
(17, 18),
(18, 9),
(19, 25),
(20, 14),
(21, 30);

INSERT INTO `product_categories` (`product_id`, `category_id`) VALUES
(12, 3),
(13, 7),
(14, 2),
(15, 5),
(16, 1),
(17, 8),
(18, 4),
(19, 6),
(20, 9),
(21, 10);




INSERT INTO `products` (`id`, `user_id`, `price`, `price_before_discount`, `is_active`, `status_approved`, `avg_rate`, `count_rate`) VALUES
(22, 3, 18.00, 22.00, 1, 'waiting', 0.00, 0),
(23, 3, 25.00, 30.00, 1, 'approved', 0.00, 0),
(24, 3, 14.00, NULL, 1, 'rejected', 0.00, 0),
(25, 3, 16.00, 19.00, 1, 'approved', 0.00, 0),
(26, 3, 21.00, 25.00, 1, 'waiting', 0.00, 0),
(27, 3, 17.00, NULL, 1, 'approved', 0.00, 0),
(28, 3, 19.50, 23.00, 1, 'rejected', 0.00, 0),
(29, 3, 12.00, 15.00, 1, 'approved', 0.00, 0),
(30, 3, 27.00, 32.00, 1, 'waiting', 0.00, 0),
(31, 3, 15.00, NULL, 1, 'approved', 0.00, 0),
(32, 3, 18.00, 20.00, 1, 'rejected', 0.00, 0),
(33, 3, 22.00, 26.00, 1, 'approved', 0.00, 0),
(34, 3, 13.50, NULL, 1, 'waiting', 0.00, 0),
(35, 3, 26.00, 30.00, 1, 'approved', 0.00, 0),
(36, 3, 24.00, 28.00, 1, 'rejected', 0.00, 0),
(37, 3, 10.00, 13.00, 1, 'approved', 0.00, 0),
(38, 3, 11.00, NULL, 1, 'waiting', 0.00, 0),
(39, 3, 23.00, 27.00, 1, 'approved', 0.00, 0),
(40, 3, 29.00, 35.00, 1, 'rejected', 0.00, 0),
(41, 3, 14.50, 17.00, 1, 'approved', 0.00, 0),
(42, 3, 21.00, NULL, 1, 'waiting', 0.00, 0),
(43, 3, 19.00, 22.00, 1, 'approved', 0.00, 0),
(44, 3, 17.50, 20.00, 1, 'rejected', 0.00, 0),
(45, 3, 12.50, 15.00, 1, 'approved', 0.00, 0),
(46, 3, 16.00, NULL, 1, 'waiting', 0.00, 0),
(47, 3, 20.00, 24.00, 1, 'approved', 0.00, 0),
(48, 3, 15.50, 18.00, 1, 'rejected', 0.00, 0),
(49, 3, 18.50, 22.00, 1, 'approved', 0.00, 0),
(50, 3, 23.00, 27.00, 1, 'waiting', 0.00, 0),
(51, 3, 13.00, NULL, 1, 'approved', 0.00, 0);




INSERT INTO `product_translates` (`product_id`, `lang`, `description`, `name`) VALUES
(22, 'ar', 'فطيرة جبنة لذيذة', 'فطيرة جبنة'),
(22, 'en', 'Delicious Cheese Pie', 'Cheese Pie'),
(23, 'ar', 'عصير طبيعي منعش', 'عصير طبيعي'),
(23, 'en', 'Refreshing Natural Juice', 'Natural Juice'),
(24, 'ar', 'سلطة خضراء طازجة', 'سلطة خضراء'),
(24, 'en', 'Fresh Green Salad', 'Green Salad'),
(25, 'ar', 'ساندوتش لحم مشوي', 'ساندوتش لحم'),
(25, 'en', 'Grilled Meat Sandwich', 'Grilled Meat'),
(26, 'ar', 'كيك شوكولاتة', 'كيك شوكولاتة'),
(26, 'en', 'Chocolate Cake', 'Chocolate Cake'),
(27, 'ar', 'سمك مشوي مع خضار', 'سمك مشوي'),
(27, 'en', 'Grilled Fish with Vegetables', 'Grilled Fish'),
(28, 'ar', 'شوربة دجاج ساخنة', 'شوربة دجاج'),
(28, 'en', 'Hot Chicken Soup', 'Chicken Soup'),
(29, 'ar', 'بطاطس مقلية مقرمشة', 'بطاطس مقلية'),
(29, 'en', 'Crispy French Fries', 'French Fries'),
(30, 'ar', 'مشروب غازي منعش', 'مشروب غازي'),
(30, 'en', 'Refreshing Soft Drink', 'Soft Drink'),
(31, 'ar', 'بيتزا مارجريتا', 'بيتزا مارجريتا'),
(31, 'en', 'Margherita Pizza', 'Margherita Pizza'),
(32, 'ar', 'برجر لحم', 'برجر لحم'),
(32, 'en', 'Beef Burger', 'Beef Burger'),
(33, 'ar', 'نودلز صيني', 'نودلز صيني'),
(33, 'en', 'Chinese Noodles', 'Chinese Noodles'),
(34, 'ar', 'كريب نوتيلا', 'كريب نوتيلا'),
(34, 'en', 'Nutella Crepe', 'Nutella Crepe'),
(35, 'ar', 'وافلز بالعسل', 'وافلز بالعسل'),
(35, 'en', 'Honey Waffles', 'Honey Waffles'),
(36, 'ar', 'مكرونة بالجبنة', 'مكرونة بالجبنة'),
(36, 'en', 'Mac & Cheese', 'Mac & Cheese'),
(37, 'ar', 'أرز باللحم', 'أرز باللحم'),
(37, 'en', 'Meat Rice', 'Meat Rice'),
(38, 'ar', 'سوشي مشكل', 'سوشي مشكل'),
(38, 'en', 'Mixed Sushi', 'Mixed Sushi'),
(39, 'ar', 'فتة مصرية', 'فتة مصرية'),
(39, 'en', 'Egyptian Fatta', 'Egyptian Fatta'),
(40, 'ar', 'سلطة سيزر', 'سلطة سيزر'),
(40, 'en', 'Caesar Salad', 'Caesar Salad'),
(41, 'ar', 'دجاج كنتاكي', 'دجاج كنتاكي'),
(41, 'en', 'KFC Chicken', 'KFC Chicken'),
(42, 'ar', 'عصير مانجو فريش', 'عصير مانجو'),
(42, 'en', 'Fresh Mango Juice', 'Mango Juice'),
(43, 'ar', 'عصير برتقال', 'عصير برتقال'),
(43, 'en', 'Orange Juice', 'Orange Juice'),
(44, 'ar', 'شطيرة تركي مدخن', 'شطيرة تركي'),
(44, 'en', 'Smoked Turkey Sandwich', 'Smoked Turkey'),
(45, 'ar', 'برياني دجاج', 'برياني دجاج'),
(45, 'en', 'Chicken Biryani', 'Chicken Biryani'),
(46, 'ar', 'دونات محلاة', 'دونات'),
(46, 'en', 'Sweet Donut', 'Donut'),
(47, 'ar', 'آيس كريم فانيليا', 'آيس كريم فانيليا'),
(47, 'en', 'Vanilla Ice Cream', 'Vanilla Ice Cream'),
(48, 'ar', 'آيس كريم شوكولاتة', 'آيس كريم شوكولاتة'),
(48, 'en', 'Chocolate Ice Cream', 'Chocolate Ice Cream'),
(49, 'ar', 'حساء عدس', 'شوربة عدس'),
(49, 'en', 'Lentil Soup', 'Lentil Soup'),
(50, 'ar', 'بسبوسة مصرية', 'بسبوسة مصرية'),
(50, 'en', 'Egyptian Basbousa', 'Basbousa'),
(51, 'ar', 'كنافة نابلسية', 'كنافة نابلسية'),
(51, 'en', 'Nabulsi Kunafa', 'Kunafa');



INSERT INTO `product_add_ons` (`product_id`, `add_on_id`) VALUES
(22, 5), (22, 12),
(23, 7), (23, 15),
(24, 20), (24, 3),
(25, 1), (25, 8),
(26, 9), (26, 17),
(27, 2), (27, 14),
(28, 4), (28, 6),
(29, 11), (29, 18),
(30, 16), (30, 22),
(31, 13), (31, 24),
(32, 21), (32, 19),
(33, 28), (33, 5),
(34, 10), (34, 31),
(35, 12), (35, 2),
(36, 14), (36, 25),
(37, 17), (37, 6),
(38, 30), (38, 11),
(39, 22), (39, 9),
(40, 27), (40, 15),
(41, 26), (41, 4),
(42, 18), (42, 29),
(43, 19), (43, 8),
(44, 23), (44, 20),
(45, 21), (45, 7),
(46, 24), (46, 5),
(47, 3), (47, 13),
(48, 16), (48, 2),
(49, 10), (49, 28),
(50, 6), (50, 18),
(51, 25), (51, 1);


INSERT INTO `product_categories` (`product_id`, `category_id`) VALUES
(22, 1), (22, 4),
(23, 2), (23, 5),
(24, 3), (24, 6),
(25, 7), (25, 8),
(26, 9), (26, 10),
(27, 1), (27, 5),
(28, 2), (28, 6),
(29, 3), (29, 7),
(30, 4), (30, 8),
(31, 5), (31, 9),
(32, 6), (32, 10),
(33, 1), (33, 7),
(34, 2), (34, 8),
(35, 3), (35, 9),
(36, 4), (36, 10),
(37, 5), (37, 1),
(38, 6), (38, 2),
(39, 7), (39, 3),
(40, 8), (40, 4),
(41, 9), (41, 5),
(42, 10), (42, 6),
(43, 1), (43, 7),
(44, 2), (44, 8),
(45, 3), (45, 9),
(46, 4), (46, 10),
(47, 5), (47, 1),
(48, 6), (48, 2),
(49, 7), (49, 3),
(50, 8), (50, 4),
(51, 9), (51, 5);





INSERT INTO `problems` (`id`) VALUES
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(11), (12), (13), (14), (15), (16), (17), (18), (19), (20),
(21), (22), (23), (24), (25), (26), (27), (28), (29), (30);






-- start product show admin panel 


INSERT INTO `products` (`id`, `user_id`, `price`, `price_before_discount`, `image_main`, `is_active`, `status_approved`, `avg_rate`, `count_rate`, `deleted_at`, `created_at`, `updated_at`) VALUES
(52, 3, 125.00, 250, 'upload-test/products/4gdXdTdHbRFrHTSOGDZV1747906530.jpg', 1, 'waiting', 0.00, 0, NULL, '2025-05-22 06:35:30', '2025-05-22 06:35:30');

INSERT INTO `product_translates` (`id`, `product_id`, `lang`, `description`, `name`, `created_at`, `updated_at`) VALUES
(82, 52, 'en', 'Taste the authentic Italian experience with Vesta Pizza — crispy crust, fresh ingredients, and irresistible melted cheese. Available in a variety of flavors to satisfy every craving.', 'Vesta Pizza', NULL, NULL),
(81, 52, 'ar', 'عيش تجربة الطعم الإيطالي الأصيل مع بيتزا فستا، بعجينة هشة ومكونات فريش، وجبنة سايحة هتخطف قلبك من أول قضمة. متوفرة بنكهات متنوعة تناسب كل الأذواق.', 'بيتزا فستا', NULL, NULL);



INSERT INTO `product_images` (`id`, `product_id`, `image`, `created_at`, `updated_at`) VALUES
(1, 52, 'upload-test/products/VkinejWPcjV3VQ3WLZ0Q1747906530.jpg', NULL, NULL),
(2, 52, 'upload-test/products/vimth4sgznK1NH6uMJ3y1747906530.jpg', NULL, NULL),
(3, 52, 'upload-test/products/KN6a6ximklalTQMLccqU1747906530.jpg', NULL, NULL),
(4, 52, 'upload-test/products/6wml0D0jCVEZrLM14ZSm1747906530.jpg', NULL, NULL);


INSERT INTO `product_add_ons` (`id`, `product_id`, `add_on_id`, `created_at`, `updated_at`) VALUES (NULL, '52', '1', NULL, NULL), (NULL, '52', '2', NULL, NULL);

INSERT INTO `product_categories` (`id`, `product_id`, `category_id`, `created_at`, `updated_at`) VALUES (NULL, '52', '2', NULL, NULL), (NULL, '52', '9', NULL, NULL);


INSERT INTO `product_rates` (`id`, `product_id`, `user_id`, `rate`, `comment`, `created_at`, `updated_at`) VALUES
(3, 52, 5, 5, 'البيتزا دي فاقت توقعاتي! العجينة خفيفة والجبنة سايحة بشكل بيخليك تدمنها. هطلبها تاني أكيد 🔥', '2025-05-22 14:20:00', '2025-05-22 14:20:00'),
(4, 52, 6, 4, 'مذاق رائع والمكونات فريش جدًا، بس كنت أتمنى تكون أطرافها مقرمشة أكتر. بشكل عام تجربة ممتازة 👌', '2025-05-22 14:21:00', '2025-05-22 14:21:00'),
(5, 52, 7, 5, 'من أول قطعة وأنا عارف إن دي هتبقى البيتزا المفضلة عندي. الطعم متوازن والصلصة خرافية 😍', '2025-05-22 14:22:00', '2025-05-22 14:22:00'),
(6, 52, 8, 3, 'البيتزا كويسة لكن حسيت إنها كانت محتاجة تتسخن أكتر. المذاق العام جيد، بس في مجال للتحسين.', '2025-05-22 14:23:00', '2025-05-22 14:23:00'),
(7, 52, 9, 4, 'جبنة كتير وطعم ممتاز، بس التوصيل اتأخر شوية. غير كده، كل حاجة كانت تمام 👏', '2025-05-22 14:24:00', '2025-05-22 14:24:00');
