--
-- Host: 127.0.0.1    Database: adminpanel
-- ------------------------------------------------------


--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `content` longtext DEFAULT NULL,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about_us`
--


--
-- Table structure for table `auth`
--

CREATE TABLE `auth` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT 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 `auth`
--

INSERT INTO `auth` VALUES (1,'Customer',NULL,NULL,NULL),(2,'Director',NULL,NULL,NULL),(3,'Marketing',NULL,NULL,NULL);

--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_text` longtext NOT NULL,
  `category_id` int(11) NOT NULL,
  `replyIn` int(11) DEFAULT NULL,
  `replyOut` int(11) DEFAULT NULL,
  `confirm` int(11) NOT NULL DEFAULT 0,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_comments_user_id_foreign` (`user_id`),
  CONSTRAINT `blog_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_comments`
--


--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `session_id` varchar(255) DEFAULT NULL,
  `variant_id` int(11) 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 `cart`
--


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

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `icon` varchar(255) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `image` varchar(255) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `categories`
--


--
-- Table structure for table `categories_language`
--

CREATE TABLE `categories_language` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `language_id` varchar(255) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL 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 `categories_language`
--


--
-- Table structure for table `category_variants`
--

CREATE TABLE `category_variants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned NOT NULL,
  `variant_id` bigint(20) unsigned NOT 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 `category_variants`
--


