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

START TRANSACTION;



--
-- Database: `restaurants_order_webs`
--

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

--
-- Table structure for table `areas`
--

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

--
-- Dumping data for table `areas`
--

INSERT INTO `areas` (`id`, `city_id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'Abdullah Haroon Road', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(2, 2, 'Abyssinia Lines', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(3, 2, 'Agra Taj Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(4, 2, 'Airport', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(5, 2, 'Aisb', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(6, 2, 'Al-Falah Society', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(7, 2, 'Al-Hilal Society', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(8, 2, 'Amir Khusro Road', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(9, 2, 'Ancholi', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(10, 2, 'Andleeb Jaya', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(11, 2, 'Azam Basti', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(12, 2, 'Baba Bhits', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(13, 2, 'Baghdadi', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(14, 2, 'Bahadurabad', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(15, 2, 'Bahria Town', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(16, 2, 'Baldia Town', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(17, 2, 'Baloch Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(18, 2, 'Banaras Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(19, 2, 'Barkat-e-Hyderi', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(20, 2, 'Bath Island', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(21, 2, 'Bhutta Village', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(22, 2, 'Bihar Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(23, 2, 'Bilal Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(24, 2, 'Bin Qasim Town', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(25, 2, 'Boat Basin', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(26, 2, 'Bombay Bazar', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(27, 2, 'Buffer Zone', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(28, 2, 'Burns Road', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(29, 2, 'Cantt', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(30, 2, 'Central Jacob Lines', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(31, 2, 'Chakiwara', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(32, 2, 'Chanesar Goth', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(33, 2, 'City Railway Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(34, 2, 'Civil Lines', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(35, 2, 'Clifton', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(36, 2, 'Commissioner Society', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(37, 2, 'Cosmopolitan Society', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(38, 2, 'Cotton Exchange', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(39, 2, 'CP Berar Society', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(40, 2, 'Dastagir Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(41, 2, 'Defense Housing Authority', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(42, 2, 'Delhi Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(43, 2, 'DHA City', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(44, 2, 'DHA Phase 1', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(45, 2, 'DHA Phase 2', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(46, 2, 'DHA Phase 4', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(47, 2, 'DHA Phase 5', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(48, 2, 'DHA Phase 6', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(49, 2, 'DHA Phase 7', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(50, 2, 'DHA Phase 8', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(51, 2, 'Dhoraji Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(52, 2, 'Diamond City', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(53, 2, 'Dr. Ziauddin Ahmed Road', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(54, 2, 'Ebrahim Hyderi', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(55, 2, 'Eidgah', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(56, 2, 'Essa Nagri', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(57, 2, 'Federal B Area', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(58, 2, 'Frere Town', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(59, 2, 'Gadap Town', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(60, 2, 'Garden East', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(61, 2, 'Garden West', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(62, 2, 'Gazdarabad', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(63, 2, 'Ghard', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(64, 2, 'Gizri', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(65, 2, 'Godhra', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(66, 2, 'Golimar', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(67, 2, 'Green Town', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(68, 2, 'Gulbahar', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(69, 2, 'Gulberg Town', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(70, 2, 'Gulistan-e-Jauhar', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(71, 2, 'Gulshan-e-Hadeed', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(72, 2, 'Gulshan-e-Iqbal', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(73, 2, 'Gulshan-e-Maymar', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(74, 2, 'Gulshan-e-Sikandar', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(75, 2, 'Gulshan-e-Zia', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(76, 2, 'Gulzar-e-Hijri', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(77, 2, 'Guru Mandir', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(78, 2, 'H. Area', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(79, 2, 'Haji Camp', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(80, 2, 'Haqqani Chowk', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(81, 2, 'Hasrat Mohani Colony', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(82, 2, 'Hawksbay', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(83, 2, 'Hill Park', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(84, 2, 'Hussainabad', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(85, 2, 'I.I. Chundrigar Road', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(86, 2, 'Indus Valley', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(87, 2, 'Islamia College', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(88, 2, 'Ittehad Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(89, 2, 'Jacob Lines', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(90, 2, 'Jamia Millia', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(91, 2, 'Jamshed Quarters', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(92, 2, 'Jamshed Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(93, 2, 'Jamshed Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(94, 2, 'Jinnah Terminal', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(95, 2, 'Jodia Bazar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(96, 2, 'Jut Line', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(97, 2, 'K.A.E.C.H.S', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(98, 2, 'K.D.A Scheme 1', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(99, 2, 'K.D.A Scheme 33', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(100, 2, 'K.M.C.H.S', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(101, 2, 'Karachi Admin Society', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(102, 2, 'Karachi Memon Society', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(103, 2, 'Karachi University', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(104, 2, 'Karimabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(105, 2, 'Keamari', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(106, 2, 'Kehkashan', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(107, 2, 'Kharadar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(108, 2, 'Khayaban-e-Bahria', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(109, 2, 'Khayaban-e-Badar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(110, 2, 'Khayaban-e-Hafiz', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(111, 2, 'Khayaban-e-Ittehad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(112, 2, 'Khayaban-e-Jami', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(113, 2, 'Khayaban-e-Muhafiz', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(114, 2, 'Khayaban-e-Rahat', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(115, 2, 'Khayaban-e-Sahar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(116, 2, 'Khayaban-e-Seher', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(117, 2, 'Khayaban-e-Shamsheer', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(118, 2, 'Khayaban-e-Tanzeem', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(119, 2, 'Khokrapar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(120, 2, 'Khudadad Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(121, 2, 'Korangi', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(122, 2, 'Korangi Creek', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(123, 2, 'Korangi Industrial Area', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(124, 2, 'Landhi', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(125, 2, 'Liaquatabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(126, 2, 'Lines Area', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(127, 2, 'Lyari', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(128, 2, 'M.A. Jinnah Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(129, 2, 'Machar Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(130, 2, 'Madina Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(131, 2, 'Mahmoodabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(132, 2, 'Malir', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(133, 2, 'Malir Cantonment', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(134, 2, 'Malir City', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(135, 2, 'Malir Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(136, 2, 'Manora', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(137, 2, 'Mansoor Nagar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(138, 2, 'Manzoor Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(139, 2, 'Maripur', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(140, 2, 'Martin Quarters', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(141, 2, 'Mauripur', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(142, 2, 'Mehmoodabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(143, 2, 'Memon Goth', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(144, 2, 'Metroville', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(145, 2, 'Mithadar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(146, 2, 'Model Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(147, 2, 'Mohammad Ali Society', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(148, 2, 'Mominabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(149, 2, 'Morio Goth', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(150, 2, 'Muslimabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(151, 2, 'Nanak Wara', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(152, 2, 'Napier Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(153, 2, 'Naya Nazimabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(154, 2, 'Nazimabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(155, 2, 'New Karachi', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(156, 2, 'New Sabzi Mandi', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(157, 2, 'Nishtar Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(158, 2, 'North Karachi', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(159, 2, 'North Nazimabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(160, 2, 'Numaish', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(161, 2, 'Old Clifton', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(162, 2, 'Old Golimar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(163, 2, 'Orangi Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(164, 2, 'P.E.C.H.S', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(165, 2, 'Pakistan Chowk', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(166, 2, 'Paposh Nagar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(167, 2, 'Patel Para', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(168, 2, 'Pehlwan Goth', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(169, 2, 'Pib Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(170, 2, 'Pir Ilahi Buksh Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(171, 2, 'Port Qasim', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(172, 2, 'Punjab Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(173, 2, 'Qasba Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(174, 2, 'Qauidabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(175, 2, 'Qayyumabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(176, 2, 'Ranchore Line', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(177, 2, 'Rashid Minhas Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(178, 2, 'Rehmanabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(179, 2, 'Rizvia Society', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(180, 2, 'Saddar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(181, 2, 'Saadi Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(182, 2, 'Saeedabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(183, 2, 'Sakhi Hassan', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(184, 2, 'Samnabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(185, 2, 'Sandoz Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(186, 2, 'Sarafa Bazar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(187, 2, 'Scheme 33', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(188, 2, 'Shah Faisal Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(189, 2, 'Shah Faisal Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(190, 2, 'Shaheed-e-Millat Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(191, 2, 'Shahra-e-Faisal', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(192, 2, 'Sher Shah', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(193, 2, 'Sindhi Muslim Society', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(194, 2, 'SITE', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(195, 2, 'Soldier Bazar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(196, 2, 'Sohrab Goth', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(197, 2, 'Steel Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(198, 2, 'Surjani Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(199, 2, 'Tariq Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(200, 2, 'Taiser Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(201, 2, 'Timber Market', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(202, 2, 'Tipu Sultan Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(203, 2, 'University Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(204, 2, 'Upper Gizri', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(205, 2, 'West Wharf', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(206, 2, 'Yiaquatabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(207, 2, 'Zaman Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(208, 3, 'Gulberg', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(209, 3, 'DHA', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(210, 3, 'Model Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(211, 3, 'Johar Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(212, 3, 'Cantt', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(213, 3, 'Bahria Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(214, 3, 'Wapda Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(215, 3, 'Garden Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(216, 3, 'Allama Iqbal Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(217, 3, 'Faisal Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(218, 4, 'F-6', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(219, 4, 'F-7', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(220, 4, 'F-8', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(221, 4, 'F-10', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(222, 4, 'F-11', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(223, 4, 'G-6', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(224, 4, 'G-7', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(225, 4, 'G-10', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(226, 4, 'G-11', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(227, 4, 'E-11', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(228, 4, 'Bahria Enclave', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(229, 4, 'DHA', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(230, 5, 'Satellite Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(231, 5, 'Bahria Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(232, 5, 'Saddar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(233, 5, 'Westridge', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(234, 5, 'Chaklala', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(235, 5, 'Gulraiz', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(236, 6, 'Peoples Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(237, 6, 'Madina Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(238, 6, 'Civil Lines', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(239, 6, 'Gulberg', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(240, 6, 'Samanabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(241, 7, 'Gulgasht Colony', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(242, 7, 'Cantt', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(243, 7, 'Bosan Road', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(244, 7, 'Shah Rukn-e-Alam', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(245, 7, 'New Multan', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(246, 8, 'Hayatabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(247, 8, 'University Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(248, 8, 'Cantt', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(249, 8, 'Saddar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(250, 8, 'Gulbahar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(251, 9, 'Jinnah Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(252, 9, 'Shahbaz Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(253, 9, 'Cantt', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(254, 9, 'Model Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(255, 9, 'Satellite Town', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `banner_link` varchar(255) DEFAULT NULL,
  `sort` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `user_id`, `name`, `slug`, `banner`, `icon`, `banner_link`, `sort`, `created_at`, `updated_at`) VALUES
(52, 4, 'Shawarma', 'shawarma', '4/categories/shawarma/category-banners/eCOz8Cx3Fwkb2RkX2MIYGfniGmd098ykPgvl7fi3.png', NULL, NULL, 1, '2026-01-30 09:22:58', '2026-01-30 09:28:46'),
(53, 4, 'Tamiya Falafel', 'tamiya-falafel', '4/categories/tamiya-falafel/category-banners/6csKy9zdkANF6Xegoe7Ypk3B36u7Tk4rX9CtM7ew.webp', NULL, NULL, 2, '2026-01-30 09:24:09', '2026-01-30 09:28:46'),
(54, 4, 'Chicken Burgers and Fried Chicken', 'chicken-burgers-and-fried-chicken', '4/categories/chicken-burgers-and-fried-chicken/category-banners/80UjEPOsRiCnpCAO3bbaiJqZdx0lxrAtEiP3ZGdS.webp', NULL, NULL, 3, '2026-01-30 09:25:05', '2026-01-30 09:28:46'),
(55, 4, 'Prawns and Fries', 'prawns-and-fries', '4/categories/prawns-and-fries/category-banners/uUEKWWTQzP1Wuql7z7RlNNKtZr1lTLzxKzUDnAo3.webp', NULL, NULL, 4, '2026-01-30 09:25:44', '2026-01-30 09:28:46'),
(56, 4, 'Add ons', 'add-ons', '4/categories/add-ons/category-banners/9CcROaYfKl3vigdnQH1yl9mxO9JJHKX2yOQKedjV.webp', NULL, NULL, 5, '2026-01-30 09:26:14', '2026-01-30 09:28:46'),
(57, 4, 'Beverages', 'beverages', '4/categories/beverages/category-banners/yLGXRwqn5nq5SCe0pdkXemLGASORNsks0PhiYDCH.webp', NULL, NULL, 6, '2026-01-30 09:27:03', '2026-01-30 09:28:46');

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

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

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

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

INSERT INTO `cities` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Karachi', 'active', '2026-01-30 06:37:46', '2026-01-30 06:37:46'),
(3, 'Lahore', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(4, 'Islamabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(5, 'Rawalpindi', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(6, 'Faisalabad', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(7, 'Multan', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(8, 'Peshawar', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47'),
(9, 'Quetta', 'active', '2026-01-30 06:37:47', '2026-01-30 06:37:47');

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

--
-- Table structure for table `content_pages`
--

CREATE TABLE `content_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `content` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_pages`
--

INSERT INTO `content_pages` (`id`, `user_id`, `meta_title`, `meta_keywords`, `meta_description`, `slug`, `content`, `created_at`, `updated_at`) VALUES
(1, 4, NULL, NULL, NULL, 'home', '<h2>Experience the Best Shawarma at Shawarma Kaizer in Karachi</h2><p>Order online from Shawarma Kaizer in Karachi and enjoy mouthwatering shawarma made with the finest ingredients. Whether for a quick bite or a satisfying meal, Shawarma Kaizer delivers flavor and freshness in every wrap. Enjoy convenience and authentic taste—place your order online today!</p>', '2026-01-30 09:37:16', '2026-01-30 09:37:16');

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

--
-- Table structure for table `delivery_zones`
--

CREATE TABLE `delivery_zones` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `city_id` bigint(20) UNSIGNED NOT NULL,
  `area_id` bigint(20) UNSIGNED NOT NULL,
  `delivery_fee` decimal(10,2) NOT NULL,
  `min_order_amount` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_zones`
--

INSERT INTO `delivery_zones` (`id`, `branch_id`, `city_id`, `area_id`, `delivery_fee`, `min_order_amount`, `created_at`, `updated_at`) VALUES
(18, 1, 2, 44, 160.00, 500.00, '2026-01-30 10:35:57', '2026-01-30 10:35:57'),
(19, 1, 2, 45, 160.00, 500.00, '2026-01-30 10:35:57', '2026-01-30 10:35:57'),
(20, 1, 2, 46, 160.00, 500.00, '2026-01-30 10:35:57', '2026-01-30 10:35:57'),
(21, 1, 2, 47, 160.00, 500.00, '2026-01-30 10:35:57', '2026-01-30 10:35:57'),
(22, 1, 2, 48, 160.00, 500.00, '2026-01-30 10:35:57', '2026-01-30 10:35:57'),
(23, 1, 2, 49, 160.00, 500.00, '2026-01-30 10:35:57', '2026-01-30 10:35:57'),
(24, 1, 2, 50, 160.00, 500.00, '2026-01-30 10:35:57', '2026-01-30 10:35:57');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2025_12_23_000001_create_roles_table', 1),
(2, '2025_12_23_000002_create_cities_table', 1),
(3, '2025_12_23_000003_create_areas_table', 1),
(4, '2025_12_23_000004_create_users_table', 1),
(5, '2025_12_23_000005_create_session_tokens_table', 1),
(6, '2025_12_23_000006_create_web_settings_table', 1),
(7, '2025_12_23_000007_create_categories_table', 1),
(8, '2025_12_23_000010_create_content_pages_table', 1),
(9, '2025_12_23_000011_create_products_table', 1),
(10, '2025_12_23_000012_create_tags_table', 1),
(11, '2025_12_23_000013_create_product_images_table', 1),
(12, '2025_12_23_000014_create_product_option_groups_table', 1),
(13, '2025_12_23_000015_create_product_options_table', 1),
(14, '2025_12_23_000016_create_popular_dishes_table', 1),
(15, '2025_12_23_000017_create_sliders_table', 1),
(16, '2025_12_23_000018_create_restaurant_branches_table', 1),
(17, '2025_12_23_000019_create_delivery_zones_table', 1),
(18, '2025_12_23_000020_create_orders_table', 1),
(19, '2025_12_23_000021_create_order_items_table', 1),
(20, '2025_12_23_000022_create_order_item_options_table', 1),
(21, '2025_12_23_000023_create_recommended_products_table', 1),
(22, '2025_12_23_174456_create_sessions_table', 1),
(23, '2025_12_23_174756_create_cache_table', 1),
(24, '2026_01_15_075920_add_name_to_product_options_table', 2),
(25, '2026_01_15_103459_add_link_to_sliders_table', 2),
(26, '2026_01_17_000000_add_image_path_to_product_options', 2),
(27, '2026_01_17_131147_add_sort_order_to_product_options_table', 3),
(28, '2026_01_18_000001_add_user_id_to_tags_table', 4),
(29, '2026_01_18_000002_make_product_id_nullable_in_tags_table', 5),
(30, '2026_01_19_000001_add_out_of_stock_to_products_table', 6),
(31, '2026_01_19_000002_add_is_recommended_to_products_table', 7),
(32, '2026_01_19_000003_drop_recommended_products_table', 7),
(33, '2026_01_30_125714_create_personal_access_tokens_table', 8);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone_number` varchar(255) NOT NULL,
  `alternate_phone_number` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `change_request` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `recipient_name` varchar(255) DEFAULT NULL,
  `recipient_number` varchar(255) DEFAULT NULL,
  `gifting_message` text DEFAULT NULL,
  `special_instructions` text DEFAULT NULL,
  `delivery_instructions` text DEFAULT NULL,
  `delivered_to` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_item_options`
--

CREATE TABLE `order_item_options` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_item_id` bigint(20) UNSIGNED NOT NULL,
  `option_group_id` bigint(20) UNSIGNED NOT NULL,
  `linked_product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `extra_price` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `popular_dishes`
--

CREATE TABLE `popular_dishes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `sort` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `price_percent_off` decimal(5,2) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `youtube_url` varchar(255) DEFAULT NULL,
  `free_delivery` tinyint(1) NOT NULL DEFAULT 0,
  `product_option` tinyint(1) NOT NULL DEFAULT 0,
  `out_of_stock` tinyint(1) NOT NULL DEFAULT 0,
  `is_recommended` tinyint(1) NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `category_id`, `user_id`, `name`, `description`, `slug`, `meta_keywords`, `meta_description`, `price_percent_off`, `price`, `youtube_url`, `free_delivery`, `product_option`, `out_of_stock`, `is_recommended`, `status`, `created_at`, `updated_at`) VALUES
(66, 52, 4, 'Chicken Shawarma', '<p><br></p>', 'chicken-shawarma', 'Chicken Shawarma', 'Chicken Shawarma', NULL, 490.00, NULL, 0, 1, 0, 1, 'active', '2026-01-30 09:33:26', '2026-01-30 09:58:10'),
(67, 52, 4, 'Regular Beef Shawarma', '<p><br></p>', 'regular-beef-shawarma', NULL, NULL, NULL, 589.00, NULL, 0, 1, 0, 0, 'active', '2026-01-30 09:46:49', '2026-01-30 09:46:49'),
(69, 53, 4, 'Tamiya with fries (6 pieces)', '<p><br></p>', 'tamiya-with-fries-6-pieces', NULL, NULL, NULL, 390.00, NULL, 0, 0, 0, 1, 'active', '2026-01-30 09:48:22', '2026-01-30 09:58:13'),
(70, 53, 4, 'Tamiya Wrap', '<p><br></p>', 'tamiya-wrap', NULL, NULL, NULL, 390.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:49:56', '2026-01-30 09:49:56'),
(71, 54, 4, 'Zinger Burger', '<p><br></p>', 'zinger-burger', NULL, NULL, NULL, 440.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:50:25', '2026-01-30 09:50:25'),
(72, 54, 4, 'Zinger Burger with Cheese', '<p><br></p>', 'zinger-burger-with-cheese', NULL, NULL, NULL, 490.00, NULL, 0, 0, 0, 1, 'active', '2026-01-30 09:50:52', '2026-01-30 10:09:58'),
(73, 54, 4, 'Spicy Korean Zinger Burger', '<p><br></p>', 'spicy-korean-zinger-burger', NULL, NULL, NULL, 540.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:51:40', '2026-01-30 10:05:48'),
(74, 55, 4, 'Dynamite Prawns (07 pieces)', '<p><br></p>', 'dynamite-prawns-07-pieces', NULL, NULL, NULL, 490.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:52:14', '2026-01-30 09:52:14'),
(75, 55, 4, 'Fries (Approx. 150 gm)', '<p><br></p>', 'fries-approx-150-gm', NULL, NULL, NULL, 287.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:54:02', '2026-01-30 09:54:02'),
(76, 56, 4, 'Extra Cheese Slice', '<p><br></p>', 'extra-cheese-slice', NULL, NULL, NULL, 70.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:54:41', '2026-01-30 09:54:41'),
(77, 56, 4, 'Extra Dynamite Sauce', '<p><br></p>', 'extra-dynamite-sauce', NULL, NULL, NULL, 70.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:55:18', '2026-01-30 09:55:18'),
(78, 56, 4, 'Extra Toum Sauce', '<p><br></p>', 'extra-toum-sauce', NULL, NULL, NULL, 70.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:55:43', '2026-01-30 09:55:43'),
(79, 57, 4, 'Water Bottle', '<p>500ml</p>', 'water-bottle', NULL, NULL, NULL, 59.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:56:20', '2026-01-30 09:56:20'),
(80, 57, 4, 'Cold Drink', '<p>345ml</p>', 'cold-drink', NULL, NULL, NULL, 120.00, NULL, 0, 0, 0, 0, 'active', '2026-01-30 09:56:58', '2026-01-30 10:09:50');

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

--
-- Table structure for table `product_images`
--

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

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image_path`, `created_at`, `updated_at`) VALUES
(10, 66, '4/product/chicken-shawarma/kXkHt4miiNfFJ5IJJz5aAhnyAJ0eYlxDQXBsc9XM.webp', '2026-01-30 09:33:26', '2026-01-30 09:33:26'),
(11, 67, '4/product/regular-beef-shawarma/yS3WqhzaF9czGEl9nZql4OGQvyDslZyqwjPZKTTf.webp', '2026-01-30 09:46:49', '2026-01-30 09:46:49'),
(12, 69, '4/product/tamiya-with-fries-6-pieces/5SX0FMeNGfedCFyAI4yEtMKkU0W49U5rzURd8mtM.webp', '2026-01-30 09:48:22', '2026-01-30 09:48:22'),
(13, 70, '4/product/tamiya-wrap/u2YqhjHGN5UlNIcr3eqmNbKcHwmjmLf5tUkOgDMk.webp', '2026-01-30 09:49:56', '2026-01-30 09:49:56'),
(14, 71, '4/product/zinger-burger/xvlaqsUY8yruBlXcIE3cNNeRdRANHMP30r6afObz.webp', '2026-01-30 09:50:26', '2026-01-30 09:50:26'),
(15, 72, '4/product/zinger-burger-with-cheese/Kjf4F1Kt72dlQyaKMPOYjFxDt0t3lBMt1oAUVUUK.webp', '2026-01-30 09:50:52', '2026-01-30 09:50:52'),
(16, 73, '4/product/spicy-korean-zinger-burger/C7ozq7ZgvwxYlkWMU7K89rZYoGPI4dx3Thay7ghP.webp', '2026-01-30 09:51:40', '2026-01-30 09:51:40'),
(17, 74, '4/product/dynamite-prawns-07-pieces/ClX0QH7bsLnVMS0H2sUWIGuIIPHxPoYtCvNDAqgK.webp', '2026-01-30 09:52:14', '2026-01-30 09:52:14'),
(18, 75, '4/product/fries-approx-150-gm/dAo6evpYaNoR9Bl4VQkwhjTM1zgqYztifprCM6w8.webp', '2026-01-30 09:54:02', '2026-01-30 09:54:02'),
(19, 76, '4/product/extra-cheese-slice/ZiZdMfbGp77cRAjbNWhU2RuNa6kwAxlO16RjX7sN.webp', '2026-01-30 09:54:41', '2026-01-30 09:54:41'),
(20, 77, '4/product/extra-dynamite-sauce/hPLBWMv9XejRTVUe5FXR6uj37DMDTQGz8X1zZSK3.webp', '2026-01-30 09:55:18', '2026-01-30 09:55:18'),
(21, 78, '4/product/extra-toum-sauce/mqE8ieyq72nWY3C6LAPwhCdDdphRvozTJN0fAx9r.webp', '2026-01-30 09:55:43', '2026-01-30 09:55:43'),
(22, 79, '4/product/water-bottle/WP1VpLEwQ34dOXH9D2ZzACl7Pn5nwDKiQqlah9mC.webp', '2026-01-30 09:56:20', '2026-01-30 09:56:20'),
(23, 80, '4/product/cold-drink/YHDUm19Gg1xXBjiBF51g44YNWXQ0YPTHCRHnZAWk.webp', '2026-01-30 09:56:58', '2026-01-30 09:56:58');

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

