# ************************************************************
# Sequel Ace SQL dump
# Version 20046
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# Host: 127.0.0.1 (MySQL 8.0.32-0ubuntu0.20.04.2)
# Database: blockat_back
# Generation Time: 2023-03-20 07:32:02 +0000
# ************************************************************




# Dump of table categories
# ------------------------------------------------------------


CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ar_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `en_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `bg_color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `categories` (`id`, `ar_name`, `en_name`, `order`, `is_active`, `bg_color`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'عبايات','Abayas',2,1,'#ffffff',NULL,'2022-12-26 10:59:06',NULL),
	(2,'جلابيات ودراريع','Jalabiyas & Dararie',1,1,'#F8F2DC',NULL,'2022-03-16 13:18:00',NULL),
	(3,'كاجوال','Casual',6,1,'#FFFCF5',NULL,'2022-03-16 13:19:28',NULL),
	(4,'فساتين','Dresses',3,1,'#F8F2DC',NULL,'2022-03-16 13:18:00',NULL),
	(5,'عطورات ودهن عود','Perfume & Oud Oil',7,1,'#fffcf5',NULL,'2022-03-16 13:19:49',NULL),
	(6,'أكسسوارات','Accessory',4,1,'#ffffff',NULL,'2022-11-30 07:34:04',NULL),
	(7,'مستحضرات تجميل','Cosmetic Products',8,1,'#ffffff',NULL,'2022-03-16 13:19:49',NULL),
	(8,'ميك أب أرتست','Makeup Artist',9,0,'#fffcf5',NULL,'2022-11-02 20:38:02',NULL),
	(9,'حقائب وأحذية','Bags & Shoes',5,1,'#F8F2DC',NULL,'2022-03-16 13:19:28',NULL),
	(10,'مودل','Modelling',12,0,'#f5f5f5','2022-01-13 08:33:44','2022-03-16 13:58:21',NULL),
	(11,'مستلزمات منزلية','Home Accessory',11,1,'#ffffff','2022-01-18 12:46:35','2022-03-16 13:20:39',NULL),
	(12,'ملابس أطفال','Kids Clothes',10,1,'#f2d9d9','2022-01-18 12:49:06','2022-03-16 13:59:18',NULL),
	(13,'عربات كوفي وأكل','Coffee carts and eat',13,0,'#000000','2022-11-30 07:49:35','2022-11-30 08:30:56',NULL),
	(14,'مستلزمات الأحتفالات','party accessories',14,1,'#000000','2023-01-04 23:43:20','2023-01-04 23:43:20',NULL);



# Dump of table category_package
# ------------------------------------------------------------