--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `contact_email` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_fax` varchar(255) DEFAULT NULL,
  `contact_whatsapp` varchar(255) DEFAULT NULL,
  `contact_address` varchar(255) DEFAULT NULL,
  `google_maps` longtext DEFAULT NULL,
  `header_codes` longtext 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 `contact`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `short_code` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `capital` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `continent` varchar(255) DEFAULT NULL,
  `continent_code` varchar(255) DEFAULT NULL,
  `alpha_3` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'Afghanistan','AF','93','؋','Kabul','AFN','Asia','AS','AFG',NULL,NULL,NULL),(2,'Aland Islands','AX','358','€','Mariehamn','EUR','Europe','EU','ALA',NULL,NULL,NULL),(3,'Albania','AL','355','Lek','Tirana','ALL','Europe','EU','ALB',NULL,NULL,NULL),(4,'Algeria','DZ','213','دج','Algiers','DZD','Africa','AF','DZA',NULL,NULL,NULL),(5,'American Samoa','AS','1684','$','Pago Pago','USD','Oceania','OC','ASM',NULL,NULL,NULL),(6,'Andorra','AD','376','€','Andorra la Vella','EUR','Europe','EU','AND',NULL,NULL,NULL),(7,'Angola','AO','244','Kz','Luanda','AOA','Africa','AF','AGO',NULL,NULL,NULL),(8,'Anguilla','AI','1264','$','The Valley','XCD','North America','NA','AIA',NULL,NULL,NULL),(9,'Antarctica','AQ','672','$','Antarctica','AAD','Antarctica','AN','ATA',NULL,NULL,NULL),(10,'Antigua and Barbuda','AG','1268','$','St. John\'s','XCD','North America','NA','ATG',NULL,NULL,NULL),(11,'Argentina','AR','54','$','Buenos Aires','ARS','South America','SA','ARG',NULL,NULL,NULL),(12,'Armenia','AM','374','֏','Yerevan','AMD','Asia','AS','ARM',NULL,NULL,NULL),(13,'Aruba','AW','297','ƒ','Oranjestad','AWG','North America','NA','ABW',NULL,NULL,NULL),(14,'Australia','AU','61','$','Canberra','AUD','Oceania','OC','AUS',NULL,NULL,NULL),(15,'Austria','AT','43','€','Vienna','EUR','Europe','EU','AUT',NULL,NULL,NULL),(16,'Azerbaijan','AZ','994','m','Baku','AZN','Asia','AS','AZE',NULL,NULL,NULL),(17,'Bahamas','BS','1242','B$','Nassau','BSD','North America','NA','BHS',NULL,NULL,NULL),(18,'Bahrain','BH','973','.د.ب','Manama','BHD','Asia','AS','BHR',NULL,NULL,NULL),(19,'Bangladesh','BD','880','৳','Dhaka','BDT','Asia','AS','BGD',NULL,NULL,NULL),(20,'Barbados','BB','1246','Bds$','Bridgetown','BBD','North America','NA','BRB',NULL,NULL,NULL),(21,'Belarus','BY','375','Br','Minsk','BYN','Europe','EU','BLR',NULL,NULL,NULL),(22,'Belgium','BE','32','€','Brussels','EUR','Europe','EU','BEL',NULL,NULL,NULL),(23,'Belize','BZ','501','$','Belmopan','BZD','North America','NA','BLZ',NULL,NULL,NULL),(24,'Benin','BJ','229','CFA','Porto-Novo','XOF','Africa','AF','BEN',NULL,NULL,NULL),(25,'Bermuda','BM','1441','$','Hamilton','BMD','North America','NA','BMU',NULL,NULL,NULL),(26,'Bhutan','BT','975','Nu.','Thimphu','BTN','Asia','AS','BTN',NULL,NULL,NULL),(27,'Bolivia','BO','591','Bs.','Sucre','BOB','South America','SA','BOL',NULL,NULL,NULL),(28,'Bonaire, Sint Eustatius and Saba','BQ','599','$','Kralendijk','USD','North America','NA','BES',NULL,NULL,NULL),(29,'Bosnia and Herzegovina','BA','387','KM','Sarajevo','BAM','Europe','EU','BIH',NULL,NULL,NULL),(30,'Botswana','BW','267','P','Gaborone','BWP','Africa','AF','BWA',NULL,NULL,NULL),(31,'Bouvet Island','BV','55','kr','','NOK','Antarctica','AN','BVT',NULL,NULL,NULL),(32,'Brazil','BR','55','R$','Brasilia','BRL','South America','SA','BRA',NULL,NULL,NULL),(33,'British Indian Ocean Territory','IO','246','$','Diego Garcia','USD','Asia','AS','IOT',NULL,NULL,NULL),(34,'Brunei Darussalam','BN','673','B$','Bandar Seri Begawan','BND','Asia','AS','BRN',NULL,NULL,NULL),(35,'Bulgaria','BG','359','Лв.','Sofia','BGN','Europe','EU','BGR',NULL,NULL,NULL),(36,'Burkina Faso','BF','226','CFA','Ouagadougou','XOF','Africa','AF','BFA',NULL,NULL,NULL),(37,'Burundi','BI','257','FBu','Bujumbura','BIF','Africa','AF','BDI',NULL,NULL,NULL),(38,'Cambodia','KH','855','KHR','Phnom Penh','KHR','Asia','AS','KHM',NULL,NULL,NULL),(39,'Cameroon','CM','237','FCFA','Yaounde','XAF','Africa','AF','CMR',NULL,NULL,NULL),(40,'Canada','CA','1','$','Ottawa','CAD','North America','NA','CAN',NULL,NULL,NULL),(41,'Cape Verde','CV','238','$','Praia','CVE','Africa','AF','CPV',NULL,NULL,NULL),(42,'Cayman Islands','KY','1345','$','George Town','KYD','North America','NA','CYM',NULL,NULL,NULL),(43,'Central African Republic','CF','236','FCFA','Bangui','XAF','Africa','AF','CAF',NULL,NULL,NULL),(44,'Chad','TD','235','FCFA','N\'Djamena','XAF','Africa','AF','TCD',NULL,NULL,NULL),(45,'Chile','CL','56','$','Santiago','CLP','South America','SA','CHL',NULL,NULL,NULL),(46,'China','CN','86','¥','Beijing','CNY','Asia','AS','CHN',NULL,NULL,NULL),(47,'Christmas Island','CX','61','$','Flying Fish Cove','AUD','Asia','AS','CXR',NULL,NULL,NULL),(48,'Cocos (Keeling) Islands','CC','672','$','West Island','AUD','Asia','AS','CCK',NULL,NULL,NULL),(49,'Colombia','CO','57','$','Bogota','COP','South America','SA','COL',NULL,NULL,NULL),(50,'Comoros','KM','269','CF','Moroni','KMF','Africa','AF','COM',NULL,NULL,NULL),(51,'Congo','CG','242','FC','Brazzaville','XAF','Africa','AF','COG',NULL,NULL,NULL),(52,'Congo, Democratic Republic of the Congo','CD','242','FC','Kinshasa','CDF','Africa','AF','COD',NULL,NULL,NULL),(53,'Cook Islands','CK','682','$','Avarua','NZD','Oceania','OC','COK',NULL,NULL,NULL),(54,'Costa Rica','CR','506','₡','San Jose','CRC','North America','NA','CRI',NULL,NULL,NULL),(55,'Cote D\'Ivoire','CI','225','CFA','Yamoussoukro','XOF','Africa','AF','CIV',NULL,NULL,NULL),(56,'Croatia','HR','385','kn','Zagreb','HRK','Europe','EU','HRV',NULL,NULL,NULL),(57,'Cuba','CU','53','$','Havana','CUP','North America','NA','CUB',NULL,NULL,NULL),(58,'Curacao','CW','599','ƒ','Willemstad','ANG','North America','NA','CUW',NULL,NULL,NULL),(59,'Cyprus','CY','357','€','Nicosia','EUR','Asia','AS','CYP',NULL,NULL,NULL),(60,'Czech Republic','CZ','420','Kč','Prague','CZK','Europe','EU','CZE',NULL,NULL,NULL),(61,'Denmark','DK','45','Kr.','Copenhagen','DKK','Europe','EU','DNK',NULL,NULL,NULL),(62,'Djibouti','DJ','253','Fdj','Djibouti','DJF','Africa','AF','DJI',NULL,NULL,NULL),(63,'Dominica','DM','1767','$','Roseau','XCD','North America','NA','DMA',NULL,NULL,NULL),(64,'Dominican Republic','DO','1809','$','Santo Domingo','DOP','North America','NA','DOM',NULL,NULL,NULL),(65,'Ecuador','EC','593','$','Quito','USD','South America','SA','ECU',NULL,NULL,NULL),(66,'Egypt','EG','20','ج.م','Cairo','EGP','Africa','AF','EGY',NULL,NULL,NULL),(67,'El Salvador','SV','503','$','San Salvador','USD','North America','NA','SLV',NULL,NULL,NULL),(68,'Equatorial Guinea','GQ','240','FCFA','Malabo','XAF','Africa','AF','GNQ',NULL,NULL,NULL),(69,'Eritrea','ER','291','Nfk','Asmara','ERN','Africa','AF','ERI',NULL,NULL,NULL),(70,'Estonia','EE','372','€','Tallinn','EUR','Europe','EU','EST',NULL,NULL,NULL),(71,'Ethiopia','ET','251','Nkf','Addis Ababa','ETB','Africa','AF','ETH',NULL,NULL,NULL),(72,'Falkland Islands (Malvinas)','FK','500','£','Stanley','FKP','South America','SA','FLK',NULL,NULL,NULL),(73,'Faroe Islands','FO','298','Kr.','Torshavn','DKK','Europe','EU','FRO',NULL,NULL,NULL),(74,'Fiji','FJ','679','FJ$','Suva','FJD','Oceania','OC','FJI',NULL,NULL,NULL),(75,'Finland','FI','358','€','Helsinki','EUR','Europe','EU','FIN',NULL,NULL,NULL),(76,'France','FR','33','€','Paris','EUR','Europe','EU','FRA',NULL,NULL,NULL),(77,'French Guiana','GF','594','€','Cayenne','EUR','South America','SA','GUF',NULL,NULL,NULL),(78,'French Polynesia','PF','689','₣','Papeete','XPF','Oceania','OC','PYF',NULL,NULL,NULL),(79,'French Southern Territories','TF','262','€','Port-aux-Francais','EUR','Antarctica','AN','ATF',NULL,NULL,NULL),(80,'Gabon','GA','241','FCFA','Libreville','XAF','Africa','AF','GAB',NULL,NULL,NULL),(81,'Gambia','GM','220','D','Banjul','GMD','Africa','AF','GMB',NULL,NULL,NULL),(82,'Georgia','GE','995','ლ','Tbilisi','GEL','Asia','AS','GEO',NULL,NULL,NULL),(83,'Germany','DE','49','€','Berlin','EUR','Europe','EU','DEU',NULL,NULL,NULL),(84,'Ghana','GH','233','GH₵','Accra','GHS','Africa','AF','GHA',NULL,NULL,NULL),(85,'Gibraltar','GI','350','£','Gibraltar','GIP','Europe','EU','GIB',NULL,NULL,NULL),(86,'Greece','GR','30','€','Athens','EUR','Europe','EU','GRC',NULL,NULL,NULL),(87,'Greenland','GL','299','Kr.','Nuuk','DKK','North America','NA','GRL',NULL,NULL,NULL),(88,'Grenada','GD','1473','$','St. George\'s','XCD','North America','NA','GRD',NULL,NULL,NULL),(89,'Guadeloupe','GP','590','€','Basse-Terre','EUR','North America','NA','GLP',NULL,NULL,NULL),(90,'Guam','GU','1671','$','Hagatna','USD','Oceania','OC','GUM',NULL,NULL,NULL),(91,'Guatemala','GT','502','Q','Guatemala City','GTQ','North America','NA','GTM',NULL,NULL,NULL),(92,'Guernsey','GG','44','£','St Peter Port','GBP','Europe','EU','GGY',NULL,NULL,NULL),(93,'Guinea','GN','224','FG','Conakry','GNF','Africa','AF','GIN',NULL,NULL,NULL),(94,'Guinea-Bissau','GW','245','CFA','Bissau','XOF','Africa','AF','GNB',NULL,NULL,NULL),(95,'Guyana','GY','592','$','Georgetown','GYD','South America','SA','GUY',NULL,NULL,NULL),(96,'Haiti','HT','509','G','Port-au-Prince','HTG','North America','NA','HTI',NULL,NULL,NULL),(97,'Heard Island and Mcdonald Islands','HM','0','$','','AUD','Antarctica','AN','HMD',NULL,NULL,NULL),(98,'Holy See (Vatican City State)','VA','39','€','Vatican City','EUR','Europe','EU','VAT',NULL,NULL,NULL),(99,'Honduras','HN','504','L','Tegucigalpa','HNL','North America','NA','HND',NULL,NULL,NULL),(100,'Hong Kong','HK','852','$','Hong Kong','HKD','Asia','AS','HKG',NULL,NULL,NULL),(101,'Hungary','HU','36','Ft','Budapest','HUF','Europe','EU','HUN',NULL,NULL,NULL),(102,'Iceland','IS','354','kr','Reykjavik','ISK','Europe','EU','ISL',NULL,NULL,NULL),(103,'India','IN','91','₹','New Delhi','INR','Asia','AS','IND',NULL,NULL,NULL),(104,'Indonesia','ID','62','Rp','Jakarta','IDR','Asia','AS','IDN',NULL,NULL,NULL),(105,'Iran, Islamic Republic of','IR','98','﷼','Tehran','IRR','Asia','AS','IRN',NULL,NULL,NULL),(106,'Iraq','IQ','964','د.ع','Baghdad','IQD','Asia','AS','IRQ',NULL,NULL,NULL),(107,'Ireland','IE','353','€','Dublin','EUR','Europe','EU','IRL',NULL,NULL,NULL),(108,'Isle of Man','IM','44','£','Douglas, Isle of Man','GBP','Europe','EU','IMN',NULL,NULL,NULL),(109,'Israel','IL','972','₪','Jerusalem','ILS','Asia','AS','ISR',NULL,NULL,NULL),(110,'Italy','IT','39','€','Rome','EUR','Europe','EU','ITA',NULL,NULL,NULL),(111,'Jamaica','JM','1876','J$','Kingston','JMD','North America','NA','JAM',NULL,NULL,NULL),(112,'Japan','JP','81','¥','Tokyo','JPY','Asia','AS','JPN',NULL,NULL,NULL),(113,'Jersey','JE','44','£','Saint Helier','GBP','Europe','EU','JEY',NULL,NULL,NULL),(114,'Jordan','JO','962','ا.د','Amman','JOD','Asia','AS','JOR',NULL,NULL,NULL),(115,'Kazakhstan','KZ','7','лв','Astana','KZT','Asia','AS','KAZ',NULL,NULL,NULL),(116,'Kenya','KE','254','KSh','Nairobi','KES','Africa','AF','KEN',NULL,NULL,NULL),(117,'Kiribati','KI','686','$','Tarawa','AUD','Oceania','OC','KIR',NULL,NULL,NULL),(118,'Korea, Democratic People\'s Republic of','KP','850','₩','Pyongyang','KPW','Asia','AS','PRK',NULL,NULL,NULL),(119,'Korea, Republic of','KR','82','₩','Seoul','KRW','Asia','AS','KOR',NULL,NULL,NULL),(120,'Kosovo','XK','381','€','Pristina','EUR','Europe','EU','XKX',NULL,NULL,NULL),(121,'Kuwait','KW','965','ك.د','Kuwait City','KWD','Asia','AS','KWT',NULL,NULL,NULL),(122,'Kyrgyzstan','KG','996','лв','Bishkek','KGS','Asia','AS','KGZ',NULL,NULL,NULL),(123,'Lao People\'s Democratic Republic','LA','856','₭','Vientiane','LAK','Asia','AS','LAO',NULL,NULL,NULL),(124,'Latvia','LV','371','€','Riga','EUR','Europe','EU','LVA',NULL,NULL,NULL),(125,'Lebanon','LB','961','£','Beirut','LBP','Asia','AS','LBN',NULL,NULL,NULL),(126,'Lesotho','LS','266','L','Maseru','LSL','Africa','AF','LSO',NULL,NULL,NULL),(127,'Liberia','LR','231','$','Monrovia','LRD','Africa','AF','LBR',NULL,NULL,NULL),(128,'Libyan Arab Jamahiriya','LY','218','د.ل','Tripolis','LYD','Africa','AF','LBY',NULL,NULL,NULL),(129,'Liechtenstein','LI','423','CHf','Vaduz','CHF','Europe','EU','LIE',NULL,NULL,NULL),(130,'Lithuania','LT','370','€','Vilnius','EUR','Europe','EU','LTU',NULL,NULL,NULL),(131,'Luxembourg','LU','352','€','Luxembourg','EUR','Europe','EU','LUX',NULL,NULL,NULL),(132,'Macao','MO','853','$','Macao','MOP','Asia','AS','MAC',NULL,NULL,NULL),(133,'Macedonia, the Former Yugoslav Republic of','MK','389','ден','Skopje','MKD','Europe','EU','MKD',NULL,NULL,NULL),(134,'Madagascar','MG','261','Ar','Antananarivo','MGA','Africa','AF','MDG',NULL,NULL,NULL),(135,'Malawi','MW','265','MK','Lilongwe','MWK','Africa','AF','MWI',NULL,NULL,NULL),(136,'Malaysia','MY','60','RM','Kuala Lumpur','MYR','Asia','AS','MYS',NULL,NULL,NULL),(137,'Maldives','MV','960','Rf','Male','MVR','Asia','AS','MDV',NULL,NULL,NULL),(138,'Mali','ML','223','CFA','Bamako','XOF','Africa','AF','MLI',NULL,NULL,NULL),(139,'Malta','MT','356','€','Valletta','EUR','Europe','EU','MLT',NULL,NULL,NULL),(140,'Marshall Islands','MH','692','$','Majuro','USD','Oceania','OC','MHL',NULL,NULL,NULL),(141,'Martinique','MQ','596','€','Fort-de-France','EUR','North America','NA','MTQ',NULL,NULL,NULL),(142,'Mauritania','MR','222','MRU','Nouakchott','MRO','Africa','AF','MRT',NULL,NULL,NULL),(143,'Mauritius','MU','230','₨','Port Louis','MUR','Africa','AF','MUS',NULL,NULL,NULL),(144,'Mayotte','YT','269','€','Mamoudzou','EUR','Africa','AF','MYT',NULL,NULL,NULL),(145,'Mexico','MX','52','$','Mexico City','MXN','North America','NA','MEX',NULL,NULL,NULL),(146,'Micronesia, Federated States of','FM','691','$','Palikir','USD','Oceania','OC','FSM',NULL,NULL,NULL),(147,'Moldova, Republic of','MD','373','L','Chisinau','MDL','Europe','EU','MDA',NULL,NULL,NULL),(148,'Monaco','MC','377','€','Monaco','EUR','Europe','EU','MCO',NULL,NULL,NULL),(149,'Mongolia','MN','976','₮','Ulan Bator','MNT','Asia','AS','MNG',NULL,NULL,NULL),(150,'Montenegro','ME','382','€','Podgorica','EUR','Europe','EU','MNE',NULL,NULL,NULL),(151,'Montserrat','MS','1664','$','Plymouth','XCD','North America','NA','MSR',NULL,NULL,NULL),(152,'Morocco','MA','212','DH','Rabat','MAD','Africa','AF','MAR',NULL,NULL,NULL),(153,'Mozambique','MZ','258','MT','Maputo','MZN','Africa','AF','MOZ',NULL,NULL,NULL),(154,'Myanmar','MM','95','K','Nay Pyi Taw','MMK','Asia','AS','MMR',NULL,NULL,NULL),(155,'Namibia','NA','264','$','Windhoek','NAD','Africa','AF','NAM',NULL,NULL,NULL),(156,'Nauru','NR','674','$','Yaren','AUD','Oceania','OC','NRU',NULL,NULL,NULL),(157,'Nepal','NP','977','₨','Kathmandu','NPR','Asia','AS','NPL',NULL,NULL,NULL),(158,'Netherlands','NL','31','€','Amsterdam','EUR','Europe','EU','NLD',NULL,NULL,NULL),(159,'Netherlands Antilles','AN','599','NAf','Willemstad','ANG','North America','NA','ANT',NULL,NULL,NULL),(160,'New Caledonia','NC','687','₣','Noumea','XPF','Oceania','OC','NCL',NULL,NULL,NULL),(161,'New Zealand','NZ','64','$','Wellington','NZD','Oceania','OC','NZL',NULL,NULL,NULL),(162,'Nicaragua','NI','505','C$','Managua','NIO','North America','NA','NIC',NULL,NULL,NULL),(163,'Niger','NE','227','CFA','Niamey','XOF','Africa','AF','NER',NULL,NULL,NULL),(164,'Nigeria','NG','234','₦','Abuja','NGN','Africa','AF','NGA',NULL,NULL,NULL),(165,'Niue','NU','683','$','Alofi','NZD','Oceania','OC','NIU',NULL,NULL,NULL),(166,'Norfolk Island','NF','672','$','Kingston','AUD','Oceania','OC','NFK',NULL,NULL,NULL),(167,'Northern Mariana Islands','MP','1670','$','Saipan','USD','Oceania','OC','MNP',NULL,NULL,NULL),(168,'Norway','NO','47','kr','Oslo','NOK','Europe','EU','NOR',NULL,NULL,NULL),(169,'Oman','OM','968','.ع.ر','Muscat','OMR','Asia','AS','OMN',NULL,NULL,NULL),(170,'Pakistan','PK','92','₨','Islamabad','PKR','Asia','AS','PAK',NULL,NULL,NULL),(171,'Palau','PW','680','$','Melekeok','USD','Oceania','OC','PLW',NULL,NULL,NULL),(172,'Palestinian Territory, Occupied','PS','970','₪','East Jerusalem','ILS','Asia','AS','PSE',NULL,NULL,NULL),(173,'Panama','PA','507','B/.','Panama City','PAB','North America','NA','PAN',NULL,NULL,NULL),(174,'Papua New Guinea','PG','675','K','Port Moresby','PGK','Oceania','OC','PNG',NULL,NULL,NULL),(175,'Paraguay','PY','595','₲','Asuncion','PYG','South America','SA','PRY',NULL,NULL,NULL),(176,'Peru','PE','51','S/.','Lima','PEN','South America','SA','PER',NULL,NULL,NULL),(177,'Philippines','PH','63','₱','Manila','PHP','Asia','AS','PHL',NULL,NULL,NULL),(178,'Pitcairn','PN','64','$','Adamstown','NZD','Oceania','OC','PCN',NULL,NULL,NULL),(179,'Poland','PL','48','zł','Warsaw','PLN','Europe','EU','POL',NULL,NULL,NULL),(180,'Portugal','PT','351','€','Lisbon','EUR','Europe','EU','PRT',NULL,NULL,NULL),(181,'Puerto Rico','PR','1787','$','San Juan','USD','North America','NA','PRI',NULL,NULL,NULL),(182,'Qatar','QA','974','ق.ر','Doha','QAR','Asia','AS','QAT',NULL,NULL,NULL),(183,'Reunion','RE','262','€','Saint-Denis','EUR','Africa','AF','REU',NULL,NULL,NULL),(184,'Romania','RO','40','lei','Bucharest','RON','Europe','EU','ROM',NULL,NULL,NULL),(185,'Russian Federation','RU','70','₽','Moscow','RUB','Asia','AS','RUS',NULL,NULL,NULL),(186,'Rwanda','RW','250','FRw','Kigali','RWF','Africa','AF','RWA',NULL,NULL,NULL),(187,'Saint Barthelemy','BL','590','€','Gustavia','EUR','North America','NA','BLM',NULL,NULL,NULL),(188,'Saint Helena','SH','290','£','Jamestown','SHP','Africa','AF','SHN',NULL,NULL,NULL),(189,'Saint Kitts and Nevis','KN','1869','$','Basseterre','XCD','North America','NA','KNA',NULL,NULL,NULL),(190,'Saint Lucia','LC','1758','$','Castries','XCD','North America','NA','LCA',NULL,NULL,NULL),(191,'Saint Martin','MF','590','€','Marigot','EUR','North America','NA','MAF',NULL,NULL,NULL),(192,'Saint Pierre and Miquelon','PM','508','€','Saint-Pierre','EUR','North America','NA','SPM',NULL,NULL,NULL),(193,'Saint Vincent and the Grenadines','VC','1784','$','Kingstown','XCD','North America','NA','VCT',NULL,NULL,NULL),(194,'Samoa','WS','684','SAT','Apia','WST','Oceania','OC','WSM',NULL,NULL,NULL),(195,'San Marino','SM','378','€','San Marino','EUR','Europe','EU','SMR',NULL,NULL,NULL),(196,'Sao Tome and Principe','ST','239','Db','Sao Tome','STD','Africa','AF','STP',NULL,NULL,NULL),(197,'Saudi Arabia','SA','966','﷼','Riyadh','SAR','Asia','AS','SAU',NULL,NULL,NULL),(198,'Senegal','SN','221','CFA','Dakar','XOF','Africa','AF','SEN',NULL,NULL,NULL),(199,'Serbia','RS','381','din','Belgrade','RSD','Europe','EU','SRB',NULL,NULL,NULL),(200,'Serbia and Montenegro','CS','381','din','Belgrade','RSD','Europe','EU','SCG',NULL,NULL,NULL),(201,'Seychelles','SC','248','SRe','Victoria','SCR','Africa','AF','SYC',NULL,NULL,NULL),(202,'Sierra Leone','SL','232','Le','Freetown','SLL','Africa','AF','SLE',NULL,NULL,NULL),(203,'Singapore','SG','65','$','Singapur','SGD','Asia','AS','SGP',NULL,NULL,NULL),(204,'Sint Maarten','SX','1','ƒ','Philipsburg','ANG','North America','NA','SXM',NULL,NULL,NULL),(205,'Slovakia','SK','421','€','Bratislava','EUR','Europe','EU','SVK',NULL,NULL,NULL),(206,'Slovenia','SI','386','€','Ljubljana','EUR','Europe','EU','SVN',NULL,NULL,NULL),(207,'Solomon Islands','SB','677','Si$','Honiara','SBD','Oceania','OC','SLB',NULL,NULL,NULL),(208,'Somalia','SO','252','Sh.so.','Mogadishu','SOS','Africa','AF','SOM',NULL,NULL,NULL),(209,'South Africa','ZA','27','R','Pretoria','ZAR','Africa','AF','ZAF',NULL,NULL,NULL),(210,'South Georgia and the South Sandwich Islands','GS','500','£','Grytviken','GBP','Antarctica','AN','SGS',NULL,NULL,NULL),(211,'South Sudan','SS','211','£','Juba','SSP','Africa','AF','SSD',NULL,NULL,NULL),(212,'Spain','ES','34','€','Madrid','EUR','Europe','EU','ESP',NULL,NULL,NULL),(213,'Sri Lanka','LK','94','Rs','Colombo','LKR','Asia','AS','LKA',NULL,NULL,NULL),(214,'Sudan','SD','249','.س.ج','Khartoum','SDG','Africa','AF','SDN',NULL,NULL,NULL),(215,'Suriname','SR','597','$','Paramaribo','SRD','South America','SA','SUR',NULL,NULL,NULL),(216,'Svalbard and Jan Mayen','SJ','47','kr','Longyearbyen','NOK','Europe','EU','SJM',NULL,NULL,NULL),(217,'Swaziland','SZ','268','E','Mbabane','SZL','Africa','AF','SWZ',NULL,NULL,NULL),(218,'Sweden','SE','46','kr','Stockholm','SEK','Europe','EU','SWE',NULL,NULL,NULL),(219,'Switzerland','CH','41','CHf','Berne','CHF','Europe','EU','CHE',NULL,NULL,NULL),(220,'Syrian Arab Republic','SY','963','LS','Damascus','SYP','Asia','AS','SYR',NULL,NULL,NULL),(221,'Taiwan, Province of China','TW','886','$','Taipei','TWD','Asia','AS','TWN',NULL,NULL,NULL),(222,'Tajikistan','TJ','992','SM','Dushanbe','TJS','Asia','AS','TJK',NULL,NULL,NULL),(223,'Tanzania, United Republic of','TZ','255','TSh','Dodoma','TZS','Africa','AF','TZA',NULL,NULL,NULL),(224,'Thailand','TH','66','฿','Bangkok','THB','Asia','AS','THA',NULL,NULL,NULL),(225,'Timor-Leste','TL','670','$','Dili','USD','Asia','AS','TLS',NULL,NULL,NULL),(226,'Togo','TG','228','CFA','Lome','XOF','Africa','AF','TGO',NULL,NULL,NULL),(227,'Tokelau','TK','690','$','','NZD','Oceania','OC','TKL',NULL,NULL,NULL),(228,'Tonga','TO','676','$','Nuku\'alofa','TOP','Oceania','OC','TON',NULL,NULL,NULL),(229,'Trinidad and Tobago','TT','1868','$','Port of Spain','TTD','North America','NA','TTO',NULL,NULL,NULL),(230,'Tunisia','TN','216','ت.د','Tunis','TND','Africa','AF','TUN',NULL,NULL,NULL),(231,'Turkey','TR','90','₺','Ankara','TRY','Asia','AS','TUR',NULL,NULL,NULL),(232,'Turkmenistan','TM','7370','T','Ashgabat','TMT','Asia','AS','TKM',NULL,NULL,NULL),(233,'Turks and Caicos Islands','TC','1649','$','Cockburn Town','USD','North America','NA','TCA',NULL,NULL,NULL),(234,'Tuvalu','TV','688','$','Funafuti','AUD','Oceania','OC','TUV',NULL,NULL,NULL),(235,'Uganda','UG','256','USh','Kampala','UGX','Africa','AF','UGA',NULL,NULL,NULL),(236,'Ukraine','UA','380','₴','Kiev','UAH','Europe','EU','UKR',NULL,NULL,NULL),(237,'United Arab Emirates','AE','971','إ.د','Abu Dhabi','AED','Asia','AS','ARE',NULL,NULL,NULL),(238,'United Kingdom','GB','44','£','London','GBP','Europe','EU','GBR',NULL,NULL,NULL),(239,'United States','US','1','$','Washington','USD','North America','NA','USA',NULL,NULL,NULL),(240,'United States Minor Outlying Islands','UM','1','$','','USD','North America','NA','UMI',NULL,NULL,NULL),(241,'Uruguay','UY','598','$','Montevideo','UYU','South America','SA','URY',NULL,NULL,NULL),(242,'Uzbekistan','UZ','998','лв','Tashkent','UZS','Asia','AS','UZB',NULL,NULL,NULL),(243,'Vanuatu','VU','678','VT','Port Vila','VUV','Oceania','OC','VUT',NULL,NULL,NULL),(244,'Venezuela','VE','58','Bs','Caracas','VEF','South America','SA','VEN',NULL,NULL,NULL),(245,'Viet Nam','VN','84','₫','Hanoi','VND','Asia','AS','VNM',NULL,NULL,NULL),(246,'Virgin Islands, British','VG','1284','$','Road Town','USD','North America','NA','VGB',NULL,NULL,NULL),(247,'Virgin Islands, U.s.','VI','1340','$','Charlotte Amalie','USD','North America','NA','VIR',NULL,NULL,NULL),(248,'Wallis and Futuna','WF','681','₣','Mata Utu','XPF','Oceania','OC','WLF',NULL,NULL,NULL),(249,'Western Sahara','EH','212','MAD','El-Aaiun','MAD','Africa','AF','ESH',NULL,NULL,NULL),(250,'Yemen','YE','967','﷼','Sanaa','YER','Asia','AS','YEM',NULL,NULL,NULL),(251,'Zambia','ZM','260','ZK','Lusaka','ZMW','Africa','AF','ZMB',NULL,NULL,NULL),(252,'Zimbabwe','ZW','263','$','Harare','ZWL','Africa','AF','ZWE',NULL,NULL,NULL);

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `symbol` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT 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 `currencies`
--

INSERT INTO `currencies` VALUES (1,'Türk Lirası','₺','TRY',1,NULL,NULL,NULL);

--
-- Table structure for table `currency_rates`
--

CREATE TABLE `currency_rates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from_currency_id` int(11) NOT NULL,
  `to_currency_id` int(11) NOT NULL,
  `rate` double(8,3) NOT 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 `currency_rates`
--


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

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

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `gallery_category_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galleries`
--


--
-- Table structure for table `gallery_categories`
--

CREATE TABLE `gallery_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery_categories`
--


--
-- Table structure for table `gallery_category_languages`
--

CREATE TABLE `gallery_category_languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `language_id` bigint(20) NOT NULL DEFAULT 1,
  `gallery_category_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery_category_languages`
