-- MySQL dump 10.13 Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost Database: fitmomsa_Store
-- ------------------------------------------------------
-- Server version 5.7.27
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `fitmomsa_Store`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `fitmomsa_Store` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `fitmomsa_Store`;
--
-- Table structure for table `blocs`
--
DROP TABLE IF EXISTS `blocs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blocs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`area` text COLLATE utf8_unicode_ci NOT NULL,
`content` text COLLATE utf8_unicode_ci NOT NULL,
`title` text COLLATE utf8_unicode_ci NOT NULL,
`o` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `blocs`
--
LOCK TABLES `blocs` WRITE;
/*!40000 ALTER TABLE `blocs` DISABLE KEYS */;
INSERT INTO `blocs` VALUES (2,'home','widget:products','Products',1),(3,'home','
\r\n
\r\n
\r\n
Discover our latest collection of bags
\r\n
Buy one of our select bags collection and get up to 40% Includes fast delivery and zero shipping costs .\r\nIf you want to purchase online a woman bag, remember to visit our shop, where you will certainly find the highest quality leather goods, innovative and suitable for those who love to stand out.
','Deal',2),(4,'home','widget:blog','Blog posts',3),(5,'post','widget:subscribe','Subscribe',4);
/*!40000 ALTER TABLE `blocs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `blog`
--
DROP TABLE IF EXISTS `blog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text COLLATE utf8mb4_unicode_ci NOT NULL,
`content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`time` text COLLATE utf8mb4_unicode_ci NOT NULL,
`images` text COLLATE utf8mb4_unicode_ci NOT NULL,
`visits` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `blog`
--
LOCK TABLES `blog` WRITE;
/*!40000 ALTER TABLE `blog` DISABLE KEYS */;
INSERT INTO `blog` VALUES (8,'10 Essential Website Hacks to Boost Sales','\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquam vulputate mauris ut faucibus. Mauris nibh neque, gravida in nisl eget, varius malesuada dui. Quisque pharetra felis mollis justo tincidunt semper vitae vitae erat. Donec libero velit, tempor id bibendum vel, placerat vel lectus. Pellentesque laoreet elementum diam. Mauris in accumsan felis. Proin lobortis tempus egestas. Mauris elementum auctor tincidunt. Nullam sapien massa, venenatis eu risus et, consequat elementum justo. Fusce ullamcorper finibus lacus quis sodales. Morbi viverra ligula et blandit placerat. Aenean porta tortor eu orci congue, placerat vestibulum dolor rutrum.\r\n\r\nIn tempor cursus accumsan. Nunc bibendum orci urna, id ornare felis elementum vitae. Aliquam ut suscipit est, ut rutrum turpis. Donec elit ex, euismod vitae rhoncus eget, dapibus ut orci. Morbi consequat in lorem vitae blandit. Sed ornare diam nec ullamcorper egestas. Maecenas ipsum mauris, viverra sit amet nisl eu, finibus tincidunt ante. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Integer ut massa vel leo porta lacinia vel sed mauris. Donec eget dictum nulla. Nunc bibendum vestibulum dapibus. Fusce finibus egestas molestie. Quisque efficitur nibh id auctor aliquam. Proin id ex et ante pulvinar cursus vitae eu est.\r\n\r\nPhasellus sit amet ex sit amet elit condimentum vehicula. Morbi eu ornare metus. Praesent nibh dolor, facilisis accumsan est vitae, varius aliquam lectus. Ut ultricies dolor pulvinar diam mollis, eu volutpat eros faucibus. Suspendisse pulvinar eros vel enim consectetur tristique. Proin purus nulla, consectetur pulvinar pharetra eget, accumsan at sapien. Aliquam erat volutpat. Maecenas suscipit nisl erat, at luctus ex porttitor quis.\r\n\r\nPellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nullam ipsum nisi, efficitur non tellus a, pulvinar venenatis elit. Morbi mattis magna nec libero luctus, in lacinia ligula euismod. Etiam mi ante, pharetra in dolor eu, condimentum consectetur urna. Morbi eget justo posuere, condimentum mi in, dictum erat. Aliquam neque nisi, sollicitudin non viverra id, laoreet tempus nisi. Sed et vulputate tortor. Donec non scelerisque nisi, non luctus felis. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Phasellus eleifend libero commodo feugiat dapibus. Sed consectetur libero ut ante consectetur, id rutrum turpis eleifend. Proin ut purus tellus. In in purus interdum neque imperdiet auctor. Mauris in mauris sed augue cursus convallis.\r\n\r\nProin hendrerit felis ligula. Cras vulputate maximus est eget aliquet. Quisque lacinia dapibus arcu, a gravida neque tempus rutrum. Donec consectetur, ante sed dapibus pellentesque, magna lacus tincidunt nibh, eu semper nunc magna at nibh. Maecenas a sollicitudin risus. Aenean fringilla nisi vehicula, iaculis diam at, porta mi. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec et tempus nunc. Integer auctor augue eget eros efficitur commodo. Fusce in elementum elit. ','1482605058','8.jpg',0),(9,'Footwear , A new trend in Online Shopping','\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquam vulputate mauris ut faucibus. Mauris nibh neque, gravida in nisl eget, varius malesuada dui. Quisque pharetra felis mollis justo tincidunt semper vitae vitae erat. Donec libero velit, tempor id bibendum vel, placerat vel lectus. Pellentesque laoreet elementum diam. Mauris in accumsan felis. Proin lobortis tempus egestas. Mauris elementum auctor tincidunt. Nullam sapien massa, venenatis eu risus et, consequat elementum justo. Fusce ullamcorper finibus lacus quis sodales. Morbi viverra ligula et blandit placerat. Aenean porta tortor eu orci congue, placerat vestibulum dolor rutrum.\r\n\r\nIn tempor cursus accumsan. Nunc bibendum orci urna, id ornare felis elementum vitae. Aliquam ut suscipit est, ut rutrum turpis. Donec elit ex, euismod vitae rhoncus eget, dapibus ut orci. Morbi consequat in lorem vitae blandit. Sed ornare diam nec ullamcorper egestas. Maecenas ipsum mauris, viverra sit amet nisl eu, finibus tincidunt ante. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Integer ut massa vel leo porta lacinia vel sed mauris. Donec eget dictum nulla. Nunc bibendum vestibulum dapibus. Fusce finibus egestas molestie. Quisque efficitur nibh id auctor aliquam. Proin id ex et ante pulvinar cursus vitae eu est.\r\n\r\nPhasellus sit amet ex sit amet elit condimentum vehicula. Morbi eu ornare metus. Praesent nibh dolor, facilisis accumsan est vitae, varius aliquam lectus. Ut ultricies dolor pulvinar diam mollis, eu volutpat eros faucibus. Suspendisse pulvinar eros vel enim consectetur tristique. Proin purus nulla, consectetur pulvinar pharetra eget, accumsan at sapien. Aliquam erat volutpat. Maecenas suscipit nisl erat, at luctus ex porttitor quis.\r\n\r\nPellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nullam ipsum nisi, efficitur non tellus a, pulvinar venenatis elit. Morbi mattis magna nec libero luctus, in lacinia ligula euismod. Etiam mi ante, pharetra in dolor eu, condimentum consectetur urna. Morbi eget justo posuere, condimentum mi in, dictum erat. Aliquam neque nisi, sollicitudin non viverra id, laoreet tempus nisi. Sed et vulputate tortor. Donec non scelerisque nisi, non luctus felis. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Phasellus eleifend libero commodo feugiat dapibus. Sed consectetur libero ut ante consectetur, id rutrum turpis eleifend. Proin ut purus tellus. In in purus interdum neque imperdiet auctor. Mauris in mauris sed augue cursus convallis.\r\n\r\nProin hendrerit felis ligula. Cras vulputate maximus est eget aliquet. Quisque lacinia dapibus arcu, a gravida neque tempus rutrum. Donec consectetur, ante sed dapibus pellentesque, magna lacus tincidunt nibh, eu semper nunc magna at nibh. Maecenas a sollicitudin risus. Aenean fringilla nisi vehicula, iaculis diam at, porta mi. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec et tempus nunc. Integer auctor augue eget eros efficitur commodo. Fusce in elementum elit. ','1482605362','9.jpg',0),(10,'How To Use Coupons When Shopping Online','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquam vulputate mauris ut faucibus. Mauris nibh neque, gravida in nisl eget, varius malesuada dui. Quisque pharetra felis mollis justo tincidunt semper vitae vitae erat. Donec libero velit, tempor id bibendum vel, placerat vel lectus. Pellentesque laoreet elementum diam. Mauris in accumsan felis. Proin lobortis tempus egestas. Mauris elementum auctor tincidunt. Nullam sapien massa, venenatis eu risus et, consequat elementum justo. Fusce ullamcorper finibus lacus quis sodales. Morbi viverra ligula et blandit placerat. Aenean porta tortor eu orci congue, placerat vestibulum dolor rutrum.\r\n\r\nIn tempor cursus accumsan. Nunc bibendum orci urna, id ornare felis elementum vitae. Aliquam ut suscipit est, ut rutrum turpis. Donec elit ex, euismod vitae rhoncus eget, dapibus ut orci. Morbi consequat in lorem vitae blandit. Sed ornare diam nec ullamcorper egestas. Maecenas ipsum mauris, viverra sit amet nisl eu, finibus tincidunt ante. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Integer ut massa vel leo porta lacinia vel sed mauris. Donec eget dictum nulla. Nunc bibendum vestibulum dapibus. Fusce finibus egestas molestie. Quisque efficitur nibh id auctor aliquam. Proin id ex et ante pulvinar cursus vitae eu est.\r\n\r\nPhasellus sit amet ex sit amet elit condimentum vehicula. Morbi eu ornare metus. Praesent nibh dolor, facilisis accumsan est vitae, varius aliquam lectus. Ut ultricies dolor pulvinar diam mollis, eu volutpat eros faucibus. Suspendisse pulvinar eros vel enim consectetur tristique. Proin purus nulla, consectetur pulvinar pharetra eget, accumsan at sapien. Aliquam erat volutpat. Maecenas suscipit nisl erat, at luctus ex porttitor quis.\r\n\r\nPellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nullam ipsum nisi, efficitur non tellus a, pulvinar venenatis elit. Morbi mattis magna nec libero luctus, in lacinia ligula euismod. Etiam mi ante, pharetra in dolor eu, condimentum consectetur urna. Morbi eget justo posuere, condimentum mi in, dictum erat. Aliquam neque nisi, sollicitudin non viverra id, laoreet tempus nisi. Sed et vulputate tortor. Donec non scelerisque nisi, non luctus felis. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Phasellus eleifend libero commodo feugiat dapibus. Sed consectetur libero ut ante consectetur, id rutrum turpis eleifend. Proin ut purus tellus. In in purus interdum neque imperdiet auctor. Mauris in mauris sed augue cursus convallis.\r\n\r\nProin hendrerit felis ligula. Cras vulputate maximus est eget aliquet. Quisque lacinia dapibus arcu, a gravida neque tempus rutrum. Donec consectetur, ante sed dapibus pellentesque, magna lacus tincidunt nibh, eu semper nunc magna at nibh. Maecenas a sollicitudin risus. Aenean fringilla nisi vehicula, iaculis diam at, porta mi. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec et tempus nunc. Integer auctor augue eget eros efficitur commodo. Fusce in elementum elit. ','1482605473','10.jpg',0);
/*!40000 ALTER TABLE `blog` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `browsers`
--
DROP TABLE IF EXISTS `browsers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `browsers` (
`browser` text COLLATE utf8_unicode_ci NOT NULL,
`visits` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `browsers`
--
LOCK TABLES `browsers` WRITE;
/*!40000 ALTER TABLE `browsers` DISABLE KEYS */;
INSERT INTO `browsers` VALUES ('Chrome',13),('Unknown Browser',2),('Handheld Browser',3),('Firefox',5);
/*!40000 ALTER TABLE `browsers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`parent` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `category`
--
LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (4,'Kids','kids',0),(5,'Classes','Classes',0),(6,'Special Events','',0);
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`registration` int(11) NOT NULL,
`theme` text NOT NULL,
`translations` int(11) NOT NULL,
`lang` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`views` int(11) NOT NULL,
`name` text NOT NULL,
`email` text NOT NULL,
`desc` text NOT NULL,
`key` text NOT NULL,
`logo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`floating_cart` int(11) NOT NULL,
`tumblr` text NOT NULL,
`youtube` text NOT NULL,
`facebook` text NOT NULL,
`instagram` text NOT NULL,
`twitter` text NOT NULL,
`phone` text NOT NULL,
`address` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,1,'default',1,'en',23,'Fitmomsandkids - Store','store@fitmomsandkids.com','The store of fitmomsandkids','store, gym','assets/logo.png',1,'http://tumblr.com','http://youtube.com','http://facebook.com/fitmomsglengormley','http://instagram.com','http://twitter.com','+44 28 9508 7412','3 Portland avenue , glengormley\r\nNewtownabbey');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `country`
--
DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`iso` char(2) NOT NULL,
`nicename` varchar(80) NOT NULL,
`phonecode` int(5) NOT NULL,
`visitors` int(11) NOT NULL DEFAULT '0',
`orders` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `country`
--
LOCK TABLES `country` WRITE;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT INTO `country` VALUES (1,'AF','Afghanistan',93,0,0),(2,'AL','Albania',355,0,0),(3,'DZ','Algeria',213,0,0),(4,'AS','American Samoa',1684,0,0),(5,'AD','Andorra',376,0,0),(6,'AO','Angola',244,0,0),(7,'AI','Anguilla',1264,0,0),(8,'AQ','Antarctica',0,0,0),(9,'AG','Antigua and Barbuda',1268,0,0),(10,'AR','Argentina',54,0,0),(11,'AM','Armenia',374,0,0),(12,'AW','Aruba',297,0,0),(13,'AU','Australia',61,0,0),(14,'AT','Austria',43,0,0),(15,'AZ','Azerbaijan',994,0,0),(16,'BS','Bahamas',1242,0,0),(17,'BH','Bahrain',973,0,0),(18,'BD','Bangladesh',880,0,0),(19,'BB','Barbados',1246,0,0),(20,'BY','Belarus',375,0,0),(21,'BE','Belgium',32,0,0),(22,'BZ','Belize',501,0,0),(23,'BJ','Benin',229,0,0),(24,'BM','Bermuda',1441,0,0),(25,'BT','Bhutan',975,0,0),(26,'BO','Bolivia',591,0,0),(27,'BA','Bosnia',387,0,0),(28,'BW','Botswana',267,0,0),(29,'BV','Bouvet Island',0,0,0),(30,'BR','Brazil',55,0,0),(31,'IO','Indian Ocean',246,0,0),(32,'BN','Brunei Darussalam',673,0,0),(33,'BG','Bulgaria',359,0,0),(34,'BF','Burkina Faso',226,0,0),(35,'BI','Burundi',257,0,0),(36,'KH','Cambodia',855,0,0),(37,'CM','Cameroon',237,0,0),(38,'CA','Canada',1,0,0),(39,'CV','Cape Verde',238,0,0),(40,'KY','Cayman Islands',1345,0,0),(41,'CF','Central African Republic',236,0,0),(42,'TD','Chad',235,0,0),(43,'CL','Chile',56,0,0),(44,'CN','China',86,0,0),(45,'CX','Christmas Island',61,0,0),(46,'CC','Cocos Islands',672,0,0),(47,'CO','Colombia',57,0,0),(48,'KM','Comoros',269,0,0),(49,'CG','Congo',242,0,0),(51,'CK','Cook Islands',682,0,0),(52,'CR','Costa Rica',506,0,0),(53,'CI','Cote D\'Ivoire',225,0,0),(54,'HR','Croatia',385,0,0),(55,'CU','Cuba',53,0,0),(56,'CY','Cyprus',357,0,0),(57,'CZ','Czech Republic',420,0,0),(58,'DK','Denmark',45,0,0),(59,'DJ','Djibouti',253,0,0),(60,'DM','Dominica',1767,0,0),(61,'DO','Dominican Republic',1809,0,0),(62,'EC','Ecuador',593,0,0),(63,'EG','Egypt',20,0,0),(64,'SV','El Salvador',503,0,0),(65,'GQ','Equatorial Guinea',240,0,0),(66,'ER','Eritrea',291,0,0),(67,'EE','Estonia',372,0,0),(68,'ET','Ethiopia',251,0,0),(69,'FK','Falkland Islands',500,0,0),(70,'FO','Faroe Islands',298,0,0),(71,'FJ','Fiji',679,0,0),(72,'FI','Finland',358,0,0),(73,'FR','France',33,0,0),(74,'GF','French Guiana',594,0,0),(75,'PF','French Polynesia',689,0,0),(77,'GA','Gabon',241,0,0),(78,'GM','Gambia',220,0,0),(79,'GE','Georgia',995,0,0),(80,'DE','Germany',49,0,0),(81,'GH','Ghana',233,0,0),(82,'GI','Gibraltar',350,0,0),(83,'GR','Greece',30,0,0),(84,'GL','Greenland',299,0,0),(85,'GD','Grenada',1473,0,0),(86,'GP','Guadeloupe',590,0,0),(87,'GU','Guam',1671,0,0),(88,'GT','Guatemala',502,0,0),(89,'GN','Guinea',224,0,0),(90,'GW','Guinea-Bissau',245,0,0),(91,'GY','Guyana',592,0,0),(92,'HT','Haiti',509,0,0),(95,'HN','Honduras',504,0,0),(96,'HK','Hong Kong',852,0,0),(97,'HU','Hungary',36,0,0),(98,'IS','Iceland',354,0,0),(99,'IN','India',91,0,0),(100,'ID','Indonesia',62,0,0),(101,'IR','Iran',98,0,0),(102,'IQ','Iraq',964,0,0),(103,'IE','Ireland',353,0,0),(104,'IL','Israel',972,0,0),(105,'IT','Italy',39,0,0),(106,'JM','Jamaica',1876,0,0),(107,'JP','Japan',81,0,0),(108,'JO','Jordan',962,0,0),(109,'KZ','Kazakhstan',7,0,0),(110,'KE','Kenya',254,0,0),(111,'KI','Kiribati',686,0,0),(112,'KP','Korea',850,0,0),(114,'KW','Kuwait',965,0,0),(115,'KG','Kyrgyzstan',996,0,0),(116,'LA','Lao',856,0,0),(117,'LV','Latvia',371,0,0),(118,'LB','Lebanon',961,0,0),(119,'LS','Lesotho',266,0,0),(120,'LR','Liberia',231,0,0),(121,'LY','Libya',218,0,0),(122,'LI','Liechtenstein',423,0,0),(123,'LT','Lithuania',370,0,0),(124,'LU','Luxembourg',352,0,0),(125,'MO','Macao',853,0,0),(126,'MK','Macedonia',389,0,0),(127,'MG','Madagascar',261,0,0),(128,'MW','Malawi',265,0,0),(129,'MY','Malaysia',60,0,0),(130,'MV','Maldives',960,0,0),(131,'ML','Mali',223,0,0),(132,'MT','Malta',356,0,0),(133,'MH','Marshall Islands',692,0,0),(134,'MQ','Martinique',596,0,0),(135,'MR','Mauritania',222,0,0),(136,'MU','Mauritius',230,0,0),(137,'YT','Mayotte',269,0,0),(138,'MX','Mexico',52,0,0),(139,'FM','Micronesia',691,0,0),(140,'MD','Moldova',373,0,0),(141,'MC','Monaco',377,0,0),(142,'MN','Mongolia',976,0,0),(143,'MS','Montserrat',1664,0,0),(144,'MA','Morocco',212,0,0),(145,'MZ','Mozambique',258,0,0),(146,'MM','Myanmar',95,0,0),(147,'NA','Namibia',264,0,0),(148,'NR','Nauru',674,0,0),(149,'NP','Nepal',977,0,0),(150,'NL','Netherlands',31,0,0),(151,'AN','Netherlands Antilles',599,0,0),(152,'NC','New Caledonia',687,0,0),(153,'NZ','New Zealand',64,0,0),(154,'NI','Nicaragua',505,0,0),(155,'NE','Niger',227,0,0),(156,'NG','Nigeria',234,0,0),(157,'NU','Niue',683,0,0),(158,'NF','Norfolk Island',672,0,0),(159,'MP','Northern Mariana Islands',1670,0,0),(160,'NO','Norway',47,0,0),(161,'OM','Oman',968,0,0),(162,'PK','Pakistan',92,0,0),(163,'PW','Palau',680,0,0),(164,'PS','Palestin',970,0,0),(165,'PA','Panama',507,0,0),(166,'PG','Papua New Guinea',675,0,0),(167,'PY','Paraguay',595,0,0),(168,'PE','Peru',51,0,0),(169,'PH','Philippines',63,0,0),(170,'PN','Pitcairn',0,0,0),(171,'PL','Poland',48,0,0),(172,'PT','Portugal',351,0,0),(173,'PR','Puerto Rico',1787,0,0),(174,'QA','Qatar',974,0,0),(175,'RE','Reunion',262,0,0),(176,'RO','Romania',40,0,0),(177,'RU','Russian Federation',70,0,0),(178,'RW','Rwanda',250,0,0),(179,'SH','Saint Helena',290,0,0),(180,'KN','Saint Kitts and Nevis',1869,0,0),(181,'LC','Saint Lucia',1758,0,0),(182,'PM','Saint Pierre',508,0,0),(183,'VC','Saint Vincent',1784,0,0),(184,'WS','Samoa',684,0,0),(185,'SM','San Marino',378,0,0),(186,'ST','Sao Tome',239,0,0),(187,'SA','Saudi Arabia',966,0,0),(188,'SN','Senegal',221,0,0),(189,'CS','Serbia',381,0,0),(190,'SC','Seychelles',248,0,0),(191,'SL','Sierra Leone',232,0,0),(192,'SG','Singapore',65,0,0),(193,'SK','Slovakia',421,0,0),(194,'SI','Slovenia',386,0,0),(195,'SB','Solomon Islands',677,0,0),(196,'SO','Somalia',252,0,0),(197,'ZA','South Africa',27,0,0),(198,'GS','South Georgia',0,0,0),(199,'ES','Spain',34,0,0),(200,'LK','Sri Lanka',94,0,0),(201,'SD','Sudan',249,0,0),(202,'SR','Suriname',597,0,0),(203,'SJ','Svalbard and Jan Mayen',47,0,0),(204,'SZ','Swaziland',268,0,0),(205,'SE','Sweden',46,0,0),(206,'CH','Switzerland',41,0,0),(207,'SY','Syrian Arab Republic',963,0,0),(208,'TW','Taiwan',886,0,0),(209,'TJ','Tajikistan',992,0,0),(210,'TZ','Tanzania',255,0,0),(211,'TH','Thailand',66,0,0),(212,'TL','Timor-Leste',670,0,0),(213,'TG','Togo',228,0,0),(214,'TK','Tokelau',690,0,0),(215,'TO','Tonga',676,0,0),(216,'TT','Trinidad and Tobago',1868,0,0),(217,'TN','Tunisia',216,0,0),(218,'TR','Turkey',90,0,0),(219,'TM','Turkmenistan',7370,0,0),(220,'TC','Turks and Caicos Islands',1649,0,0),(221,'TV','Tuvalu',688,0,0),(222,'UG','Uganda',256,0,0),(223,'UA','Ukraine',380,0,0),(224,'AE','United Arab Emirates',971,0,0),(225,'GB','United Kingdom',44,0,0),(226,'US','United States',1,0,0),(228,'UY','Uruguay',598,0,0),(229,'UZ','Uzbekistan',998,0,0),(230,'VU','Vanuatu',678,0,0),(231,'VE','Venezuela',58,0,0),(232,'VN','Viet Nam',84,0,0),(233,'VG','Virgin Islands, British',1284,0,0),(234,'VI','Virgin Islands, U.s.',1340,0,0),(235,'WF','Wallis and Futuna',681,0,0),(236,'EH','Western Sahara',212,0,0),(237,'YE','Yemen',967,0,0),(238,'ZM','Zambia',260,0,0),(239,'ZW','Zimbabwe',263,0,0);
/*!40000 ALTER TABLE `country` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `coupons`
--
DROP TABLE IF EXISTS `coupons`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `coupons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` text COLLATE utf8_unicode_ci NOT NULL,
`discount` int(11) NOT NULL,
`type` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `coupons`
--
LOCK TABLES `coupons` WRITE;
/*!40000 ALTER TABLE `coupons` DISABLE KEYS */;
INSERT INTO `coupons` VALUES (1,'coupon',10,'%');
/*!40000 ALTER TABLE `coupons` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `currency`
--
DROP TABLE IF EXISTS `currency`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currency` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`code` text COLLATE utf8_unicode_ci NOT NULL,
`rate` decimal(11,2) NOT NULL,
`default` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `currency`
--
LOCK TABLES `currency` WRITE;
/*!40000 ALTER TABLE `currency` DISABLE KEYS */;
INSERT INTO `currency` VALUES (1,'pounds','£',1.00,1);
/*!40000 ALTER TABLE `currency` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `customers`
--
DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`email` text COLLATE utf8_unicode_ci NOT NULL,
`password` text COLLATE utf8_unicode_ci NOT NULL,
`sid` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customers`
--
LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fields`
--
DROP TABLE IF EXISTS `fields`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fields` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fields`
--
LOCK TABLES `fields` WRITE;
/*!40000 ALTER TABLE `fields` DISABLE KEYS */;
INSERT INTO `fields` VALUES (1,'Full name','name'),(2,'E-mail','email'),(3,'City','city'),(4,'Address','address'),(5,'Mobile','mobile'),(6,'Country','country');
/*!40000 ALTER TABLE `fields` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `footer`
--
DROP TABLE IF EXISTS `footer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `footer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`link` longtext COLLATE utf8_unicode_ci NOT NULL,
`title` longtext COLLATE utf8_unicode_ci NOT NULL,
`o` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `footer`
--
LOCK TABLES `footer` WRITE;
/*!40000 ALTER TABLE `footer` DISABLE KEYS */;
INSERT INTO `footer` VALUES (1,'page/about','About us',1),(2,'404','404',5),(7,'support','Support',6),(8,'page/faq','FAQ',4),(9,'blog','Blog',3),(10,'products','Products',2);
/*!40000 ALTER TABLE `footer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `langs`
--
DROP TABLE IF EXISTS `langs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `langs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`code` mediumtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `langs`
--
LOCK TABLES `langs` WRITE;
/*!40000 ALTER TABLE `langs` DISABLE KEYS */;
INSERT INTO `langs` VALUES (1,'English','en'),(2,'French','fr');
/*!40000 ALTER TABLE `langs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `menu`
--
DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`link` longtext COLLATE utf8_unicode_ci NOT NULL,
`title` longtext COLLATE utf8_unicode_ci NOT NULL,
`o` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `menu`
--
LOCK TABLES `menu` WRITE;
/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
INSERT INTO `menu` VALUES (1,'page/about','About us',5),(2,'404','404',7),(3,'','Home',1),(4,'products/men','Men',2),(5,'products/women','Women',3),(6,'products/kids','kids',4),(7,'support','Support',8),(8,'page/faq','FAQ',6);
/*!40000 ALTER TABLE `menu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orders`
--
DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`customer` int(11) NOT NULL DEFAULT '0',
`name` text COLLATE utf8_unicode_ci NOT NULL,
`email` text COLLATE utf8_unicode_ci NOT NULL,
`city` text COLLATE utf8_unicode_ci NOT NULL,
`address` text COLLATE utf8_unicode_ci NOT NULL,
`mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`products` text COLLATE utf8_unicode_ci NOT NULL,
`shipping` decimal(11,2) NOT NULL DEFAULT '0.00',
`summ` decimal(11,2) NOT NULL DEFAULT '0.00',
`date` text COLLATE utf8_unicode_ci NOT NULL,
`coupon` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(11) NOT NULL,
`stat` int(11) NOT NULL DEFAULT '1',
`country` text COLLATE utf8_unicode_ci NOT NULL,
`payment` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders`
--
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `os`
--
DROP TABLE IF EXISTS `os`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `os` (
`os` text COLLATE utf8_unicode_ci NOT NULL,
`visits` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `os`
--
LOCK TABLES `os` WRITE;
/*!40000 ALTER TABLE `os` DISABLE KEYS */;
INSERT INTO `os` VALUES ('Windows 10',18),('Unknown OS Platform',2),('Android',3);
/*!40000 ALTER TABLE `os` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pages`
--
DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`path` text COLLATE utf8_unicode_ci NOT NULL,
`title` text COLLATE utf8_unicode_ci NOT NULL,
`content` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pages`
--
LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` VALUES (1,'about','About us','
');
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `payments`
--
DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text COLLATE utf8_unicode_ci NOT NULL,
`code` text COLLATE utf8_unicode_ci NOT NULL,
`options` text COLLATE utf8_unicode_ci NOT NULL,
`active` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `payments`
--
LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
INSERT INTO `payments` VALUES (1,'PayPal','paypal','{\"email\":\"payments@shop.com\"}',1),(2,'Credit Card','stripe','{\"key\":\"YOUR_KEY_HERE\",\"secret\":\"YOUR_SECRET_HERE\"}',1),(3,'Cash on delivery','cash','{}',1),(4,'Bank transfer','bank','{\"AccountName\":\"Name\",\"AccountNumber\":\"123456\",\"BankName\":\"Bank\",\"RoutingNumber\":\"123456\",\"IBAN\":\"123456\",\"SWIFT\":\"123456\"}',1);
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `products`
--
DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` longtext COLLATE utf8_unicode_ci NOT NULL,
`category` int(11) NOT NULL,
`price` float(11,2) NOT NULL,
`images` text COLLATE utf8_unicode_ci NOT NULL,
`text` text COLLATE utf8_unicode_ci NOT NULL,
`quantity` text COLLATE utf8_unicode_ci NOT NULL,
`download` text COLLATE utf8_unicode_ci NOT NULL,
`options` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `products`
--
LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (29,'T-Shirt',2,13.00,'29-0.png,29-1.png,29-2.png','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque porttitor imperdiet porttitor. Pellentesque id consectetur massa. Nam vitae sem convallis, interdum magna nec, sollicitudin tortor. Nulla vitae nisl consequat, vestibulum nulla eget, consectetur dolor. Mauris id erat ac neque condimentum viverra a vitae nisi. Mauris ornare cursus nisl.\r\n\r\nMauris sit amet velit vulputate, euismod dolor sed, rutrum dolor. Integer placerat egestas varius ultrices interdum at a nunc. Pellentesque finibus vitae ligula at scelerisque. Praesent elementum in felis at vestibulum. Sed porttitor risus at gravida iaculis.\r\n\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque porttitor imperdiet porttitor. Pellentesque id consectetur massa. Nam vitae sem convallis, interdum magna nec, sollicitudin tortor. Nulla vitae nisl consequat, vestibulum nulla eget, consectetur dolor. Mauris id erat ac neque condimentum viverra a vitae nisi. Mauris ornare cursus nisl.\r\n\r\nMauris sit amet velit vulputate, euismod dolor sed, rutrum dolor. Integer placerat egestas varius ultrices interdum at a nunc. Pellentesque finibus vitae ligula at scelerisque. Praesent elementum in felis at vestibulum. Sed porttitor risus at gravida iaculis.','100','','[]'),(33,'Session',5,5.00,'33-0.png','A fit moms and kids session','89','','[{\"no\":\"1\",\"title\":\"Name\",\"name\":\"choice_1\",\"type\":\"text\",\"option\":[\"none\"]}]'),(34,'Kids Monthly Subsciption',5,15.00,'34-0.png','A one time payment for 1 month subscription','99','','[]'),(35,'Monthly subscription',5,25.00,'35-0.png','A monthly subscription for ages 11+','99','','[{\"no\":\"1\",\"title\":\"Name\",\"name\":\"choice_1\",\"type\":\"text\",\"option\":[\"none\"]}]'),(36,'1 - 1 session',5,20.00,'36-0.png','Get a personal one to one session with the owner','100','','[{\"no\":\"1\",\"title\":\"Name\",\"name\":\"choice_1\",\"type\":\"text\",\"option\":[\"none\"]}]'),(37,'ten 1-1 sessions',5,160.00,'37-0.png','Ten one to to sessions','100','','[]'),(38,'Monday Morning',5,5.00,'38-0.jpg','Yogahilt 9.45am','20','','[]');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `referrer`
--
DROP TABLE IF EXISTS `referrer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `referrer` (
`referrer` text COLLATE utf8_unicode_ci NOT NULL,
`visits` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `referrer`
--
LOCK TABLES `referrer` WRITE;
/*!40000 ALTER TABLE `referrer` DISABLE KEYS */;
INSERT INTO `referrer` VALUES ('fitmomsandkids.com',11),('Direct',11),('m.facebook.com',1);
/*!40000 ALTER TABLE `referrer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reviews`
--
DROP TABLE IF EXISTS `reviews`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product` int(11) NOT NULL,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`email` text COLLATE utf8_unicode_ci NOT NULL,
`review` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(11) NOT NULL,
`rating` int(11) NOT NULL,
`active` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reviews`
--
LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shipping`
--
DROP TABLE IF EXISTS `shipping`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shipping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country` text COLLATE utf8_unicode_ci NOT NULL,
`cost` decimal(11,2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shipping`
--
LOCK TABLES `shipping` WRITE;
/*!40000 ALTER TABLE `shipping` DISABLE KEYS */;
/*!40000 ALTER TABLE `shipping` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `style`
--
DROP TABLE IF EXISTS `style`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `style` (
`slogan` text COLLATE utf8_unicode_ci NOT NULL,
`desc` text COLLATE utf8_unicode_ci NOT NULL,
`background` text COLLATE utf8_unicode_ci NOT NULL,
`button` text COLLATE utf8_unicode_ci NOT NULL,
`media` text COLLATE utf8_unicode_ci NOT NULL,
`css` text COLLATE utf8_unicode_ci NOT NULL,
`js` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `style`
--
LOCK TABLES `style` WRITE;
/*!40000 ALTER TABLE `style` DISABLE KEYS */;
INSERT INTO `style` VALUES ('New arrivals','New products with great discounts from the most luxurious brand in the world !','#4c77c6,#649bf2','Shop now,products','https://www.youtube.com/watch?v=Z0FETzb32Hs','','');
/*!40000 ALTER TABLE `style` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subscribers`
--
DROP TABLE IF EXISTS `subscribers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscribers` (
`email` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subscribers`
--
LOCK TABLES `subscribers` WRITE;
/*!40000 ALTER TABLE `subscribers` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscribers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `templates`
--
DROP TABLE IF EXISTS `templates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `templates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text COLLATE utf8_unicode_ci NOT NULL,
`code` text COLLATE utf8_unicode_ci NOT NULL,
`template` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `templates`
--
LOCK TABLES `templates` WRITE;
/*!40000 ALTER TABLE `templates` DISABLE KEYS */;
INSERT INTO `templates` VALUES (1,'Order Email','order','\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n