CREATE TABLE `category_package` (
  `category_id` bigint unsigned NOT NULL,
  `package_id` bigint unsigned NOT NULL,
  KEY `category_package_category_id_foreign` (`category_id`),
  KEY `category_package_package_id_foreign` (`package_id`),
  CONSTRAINT `category_package_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `category_package_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `category_package` (`category_id`, `package_id`)
VALUES
	(1,1),
	(2,1),
	(3,1),
	(4,1),
	(5,1),
	(6,1),
	(7,1),
	(8,1),
	(9,1),
	(10,1),
	(11,1),
	(12,1),
	(13,1);



# Dump of table contact_us
# ------------------------------------------------------------


CREATE TABLE `contact_us` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table countries
# ------------------------------------------------------------


CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ar_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `en_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `en_currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ar_currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `flag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `countries` (`id`, `ar_name`, `en_name`, `en_currency`, `ar_currency`, `code`, `flag`, `is_active`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'قطر','Qatar','QAR','QAR','+974','',1,NULL,'2022-01-31 08:42:51',NULL),
	(2,'افغانستان','Afghanistan','AFN','AFN','+93','AF',1,'2021-12-29 13:10:18','2022-03-14 08:43:39',NULL),
	(3,'البانيا','Albania','ALL','ALL','+355','AL',1,'2021-12-29 13:10:18','2022-03-14 08:43:46',NULL),
	(4,'أنتاركتيكا','Antarctica','','','+672','AQ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(5,'الجزائر','Algeria','DZD','DZD','+213','DZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(6,'ساموا الأمريكية','American Samoa','USD','USD','+1','AS',1,'2021-12-29 13:10:18','2022-03-13 10:35:17',NULL),
	(7,'أندورا','Andorra','EUR','EUR','+376','AD',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(8,'أنغولا','Angola','AOA','AOA','+244','AO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(9,'أنتيغوا وبربودا','Antigua and Barbuda','XCD','XCD','+1','AG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(10,'أذربيجان','Azerbaijan','AZN','AZN','+994','AZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(11,'الارجنتين','Argentina','ARS','ARS','+54','AR',1,'2021-12-29 13:10:18','2022-03-14 08:43:58',NULL),
	(12,'استراليا','Australia','AUD','AUD','+61','AU',1,'2021-12-29 13:10:18','2022-03-14 08:44:02',NULL),
	(13,'النمسا','Austria','EUR','EUR','+43','AT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(14,'الباهاماس','Bahamas','BSD','BSD','+1','BS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(15,'البحرين','Bahrain','BHD','BHD','+973','BH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(16,'بنغلاديش','Bangladesh','BDT','BDT','+880','BD',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(17,'أرمينيا','Armenia','AMD','AMD','+374','AM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(18,'بربادوس','Barbados','BBD','BBD','+1','BB',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(19,'بلجيكا','Belgium','EUR','EUR','+32','BE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(20,'جزر برمودا','Bermuda','BMD','BMD','+1','BM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(21,'بوتان','Bhutan','BTN','BTN','+975','BT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(22,'بوليفيا','Bolivia, Plurinational State of','BOB','BOB','+591','BO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(23,'البوسنة','Bosnia and Herzegovina','BAM','BAM','+387','BA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(24,'بوتسوانا','Botswana','BWP','BWP','+267','BW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(25,'Bouvet Island','Bouvet Island','','','+47','BV',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(26,'البرازيل','Brazil','BRL','BRL','+55','BR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(27,'بيليز','Belize','BZD','BZD','+501','BZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(28,'British Indian Ocean Territory','British Indian Ocean Territory','USD','USD','+246','IO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(29,'جزر سليمان','Solomon Islands','SBD','SBD','+677','SB',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(30,'الجزر العذراء البريطانية','Virgin Islands, British','USD','USD','+1','VG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(31,'بروني','Brunei Darussalam','BND','BND','+673','BN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(32,'بلغاريا','Bulgaria','BGN','BGN','+359','BG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(33,'ميانمار','Myanmar','MMK','MMK','+95','MM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(34,'بوروندي','Burundi','BIF','BIF','+257','BI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(35,'روسيا البيضاء','Belarus','BYR','BYR','+375','BY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(36,'كمبوديا','Cambodia','KHR','KHR','+855','KH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(37,'كاميرون','Cameroon','XAF','XAF','+237','CM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(38,'كندا','Canada','CAD','CAD','+1','CA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(39,'الرأس الأخضر','Cape Verde','CVE','CVE','+238','CV',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(40,'Cayman Islands','Cayman Islands','KYD','KYD','+1','KY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(41,'جمهورية أفريقيا الوسطى','Central African Republic','XAF','XAF','+236','CF',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(42,'سريلانكا','Sri Lanka','LKR','LKR','+94','LK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(43,'تشاد','Chad','XAF','XAF','+235','TD',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(44,'شيلي','Chile','CLP','CLP','+56','CL',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(45,'الصين','China','CNY','CNY','+86','CN',1,'2021-12-29 13:10:18','2022-03-13 10:35:25',NULL),
	(46,'تايوان','Taiwan, Province of China','TWD','TWD','+886','TW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(47,'Christmas Island','Christmas Island','AUD','AUD','+61','CX',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(48,'Cocos (Keeling) Islands','Cocos (Keeling) Islands','AUD','AUD','+61','CC',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(49,'كولومبيا','Colombia','COP','COP','+57','CO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(50,'جزر القمر','Comoros','KMF','KMF','+269','KM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(51,'Mayotte','Mayotte','EUR','EUR','+262','YT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(52,'الكونغو','Congo','XAF','XAF','+242','CG',1,'2021-12-29 13:10:18','2022-03-13 10:35:34',NULL),
	(53,'الكونغو','Congo, the Democratic Republic of the','CDF','CDF','+243','CD',1,'2021-12-29 13:10:18','2022-03-13 10:35:39',NULL),
	(54,'جزر كوك','Cook Islands','NZD','NZD','+682','CK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(55,'كوستاريكا','Costa Rica','CRC','CRC','+506','CR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(56,'كرواتيا','Croatia','HRK','HRK','+385','HR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(57,'كوبا','Cuba','CUP','CUP','+53','CU',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(58,'قبرص','Cyprus','EUR','EUR','+357','CY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(59,'التشيك','Czech Republic','CZK','CZK','+420','CZ',1,'2021-12-29 13:10:18','2022-03-13 10:35:49',NULL),
	(60,'بنين','Benin','XOF','XOF','+229','BJ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(61,'الدانمارك','Denmark','DKK','DKK','+45','DK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(62,'دومينيكا','Dominica','XCD','XCD','+1','DM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(63,'الجمهورية الدومينيكية','Dominican Republic','DOP','DOP','+1','DO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(64,'إكوادور','Ecuador','USD','USD','+593','EC',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(65,'إلسلفادور','El Salvador','SVC','SVC','+503','SV',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(66,'غينيا الاستوائي','Equatorial Guinea','XAF','XAF','+240','GQ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(67,'أثيوبيا','Ethiopia','ETB','ETB','+251','ET',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(68,'إريتريا','Eritrea','ERN','ERN','+291','ER',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(69,'استونيا','Estonia','EUR','EUR','+372','EE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(70,'جزر فارو','Faroe Islands','DKK','DKK','+298','FO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(71,'Falkland Islands (Malvinas)','Falkland Islands (Malvinas)','FKP','FKP','+500','FK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(72,'South Georgia and the South Sandwich Islands','South Georgia and the South Sandwich Islands','','','+44','GS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(73,'فيجي','Fiji','FJD','FJD','+679','FJ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(74,'فنلندا','Finland','EUR','EUR','+358','FI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(75,'Åland Islands','Åland Islands','EUR','EUR','+358','AX',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(76,'فرنسا','France','EUR','EUR','+33','FR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(77,'غويانا الفرنسية','French Guiana','EUR','EUR','+594','GF',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(78,'بولينيزيا الفرنسية','French Polynesia','XPF','XPF','+689','PF',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(79,'French Southern Territories','French Southern Territories','EUR','EUR','+33','TF',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(80,'جيبوتي','Djibouti','DJF','DJF','+253','DJ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(81,'الغابون','Gabon','XAF','XAF','+241','GA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(82,'جيورجيا','Georgia','GEL','GEL','+995','GE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(83,'غامبيا','Gambia','GMD','GMD','+220','GM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(84,'فلسطين','Palestine','NULL','NULL','+970','PS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(85,'ألمانيا','Germany','EUR','EUR','+49','DE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(86,'غانا','Ghana','GHS','GHS','+233','GH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(87,'جبل طارق','Gibraltar','GIP','GIP','+350','GI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(88,'كيريباتي','Kiribati','AUD','AUD','+686','KI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(89,'اليونان','Greece','EUR','EUR','+30','GR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(90,'جرينلاند','Greenland','DKK','DKK','+299','GL',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(91,'غرينادا','Grenada','XCD','XCD','+1','GD',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(92,'جزر جوادلوب','Guadeloupe','EUR','EUR','+590','GP',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(93,'جوام','Guam','USD','USD','+1','GU',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(94,'غواتيمال','Guatemala','GTQ','GTQ','+502','GT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(95,'غينيا','Guinea','GNF','GNF','+224','GN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(96,'غيانا','Guyana','GYD','GYD','+592','GY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(97,'هايتي','Haiti','HTG','HTG','+509','HT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(98,'Heard Island and McDonald Islands','Heard Island and McDonald Islands','','','+61','HM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(99,'الفاتيكان','Holy See (Vatican City State)','EUR','EUR','+39','VA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(100,'هندوراس','Honduras','HNL','HNL','+504','HN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(101,'هونغ كونغ','Hong Kong','HKD','HKD','+852','HK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(102,'المجر','Hungary','HUF','HUF','+36','HU',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(103,'آيسلندا','Iceland','ISK','ISK','+354','IS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(104,'الهند','India','INR','INR','+91','IN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(105,'اندونيسيا','Indonesia','IDR','IDR','+62','ID',1,'2021-12-29 13:10:18','2022-03-14 08:44:06',NULL),
	(106,'ايران','Iran, Islamic Republic of','IRR','IRR','+98','IR',1,'2021-12-29 13:10:18','2022-03-14 08:44:15',NULL),
	(107,'العراق','Iraq','IQD','IQD','+964','IQ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(108,'إيرلندا','Ireland','EUR','EUR','+353','IE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(109,'إيطاليا','Italy','EUR','EUR','+39','IT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(110,'ساحل العاج','Côte d\'Ivoire','XOF','XOF','+225','CI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(111,'جمايكا','Jamaica','JMD','JMD','+1','JM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(112,'اليابان','Japan','JPY','JPY','+81','JP',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(113,'كازاخستان','Kazakhstan','KZT','KZT','+7','KZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(114,'الاردن','Jordan','JOD','JOD','+962','JO',1,'2021-12-29 13:10:18','2022-03-14 08:41:49',NULL),
	(115,'كينيا','Kenya','KES','KES','+254','KE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(116,'كوريا الجنوبية','Korea, Democratic People\'s Republic of','KPW','KPW','+850','KP',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(117,'كوريا الشمالية','Korea, Republic of','KRW','KRW','+82','KR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(118,'الكويت','Kuwait','KWD','KWD','+965','KW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(119,'قيرغيزستان','Kyrgyzstan','KGS','KGS','+996','KG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(120,'لاوس','Lao People\'s Democratic Republic','LAK','LAK','+856','LA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(121,'لبنان','Lebanon','LBP','LBP','+961','LB',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(122,'ليسوتو','Lesotho','LSL','LSL','+266','LS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(123,'لاتفيا','Latvia','LVL','LVL','+371','LV',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(124,'ليبيريا','Liberia','LRD','LRD','+231','LR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(125,'ليبيا','Libya','LYD','LYD','+218','LY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(126,'ليختنشتين','Liechtenstein','CHF','CHF','+423','LI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(127,'لتوانيا','Lithuania','LTL','LTL','+370','LT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(128,'لوكسمبورغ','Luxembourg','EUR','EUR','+352','LU',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(129,'ماكاو','Macao','MOP','MOP','+853','MO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(130,'مدغشقر','Madagascar','MGA','MGA','+261','MG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(131,'مالاوي','Malawi','MWK','MWK','+265','MW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(132,'ماليزيا','Malaysia','MYR','MYR','+60','MY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(133,'المالديف','Maldives','MVR','MVR','+960','MV',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(134,'مالي','Mali','XOF','XOF','+223','ML',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(135,'مالطا','Malta','EUR','EUR','+356','MT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(136,'مارتينيك','Martinique','EUR','EUR','+596','MQ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(137,'موريتانيا','Mauritania','MRO','MRO','+222','MR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(138,'موريشيوس','Mauritius','MUR','MUR','+230','MU',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(139,'المكسيك','Mexico','MXN','MXN','+52','MX',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(140,'موناكو','Monaco','EUR','EUR','+377','MC',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(141,'منغوليا','Mongolia','MNT','MNT','+976','MN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(142,'مولدافيا','Moldova, Republic of','MDL','MDL','+373','MD',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(143,'الجبل الأسو','Montenegro','EUR','EUR','+382','ME',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(144,'مونتسيرات','Montserrat','XCD','XCD','+1','MS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(145,'المغرب','Morocco','MAD','MAD','+212','MA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(146,'موزمبيق','Mozambique','MZN','MZN','+258','MZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(147,'عمان','Oman','OMR','OMR','+968','OM',1,'2021-12-29 13:10:18','2022-02-23 10:16:33',NULL),
	(148,'ناميبيا','Namibia','NAD','NAD','+264','NA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(149,'نورو','Nauru','AUD','AUD','+674','NR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(150,'نيبال','Nepal','NPR','NPR','+977','NP',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(151,'هولندا','Netherlands','EUR','EUR','+31','NL',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(152,'Curaçao','Curaçao','ANG','ANG','+599','CW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(153,'أروبه','Aruba','AWG','AWG','+297','AW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(154,'Sint Maarten (Dutch part)','Sint Maarten (Dutch part)','ANG','ANG','+721','SX',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(155,'Bonaire, Sint Eustatius and Saba','Bonaire, Sint Eustatius and Saba','USD','USD','+599','BQ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(156,'كاليدونيا الجديدة','New Caledonia','XPF','XPF','+687','NC',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(157,'فانواتو','Vanuatu','VUV','VUV','+678','VU',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(158,'نيوزيلندا','New Zealand','NZD','NZD','+64','NZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(159,'نيكاراجوا','Nicaragua','NIO','NIO','+505','NI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(160,'النيجر','Niger','XOF','XOF','+227','NE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(161,'نيجيريا','Nigeria','NGN','NGN','+234','NG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(162,'ني','Niue','NZD','NZD','+683','NU',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(163,'Norfolk Island','Norfolk Island','AUD','AUD','+672','NF',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(164,'النرويج','Norway','NOK','NOK','+47','NO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(165,'جزر ماريانا الشمالي','Northern Mariana Islands','USD','USD','+1','MP',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(166,'United States Minor Outlying Islands','United States Minor Outlying Islands','USD','USD','+1','UM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(167,'Micronesia, Federated States of','Micronesia, Federated States of','USD','USD','+691','FM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(168,'جزر مارشال','Marshall Islands','USD','USD','+692','MH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(169,'بالاو','Palau','USD','USD','+680','PW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(170,'باكستان','Pakistan','PKR','PKR','+92','PK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(171,'بنما','Panama','PAB','PAB','+507','PA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(172,'بابوا غينيا الجديدة','Papua New Guinea','PGK','PGK','+675','PG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(173,'باراغواي','Paraguay','PYG','PYG','+595','PY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(174,'بيرو','Peru','PEN','PEN','+51','PE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(175,'الفليبين','Philippines','PHP','PHP','+63','PH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(176,'Pitcairn','Pitcairn','NZD','NZD','+649','PN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(177,'بولونيا','Poland','PLN','PLN','+48','PL',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(178,'البرتغال','Portugal','EUR','EUR','+351','PT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(179,'غينيا بيساو','Guinea-Bissau','XOF','XOF','+245','GW',1,'2021-12-29 13:10:18','2022-03-13 10:36:04',NULL),
	(180,'تيمور الشرقية','Timor-Leste','USD','USD','+670','TL',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(181,'بورتو ريكو','Puerto Rico','USD','USD','+1','PR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(182,'قطر','Qatar','QAR','QAR','+974','QA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(183,'ريونيون','Réunion','EUR','EUR','+262','RE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(184,'رومانيا','Romania','RON','RON','+40','RO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(185,'روسيا','Russian Federation','RUB','RUB','+7','RU',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(186,'رواندا','Rwanda','RWF','RWF','+250','RW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(187,'Saint Barthélemy','Saint Barthélemy','EUR','EUR','+590','BL',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(188,'Saint Helena, Ascension and Tristan da Cunha','Saint Helena, Ascension and Tristan da Cunha','SHP','SHP','+290','SH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(189,'سانت كيتس ونيفس','Saint Kitts and Nevis','XCD','XCD','+1','KN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(190,'أنغويلا','Anguilla','XCD','XCD','+1','AI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(191,'سانت لوسيا','Saint Lucia','XCD','XCD','+1','LC',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(192,'Saint Martin (French part)','Saint Martin (French part)','EUR','EUR','+590','MF',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(193,'Saint Pierre and Miquelon','Saint Pierre and Miquelon','EUR','EUR','+508','PM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(194,'سانت فنسنت وجزر غرينادين','Saint Vincent and the Grenadines','XCD','XCD','+1','VC',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(195,'سان مارينو','San Marino','EUR','EUR','+378','SM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(196,'ساو تومي وبرينسيبي','Sao Tome and Principe','STD','STD','+239','ST',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(197,'السعودية','Saudi Arabia','SAR','SAR','+966','SA',1,'2021-12-29 13:10:18','2022-03-13 10:36:12',NULL),
	(198,'السنغال','Senegal','XOF','XOF','+221','SN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(199,'جمهورية صربيا','Serbia','RSD','RSD','+381','RS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(200,'سيشيل','Seychelles','SCR','SCR','+248','SC',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(201,'سيراليون','Sierra Leone','SLL','SLL','+232','SL',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(202,'سنغافورة','Singapore','SGD','SGD','+65','SG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(203,'سلوفاكيا','Slovakia','EUR','EUR','+421','SK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(204,'فيتنام','Viet Nam','VND','VND','+84','VN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(205,'سلوفينيا','Slovenia','EUR','EUR','+386','SI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(206,'الصومال','Somalia','SOS','SOS','+252','SO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(207,'جنوب أفريقيا','South Africa','ZAR','ZAR','+27','ZA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(208,'زمبابوي','Zimbabwe','ZWL','ZWL','+263','ZW',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(209,'إسبانيا','Spain','EUR','EUR','+34','ES',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(210,'South Sudan','South Sudan','SSP','SSP','+211','SS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(211,'السودان','Sudan','SDG','SDG','+249','SD',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(212,'الصحراء الغربية','Western Sahara','MAD','MAD','+212','EH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(213,'سورينام','Suriname','SRD','SRD','+597','SR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(214,'Svalbard and Jan Mayen','Svalbard and Jan Mayen','NOK','NOK','+47','SJ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(215,'سوازيلند','Swaziland','SZL','SZL','+268','SZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(216,'السويد','Sweden','SEK','SEK','+46','SE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(217,'سويسرا','Switzerland','CHF','CHF','+41','CH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(218,'سوريا','Syria','SYP','SYP','+963','SY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(219,'طاجيكستان','Tajikistan','TJS','TJS','+992','TJ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(220,'تايلندا','Thailand','THB','THB','+66','TH',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(221,'توغو','Togo','XOF','XOF','+228','TG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(222,'Tokelau','Tokelau','NZD','NZD','+690','TK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(223,'تونغا','Tonga','TOP','TOP','+676','TO',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(224,'ترينيداد وتوباغو','Trinidad and Tobago','TTD','TTD','+1','TT',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(225,'الامارات','United Arab Emirates','AED','AED','+971','AE',1,'2021-12-29 13:10:18','2022-02-23 10:12:43',NULL),
	(226,'تونس','Tunisia','TND','TND','+216','TN',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(227,'تركيا','Turkey','TRY','TRY','+90','TR',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(228,'تركمانستان','Turkmenistan','TMT','TMT','+993','TM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(229,'Turks and Caicos Islands','Turks and Caicos Islands','USD','USD','+1','TC',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(230,'توفالو','Tuvalu','AUD','AUD','+688','TV',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(231,'أوغندا','Uganda','UGX','UGX','+256','UG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(232,'أوكرانيا','Ukraine','UAH','UAH','+380','UA',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(233,'Macedonia, the former Yugoslav Republic of','Macedonia, the former Yugoslav Republic of','MKD','MKD','+389','MK',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(234,'مصر','Egypt','EGP','EGP','+20','EG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(235,'بريطانيا','United Kingdom','GBP','GBP','+44','GB',1,'2021-12-29 13:10:18','2022-02-23 10:17:48',NULL),
	(236,'Guernsey','Guernsey','GGP (GG2)','GGP (GG2)','+44','GG',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(237,'Jersey','Jersey','JEP (JE2)','JEP (JE2)','+44','JE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(238,'Isle of Man','Isle of Man','IMP (IM2)','IMP (IM2)','+44','IM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(239,'تنزانيا','Tanzania, United Republic of','TZS','TZS','+255','TZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(240,'امريكا','United States','USD','USD','+1','US',1,'2021-12-29 13:10:18','2022-03-13 10:32:32',NULL),
	(241,'الجزر العذراء الأمريكي','Virgin Islands, U.S.','USD','USD','+1','VI',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(242,'بوركينا فاسو','Burkina Faso','XOF','XOF','+226','BF',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(243,'أورغواي','Uruguay','UYU','UYU','+598','UY',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(244,'أوزباكستان','Uzbekistan','UZS','UZS','+998','UZ',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(245,'فنزويلا','Venezuela, Bolivarian Republic of','VEF','VEF','+58','VE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(246,'والس وفوتونا','Wallis and Futuna','XPF','XPF','+681','WF',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(247,'المناطق','Samoa','WST','WST','+685','WS',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(248,'اليمن','Yemen','YER','YER','+967','YE',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(249,'زامبيا','Zambia','ZMW','ZMW','+260','ZM',1,'2021-12-29 13:10:18','2021-12-29 13:10:18',NULL),
	(250,'عمان','oman','ryal','ريال عماني','+968',NULL,0,'2022-07-23 18:21:51','2022-07-23 18:22:37',NULL);



# Dump of table failed_jobs
# ------------------------------------------------------------


CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table favorites
# ------------------------------------------------------------


CREATE TABLE `favorites` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `favoriteable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `favoriteable_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `favorites_user_id_foreign` (`user_id`),
  CONSTRAINT `favorites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table firebase_notifications
# ------------------------------------------------------------


CREATE TABLE `firebase_notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` text COLLATE utf8mb4_unicode_ci,
  `body` text COLLATE utf8mb4_unicode_ci,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ar',
  `product_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `item_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `firebase_notifications_user_id_foreign` (`user_id`),
  KEY `firebase_notifications_product_id_foreign` (`product_id`),
  CONSTRAINT `firebase_notifications_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  CONSTRAINT `firebase_notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table images
# ------------------------------------------------------------


CREATE TABLE `images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `imageable_id` bigint unsigned NOT NULL,
  `imageable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` int NOT NULL DEFAULT '0',
  `order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `images` (`id`, `imageable_id`, `imageable_type`, `path`, `is_default`, `order`, `created_at`, `updated_at`)
VALUES
	(1,138,'user','users/9f79f2ef-d331-49c4-8ce3-7f8c29585912.jpg',1,NULL,'2023-03-18 20:05:38','2023-03-18 20:05:38');



# Dump of table marketers
# ------------------------------------------------------------


CREATE TABLE `marketers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `marketer_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount_percentage` double NOT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table migrations
# ------------------------------------------------------------


CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES
	(1,'2014_10_11_024917_create_countries_table',1),
	(2,'2014_10_12_000000_create_users_table',1),
	(3,'2014_10_12_100000_create_password_resets_table',1),
	(4,'2019_08_19_000000_create_failed_jobs_table',1),
	(5,'2019_12_14_000001_create_personal_access_tokens_table',1),
	(6,'2021_04_25_224835_create_categories_table',1),
	(7,'2021_04_25_225634_create_packages_table',1),
	(8,'2021_04_25_225842_create_category_package_table',1),
	(9,'2021_04_25_231850_create_payment_transaction_table',1),
	(10,'2021_04_25_231924_create_shop_categories_table',1),
	(11,'2021_04_25_233614_create_shop_products_table',1),
	(12,'2021_04_25_234140_create_contact_us_table',1),
	(13,'2021_04_25_234304_create_settings_table',1),
	(14,'2021_04_26_010244_create_images_table',1),
	(15,'2021_04_30_011751_create_sms_logs_table',1),
	(16,'2021_05_11_043733_create_favorites_table',1),
	(17,'2021_06_04_172924_alter_categories_table_add_bg_color',1),
	(18,'2021_06_10_111711_alter_packages_table_add_days',1),
	(19,'2021_06_10_223130_create_admins_table',1),
	(20,'2021_06_12_032000_alter_admins_table_add_lang',1),
	(21,'2021_06_15_003047_alter_countries_table_set_flag_nullable',1),
	(22,'2021_06_15_022116_alter_countries_table_add_soft_delete',1),
	(23,'2021_07_01_222501_create_firebase_notifications_table',1),
	(24,'2021_07_16_185521_alter_users_table_add_shop_name_en',1),
	(25,'2021_07_16_194746_alter_countries_table_add_currency',1),
	(26,'2021_07_17_050706_alter_notification_table_fix',1),
	(27,'2021_09_20_024330_alter_settings_table_value',1),
	(28,'2021_09_20_032548_alter_firebasenotifications_table',1),
	(29,'2021_09_20_184548_alter_products_table_is_approved',1),
	(30,'2021_09_24_024138_create_permission_tables',1),
	(31,'2021_10_03_141603_sadad_trans_log',2),
	(32,'2022_01_09_130935_create_package_histories_table',2),
	(33,'2022_02_09_071746_add_name_field_to_products',3),
	(34,'2022_03_11_231746_change_products_table_field',4),
	(35,'2022_03_12_092603_add_fields_to_users_table',4),
	(36,'2022_04_17_090823_add_declined_reason_to_products_table',5),
	(37,'2022_05_19_082126_create_marketers_table',6),
	(38,'2022_05_19_120221_add_marketer_details_to_payment_transactions_table',6),
	(39,'2022_05_23_125914_make_nullable_name_field_users_table',6),
	(40,'2022_07_05_072316_update_products_table',6),
	(41,'2022_10_30_135558_add_user_vendor_field_to_users_table',7),
	(42,'2023_01_03_083353_add_language_column_to_firebase_notifications_table',8),
	(43,'2023_01_03_112645_add_declined_reason_ar_field_to_products_table',8);



# Dump of table model_has_permissions
# ------------------------------------------------------------


CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table model_has_roles
# ------------------------------------------------------------


CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`)
VALUES
	(1,'App\\Models\\Admin',1),
	(1,'App\\Models\\Admin',2),
	(1,'App\\Models\\Admin',3),
	(8,'App\\Models\\Admin',7),
	(9,'App\\Models\\Admin',8),
	(10,'App\\Models\\Admin',9),
	(11,'App\\Models\\Admin',10);



