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

START TRANSACTION;



--
-- Database: `sassolut_jared`
--

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

--
-- Table structure for table `all_special_products`
--

CREATE TABLE `all_special_products` (
  `asp_id` int(11) NOT NULL,
  `specials_category_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `preference_id` text DEFAULT NULL,
  `days_ids` text DEFAULT NULL,
  `start_time` varchar(255) DEFAULT NULL,
  `end_time` varchar(255) DEFAULT NULL,
  `restaurant_id` int(11) NOT NULL DEFAULT 1,
  `special_title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `deal_name` varchar(255) DEFAULT NULL,
  `deals_type` varchar(255) DEFAULT NULL,
  `price_actual` varchar(255) DEFAULT NULL,
  `discount_type` varchar(255) DEFAULT 'None',
  `discount_amount` double NOT NULL,
  `price_after_discount` varchar(255) DEFAULT '0',
  `is_featured` int(11) NOT NULL DEFAULT 0,
  `longtitude` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `date_time` datetime NOT NULL DEFAULT current_timestamp(),
  `verified_by` int(11) NOT NULL DEFAULT 0,
  `visited_by` int(11) NOT NULL DEFAULT 0,
  `verification_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 unapprove, 1 approve, 2 deleted'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `all_special_products`
--

INSERT INTO `all_special_products` (`asp_id`, `specials_category_id`, `role_id`, `user_id`, `preference_id`, `days_ids`, `start_time`, `end_time`, `restaurant_id`, `special_title`, `description`, `deal_name`, `deals_type`, `price_actual`, `discount_type`, `discount_amount`, `price_after_discount`, `is_featured`, `longtitude`, `latitude`, `date_time`, `verified_by`, `visited_by`, `verification_status`) VALUES
(199, 11, 2, 152, '0', '[\"1\"]', '2:57 PM', '3:57 PM', 2, 'Adding new titl', 'Adding new description ', '2', '[]', '100', 'Percentage', 10, '90', 0, '67.0783924', '24.9049938', '2023-06-01 11:58:53', 0, 0, 1),
(200, 11, 1, 131, '0', '[\"1\"]', '5:02 PM', '5:03 PM', 119, 'special drink ', 'enjoy the special drink', 'null', '[]', '12', 'Dollar', 10, '2', 0, '67.0783979', '24.9049325', '2023-06-01 14:04:38', 0, 0, 0),
(201, 12, 1, 131, '1', '[\"1\",\"2\",\"3\"]', '5:04 PM', '5:04 PM', 119, 'asian food spec', 'good asian food', 'null', '[]', '100', 'Dollar', 10, '90', 0, '67.0783977', '24.9049792', '2023-06-01 14:05:37', 0, 0, 0),
(202, 14, 1, 131, '0', '[\"1\",\"2\"]', '5:05 PM', '6:05 PM', 119, 'Happi happi food', 'this is a happy hour food', 'Happi happi food', '[\"Food\"]', '120', 'Dollar', 100, '20', 0, '67.078386', '24.9049359', '2023-06-01 14:06:58', 0, 0, 0),
(203, 19, 1, 131, '2', '[\"1\",\"2\",\"3\"]', '5:09 PM', '5:09 PM', 119, 'dinner burger', 'tasty burger', 'null', '[]', '100', 'Dollar', 80, '20', 0, '67.0783883', '24.9049489', '2023-06-01 14:10:17', 0, 0, 0),
(204, 19, 1, 130, '1', '[\"1\",\"2\"]', '12:39 AM', '12:39 AM', 1, 'Testing special', 'Testing description ', 'null', '[]', '500', 'Dollar', 15, '485', 0, '67.053795', '24.86314', '2023-06-02 21:42:08', 2, 0, 0);

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

--
-- Table structure for table `booked_packages`
--

CREATE TABLE `booked_packages` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `package_name` varchar(200) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `booked_packages`
--

INSERT INTO `booked_packages` (`id`, `user_id`, `package_name`, `created_at`, `update_at`) VALUES
(1, 8, 'Testing Package', '2022-07-02 12:04:55', '2022-07-02 12:04:55'),
(2, 64, 'Testing Package', '2022-08-02 15:50:34', '2022-08-02 15:50:34'),
(3, 117, 'Testing Package', '2022-11-19 14:03:02', '2022-11-19 14:03:02'),
(4, 130, 'Testing Package', '2023-04-28 19:44:40', '2023-04-28 19:44:40'),
(5, 131, 'Testing Package', '2023-05-31 14:39:25', '2023-05-31 14:39:25');

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

--
-- Table structure for table `distance`
--

CREATE TABLE `distance` (
  `id` int(11) NOT NULL,
  `distance` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `distance`
--

INSERT INTO `distance` (`id`, `distance`, `created_at`, `updated_at`) VALUES
(1, 50, '2022-07-01 23:51:35', '2022-07-01 21:51:35');

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

--
-- Table structure for table `favourites`
--

CREATE TABLE `favourites` (
  `fav_Id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `special_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `favourites`
--

INSERT INTO `favourites` (`fav_Id`, `user_id`, `special_id`) VALUES
(104, '130', '103'),
(115, '138', '96'),
(117, '131', '98'),
(122, '144', '118'),
(123, '144', '136'),
(127, '131', '103'),
(128, '131', '94'),
(129, '131', '141');

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

--
-- Table structure for table `list_of_rewards`
--

CREATE TABLE `list_of_rewards` (
  `id` int(11) NOT NULL,
  `tenure` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `list_of_rewards`
--

INSERT INTO `list_of_rewards` (`id`, `tenure`, `description`) VALUES
(1, 'month', '500 points for entering a new deal on 16 different days'),
(2, 'month', '500 points for entering 20 new reataurants'),
(3, 'month', '1000 points for adding a new deal on 25 different days'),
(4, 'month', '500 points for adding 100 new specials'),
(5, 'month', '1000 points for adding 250 new specials'),
(6, 'week', '50 points for adding a new restaurant maximum 3 a days'),
(7, 'week', '10points for adding a new special 10 for each day'),
(8, 'week', '5 points for verifying a special 10 for each day'),
(11, 'week', '5 points for verifying a special 10 for each day'),
(12, 'onetime', '5 points for verifying a special when it gets approved by admin.'),
(13, 'onetime', '10 points for adding a special when it gets approved by admin.');

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

--
-- Table structure for table `new_deal_log_monthly`
--

CREATE TABLE `new_deal_log_monthly` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` varchar(255) NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `new_restraunt_log`
--

CREATE TABLE `new_restraunt_log` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `new_restraunt_log`
--

INSERT INTO `new_restraunt_log` (`id`, `user_id`, `created_at`) VALUES
(54, 131, '2023-05-23');

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

--
-- Table structure for table `new_special_log`
--

CREATE TABLE `new_special_log` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `new_special_log_monthly`
--

CREATE TABLE `new_special_log_monthly` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `packages` (
  `id` int(11) NOT NULL,
  `package_name` varchar(200) NOT NULL,
  `package_price` int(11) DEFAULT NULL,
  `package_description` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `package_name`, `package_price`, `package_description`, `created_at`, `updated_at`) VALUES
(1, 'Testing Package', 1000, 'testing package description', '2022-06-28 16:17:37', '2022-06-28 16:17:37');

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

--
-- Table structure for table `request_redeem`
--

CREATE TABLE `request_redeem` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `points` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'unpaid'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `request_redeem`
--

INSERT INTO `request_redeem` (`id`, `user_id`, `points`, `amount`, `status`) VALUES
(6, 119, '1000', '5', 'paid'),
(8, 119, '1000', '5', 'paid'),
(9, 119, '1900', '10', 'paid'),
(10, 119, '1000', '5', 'paid'),
(15, 119, '1000', '5', 'unpaid'),
(18, 138, '3000', '20', 'paid'),
(19, 138, '6000', '50', 'paid');

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

--
-- Table structure for table `restuarant`
--

CREATE TABLE `restuarant` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `restuarant_name` varchar(200) NOT NULL,
  `restuarant_phone` varchar(200) NOT NULL,
  `restuarant_description` longtext NOT NULL,
  `restuarant_address` varchar(200) NOT NULL,
  `longtitude` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `first_image` longtext DEFAULT NULL,
  `second_image` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `restuarant`
--

INSERT INTO `restuarant` (`id`, `user_id`, `restuarant_name`, `restuarant_phone`, `restuarant_description`, `restuarant_address`, `longtitude`, `latitude`, `first_image`, `second_image`, `created_at`, `updated_at`) VALUES
(1, 130, 'OPTP', '0312225541', 'We serve the best burger that you will crave for.', 'Houston', '67.05270850077407', '24.86438203658687', 'optp.jpg', NULL, '2022-12-10 06:35:27', NULL),
(2, 129, 'Pizza Hut', '03122255410', 'Get your best and delicious pizza', 'Texas', '67.05380261842441', '24.859398186968267', 'pizzahub.png', NULL, '2022-12-10 06:36:13', NULL),
(3, 128, 'Pizza California', '03122255410', 'A best pizza in the twon', 'Texas', '67.05695659441228', '24.855367342995326', 'california.png\n', NULL, '2022-12-10 06:39:05', NULL),
(118, 134, 'Burger King', '3035258193', 'Hello test', 'Houston ', NULL, NULL, NULL, NULL, '2023-04-28 19:29:59', NULL),
(119, 131, 'Tasty Bites', '03112233445566', 'Very Very tasty bites', 'chainsaw chain ', '67.0784007', '24.9049705', NULL, NULL, '2023-05-23 15:45:53', NULL),
(120, 140, 'ABC', '4654654654', 'Testing', 'test', '67.05270850077407', '24.86438203658687', NULL, NULL, '2023-05-26 13:39:40', NULL);

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

--
-- Table structure for table `restuarant_images`
--

CREATE TABLE `restuarant_images` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `restuarant_id` bigint(20) NOT NULL,
  `restuarant_image` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `restuarant_images`
--

INSERT INTO `restuarant_images` (`id`, `user_id`, `restuarant_id`, `restuarant_image`, `created_at`, `updated_at`) VALUES
(28, 92, 14, 'rn_image_picker_lib_temp_d231feb3-cc28-4d10-9019-96685952d72f.jpg', '2022-08-15 12:09:49', NULL),
(29, 92, 14, 'rn_image_picker_lib_temp_d6938a01-e647-49f6-bc3c-dac4dfa29ec4.jpg', '2022-08-15 12:09:49', NULL),
(30, 92, 14, 'rn_image_picker_lib_temp_d61e97bb-7159-4715-a3af-f2496d6d2aa7.jpg', '2022-08-15 12:09:53', NULL),
(31, 96, 15, 'rn_image_picker_lib_temp_f4847488-2bf3-4054-a868-2b2e484ea8de.jpg', '2022-08-19 07:38:23', NULL),
(32, 96, 15, 'rn_image_picker_lib_temp_92283140-bbdb-4af8-8525-aef264d31305.jpg', '2022-08-19 07:38:23', NULL),
(33, 96, 15, 'rn_image_picker_lib_temp_73d57e82-0473-439a-a3f0-c0bd1fb4b311.jpg', '2022-08-19 07:38:23', NULL),
(34, 102, 16, 'rn_image_picker_lib_temp_0550a00d-03a8-49c7-9cba-cfab644baefd.jpg', '2022-08-19 15:50:17', NULL),
(35, 102, 16, 'rn_image_picker_lib_temp_575895d7-46af-4cea-9228-a21a7ad53783.jpg', '2022-08-19 15:50:17', NULL),
(36, 102, 16, 'rn_image_picker_lib_temp_8c32eb38-533c-4633-8d74-9788975ff0b7.jpg', '2022-08-19 15:50:17', NULL),
(37, 117, 17, 'rn_image_picker_lib_temp_6a771e61-1e89-417a-8635-5591bab1a847.jpg', '2022-09-12 16:13:41', NULL),
(38, 117, 17, 'rn_image_picker_lib_temp_543dd75c-61bf-40a7-a9ae-219e673ac4c1.jpg', '2022-09-12 16:13:41', NULL),
(39, 117, 17, 'rn_image_picker_lib_temp_00841e86-c2c2-4c56-8583-c0bff5e7ccb0.jpg', '2022-09-12 16:13:41', NULL),
(40, 117, 18, 'rn_image_picker_lib_temp_23277791-d8f2-4f18-9c64-ab35831be672.jpg', '2022-09-15 16:24:32', NULL),
(43, 121, 115, 'rn_image_picker_lib_temp_3781fca3-9f6b-4597-b1a4-28edd0d22934.jpg', '2022-12-10 08:27:29', NULL),
(44, 121, 115, 'rn_image_picker_lib_temp_8689569c-c766-4f5c-85d5-8550817de60e.jpg', '2022-12-10 08:27:33', NULL),
(45, 121, 115, 'rn_image_picker_lib_temp_08fb8bc2-57d5-44ac-9347-f4f442f6b62e.jpg', '2022-12-10 08:27:33', NULL),
(46, 134, 118, '275636761_128246866432236_5283308750165330249_n.jpg', '2023-04-28 19:29:59', NULL),
(47, 131, 0, 'rn_image_picker_lib_temp_7d9ef22e-f978-44b9-8225-30f6ca9610c5.jpg', '2023-05-23 15:45:53', NULL),
(48, 131, 0, 'rn_image_picker_lib_temp_012aba26-6765-495e-9837-8e132ad1e9ed.jpg', '2023-05-23 15:45:54', NULL),
(49, 131, 0, 'rn_image_picker_lib_temp_0e5a4243-641c-49a9-9bba-510f8ab10efd.jpg', '2023-05-23 15:45:54', NULL);

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

--
-- Table structure for table `rewards_payoffs`
--

CREATE TABLE `rewards_payoffs` (
  `id` int(11) NOT NULL,
  `points` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rewards_payoffs`
--

INSERT INTO `rewards_payoffs` (`id`, `points`, `amount`) VALUES
(1, '1000', '5'),
(2, '1900', '10'),
(3, '3000', '20'),
(4, '6000', '50'),
(5, '8000', '100');

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

--
-- Table structure for table `rules_terms`
--

CREATE TABLE `rules_terms` (
  `id` int(11) NOT NULL,
  `rules` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rules_terms`
--

INSERT INTO `rules_terms` (`id`, `rules`) VALUES
(1, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.'),
(2, 'Lorem Ipsum has been the industrys standard dummy text ever since the 1500s'),
(3, 'When an unknown printer took a galley of type and scrambled it to make a type specimen book.'),
(4, 'It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged.'),
(5, ' It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.');

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

--
-- Table structure for table `specials`
--

CREATE TABLE `specials` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `owner_id` int(11) DEFAULT NULL,
  `restuarant_id` varchar(200) DEFAULT NULL,
  `speciality_title` varchar(200) NOT NULL,
  `special_category` varchar(200) NOT NULL DEFAULT 'category',
  `category_id` int(11) NOT NULL,
  `preference_id` int(11) NOT NULL DEFAULT 0 COMMENT '0 means it will be counted as all',
  `special_description` longtext NOT NULL,
  `special_price` varchar(200) NOT NULL,
  `longitude` varchar(200) NOT NULL,
  `latitude` varchar(200) NOT NULL,
  `verified_by` int(11) DEFAULT 0,
  `visited_by` varchar(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `specials`
--

INSERT INTO `specials` (`id`, `user_id`, `owner_id`, `restuarant_id`, `speciality_title`, `special_category`, `category_id`, `preference_id`, `special_description`, `special_price`, `longitude`, `latitude`, `verified_by`, `visited_by`, `created_at`, `updated_at`) VALUES
(60, 102, 0, NULL, 'Burger ', 'undefined', 0, 0, 'The best burgers offer a combination of tastes', '60', '67.1138483', '24.8290448', 18, '12', '2022-08-19 15:52:07', '2022-08-19 15:52:07'),
(61, 110, 0, '118', 'Pasta', 'Happy Hour', 0, 0, 'Contains eggs and additional water.', '120', '67.1138493', '24.8290428', 5, NULL, '2022-08-19 17:11:43', '2022-08-19 17:11:43'),
(63, 96, 0, NULL, 'Pineapple Juice', 'Drink', 0, 0, 'A hot sandwich made of a patty of chicken in a bun', '70', '67.0532047', '24.9904935', 5, NULL, '2022-08-19 18:46:57', '2022-08-19 18:46:57'),
(64, 96, 0, NULL, 'Have a meal', 'Drink', 0, 0, 'Enjoy the meal', '20', '67.0532011', '24.9904882', 1, NULL, '2022-08-19 20:14:13', '2022-08-19 20:14:13'),
(65, 112, 0, NULL, 'testing meal', 'Drink', 0, 0, 'testing meal description ', '10', '67.0532006', '24.9904905', 0, NULL, '2022-08-19 20:17:45', '2022-08-19 20:17:45'),
(66, 118, 0, NULL, 'Tite', 'undefined', 0, 0, 'Ayan ali', '500', '67.0784169', '24.9049342', 0, NULL, '2022-09-06 07:12:57', '2022-09-06 07:12:57'),
(67, 102, 0, NULL, 'Chicken Burgerzzz', 'Daily', 0, 0, 'The best burgers offer a combination of tastes', '60', '67.1138483', '24.8290448', 18, '11', '2022-08-19 15:52:07', '2022-08-19 15:52:07'),
(68, 119, 0, '19', 'Daily', 'Daily', 0, 0, 'Tilte', '500', '67.0783956', '24.9049134', 0, NULL, '2022-09-06 10:41:54', '2022-09-06 10:41:54'),
(69, 117, 0, NULL, 'Dinner testing ', 'undefined', 0, 0, 'Dinner testing description ', '300', '67.0783761', '24.9049184', 0, NULL, '2022-09-06 10:43:01', '2022-09-06 10:43:01');

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

--
-- Table structure for table `specials_cateogries`
--

CREATE TABLE `specials_cateogries` (
  `id` int(11) NOT NULL,
  `category_name` varchar(200) NOT NULL,
  `category_description` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `specials_cateogries`
--

INSERT INTO `specials_cateogries` (`id`, `category_name`, `category_description`, `created_at`, `updated_at`) VALUES
(11, 'Drink Special', 'This is the description of drink specials.', '2022-07-18 12:05:43', '2022-07-18 12:05:43'),
(12, 'Daily Special', 'This is the description of daily specials.', '2022-07-18 12:05:43', '2022-07-18 12:05:43'),
(14, 'Happy Hour', 'This in our Happy Our Category', '2022-08-11 09:27:47', '2022-08-11 09:27:47'),
(19, 'Dinner Special', 'This in our Dinner Category', '2022-08-11 09:27:47', '2022-08-11 09:27:47'),
(20, 'Lunch Special', 'This in our Dinner Category', '2022-08-11 09:27:47', '2022-08-11 09:27:47'),
(21, 'Breakfast Special', 'This in our Breakfast Category', '2022-08-11 09:27:47', '2022-08-11 09:27:47');

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

--
-- Table structure for table `specials_images`
--

CREATE TABLE `specials_images` (
  `id` int(11) NOT NULL,
  `special_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `special_image` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `specials_images`
--

INSERT INTO `specials_images` (`id`, `special_id`, `user_id`, `special_image`, `created_at`, `updated_at`) VALUES
(176, 94, 131, '202304191240SP.jpg', '2023-04-19 18:12:45', '2023-04-19 18:12:45'),
(177, 94, 131, '202304191240SP.jpg', '2023-04-19 18:12:50', '2023-04-19 18:12:50'),
(178, 94, 131, '202304191240SP.jpg', '2023-04-19 18:12:55', '2023-04-19 18:12:55'),
(179, 95, 131, '202304192052SP_.0.jpg', '2023-04-19 18:20:52', '2023-04-19 18:20:52'),
(180, 96, 131, '202304192128SP_.0.jpg', '2023-04-19 18:21:28', '2023-04-19 18:21:28'),
(181, 97, 131, '202304192236SP_.0.jpg', '2023-04-19 18:22:36', '2023-04-19 18:22:36'),
(182, 98, 131, '202304192319SP_.0.jpg', '2023-04-19 18:23:19', '2023-04-19 18:23:19'),
(183, 99, 131, '202304192425SP_.0.jpg', '2023-04-19 18:24:25', '2023-04-19 18:24:25'),
(184, 100, 131, '202304192530SP_.0.jpg', '2023-04-19 18:25:30', '2023-04-19 18:25:30'),
(185, 101, 131, '202304192534SP_.0.jpg', '2023-04-19 18:25:34', '2023-04-19 18:25:34'),
(186, 102, 131, '202304192756SP_.0.jpg', '2023-04-19 18:27:56', '2023-04-19 18:27:56'),
(187, 103, 131, '202304192934SP_.0.jpg', '2023-04-19 18:29:34', '2023-04-19 18:29:34'),
(188, 104, 133, '202304191807SP_.0.jpg', '2023-04-19 19:18:07', '2023-04-19 19:18:07'),
(189, 104, 133, '202304191807SP_.1.jpg', '2023-04-19 19:18:07', '2023-04-19 19:18:07'),
(190, 104, 133, '202304191807SP_.2.jpg', '2023-04-19 19:18:07', '2023-04-19 19:18:07'),
(191, 105, 133, '202304285920SP_.0.jpg', '2023-04-28 19:59:20', '2023-04-28 19:59:20'),
(192, 105, 133, '202304285920SP_.1.jpg', '2023-04-28 19:59:20', '2023-04-28 19:59:20'),
(193, 105, 133, '202304285920SP_.2.jpg', '2023-04-28 19:59:20', '2023-04-28 19:59:20'),
(194, 106, 131, '202305230626SP_.0.jpg', '2023-05-23 12:06:27', '2023-05-23 12:06:27'),
(195, 106, 131, '202305230627SP_.1.jpg', '2023-05-23 12:06:28', '2023-05-23 12:06:28'),
(196, 106, 131, '202305230628SP_2.png', '2023-05-23 12:06:28', '2023-05-23 12:06:28'),
(197, 107, 131, '202305230758SP_.0.jpg', '2023-05-23 12:07:59', '2023-05-23 12:07:59'),
(198, 107, 131, '202305230759SP_.1.jpg', '2023-05-23 12:08:00', '2023-05-23 12:08:00'),
(199, 107, 131, '202305230800SP_.2.jpg', '2023-05-23 12:08:00', '2023-05-23 12:08:00'),
(200, 108, 131, '202305230839SP_.0.jpg', '2023-05-23 12:08:40', '2023-05-23 12:08:40'),
(201, 108, 131, '202305230840SP_.1.jpg', '2023-05-23 12:08:40', '2023-05-23 12:08:40'),
(202, 108, 131, '202305230840SP_.2.jpg', '2023-05-23 12:08:40', '2023-05-23 12:08:40'),
(203, 109, 131, '202305230859SP_.0.jpg', '2023-05-23 12:09:00', '2023-05-23 12:09:00'),
(204, 109, 131, '202305230900SP_.1.jpg', '2023-05-23 12:09:01', '2023-05-23 12:09:01'),
(205, 109, 131, '202305230901SP_.2.jpg', '2023-05-23 12:09:01', '2023-05-23 12:09:01'),
(206, 110, 131, '202305231114SP_.0.jpg', '2023-05-23 12:11:15', '2023-05-23 12:11:15'),
(207, 110, 131, '202305231115SP_.1.jpg', '2023-05-23 12:11:15', '2023-05-23 12:11:15'),
(208, 110, 131, '202305231115SP_.2.jpg', '2023-05-23 12:11:16', '2023-05-23 12:11:16'),
(209, 111, 131, '202305231210SP_.0.jpg', '2023-05-23 12:12:11', '2023-05-23 12:12:11'),
(210, 111, 131, '202305231211SP_.1.jpg', '2023-05-23 12:12:12', '2023-05-23 12:12:12'),
(211, 111, 131, '202305231212SP_.2.jpg', '2023-05-23 12:12:12', '2023-05-23 12:12:12'),
(212, 112, 131, '202305231213SP_.0.jpg', '2023-05-23 12:12:15', '2023-05-23 12:12:15'),
(213, 112, 131, '202305231215SP_.1.jpg', '2023-05-23 12:12:15', '2023-05-23 12:12:15'),
(214, 112, 131, '202305231215SP_.2.jpg', '2023-05-23 12:12:15', '2023-05-23 12:12:15'),
(215, 113, 131, '202305232003SP_.0.jpg', '2023-05-23 12:20:03', '2023-05-23 12:20:03'),
(216, 113, 131, '202305232003SP_.1.jpg', '2023-05-23 12:20:03', '2023-05-23 12:20:03'),
(217, 113, 131, '202305232003SP_.2.jpg', '2023-05-23 12:20:03', '2023-05-23 12:20:03'),
(218, 114, 131, '202305232153SP_.0.jpg', '2023-05-23 12:21:53', '2023-05-23 12:21:53'),
(219, 114, 131, '202305232153SP_.1.jpg', '2023-05-23 12:21:53', '2023-05-23 12:21:53'),
(220, 114, 131, '202305232153SP_.2.jpg', '2023-05-23 12:21:53', '2023-05-23 12:21:53'),
(221, 115, 131, '202305232254SP_.0.jpg', '2023-05-23 12:22:54', '2023-05-23 12:22:54'),
(222, 115, 131, '202305232254SP_.1.jpg', '2023-05-23 12:22:54', '2023-05-23 12:22:54'),
(223, 115, 131, '202305232254SP_.2.jpg', '2023-05-23 12:22:54', '2023-05-23 12:22:54'),
(224, 116, 131, '202305232341SP_.0.jpg', '2023-05-23 12:23:41', '2023-05-23 12:23:41'),
(225, 116, 131, '202305232341SP_.1.jpg', '2023-05-23 12:23:41', '2023-05-23 12:23:41'),
(226, 116, 131, '202305232341SP_.2.jpg', '2023-05-23 12:23:41', '2023-05-23 12:23:41'),
(227, 117, 131, '202305232358SP_.0.jpg', '2023-05-23 12:23:58', '2023-05-23 12:23:58'),
(228, 117, 131, '202305232358SP_.1.jpg', '2023-05-23 12:23:58', '2023-05-23 12:23:58'),
(229, 117, 131, '202305232358SP_.2.jpg', '2023-05-23 12:23:58', '2023-05-23 12:23:58'),
(230, 118, 131, '202305232627SP_.0.jpg', '2023-05-23 12:26:27', '2023-05-23 12:26:27'),
(231, 118, 131, '202305232627SP_.1.jpg', '2023-05-23 12:26:27', '2023-05-23 12:26:27'),
(232, 118, 131, '202305232627SP_.2.jpg', '2023-05-23 12:26:30', '2023-05-23 12:26:30'),
(233, 119, 131, '202305234737SP_.0.jpg', '2023-05-23 12:47:38', '2023-05-23 12:47:38'),
(234, 119, 131, '202305234738SP_.1.jpg', '2023-05-23 12:47:38', '2023-05-23 12:47:38'),
(235, 119, 131, '202305234738SP_.2.jpg', '2023-05-23 12:47:40', '2023-05-23 12:47:40'),
(236, 120, 136, '202305234134SP_.0.jpg', '2023-05-23 14:41:34', '2023-05-23 14:41:34'),
(237, 120, 136, '202305234134SP_.1.jpg', '2023-05-23 14:41:34', '2023-05-23 14:41:34'),
(238, 120, 136, '202305234134SP_.2.jpg', '2023-05-23 14:41:34', '2023-05-23 14:41:34'),
(239, 121, 136, '202305234328SP_.0.jpg', '2023-05-23 14:43:28', '2023-05-23 14:43:28'),
(240, 121, 136, '202305234328SP_.1.jpg', '2023-05-23 14:43:28', '2023-05-23 14:43:28'),
(241, 121, 136, '202305234328SP_.2.jpg', '2023-05-23 14:43:28', '2023-05-23 14:43:28'),
(242, 122, 136, '202305234417SP_.0.jpg', '2023-05-23 14:44:17', '2023-05-23 14:44:17'),
(243, 122, 136, '202305234417SP_.1.jpg', '2023-05-23 14:44:17', '2023-05-23 14:44:17'),
(244, 122, 136, '202305234417SP_.2.jpg', '2023-05-23 14:44:17', '2023-05-23 14:44:17'),
(245, 123, 136, '202305234512SP_.0.jpg', '2023-05-23 14:45:12', '2023-05-23 14:45:12'),
(246, 123, 136, '202305234512SP_.1.jpg', '2023-05-23 14:45:12', '2023-05-23 14:45:12'),
(247, 123, 136, '202305234512SP_.2.jpg', '2023-05-23 14:45:12', '2023-05-23 14:45:12'),
(248, 124, 136, '202305234935SP_.0.jpg', '2023-05-23 14:49:35', '2023-05-23 14:49:35'),
(249, 124, 136, '202305234935SP_.1.jpg', '2023-05-23 14:49:35', '2023-05-23 14:49:35'),
(250, 124, 136, '202305234935SP_.2.jpg', '2023-05-23 14:49:35', '2023-05-23 14:49:35'),
(251, 125, 136, '202305235001SP_.0.jpg', '2023-05-23 14:50:01', '2023-05-23 14:50:01'),
(252, 125, 136, '202305235001SP_.1.jpg', '2023-05-23 14:50:01', '2023-05-23 14:50:01'),
(253, 125, 136, '202305235001SP_.2.jpg', '2023-05-23 14:50:01', '2023-05-23 14:50:01'),
(254, 126, 136, '202305235036SP_.0.jpg', '2023-05-23 14:50:36', '2023-05-23 14:50:36'),
(255, 126, 136, '202305235036SP_.1.jpg', '2023-05-23 14:50:36', '2023-05-23 14:50:36'),
(256, 126, 136, '202305235036SP_.2.jpg', '2023-05-23 14:50:36', '2023-05-23 14:50:36'),
(257, 127, 136, '202305235055SP_.0.jpg', '2023-05-23 14:50:55', '2023-05-23 14:50:55'),
(258, 127, 136, '202305235055SP_.1.jpg', '2023-05-23 14:50:55', '2023-05-23 14:50:55'),
(259, 127, 136, '202305235055SP_.2.jpg', '2023-05-23 14:50:55', '2023-05-23 14:50:55'),
(260, 128, 136, '202305235114SP_.0.jpg', '2023-05-23 14:51:14', '2023-05-23 14:51:14'),
(261, 128, 136, '202305235114SP_.1.jpg', '2023-05-23 14:51:14', '2023-05-23 14:51:14'),
(262, 128, 136, '202305235114SP_.2.jpg', '2023-05-23 14:51:14', '2023-05-23 14:51:14'),
(263, 129, 136, '202305235141SP_.0.jpg', '2023-05-23 14:51:41', '2023-05-23 14:51:41'),
(264, 129, 136, '202305235141SP_.1.jpg', '2023-05-23 14:51:41', '2023-05-23 14:51:41'),
(265, 129, 136, '202305235141SP_.2.jpg', '2023-05-23 14:51:41', '2023-05-23 14:51:41'),
(266, 130, 136, '202305235210SP_.0.jpg', '2023-05-23 14:52:10', '2023-05-23 14:52:10'),
(267, 130, 136, '202305235210SP_.1.jpg', '2023-05-23 14:52:10', '2023-05-23 14:52:10'),
(268, 130, 136, '202305235210SP_.2.jpg', '2023-05-23 14:52:10', '2023-05-23 14:52:10'),
(269, 131, 136, '202305235228SP_.0.jpg', '2023-05-23 14:52:28', '2023-05-23 14:52:28'),
(270, 131, 136, '202305235228SP_.1.jpg', '2023-05-23 14:52:28', '2023-05-23 14:52:28'),
(271, 131, 136, '202305235228SP_.2.jpg', '2023-05-23 14:52:28', '2023-05-23 14:52:28'),
(272, 132, 138, '202305231923SP_0jpgjpg.jpg', '2023-05-23 16:19:23', '2023-05-23 16:19:23'),
(273, 132, 138, '202305231923SP_1jpgjpgjpgjpgjpg.jpg', '2023-05-23 16:19:23', '2023-05-23 16:19:23'),
(274, 132, 138, '202305231923SP_0.png', '2023-05-23 16:19:23', '2023-05-23 16:19:23'),
(275, 133, 139, '202305270840SP_.0.jpg', '2023-05-27 06:08:43', '2023-05-27 06:08:43'),
(276, 133, 139, '202305270843SP_.1.jpg', '2023-05-27 06:08:46', '2023-05-27 06:08:46'),
(277, 133, 139, '202305270846SP_.2.jpg', '2023-05-27 06:08:49', '2023-05-27 06:08:49'),
(278, 134, 139, '202305271032SP_.0.jpg', '2023-05-27 06:10:35', '2023-05-27 06:10:35'),
(279, 134, 139, '202305271035SP_.1.jpg', '2023-05-27 06:10:38', '2023-05-27 06:10:38'),
(280, 134, 139, '202305271038SP_.2.jpg', '2023-05-27 06:10:41', '2023-05-27 06:10:41'),
(281, 135, 139, '202305271239SP_.0.jpg', '2023-05-27 06:12:42', '2023-05-27 06:12:42'),
(282, 135, 139, '202305271242SP_.1.jpg', '2023-05-27 06:12:45', '2023-05-27 06:12:45'),
(283, 135, 139, '202305271245SP_.2.jpg', '2023-05-27 06:12:48', '2023-05-27 06:12:48'),
(284, 136, 131, '202305273435SP_.0.jpg', '2023-05-27 11:34:35', '2023-05-27 11:34:35'),
(285, 136, 131, '202305273435SP_.1.jpg', '2023-05-27 11:34:35', '2023-05-27 11:34:35'),
(286, 136, 131, '202305273435SP_.2.jpg', '2023-05-27 11:34:35', '2023-05-27 11:34:35'),
(287, 137, 131, '202305295014SP_.0.jpg', '2023-05-29 09:50:16', '2023-05-29 09:50:16'),
(288, 137, 131, '202305295016SP_.1.jpg', '2023-05-29 09:50:17', '2023-05-29 09:50:17'),
(289, 137, 131, '202305295017SP_.2.jpg', '2023-05-29 09:50:19', '2023-05-29 09:50:19'),
(290, 138, 131, '202305304417SP_.0.png', '2023-05-30 09:44:17', '2023-05-30 09:44:17'),
(291, 138, 131, '202305304417SP_.1.png', '2023-05-30 09:44:17', '2023-05-30 09:44:17'),
(292, 138, 131, '202305304417SP_.2.png', '2023-05-30 09:44:17', '2023-05-30 09:44:17'),
(293, 139, 131, '202305304830SP_.0.png', '2023-05-30 09:48:31', '2023-05-30 09:48:31'),
(294, 139, 131, '202305304831SP_.1.png', '2023-05-30 09:48:31', '2023-05-30 09:48:31'),
(295, 139, 131, '202305304831SP_.2.png', '2023-05-30 09:48:31', '2023-05-30 09:48:31'),
(296, 141, 131, 'rn_image_picker_lib_temp_5b453667-2a33-43bf-922c-9ad9573ab219jpg.jpg', '2023-05-30 14:43:04', '2023-05-30 14:43:04'),
(297, 141, 131, 'rn_image_picker_lib_temp_5b453667-2a33-43bf-922c-9ad9573ab219.jpg', '2023-05-30 14:43:04', '2023-05-30 14:43:04'),
(298, 141, 131, 'rn_image_picker_lib_temp_5b453667-2a33-43bf-922c-9ad9573ab219.jpg', '2023-05-30 14:43:05', '2023-05-30 14:43:05'),
(299, 142, 131, '202305304422SP_.0.jpg', '2023-05-30 14:44:22', '2023-05-30 14:44:22'),
(300, 142, 131, '202305304422SP_.1.jpg', '2023-05-30 14:44:22', '2023-05-30 14:44:22'),
(301, 142, 131, '202305304422SP_.2.jpg', '2023-05-30 14:44:22', '2023-05-30 14:44:22'),
(302, 143, 138, '202305303900SP_.0.jpg', '2023-05-30 15:39:00', '2023-05-30 15:39:00'),
(303, 143, 138, '202305303900SP_.1.jpg', '2023-05-30 15:39:00', '2023-05-30 15:39:00'),
(304, 143, 138, '202305303900SP_.2.jpg', '2023-05-30 15:39:00', '2023-05-30 15:39:00'),
(305, 144, 131, '202305304933SP_.0.jpg', '2023-05-30 15:49:33', '2023-05-30 15:49:33'),
(306, 144, 131, '202305304933SP_.1.jpg', '2023-05-30 15:49:33', '2023-05-30 15:49:33'),
(307, 144, 131, '202305304933SP_.2.jpg', '2023-05-30 15:49:33', '2023-05-30 15:49:33'),
(308, 148, 131, '202305301540SP_.0.jpg', '2023-05-30 16:15:40', '2023-05-30 16:15:40'),
(309, 148, 131, '202305301540SP_.1.jpg', '2023-05-30 16:15:43', '2023-05-30 16:15:43'),
(310, 148, 131, '202305301543SP_.2.jpg', '2023-05-30 16:15:43', '2023-05-30 16:15:43'),
(311, 149, 131, '202305301916SP_.0.jpg', '2023-05-30 16:19:16', '2023-05-30 16:19:16'),
(312, 149, 131, '202305301916SP_.1.jpg', '2023-05-30 16:19:16', '2023-05-30 16:19:16'),
(313, 149, 131, '202305301916SP_.2.jpg', '2023-05-30 16:19:16', '2023-05-30 16:19:16'),
(314, 150, 131, '202305315048SP_.0.jpg', '2023-05-31 10:50:48', '2023-05-31 10:50:48'),
(315, 150, 131, '202305315048SP_.1.jpg', '2023-05-31 10:50:48', '2023-05-31 10:50:48'),
(316, 150, 131, '202305315048SP_.2.jpg', '2023-05-31 10:50:48', '2023-05-31 10:50:48'),
(317, 151, 131, '202305311054SP_.0.jpg', '2023-05-31 14:10:54', '2023-05-31 14:10:54'),
(318, 151, 131, '202305311054SP_.1.jpg', '2023-05-31 14:10:54', '2023-05-31 14:10:54'),
(319, 151, 131, '202305311054SP_.2.jpg', '2023-05-31 14:10:54', '2023-05-31 14:10:54'),
(320, 152, 131, '202305311348SP_.0.jpg', '2023-05-31 14:13:48', '2023-05-31 14:13:48'),
(321, 152, 131, '202305311348SP_.1.jpg', '2023-05-31 14:13:48', '2023-05-31 14:13:48'),
(322, 152, 131, '202305311348SP_.2.jpg', '2023-05-31 14:13:48', '2023-05-31 14:13:48'),
(323, 153, 131, '202305313852SP_.0.jpg', '2023-05-31 14:38:52', '2023-05-31 14:38:52'),
(324, 153, 131, '202305313852SP_.1.jpg', '2023-05-31 14:38:53', '2023-05-31 14:38:53'),
(325, 153, 131, '202305313853SP_.2.jpg', '2023-05-31 14:38:54', '2023-05-31 14:38:54'),
(326, 154, 131, '202305314625SP_.0.jpg', '2023-05-31 14:46:27', '2023-05-31 14:46:27'),
(327, 154, 131, '202305314627SP_.1.jpg', '2023-05-31 14:46:30', '2023-05-31 14:46:30'),
(328, 154, 131, '202305314630SP_.2.jpg', '2023-05-31 14:46:33', '2023-05-31 14:46:33'),
(329, 155, 131, '202305314942SP_.0.jpg', '2023-05-31 14:49:44', '2023-05-31 14:49:44'),
(330, 155, 131, '202305314944SP_.1.jpg', '2023-05-31 14:49:46', '2023-05-31 14:49:46'),
(331, 155, 131, '202305314946SP_.2.jpg', '2023-05-31 14:49:48', '2023-05-31 14:49:48'),
(332, 156, 131, '202305315202SP_.0.jpg', '2023-05-31 14:52:05', '2023-05-31 14:52:05'),
(333, 156, 131, '202305315205SP_.1.jpg', '2023-05-31 14:52:08', '2023-05-31 14:52:08'),
(334, 156, 131, '202305315208SP_.2.jpg', '2023-05-31 14:52:11', '2023-05-31 14:52:11'),
(335, 157, 131, '202305315358SP_.0.jpg', '2023-05-31 14:54:01', '2023-05-31 14:54:01'),
(336, 157, 131, '202305315401SP_.1.jpg', '2023-05-31 14:54:03', '2023-05-31 14:54:03'),
(337, 157, 131, '202305315403SP_.2.jpg', '2023-05-31 14:54:04', '2023-05-31 14:54:04'),
(338, 158, 131, '202305315639SP_.0.jpg', '2023-05-31 14:56:39', '2023-05-31 14:56:39'),
(339, 158, 131, '202305315639SP_.1.jpg', '2023-05-31 14:56:39', '2023-05-31 14:56:39'),
(340, 158, 131, '202305315639SP_.2.jpg', '2023-05-31 14:56:40', '2023-05-31 14:56:40'),
(341, 159, 131, '202305310101SP_.0.jpg', '2023-05-31 15:01:01', '2023-05-31 15:01:01'),
(342, 159, 131, '202305310101SP_.1.jpg', '2023-05-31 15:01:01', '2023-05-31 15:01:01'),
(343, 159, 131, '202305310101SP_.2.jpg', '2023-05-31 15:01:02', '2023-05-31 15:01:02'),
(344, 160, 131, '202305310229SP_.0.jpg', '2023-05-31 15:02:29', '2023-05-31 15:02:29'),
(345, 160, 131, '202305310229SP_.1.jpg', '2023-05-31 15:02:29', '2023-05-31 15:02:29'),
(346, 160, 131, '202305310229SP_.2.jpg', '2023-05-31 15:02:30', '2023-05-31 15:02:30'),
(347, 161, 131, '202305310541SP_.0.jpg', '2023-05-31 15:05:41', '2023-05-31 15:05:41'),
(348, 161, 131, '202305310541SP_.1.jpg', '2023-05-31 15:05:41', '2023-05-31 15:05:41'),
(349, 161, 131, '202305310541SP_.2.jpg', '2023-05-31 15:05:42', '2023-05-31 15:05:42'),
(350, 162, 131, '202305313548SP_.0.jpg', '2023-05-31 15:35:48', '2023-05-31 15:35:48'),
(351, 162, 131, '202305313548SP_.1.jpg', '2023-05-31 15:35:48', '2023-05-31 15:35:48'),
(352, 162, 131, '202305313548SP_.2.jpg', '2023-05-31 15:35:48', '2023-05-31 15:35:48'),
(353, 163, 131, '202305313708SP_.0.jpg', '2023-05-31 15:37:08', '2023-05-31 15:37:08'),
(354, 163, 131, '202305313708SP_.1.jpg', '2023-05-31 15:37:08', '2023-05-31 15:37:08'),
(355, 163, 131, '202305313708SP_.2.jpg', '2023-05-31 15:37:08', '2023-05-31 15:37:08'),
(356, 164, 131, '202306015235SP_.0.jpg', '2023-06-01 04:52:35', '2023-06-01 04:52:35'),
(357, 164, 131, '202306015235SP_.1.jpg', '2023-06-01 04:52:35', '2023-06-01 04:52:35'),
(358, 164, 131, '202306015235SP_.2.jpg', '2023-06-01 04:52:35', '2023-06-01 04:52:35'),
(359, 165, 131, '202306015502SP_.0.jpg', '2023-06-01 04:55:02', '2023-06-01 04:55:02'),
(360, 165, 131, '202306015502SP_.1.jpg', '2023-06-01 04:55:02', '2023-06-01 04:55:02'),
(361, 165, 131, '202306015502SP_.2.jpg', '2023-06-01 04:55:02', '2023-06-01 04:55:02'),
(362, 166, 131, '202306015745SP_.0.jpg', '2023-06-01 04:57:45', '2023-06-01 04:57:45'),
(363, 166, 131, '202306015745SP_.1.jpg', '2023-06-01 04:57:46', '2023-06-01 04:57:46'),
(364, 166, 131, '202306015746SP_.2.jpg', '2023-06-01 04:57:46', '2023-06-01 04:57:46'),
(365, 167, 131, '202306015907SP_.0.jpg', '2023-06-01 04:59:07', '2023-06-01 04:59:07'),
(366, 167, 131, '202306015907SP_.1.jpg', '2023-06-01 04:59:07', '2023-06-01 04:59:07'),
(367, 167, 131, '202306015907SP_.2.jpg', '2023-06-01 04:59:07', '2023-06-01 04:59:07'),
(368, 168, 131, '202306010534SP_.0.jpg', '2023-06-01 05:05:34', '2023-06-01 05:05:34'),
(369, 168, 131, '202306010534SP_.1.jpg', '2023-06-01 05:05:34', '2023-06-01 05:05:34'),
(370, 168, 131, '202306010534SP_.2.jpg', '2023-06-01 05:05:34', '2023-06-01 05:05:34'),
(371, 169, 131, '202306011701SP_.0.jpg', '2023-06-01 05:17:01', '2023-06-01 05:17:01'),
(372, 169, 131, '202306011701SP_.1.jpg', '2023-06-01 05:17:01', '2023-06-01 05:17:01'),
(373, 169, 131, '202306011701SP_.2.jpg', '2023-06-01 05:17:01', '2023-06-01 05:17:01'),
(374, 170, 131, '202306011740SP_.0.jpg', '2023-06-01 05:17:40', '2023-06-01 05:17:40'),
(375, 170, 131, '202306011740SP_.1.jpg', '2023-06-01 05:17:40', '2023-06-01 05:17:40'),
(376, 170, 131, '202306011740SP_.2.jpg', '2023-06-01 05:17:40', '2023-06-01 05:17:40'),
(377, 171, 131, '202306012813SP_.0.jpg', '2023-06-01 05:28:14', '2023-06-01 05:28:14'),
(378, 171, 131, '202306012814SP_.1.jpg', '2023-06-01 05:28:17', '2023-06-01 05:28:17'),
(379, 171, 131, '202306012817SP_.2.jpg', '2023-06-01 05:28:19', '2023-06-01 05:28:19'),
(380, 173, 131, '202306013206SP_.0.jpg', '2023-06-01 09:32:06', '2023-06-01 09:32:06'),
(381, 173, 131, '202306013206SP_.1.jpg', '2023-06-01 09:32:11', '2023-06-01 09:32:11'),
(382, 173, 131, '202306013211SP_.2.jpg', '2023-06-01 09:32:12', '2023-06-01 09:32:12'),
(383, 174, 131, '202306013223SP_.0.jpg', '2023-06-01 09:32:24', '2023-06-01 09:32:24'),
(384, 174, 131, '202306013224SP_.1.jpg', '2023-06-01 09:32:29', '2023-06-01 09:32:29'),
(385, 174, 131, '202306013229SP_.2.jpg', '2023-06-01 09:32:29', '2023-06-01 09:32:29'),
(386, 175, 131, '202306013241SP_.0.jpg', '2023-06-01 09:32:41', '2023-06-01 09:32:41'),
(387, 175, 131, '202306013241SP_.1.jpg', '2023-06-01 09:32:47', '2023-06-01 09:32:47'),
(388, 175, 131, '202306013247SP_.2.jpg', '2023-06-01 09:32:47', '2023-06-01 09:32:47'),
(389, 176, 131, '202306013250SP_.0.jpg', '2023-06-01 09:32:50', '2023-06-01 09:32:50'),
(390, 176, 131, '202306013250SP_.1.jpg', '2023-06-01 09:32:55', '2023-06-01 09:32:55'),
(391, 176, 131, '202306013255SP_.2.jpg', '2023-06-01 09:32:56', '2023-06-01 09:32:56'),
(392, 177, 131, '202306013303SP_.0.jpg', '2023-06-01 09:33:04', '2023-06-01 09:33:04'),
(393, 177, 131, '202306013304SP_.1.jpg', '2023-06-01 09:33:09', '2023-06-01 09:33:09'),
(394, 178, 131, '202306013309SP_.0.jpg', '2023-06-01 09:33:09', '2023-06-01 09:33:09'),
(395, 177, 131, '202306013309SP_.2.jpg', '2023-06-01 09:33:10', '2023-06-01 09:33:10'),
(396, 178, 131, '202306013309SP_.1.jpg', '2023-06-01 09:33:15', '2023-06-01 09:33:15'),
(397, 178, 131, '202306013315SP_.2.jpg', '2023-06-01 09:33:16', '2023-06-01 09:33:16'),
(398, 179, 131, '202306013329SP_.0.jpg', '2023-06-01 09:33:29', '2023-06-01 09:33:29'),
(399, 179, 131, '202306013329SP_.1.jpg', '2023-06-01 09:33:34', '2023-06-01 09:33:34'),
(400, 179, 131, '202306013334SP_.2.jpg', '2023-06-01 09:33:35', '2023-06-01 09:33:35'),
(401, 180, 131, '202306013344SP_.0.jpg', '2023-06-01 09:33:44', '2023-06-01 09:33:44'),
(402, 180, 131, '202306013344SP_.1.jpg', '2023-06-01 09:33:50', '2023-06-01 09:33:50'),
(403, 180, 131, '202306013350SP_.2.jpg', '2023-06-01 09:33:50', '2023-06-01 09:33:50'),
(404, 181, 131, '202306013353SP_.0.jpg', '2023-06-01 09:33:54', '2023-06-01 09:33:54'),
(405, 181, 131, '202306013354SP_.1.jpg', '2023-06-01 09:33:59', '2023-06-01 09:33:59'),
(406, 181, 131, '202306013359SP_.2.jpg', '2023-06-01 09:33:59', '2023-06-01 09:33:59'),
(407, 182, 131, '202306013400SP_.0.jpg', '2023-06-01 09:34:00', '2023-06-01 09:34:00'),
(408, 182, 131, '202306013400SP_.1.jpg', '2023-06-01 09:34:05', '2023-06-01 09:34:05'),
(409, 182, 131, '202306013405SP_.2.jpg', '2023-06-01 09:34:06', '2023-06-01 09:34:06'),
(410, 183, 131, '202306013411SP_.0.jpg', '2023-06-01 09:34:11', '2023-06-01 09:34:11'),
(411, 183, 131, '202306013411SP_.1.jpg', '2023-06-01 09:34:16', '2023-06-01 09:34:16'),
(412, 183, 131, '202306013416SP_.2.jpg', '2023-06-01 09:34:17', '2023-06-01 09:34:17'),
(413, 184, 131, '202306013430SP_.0.jpg', '2023-06-01 09:34:30', '2023-06-01 09:34:30'),
(414, 184, 131, '202306013430SP_.1.jpg', '2023-06-01 09:34:35', '2023-06-01 09:34:35'),
(415, 184, 131, '202306013435SP_.2.jpg', '2023-06-01 09:34:36', '2023-06-01 09:34:36'),
(416, 185, 131, '202306013443SP_.0.jpg', '2023-06-01 09:34:43', '2023-06-01 09:34:43'),
(417, 185, 131, '202306013443SP_.1.jpg', '2023-06-01 09:34:48', '2023-06-01 09:34:48'),
(418, 186, 131, '202306013448SP_.0.jpg', '2023-06-01 09:34:49', '2023-06-01 09:34:49'),
(419, 185, 131, '202306013448SP_.2.jpg', '2023-06-01 09:34:49', '2023-06-01 09:34:49'),
(420, 186, 131, '202306013449SP_.1.jpg', '2023-06-01 09:34:54', '2023-06-01 09:34:54'),
(421, 186, 131, '202306013454SP_.2.jpg', '2023-06-01 09:34:55', '2023-06-01 09:34:55'),
(422, 187, 131, '202306013458SP_.0.jpg', '2023-06-01 09:34:58', '2023-06-01 09:34:58'),
(423, 187, 131, '202306013458SP_.1.jpg', '2023-06-01 09:35:03', '2023-06-01 09:35:03'),
(424, 187, 131, '202306013503SP_.2.jpg', '2023-06-01 09:35:04', '2023-06-01 09:35:04'),
(425, 188, 131, '202306013505SP_.0.jpg', '2023-06-01 09:35:05', '2023-06-01 09:35:05'),
(426, 188, 131, '202306013505SP_.1.jpg', '2023-06-01 09:35:10', '2023-06-01 09:35:10'),
(427, 188, 131, '202306013510SP_.2.jpg', '2023-06-01 09:35:11', '2023-06-01 09:35:11'),
(428, 189, 131, '202306013648SP_.0.jpg', '2023-06-01 09:36:53', '2023-06-01 09:36:53'),
(429, 189, 131, '202306013653SP_.1.jpg', '2023-06-01 09:36:59', '2023-06-01 09:36:59'),
(430, 189, 131, '202306013659SP_.2.jpg', '2023-06-01 09:37:05', '2023-06-01 09:37:05'),
(431, 190, 131, '202306013753SP_.0.jpg', '2023-06-01 09:37:58', '2023-06-01 09:37:58'),
(432, 190, 131, '202306013758SP_.1.jpg', '2023-06-01 09:38:03', '2023-06-01 09:38:03'),
(433, 190, 131, '202306013803SP_.2.jpg', '2023-06-01 09:38:08', '2023-06-01 09:38:08'),
(434, 192, 131, '202306014012SP_.0.jpg', '2023-06-01 09:40:17', '2023-06-01 09:40:17'),
(435, 192, 131, '202306014017SP_.1.jpg', '2023-06-01 09:40:22', '2023-06-01 09:40:22'),
(436, 192, 131, '202306014022SP_.2.jpg', '2023-06-01 09:40:27', '2023-06-01 09:40:27'),
(437, 193, 131, '202306014100SP_.0.jpg', '2023-06-01 09:41:05', '2023-06-01 09:41:05'),
(438, 193, 131, '202306014105SP_.1.jpg', '2023-06-01 09:41:10', '2023-06-01 09:41:10'),
(439, 193, 131, '202306014110SP_.2.jpg', '2023-06-01 09:41:15', '2023-06-01 09:41:15'),
(440, 194, 131, '202306014131SP_.0.jpg', '2023-06-01 09:41:36', '2023-06-01 09:41:36'),
(441, 194, 131, '202306014136SP_.1.jpg', '2023-06-01 09:41:42', '2023-06-01 09:41:42'),
(442, 194, 131, '202306014142SP_.2.jpg', '2023-06-01 09:41:47', '2023-06-01 09:41:47'),
(443, 195, 131, '202306014142SP_.0.jpg', '2023-06-01 09:41:47', '2023-06-01 09:41:47'),
(444, 195, 131, '202306014147SP_.1.jpg', '2023-06-01 09:41:52', '2023-06-01 09:41:52'),
(445, 195, 131, '202306014152SP_.2.jpg', '2023-06-01 09:41:58', '2023-06-01 09:41:58'),
(446, 196, 131, '202306014337SP_.0.jpg', '2023-06-01 09:43:43', '2023-06-01 09:43:43'),
(447, 196, 131, '202306014343SP_.1.jpg', '2023-06-01 09:43:48', '2023-06-01 09:43:48'),
(448, 196, 131, '202306014348SP_.2.jpg', '2023-06-01 09:43:50', '2023-06-01 09:43:50'),
(449, 197, 152, '202306014649SP_.0.jpg', '2023-06-01 09:46:55', '2023-06-01 09:46:55'),
(450, 197, 152, '202306014655SP_.1.jpg', '2023-06-01 09:47:00', '2023-06-01 09:47:00'),
(451, 197, 152, '202306014700SP_.2.jpg', '2023-06-01 09:47:05', '2023-06-01 09:47:05'),
(452, 198, 152, '202306014908SP_.0.jpg', '2023-06-01 09:49:13', '2023-06-01 09:49:13'),
(453, 198, 152, '202306014913SP_.1.jpg', '2023-06-01 09:49:18', '2023-06-01 09:49:18'),
(454, 198, 152, '202306014918SP_.2.jpg', '2023-06-01 09:49:23', '2023-06-01 09:49:23'),
(455, 199, 152, '202306015853SP_.0.jpg', '2023-06-01 09:58:58', '2023-06-01 09:58:58'),
(456, 199, 152, '202306015858SP_.1.jpg', '2023-06-01 09:59:04', '2023-06-01 09:59:04'),
(457, 199, 152, '202306015904SP_.2.jpg', '2023-06-01 09:59:09', '2023-06-01 09:59:09'),
(458, 200, 131, '202306010438SP_.0.jpg', '2023-06-01 12:04:38', '2023-06-01 12:04:38'),
(459, 200, 131, '202306010438SP_.1.jpg', '2023-06-01 12:04:38', '2023-06-01 12:04:38'),
(460, 200, 131, '202306010438SP_.2.jpg', '2023-06-01 12:04:38', '2023-06-01 12:04:38'),
(461, 201, 131, '202306010537SP_.0.jpg', '2023-06-01 12:05:37', '2023-06-01 12:05:37'),
(462, 201, 131, '202306010537SP_.1.jpg', '2023-06-01 12:05:37', '2023-06-01 12:05:37'),
(463, 201, 131, '202306010537SP_.2.jpg', '2023-06-01 12:05:37', '2023-06-01 12:05:37'),
(464, 202, 131, '202306010658SP_.0.jpg', '2023-06-01 12:06:58', '2023-06-01 12:06:58'),
(465, 202, 131, '202306010658SP_.1.jpg', '2023-06-01 12:06:58', '2023-06-01 12:06:58'),
(466, 202, 131, '202306010658SP_.2.jpg', '2023-06-01 12:06:58', '2023-06-01 12:06:58'),
(467, 203, 131, '202306011017SP_.0.jpg', '2023-06-01 12:10:17', '2023-06-01 12:10:17'),
(468, 203, 131, '202306011017SP_.1.jpg', '2023-06-01 12:10:17', '2023-06-01 12:10:17'),
(469, 203, 131, '202306011017SP_.2.jpg', '2023-06-01 12:10:17', '2023-06-01 12:10:17'),
(470, 204, 130, '202306024208SP_.0.jpg', '2023-06-02 19:42:08', '2023-06-02 19:42:08'),
(471, 204, 130, '202306024208SP_.1.jpg', '2023-06-02 19:42:08', '2023-06-02 19:42:08'),
(472, 204, 130, '202306024208SP_.2.jpg', '2023-06-02 19:42:08', '2023-06-02 19:42:08');

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

--
-- Table structure for table `specials_list`
--

CREATE TABLE `specials_list` (
  `sp_id` int(11) NOT NULL,
  `sp_name` varchar(255) NOT NULL,
  `sp_icon` varchar(255) NOT NULL,
  `sp_icon_type` varchar(255) DEFAULT NULL,
  `special_img` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `specials_list`
--

INSERT INTO `specials_list` (`sp_id`, `sp_name`, `sp_icon`, `sp_icon_type`, `special_img`) VALUES
(1, 'Asian', 'food-turkey', 'MaterialCommunityIcons', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcR5vyw4Y6y4R3ZPZdfSbZETuzGcmN_F_aJNNMWpLlnBrMpqrv3QlaN5FU4cB7HrLH90vvI&usqp=CAU'),
(2, 'Burgers', 'hamburger', 'FontAwesome5', 'https://www.unileverfoodsolutions.com.au/dam/global-ufs/mcos/anz/calcmenu/recipe/killer-recipes-update/beef-burger-with-deep-fried-bacon-and-thousand-island-dressing_main-header.jpg'),
(3, 'Indian', 'rice', 'MaterialCommunityIcons', 'https://www.seriouseats.com/thmb/nPKYLQXppu9LIPuzsBGFZyivoOo=/1125x1125/smart/filters:no_upscale()/easy-vegetable-fried-rice-recipe-hero-2-fed2a62b8bce4c51b945d9c24c2edb68.jpg'),
(4, 'Breakfast', 'free-breakfast', 'MaterialIcons', 'https://www.seriouseats.com/thmb/UlF0SaM4h-YvY6qzx43ZjOnISKU=/1500x1125/filters:fill(auto,1)/__opt__aboutcom__coeus__resources__content_migration__serious_eats__seriouseats.com__images__2017__10__20171009-egg-breakfast-recipes-roundup-02-0d06fb82dd8a4b1f89fdd7f562fbcb80.jpg'),
(5, 'Entree', 'pasta', 'MaterialCommunityIcons', 'https://khappa.pk/wp-content/uploads/2018/10/ff1.jpg'),
(6, 'Appetizer', 'food-drumstick', 'MaterialCommunityIcons', NULL),
(7, 'Pizza', 'pizza', 'Ionicons', NULL),
(8, 'Mexican', 'food-steak', 'MaterialCommunityIcons', NULL),
(9, 'Fastfood', 'fastfood', 'MaterialIcons', NULL),
(10, 'Seafood', 'fish', 'FontAwesome5', NULL),
(11, 'Sandwiches', 'food-takeout-box', 'MaterialCommunityIcons', NULL),
(12, 'Salad', 'leaf', 'Ionicons', NULL),
(13, 'Desserts', 'pie-chart', 'FontAwesome', NULL),
(14, 'American', 'food-hot-dog', 'MaterialCommunityIcons', NULL);

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `transaction_type` varchar(100) NOT NULL COMMENT 'debit or credit',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `total_points` double NOT NULL,
  `reason` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `total_amount`, `transaction_type`, `created_at`, `total_points`, `reason`) VALUES
(7, 119, 5, 'debit', '2023-04-19 11:47:34', 1000, '1000 points has been deducted for redeem request of $5'),
(8, 119, 5, 'credit', '2023-04-19 11:47:36', 10, '10 points have been credited as your special has been approved.'),
(9, 119, 5, 'amount credited', '2023-04-19 11:47:38', 10, 'A $5 voucher has been sent to your provided email account.'),
(10, 133, 10, 'debit', '2023-04-28 20:12:59', 1900, '1900 points has been deducted for redeem request of $10'),
(11, 119, 5, 'credit', '2023-04-19 11:47:36', 10, '10 points have been credited as your special has been approved.'),
(12, 131, 5, 'credit', '2023-05-27 09:55:57', 10, '10 points have been credited as your special has been approved.'),
(13, 131, 5, 'credit', '2023-05-27 09:56:14', 10, '10 points have been credited as your special has been approved.'),
(14, 138, 5, 'credit', '2023-05-29 11:59:14', 10, '10 points have been credited as your special has been approved.'),
(15, 138, 0, 'credit', '2023-05-29 11:59:17', 5, '10 points have been credited as your special has been approved.'),
(16, 138, 0, 'credit', '2023-05-29 12:00:09', 5, '10 points have been credited as your special has been approved.'),
(17, 138, 0, 'credit', '2023-05-29 12:06:41', 5, '10 points have been credited as your special has been approved.'),
(18, 138, 0, 'credit', '2023-05-29 12:09:41', 5, '10 points have been credited as your special has been approved.'),
(19, 138, 0, 'credit', '2023-05-29 12:09:58', 5, '10 points have been credited as your special has been approved.'),
(20, 138, 0, 'credit', '2023-05-29 12:10:04', 5, '10 points have been credited as your special has been approved.'),
(21, 138, 0, 'credit', '2023-05-29 12:16:16', 5, '10 points have been credited as your special has been approved.'),
(22, 138, 0, 'credit', '2023-05-29 12:17:01', 5, '10 points have been credited as your special has been approved.'),
(23, 131, 0, 'credit', '2023-05-29 12:21:45', 10, '10 points has been credited as your special has been approved.'),
(24, 133, 0, 'credit', '2023-05-29 12:22:40', 10, '10 points has been credited as your special has been approved.'),
(25, 131, 0, 'credit', '2023-05-29 12:22:43', 10, '10 points has been credited as your special has been approved.'),
(26, 131, 0, 'credit', '2023-05-29 12:27:08', 5, '5 points has been credited as your special has been approved.'),
(27, 131, 0, 'credit', '2023-05-29 12:29:45', 5, '5 points has been credited as your special has been approved.'),
(28, 131, 0, 'credit', '2023-05-29 12:30:08', 5, '5 points has been credited as your special has been approved.'),
(29, 131, 0, 'credit', '2023-05-29 12:30:28', 5, '5 points has been credited as your special has been approved.'),
(30, 131, 0, 'credit', '2023-05-29 12:32:33', 5, '5 points has been credited as your special has been approved.'),
(31, 131, 0, 'credit', '2023-05-29 12:33:24', 5, '5 points has been credited as your special has been approved.'),
(32, 131, 0, 'credit', '2023-05-29 12:34:06', 5, '5 points has been credited as your special has been approved.'),
(33, 131, 0, 'credit', '2023-05-29 12:47:45', 10, '10 points has been credited as your special has been approved.'),
(34, 131, 0, 'credit', '2023-05-29 12:47:45', 5, '5 points has been credited as the special you verified is approved.'),
(35, 138, 0, 'credit', '2023-05-29 12:47:45', 5, '5 points has been credited as the special you verified is approved.'),
(36, 131, 0, 'credit', '2023-05-29 12:48:47', 10, '10 points has been credited as your special has been approved.'),
(37, 131, 0, 'credit', '2023-05-29 12:48:47', 5, '5 points has been credited as the special you verified is approved.'),
(38, 138, 0, 'credit', '2023-05-29 12:48:47', 5, '5 points has been credited as the special you verified is approved.'),
(39, 138, 5, 'debit', '2023-05-29 12:55:12', 1000, '1000 points has been deducted for redeem request of $5'),
(40, 138, 20, 'debit', '2023-05-29 12:57:20', 3000, '3000 points has been deducted for redeem request of $20'),
(41, 138, 20, 'credit', '2023-05-29 13:19:30', 0, '$20 voucher has been sent via email.'),
(42, 138, 50, 'debit', '2023-05-29 13:22:42', 6000, '6000 points has been deducted for redeem request of $50'),
(43, 138, 50, 'credit', '2023-05-29 13:22:52', 0, '$50 voucher has been sent via email.'),
(44, 131, 0, 'credit', '2023-05-29 15:01:30', 5, '5 points have been credited as you have visted a restarunt.');

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

--
-- Table structure for table `user_profile`
--

CREATE TABLE `user_profile` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created-at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `verified_specials`
--

CREATE TABLE `verified_specials` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `special_id` int(11) NOT NULL,
  `status` varchar(200) NOT NULL DEFAULT 'verified',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `verified_specials`
--

INSERT INTO `verified_specials` (`id`, `user_id`, `special_id`, `status`, `created_at`, `updated_at`) VALUES
(96, 110, 80, 'verified', '2023-04-19 09:19:41', '2023-04-19 09:19:41'),
(97, 119, 80, 'verified', '2023-04-19 09:22:51', '2023-04-19 09:22:51'),
(98, 131, 105, 'verified', '2023-05-23 09:45:33', '2023-05-23 09:45:33'),
(99, 138, 137, 'verified', '2023-05-29 12:19:28', '2023-05-29 12:19:28'),
(100, 144, 204, 'verified', '2023-06-26 18:30:29', '2023-06-26 18:30:29'),
(101, 154, 204, 'verified', '2023-07-11 01:13:07', '2023-07-11 01:13:07');

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

--
-- Table structure for table `verify_special_log`
--

CREATE TABLE `verify_special_log` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `verify_special_log`
--

INSERT INTO `verify_special_log` (`id`, `user_id`, `created_at`) VALUES
(14, 110, '2023-04-19'),
(15, 119, '2023-04-19'),
(16, 131, '2023-05-23'),
(17, 138, '2023-05-29'),
(18, 144, '2023-06-26'),
(19, 154, '2023-07-11');

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

--
-- Table structure for table `visited_by`
--

CREATE TABLE `visited_by` (
  `id` int(11) NOT NULL,
  `user_id` varchar(200) DEFAULT NULL,
  `special_id` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `visited_by`
--

INSERT INTO `visited_by` (`id`, `user_id`, `special_id`, `created_at`) VALUES
(38, '133', '102', '2023-04-19 18:45:03'),
(39, '130', '103', '2023-04-28 19:32:56'),
(40, '133', '103', '2023-04-28 19:49:23'),
(41, '133', '103', '2023-04-28 20:14:51'),
(42, '131', '102', '2023-05-23 09:43:59'),
(43, '131', '102', '2023-05-23 11:19:46'),
(44, '138', '102', '2023-05-23 16:15:49'),
(45, '138', '102', '2023-05-27 07:47:34'),
(46, '131', '98', '2023-05-27 07:47:36'),
(47, '138', '102', '2023-05-27 07:47:56'),
(48, '131', '94', '2023-05-27 08:48:10'),
(49, '131', '94', '2023-05-27 08:48:23'),
(50, '131', '94', '2023-05-27 08:49:34'),
(51, '131', '94', '2023-05-27 08:49:49'),
(52, '131', '94', '2023-05-27 08:50:12'),
(53, '131', '94', '2023-05-27 08:50:34'),
(54, '131', '94', '2023-05-27 08:50:59'),
(55, '131', '94', '2023-05-27 08:51:14'),
(56, '131', '94', '2023-05-27 08:53:57'),
(57, '131', '94', '2023-05-27 08:54:08'),
(58, '131', '94', '2023-05-27 08:54:17'),
(59, '131', '94', '2023-05-27 09:47:58'),
(60, '131', '94', '2023-05-27 09:48:26'),
(63, '131', '94', '2023-05-27 09:49:46'),
(64, '131', '94', '2023-05-27 09:50:40'),
(65, '131', '94', '2023-05-27 09:51:03'),
(66, '131', '94', '2023-05-27 09:52:14'),
(67, '131', '94', '2023-05-27 09:52:39'),
(68, '131', '94', '2023-05-27 09:53:14'),
(69, '131', '94', '2023-05-27 09:53:27'),
(70, '131', '94', '2023-05-27 09:53:47'),
(71, '131', '94', '2023-05-27 09:53:58'),
(72, '131', '94', '2023-05-27 09:54:51'),
(73, '131', '94', '2023-05-27 09:55:20'),
(74, '131', '94', '2023-05-27 09:55:34'),
(75, '131', '94', '2023-05-27 09:55:57'),
(76, '131', '94', '2023-05-27 09:56:14'),
(77, '138', '132', '2023-05-29 11:59:14'),
(78, '138', '132', '2023-05-29 11:59:17'),
(79, '138', '132', '2023-05-29 12:00:09'),
(80, '138', '132', '2023-05-29 12:06:41'),
(81, '138', '132', '2023-05-29 12:09:41'),
(82, '138', '132', '2023-05-29 12:09:58'),
(83, '138', '132', '2023-05-29 12:10:04'),
(84, '138', '102', '2023-05-29 12:16:16'),
(85, '138', '103', '2023-05-29 12:17:01'),
(86, '131', '132', '2023-05-29 15:01:30');

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

--
-- Table structure for table `weekdays`
--

CREATE TABLE `weekdays` (
  `w_id` int(11) NOT NULL,
  `w_day` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `weekdays`
--

INSERT INTO `weekdays` (`w_id`, `w_day`) VALUES
(1, 'Monday'),
(2, 'Tuesday'),
(3, 'Wednesday'),
(4, 'Thursday'),
(5, 'Friday'),
(6, 'Saturday'),
(7, 'Sunday');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `all_special_products`
--
ALTER TABLE `all_special_products`
  ADD PRIMARY KEY (`asp_id`);

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

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

--
-- Indexes for table `favourites`
--
ALTER TABLE `favourites`
  ADD PRIMARY KEY (`fav_Id`);

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

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

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

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

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

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

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

--
-- Indexes for table `restuarant`
--
ALTER TABLE `restuarant`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

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

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

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

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

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

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

--
-- Indexes for table `specials_list`
--
ALTER TABLE `specials_list`
  ADD PRIMARY KEY (`sp_id`);

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

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

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

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

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

--
-- Indexes for table `weekdays`
--
ALTER TABLE `weekdays`
  ADD PRIMARY KEY (`w_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `all_special_products`
--
ALTER TABLE `all_special_products`
  MODIFY `asp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=205;

--
-- AUTO_INCREMENT for table `booked_packages`
--
ALTER TABLE `booked_packages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `distance`
--
ALTER TABLE `distance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `favourites`
--
ALTER TABLE `favourites`
  MODIFY `fav_Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT for table `list_of_rewards`
--
ALTER TABLE `list_of_rewards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `new_deal_log_monthly`
--
ALTER TABLE `new_deal_log_monthly`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `new_restraunt_log`
--
ALTER TABLE `new_restraunt_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `new_special_log`
--
ALTER TABLE `new_special_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `new_special_log_monthly`
--
ALTER TABLE `new_special_log_monthly`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=268;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `request_redeem`
--
ALTER TABLE `request_redeem`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `restuarant`
--
ALTER TABLE `restuarant`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121;

--
-- AUTO_INCREMENT for table `restuarant_images`
--
ALTER TABLE `restuarant_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `rewards_payoffs`
--
ALTER TABLE `rewards_payoffs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `rules_terms`
--
ALTER TABLE `rules_terms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `specials`
--
ALTER TABLE `specials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `specials_cateogries`
--
ALTER TABLE `specials_cateogries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `specials_images`
--
ALTER TABLE `specials_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=473;

--
-- AUTO_INCREMENT for table `specials_list`
--
ALTER TABLE `specials_list`
  MODIFY `sp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `user_profile`
--
ALTER TABLE `user_profile`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `verified_specials`
--
ALTER TABLE `verified_specials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;

--
-- AUTO_INCREMENT for table `verify_special_log`
--
ALTER TABLE `verify_special_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `visited_by`
--
ALTER TABLE `visited_by`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

--
-- AUTO_INCREMENT for table `weekdays`
--
ALTER TABLE `weekdays`
  MODIFY `w_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `restuarant`
--
ALTER TABLE `restuarant`
  ADD CONSTRAINT `user_restuarant` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

