
--
-- Table structure for table `sc_shop_attribute_group`
--

CREATE TABLE `sc_shop_attribute_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `sort` int NOT NULL DEFAULT '0',
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'radio,select,checkbox',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_attribute_group`
--

INSERT INTO `sc_shop_attribute_group` VALUES (1,'Color',1,1,'radio',NULL,NULL),(2,'Size',1,2,'select',NULL,NULL);

--
-- Table structure for table `sc_shop_banner`
--

CREATE TABLE `sc_shop_banner` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `html` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '0',
  `sort` int NOT NULL DEFAULT '0',
  `click` int NOT NULL DEFAULT '0',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_banner_type_index` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_banner`
--

INSERT INTO `sc_shop_banner` VALUES ('9d301b85-ea82-4e37-a4a0-30f78ad1cb84','Banner home 2 (s-cart-light)','/data/banner/2e763cb8b95a09dcd38da91db3432fa1.jpg',NULL,'_self',NULL,1,1,0,'banner','2024-10-07 16:40:57','2024-10-08 09:06:30'),('9d301b85-f0a5-4a16-a1eb-a2f7d7b4b812','Banner store (s-cart-light)','/data/banner/Banner2.png',NULL,'_self',NULL,1,1,1,'banner','2024-10-07 16:40:57','2024-10-08 09:09:56');

--
-- Table structure for table `sc_shop_banner_store`
--

