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

START TRANSACTION;



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

--
-- Table structure for table `brands`
--

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

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Samsung', '2024-10-09 06:33:48', '2024-10-09 06:33:48'),
(2, 'Infinix', '2024-10-09 06:33:48', '2024-10-09 06:33:48'),
(3, 'Nokia', '2024-10-09 06:33:48', '2024-10-09 06:33:48'),
(4, 'Xiaomi', '2024-10-24 14:04:24', '2024-10-24 14:04:24');

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

--
-- Table structure for table `brand_homes`
--

CREATE TABLE `brand_homes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(191) NOT NULL,
  `discover_more_link` text DEFAULT NULL,
  `photo` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `brand_homes`
--

INSERT INTO `brand_homes` (`id`, `name`, `description`, `discover_more_link`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'Samsung', 'Warranty Policy COMMON Warranty Service Policy & Procedures SAMSUNG offers warranty service for all our different mix of products.', 'https://thinkonlinedemos.com/vn4/public/arabia_mobiles/shop?&brand_id=1', 'images/photo/6708212d8210b1728586029.webp', '2024-10-10 10:28:38', '2024-11-06 18:18:56'),
(2, 'Infinix Authorized Distributor', 'In addition to the warranty and after sale service, Arabia Mobiles is the Authorized Distributor of Infinix in Lebanon', 'https://thinkonlinedemos.com/vn4/public/arabia_mobiles/shop?&brand_id=2', 'images/photo/670820a2de2a91728585890.webp', '2024-10-10 10:28:39', '2024-11-06 18:18:33'),
(3, 'Nokia Warranty', 'The Warranty period starts on the date the Product is sold to an end user for the first time, as evidenced by the original proof of purchase.', 'https://thinkonlinedemos.com/vn4/public/arabia_mobiles#', 'images/photo/6708210f675921728585999.webp', '2024-10-10 10:28:39', '2024-11-06 18:19:29'),
(4, 'XIAOMI', 'Eagle Plus, sister company of Arabia Mobiles, is Xiaomi\'s authorized distributor in Lebanon, delivering the latest tech innovations with trusted service.', 'https://thinkonlinedemos.com/vn4/public/arabia_mobiles/shop?&brand_id=4', 'images/photo/67220eed932d41730285293.webp', '2024-10-30 15:48:14', '2024-11-06 18:17:57');

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

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

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

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

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'MOBILES', '2024-10-08 19:31:22', '2024-10-09 10:17:53'),
(2, 'TABLETS', '2024-10-08 19:31:22', '2024-10-09 10:18:19'),
(3, 'ACCESSORIES', '2024-10-08 19:31:22', '2024-10-09 10:19:00');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `subject` varchar(191) NOT NULL,
  `imei` varchar(1000) DEFAULT NULL,
  `message` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `phone_number`, `subject`, `imei`, `message`, `created_at`, `updated_at`) VALUES
(1, 'maher', 'maher@gmail.com', '+1 (548) 167-6916', 'hi', NULL, 'done', '2024-10-09 03:46:45', '2024-10-09 03:46:45'),
(2, 'Nelly Ghossein', 'nellyghossein@gmail.com', '70766990', 'test', NULL, 'test', '2024-10-11 09:43:15', '2024-10-11 09:43:15'),
(3, 'Nelly Ghossein', 'nellyghossein@gmail.com', '70766990', 'test', NULL, 'hello word', '2024-10-11 15:50:27', '2024-10-11 15:50:27');

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

--
-- Table structure for table `counters`
--

CREATE TABLE `counters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `count_number` int(11) NOT NULL,
  `description` varchar(191) NOT NULL,
  `counter_photo` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `counters`
--

INSERT INTO `counters` (`id`, `title`, `count_number`, `description`, `counter_photo`, `created_at`, `updated_at`) VALUES
(1, 'NORTH', 500, '5 Wholesalers', 'images/counter_photo/67233bbb97c321730362299.webp', '2024-10-08 19:31:25', '2024-12-20 21:05:59'),
(2, 'MOUNT LEBANON', 700, '22 Wholesalers', 'images/counter_photo/6708ac50553461728621648.webp', '2024-10-08 19:31:25', '2024-12-20 21:06:15'),
(3, 'BEIRUT', 300, '8 Wholesalers', 'images/counter_photo/6708ac373fb0e1728621623.webp', '2024-10-08 19:31:26', '2024-12-20 21:05:41'),
(5, 'SOUTH', 500, 'Wholesalers: 8', 'images/counter_photo/6708ac27336a61728621607.webp', '2024-10-08 19:31:27', '2024-12-20 21:05:26'),
(7, 'BEKAA', 500, 'Wholesalers: 12', 'images/counter_photo/6708ac196ac121728621593.webp', '2024-10-11 00:13:01', '2024-12-20 20:41:21');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `main_page_services`
--

CREATE TABLE `main_page_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `photo` text NOT NULL,
  `link` varchar(1500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `main_page_services`
--

INSERT INTO `main_page_services` (`id`, `title`, `photo`, `link`, `created_at`, `updated_at`) VALUES
(1, 'Market Distribution', 'images/photo/6762943e478bf1734513726.webp', 'https://thinkonlinedemos.com/v6/public/arabia_mobiles/service/details/14', '2024-10-10 10:25:21', '2024-12-18 18:10:20'),
(2, 'Arabia Care Service Center', 'images/photo/676573b32da571734702003.webp', 'https://thinkonlinedemos.com/v6/public/arabia_mobiles/service/details/11', '2024-10-10 10:25:42', '2024-12-20 19:40:03'),
(3, 'Marketing and Trade', 'images/photo/676293f51842f1734513653.webp', 'https://thinkonlinedemos.com/v6/public/arabia_mobiles/service/details/10', '2024-10-10 10:26:03', '2024-12-18 18:08:55');

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

--
-- Table structure for table `metas`
--

CREATE TABLE `metas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `header_logo` varchar(191) NOT NULL,
  `footer_logo` varchar(191) NOT NULL,
  `icon` varchar(191) NOT NULL,
  `og_image` varchar(191) NOT NULL,
  `web_color` varchar(191) NOT NULL,
  `link` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `metas`
--

INSERT INTO `metas` (`id`, `header_logo`, `footer_logo`, `icon`, `og_image`, `web_color`, `link`, `created_at`, `updated_at`) VALUES
(1, 'images/metas/65e76021b8e951709662241.webp', 'images/metas/65e76022487e11709662242.webp', 'images/metas/65e76022263531709662242.webp', 'images/metas/65e744dcee36c1709655260.webp', 'red', 'https://www.zynyjekevifelus.cc', '2024-09-09 06:36:45', '2024-09-09 06:36:45');

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

--
-- Table structure for table `meta_translations`
--

CREATE TABLE `meta_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(2) NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `og_title` text DEFAULT NULL,
  `keywords` text DEFAULT NULL,
  `footer` text DEFAULT NULL,
  `web_name` text DEFAULT NULL,
  `rights` text DEFAULT NULL,
  `term_condition` text DEFAULT NULL,
  `privacy_policy` text DEFAULT NULL,
  `location` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `meta_translations`
--

INSERT INTO `meta_translations` (`id`, `meta_id`, `locale`, `title`, `description`, `og_title`, `keywords`, `footer`, `web_name`, `rights`, `term_condition`, `privacy_policy`, `location`) VALUES
(1, 1, 'ar', 'Arabia Mobiles', 'description_ar', 'Arabia Mobiles', 'button_name_ar', 'button_name_ar', 'Jenna Clements', 'Voluptatum perspicia', NULL, NULL, 'Alias reiciendis qui'),
(2, 1, 'en', 'Arabia Mobiles', 'description_en', 'Arabia Mobiles', 'button_name_en', 'button_name_en', 'Jenna Clements', 'Voluptatum perspicia', NULL, NULL, 'Alias reiciendis qui');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_02_22_055958_create_admins_table', 1),
(6, '2024_02_22_073609_create_metas_table', 1),
(7, '2024_02_22_073630_create_meta_translations_table', 1),
(8, '2024_09_07_094833_create_sliders_table', 1),
(9, '2024_09_08_185833_create_contacts_table', 1),
(10, '2024_09_09_063952_create_settings_table', 1);

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

--
-- Table structure for table `new_events`
--

CREATE TABLE `new_events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `date` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `photo` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `new_events`
--