--


--
-- Table structure for table `gallery_languages`
--

CREATE TABLE `gallery_languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `gallery_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery_languages`
--


--
-- Table structure for table `gallery_media`
--

CREATE TABLE `gallery_media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `gallery_id` bigint(20) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `gallery_media`
--


--
-- Table structure for table `general_settings`
--

CREATE TABLE `general_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `new_register_email` varchar(255) DEFAULT NULL,
  `new_register_email_status` tinyint(4) NOT NULL DEFAULT 0,
  `new_order_email` varchar(255) DEFAULT NULL,
  `new_order_email_status` tinyint(4) NOT NULL DEFAULT 0,
  `new_contact_message_email` varchar(255) DEFAULT NULL,
  `new_contact_message_email_status` int(11) NOT NULL DEFAULT 0,
  `product_small_image_width` int(11) DEFAULT NULL,
  `product_small_image_height` int(11) DEFAULT NULL,
  `product_medium_image_width` int(11) DEFAULT NULL,
  `product_medium_image_height` int(11) DEFAULT NULL,
  `product_large_image_width` int(11) DEFAULT NULL,
  `product_large_image_height` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `general_settings`
--


--
-- Table structure for table `headers`
--

CREATE TABLE `headers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tags` text NOT 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 `headers`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `language_strings`
--

CREATE TABLE `language_strings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `string_key` varchar(255) NOT NULL,
  `lang_code` varchar(255) NOT NULL,
  `string_value` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1331 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `language_strings`