--
-- Table structure for table `product_options`
--

CREATE TABLE `product_options` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `option_group_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `linked_product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `extra_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_options`
--

INSERT INTO `product_options` (`id`, `option_group_id`, `name`, `linked_product_id`, `image_path`, `extra_price`, `is_default`, `created_at`, `updated_at`, `sort_order`) VALUES
(37, 15, 'Extra Spicy Sauce', NULL, NULL, 70.00, 0, '2026-01-30 09:46:49', '2026-01-30 09:46:49', 0),
(38, 15, 'Extra Toum Sauce', NULL, NULL, 60.00, 0, '2026-01-30 09:46:49', '2026-01-30 09:46:49', 1),
(39, 15, 'Extra Cheese Slice', NULL, NULL, 60.00, 0, '2026-01-30 09:46:49', '2026-01-30 09:46:49', 2),
(40, 15, 'Extra Dynamite Sauce', NULL, NULL, 60.00, 0, '2026-01-30 09:46:49', '2026-01-30 09:46:49', 3),
(49, 20, 'Regular', NULL, NULL, 0.00, 0, '2026-02-01 08:42:16', '2026-02-01 08:42:16', 0),
(50, 20, 'Mini', NULL, NULL, 390.00, 0, '2026-02-01 08:42:16', '2026-02-01 08:42:16', 1),
(51, 21, 'Extra Chicken', NULL, NULL, 200.00, 0, '2026-02-01 08:42:16', '2026-02-01 08:42:16', 0),
(52, 21, 'Extra Cheese Slice', NULL, NULL, 60.00, 0, '2026-02-01 08:42:16', '2026-02-01 08:42:16', 1),
(53, 21, 'Zinger Burger', 71, NULL, 0.00, 0, '2026-02-01 08:42:16', '2026-02-01 08:42:16', 2);

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