INSERT INTO `new_events` (`id`, `title`, `date`, `description`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'New Technology or specs in the mobiles', '8 Aug, 2024', 'The Infinix Zero Flip was officially launched globally on September 28, 2024. This marks the entry of Infinix into the foldable smartphone market with significant advancements in mobile technology. \r\nInfinix is introducing cutting-edge features in their latest models, like the Infinix Zero Flip, which offers:\r\n-	A dual-display experience with a 6.9-inch full-HD+ AMOLED main screen \r\n-	A 3.64-inch AMOLED cover display, both supporting a 120Hz refresh rate for seamless visuals. \r\n-	It\'s powered by the MediaTek Dimensity 8020 SoC for robust multitasking and gaming performance. \r\n-	The model boasts dual 50-megapixel cameras for enhanced photography, including a high-resolution selfie shooter, and offers up to 512GB of storage. \r\n-	Running on Android 14 with XOS 14.5, it incorporates the latest software advancements for an improved user interface and experience.', 'images/photo/67081f5e6c8ff1728585566.webp', '2024-10-10 13:33:31', '2024-10-10 23:39:26'),
(2, 'EU to pump €865M into 5G, infrastructure projects', '10Oct, 2024', 'The European Commission set out a plan to spend €865 million on improving digital connectivity in European Union (EU) member states, the latest swathe of cash to be released from a €2 billion pot to improve the region’s infrastructure.\r\n\r\nIn a statement, the authority announced the adoption of its second work programme under the Connecting Europe Facility Digital scheme, which aims to support projects deemed of common EU interest alongside deployment of the latest connectivity infrastructure in specific areas.\r\n\r\nThe latest tranche of cash will be partly used for co-financing large-scale 5G and gigabit fibre projects. Funds will also be allocated to “deployment and significant upgrade of backbone networks”, including quantum communication and submarine cables to improve capacity.\r\n\r\nDigital industry schemes are also set to receive allocations from the pot, with the EC stating an ambition to aid “integration of edge cloud and computing capabilities in vertical sectoral applications, such as health, manufacturing, transport and logistics”.\r\n\r\nThe latest batch of cash will be allocated for 2024 to 2027: the EC’s previous work programme ran from 2021 to 2023. It plans to call for applications in the coming days.\r\n\r\nEuropean Commissioner and EVP for a Europe Fit for the Digital Age Margrethe Vestager (pictured) highlighted the strategic importance of improving connectivity: “with this second work programme we aim to connect more citizens and businesses, and launch more innovative connectivity infrastructure”.', 'images/photo/67081fdcbb9cd1728585692.webp', '2024-10-10 13:33:31', '2024-10-10 23:41:32'),
(3, 'MTV and Infinix', '8 July, 2024', 'The Infinix and MTV partnership enhances sports broadcasts with features   during basketball and football games, seasonal awards during Christmas and Ramadan and viewer-driven awards with prizes.', 'images/photo/67081eef5dede1728585455.webp', '2024-10-10 23:37:35', '2024-10-10 23:37:35'),
(5, 'Christmas Annual Dinner', 'Decembre 09, 2023', 'Experience the festive spirit of our Christmas Annual Dinner with Arabia Mobiles. This special event brings together colleagues, partners, and friends for a joyful celebration, complete with a delightful meal, live entertainment, and engaging activities. It’s a perfect opportunity to connect, celebrate, and share the magic of the holiday season.', 'images/photo/675c3dc8c004d1734098376.webp', '2024-12-13 19:59:37', '2024-12-13 19:59:37');

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

--
-- Table structure for table `process`
--

