-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 03, 2026 at 03:47 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 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 `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cache` -- INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel-cache-580071baad7b227a20e85017933acecb', 'i:1;', 1770084758), ('laravel-cache-580071baad7b227a20e85017933acecb:timer', 'i:1770084758;', 1770084758), ('laravel-cache-a52476eecda282f965da3f60bc7f225e', 'i:1;', 1769952030), ('laravel-cache-a52476eecda282f965da3f60bc7f225e:timer', 'i:1769952030;', 1769952030), ('laravel-cache-c525a5357e97fef8d3db25841c86da1a', 'i:1;', 1768710767), ('laravel-cache-c525a5357e97fef8d3db25841c86da1a:timer', 'i:1768710767;', 1768710767); -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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', '

Experience the Best Shawarma at Shawarma Kaizer in Karachi

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!

', '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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` text NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL 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 `personal_access_tokens` -- INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `expires_at`, `created_at`, `updated_at`) VALUES (1, 'App\\Models\\User', 1, 'static-api-key', 'da4fd9f0a12267225a376bfa0356e54ee0f5d3a19ea3bfda4a893c52c9e5079c', '[\"*\"]', NULL, NULL, '2026-01-30 07:57:50', '2026-01-30 07:57:50'); -- -------------------------------------------------------- -- -- 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', '


', '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', '


', '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)', '


', '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', '


', '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', '


', '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', '


', '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', '


', '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)', '


', '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)', '


', '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', '


', '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', '


', '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', '


', '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', '

500ml

', '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', '

345ml

', '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 `session_tokens` -- CREATE TABLE `session_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `token` varchar(255) NOT NULL, `expires_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `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 `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'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `parent_user_id` bigint(20) UNSIGNED DEFAULT NULL, `role_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT 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 `users` -- INSERT INTO `users` (`id`, `parent_user_id`, `role_id`, `name`, `email`, `password`, `phone_number`, `status`, `created_at`, `updated_at`) VALUES (1, NULL, 1, 'Super Admin', 'superadmin@example.com', '$2y$12$VrQS1pK8w310rjnIHEdnve3xOqhZmr/skcxiuiJ.gqU3NM2cYmRm2', NULL, 'active', '2026-01-06 21:47:50', '2026-01-17 09:04:57'), (2, 1, 2, 'admin', 'admin@gmail.com', '$2y$12$VM.MQ41zP.9cGFT/yGRnn.nRUehUFCN5hK0.95vqIZZZmiE0g5gtm', NULL, 'active', '2026-01-17 08:31:17', '2026-01-19 12:01:11'), (4, 1, 2, 'shawarmakaizer', 'admin@shawarmakaizer.pk', '$2y$12$KycZjWBdgV1IMwGD6BAETerzeR5mkHGQWF3Ai3PM6yH43ImDLxGd.', NULL, 'active', '2026-01-30 09:20:01', '2026-01-30 09:20:01'); -- -------------------------------------------------------- -- -- Table structure for table `web_settings` -- CREATE TABLE `web_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `tax_percentage` decimal(5,2) DEFAULT NULL, `delivery_fee` decimal(10,2) DEFAULT NULL, `robots_tag` varchar(255) DEFAULT NULL, `restaurant_full_address` varchar(255) DEFAULT NULL, `clarity_tag` varchar(255) DEFAULT NULL, `meta_pixel_tag` varchar(255) DEFAULT NULL, `gtm_tag` varchar(255) DEFAULT NULL, `analytics_tag` varchar(255) DEFAULT NULL, `google_verification_code` varchar(255) DEFAULT NULL, `yahoo_verification_code` varchar(255) DEFAULT NULL, `bing_verification_code` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `domain_name` varchar(255) DEFAULT NULL, `restaurant_name` varchar(255) DEFAULT NULL, `payment_amount` decimal(10,2) DEFAULT NULL, `favicon` varchar(255) DEFAULT NULL, `meta_title` varchar(255) DEFAULT NULL, `meta_keywords` varchar(255) DEFAULT NULL, `meta_description` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `web_phone_number` varchar(255) DEFAULT NULL, `restaurant_open_time` timestamp NULL DEFAULT NULL, `restaurant_close_time` timestamp NULL DEFAULT NULL, `map_location_link` varchar(255) DEFAULT NULL, `web_bg_banner` varchar(255) DEFAULT NULL, `facebook_link` varchar(255) DEFAULT NULL, `instagram_link` varchar(255) DEFAULT NULL, `youtube_link` varchar(255) DEFAULT NULL, `tiktok_link` varchar(255) DEFAULT NULL, `snapchat_link` varchar(255) DEFAULT NULL, `pinterest_link` varchar(255) DEFAULT NULL, `whatsapp_link` 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; -- -- Dumping data for table `web_settings` -- INSERT INTO `web_settings` (`id`, `user_id`, `tax_percentage`, `delivery_fee`, `robots_tag`, `restaurant_full_address`, `clarity_tag`, `meta_pixel_tag`, `gtm_tag`, `analytics_tag`, `google_verification_code`, `yahoo_verification_code`, `bing_verification_code`, `logo`, `domain_name`, `restaurant_name`, `payment_amount`, `favicon`, `meta_title`, `meta_keywords`, `meta_description`, `content`, `web_phone_number`, `restaurant_open_time`, `restaurant_close_time`, `map_location_link`, `web_bg_banner`, `facebook_link`, `instagram_link`, `youtube_link`, `tiktok_link`, `snapchat_link`, `pinterest_link`, `whatsapp_link`, `created_at`, `updated_at`) VALUES (1, 1, NULL, NULL, NULL, 'sdfsdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1/web-settings/logos/blYnrwevLZ3E46qPsjlJpEUr5vmICIdhDmZ5RbRC.jpg', 'sdfsdf', 'fsdfsdf', NULL, 'user_id 1/web-settings/favicons/H3UQhRVUfSKZqZkWOF1N8XkIc7UN5l7DOTlSEVLI.jpg', NULL, NULL, NULL, NULL, '12313123', NULL, NULL, NULL, 'user_id 1/web-settings/web_bg_banners/FLKeEd5eK7tOuRINuio43TIupzE0SkcHprJH0sT0.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-18 00:08:51', '2026-01-18 00:15:25'), (2, 4, NULL, NULL, NULL, 'Shop No. 4, Building No. 2-C, Lane No. 1, Rahat Commercial, Popular Avenue, D.H.A Phase VI', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4/web-settings/logos/reIZgCZ6dJb17phYIXXY0i4BmW0urBXOi7dKS79J.webp', 'shawarmakaizer.pk', 'Shawarmakaizer', NULL, '4/web-settings/favicons/M4gqn54yOehxp4ooUBmr8mZUGd8ImIqZAvJyUPx2.png', 'Experience Authentic Shawarma Flavors | Order Online at Shawarma Kaizer', NULL, 'Savor the authentic taste of freshly made shawarma at Shawarma Kaizer in Karachi. Crafted with premium ingredients—pick up or order online now!', NULL, '03282860677', '2026-01-30 11:00:00', '2026-01-29 20:00:00', NULL, NULL, 'https://www.facebook.com/p/Shawarma-Kaizer-61560625655261/', 'https://www.instagram.com/shawarmakaizer', NULL, NULL, NULL, NULL, NULL, '2026-01-30 09:41:34', '2026-01-30 09:41:34'); -- -- 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 `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- 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 `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`), ADD KEY `personal_access_tokens_expires_at_index` (`expires_at`); -- -- 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 `session_tokens` -- ALTER TABLE `session_tokens` ADD PRIMARY KEY (`id`), ADD KEY `session_tokens_user_id_foreign` (`user_id`); -- -- 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`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_parent_user_id_foreign` (`parent_user_id`), ADD KEY `users_role_id_foreign` (`role_id`); -- -- Indexes for table `web_settings` -- ALTER TABLE `web_settings` ADD PRIMARY KEY (`id`), ADD KEY `web_settings_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 `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- 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 `session_tokens` -- ALTER TABLE `session_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `web_settings` -- ALTER TABLE `web_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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 `session_tokens` -- ALTER TABLE `session_tokens` ADD CONSTRAINT `session_tokens_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; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_parent_user_id_foreign` FOREIGN KEY (`parent_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `web_settings` -- ALTER TABLE `web_settings` ADD CONSTRAINT `web_settings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;