--
-- Table structure for table `product_option_groups`
--

CREATE TABLE `product_option_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `is_required` tinyint(1) NOT NULL DEFAULT 0,
  `min_selection` int(11) DEFAULT NULL,
  `max_selection` int(11) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_option_groups`
--

INSERT INTO `product_option_groups` (`id`, `product_id`, `name`, `type`, `is_required`, `min_selection`, `max_selection`, `sort_order`, `created_at`, `updated_at`) VALUES
(15, 67, 'Addons', 'checkbox', 0, NULL, NULL, 0, '2026-01-30 09:46:49', '2026-01-30 09:46:49'),
(20, 66, 'Size', 'radio', 1, NULL, 2, 0, '2026-02-01 08:42:16', '2026-02-01 08:42:16'),
(21, 66, 'Addons', 'checkbox', 0, NULL, NULL, 1, '2026-02-01 08:42:16', '2026-02-01 08:42:16');

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

--
-- Table structure for table `restaurant_branches`
--

CREATE TABLE `restaurant_branches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `city_id` bigint(20) UNSIGNED NOT NULL,
  `area_id` bigint(20) UNSIGNED NOT NULL,
  `branch_name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `delivery_radius_km` decimal(5,2) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `restaurant_branches`
--

INSERT INTO `restaurant_branches` (`id`, `user_id`, `city_id`, `area_id`, `branch_name`, `address`, `latitude`, `longitude`, `delivery_radius_km`, `phone_number`, `status`, `created_at`, `updated_at`) VALUES
(1, 4, 2, 48, 'Shawarma Kaizer Main', 'Shop No. 04, Building No, 2-C Lane No. 01, D.H.A Phase 6 Rahat Commercial Area Phase 6 Defence Housing Authority, Karachi,', NULL, NULL, NULL, '0328 2860677', 'active', '2026-01-30 06:45:22', '2026-01-30 06:45:22');

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