CREATE TABLE `process` (
  `id` int(11) NOT NULL,
  `title` varchar(1000) DEFAULT NULL,
  `o_s` int(11) DEFAULT 1,
  `image` varchar(1000) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `process`
--

INSERT INTO `process` (`id`, `title`, `o_s`, `image`, `service_id`) VALUES
(11, 'WARRANTY SUPPORT', 1, 'images/image/67629debb40dd1734516203.webp', 11),
(26, 'SALES PROSPECTING', 1, 'images/image/6762a80703cbf1734518791.webp', 14),
(12, 'TROUBLESHOOTING', 1, 'images/image/67629e0153f721734516225.webp', 11),
(13, 'SOFTWARE UPDATES', 1, 'images/image/67629e1778df81734516247.webp', 11),
(14, 'MAINTENANCE', 1, 'images/image/67629e2f8880e1734516271.webp', 11),
(15, 'PERSONALISED ASSISTANCE', 1, 'images/image/67629e4e1aab01734516302.webp', 11),
(16, 'INVENTORY MANAGEMENT', 1, 'images/image/67629f8872d601734516616.webp', 8),
(17, 'MARKETING INITIATIVES', 1, 'images/image/67629fa0b32df1734516640.webp', 8),
(18, 'FINANCIAL RISK MANAGEMENT', 1, 'images/image/67629fc9926931734516681.webp', 8),
(32, 'HANDLING OBJECTIONS', 1, 'images/image/6762a8b8e538f1734518968.webp', 14),
(45, 'TEAM COVERAGE', NULL, 'images/image/67656567236c31734698343.webp', 16),
(30, 'MAKING AN OFFER', 1, 'images/image/6762a8a5d9efb1734518949.webp', 14),
(29, 'NURTURING THE LEAD', 1, 'images/image/6762a859a00351734518873.webp', 14),
(28, 'QUALIFYING THE LEAD', 1, 'images/image/6762a83232b511734518834.webp', 14),
(27, 'MAKING CONTACT', 1, 'images/image/6762a821042901734518817.webp', 14),
(33, 'CLOSING THE SALE', 1, 'images/image/6762a8d50d0ae1734518997.webp', 14),
(57, 'MARKET RESEARCH', NULL, 'images/image/676917b7652c41734940599.webp', 10),
(55, 'ACTIVATION EXECUTION', NULL, 'images/image/6769175066c021734940496.webp', 10),
(56, 'BRANDING', NULL, 'images/image/6769178d2b7601734940557.webp', 10),
(54, 'SPONSORSHIP MANAGEMENT', NULL, 'images/image/6769171ad29a11734940442.webp', 10),
(53, 'PROMOTIONAL PLANNING', NULL, 'images/image/676916e0ccd3d1734940384.webp', 10),
(52, 'STRATEGY IMPLEMENTATION', NULL, 'images/image/676916816cc5b1734940289.webp', 10),
(41, 'PARTNERSHIP DEVELOPMENT', 1, 'images/image/6762b890d33d71734523024.webp', 9),
(42, 'INVENTORY MANAGEMENT', 1, 'images/image/6762b926c154e1734523174.webp', 9),
(43, 'PLATFORM OPTIMIZED', 1, 'images/image/6762b99e904931734523294.webp', 9),
(44, 'ACCESS AND OUTREACH', 1, 'images/image/6762b9b1eb9061734523313.webp', 9),
(46, 'ENSURE INVENTORY ACCURACY', NULL, 'images/image/67656583559ed1734698371.webp', 16),
(47, 'GUARANTEE DATA RELIABILITY', NULL, 'images/image/676566928a01c1734698642.webp', 16),
(48, 'OPTIMIZE SUPPLY CHAIN', NULL, 'images/image/676566fbcf3c11734698747.webp', 16),
(49, 'BUILD RETAIL RELATIONSHIPS', NULL, 'images/image/6765671774cfe1734698775.webp', 16),
(50, 'PROVIDE MAREKETING SUPPORT', NULL, 'images/image/6765676fb384a1734698863.webp', 16),
(51, 'ENHANCE CUSTOMER SATISFACTION', NULL, 'images/image/676567f5241261734698997.webp', 16);

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sub_category_id` bigint(20) UNSIGNED NOT NULL,
  `brand_id` bigint(20) UNSIGNED NOT NULL,
  `product_name` varchar(191) NOT NULL,
  `price` double NOT NULL,
  `description` longtext NOT NULL,
  `product_photo` text NOT NULL,
  `product_photos` text DEFAULT NULL,
  `colors` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `products` (`id`, `sub_category_id`, `brand_id`, `product_name`, `price`, `description`, `product_photo`, `product_photos`, `colors`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 'Samsung Galaxy Z Flip6', 939, '256 GB', 'images/product_photo/67065e54a85c11728470612.webp', '[\"images\\/product_photo\\/672216047f5ff1730287108.webp\",\"images\\/product_photo\\/672216049cde71730287108.webp\",\"images\\/product_photo\\/67221604bc85a1730287108.webp\"]', '[{\"color\":\"#767474\",\"name\":\"Grey\"},{\"color\":\"#c8fbb1\",\"name\":\"Mint\"},{\"color\":\"#f5c929\",\"name\":\"Yellow\"},{\"color\":\"#9be9f8\",\"name\":\"Blue\"}]', 1, '2024-10-09 06:34:31', '2024-10-30 16:20:26'),
(3, 1, 1, 'Samsung Galaxy S24 Ultra', 1099, 'Meet Galaxy S24 Ultra, the ultimate form of Galaxy Ultra with a new titanium exterior and a 17.25cm (6.8\") flat display. It\'s an absolute marvel of design.\r\nThe legacy of Galaxy Note is alive and well. Write, tap and navigate with precision your fingers wish they had on the new, flat display.\r\nWith the most megapixels on a smartphone and AI processing, Galaxy S24 Ultra sets the industry standard for image quality every time you hit the shutter. What\'s more, the new ProVisual engine recognizes objects — improving colour tone, reducing noise and bringing out detail.', 'images/product_photo/6708afaa88e3f1728622506.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#a09898\",\"name\":\"Grey\"},{\"color\":\"#c787d9\",\"name\":\"Violet\"},{\"color\":\"#f7f962\",\"name\":\"Titanium Yellow\"},{\"color\":\"#8e99ec\",\"name\":\"Titanium Blue\"},{\"color\":\"#9ce873\",\"name\":\"Titanium Green\"}]', 1, '2024-10-11 09:55:07', '2024-10-30 15:50:31'),
(4, 3, 2, 'EARPHONES  XE28', 20, '\"Up to 30dB Noise Cancellation, 4-Mic AI DNN ENC for Clear Call\r\nPowerful and Rich bass with great master tune 30-Hour Playtime Charge for 15 minutes, Listen for 2 hours, Infinix Phone Pop-up/Smart Welife App\"', 'images/product_photo/6708b36f38ad71728623471.webp', NULL, '[{\"color\":\"#f5f4f4\",\"name\":\"White\"},{\"color\":\"#285c2c\",\"name\":\"Green\"}]', 1, '2024-10-11 10:11:11', '2024-10-24 13:57:20'),
(5, 3, 2, 'EARPHONES  XE29', 18, '\"Wireless Charge , 2-Mic DNN AI ENC for clear cal , BT5.3 Fast and Stable connection\r\nInfinix Phone Pop-up/Smart Welife App , 28-Hour Playtime\r\nSemi In-Ear and Comfortable Lightweight for Comfortable and Secure Fi\"', 'images/product_photo/6708b465bb2891728623717.webp', NULL, '[{\"color\":\"#f8f7f7\",\"name\":\"White\"}]', 1, '2024-10-11 10:15:17', '2024-10-24 13:57:03'),
(6, 3, 2, 'EARPHONES  XE31', 15, '\"7/30 Hours Long Play time, 13mm powerful and rich Bass Sound, 1-MIC AI ENC for Clear Call\r\nInfinix Phone Pop-up/Smart Welife App, One-Step Fast Pair, Semi In-Ear and Lightweight\r\nComfortable and Secure Fit\"', 'images/product_photo/6708b4dd13d521728623837.webp', NULL, '[{\"color\":\"#fffafa\",\"name\":\"White\"}]', 1, '2024-10-11 10:17:17', '2024-10-24 13:56:50'),
(7, 4, 2, 'Data Cable  XDL52A', 5, 'USB A to Lightning Support 2.4A high current, 12W，1M Length TYPE fireproof material', 'images/product_photo/6708b5780e5371728623992.webp', NULL, '[{\"color\":\"#ffffff\",\"name\":\"White\"}]', 1, '2024-10-11 10:19:52', '2024-10-24 13:56:34'),
(9, 4, 2, 'Data Cable  XDC53A', 5, 'USB A to TYPE C 3A current, 1M length TYPE fireproof material', 'images/product_photo/6708ce42d70b01728630338.webp', NULL, '[{\"color\":\"#fcf7f7\",\"name\":\"White\"}]', 1, '2024-10-11 12:05:39', '2024-10-24 13:55:48'),
(10, 4, 2, 'Data Cable  XDC53', 5, 'TYPE C to TYPE C\r\nSupport 3A high current, 60W, charging Smartphone , Apple and Laptop ,1M length\r\nTYPE fireproof material', 'images/product_photo/6708cea2a1a151728630434.webp', NULL, '[{\"color\":\"#f9f6f6\",\"name\":\"White\"}]', 1, '2024-10-11 12:07:14', '2024-10-24 13:54:53'),
(11, 5, 2, 'WATCH  XW3E', 35, '1.43\" AMOLED Large Screen, Premium Metal Body, Digital Crown、Free Wireless Charge\r\nClear Bluetooth Call, Comprehensive Health Monitoring, Multiple Sports Modes、200+ Stylish Watch Faces, IP68 Waterproof, My Health App.', 'images/product_photo/6708d26eaa17b1728631406.webp', NULL, '[{\"color\":\"#656161\",\"name\":\"Grey\"}]', 1, '2024-10-11 12:12:53', '2024-10-24 14:00:27'),
(12, 5, 2, 'WATCH  XW3', 23, '2.01” G+F 240*296, 24/7 HRM, More Skin/Hair/Scars, Comprehensive Health Monitor\r\nWaterproof IP68, My Health App', 'images/product_photo/6708d260331b01728631392.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#2a7e2b\",\"name\":\"Green\"}]', 1, '2024-10-11 12:15:33', '2024-10-24 13:59:59'),
(13, 5, 2, 'WATCH  XW3P', 35, '2.13\" AMOLED Large Curved Screen, Premium Metal Body, Digital Crown, Clear Bluetooth Call\r\nComprehensive Health Monitoring, 123 Sports Modes, 100+ Stylish Watch Faces, IP68 Waterproof\r\nMy Health App', 'images/product_photo/6708d2e9cae9d1728631529.webp', NULL, '[{\"color\":\"#5f5d5d\",\"name\":\"Grey\"}]', 1, '2024-10-11 12:25:30', '2024-10-24 13:59:40'),
(14, 1, 2, 'WATCH  XW3GT', 43, '1.53” G+F 360*360, Clear Bluetooth Calling, Aluminum alloy Metal Case, 7-10 days work time(BT Call Off), Comprehensive Health Monitor, Waterproof IP68, My Health App, Digital Crown\r\nCustomized Watch faces', 'images/product_photo/6708d749940441728632649.webp', NULL, '[{\"color\":\"#ff7b00\",\"name\":\"Orange\"}]', 1, '2024-10-11 12:27:39', '2024-11-06 18:14:09'),
(15, 5, 2, 'WATCH  XW1', 23, '1.83” 240*284 G+F   Advance Bluetooth Calling, 24/7 HRM, More Skin/Hair/Scars\r\nClear True Blood oxygen, 123+ actvities & 100+ faces, Waterproof IP68, My Health App', 'images/product_photo/6708d3a31dd9e1728631715.webp', NULL, '[{\"color\":\"#bfbaba\",\"name\":\"Silver\"}]', 1, '2024-10-11 12:28:35', '2024-10-24 13:58:30'),
(16, 6, 2, 'GT20  GAMING KIT', 18, 'GT MECHA CASE, Designed for Infinix GT 20 Pro. Compatible with GT Cooling Fan.\r\nLight-weight and compact built for seamless fit and feel.Improved durability and gaming experience on Infinix GT 20 Pro.\r\nGT COOLING FAN, Compatible with magnetic cases. Designed for GT 20 Pro.\r\nCompact and light-weight. Mecha inspired design. High speed and silent operation for best gaming experience.', 'images/product_photo/6708d413f151b1728631827.webp', NULL, NULL, 1, '2024-10-11 12:30:28', '2024-10-11 12:32:44'),
(17, 7, 2, 'Power Bank  XP05', 12, 'Max Charging Speed 12W, Volume：5000mAh, USB A/TPYE C OUTPUT, Own 30CM USD A to C Cable', 'images/product_photo/6708d5b3211f01728632243.webp', NULL, '[{\"color\":\"#e9a0e6\",\"name\":\"Purple\"}]', 1, '2024-10-11 12:37:23', '2024-10-24 13:58:13'),
(18, 7, 2, 'Power Bank  XP03', 14, 'Max Charging Speed 18W, Magnetic charge , Volume：3000mAh', 'images/product_photo/6708d6d2cf9051728632530.webp', NULL, '[{\"color\":\"#ffffff\",\"name\":\"White\"}]', 1, '2024-10-11 12:42:10', '2024-10-24 13:57:59'),
(19, 1, 2, 'Infinix smart 8', 300, '3GB/64GB Timber Black\r\nInfinix Smart 8: Unleash the Power Within\r\nBrace yourself for a smartphone that redefines expectations. The all-new Infinix Smart 8 has arrived at Moosani.pk, packing a punch that will leave you speechless. Here\'s why the Infinix Smart 8 is the perfect companion for your everyday adventures:\r\n\r\nSpeedy Processor: Experience seamless multitasking and lag-free gaming with the Infinix Smart 8\'s powerful processor.\r\nLong-lasting Battery: Power through your day without worry thanks to the Smart 8\'s impressive battery life.\r\nAmple Storage: Store all your favorite apps, games, photos, and videos with the Smart 8\'s generous storage capacity.\r\nCapture Stunning Visuals:\r\n\r\nExceptional Camera: The Smart 8 boasts an advanced camera system that captures breathtaking photos and videos, day or night.\r\nImmersive Display: Enjoy vibrant colors and sharp details on the Smart 8\'s high-resolution display.\r\nDesigned for You:\r\n\r\nSleek and Stylish: The Smart 8\'s modern design makes a statement wherever you go.\r\nUser-friendly Interface: Navigate your phone effortlessly with the Smart 8\'s intuitive interface.', 'images/product_photo/670905a2acfa41728644514.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#337547\",\"name\":\"Green\"},{\"color\":\"#cbc3c3\",\"name\":\"Silver\"}]', 1, '2024-10-11 16:01:54', '2024-10-24 14:13:38'),
(20, 1, 2, 'Infinix Smart 9', 0, 'The Infinix Smart 9 (4GB+128GB) variant is a budget-friendly smartphone that offers a solid combination of performance and storage. Another variant of the Infinix Smart 9 is the 3GB+64GB model. The primary difference lies in its memory and storage capacity.', 'images/product_photo/67090a166c9ee1728645654.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Starlit Black\"},{\"color\":\"#8bacd0\",\"name\":\"palm blue\"},{\"color\":\"#ddb64b\",\"name\":\"horizon gold\"},{\"color\":\"#8ed78f\",\"name\":\"starfall green\"}]', 1, '2024-10-11 16:12:23', '2024-11-06 18:10:20'),
(21, 1, 2, 'Infinix Hot 40i', 100, '6.56″ IPS LCD, 90Hz\r\nAndroid 13, XOS 13\r\nUp to 16GB RAM (8+8)\r\n256GB of Storage\r\n50MP Main Camera\r\n32MP Selfie Camera\r\nFingerprint (side-mounted)\r\n5000mAh Battery\r\n18W wired Charging\r\n1 Year Warranty', 'images/product_photo/6709092d22f7f1728645421.webp', NULL, '[{\"color\":\"#6aa0d2\",\"name\":\"Palm Blue\"},{\"color\":\"#e8c930\",\"name\":\"Horizon Gold\"},{\"color\":\"#7de170\",\"name\":\"Starfall Green\"},{\"color\":\"#000000\",\"name\":\"Starlit Black\"}]', 1, '2024-10-11 16:17:01', '2024-11-06 18:09:58'),
(22, 1, 2, 'Infinix Hot 40', 100, '6.78″ IPS LCD, 90Hz\r\nAndroid 13, XOS 13.5\r\nMediatek Helio G88 (12nm)\r\nUp to 16GB RAM (8+8)\r\n256GB of Storage\r\nDual Camera 50MP + 2MP\r\nSelfie Camera 32MP\r\n5000mAh Battery\r\n33W wired Charging', 'images/product_photo/67090a75a66931728645749.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Starlit Black\"},{\"color\":\"#529cbc\",\"name\":\"Palm Blue\"},{\"color\":\"#b0eaa9\",\"name\":\"Green\"},{\"color\":\"#eac953\",\"name\":\"Titan Gold\"}]', 1, '2024-10-11 16:22:29', '2024-11-06 18:09:40'),
(23, 1, 2, 'Infinix Hot 50i', 100, '6.7″ Display, 120Hz\r\nAndroid 14\r\nHelio G81 Processor\r\nUp to 8GB RAM (4+4)\r\n256GB of Storage\r\n48MP Main Camera\r\n8MP Selfie Camera\r\n5000mAh Battery\r\n18W Fast Charge\r\n1 Year Warranty', 'images/product_photo/67090aa05738f1728645792.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#e0a2ec\",\"name\":\"Purple\"},{\"color\":\"#c4bbbb\",\"name\":\"Silver\"},{\"color\":\"#929fe3\",\"name\":\"Palm Blue\"}]', 1, '2024-10-11 16:23:12', '2024-11-06 18:09:19'),
(24, 1, 2, 'Infinix Hot 40i 4GB', 100, '6.56″ IPS LCD, 90Hz\r\nAndroid 13, XOS 13\r\nUp to 8GB RAM (4+4)\r\n128GB of Storage\r\n50MP Main Camera\r\n32MP Selfie Camera\r\nFingerprint (side-mounted)\r\n5000mAh Battery\r\n18W wired Charging\r\n1 Year Warranty', 'images/product_photo/67090aef5c7941728645871.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Starlit Black\"},{\"color\":\"#8ba9da\",\"name\":\"Palm Blue\"},{\"color\":\"#edcb50\",\"name\":\"Horizon Gold\"},{\"color\":\"#1c4020\",\"name\":\"Starfall Green\"}]', 1, '2024-10-11 16:24:31', '2024-11-06 18:09:03'),
(25, 1, 2, 'InfinIx Note 40 4G', 1000, '6.78″ AMOLED, 120Hz, 1300 nits (peak)\r\nAndroid 14, XOS 14\r\nMediatek Helio G99 Ultimate\r\nUp to 24GB RAM (12+12)\r\n256GB of Storage\r\nTriple Camera 108MP + 2MP + 2MP\r\nSelfie Camera 32MP\r\nFingerprint (under display, optical)\r\n5000mAh Battery\r\n70W wired, 20W wireless MagCharge\r\n1 Year Warranty', 'images/product_photo/67090b510fe281728645969.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#f9be3e\",\"name\":\"Titan Gold\"}]', 1, '2024-10-11 16:26:09', '2024-11-06 18:07:55'),
(26, 1, 2, 'Infinix Note 40 Pro 4G', 100, '6.78″ AMOLED, 120Hz, 1300 nits (peak)\r\nAndroid 14, XOS 14\r\nMediatek Helio G99 Ultimate\r\nUp to 16GB RAM (8+8)\r\n256GB of Storage\r\nTriple Camera 108MP + 2MP + 2MP\r\nSelfie Camera 32MP\r\nFingerprint (under display, optical)\r\n5000mAh Battery\r\n70W wired, 20W wireless MagCharge\r\n1 Year Warranty', 'images/product_photo/67090b7ae66911728646010.webp', NULL, '[{\"color\":\"#ffbf52\",\"name\":\"Titan Gold\"},{\"color\":\"#18351a\",\"name\":\"Vintage Green\"}]', 1, '2024-10-11 16:26:51', '2024-11-06 18:08:33'),
(27, 1, 2, 'Infinix Note 40 Pro Plus 5G', 100, '6.78″ AMOLED, 1B colors, 120Hz, 1300 nits (peak)\r\nAndroid 14, XOS 14\r\nMediatek Dimensity 7020 (6 nm)\r\nUp to 24GB RAM (12+12)\r\n256GB of Storage\r\nTriple Camera 108MP + 2MP + 2MP\r\nSelfie Camera 32MP\r\nFingerprint (under display, optical)\r\n4600mAh Battery\r\n100W wired Charging\r\n20W wireless MagCharge\r\nReverse wired and wireless charging\r\n1 Year Warranty', 'images/product_photo/67090ba5ccc901728646053.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#1a471d\",\"name\":\"Green\"}]', 1, '2024-10-11 16:27:33', '2024-11-06 18:11:33'),
(28, 1, 2, 'Infinix GT 20 Pro 5G', 100, '6.78″ AMOLED, 1B colors, 144Hz, 1300 nits (peak)\r\nAndroid 14, XOS 14\r\nMediatek Dimensity 8200 Ultimate (4 nm)\r\nUp to 24GB RAM (12+12)\r\n256GB of Storage\r\nTriple Camera 108MP + 2MP + 2MP\r\nSelfie Camera 32MP\r\nFingerprint (under display, optical)\r\nCustomizable RGB LEDs on the back\r\n5000mAh Battery\r\n45W wired, PD3 Charging\r\n1 Year Warranty', 'images/product_photo/67090be785d2d1728646119.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#c9c0c0\",\"name\":\"Silver\"},{\"color\":\"#10034f\",\"name\":\"Navy Blue\"}]', 1, '2024-10-11 16:28:39', '2024-11-06 18:11:46'),
(29, 1, 2, 'Infinix Zero 40 5G', 100, '6.78″ AMOLED 3D-Curved, 144Hz\r\nAndroid 14\r\nDimensity 8200 Ultimate 5G (4 nm)\r\nUp to 24GB RAM (12+12)\r\n512GB of Storage\r\nTriple Camera 108MP + 50MP + 2MP\r\nSelfie Camera 50MP\r\n5000mAh Battery\r\n45W Super Charge\r\n20W wireless\r\n1 Year Warranty', 'images/product_photo/67090c1cf11ab1728646172.webp', NULL, '[{\"color\":\"#c266b1\",\"name\":\"Purple\"},{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#c3b7b7\",\"name\":\"Silver\"}]', 1, '2024-10-11 16:29:33', '2024-11-06 18:12:01'),
(30, 1, 2, 'Infinix XPad', 155, '11″ FHD+ Bright Display, 90Hz\r\nAndroid 14\r\nHelio G99\r\n4GB + 128GB\r\nFolax AI Voice Assistant\r\n4 Speakers Stereo Sound\r\nMain Camera 8MP\r\nSelfie Camera 8MP\r\n7000mAh Battery\r\nWifi\r\nModel X1101\r\n1 Year Warranty\r\n120 Days Screen Warranty', 'images/product_photo/67090c4d763791728646221.webp', NULL, '[]', 1, '2024-10-11 16:30:21', '2024-11-06 18:12:15'),
(35, 8, 4, 'Mi Router 4C', 0, 'Single band - 2.4GHz\r\nWireless securit - WPA-PSK/WPA2-PSK encryption, wireless access control (blacklist and whitelist), SSID hiding.', 'images/product_photo/671a19ef4f76c1729763823.webp', NULL, '[]', 1, '2024-10-24 14:57:03', '2024-10-24 14:58:29'),
(36, 8, 4, 'Mi Router 4A', 0, '4 external antennas - 2.4GHz - the max wireless speed is up to 1167Mbps\r\nLarge 64 MB memory for stable connection of 64 devices\r\nControl remotely via app Parental Control', 'images/product_photo/671a1adc1b9491729764060.webp', NULL, NULL, 1, '2024-10-24 15:01:00', '2024-10-24 15:01:00'),
(37, 8, 4, 'Xiaomi Wifi Range Extender N300', 0, 'Dimensions - 80x54x70mm Signal Rate - 2.4GHz, up to 300Mbps\r\nWireless Security - WPA-PSK/ WPA2-PSK encryption\r\nPower Supply - 100-240V/0.35A', 'images/product_photo/671a1b682c9fa1729764200.webp', NULL, '[]', 1, '2024-10-24 15:02:14', '2024-10-24 15:03:20'),
(38, 8, 4, 'Xiaomi Router AC1200', 0, 'Dual-core 880MHz - 2.4 GHz Wi-Fi up to 5 GHz Wi-Fi ROM - 16MB\r\nProduct memory - 128MB DDR3\r\n4 external omni-directional high performance antennas', 'images/product_photo/671a1b9e203631729764254.webp', NULL, NULL, 1, '2024-10-24 15:04:14', '2024-10-24 15:04:14'),
(39, 8, 4, 'Xiaomi Mesh System AC1200', 0, 'Internal antennas - 2.4 GHz Wi-Fi up to 5 GHz Wi-Fi\r\n2 × 10/100/1000 Mbps WAN/LAN auto-sensing port\r\nWPA-PSK/WPA2-PSK/WPA3-SAE encryption', 'images/product_photo/671a1beea2d081729764334.webp', NULL, NULL, 1, '2024-10-24 15:05:34', '2024-10-24 15:05:34'),
(40, 9, 4, 'Redmi Buds 4 Ative Black/White', 0, 'Earbuds - 1040 (34mah) Charging case - 440mAh\r\nType-C Communication range- 10m Speaker impedance - 32Ω', 'images/product_photo/671a1c7eecbea1729764478.webp', NULL, NULL, 1, '2024-10-24 15:07:59', '2024-10-24 15:07:59'),
(41, 9, 4, 'Redmi Buds 5-Black', 0, 'Earbuds - 54mAh Charging case - 480mAh Type-C', 'images/product_photo/671a1cbaa765f1729764538.webp', NULL, NULL, 1, '2024-10-24 15:09:00', '2024-10-24 15:09:00'),
(42, 9, 4, 'Redmi Buds 6 Play Black', 0, 'Earbuds - 57mAh Charging case - 600mAh TYPE-C', 'images/product_photo/671a1d12b81721729764626.webp', NULL, NULL, 1, '2024-10-24 15:10:27', '2024-10-24 15:10:27'),
(43, 10, 4, 'Xiaomi Smart Camera C301', 0, 'Resolution - 2304 × 1296\r\nCompatible with - Android 8.0 & iOS 12.0 or above\r\nMicroSD card (8 GB–256 GB supported)/Cloud storage', 'images/product_photo/671a1d6f37c7e1729764719.webp', NULL, NULL, 1, '2024-10-24 15:11:59', '2024-10-24 15:11:59'),
(44, 10, 4, 'Xiaomi Smart Camera C400', 0, 'Resolution - 2560 × 1440\r\nStorage - microSD card (up to 256 GB)\r\nWi-Fi 5GHz', 'images/product_photo/671a1de21af761729764834.webp', NULL, NULL, 1, '2024-10-24 15:13:54', '2024-10-24 15:13:54'),
(45, 10, 4, 'Xiaomi Smart Camera C500 Pro', 0, 'Resolution - 2960 x 1666\r\nStorage - MicroSD card (8GB–256GB)\r\nWireless Connectivity - 2.4GHz/5GHz', 'images/product_photo/671a1e43dd7a81729764931.webp', NULL, NULL, 1, '2024-10-24 15:15:32', '2024-10-24 15:15:32'),
(46, 10, 4, 'Xiaomi Smart Camera C200', 0, 'Resolution - 1920 × 1080 Input - 5V DC 2A\r\nStorage - MicroSD card (up to 256 GB) Wi-Fi 2.4GHZ', 'images/product_photo/671a1e93dc3fa1729765011.webp', NULL, NULL, 1, '2024-10-24 15:16:51', '2024-10-24 15:16:51'),
(47, 5, 4, 'Redmi Watch 3 Active Black/Gray', 0, 'Heart rate sensor (with blood oxygen sensor). Battery 289mAh\r\nDisplay -1.83 inch LCD Resolution: 240×280 pixel Microphone Speaker 5ATM water resistant', 'images/product_photo/671a1ed405f161729765076.webp', NULL, NULL, 1, '2024-10-24 15:17:56', '2024-10-24 15:17:56'),
(48, 5, 4, 'Xiaomi Watch S3 Black Silver', 0, 'Display -1.43\" AMOLED display, 466 × 466, 326PPI\r\nBattery - 486mAh Lithium-ion polymer battery Water Resistance Rating - 5ATM Sensors - Heart rate sensor Microphone Speakers', 'images/product_photo/671a1f0ae20061729765130.webp', NULL, NULL, 1, '2024-10-24 15:18:52', '2024-10-24 15:18:52'),
(49, 5, 4, 'Xiaomi Smart Band 8 Active Black', 0, 'Dimensions -42.81mm × 25.42mm × 9.99mm Resolution - 172 x 320 pixels\r\nCapacity - 210mAh Heart rate monitoring, SpO₂ tracking, Sleep tracking, Female health tracking, Stress level measurement, 5ATM water resistant', 'images/product_photo/671a1f60bf8421729765216.webp', NULL, NULL, 1, '2024-10-24 15:20:16', '2024-10-24 15:20:16'),
(50, 11, 4, 'Xiaomi Wireless Mouse Lite', 0, '2.4GHz wireless connection Compatible with Windows 10 Rated input - 1.5V 50mA', 'images/product_photo/671a1fddc32a31729765341.webp', NULL, NULL, 1, '2024-10-24 15:22:22', '2024-10-24 15:22:22'),
(51, 11, 4, 'Mi Dual Mode Wireless Mouse Black White', 0, 'Operating Distance - 8m Input parameters - 3V = 10mA\r\nWireless connection - Low-power consumption Bluetooth 3.0+Bluetooth 5.0, 2.4GHz', 'images/product_photo/671a202c465221729765420.webp', NULL, NULL, 1, '2024-10-24 15:23:40', '2024-10-24 15:23:40'),
(52, 11, 4, 'Xiaomi Wireless Keyboard and Mouse Combo', 0, '436.5 x 127.5 x 27.5mm (keyboard) 113 x 60 x 36mm (mouse)\r\nCompatible with Windows 10 1.5V ⎓ 50mA (keyboard) 1.5V ⎓ 50mA (mouse)', 'images/product_photo/671a206c26e051729765484.webp', NULL, NULL, 1, '2024-10-24 15:24:44', '2024-10-24 15:24:44'),
(53, 11, 4, 'Mi 20W Wireless Charging Stand', 0, 'Input Parameters - 5V=2A/9V=1.6A/12V–16V– 1.7A max Output Parameters  20W max Input Port - USB-C', 'images/product_photo/671a20d01a6ff1729765584.webp', NULL, NULL, 1, '2024-10-24 15:26:24', '2024-10-24 15:26:24'),
(54, 1, 4, 'Redmi A3', 0, 'Display: 6.71 IPS LCD\r\nProcessor: Octa-core\r\nRam: 3GB/4GB\r\nRom: 64GB/ 128 GB\r\nBattery: 5000 MAH\r\nCharger: 10W type C\r\nMain Camera: 8 MP\r\nSelfie Camera: 5MP', 'images/product_photo/671a2bfc556d21729768444.webp', NULL, '[{\"color\":\"#284e1d\",\"name\":\"Green\"},{\"color\":\"#000000\",\"name\":\"Black\"},{\"color\":\"#6d86e8\",\"name\":\"Blue\"}]', 1, '2024-10-24 15:36:32', '2024-10-24 16:14:04'),
(55, 1, 4, 'Redmi 13C', 0, 'Display: 6.71 IPS LCD\r\nProcessor: Octa-core\r\nRam: 4GB/6GB/8GB\r\nRom: 128 GB/ 256 GB\r\nBattery: 5000 MAH\r\nCharger: 18 W type C\r\nMain Camera: 50 MP\r\nSelfie Camera: 5 MP', 'images/product_photo/671a2d9d7717c1729768861.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Midnight Black\"},{\"color\":\"#0d144a\",\"name\":\"Navy Blue\"},{\"color\":\"#eee7e7\",\"name\":\"Glacier White\"},{\"color\":\"#1d4920\",\"name\":\"Clover Green\"}]', 1, '2024-10-24 15:39:32', '2024-10-24 16:21:01'),
(56, 1, 4, 'Redmi 13', 0, 'Display: 6.79 IPS LCD\r\nProcessor: Octa-core\r\nRam: 6GB/8GB/8GB\r\nRom: 128 GB/ 256 GB\r\nBattery: 5030 MAH\r\nCharger: 33 W type C\r\nMain Camera: 108 MP\r\nSelfie Camera: 13 MP', 'images/product_photo/671a2b4e3ede31729768270.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Midnight Black\"},{\"color\":\"#a3e59e\",\"name\":\"Mint Green\"},{\"color\":\"#574dea\",\"name\":\"Ice Blue\"},{\"color\":\"#f2a069\",\"name\":\"Ocean Sunset\"}]', 1, '2024-10-24 15:41:51', '2024-10-24 16:22:09'),
(57, 1, 4, 'Redmi Note 13', 0, 'Display: 6.67 AMOLED\r\nProcessor: Octa-core\r\nRam: 8GB\r\nRom: 256 GB\r\nBattery: 5000 MAH\r\nCharger: 33 W type C\r\nMain Camera: 108 MP\r\nSelfie Camera: 16 MP', 'images/product_photo/671a2d3ec642b1729768766.webp', NULL, '[{\"color\":\"#a5f490\",\"name\":\"Mint Green\"},{\"color\":\"#0850f7\",\"name\":\"Ice Blue\"},{\"color\":\"#000000\",\"name\":\"Midnight Black\"},{\"color\":\"#e1a06b\",\"name\":\"Ocean Sunset\"}]', 1, '2024-10-24 15:44:11', '2024-10-24 16:19:27'),
(58, 1, 4, 'Redmi Note 13 Pro', 0, 'Display: 6.67 AMOLED\r\nProcessor: Octa-core\r\nRam: 8 GB/ 12 GB\r\nRom: 256 GB/ 512 GB\r\nBattery: 5100 MAH\r\nCharger: 67 W type C\r\nMain Camera: 200 MP\r\nSelfie Camera: 16 MP', 'images/product_photo/671a2afe9cae31729768190.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Midnight Black\"},{\"color\":\"#0d7314\",\"name\":\"Forest Green\"},{\"color\":\"#6f0f76\",\"name\":\"Lavender Purple\"}]', 1, '2024-10-24 15:46:26', '2024-10-24 16:09:50'),
(59, 1, 4, 'Redmi Note 13 Pro+ 5G', 0, 'Display: 6.67 AMOLED\r\nProcessor: Octa-core\r\nRam: 12 GB\r\nRom: 512 GB\r\nBattery: 5000 MAH\r\nCharger: 120 W type C\r\nMain Camera: 200 MP\r\nSelfie Camera: 16 MP', 'images/product_photo/671a2ccd3e7381729768653.webp', NULL, '[{\"color\":\"#000000\",\"name\":\"Midnight Black\"},{\"color\":\"#ebebeb\",\"name\":\"Moonlight White\"},{\"color\":\"#fdaafa\",\"name\":\"Aurora Purple\"}]', 1, '2024-10-24 15:48:22', '2024-10-24 16:17:33'),
(60, 2, 4, 'Pad SE', 0, 'Display:11 IPS LCD\r\nProcessor: Octa-core\r\nRam: 8 GB\r\nRom: 256 GB\r\nBattery: 8000 MAH\r\nCharger: 18 W type C\r\nMain Camera: 8 MP\r\nSelfie Camera: 5 MP', 'images/product_photo/671a266e361481729767022.webp', NULL, NULL, 1, '2024-10-24 15:50:22', '2024-10-24 15:50:22'),
(61, 1, 2, 'tonia test', 0, 'hello world', 'images/product_photo/676588e03508c1734707424.webp', NULL, NULL, 1, '2024-12-20 21:10:24', '2024-12-20 21:10:24');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` longtext NOT NULL,
  `service_photo` text NOT NULL,
  `service_photo_details` text NOT NULL,
  `banner` varchar(1000) DEFAULT NULL,
  `link` varchar(1500) DEFAULT NULL,
  `mount_of_lebanon` text DEFAULT NULL,
  `bekaa` text DEFAULT NULL,
  `south_leabanon` text DEFAULT NULL,
  `beirut` text DEFAULT NULL,
  `north_lebanon` text DEFAULT NULL,
  `main_office` text DEFAULT NULL,
  `so_number` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `title`, `description`, `service_photo`, `service_photo_details`, `banner`, `link`, `mount_of_lebanon`, `bekaa`, `south_leabanon`, `beirut`, `north_lebanon`, `main_office`, `so_number`, `created_at`, `updated_at`) VALUES