CREATE TABLE `sc_shop_banner_store` (
  `banner_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`banner_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_banner_store`
--

INSERT INTO `sc_shop_banner_store` VALUES ('9d301b85-ea82-4e37-a4a0-30f78ad1cb84','1'),('9d301b85-f0a5-4a16-a1eb-a2f7d7b4b812','1');

--
-- Table structure for table `sc_shop_banner_type`
--

CREATE TABLE `sc_shop_banner_type` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_banner_type_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_banner_type`
--

INSERT INTO `sc_shop_banner_type` VALUES (1,'banner','Banner main',NULL,NULL),(2,'background','Background website',NULL,NULL),(3,'breadcrumb','Breadcrumb',NULL,NULL),(4,'banner-store','Banner store',NULL,NULL),(5,'banner-left','Banner left',NULL,NULL),(6,'banner-right','Banner right',NULL,NULL),(7,'other','Other',NULL,NULL);

--
-- Table structure for table `sc_shop_brand`
--

CREATE TABLE `sc_shop_brand` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `sort` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_brand_alias_index` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_brand`
--

INSERT INTO `sc_shop_brand` VALUES ('9d301b87-2b7a-4a63-812d-b9d43139e20f','DaNang','danang','/data/brand/acer.png',NULL,1,0,NULL,NULL),('9d301b87-2b89-4fec-af98-28ee54b424e3','SaiGon','saigon','/data/brand/assus.png',NULL,1,0,NULL,NULL),('9d301b87-2b9a-4a40-9d25-f944a3ec351c','HaNoi','hanoi','/data/brand/casio.png',NULL,1,0,NULL,NULL),('9d301b87-2b9f-4a9b-a4df-a280a9cf9f16','BenTre','bentre','/data/brand/dell.png',NULL,1,0,NULL,NULL),('9d301b87-2ba3-4a97-8723-1e7ee3eb2724','NgheAn','nghean','/data/brand/microsoft.png',NULL,1,0,NULL,NULL),('9d301b87-2bad-40be-b155-723619a09802','LongAn','longan','/data/brand/nokia.png',NULL,1,0,NULL,NULL),('9d301b87-2bb2-49b3-81a8-495c16a54bfd','CaMau','camau','/data/brand/panasonic.png',NULL,1,0,NULL,NULL),('9d301b87-2bb6-474e-8ba1-2889a10ace75','HaGiang','hagiang','/data/brand/sharp.png',NULL,1,0,NULL,NULL),('9d301b87-2bbe-44c8-96da-1dc033275b5e','ThanhHoa','thanhhoa','/data/brand/vaio.png',NULL,1,0,NULL,NULL),('9d3025ba-f332-4448-8163-f3c3c00b5bf7','Gurgaon','wedding-venues','/data/brand/acer.png','http://64.227.143.178/public/wedding-venues-gurgaon',1,0,'2024-10-07 17:09:30','2024-10-07 17:09:30');

--
-- Table structure for table `sc_shop_brand_store`
--

CREATE TABLE `sc_shop_brand_store` (
  `brand_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`brand_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_brand_store`
--

INSERT INTO `sc_shop_brand_store` VALUES ('9d301b87-2b7a-4a63-812d-b9d43139e20f','1'),('9d301b87-2b89-4fec-af98-28ee54b424e3','1'),('9d301b87-2b9a-4a40-9d25-f944a3ec351c','1'),('9d301b87-2b9f-4a9b-a4df-a280a9cf9f16','1'),('9d301b87-2ba3-4a97-8723-1e7ee3eb2724','1'),('9d301b87-2bad-40be-b155-723619a09802','1'),('9d301b87-2bb2-49b3-81a8-495c16a54bfd','1'),('9d301b87-2bb6-474e-8ba1-2889a10ace75','1'),('9d301b87-2bbe-44c8-96da-1dc033275b5e','1'),('9d3025ba-f332-4448-8163-f3c3c00b5bf7','1');

--
-- Table structure for table `sc_shop_category`
--

CREATE TABLE `sc_shop_category` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `top` int DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '0',
  `sort` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_category_alias_index` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_category`
--

INSERT INTO `sc_shop_category` VALUES ('9d301b87-2031-4440-aa0b-74b68b40899f','/data/category/Categorgy/Banner 4 (1) (1).jpg','wedding-photography','0',1,1,0,NULL,'2024-10-07 18:07:36'),('9d301b87-2040-4d54-aa08-11e41730bba8','/data/category/headphone1.png','makeup-artist','0',1,1,1,NULL,'2024-10-07 18:10:21'),('9d301b87-2075-4a06-872d-6638406e3953','/data/category/usb1.png','bridal-wear','0',1,1,6,NULL,'2024-10-07 18:11:32'),('9d30243c-01de-42ce-bf80-09847ab52eb4','/data/category/Wedding venues.jpg','wedding-venues','0',1,1,1,'2024-10-07 17:05:19','2024-10-07 17:05:38');

--
-- Table structure for table `sc_shop_category_description`
--

CREATE TABLE `sc_shop_category_description` (
  `category_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  UNIQUE KEY `sc_shop_category_description_category_id_lang_unique` (`category_id`,`lang`),
  KEY `sc_shop_category_description_lang_index` (`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_category_description`
--

INSERT INTO `sc_shop_category_description` VALUES ('9d301b87-2031-4440-aa0b-74b68b40899f','en','Wedding Photography',NULL,NULL),('9d301b87-2031-4440-aa0b-74b68b40899f','vi','Wedding Photography',NULL,NULL),('9d301b87-2040-4d54-aa08-11e41730bba8','en','Makeup Artist',NULL,NULL),('9d301b87-2040-4d54-aa08-11e41730bba8','vi','Makeup Artist',NULL,NULL),('9d301b87-2075-4a06-872d-6638406e3953','en','Bridal Wear',NULL,NULL),('9d301b87-2075-4a06-872d-6638406e3953','vi','Bridal Wear',NULL,NULL),('9d30243c-01de-42ce-bf80-09847ab52eb4','en','Wedding Venues','wedding venues in Delhi','Selecting venues for weddings is one of the biggest and the most important decisions a couple has to take when planning for their wedding. After all, you would want to book one of the best wedding venues in Delhi/NCR, that comes with a great package and best deals! There is a wide variety of venue options in Delhi/NCR for you to choose from, right from banquet halls to poolside venues, from lawns to resorts, you can find them all.'),('9d30243c-01de-42ce-bf80-09847ab52eb4','vi','Wedding Venues','wedding venues in delhi ncr','Selecting venues for weddings is one of the biggest and the most important decisions a couple has to take when planning for their wedding. After all, you would want to book one of the best wedding venues in Delhi/NCR, that comes with a great package and best deals! There is a wide variety of venue options in Delhi/NCR for you to choose from, right from banquet halls to poolside venues, from lawns to resorts, you can find them all.');

--
-- Table structure for table `sc_shop_category_store`
--

CREATE TABLE `sc_shop_category_store` (
  `category_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`category_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_category_store`
--

INSERT INTO `sc_shop_category_store` VALUES ('9d301b87-2031-4440-aa0b-74b68b40899f','1'),('9d301b87-2040-4d54-aa08-11e41730bba8','1'),('9d301b87-2075-4a06-872d-6638406e3953','1');

--
-- Table structure for table `sc_shop_country`
--

CREATE TABLE `sc_shop_country` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_country_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=246 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_country`
--

INSERT INTO `sc_shop_country` VALUES (1,'AL','Albania'),(2,'DZ','Algeria'),(3,'DS','American Samoa'),(4,'AD','Andorra'),(5,'AO','Angola'),(6,'AI','Anguilla'),(7,'AQ','Antarctica'),(8,'AG','Antigua and Barbuda'),(9,'AR','Argentina'),(10,'AM','Armenia'),(11,'AW','Aruba'),(12,'AU','Australia'),(13,'AT','Austria'),(14,'AZ','Azerbaijan'),(15,'BS','Bahamas'),(16,'BH','Bahrain'),(17,'BD','Bangladesh'),(18,'BB','Barbados'),(19,'BY','Belarus'),(20,'BE','Belgium'),(21,'BZ','Belize'),(22,'BJ','Benin'),(23,'BM','Bermuda'),(24,'BT','Bhutan'),(25,'BO','Bolivia'),(26,'BA','Bosnia and Herzegovina'),(27,'BW','Botswana'),(28,'BV','Bouvet Island'),(29,'BR','Brazil'),(30,'IO','British Indian Ocean Territory'),(31,'BN','Brunei Darussalam'),(32,'BG','Bulgaria'),(33,'BF','Burkina Faso'),(34,'BI','Burundi'),(35,'KH','Cambodia'),(36,'CM','Cameroon'),(37,'CA','Canada'),(38,'CV','Cape Verde'),(39,'KY','Cayman Islands'),(40,'CF','Central African Republic'),(41,'TD','Chad'),(42,'CL','Chile'),(43,'CN','China'),(44,'CX','Christmas Island'),(45,'CC','Cocos (Keeling) Islands'),(46,'CO','Colombia'),(47,'KM','Comoros'),(48,'CG','Congo'),(49,'CK','Cook Islands'),(50,'CR','Costa Rica'),(51,'HR','Croatia (Hrvatska)'),(52,'CU','Cuba'),(53,'CY','Cyprus'),(54,'CZ','Czech Republic'),(55,'DK','Denmark'),(56,'DJ','Djibouti'),(57,'DM','Dominica'),(58,'DO','Dominican Republic'),(59,'TP','East Timor'),(60,'EC','Ecuador'),(61,'EG','Egypt'),(62,'SV','El Salvador'),(63,'GQ','Equatorial Guinea'),(64,'ER','Eritrea'),(65,'EE','Estonia'),(66,'ET','Ethiopia'),(67,'FK','Falkland Islands (Malvinas)'),(68,'FO','Faroe Islands'),(69,'FJ','Fiji'),(70,'FI','Finland'),(71,'FR','France'),(72,'FX','France, Metropolitan'),(73,'GF','French Guiana'),(74,'PF','French Polynesia'),(75,'TF','French Southern Territories'),(76,'GA','Gabon'),(77,'GM','Gambia'),(78,'GE','Georgia'),(79,'DE','Germany'),(80,'GH','Ghana'),(81,'GI','Gibraltar'),(82,'GK','Guernsey'),(83,'GR','Greece'),(84,'GL','Greenland'),(85,'GD','Grenada'),(86,'GP','Guadeloupe'),(87,'GU','Guam'),(88,'GT','Guatemala'),(89,'GN','Guinea'),(90,'GW','Guinea-Bissau'),(91,'GY','Guyana'),(92,'HT','Haiti'),(93,'HM','Heard and Mc Donald Islands'),(94,'HN','Honduras'),(95,'HK','Hong Kong'),(96,'HU','Hungary'),(97,'IS','Iceland'),(98,'IN','India'),(99,'IM','Isle of Man'),(100,'ID','Indonesia'),(101,'IR','Iran (Islamic Republic of)'),(102,'IQ','Iraq'),(103,'IE','Ireland'),(104,'IL','Israel'),(105,'IT','Italy'),(106,'CI','Ivory Coast'),(107,'JE','Jersey'),(108,'JM','Jamaica'),(109,'JP','Japan'),(110,'JO','Jordan'),(111,'KZ','Kazakhstan'),(112,'KE','Kenya'),(113,'KI','Kiribati'),(114,'KP','Korea,Democratic People\\s Republic of'),(115,'KR','Korea, Republic of'),(116,'XK','Kosovo'),(117,'KW','Kuwait'),(118,'KG','Kyrgyzstan'),(119,'LA','Lao People\\s Democratic Republic'),(120,'LV','Latvia'),(121,'LB','Lebanon'),(122,'LS','Lesotho'),(123,'LR','Liberia'),(124,'LY','Libyan Arab Jamahiriya'),(125,'LI','Liechtenstein'),(126,'LT','Lithuania'),(127,'LU','Luxembourg'),(128,'MO','Macau'),(129,'MK','Macedonia'),(130,'MG','Madagascar'),(131,'MW','Malawi'),(132,'MY','Malaysia'),(133,'MV','Maldives'),(134,'ML','Mali'),(135,'MT','Malta'),(136,'MH','Marshall Islands'),(137,'MQ','Martinique'),(138,'MR','Mauritania'),(139,'MU','Mauritius'),(140,'TY','Mayotte'),(141,'MX','Mexico'),(142,'FM','Micronesia, Federated States of'),(143,'MD','Moldova, Republic of'),(144,'MC','Monaco'),(145,'MN','Mongolia'),(146,'ME','Montenegro'),(147,'MS','Montserrat'),(148,'MA','Morocco'),(149,'MZ','Mozambique'),(150,'MM','Myanmar'),(151,'NA','Namibia'),(152,'NR','Nauru'),(153,'NP','Nepal'),(154,'NL','Netherlands'),(155,'AN','Netherlands Antilles'),(156,'NC','New Caledonia'),(157,'NZ','New Zealand'),(158,'NI','Nicaragua'),(159,'NE','Niger'),(160,'NG','Nigeria'),(161,'NU','Niue'),(162,'NF','Norfolk Island'),(163,'MP','Northern Mariana Islands'),(164,'NO','Norway'),(165,'OM','Oman'),(166,'PK','Pakistan'),(167,'PW','Palau'),(168,'PS','Palestine'),(169,'PA','Panama'),(170,'PG','Papua New Guinea'),(171,'PY','Paraguay'),(172,'PE','Peru'),(173,'PH','Philippines'),(174,'PN','Pitcairn'),(175,'PL','Poland'),(176,'PT','Portugal'),(177,'PR','Puerto Rico'),(178,'QA','Qatar'),(179,'RE','Reunion'),(180,'RO','Romania'),(181,'RU','Russian Federation'),(182,'RW','Rwanda'),(183,'KN','Saint Kitts and Nevis'),(184,'LC','Saint Lucia'),(185,'VC','Saint Vincent and the Grenadines'),(186,'WS','Samoa'),(187,'SM','San Marino'),(188,'ST','Sao Tome and Principe'),(189,'SA','Saudi Arabia'),(190,'SN','Senegal'),(191,'RS','Serbia'),(192,'SC','Seychelles'),(193,'SL','Sierra Leone'),(194,'SG','Singapore'),(195,'SK','Slovakia'),(196,'SI','Slovenia'),(197,'SB','Solomon Islands'),(198,'SO','Somalia'),(199,'ZA','South Africa'),(200,'GS','South Georgia South Sandwich Islands'),(201,'SS','South Sudan'),(202,'ES','Spain'),(203,'LK','Sri Lanka'),(204,'SH','St. Helena'),(205,'PM','St. Pierre and Miquelon'),(206,'SD','Sudan'),(207,'SR','Suriname'),(208,'SJ','Svalbard and Jan Mayen Islands'),(209,'SZ','Swaziland'),(210,'SE','Sweden'),(211,'CH','Switzerland'),(212,'SY','Syrian Arab Republic'),(213,'TW','Taiwan'),(214,'TJ','Tajikistan'),(215,'TZ','Tanzania, United Republic of'),(216,'TH','Thailand'),(217,'TG','Togo'),(218,'TK','Tokelau'),(219,'TO','Tonga'),(220,'TT','Trinidad and Tobago'),(221,'TN','Tunisia'),(222,'TR','Turkey'),(223,'TM','Turkmenistan'),(224,'TC','Turks and Caicos Islands'),(225,'TV','Tuvalu'),(226,'UG','Uganda'),(227,'UA','Ukraine'),(228,'AE','United Arab Emirates'),(229,'GB','United Kingdom'),(230,'US','United States'),(231,'UM','United States minor outlying islands'),(232,'UY','Uruguay'),(233,'UZ','Uzbekistan'),(234,'VU','Vanuatu'),(235,'VA','Vatican City State'),(236,'VE','Venezuela'),(237,'VN','Vietnam'),(238,'VG','Virgin Islands (British)'),(239,'vi','Virgin Islands (U.S.)'),(240,'WF','Wallis and Futuna Islands'),(241,'EH','Western Sahara'),(242,'YE','Yemen'),(243,'ZR','Zaire'),(244,'ZM','Zambia'),(245,'ZW','Zimbabwe');

--
-- Table structure for table `sc_shop_currency`
--

CREATE TABLE `sc_shop_currency` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exchange_rate` double(8,2) NOT NULL,
  `precision` tinyint NOT NULL DEFAULT '2',
  `symbol_first` tinyint NOT NULL DEFAULT '0',
  `thousands` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ',',
  `status` tinyint NOT NULL DEFAULT '0',
  `sort` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_currency_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_currency`
--

INSERT INTO `sc_shop_currency` VALUES (1,'USD Dola','USD','$',1.00,2,1,',',0,0,NULL,'2024-10-08 09:39:20'),(2,'VietNam Dong','VND','₫',20000.00,0,0,',',0,1,NULL,'2024-10-08 09:05:08'),(3,'Rupees','Rs.','Rs',1.00,0,1,',',1,0,'2024-10-08 09:39:11','2024-10-08 09:39:11');

--
-- Table structure for table `sc_shop_custom_field`
--

CREATE TABLE `sc_shop_custom_field` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'shop_product, shop_customer,...',
  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  `option` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'radio, select, input',
  `default` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '{"value1":"name1", "value2":"name2"}',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_custom_field_type_index` (`type`),
  KEY `sc_shop_custom_field_code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_custom_field`
--


--
-- Table structure for table `sc_shop_custom_field_detail`
--

CREATE TABLE `sc_shop_custom_field_detail` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_field_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rel_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ID of product, customer,...',
  `text` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_custom_field_detail_custom_field_id_index` (`custom_field_id`),
  KEY `sc_shop_custom_field_detail_rel_id_index` (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_custom_field_detail`
--


--
-- Table structure for table `sc_shop_customer`
--

CREATE TABLE `sc_shop_customer` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint DEFAULT NULL COMMENT '0:women, 1:men',
  `birthday` date DEFAULT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'VN',
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `group` tinyint NOT NULL DEFAULT '1',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `provider` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_customer_email_provider_provider_id_unique` (`email`,`provider`,`provider_id`),
  KEY `sc_shop_customer_address_id_index` (`address_id`),
  KEY `sc_shop_customer_store_id_index` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_customer`
--


--
-- Table structure for table `sc_shop_customer_address`
--

CREATE TABLE `sc_shop_customer_address` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'VN',
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_customer_address_customer_id_index` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_customer_address`
--


--
-- Table structure for table `sc_shop_email_template`
--

CREATE TABLE `sc_shop_email_template` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `status` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_email_template_store_id_index` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_email_template`
--

INSERT INTO `sc_shop_email_template` VALUES ('9d301b85-db7b-46b9-9bf1-ffced1ffa691','Reset password','forgot_password','\n<h1 style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#2f3133;font-size:19px;font-weight:bold;margin-top:0;text-align:left\">{{$title}}</h1>\n<p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;font-size:16px;line-height:1.5em;margin-top:0;text-align:left\">{{$reason_sendmail}}</p>\n<table class=\"action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;margin:30px auto;padding:0;text-align:center;width:100%\">\n<tbody>\n    <tr>\n    <td align=\"center\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n        <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n            <tbody>\n                <tr>\n                <td align=\"center\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n                    <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n                        <tbody>\n                            <tr>\n                            <td style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n                                <a href=\"{{$reset_link}}\" class=\"button button-primary\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;border-radius:3px;color:#fff;display:inline-block;text-decoration:none;background-color:#3097d1;border-top:10px solid #3097d1;border-right:18px solid #3097d1;border-bottom:10px solid #3097d1;border-left:18px solid #3097d1\" target=\"_blank\">{{$reset_button}}</a>\n                            </td>\n                            </tr>\n                        </tbody>\n                    </table>\n                </td>\n                </tr>\n            </tbody>\n        </table>\n    </td>\n    </tr>\n    </tbody>\n    </table>\n    <p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;font-size:16px;line-height:1.5em;margin-top:0;text-align:left\">\n    {{$note_sendmail}}\n    </p>\n    <table class=\"subcopy\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;border-top:1px solid #edeff2;margin-top:25px;padding-top:25px\">\n    <tbody>\n    <tr>\n        <td style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n            <p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;line-height:1.5em;margin-top:0;text-align:left;font-size:12px\">{{$note_access_link}}</p>\n        </td>\n    </tr>\n    </tbody>\n</table>','1',1,NULL,NULL),('9d301b85-db89-4832-a308-d30ccb93cf81','Customer verification','customer_verify','\n<h1 style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#2f3133;font-size:19px;font-weight:bold;margin-top:0;text-align:left\">{{$title}}</h1>\n<p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;font-size:16px;line-height:1.5em;margin-top:0;text-align:left\">{{$reason_sendmail}}</p>\n<table class=\"action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;margin:30px auto;padding:0;text-align:center;width:100%\">\n    <tbody>\n    <tr>\n        <td align=\"center\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n            <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n                <tbody>\n                <tr>\n                    <td align=\"center\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n                        <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n                            <tbody>\n                            <tr>\n                                <td style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n                                    <a href=\"{{$url_verify}}\" class=\"button button-primary\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;border-radius:3px;color:#fff;display:inline-block;text-decoration:none;background-color:#3097d1;border-top:10px solid #3097d1;border-right:18px solid #3097d1;border-bottom:10px solid #3097d1;border-left:18px solid #3097d1\" target=\"_blank\">{{$button}}</a>\n                                </td>\n                            </tr>\n                            </tbody>\n                        </table>\n                    </td>\n                </tr>\n                </tbody>\n            </table>\n        </td>\n    </tr>\n    </tbody>\n    </table>\n    <p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;font-size:16px;line-height:1.5em;margin-top:0;text-align:left\">\n    {{$note_sendmail}}\n    </p>\n    <table class=\"subcopy\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;border-top:1px solid #edeff2;margin-top:25px;padding-top:25px\">\n    <tbody>\n    <tr>\n        <td style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n            <p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;line-height:1.5em;margin-top:0;text-align:left;font-size:12px\">{{$note_access_link}}</p>\n        </td>\n    </tr>\n    </tbody>\n</table>','1',1,NULL,NULL),('9d301b85-db8d-4a0c-b23e-ea17f7c95f66','Welcome new customer','welcome_customer','\n<h1 style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#2f3133;font-size:19px;font-weight:bold;margin-top:0;text-align:center\">{{$title}}</h1>\n<p style=\"text-align:center;\">Welcome to my site!</p>','1',1,NULL,NULL),('9d301b85-db92-4356-9a83-c3fd31c440f6','Send form contact to admin','contact_to_admin','\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n<tr>\n   <td>\n      <b>Name</b>: {{$name}}<br>\n      <b>Email</b>: {{$email}}<br>\n      <b>Phone</b>: {{$phone}}<br>\n   </td>\n</tr>\n</table>\n<hr>\n<p style=\"text-align: center;\">Content:<br>\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n<tr>\n   <td>{{$content}}</td>\n</tr>\n</table>','1',1,NULL,NULL),('9d301b85-db96-4553-a159-a8acc025726e','New order to admin','order_success_to_admin','\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n<tr>\n   <td>\n      <b>Order ID</b>: {{$orderID}}<br>\n      <b>Customer name</b>: {{$toname}}<br>\n      <b>Email</b>: {{$email}}<br>\n      <b>Address</b>: {{$address}}<br>\n      <b>Phone</b>: {{$phone}}<br>\n      <b>Order note</b>: {{$comment}}\n   </td>\n</tr>\n</table>\n<hr>\n<p style=\"text-align: center;\">Order detail:<br>\n   ===================================<br>\n</p>\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" border=\"1\">\n{{$orderDetail}}\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Sub total</td>\n   <td colspan=\"2\" align=\"right\">{{$subtotal}}</td>\n</tr>\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Shipping fee</td>\n   <td colspan=\"2\" align=\"right\">{{$shipping}}</td>\n</tr>\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Discount</td>\n   <td colspan=\"2\" align=\"right\">{{$discount}}</td>\n</tr>\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Other Fee</td>\n   <td colspan=\"2\" align=\"right\">{{$otherFee}}</td>\n</tr>\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Total</td>\n   <td colspan=\"2\" align=\"right\">{{$total}}</td>\n</tr>\n</table>','1',1,NULL,NULL),('9d301b85-db99-43f6-8832-c4954eaeadcf','New order to customr','order_success_to_customer','\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n<tr>\n   <td>\n      <b>Order ID</b>: {{$orderID}}<br>\n      <b>Customer name</b>: {{$toname}}<br>\n      <b>Address</b>: {{$address}}<br>\n      <b>Phone</b>: {{$phone}}<br>\n      <b>Order note</b>: {{$comment}}\n   </td>\n</tr>\n</table>\n<hr>\n<p style=\"text-align: center;\">Order detail:<br>\n   ===================================<br>\n</p>\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" border=\"1\">\n{{$orderDetail}}\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Sub total</td>\n   <td colspan=\"2\" align=\"right\">{{$subtotal}}</td>\n</tr>\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Shipping fee</td>\n   <td colspan=\"2\" align=\"right\">{{$shipping}}</td>\n</tr>\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Discount</td>\n   <td colspan=\"2\" align=\"right\">{{$discount}}</td>\n</tr>\n<tr>\n   <td colspan=\"2\"></td>\n   <td colspan=\"2\" style=\"font-weight: bold;\">Total</td>\n   <td colspan=\"2\" align=\"right\">{{$total}}</td>\n</tr>\n</table>','1',1,NULL,NULL);

--
-- Table structure for table `sc_shop_language`
--

CREATE TABLE `sc_shop_language` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `rtl` tinyint DEFAULT '0' COMMENT 'Layout RTL',
  `sort` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_language_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_language`
--

INSERT INTO `sc_shop_language` VALUES (1,'English','en','/data/language/flag_uk.png',1,0,1,NULL,NULL),(2,'Tiếng Việt','vi','/data/language/flag_vn.png',0,0,2,NULL,'2024-10-08 09:00:30');

--
-- Table structure for table `sc_shop_layout_page`
--

CREATE TABLE `sc_shop_layout_page` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_layout_page_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_layout_page`
--

INSERT INTO `sc_shop_layout_page` VALUES (1,'home','admin.layout_page_position.home',NULL,NULL),(2,'shop_home','admin.layout_page_position.shop_home',NULL,NULL),(3,'shop_search','admin.layout_page_position.shop_search',NULL,NULL),(4,'shop_product_list','admin.layout_page_position.product_list',NULL,NULL),(5,'product_detail','admin.layout_page_position.product_detail',NULL,NULL),(6,'shop_cart','admin.layout_page_position.shop_cart',NULL,NULL),(7,'shop_item_list','admin.layout_page_position.item_list',NULL,NULL),(8,'shop_item_detail','admin.layout_page_position.item_detail',NULL,NULL),(9,'shop_news','admin.layout_page_position.news_list',NULL,NULL),(10,'shop_news_detail','admin.layout_page_position.news_detail',NULL,NULL),(11,'shop_auth','admin.layout_page_position.shop_auth',NULL,NULL),(12,'shop_profile','admin.layout_page_position.shop_profile',NULL,NULL),(13,'shop_page','admin.layout_page_position.shop_page',NULL,NULL),(14,'shop_contact','admin.layout_page_position.shop_contact',NULL,NULL),(15,'content_list','admin.layout_page_position.content_list',NULL,NULL),(16,'content_detail','admin.layout_page_position.content_detail',NULL,NULL),(17,'vendor_home','admin.layout_page_position.vendor_home',NULL,NULL),(18,'store_product_list','admin.layout_page_position.store_product_list',NULL,NULL);

--
-- Table structure for table `sc_shop_layout_position`
--

CREATE TABLE `sc_shop_layout_position` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_layout_position_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_layout_position`
--

INSERT INTO `sc_shop_layout_position` VALUES (1,'header','admin.layout_page_block.header',NULL,NULL),(2,'banner_top','admin.layout_page_block.banner_top',NULL,NULL),(3,'top','admin.layout_page_block.top',NULL,NULL),(4,'left','admin.layout_page_block.left',NULL,NULL),(5,'right','admin.layout_page_block.right',NULL,NULL),(6,'bottom','admin.layout_page_block.bottom',NULL,NULL);

--
-- Table structure for table `sc_shop_length`
--

CREATE TABLE `sc_shop_length` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_length_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_length`
--

INSERT INTO `sc_shop_length` VALUES (1,'mm','Millimeter',NULL,NULL),(2,'cm','Centimeter',NULL,NULL),(3,'m','Meter ',NULL,NULL),(4,'in','Inch ',NULL,NULL);

--
-- Table structure for table `sc_shop_link`
--

CREATE TABLE `sc_shop_link` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Location of the link: footer, menu,...',
  `module` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Related components (plugins, templates).\n Used to track, remove when the relevant component is removed.',
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Distinguish between Link and Collection. \nValue collection|null',
  `collection_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Collection\\''s ID',
  `status` tinyint NOT NULL DEFAULT '0',
  `sort` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_link`
--

INSERT INTO `sc_shop_link` VALUES ('1','front.about','route::page.detail::about','_self','menu',NULL,NULL,NULL,1,50,NULL,NULL),('2','S-Cart','#collection','_self','menu',NULL,'collection',NULL,1,60,NULL,NULL),('3','About us','https://s-cart.org/en/about.html','_self','menu',NULL,NULL,'2',1,10,NULL,NULL),('4','Github','https://github.com/s-cart/s-cart','_self','menu',NULL,NULL,'2',1,20,NULL,NULL),('9d301b85-dde8-4e15-9fa0-bd332f7137a2','front.home','route::home','_self','menu','',NULL,NULL,1,10,NULL,NULL),('9d301b85-ddf4-4bf0-955a-8ba8b6e15581','front.shop','route::shop','_self','menu','',NULL,NULL,1,20,NULL,NULL),('9d301b85-ddf8-4c73-8372-971dfa81e45b','front.blog','route::news','_self','menu','',NULL,NULL,1,30,NULL,NULL),('9d301b85-ddfc-4be3-90fb-7471137a1112','front.contact','route::contact','_self','menu','',NULL,NULL,1,40,NULL,NULL),('9d301b85-de02-419d-a407-38dd89ee45a3','front.my_profile','route::login','_self','footer','',NULL,NULL,1,60,NULL,NULL),('9d301b85-de05-4958-9646-11232f2a3d99','front.compare_page','route::compare','_self','footer','',NULL,NULL,1,70,NULL,NULL),('9d301b85-de09-4fc9-b60a-bbea1b556e0d','front.wishlist_page','route::wishlist','_self','footer','',NULL,NULL,1,80,NULL,NULL);

--
-- Table structure for table `sc_shop_link_group`
--

CREATE TABLE `sc_shop_link_group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_link_group_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_link_group`
--

INSERT INTO `sc_shop_link_group` VALUES (1,'menu','Menu main',NULL,NULL),(2,'menu_left','Menu left',NULL,NULL),(3,'menu_right','Menu right',NULL,NULL),(4,'footer','Footer main',NULL,NULL),(5,'footer_left','Footer left',NULL,NULL),(6,'footer_right','Footer right',NULL,NULL),(7,'sidebar','Sidebar',NULL,NULL);

--
-- Table structure for table `sc_shop_link_store`
--

CREATE TABLE `sc_shop_link_store` (
  `link_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`link_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_link_store`
--

INSERT INTO `sc_shop_link_store` VALUES ('1','1'),('2','1'),('3','1'),('4','1'),('9d301b85-dde8-4e15-9fa0-bd332f7137a2','1'),('9d301b85-ddf4-4bf0-955a-8ba8b6e15581','1'),('9d301b85-ddf8-4c73-8372-971dfa81e45b','1'),('9d301b85-ddfc-4be3-90fb-7471137a1112','1'),('9d301b85-de02-419d-a407-38dd89ee45a3','1'),('9d301b85-de05-4958-9646-11232f2a3d99','1'),('9d301b85-de09-4fc9-b60a-bbea1b556e0d','1');

--
-- Table structure for table `sc_shop_news`
--

CREATE TABLE `sc_shop_news` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` int NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_news_alias_index` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_news`
--

INSERT INTO `sc_shop_news` VALUES ('9d301b87-171f-4b41-a3bc-3c7332413de4','/data/content/blog-1.jpg','demo-scart-blog-1',0,1,'2024-10-07 16:40:58',NULL),('9d301b87-1730-4438-bc55-f3b3dabc5feb','/data/content/blog-2.jpg','demo-scart-blog-2',0,1,'2024-10-07 16:40:58',NULL),('9d301b87-1734-463f-8f29-1b4e8431cd5b','/data/content/blog-3.jpg','demo-scart-blog-3',0,1,'2024-10-07 16:40:58',NULL),('9d301b87-1738-4182-9001-f6ba3afed447','/data/content/blog-4.jpg','demo-scart-blog-4',0,1,'2024-10-07 16:40:58',NULL),('9d301b87-173b-4223-8373-10ecf2937efc','/data/content/blog-5.jpg','demo-scart-blog-5',0,1,'2024-10-07 16:40:58',NULL),('9d301b87-173f-4ccb-8870-6822a4178f1f','/data/content/blog-6.jpg','demo-scart-blog-6',0,1,'2024-10-07 16:40:58',NULL);

--
-- Table structure for table `sc_shop_news_description`
--

CREATE TABLE `sc_shop_news_description` (
  `news_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` mediumtext COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `sc_shop_news_description_news_id_lang_unique` (`news_id`,`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_news_description`
--

INSERT INTO `sc_shop_news_description` VALUES ('9d301b87-171f-4b41-a3bc-3c7332413de4','en','Best Wedding venue booking platform',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-171f-4b41-a3bc-3c7332413de4','vi','Easy Polo Black Edition 1',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-1730-4438-bc55-f3b3dabc5feb','en','Easy Polo Black Edition 2',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-1730-4438-bc55-f3b3dabc5feb','vi','Easy Polo Black Edition 2',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-1734-463f-8f29-1b4e8431cd5b','en','Easy Polo Black Edition 3',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-1734-463f-8f29-1b4e8431cd5b','vi','Easy Polo Black Edition 3',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-1738-4182-9001-f6ba3afed447','en','Easy Polo Black Edition 4',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-1738-4182-9001-f6ba3afed447','vi','Easy Polo Black Edition 4',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-173b-4223-8373-10ecf2937efc','en','Easy Polo Black Edition 5',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-173b-4223-8373-10ecf2937efc','vi','Easy Polo Black Edition 5',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-173f-4ccb-8870-6822a4178f1f','en','Easy Polo Black Edition 6',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-173f-4ccb-8870-6822a4178f1f','vi','Easy Polo Black Edition 6',NULL,'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>');

--
-- Table structure for table `sc_shop_news_store`
--

CREATE TABLE `sc_shop_news_store` (
  `news_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`news_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_news_store`
--

INSERT INTO `sc_shop_news_store` VALUES ('9d301b87-171f-4b41-a3bc-3c7332413de4','1'),('9d301b87-1730-4438-bc55-f3b3dabc5feb','1'),('9d301b87-1734-463f-8f29-1b4e8431cd5b','1'),('9d301b87-1738-4182-9001-f6ba3afed447','1'),('9d301b87-173b-4223-8373-10ecf2937efc','1'),('9d301b87-173f-4ccb-8870-6822a4178f1f','1');

--
-- Table structure for table `sc_shop_order`
--

CREATE TABLE `sc_shop_order` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtotal` decimal(15,2) DEFAULT '0.00',
  `shipping` decimal(15,2) DEFAULT '0.00',
  `discount` decimal(15,2) DEFAULT '0.00',
  `payment_status` int NOT NULL DEFAULT '1',
  `shipping_status` int NOT NULL DEFAULT '1',
  `status` int NOT NULL DEFAULT '0',
  `tax` decimal(15,2) DEFAULT '0.00',
  `other_fee` decimal(15,2) DEFAULT '0.00',
  `total` decimal(15,2) DEFAULT '0.00',
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exchange_rate` decimal(15,2) DEFAULT NULL,
  `received` decimal(15,2) DEFAULT '0.00',
  `balance` decimal(15,2) DEFAULT '0.00',
  `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'VN',
  `company` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_method` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'other',
  `ip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_order_customer_id_index` (`customer_id`),
  KEY `sc_shop_order_device_type_index` (`device_type`),
  KEY `sc_shop_order_store_id_index` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_order`
--


--
-- Table structure for table `sc_shop_order_detail`
--

CREATE TABLE `sc_shop_order_detail` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(15,2) NOT NULL DEFAULT '0.00',
  `qty` int NOT NULL DEFAULT '0',
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `total_price` decimal(15,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(15,2) NOT NULL DEFAULT '0.00',
  `sku` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exchange_rate` double(8,2) DEFAULT NULL,
  `attribute` varchar(100) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `sc_shop_order_detail`
--


--
-- Table structure for table `sc_shop_order_history`
--

CREATE TABLE `sc_shop_order_history` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `customer_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `order_status_id` int NOT NULL DEFAULT '0',
  `add_date` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_order_history`
--


--
-- Table structure for table `sc_shop_order_status`
--

CREATE TABLE `sc_shop_order_status` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_order_status`
--

INSERT INTO `sc_shop_order_status` VALUES (1,'New',NULL,NULL),(2,'Processing',NULL,NULL),(3,'Hold',NULL,NULL),(4,'Canceled',NULL,NULL),(5,'Done',NULL,NULL),(6,'Failed',NULL,NULL);

--
-- Table structure for table `sc_shop_order_total`
--

CREATE TABLE `sc_shop_order_total` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` decimal(15,2) NOT NULL DEFAULT '0.00',
  `text` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_order_total_order_id_index` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_order_total`
--


--
-- Table structure for table `sc_shop_page`
--

CREATE TABLE `sc_shop_page` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_page_alias_index` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_page`
--

INSERT INTO `sc_shop_page` VALUES ('1',NULL,'about',1,NULL,'2024-10-07 18:14:25');

--
-- Table structure for table `sc_shop_page_description`
--

CREATE TABLE `sc_shop_page_description` (
  `page_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` mediumtext COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `sc_shop_page_description_page_id_lang_unique` (`page_id`,`lang`),
  KEY `sc_shop_page_description_lang_index` (`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_page_description`
--

INSERT INTO `sc_shop_page_description` VALUES ('1','en','About',NULL,NULL,'<h1><span style=\"font-size:16px;\">Why Beautiful Story?</span></h1>\r\n\r\n<p>Organising a fabulous wedding is all about having a fabulous team. It&rsquo;s these experts who work behind the scene so that you can see your dreams come to life on your special day. We at Fab Weddings help you scout for the best teams of professionals for all your wedding and other special occasion services requirements.<br />\r\n<br />\r\n&nbsp;</p>\r\n\r\n<h1><span style=\"font-size:16px;\">How we do it ?</span></h1>\r\n\r\n<p>We value your time and hence our focus is not on offering the longest, largest or most comprehensive list of vendors that is more likely to confuse you &amp; your dear ones. We offer crisp, curated lists of vendors for you choose from. If you are too pressed for time Call our Wedding Stylists at +91 9000000000&nbsp;and they will do the rest.<br />\r\n<br />\r\n&nbsp;</p>\r\n\r\n<h1><span style=\"font-size:16px;\">Wedding Stylists</span></h1>\r\n\r\n<p>Our team of Wedding stylists with expertise in attire, makeup, photography, decor, venue and culinary arts spend hours reviewing, vetting and curating scores of special occasions service professionals who fit the bill for different locations, budgets and requirements. They are just a call away from serving all your wedding requirements. Call us right now at +91 9000000000</p>'),('1','vi','About Us',NULL,NULL,'<h1>Why Beautiful Story?</h1>\r\n\r\n<p>Organising a fabulous wedding is all about having a fabulous team. It&rsquo;s these experts who work behind the scene so that you can see your dreams come to life on your special day. We at Fab Weddings help you scout for the best teams of professionals for all your wedding and other special occasion services requirements.</p>\r\n\r\n<h1>How we do it ?</h1>\r\n\r\n<p>We value your time and hence our focus is not on offering the longest, largest or most comprehensive list of vendors that is more likely to confuse you &amp; your dear ones. We offer crisp, curated lists of vendors for you choose from. If you are too pressed for time Call our Wedding Stylists at +91 9000000000&nbsp;and they will do the rest.</p>\r\n\r\n<h1>Wedding Stylists</h1>\r\n\r\n<p>Our team of Wedding stylists with expertise in attire, makeup, photography, decor, venue and culinary arts spend hours reviewing, vetting and curating scores of special occasions service professionals who fit the bill for different locations, budgets and requirements. They are just a call away from serving all your wedding requirements. Call us right now at +91 9000000000</p>');

--
-- Table structure for table `sc_shop_page_store`
--

CREATE TABLE `sc_shop_page_store` (
  `page_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`page_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_page_store`
--

INSERT INTO `sc_shop_page_store` VALUES ('1','1');

--
-- Table structure for table `sc_shop_password_resets`
--

CREATE TABLE `sc_shop_password_resets` (
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  KEY `sc_shop_password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_password_resets`
--


--
-- Table structure for table `sc_shop_payment_status`
--

CREATE TABLE `sc_shop_payment_status` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_payment_status`
--

INSERT INTO `sc_shop_payment_status` VALUES (1,'Unpaid',NULL,NULL),(2,'Partial payment',NULL,NULL),(3,'Paid',NULL,NULL),(4,'Refurn',NULL,NULL);

--
-- Table structure for table `sc_shop_product`
--

CREATE TABLE `sc_shop_product` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `upc` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'upc code',
  `ean` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ean code',
  `jan` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'jan code',
  `isbn` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'isbn code',
  `mpn` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'mpn code',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `brand_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `supplier_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `price` decimal(15,2) DEFAULT '0.00',
  `cost` decimal(15,2) DEFAULT '0.00',
  `stock` int DEFAULT '0',
  `sold` int DEFAULT '0',
  `minimum` int DEFAULT '0',
  `weight_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` decimal(15,2) DEFAULT '0.00',
  `length_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `length` decimal(15,2) DEFAULT '0.00',
  `width` decimal(15,2) DEFAULT '0.00',
  `height` decimal(15,2) DEFAULT '0.00',
  `kind` tinyint DEFAULT '0' COMMENT '0:single, 1:bundle, 2:group',
  `property` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'physical',
  `tax_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '0:No-tax, auto: Use tax default',
  `status` tinyint NOT NULL DEFAULT '0',
  `approve` tinyint NOT NULL DEFAULT '1',
  `sort` int NOT NULL DEFAULT '0',
  `view` int NOT NULL DEFAULT '0',
  `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_lastview` timestamp NULL DEFAULT NULL,
  `date_available` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_product_sku_index` (`sku`),
  KEY `sc_shop_product_brand_id_index` (`brand_id`),
  KEY `sc_shop_product_supplier_id_index` (`supplier_id`),
  KEY `sc_shop_product_kind_index` (`kind`),
  KEY `sc_shop_product_property_index` (`property`),
  KEY `sc_shop_product_tax_id_index` (`tax_id`),
  KEY `sc_shop_product_status_index` (`status`),
  KEY `sc_shop_product_approve_index` (`approve`),
  KEY `sc_shop_product_alias_index` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product`
--

INSERT INTO `sc_shop_product` VALUES ('9d301b87-36d8-4696-9804-bb2a78799326','NEM-NUONG-THANH-HOA',NULL,NULL,NULL,NULL,NULL,'/data/product/product-2.png','9d301b87-2bad-40be-b155-723619a09802','9d301b87-294d-449f-a7c6-6d31384c5640',60.00,0.00,100,0,0,NULL,0.00,NULL,0.00,0.00,0.00,0,'physical','auto',1,1,0,0,'nem-nuong-thanh-hoa',NULL,NULL,NULL,NULL),('9d301b87-3714-4be0-9673-adfed9eede6b','KEO-DUA-BEN-TRE',NULL,NULL,NULL,NULL,NULL,'/data/product/product-17.png','9d301b87-2b89-4fec-af98-28ee54b424e3','9d301b87-293f-41fb-9143-355a7c6a6867',80.00,0.00,100,0,0,NULL,0.00,NULL,0.00,0.00,0.00,0,'physical','auto',1,1,0,0,'keo-dua-ben-tre',NULL,NULL,NULL,NULL),('9d3026bb-97a3-4a20-bf9d-3c2871741344','WV1',NULL,NULL,NULL,NULL,NULL,'/data/product/Venue 1.jpg','9d3025ba-f332-4448-8163-f3c3c00b5bf7','9d301b87-293f-41fb-9143-355a7c6a6867',90000.00,100000.00,2,0,0,'oz',0.00,'in',0.00,0.00,0.00,0,'physical','0',1,1,0,4,'wedding-venues-radisson','2024-10-08 09:44:01',NULL,'2024-10-07 17:12:18','2024-10-08 09:44:01'),('9d304499-8c56-4c0d-9739-84d581e8c6d6','WV2',NULL,NULL,NULL,NULL,NULL,'/data/product/Venue 1.jpg','','',0.00,0.00,0,0,0,'oz',0.00,'in',0.00,0.00,0.00,0,'physical','0',1,1,0,0,'grand-hayatt',NULL,NULL,'2024-10-07 18:35:49','2024-10-07 18:36:59');

--
-- Table structure for table `sc_shop_product_attribute`
--

CREATE TABLE `sc_shop_product_attribute` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_group_id` int NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `add_price` decimal(15,2) NOT NULL DEFAULT '0.00',
  `sort` int NOT NULL DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `sc_shop_product_attribute_product_id_attribute_group_id_index` (`product_id`,`attribute_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_attribute`
--


--
-- Table structure for table `sc_shop_product_build`
--

CREATE TABLE `sc_shop_product_build` (
  `build_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int NOT NULL,
  PRIMARY KEY (`build_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_build`
--


--
-- Table structure for table `sc_shop_product_category`
--

CREATE TABLE `sc_shop_product_category` (
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`product_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_category`
--

INSERT INTO `sc_shop_product_category` VALUES ('9d3026bb-97a3-4a20-bf9d-3c2871741344','9d30243c-01de-42ce-bf80-09847ab52eb4'),('9d304499-8c56-4c0d-9739-84d581e8c6d6','9d30243c-01de-42ce-bf80-09847ab52eb4');

--
-- Table structure for table `sc_shop_product_description`
--

CREATE TABLE `sc_shop_product_description` (
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` mediumtext COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `sc_shop_product_description_product_id_lang_unique` (`product_id`,`lang`),
  KEY `sc_shop_product_description_lang_index` (`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_description`
--

INSERT INTO `sc_shop_product_description` VALUES ('9d301b87-36d8-4696-9804-bb2a78799326','en','Nem Nuong Thanh Hoa',NULL,'- 27-inch (diagonal) Retina 5K display\n        - 3.1GHz 6-core 10th-generation Intel Core i5\n        - AMD Radeon Pro 5300 graphics','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-36d8-4696-9804-bb2a78799326','vi','Nem Nuong Thanh Hoa',NULL,'- 27-inch (diagonal) Retina 5K display\n        - 3.1GHz 6-core 10th-generation Intel Core i5\n        - AMD Radeon Pro 5300 graphics','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-3714-4be0-9673-adfed9eede6b','en','Keo Dua Ben Tre',NULL,'- 27-inch (diagonal) Retina 5K display\n        - 3.1GHz 6-core 10th-generation Intel Core i5\n        - AMD Radeon Pro 5300 graphics','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d301b87-3714-4be0-9673-adfed9eede6b','vi','Keo Dua Ben Tre',NULL,'- 27-inch (diagonal) Retina 5K display\n        - 3.1GHz 6-core 10th-generation Intel Core i5\n        - AMD Radeon Pro 5300 graphics','<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 150px; float: right; margin: 10px;\" /></p>\n                <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),('9d3026bb-97a3-4a20-bf9d-3c2871741344','en','Radisson Blue','wedding venues in Delhi','Wedding Venues in Gurgaon','<p>Selecting venues for weddings is one of the biggest and the most important decisions a couple has to take when planning for their wedding. After all, you would want to book one of the best wedding venues in Delhi/NCR, that comes with a great package and best deals! There is a wide variety of venue options in Delhi/NCR for you to choose from, right from banquet halls to poolside venues, from lawns to resorts, you can find them all.</p>\r\n\r\n<p>Delhi weddings are known for their glitz and style and the venues in the city are a testament to this fact. It is home to some of the most beautiful locations to get married at. The rich opulence of The Ritz by Ferns N Petals, the stunning views at The Palms Town &amp; Country Club or the natural beauty of Zorba &ndash; whatever your dream destination is, you&rsquo;ll find it here. Want to book the perfect location for your nuptials? Our guide to the best wedding venues in Delhi/NCR might help!</p>\r\n\r\n<p>WMG is a wedding planning app and website that helps one in finding wedding vendors in any city sitting at one place. Be it wedding venues,&nbsp;<a href=\"https://www.wedmegood.com/vendors/delhi-ncr/wedding-photographers/\">Delhi wedding photographers</a>,&nbsp;<a href=\"https://www.wedmegood.com/vendors/delhi-ncr/bridal-makeup/\">bridal makeup artists in Delhi</a>&nbsp;or bridal jewellers amongst many others. All you need to do is visit the WMG website or&nbsp;<a href=\"https://play.google.com/store/apps/details?id=com.wedmegood.planner&amp;hl=en_IN\">Download the WMG App available on Android</a>&nbsp;as well as&nbsp;<a href=\"https://apps.apple.com/in/app/wedmegood-wedding-planner/id1043872365\">iOS</a>.</p>\r\n\r\n<p>WedMeGood is a trusted wedding planning platform listing thousands of verified wedding vendors. You can find more than 1000 wedding venues in Delhi with a capacity of 500-1500 pax ranging from INR 500 to 1500 price per plate. From veg to non veg, venues with inhouse bar, dj &amp; decor to the ones allowing outside decor &amp; caterers, at wedmegood you can find venues of your choice in and around Delhi.</p>'),('9d3026bb-97a3-4a20-bf9d-3c2871741344','vi','Radisson Blue','wedding venues in delhi ncr','Wedding Venues in Gurgaon','<p>Selecting venues for weddings is one of the biggest and the most important decisions a couple has to take when planning for their wedding. After all, you would want to book one of the best wedding venues in Delhi/NCR, that comes with a great package and best deals! There is a wide variety of venue options in Delhi/NCR for you to choose from, right from banquet halls to poolside venues, from lawns to resorts, you can find them all.</p>\r\n\r\n<p>Delhi weddings are known for their glitz and style and the venues in the city are a testament to this fact. It is home to some of the most beautiful locations to get married at. The rich opulence of The Ritz by Ferns N Petals, the stunning views at The Palms Town &amp; Country Club or the natural beauty of Zorba &ndash; whatever your dream destination is, you&rsquo;ll find it here. Want to book the perfect location for your nuptials? Our guide to the best wedding venues in Delhi/NCR might help!</p>\r\n\r\n<p>WMG is a wedding planning app and website that helps one in finding wedding vendors in any city sitting at one place. Be it wedding venues,&nbsp;<a href=\"https://www.wedmegood.com/vendors/delhi-ncr/wedding-photographers/\">Delhi wedding photographers</a>,&nbsp;<a href=\"https://www.wedmegood.com/vendors/delhi-ncr/bridal-makeup/\">bridal makeup artists in Delhi</a>&nbsp;or bridal jewellers amongst many others. All you need to do is visit the WMG website or&nbsp;<a href=\"https://play.google.com/store/apps/details?id=com.wedmegood.planner&amp;hl=en_IN\">Download the WMG App available on Android</a>&nbsp;as well as&nbsp;<a href=\"https://apps.apple.com/in/app/wedmegood-wedding-planner/id1043872365\">iOS</a>.</p>\r\n\r\n<p>WedMeGood is a trusted wedding planning platform listing thousands of verified wedding vendors. You can find more than 1000 wedding venues in Delhi with a capacity of 500-1500 pax ranging from INR 500 to 1500 price per plate. From veg to non veg, venues with inhouse bar, dj &amp; decor to the ones allowing outside decor &amp; caterers, at wedmegood you can find venues of your choice in and around Delhi.</p>'),('9d304499-8c56-4c0d-9739-84d581e8c6d6','en','Grand Hayatt',NULL,NULL,'&nbsp;&nbsp;'),('9d304499-8c56-4c0d-9739-84d581e8c6d6','vi','Grand Haytt',NULL,NULL,'&nbsp;fvnmvfdjm');

--
-- Table structure for table `sc_shop_product_download`
--

CREATE TABLE `sc_shop_product_download` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_download`
--


--
-- Table structure for table `sc_shop_product_group`
--

CREATE TABLE `sc_shop_product_group` (
  `group_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`group_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_group`
--


--
-- Table structure for table `sc_shop_product_image`
--

CREATE TABLE `sc_shop_product_image` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sc_shop_product_image_product_id_index` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_image`
--

INSERT INTO `sc_shop_product_image` VALUES ('9d301b87-3773-44ab-b193-90a9bd821d8a','/data/product/product-6.png','9d301b87-36d8-4696-9804-bb2a78799326'),('9d301b87-378a-4b93-8763-2f14db0c9adb','/data/product/product-11.png','9d301b87-36d8-4696-9804-bb2a78799326'),('9d301b87-378d-4582-8e3f-909f479947f3','/data/product/product-5.png','9d301b87-36d8-4696-9804-bb2a78799326'),('9d301b87-37ae-4e15-81ff-03f88d00005f','/data/product/product-16.png','9d301b87-3714-4be0-9673-adfed9eede6b'),('9d301b87-37b2-4d14-a2e6-5a9964aec54d','/data/product/product-6.png','9d301b87-3714-4be0-9673-adfed9eede6b'),('9d301b87-37b5-4ede-acff-0cca55809e67','/data/product/product-12.png','9d301b87-3714-4be0-9673-adfed9eede6b');

--
-- Table structure for table `sc_shop_product_promotion`
--

CREATE TABLE `sc_shop_product_promotion` (
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price_promotion` decimal(15,2) NOT NULL,
  `date_start` timestamp NULL DEFAULT NULL,
  `date_end` timestamp NULL DEFAULT NULL,
  `status_promotion` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_promotion`
--

INSERT INTO `sc_shop_product_promotion` VALUES ('9d301b87-36d8-4696-9804-bb2a78799326',30.00,NULL,NULL,1,NULL,NULL);

--
-- Table structure for table `sc_shop_product_property`
--

CREATE TABLE `sc_shop_product_property` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_product_property_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_property`
--

INSERT INTO `sc_shop_product_property` VALUES (1,'physical','Product physical',NULL,NULL),(2,'download','Product download',NULL,NULL);

--
-- Table structure for table `sc_shop_product_store`
--

CREATE TABLE `sc_shop_product_store` (
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`product_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_product_store`
--

INSERT INTO `sc_shop_product_store` VALUES ('9d301b87-36d8-4696-9804-bb2a78799326','1'),('9d301b87-3714-4be0-9673-adfed9eede6b','1'),('9d3026bb-97a3-4a20-bf9d-3c2871741344','1'),('9d304499-8c56-4c0d-9739-84d581e8c6d6','1');

--
-- Table structure for table `sc_shop_sessions`
--

CREATE TABLE `sc_shop_sessions` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `sc_shop_sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_sessions`
--


--
-- Table structure for table `sc_shop_shipping_standard`
--

CREATE TABLE `sc_shop_shipping_standard` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `fee` decimal(15,2) NOT NULL,
  `shipping_free` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_shipping_standard`
--

INSERT INTO `sc_shop_shipping_standard` VALUES (1,20.00,10000.00,NULL,NULL);

--
-- Table structure for table `sc_shop_shipping_status`
--

CREATE TABLE `sc_shop_shipping_status` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_shipping_status`
--

INSERT INTO `sc_shop_shipping_status` VALUES (1,'Not sent',NULL,NULL),(2,'Sending',NULL,NULL),(3,'Shipping done',NULL,NULL);

--
-- Table structure for table `sc_shop_shoppingcart`
--

CREATE TABLE `sc_shop_shoppingcart` (
  `identifier` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instance` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  KEY `sc_shop_shoppingcart_identifier_instance_index` (`identifier`,`instance`),
  KEY `sc_shop_shoppingcart_store_id_index` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_shoppingcart`
--


--
-- Table structure for table `sc_shop_store_block`
--

CREATE TABLE `sc_shop_store_block` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '0',
  `sort` int NOT NULL DEFAULT '0',
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `template` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_store_block_store_id_index` (`store_id`),
  KEY `sc_shop_store_block_template_index` (`template`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_store_block`
--

INSERT INTO `sc_shop_store_block` VALUES ('9d301b85-e1e2-4b09-a949-31996bd001de','Banner top (s-cart-light)','banner_top','home','view','banner_image',1,10,'1','s-cart-light',NULL,NULL),('9d301b85-e212-42d9-b211-939922f6ecaf','New product (s-cart-light)','top','home','view','product_new',1,20,'1','s-cart-light',NULL,NULL),('9d301b85-e222-41fc-8a3b-eef32d393841','Top news (s-cart-light)','bottom','home','view','top_news',1,10,'1','s-cart-light',NULL,NULL),('9d301b85-e22a-45e8-9fa7-bc8d5d4433bd','Category store left (s-cart-light)','left','shop_home,vendor_home,vendor_product_list','view','category_store_left',1,10,'1','s-cart-light',NULL,NULL),('9d301b85-e231-4b63-abf7-b19f1a38bd12','Category left (s-cart-light)','left','shop_product_list,shop_home','view','category_left',1,20,'1','s-cart-light',NULL,NULL),('9d301b85-e238-4b8e-9e5e-ced19116b3a3','Brand left (s-cart-light)','left','shop_product_list,shop_home','view','brand_left',1,30,'1','s-cart-light',NULL,NULL),('9d301b85-e23f-4eab-99df-71344c4ed16b','Product last view (s-cart-light)','left','*','view','product_lastview_left',1,40,'1','s-cart-light',NULL,NULL),('9d301b85-e248-45c2-accc-9d90fef57f50','Product special (s-cart-light)','left','*','view','product_special_left',1,30,'1','s-cart-light',NULL,NULL);

--
-- Table structure for table `sc_shop_store_css`
--

CREATE TABLE `sc_shop_store_css` (
  `css` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `sc_shop_store_css_store_id_template_unique` (`store_id`,`template`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_store_css`
--

INSERT INTO `sc_shop_store_css` VALUES ('####CSS HERE ######','1','s-cart-light',NULL,NULL);

--
-- Table structure for table `sc_shop_subscribe`
--

CREATE TABLE `sc_shop_subscribe` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_subscribe_email_index` (`email`),
  KEY `sc_shop_subscribe_store_id_index` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_subscribe`
--


--
-- Table structure for table `sc_shop_supplier`
--

CREATE TABLE `sc_shop_supplier` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `sort` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sc_shop_supplier_alias_index` (`alias`),
  KEY `sc_shop_supplier_store_id_index` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_supplier`
--

INSERT INTO `sc_shop_supplier` VALUES ('9d301b87-293f-41fb-9143-355a7c6a6867','Supplier ABC','supplier-abc','abc@gmail.com','0123456789','/data/supplier/supplier.jpg',NULL,NULL,1,'1',0,NULL,NULL),('9d301b87-294d-449f-a7c6-6d31384c5640','Supplier XYZ','supplier-xyz','xyz@gmail.com','0987654321','/data/supplier/supplier.jpg',NULL,NULL,1,'1',0,NULL,NULL);

--
-- Table structure for table `sc_shop_tax`
--

CREATE TABLE `sc_shop_tax` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_tax`
--

INSERT INTO `sc_shop_tax` VALUES (1,'Tax default (10%)',10,NULL,NULL);

--
-- Table structure for table `sc_shop_weight`
--

CREATE TABLE `sc_shop_weight` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_shop_weight_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sc_shop_weight`
--

INSERT INTO `sc_shop_weight` VALUES (1,'g','Gram',NULL,NULL),(2,'kg','Kilogram',NULL,NULL),(3,'lb','Pound ',NULL,NULL),(4,'oz','Ounce ',NULL,NULL);

--
-- Table structure for table `vendor_category`
--

CREATE TABLE `vendor_category` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `sort` int NOT NULL DEFAULT '0',
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vendor_category_alias_index` (`alias`),
  KEY `vendor_category_store_id_index` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_category`
--


--
-- Table structure for table `vendor_category_description`
--

CREATE TABLE `vendor_category_description` (
  `vendor_category_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  UNIQUE KEY `vendor_category_description_vendor_category_id_lang_unique` (`vendor_category_id`,`lang`),
  KEY `vendor_category_description_lang_index` (`lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_category_description`
--


--
-- Table structure for table `vendor_money_process`
--

CREATE TABLE `vendor_money_process` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_sum` int NOT NULL DEFAULT '0',
  `order_count` int NOT NULL DEFAULT '0',
  `amount` int NOT NULL DEFAULT '0',
  `commission_rate` int NOT NULL DEFAULT '0',
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_process` date NOT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'processing' COMMENT 'processing,pending,canceled,done',
  `date_pay` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vendor_money_process_store_id_index` (`store_id`),
  KEY `vendor_money_process_currency_index` (`currency`),
  KEY `vendor_money_process_date_process_index` (`date_process`),
  KEY `vendor_money_process_status_index` (`status`),
  KEY `vendor_money_process_date_pay_index` (`date_pay`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_money_process`
--


--
-- Table structure for table `vendor_password_resets`
--

CREATE TABLE `vendor_password_resets` (
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  KEY `vendor_password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_password_resets`
--


--
-- Table structure for table `vendor_product_category`
--

CREATE TABLE `vendor_product_category` (
  `vendor_category_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  UNIQUE KEY `vendor_product_category_vendor_category_id_product_id_unique` (`vendor_category_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_product_category`
--


--
-- Table structure for table `vendor_user`
--

CREATE TABLE `vendor_user` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'VN',
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vendor_user_store_id_index` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_user`
--