--
-- Table structure for table `roles`
--

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

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'super_admin', '2026-01-06 21:46:01', '2026-01-06 21:46:01'),
(2, 'admin', '2026-01-06 21:46:01', '2026-01-06 21:46:01');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('kNty3yCDQrDV0NAIpSMdDg8e57XzghAySnFkZCNi', 4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiUEFhTmtRbDVZbWs3NHlqaFRJZEEyemp5SkNtYTVwMDRGc0NoU3RTViI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjI3OiJodHRwOi8vbG9jYWxob3N0OjgwMDAvbG9naW4iO3M6NToicm91dGUiO3M6NToibG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo0O30=', 1769953339),
('xXdAByPa055BwK9tDm7l24jvLcbI0wOdY0SovpLf', 4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQW9aTXZnZjNtTFA3TWh6dFVQVHF2S0E0SFVtTGQ3dnMyWVQ4dlM0VyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjMxOiJodHRwOi8vbG9jYWxob3N0OjgwMDAvZGFzaGJvYXJkIjtzOjU6InJvdXRlIjtzOjQ6ImhvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo0O30=', 1769863748),
('YOPKo7xod0yLwVuF8BCauXJWZQ7A2oM8FMtxiDPj', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiWHFkVm94UWRwODl5Q04yMEUxbDFXdkpTeWtXbndOS1g4eXVvZndzcSI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjM0OiJodHRwOi8vbG9jYWxob3N0OjgwMDAvdXNlcnMvZm9ybS80IjtzOjU6InJvdXRlIjtzOjEwOiJ1c2Vycy5lZGl0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1770085790);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `sort` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `user_id`, `image`, `link`, `sort`, `created_at`, `updated_at`) VALUES
(2, 4, '4/sliders/9cTZQDBzJfzG6ZMDh6CYClgevWU0Jghvb5h9C2ve.webp', NULL, 0, '2026-01-30 09:35:49', '2026-01-30 09:35:49'),
(3, 4, '4/sliders/7sEn1WyBoiuF0GFp6ZrYGCXhkJbRITkmMrcIC8TV.webp', NULL, 0, '2026-01-30 09:35:59', '2026-01-30 09:35:59');

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

--
-- Table structure for table `tags`
--

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

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`id`, `user_id`, `product_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 2, NULL, 'Hot Sales', '2026-01-17 23:41:24', '2026-01-17 23:42:39'),
(2, 2, NULL, 'fgdfgdfg', '2026-01-17 23:42:46', '2026-01-17 23:42:46'),
(3, 1, NULL, 'Hot Sales', '2026-01-30 09:02:37', '2026-01-30 09:02:37'),
(4, 4, NULL, 'Best Seller', '2026-01-30 09:34:20', '2026-01-30 09:34:20');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`),
  ADD KEY `categories_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `content_pages`
--
ALTER TABLE `content_pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `content_pages_slug_unique` (`slug`),
  ADD KEY `content_pages_user_id_foreign` (`user_id`);