(8, 'Retail Presence', '<p>Arabia Mobiles covers a wide network of stores across regions, offering top brands to meet diverse customer needs.</p>', 'images/service_photo/676293856aad41734513541.webp', 'images/service_photo/67629385cf3fd1734513541.webp', 'images/service_photo/676293863837a1734513542.webp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, '2024-10-11 13:07:05', '2024-12-23 19:53:11'),
(9, 'Online Presence', '<p>We hold exclusive partnerships with online and offline retailers, supplying them with stock and overseeing their business operations.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', 'images/service_photo/6762933c2df781734513468.webp', 'images/service_photo/6762933c9be2e1734513468.webp', 'images/service_photo/6762933d02d651734513469.webp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, '2024-10-11 13:08:34', '2024-12-23 19:54:28'),
(10, 'Marketing Tactics', '<p>The Marketing team at Arabia Mobiles executes supplier-directed strategies to elevate the brands we distribute. Through strategic promotions, targeted sponsorships, and dynamic activations, we utilize detailed market research and advanced branding to seamlessly position our partners as industry leaders.</p>\r\n\r\n<p>&nbsp;</p>', 'images/service_photo/67657418abde71734702104.webp', 'images/service_photo/676574192911c1734702105.webp', 'images/service_photo/6765741988cf01734702105.webp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-10-11 13:11:43', '2024-12-23 19:53:33'),
(11, 'Arabia Care – Service Center', '<p>Arabia Mobiles has an in-house team offering exclusive after-sales for brands with fast, free collection and delivery. Service points across all over Lebanon.</p>', 'images/service_photo/676573e14f1a31734702049.webp', 'images/service_photo/676573e19916d1734702049.webp', 'images/service_photo/676290ef58de81734512879.webp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, '2024-10-11 13:12:56', '2024-12-23 19:54:40'),
(14, 'Market Distribution', '<p><strong>Sales is passion: </strong>one is born with sales skills and his potential shall flourish within the right company and team by following the company&rsquo;s strategy and goals.<br />\r\nSetting goals for a sales team can give everyone a target at which to aim.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Sales manager</strong></p>\r\n\r\n<p><strong>961 81 312280</strong></p>', 'images/service_photo/67628e1540d601734512149.webp', 'images/service_photo/67628e78e08de1734512248.webp', 'images/service_photo/67628c16e89251734511638.webp', NULL, '<ul>\r\n	<li><strong>Mount Lebanon</strong>\r\n	<ul>\r\n		<li>81-312276</li>\r\n	</ul>\r\n	</li>\r\n	<li><strong>Keserwen</strong>\r\n	<ul>\r\n		<li>81-312275</li>\r\n	</ul>\r\n	</li>\r\n	<li><strong>Mount Lebanon - Aley - Chouf</strong>\r\n	<ul>\r\n		<li>81-107869</li>\r\n	</ul>\r\n	</li>\r\n</ul>', '<ul>\r\n	<li><strong>Beqaa- Baalbeck</strong>\r\n	<ul>\r\n		<li>81-291190</li>\r\n	</ul>\r\n	</li>\r\n	<li><strong>West Beqaa</strong>\r\n	<ul>\r\n		<li>81-107868</li>\r\n	</ul>\r\n	</li>\r\n	<li><strong>Beqaa- Zahle</strong>\r\n	<ul>\r\n		<li>81-312277</li>\r\n	</ul>\r\n	</li>\r\n</ul>', '<ul>\r\n	<li><strong>South - Saida - Sour</strong>\r\n	<ul>\r\n		<li>81-312274</li>\r\n	</ul>\r\n	</li>\r\n	<li><strong>South - Nabatiyeh - Bint Jbeil</strong>\r\n	<ul>\r\n		<li>81-312274</li>\r\n	</ul>\r\n	</li>\r\n</ul>', '<ul>\r\n	<li><strong>Dahiyeh</strong>\r\n	<ul>\r\n		<li>81-291160</li>\r\n	</ul>\r\n	</li>\r\n	<li><strong>Beirut Central</strong>\r\n	<ul>\r\n		<li>70-382300</li>\r\n	</ul>\r\n	</li>\r\n</ul>', '<ul>\r\n	<li><strong>North - Tripoli - Zgharta</strong>\r\n	<ul>\r\n		<li>81-114434</li>\r\n	</ul>\r\n	</li>\r\n	<li><strong>North - Tripoli- Akkar</strong>\r\n	<ul>\r\n		<li>81-107867</li>\r\n	</ul>\r\n	</li>\r\n</ul>', '<ul>\r\n	<li><strong>Key Account:</strong>\r\n	<ul>\r\n		<li>79176111</li>\r\n	</ul>\r\n	</li>\r\n</ul>', 1, '2024-10-31 15:06:38', '2024-12-23 19:53:49'),
(16, 'Field Force', '<p>Our <strong>Field Force</strong> comprises a dedicated team ensuring coverage across Lebanon. Key functions include maintaining inventory accuracy, ensuring data reliability, optimizing supply chain efficiency, strengthening retail relationships, providing marketing support, and enhancing customer satisfaction.</p>', 'images/service_photo/6765623fb764f1734697535.webp', 'images/service_photo/676562402a8d21734697536.webp', 'images/service_photo/67656240822831734697536.webp', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, '2024-12-20 18:20:49', '2024-12-23 19:54:06');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `subtitle` varchar(191) DEFAULT NULL,
  `mission` text DEFAULT NULL,
  `vision` text DEFAULT NULL,
  `founder_message` text DEFAULT NULL,
  `mission_vision_photo` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `title`, `subtitle`, `mission`, `vision`, `founder_message`, `mission_vision_photo`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, 'Our mission is to deliver exceptional value to our customers by providing high-quality mobile solutions complemented by unparalleled service. We are committed to enhancing user experiences through comprehensive support and cutting-edge technology. By nurturing strong partnerships and maintaining operational excellence, we strive to meet the evolving needs of our customers and exceed their expectations in every interaction.', 'Our vision is to establish Arabia Mobiles as the foremost distributor of mobile technology across the Middle East, setting the industry standard for innovation and customer satisfaction. We aim to continuously advance our technological footprint and market influence, ensuring that we lead the way in connecting people with the latest and most effective mobile solutions.', 'From the beginning, Arabia Mobiles has aspired to be more than just a leader in mobile brands. Our vision was to establish a holding company that not only excels in sales but also provides exceptional customer care, thereby forging strong relationships with our retailers to deliver comprehensive solutions for our clients.\r\nThis dedication to integrated distribution and outstanding service has elevated us to the regional stage. As such, we continue to prioritize robust connections and uphold the highest standards of service. Our success story is a testament to our unwavering commitment to excellence and growth, solidifying our role as a crucial partner in the communications industry.', 'images/mission_vision_photo/6708e65639ef51728636502.webp', '2024-10-10 17:20:59', '2024-10-11 13:48:22');

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

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `subtitle` varchar(191) NOT NULL,
  `discover_more_link` text NOT NULL,
  `video_link` text DEFAULT NULL,
  `photo` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `sliders` (`id`, `title`, `subtitle`, `discover_more_link`, `video_link`, `photo`, `created_at`, `updated_at`) VALUES
(1, 'Innovative', 'Mobile distribution', 'http://127.0.0.1:8000/arabia_mobiles/contacts', '', 'images/photo/6707e0af453ab1728569519.webp', '2024-10-10 10:24:17', '2024-12-20 18:43:59'),
(2, 'Strategic', 'Mobile distribution', 'http://127.0.0.1:8000/arabia_mobiles/contacts', 'SyevPr8j8lk', 'images/photo/6707e0a45a2e81728569508.webp', '2024-10-10 10:24:38', '2024-12-20 18:44:50'),
(3, 'Reliable & Leaders In', 'Mobile distribution', 'http://127.0.0.1:8000/arabia_mobiles/contacts', NULL, 'images/photo/6707e09a7cb311728569498.webp', '2024-10-10 10:24:59', '2024-10-11 16:59:10');

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `category_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 'sub category one', '2024-10-08 19:31:22', '2024-10-08 19:31:22'),
(2, 2, 'sub category two', '2024-10-08 19:31:22', '2024-10-08 19:31:22'),
(3, 3, 'Earphones', '2024-10-08 19:31:22', '2024-10-11 10:11:29'),
(4, 3, 'Cables', '2024-10-08 19:31:22', '2024-10-11 10:11:36'),
(5, 3, 'Smart Watches', '2024-10-08 19:31:22', '2024-10-11 10:11:43'),
(6, 3, 'Gaming tool', '2024-10-11 12:32:18', '2024-10-11 12:32:18'),
(7, 3, 'Power Bank', '2024-10-11 12:38:52', '2024-10-11 12:38:52'),
(8, 3, 'Router', '2024-10-24 14:46:11', '2024-10-24 14:46:11'),
(9, 3, 'Earbuds', '2024-10-24 15:07:21', '2024-10-24 15:07:21'),
(10, 3, 'Smart Camera', '2024-10-24 15:11:00', '2024-10-24 15:11:00'),
(11, 3, 'Wireless Mouse', '2024-10-24 15:21:03', '2024-10-24 15:21:03');

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

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `position` varchar(191) NOT NULL,
  `linkedin` varchar(191) NOT NULL,
  `photo` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` (`id`, `name`, `position`, `linkedin`, `photo`, `created_at`, `updated_at`) VALUES
(5, 'Elie Khoury', 'CEO', 'https://www.linkedin.com/', 'images/photo/670824bbb4cd31728586939.webp', '2024-10-11 00:02:20', '2024-10-11 00:02:20'),
(6, 'Georges Khoury', 'General Manager', 'https://www.linkedin.com/', 'images/photo/67082501796ef1728587009.webp', '2024-10-11 00:03:30', '2024-10-11 00:03:30'),
(7, 'Gilbert Arab', 'Sales Manager', 'https://www.linkedin.com/', 'images/photo/67082520964481728587040.webp', '2024-10-11 00:04:01', '2024-10-11 00:04:01');

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

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

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

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

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

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

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

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

--
-- Indexes for table `meta_translations`
--
ALTER TABLE `meta_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `meta_translations_meta_id_locale_unique` (`meta_id`,`locale`),
  ADD KEY `meta_translations_locale_index` (`locale`);

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

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

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_sub_category_id_foreign` (`sub_category_id`),
  ADD KEY `products_brand_id_foreign` (`brand_id`);

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

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

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

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_categories_category_id_foreign` (`category_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `meta_translations`
--
ALTER TABLE `meta_translations`
  ADD CONSTRAINT `meta_translations_meta_id_foreign` FOREIGN KEY (`meta_id`) REFERENCES `metas` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_sub_category_id_foreign` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD CONSTRAINT `sub_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;
COMMIT;