# Dump of table package_histories
# ------------------------------------------------------------


CREATE TABLE `package_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `shop_category_id` bigint unsigned NOT NULL,
  `package_id` bigint unsigned NOT NULL,
  `from` date NOT NULL,
  `to` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `package_histories_shop_category_id_foreign` (`shop_category_id`),
  KEY `package_histories_package_id_foreign` (`package_id`),
  CONSTRAINT `package_histories_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`),
  CONSTRAINT `package_histories_shop_category_id_foreign` FOREIGN KEY (`shop_category_id`) REFERENCES `shop_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `package_histories` (`id`, `shop_category_id`, `package_id`, `from`, `to`, `created_at`, `updated_at`)
VALUES
	(1,1,1,'2023-03-18','2023-04-17','2023-03-18 20:06:34','2023-03-18 20:06:34');



# Dump of table packages
# ------------------------------------------------------------


CREATE TABLE `packages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ar_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `en_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cost` double NOT NULL,
  `days` int NOT NULL,
  `discount` double NOT NULL DEFAULT '0',
  `discount_type` int NOT NULL DEFAULT '1',
  `is_active` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `packages` (`id`, `ar_name`, `en_name`, `cost`, `days`, `discount`, `discount_type`, `is_active`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'شهر مجاني','Free Month',0,30,0,1,1,'2022-12-15 09:46:29','2022-12-15 09:46:29',NULL);



# Dump of table permissions
# ------------------------------------------------------------


CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ar_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `permissions` (`id`, `name`, `ar_name`, `group_name`, `guard_name`, `created_at`, `updated_at`)
VALUES
	(1,'dashboard_cards','عدادات لوحة التحكم','dashboard','admins',NULL,NULL),
	(2,'permissions_index','مشاهدة الصلاحيات','permissions','admins',NULL,NULL),
	(3,'permissions_create','انشاء صلاحية جديده','permissions','admins',NULL,NULL),
	(4,'permissions_edit','تعديل الصلاحيات','permissions','admins',NULL,NULL),
	(5,'permissions_delete','حذف الصلاحيات','permissions','admins',NULL,NULL),
	(6,'admins_index','مشاهدة المديرين','admins','admins',NULL,NULL),
	(7,'admins_create','انشاء مدير جديد','admins','admins',NULL,NULL),
	(8,'admins_edit','تعديل المديرين','admins','admins',NULL,NULL),
	(9,'admins_delete','حذف المديرين','admins','admins',NULL,NULL),
	(10,'countries_index','مشاهدة الدول','countries','admins',NULL,NULL),
	(11,'countries_create','انشاء دولة جديدة','countries','admins',NULL,NULL),
	(12,'countries_edit','تعديل الدول','countries','admins',NULL,NULL),
	(13,'categories_index','مشاهدة الاقسام','categories','admins',NULL,NULL),
	(14,'categories_create','انشاء الاقسام','categories','admins',NULL,NULL),
	(15,'categories_edit','تعديل الاقسام','categories','admins',NULL,NULL),
	(16,'categories_arrange','ترتيب الاقسام','categories','admins',NULL,NULL),
	(17,'packages_index','مشاهدة الباقات','packages','admins',NULL,NULL),
	(18,'packages_create','انشاء باقات','packages','admins',NULL,NULL),
	(19,'packages_edit','تعديل الباقات','packages','admins',NULL,NULL),
	(20,'users_index','مشاهدة المستخدمين','users','admins',NULL,NULL),
	(21,'users_create','انشاء مستخدمين','users','admins',NULL,NULL),
	(22,'users_edit','تعديل مستخدمين','users','admins',NULL,NULL),
	(23,'users_delete','حذف المستخدمين','users','admins',NULL,NULL),
	(24,'shops_index','مشاهدة المتاجر','shops','admins',NULL,NULL),
	(25,'shops_create','انشاء متاجر','shops','admins',NULL,NULL),
	(26,'shops_edit','تعديل المتاجر','shops','admins',NULL,NULL),
	(27,'shops_delete','حذف المتاجر','shops','admins',NULL,NULL),
	(28,'shops_notification','ارسال شعار باستخدم المتجر','shops','admins',NULL,NULL),
	(29,'products_index','مشاهدة المنتجات','products','admins',NULL,NULL),
	(30,'products_create','انشاء منتجات','products','admins',NULL,NULL),
	(31,'products_edit','تعديل المنتجات','products','admins',NULL,NULL),
	(32,'products_delete','حذف المنتجات','products','admins',NULL,NULL),
	(33,'products_notification','ارسال اشعار باستخدام المنتج','products','admins',NULL,NULL),
	(34,'products_approval','الموافقة علي ظهور المنتج','products','admins',NULL,NULL),
	(35,'subscriptions_index','مشاهدة الاشتراكات','subscriptions','admins',NULL,NULL),
	(36,'payment_transactions_index','مشاهدة العمليات المالية','payment_transactions','admins',NULL,NULL),
	(37,'complaints_index','مشاهدة الشكاوي','complaints_transactions','admins',NULL,NULL),
	(38,'notifications_index','ارسال اشعارات','notifications_transactions','admins',NULL,NULL),
	(39,'settings_index','تعديل الاعدادت','settings_transactions','admins',NULL,NULL),
	(40,'marketers_index','مشاهدة المستخدمين','marketers','admins',NULL,NULL),
	(41,'marketers_create','انشاء مستخدمين','marketers','admins',NULL,NULL),
	(42,'marketers_edit','تعديل مستخدمين','marketers','admins',NULL,NULL),
	(43,'marketers_delete','حذف المستخدمين','marketers','admins',NULL,NULL);



# Dump of table products
# ------------------------------------------------------------


CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `ar_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `en_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `price` double DEFAULT NULL,
  `price_after_discount` double DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_approved` int NOT NULL DEFAULT '0',
  `declined_reason` text COLLATE utf8mb4_unicode_ci,
  `declined_reason_en` longtext COLLATE utf8mb4_unicode_ci,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_user_id_foreign` (`user_id`),
  KEY `products_category_id_foreign` (`category_id`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table role_has_permissions
# ------------------------------------------------------------


CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `role_has_permissions` (`permission_id`, `role_id`)
VALUES
	(1,1),
	(2,1),
	(3,1),
	(4,1),
	(5,1),
	(6,1),
	(7,1),
	(8,1),
	(9,1),
	(10,1),
	(11,1),
	(12,1),
	(13,1),
	(14,1),
	(15,1),
	(16,1),
	(17,1),
	(18,1),
	(19,1),
	(20,1),
	(21,1),
	(22,1),
	(23,1),
	(24,1),
	(25,1),
	(26,1),
	(27,1),
	(28,1),
	(29,1),
	(30,1),
	(31,1),
	(32,1),
	(33,1),
	(34,1),
	(35,1),
	(36,1),
	(37,1),
	(38,1),
	(39,1),
	(40,1),
	(41,1),
	(42,1),
	(43,1),
	(1,8),
	(2,8),
	(6,8),
	(10,8),
	(11,8),
	(12,8),
	(13,8),
	(16,8),
	(17,8),
	(20,8),
	(21,8),
	(22,8),
	(23,8),
	(24,8),
	(25,8),
	(26,8),
	(27,8),
	(28,8),
	(29,8),
	(30,8),
	(31,8),
	(32,8),
	(33,8),
	(34,8),
	(35,8),
	(36,8),
	(37,8),
	(38,8),
	(40,8),
	(41,8),
	(42,8),
	(43,8),
	(2,9),
	(6,9),
	(10,9),
	(11,9),
	(13,9),
	(16,9),
	(17,9),
	(20,9),
	(24,9),
	(28,9),
	(29,9),
	(31,9),
	(32,9),
	(33,9),
	(34,9),
	(35,9),
	(37,9),
	(38,9),
	(40,9),
	(1,10),
	(2,10),
	(3,10),
	(4,10),
	(5,10),
	(10,10),
	(11,10),
	(12,10),
	(13,10),
	(16,10),
	(17,10),
	(20,10),
	(21,10),
	(22,10),
	(23,10),
	(24,10),
	(1,11),
	(2,11),
	(6,11),
	(10,11),
	(13,11),
	(17,11),
	(20,11),
	(24,11),
	(25,11),
	(26,11),
	(27,11),
	(28,11),
	(29,11),
	(30,11),
	(31,11),
	(32,11),
	(33,11),
	(34,11),
	(35,11),
	(36,11),
	(37,11),
	(38,11),
	(40,11),
	(41,11),
	(42,11),
	(43,11),
	(2,12),
	(6,12),
	(10,12),
	(11,12),
	(12,12),
	(13,12),
	(16,12),
	(17,12),
	(20,12),
	(24,12),
	(29,12),
	(30,12),
	(31,12),
	(32,12),
	(33,12),
	(34,12),
	(35,12),
	(37,12),
	(38,12),
	(40,12);



# Dump of table roles
# ------------------------------------------------------------


CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ar_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `roles` (`id`, `name`, `ar_name`, `guard_name`, `created_at`, `updated_at`)
VALUES
	(1,'super_admin','مدير','admins',NULL,NULL),
	(8,'Marketing Executive','مسؤول تسويق','admins','2022-11-19 15:35:40','2022-11-19 15:35:40'),
	(9,'markeing excutive','مسؤولة تسويق','admins','2022-12-17 20:25:15','2022-12-17 20:25:15'),
	(10,'HR','اداري','admins','2023-01-29 14:58:45','2023-01-29 14:58:45'),
	(11,'TEST ADMIN','تست ادمن','admins','2023-01-30 11:13:23','2023-01-30 11:13:23'),
	(12,'marketing advisor','marketing','admins','2023-03-05 23:37:00','2023-03-05 23:37:00');



# Dump of table sadad_trans_logs
# ------------------------------------------------------------


CREATE TABLE `sadad_trans_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `transable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transable_id` bigint unsigned NOT NULL,
  `sadad_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `response` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sadad_trans_logs_transable_type_transable_id_index` (`transable_type`,`transable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


# Dump of table shop_categories
# ------------------------------------------------------------


CREATE TABLE `shop_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `payment_id` bigint unsigned NOT NULL,
  `package_id` bigint unsigned NOT NULL,
  `is_active` int NOT NULL DEFAULT '0',
  `product_count` int NOT NULL DEFAULT '0',
  `valid_from` timestamp NOT NULL,
  `valid_to` timestamp NOT NULL,
  `current_status_json` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shop_categories_user_id_foreign` (`user_id`),
  KEY `shop_categories_category_id_foreign` (`category_id`),
  KEY `shop_categories_payment_id_foreign` (`payment_id`),
  KEY `shop_categories_package_id_foreign` (`package_id`),
  CONSTRAINT `shop_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `shop_categories_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`),
  CONSTRAINT `shop_categories_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payment_transactions` (`id`),
  CONSTRAINT `shop_categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `shop_categories` (`id`, `user_id`, `category_id`, `payment_id`, `package_id`, `is_active`, `product_count`, `valid_from`, `valid_to`, `current_status_json`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,138,1,1,1,1,0,'2023-03-18 20:06:34','2023-04-17 20:06:34','\"{\\\"id\\\":1,\\\"ar_name\\\":\\\"\\\\u0634\\\\u0647\\\\u0631 \\\\u0645\\\\u062c\\\\u0627\\\\u0646\\\\u064a\\\",\\\"en_name\\\":\\\"Free Month\\\",\\\"cost\\\":0,\\\"days\\\":30,\\\"discount\\\":0,\\\"discount_type\\\":1,\\\"is_active\\\":1,\\\"created_at\\\":\\\"2022-12-15T06:46:29.000000Z\\\",\\\"updated_at\\\":\\\"2022-12-15T06:46:29.000000Z\\\",\\\"deleted_at\\\":null,\\\"name\\\":\\\"\\\\u0634\\\\u0647\\\\u0631 \\\\u0645\\\\u062c\\\\u0627\\\\u0646\\\\u064a\\\"}\"','2023-03-18 20:06:34','2023-03-18 20:06:34',NULL);



# Dump of table sms_logs
# ------------------------------------------------------------


CREATE TABLE `sms_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int NOT NULL DEFAULT '1',
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vendor` int NOT NULL,
  `vendor_response` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sms_logs_user_id_foreign` (`user_id`),
  CONSTRAINT `sms_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `sms_logs` (`id`, `user_id`, `message`, `type`, `code`, `vendor`, `vendor_response`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,138,'كود تفعيل حساب بلوكات هو : 8799',1,NULL,3,'1777598505','2023-03-18 20:05:38','2023-03-18 20:05:42',NULL);