--
-- Indexes for table `delivery_zones`
--
ALTER TABLE `delivery_zones`
  ADD PRIMARY KEY (`id`),
  ADD KEY `delivery_zones_branch_id_foreign` (`branch_id`),
  ADD KEY `delivery_zones_city_id_foreign` (`city_id`),
  ADD KEY `delivery_zones_area_id_foreign` (`area_id`);

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_branch_id_foreign` (`branch_id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_items_order_id_foreign` (`order_id`),
  ADD KEY `order_items_product_id_foreign` (`product_id`);

--
-- Indexes for table `order_item_options`
--
ALTER TABLE `order_item_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_item_options_order_item_id_foreign` (`order_item_id`),
  ADD KEY `order_item_options_option_group_id_foreign` (`option_group_id`),
  ADD KEY `order_item_options_linked_product_id_foreign` (`linked_product_id`);

--
-- Indexes for table `popular_dishes`
--
ALTER TABLE `popular_dishes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `popular_dishes_user_id_foreign` (`user_id`),
  ADD KEY `popular_dishes_product_id_foreign` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_slug_unique` (`slug`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_user_id_foreign` (`user_id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_images_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_options`
--
ALTER TABLE `product_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_options_option_group_id_foreign` (`option_group_id`),
  ADD KEY `product_options_linked_product_id_foreign` (`linked_product_id`);

--
-- Indexes for table `product_option_groups`
--
ALTER TABLE `product_option_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_option_groups_product_id_foreign` (`product_id`);

--
-- Indexes for table `restaurant_branches`
--
ALTER TABLE `restaurant_branches`
  ADD PRIMARY KEY (`id`),
  ADD KEY `restaurant_branches_user_id_foreign` (`user_id`),
  ADD KEY `restaurant_branches_city_id_foreign` (`city_id`),
  ADD KEY `restaurant_branches_area_id_foreign` (`area_id`);

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tags_product_id_foreign` (`product_id`),
  ADD KEY `tags_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

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

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `content_pages`
--
ALTER TABLE `content_pages`
  ADD CONSTRAINT `content_pages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `delivery_zones`
--
ALTER TABLE `delivery_zones`
  ADD CONSTRAINT `delivery_zones_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `delivery_zones_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `restaurant_branches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `delivery_zones_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `restaurant_branches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_item_options`
--
ALTER TABLE `order_item_options`
  ADD CONSTRAINT `order_item_options_linked_product_id_foreign` FOREIGN KEY (`linked_product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `order_item_options_option_group_id_foreign` FOREIGN KEY (`option_group_id`) REFERENCES `product_option_groups` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_item_options_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `popular_dishes`
--
ALTER TABLE `popular_dishes`
  ADD CONSTRAINT `popular_dishes_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `popular_dishes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_images`
--
ALTER TABLE `product_images`
  ADD CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_options`
--
ALTER TABLE `product_options`
  ADD CONSTRAINT `product_options_linked_product_id_foreign` FOREIGN KEY (`linked_product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `product_options_option_group_id_foreign` FOREIGN KEY (`option_group_id`) REFERENCES `product_option_groups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_option_groups`
--
ALTER TABLE `product_option_groups`
  ADD CONSTRAINT `product_option_groups_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `restaurant_branches`
--
ALTER TABLE `restaurant_branches`
  ADD CONSTRAINT `restaurant_branches_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `restaurant_branches_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `restaurant_branches_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sliders`
--
ALTER TABLE `sliders`
  ADD CONSTRAINT `sliders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tags`
--
ALTER TABLE `tags`
  ADD CONSTRAINT `tags_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tags_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