--



--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) NOT NULL,
  `lang_name` varchar(255) NOT NULL,
  `lang_icon_url` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `default` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `languages_lang_code_unique` (`lang_code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'en','English','en_flag.png',1,1,NULL,'2024-10-02 08:13:07','2024-10-02 08:13:07'),(2,'tr','Türkçe','tr_flag.png',1,0,NULL,'2024-10-02 08:13:07','2024-10-02 08:13:07');

--
-- Table structure for table `log_searches`
--

CREATE TABLE `log_searches` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `search` varchar(255) DEFAULT NULL,
  `ip_address` varchar(255) 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 `log_searches`
--


--
-- Table structure for table `ltm_translations`
--

CREATE TABLE `ltm_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` int(11) NOT NULL DEFAULT 0,
  `locale` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `key` text NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `ltm_translations`
--


--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `messages`
--


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

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

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

INSERT INTO `migrations` VALUES (80,'2014_04_02_193005_create_translations_table',1),(81,'2014_10_12_000000_create_users_table',1),(82,'2014_10_12_100000_create_password_resets_table',1),(83,'2016_06_01_000001_create_oauth_auth_codes_table',1),(84,'2016_06_01_000002_create_oauth_access_tokens_table',1),(85,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(86,'2016_06_01_000004_create_oauth_clients_table',1),(87,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(88,'2019_08_19_000000_create_failed_jobs_table',1),(89,'2021_04_14_130237_create_categories_table',1),(90,'2021_05_22_200749_create_settings_table',1),(91,'2021_05_22_200956_create_contact_table',1),(92,'2021_06_05_233954_create_languages_table',1),(93,'2021_06_05_234013_create_language_strings_table',1),(94,'2021_06_09_224212_create_categories_language_table',1),(95,'2021_06_17_221632_create_products_table',1),(96,'2021_06_17_223300_create_products_language_table',1),(97,'2021_06_17_225632_create_product_images_table',1),(98,'2021_06_20_133220_create_messages_table',1),(99,'2021_06_20_152520_create_templates_table',1),(100,'2021_06_21_223325_create_about_us_table',1),(101,'2021_06_22_141225_create_products_showroom_table',1),(102,'2021_06_27_170040_create_posts_table',1),(103,'2021_06_27_173228_create_posts_language_table',1),(104,'2021_08_04_220402_create_auth_table',1),(105,'2021_08_14_025724_create_salesman_orders_table',1),(106,'2021_08_14_025846_create_salesman_order_products_table',1),(107,'2021_08_14_031741_create_cart_table',1),(108,'2021_08_28_155213_create_post_categories_table',1),(109,'2021_08_28_155336_create_post_categories_language_table',1),(110,'2021_12_19_035335_create_headers_table',1),(111,'2021_12_20_053559_create_blog_comments_table',1),(112,'2022_01_07_184838_create_currencies_table',1),(113,'2022_03_19_181953_create_post_places_table',1),(114,'2022_05_23_001437_create_user_addresses_table',1),(115,'2022_05_23_231349_create_countries_table',1),(116,'2022_05_28_135200_create_orders_table',1),(117,'2022_05_28_195610_create_order_products_table',1),(118,'2022_05_28_195838_create_order_addresses_table',1),(119,'2022_05_29_125205_create_pages_table',1),(120,'2022_05_29_125941_create_page_languages_table',1),(121,'2022_07_03_173307_create_options_table',1),(122,'2022_07_03_174342_create_options_language_table',1),(123,'2022_07_04_001425_create_option_values_table',1),(124,'2022_07_04_001919_create_options_value_table',1),(125,'2022_07_04_002005_create_options_value_language_table',1),(126,'2022_07_12_204951_create_product_variants_table',1),(127,'2022_07_17_203918_create_user_favorite_products_table',1),(128,'2022_07_18_020923_create_order_user_information_table',1),(129,'2022_07_23_045602_create_jobs_table',1),(130,'2022_07_23_052219_create_general_settings_table',1),(131,'2022_07_23_222324_create_order_product_returns_table',1),(132,'2022_07_25_013259_create_sliders_table',1),(133,'2022_10_20_125858_create_payment_transactions_table',1),(134,'2023_05_13_195655_create_site_settings_table',1),(135,'2023_05_15_005327_create_notifications_table',1),(136,'2023_05_26_160039_create_projects_table',1),(137,'2023_05_26_161459_create_project_languages_table',1),(138,'2023_05_27_033947_create_project_categories_table',1),(139,'2023_05_27_034503_create_project_category_languages_table',1),(140,'2023_05_28_032419_create_project_images_table',1),(141,'2023_06_21_075527_create_references_table',1),(142,'2023_06_21_075548_create_reference_languages_table',1),(143,'2023_06_21_080142_create_reference_images_table',1),(144,'2023_07_19_173658_create_post_category_places_table',1),(145,'2023_08_01_133201_create_galleries_table',1),(146,'2023_08_01_133212_create_gallery_media_table',1),(147,'2023_08_01_133222_create_gallery_languages_table',1),(148,'2023_08_02_133608_create_post_images_table',1),(149,'2023_11_18_061153_create_currency_rates_table',1),(150,'2023_11_24_094454_create_product_reviews_table',1),(151,'2023_11_25_062801_create_product_variant_options_table',1),(152,'2023_11_28_075929_create_category_variants_table',1),(153,'2023_12_13_015930_create_log_searches_table',1),(154,'2023_12_13_145033_create_slider_places_table',1),(155,'2023_12_20_153449_create_product_variant_images_table',1),(156,'2023_12_28_195600_create_teams_table',1),(157,'2024_03_20_000851_create_gallery_categories_table',1),(158,'2024_03_20_000912_create_gallery_category_languages_table',1);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` char(36) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--


--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` char(36) NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` char(36) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `secret` varchar(100) DEFAULT NULL,
  `provider` varchar(255) DEFAULT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` char(36) NOT 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 `oauth_personal_access_clients`
--


--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `option_values`
--

CREATE TABLE `option_values` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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 `option_values`
--


--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `deleted_at` timestamp NULL 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 `options`
--


--
-- Table structure for table `options_language`
--

CREATE TABLE `options_language` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `option_id` int(11) NOT NULL DEFAULT 1,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL 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 `options_language`
--


--
-- Table structure for table `options_value`
--

CREATE TABLE `options_value` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_id` int(11) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL 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 `options_value`
--


--
-- Table structure for table `options_value_language`
--

CREATE TABLE `options_value_language` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `option_value_id` int(11) NOT NULL DEFAULT 1,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL 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 `options_value_language`
--


--
-- Table structure for table `order_addresses`
--

CREATE TABLE `order_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `country_id` int(11) NOT NULL,
  `city` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0- delivery address, 1- invoice address',
  `deleted_at` timestamp NULL 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 `order_addresses`
--


--
-- Table structure for table `order_product_returns`
--

CREATE TABLE `order_product_returns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_product_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `cargo_company_name` varchar(255) DEFAULT NULL,
  `cargo_number` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `order_product_returns`
--


--
-- Table structure for table `order_products`
--

CREATE TABLE `order_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `product_variant_id` int(11) DEFAULT NULL,
  `category_id` int(11) NOT NULL DEFAULT 1,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `currency_id` int(11) NOT NULL DEFAULT 1,
  `showroom` tinyint(4) NOT NULL DEFAULT 0,
  `position` tinyint(4) NOT NULL DEFAULT 0,
  `sku` varchar(255) NOT NULL DEFAULT '0',
  `code` varchar(255) DEFAULT NULL,
  `stock` int(11) NOT NULL DEFAULT 0,
  `cargo_company_name` varchar(255) DEFAULT NULL,
  `cargo_number` varchar(255) DEFAULT NULL,
  `status` enum('active','pending','denied','hidden') NOT NULL DEFAULT 'hidden',
  `order_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0-Pending, 1-Approved, Cargo Waiting, 2-In Cargo, 3-Completed, 4-Return Request, 5-Return Completed, 6-Canceled',
  `deleted_at` timestamp NULL 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 `order_products`
--


--
-- Table structure for table `order_user_information`
--

CREATE TABLE `order_user_information` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL 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 `order_user_information`
--


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

CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `coupon` varchar(255) DEFAULT NULL,
  `price` decimal(8,2) NOT NULL,
  `currency_id` int(11) NOT NULL DEFAULT 1 COMMENT '1- TRY',
  `discount_amount` decimal(8,2) NOT NULL DEFAULT 0.00,
  `quantity` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0-Pending, 1- Approved, 2- Canceled',
  `payment_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0-Credit Card, 1- EFT/Havale',
  `payment_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0-Pending, 1- Paid, 2- Returned',
  `obf` longtext DEFAULT NULL COMMENT 'Ön Bilgilendirme Formu',
  `mss` longtext DEFAULT NULL COMMENT 'Mesafeli Satış Sözleşmesi',
  `invoice_filename` varchar(255) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `session_id` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_order_number_unique` (`order_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--


--
-- Table structure for table `page_languages`
--

CREATE TABLE `page_languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `page_id` int(11) NOT NULL,
  `content` longtext DEFAULT NULL,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL 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 `page_languages`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `deleted_at` timestamp NULL 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 `pages`
--


--
-- Table structure for table `password_resets`
--

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

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `payment_transactions`
--

CREATE TABLE `payment_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL,
  `responseCode` varchar(255) DEFAULT NULL,
  `responseMessage` varchar(255) DEFAULT NULL,
  `response` longtext DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_transactions`
--


--
-- Table structure for table `post_categories`
--

CREATE TABLE `post_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `icon` varchar(255) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `image` varchar(255) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `color` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `post_categories`
--


--
-- Table structure for table `post_categories_language`
--

CREATE TABLE `post_categories_language` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `language_id` varchar(255) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL 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 `post_categories_language`
--


--
-- Table structure for table `post_category_places`
--

CREATE TABLE `post_category_places` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_category_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `key` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `post_category_places_post_category_id_foreign` (`post_category_id`),
  KEY `post_category_places_user_id_foreign` (`user_id`),
  CONSTRAINT `post_category_places_post_category_id_foreign` FOREIGN KEY (`post_category_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `post_category_places_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_category_places`
--


--
-- Table structure for table `post_images`
--

CREATE TABLE `post_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `post_id` bigint(20) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `post_images`
--


--
-- Table structure for table `post_places`
--

CREATE TABLE `post_places` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `key` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `post_places_post_id_foreign` (`post_id`),
  KEY `post_places_user_id_foreign` (`user_id`),
  CONSTRAINT `post_places_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `post_places_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_places`
--


--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL DEFAULT 1,
  `image` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `posts`
--


--
-- Table structure for table `posts_language`
--

CREATE TABLE `posts_language` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `post_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL 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 `posts_language`
--


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

CREATE TABLE `product_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `product_id` int(11) NOT NULL,
  `prime` int(11) NOT NULL DEFAULT 0,
  `position` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `product_images`
--


--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `rate` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 0 COMMENT '0:pending, 1:approved, 2:rejected',
  `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 `product_reviews`
--


--
-- Table structure for table `product_variant_images`
--

CREATE TABLE `product_variant_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_variant_id` int(11) NOT NULL,
  `product_image_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL 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 `product_variant_images`
--


--
-- Table structure for table `product_variant_options`
--

CREATE TABLE `product_variant_options` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_variant_id` int(11) NOT NULL,
  `product_option_id` int(11) NOT NULL,
  `option_value_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL 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 `product_variant_options`
--


--
-- Table structure for table `product_variants`
--

CREATE TABLE `product_variants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `stock` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `product_variants`
--


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

CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL DEFAULT 1,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `currency_id` int(11) NOT NULL DEFAULT 1,
  `showroom` int(11) NOT NULL DEFAULT 0,
  `position` int(11) NOT NULL DEFAULT 0,
  `sku` varchar(255) NOT NULL DEFAULT '0',
  `code` varchar(255) DEFAULT NULL,
  `stock` int(11) NOT NULL DEFAULT 0,
  `status` enum('active','pending','denied','hidden') NOT NULL DEFAULT 'hidden',
  `user_id` int(11) NOT NULL DEFAULT 0,
  `vat` int(11) NOT NULL DEFAULT 18,
  `catalog_no` int(11) DEFAULT NULL,
  `rate` decimal(2,1) NOT NULL DEFAULT 0.0,
  `review_count` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `products`
--


--
-- Table structure for table `products_language`
--

CREATE TABLE `products_language` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `permalink` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `cargo_info` longtext DEFAULT NULL,
  `product_id` int(11) NOT NULL DEFAULT 1,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL 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 `products_language`
--


--
-- Table structure for table `products_showroom`
--

CREATE TABLE `products_showroom` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT 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 `products_showroom`
--


--
-- Table structure for table `project_categories`
--

CREATE TABLE `project_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_categories`
--


--
-- Table structure for table `project_category_languages`
--

CREATE TABLE `project_category_languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `language_id` bigint(20) NOT NULL DEFAULT 1,
  `project_category_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_category_languages`
--


--
-- Table structure for table `project_images`
--

CREATE TABLE `project_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `project_id` bigint(20) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `project_images`
--


--
-- Table structure for table `project_languages`
--

CREATE TABLE `project_languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `language_id` bigint(20) NOT NULL DEFAULT 1,
  `project_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_languages`
--


--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `project_category_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--


--
-- Table structure for table `reference_images`
--

CREATE TABLE `reference_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `reference_id` bigint(20) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `reference_images`
--


--
-- Table structure for table `reference_languages`
--

CREATE TABLE `reference_languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `reference_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reference_languages`
--


--
-- Table structure for table `references`
--

CREATE TABLE `references` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `references`
--


--
-- Table structure for table `salesman_order_products`
--

CREATE TABLE `salesman_order_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `quantity` int(11) NOT NULL,
  `deleted_at` timestamp NULL 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 `salesman_order_products`
--


--
-- Table structure for table `salesman_orders`
--

CREATE TABLE `salesman_orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(255) NOT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `company_user` varchar(255) DEFAULT NULL,
  `company_phone` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `discount_amount` decimal(8,2) NOT NULL DEFAULT 0.00,
  `discount_percent` decimal(8,2) NOT NULL DEFAULT 0.00,
  `total_price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `products_total_price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `salesman_orders`
--


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

CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) DEFAULT NULL,
  `site_slogan` varchar(255) DEFAULT NULL,
  `site_description` varchar(255) DEFAULT NULL,
  `site_keywords` varchar(255) DEFAULT NULL,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `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 `settings`
--

INSERT INTO `settings` VALUES (1,'Sitem','En modern ve kaliteli mobilyaların doğru adresi!','Modern ve kaliteli mobilya ürünlerimizi sizlerle buluşturuyoruz. Bize ulaşarak daha fazla bilgi alabilirsiniz.','softrede, website, yazılım, mobil uygulama, cms, crm, sistem yönetimi, personal takip',1,NULL,NULL),(2,'Sitem','En modern ve kaliteli mobilyaların doğru adresi!','Modern ve kaliteli mobilya ürünlerimizi sizlerle buluşturuyoruz. Bize ulaşarak daha fazla bilgi alabilirsiniz.','softrede, website, yazılım, mobil uygulama, cms, crm, sistem yönetimi, personal takip',2,NULL,NULL),(3,'Sitem','En modern ve kaliteli mobilyaların doğru adresi!','Modern ve kaliteli mobilya ürünlerimizi sizlerle buluşturuyoruz. Bize ulaşarak daha fazla bilgi alabilirsiniz.','softrede, website, yazılım, mobil uygulama, cms, crm, sistem yönetimi, personal takip',3,NULL,NULL);

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_settings`
--


--
-- Table structure for table `slider_places`
--

CREATE TABLE `slider_places` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slider_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `key` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `slider_places_slider_id_foreign` (`slider_id`),
  KEY `slider_places_user_id_foreign` (`user_id`),
  CONSTRAINT `slider_places_slider_id_foreign` FOREIGN KEY (`slider_id`) REFERENCES `sliders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `slider_places_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slider_places`
--


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

CREATE TABLE `sliders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `language_id` bigint(20) NOT NULL,
  `position` tinyint(4) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `sliders`
--


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

CREATE TABLE `teams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `employee_position` varchar(255) DEFAULT NULL COMMENT 'employee''s position in the company',
  `image` varchar(255) DEFAULT NULL,
  `facebook_url` varchar(255) DEFAULT NULL,
  `twitter_url` varchar(255) DEFAULT NULL,
  `instagram_url` varchar(255) DEFAULT NULL,
  `linkedin_url` varchar(255) DEFAULT NULL,
  `telegram_url` varchar(255) 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 `teams`
--


--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` enum('active','passive') NOT NULL DEFAULT 'passive',
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0-Default, 1-Blog',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` VALUES (1,'default','active',0,NULL,'2024-10-02 08:13:07','2024-10-02 08:13:07'),(48,'alibebemobilya','passive',0,NULL,'2024-10-02 07:18:46','2024-10-02 08:14:43'),(49,'aytegmobilya','passive',0,NULL,'2024-10-02 07:18:46','2024-10-02 08:14:43'),(50,'default-ecommerce','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(51,'e-trade','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(52,'ecommerce-argekom','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(53,'egesafira','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(54,'fantastikmobilya','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(55,'hukukburosu','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(56,'hukukburosu2','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(57,'istarslan','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(58,'kerem','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(59,'neyapiyon','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(60,'nivemeshome','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(61,'ozenparkanaokulu','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(62,'safirmobilya','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(63,'softrede-blog','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(64,'softrede-ecommerce','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(65,'softrede-gelirimevden','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(66,'softrede-gelirimsensin','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(67,'softrede-geliryuvan','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(68,'softrede-maydonezoyun','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(69,'softrede-maydonezoyun2','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43'),(70,'solinmobilya','passive',0,NULL,'2024-10-02 07:18:47','2024-10-02 08:14:43');

--
-- Table structure for table `user_addresses`
--

CREATE TABLE `user_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `country_id` int(11) NOT NULL,
  `city` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL 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 `user_addresses`
--


--
-- Table structure for table `user_favorite_products`
--

CREATE TABLE `user_favorite_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL 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 `user_favorite_products`
--



