-- Table structure for table `catalogsearch_fulltext_scope3`
--

CREATE TABLE `catalogsearch_fulltext_scope3` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` int(10) unsigned NOT NULL COMMENT 'Attribute_id',
  `data_index` longtext COMMENT 'Data index',
  PRIMARY KEY (`entity_id`,`attribute_id`),
  FULLTEXT KEY `FTI_FULLTEXT_DATA_INDEX` (`data_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='catalogsearch_fulltext_scope3_tmp';

--
-- Dumping data for table `catalogsearch_fulltext_scope3`
--

INSERT INTO `catalogsearch_fulltext_scope3` VALUES ('1','73','ASOS BRIDAL Here Comes The Bride Vest & Short Pyjama Set'),('1','74','9658'),('1','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('1','76','We advocate comfortable, elegant and beautiful lingerie.'),('1','135','China'),('1','136','Hollow Out'),('1','137','Push Up Bra'),('1','141','Classic'),('1','157','Triumph'),('2','73','ASOS Leanna Lace Up Satin Half Cup Moulded Underwire Bra'),('2','74','3546'),('2','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('2','76','We advocate comfortable, elegant and beautiful lingerie.'),('2','135','Germany'),('2','136','Backless'),('2','137','Support Bra'),('2','141','Sexy'),('2','157','Triumph'),('3','73','ASOS Madison Lace Underwire Bra'),('3','74','2653'),('3','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('3','76','We advocate comfortable, elegant and beautiful lingerie.'),('3','135','France'),('3','136','Hollow Out'),('3','137','Basic Bra'),('3','141','Romantic'),('3','157','Vixen'),('4','73','ASOS Shake Your Coconuts Vest & Short Pyjama Set'),('4','74','3665'),('4','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('4','76','We advocate comfortable, elegant and beautiful lingerie.'),('4','135','Germany'),('4','136','Backless'),('4','137','Push Up Bra'),('4','141','Romantic'),('4','157','Vixen'),('5','73','ASOS Hi-Leg Hi-Shine Body'),('5','74','2345'),('5','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('5','76','We advocate comfortable, elegant and beautiful lingerie.'),('5','135','USA'),('5','136','Lace'),('5','137','T-Shirt Bra'),('5','141','Romantic'),('5','157','Calvin Klein'),('6','73','Cath Kidston Guards Pyjama Tshirt'),('6','74','4443'),('6','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('6','76','We advocate comfortable, elegant and beautiful lingerie.'),('6','135','Germany'),('6','136','Hollow Out'),('6','137','Push Up Bra'),('6','141','Romantic'),('6','157','Calvin Klein'),('7','73','BRIDAL Valentina Corded Lace Slip'),('7','74','2488'),('7','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('7','76','We advocate comfortable, elegant and beautiful lingerie.'),('7','135','USA'),('7','136','Hollow Out'),('7','137','Push Up Bra'),('7','141','Romantic'),('7','157','Naf Naf'),('8','73','BRIDAL Confetti Queen Tee & Short Pyjama set'),('8','74','2377'),('8','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('8','76','We advocate comfortable, elegant and beautiful lingerie.'),('8','135','China'),('8','136','Hollow Out'),('8','137','Support Bra'),('8','141','Romantic'),('8','157','Naf Naf'),('14','73','Marie Meili Brooke Two Pack Bra'),('14','74','6133'),('14','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('14','76','We advocate comfortable, elegant and beautiful lingerie.'),('14','135','China'),('14','136','Hollow Out'),('14','137','Support Bra'),('14','141','Classic'),('14','157','Recco'),('15','73','Lace Trim Long Sleeve Tee & Short Pyjama Set'),('15','74','5123'),('15','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('15','76','We advocate comfortable, elegant and beautiful lingerie.'),('15','135','Germany'),('15','136','Hollow Out'),('15','137','Support Bra'),('15','141','Classic'),('15','157','Recco'),('16','73','Marie Meili Wisdom Super Push Up Bra | Marie Meili Wisdom Super Push Up Bra-black | Marie Meili Wisdom Super Push Up Bra-blue'),('16','74','5111'),('16','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('16','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('16','135','China | China | China'),('16','136','Backless | Backless | Backless'),('16','137','Support Bra | Support Bra | Support Bra'),('16','141','Romantic | Romantic | Romantic'),('16','143','black | blue'),('17','73','MIX & MATCH | MIX & MATCH-white | MIX & MATCH-pink'),('17','74','9654'),('17','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('17','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('17','135','USA | USA | USA'),('17','136','Backless | Backless | Backless'),('17','137','T-Shirt Bra | T-Shirt Bra | T-Shirt Bra'),('17','141','Romantic | Romantic | Romantic'),('17','143','white | pink'),('17','157','Beaujais'),('18','73','Oysho Escote Croazon Dot Body | Oysho Escote Croazon Dot Body-black | Oysho Escote Croazon Dot Body-white | Oysho Escote Croazon Dot Body-red'),('18','74','4762'),('18','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('18','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('18','135','France | France | France | France'),('18','136','Lace | Lace | Lace | Lace'),('18','137','Push Up Bra | Push Up Bra | Push Up Bra | Push Up Bra'),('18','141','Romantic | Romantic | Romantic | Romantic'),('18','143','black | white | red'),('18','157','Beaujais'),('19','73','Shoulder Detail Lace Underwire Bralet | Shoulder Detail Lace Underwire Bralet-pink | Shoulder Detail Lace Underwire Bralet-blue'),('19','74','8112'),('19','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('19','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('19','135','Germany | Germany | Germany'),('19','136','Hollow Out | Hollow Out | Hollow Out'),('19','137','Push Up Bra | Push Up Bra | Push Up Bra'),('19','141','Romantic | Romantic | Romantic'),('19','143','pink | blue'),('20','73','Undiz Ampli Mico T-Shirt Bra | Undiz Ampli Mico T-Shirt Bra-white | Undiz Ampli Mico T-Shirt Bra-black'),('20','74','4998'),('20','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('20','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('20','135','China | China | China'),('20','136','Backless | Backless | Backless'),('20','137','Support Bra | Support Bra | Support Bra'),('20','141','Romantic | Romantic | Romantic'),('20','143','white | black'),('20','157','Beaujais'),('32','73','Undiz Equiliz Bustier Longline Bra | Undiz Equiliz Bustier Longline Bra-white | Undiz Equiliz Bustier Longline Bra-blue'),('32','74','4112'),('32','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('32','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('32','135','Germany | Germany | Germany'),('32','136','Lace | Lace | Lace'),('32','137','Basic Bra | Basic Bra | Basic Bra'),('32','141','Romantic | Romantic | Romantic'),('32','143','white | blue'),('33','73','Undiz Royaltiz Gel Bra | Undiz Royaltiz Gel Bra-white | Undiz Royaltiz Gel Bra-pink'),('33','74','4221'),('33','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('33','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('33','135','USA | USA | USA'),('33','136','Backless | Backless | Backless'),('33','137','T-Shirt Bra | T-Shirt Bra | T-Shirt Bra'),('33','141','Romantic | Romantic | Romantic'),('33','143','white | pink'),('34','73','Undiz Teamminiz Short | Undiz Teamminiz Short-black | Undiz Teamminiz Short-white | Undiz Teamminiz Short-red'),('34','74','4331'),('34','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('34','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('34','135','China | China | China | China'),('34','136','Hollow Out | Hollow Out | Hollow Out | Hollow Out'),('34','137','T-Shirt Bra | T-Shirt Bra | T-Shirt Bra | T-Shirt Bra');
INSERT INTO `catalogsearch_fulltext_scope3` VALUES ('34','141','Romantic | Romantic | Romantic | Romantic'),('34','143','black | white | red'),('35','73','Weekday Note Bra | Weekday Note Bra-black | Weekday Note Bra-pink'),('35','74','4521'),('35','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('35','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('35','135','USA | USA | USA'),('35','136','Lace | Lace | Lace'),('35','137','T-Shirt Bra | T-Shirt Bra | T-Shirt Bra'),('35','141','Romantic | Romantic | Romantic'),('35','143','black | pink'),('36','73','Weekday Stella Triangle Bra | Weekday Stella Triangle Bra-white | Weekday Stella Triangle Bra-red'),('36','74','4556'),('36','75','Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible. | Every woman knows that her most sophisticated and impressive outfit is not complete without perfect lingerie underneath. Just as an old joke says, “She was wearing all white, but no one could see that, as there was a black dress on her”. Lingerie is more than just a garment. For some reason, it is often considered to be a topic which is not appropriate to be talked about. However, it deserves just as much attention as usual clothing. It may be fashionable or not, it may be comfortable or not, it may suit you or not. This is why it should be talked about, paid attention to and enjoyed. What is offered in this online store? Most comfortable sleepwear, extremely elegant swimwear, seductive lingerie, regular and plus size shapewear and so on. An extensive range of lingerie includes naughty and nice models. Be sure that whichever evening you are planning, in the lingerie which fits your body perfectly, which is comfortable and at the same time makes you look gorgeous, it will be amazing. Either it’s a special moment with your loved one, or a gathering with your friends at a tennis court, the lingerie which you’ll be wearing will make you as comfortable as possible.'),('36','76','We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie. | We advocate comfortable, elegant and beautiful lingerie.'),('36','135','China | China | China'),('36','136','Backless | Backless | Backless'),('36','137','Push Up Bra | Push Up Bra | Push Up Bra'),('36','141','Romantic | Romantic | Romantic'),('36','143','white | red');

--
-- Table structure for table `checkout_agreement`
--

CREATE TABLE `checkout_agreement` (
  `agreement_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Agreement Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `content` text COMMENT 'Content',
  `content_height` varchar(25) DEFAULT NULL COMMENT 'Content Height',
  `checkbox_text` text COMMENT 'Checkbox Text',
  `is_active` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `is_html` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Html',
  `mode` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Applied mode',
  PRIMARY KEY (`agreement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Checkout Agreement';

--
-- Table structure for table `checkout_agreement_store`
--

CREATE TABLE `checkout_agreement_store` (
  `agreement_id` int(10) unsigned NOT NULL COMMENT 'Agreement Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  PRIMARY KEY (`agreement_id`,`store_id`),
  KEY `CHECKOUT_AGREEMENT_STORE_STORE_ID_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Checkout Agreement Store';

--
-- Table structure for table `cms_block`
--

CREATE TABLE `cms_block` (
  `block_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Block ID',
  `title` varchar(255) NOT NULL COMMENT 'Block Title',
  `identifier` varchar(255) NOT NULL COMMENT 'Block String Identifier',
  `content` mediumtext COMMENT 'Block Content',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Block Creation Time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Block Modification Time',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Block Active',
  PRIMARY KEY (`block_id`),
  FULLTEXT KEY `CMS_BLOCK_TITLE_IDENTIFIER_CONTENT` (`title`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='CMS Block Table';

--
-- Dumping data for table `cms_block`
--

INSERT INTO `cms_block` VALUES (1,'Footer column content 1','footer_col_1','<ul>\r\n    <li><a href=\"{{store direct_url=\"about-us\"}}\">About Us</a></li>\r\n    <li><a href=\"{{store direct_url=\"customer-service\"}}\">Customer Service</a></li>\r\n    <li><a href=\"{{store url=\"\"}}template-settings\">Template Settings</a></li>\r\n</ul>','2016-08-10 17:14:15','2016-08-10 17:19:51',1),(2,'Footer column content 2','footer_col_2','<div class=\"footer-col\">\r\n    <h4>Why buy from us</h4>\r\n    <div class=\"footer-col-content\">\r\n   	 <ul>\r\n   		 <li><a href=\"{{store url=\"\"}}shipping-delivery\">Shipping & Delivery</a></li>\r\n   		 <li><a href=\"{{store url=\"\"}}secure-payment\">Secure payment</a></li>\r\n   		 <li><a href=\"{{store url=\"\"}}support\">Support</a></li>\r\n   		 <li><a href=\"{{store url=\"\"}}guarantee\">Guarantee</a></li>\r\n   		 <li><a href=\"{{store url=\"\"}}terms-conditions\">Terms & Conditions</a></li>\r\n   	 </ul>\r\n    </div>\r\n</div>','2016-08-10 17:16:39','2016-09-13 20:46:50',1),(3,'Footer column content 3','footer_col_3','<div class=\"footer-col\">\r\n<h4>My account</h4>\r\n    <div class=\"footer-col-content\">\r\n   	 <ul>\r\n   		 <li><a href=\"{{store url=\'customer/account/login/\'}}\">Sign In</a></li>\r\n   		 <li><a href=\"{{store url=\'checkout/cart/\'}}\">View Cart</a></li>\r\n   		 <li><a href=\"{{store url=\'wishlist/\'}}\">My Wishlist</a></li>\r\n   		 <li><a href=\"{{store url=\"\"}}faq\">FAQ</a></li>\r\n   	 </ul>\r\n    </div>\r\n</div>','2016-08-10 17:25:20','2016-09-13 20:47:22',1),(4,'header_info','header_info','<div class=\"header-info\">\r\n	<div class=\"container\">\r\n		<a href=\"{{store url=\'\'}}shipping-delivery\"><i class=\"icon-truck\"></i><strong>Free Shipping</strong> on orders over $99. This offer is valid on all our store items. </a>\r\n	</div>\r\n</div>','2016-08-15 18:42:07','2016-11-15 15:23:29',1),(5,'menu_block_1','menu_block_1','<div class=\"menu-block-1\">\r\n    <a class=\"menu-banner\" href=\"{{store url=\'\'}}furniture.html\">\r\n        <img src=\"{{view url=\'\'}}/images/media/menu-img-1.jpg\"/>\r\n    </a>\r\n    <a class=\"menu-banner\" href=\"{{store url=\'\'}}furniture.html\">\r\n        <img src=\"{{view url=\'\'}}/images/media/menu-img-2.jpg\"/>\r\n    </a>\r\n</div>','2016-08-21 17:22:39','2016-08-21 21:41:10',1),(6,'footer_block_1','footer_block_1','<div class=\"footer-block-1 footer-col\">\r\n    <h4 class=\"hidden-title\">About</h4>\r\n    <div class=\"footer-col-content\">\r\n        <div class=\"footer-logo\">\r\n            <div class=\"logoAfter\"></div>\r\n        </div>\r\n\r\n        <div class=\"desc-footer\">\r\n            We are an anyone’s ultimate destination for getting this perfect kitchen table, cozy armchair or a beautiful and comfy king sized bed! All in all, whatever home furniture you’ll be looking for, look no further!\r\n        </div>\r\n        <ul class=\"list-footer\">\r\n            <li><a target=\"_blank\" href=\"#\"><i class=\"fa fa-cc-visa\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"#\"><i class=\"fa fa-cc-mastercard\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"#\"><i class=\"fa fa-cc-paypal\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"#\"><i class=\"fa fa-cc-discover\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"#\"><i class=\"fa fa-cc-stripe\"></i></a></li>\r\n        </ul>\r\n    </div>\r\n</div>\r\n','2016-08-27 18:20:44','2016-12-07 00:39:29',1),(7,'footer_block_2','footer_block_2','<div class=\"footer-info footer-col\">\r\n    <h4>Contacts</h4>\r\n    <div class=\"footer-col-content\">\r\n        <ul class=\"list-contacts-footer\">\r\n            <li>\r\n                Address: <a href=\"#\">Glasgow D04 89GR</a>\r\n            </li>\r\n            <li>\r\n                Phones:\r\n                <a href=\"callto:80023456790\">800-2345-6789;</a>\r\n                <a href=\"callto:80023456790\">800-2345-6789</a>\r\n            </li>\r\n            <li>\r\n                E-mail: <a href=\"#\">info@demolink.org</a>\r\n            </li>\r\n            <li>\r\n                Hours: 7 days a week from 9:00 am to 7:00 pm\r\n            </li>\r\n        </ul>\r\n        <ul class=\"list-icon\">\r\n            <li><a target=\"_blank\" href=\"//www.facebook.com/TemplateMonster/\"><i class=\"fa fa-facebook\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//twitter.com/TemplateMonster\"><i class=\"fa fa-twitter\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//plus.google.com/+TemplateMonster\"><i class=\"fa fa-google-plus\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//www.instagram.com/template_monster/\"><i class=\"fa fa-instagram\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//www.pinterest.com/templatemonster/\"><i class=\"fa fa-pinterest\"></i></a></li>\r\n        </ul>\r\n    </div>\r\n</div>\r\n\r\n','2016-08-27 18:53:40','2016-08-27 23:54:04',1),(11,'block_1_layout_2','block_1_layout_2','<div class=\"row border-item\">\r\n    <div class=\"col-sm-4\">\r\n        <div class=\"custom-item-4\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_6_layout_2.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"title-1\">Sexy collections</div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}bras-bralettes.html\">Shop now!</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n    <div class=\"col-sm-4\">\r\n        <div class=\"custom-item-4 extra\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_7_layout_2.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"title-1\">Sale</div>\r\n                <div class=\"desc-1\">Get up to</div>\r\n                <div class=\"slog-1\">50% Off</div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}lingerie.html\">Shop now!</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n    <div class=\"col-sm-4\">\r\n        <div class=\"custom-item-4\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_8_layout_2.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"title-1\">Modern lingerie</div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}beauty.html\">Shop now!</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>','2016-10-18 06:07:20','2016-10-18 06:07:20',1),(12,'block_2_layout_2','block_2_layout_2','<div class=\"border-item\">\r\n    <div class=\"custom-item-5\">\r\n        <div class=\"custom-item-content\">\r\n            <div class=\"banner-label\">New!</div>\r\n            <div class=\"title-1\">Swim Collection 15% Off Beach Essentials</div>\r\n            <div class=\"desc-1\">We sell not only top quality products, but give our customers a positive online shopping experience.</div>\r\n            <a class=\"link-custom\" href=\"{{store url=\'\'}}sale-specials.html\">Shop now!</a>\r\n        </div>\r\n        <div class=\"custom-img-content\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_9_layout_2.jpg\"/>\r\n        </div>\r\n    </div>\r\n</div>','2016-10-18 06:15:49','2016-10-25 03:25:38',1),(13,'block_3_layout_2','block_3_layout_2','<div class=\"row border-none\">\r\n    <div class=\"col-sm-6\">\r\n        <div class=\"custom-item-6\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_10_layout_2.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"desc-1\">New season trends!</div>\r\n                <div class=\"title-1\">Get ready for Summer!</div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}lingerie.html\">Shop now</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n    <div class=\"col-sm-6\">\r\n        <div class=\"custom-item-6\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_11_layout_2.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"title-1\">Personalized Bra  Fittings</div>\r\n                <div class=\"desc-1\">for Women of all Sizes </div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}sleep.html\">Shop now</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>\r\n','2016-10-18 23:36:57','2016-10-18 23:42:37',1),(14,'menu_block_2','menu_block_2','<div class=\"mm-text\">\r\n    Find your perfect fit with silhouettes designed for both function and fashion. Magetique offers an extensive range of styles including soft bras, bandeaus, strapless bras and underwire bras.\r\n</div>','2016-10-24 22:58:10','2016-10-24 22:58:10',1),(15,'menu_block_3','menu_block_3','<div class=\"menu-block-3\">\r\n    <a class=\"menu-banner\" href=\"{{store url=\'\'}}lingerie.html\">\r\n        <img src=\"{{view url=\'\'}}/images/media/img_12_layout_2.jpg\"/>\r\n    </a>\r\n    <a class=\"menu-banner\" href=\"{{store url=\'\'}}sleep.html\">\r\n        <img src=\"{{view url=\'\'}}/images/media/img_13_layout_2.jpg\"/>\r\n    </a>\r\n</div>','2016-10-24 23:32:14','2016-10-24 23:32:14',1),(23,'block_4_2_layout_2','block_4_2_layout_2','<div class=\"row custom-item-indent\">\r\n    <div class=\"col-sm-6\">\r\n        <div class=\"custom-item-11 extra-color\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_22_lingeria.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"title-1\">Bras</div>\r\n                <div class=\"desc-1\">New Season Trends!</div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}lingerie.html\">Shop now</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n    <div class=\"col-sm-6\">\r\n        <div class=\"custom-item-11\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_23_lingeria.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"title-1\">Panties</div>\r\n                <div class=\"desc-1\">New Season Trends!</div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}panties.html\">Shop now</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n    <div class=\"col-sm-6\">\r\n        <div class=\"custom-item-11\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_24_lingeria.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"title-1\">Sexy</div>\r\n                <div class=\"desc-1\">New Season Trends!</div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}lingerie.html\">Shop now</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n    <div class=\"col-sm-6\">\r\n        <div class=\"custom-item-11 extra-color\">\r\n            <img src=\"{{view url=\'\'}}/images/media/img_25_lingeria.jpg\"/>\r\n            <div class=\"custom-item-content\">\r\n                <div class=\"title-1\">Sleep</div>\r\n                <div class=\"desc-1\">New Season Trends!</div>\r\n                <a class=\"link-custom\" href=\"{{store url=\'\'}}sleep.html\">Shop now</a>\r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>\r\n','2016-12-18 18:37:03','2016-12-18 18:52:14',1),(24,'block_5_2_layout_2','block_5_2_layout_2','<div class=\"custom-item-12\">\r\n    <div class=\"custom-item-content\">\r\n        <div class=\"desc-1\">New Season Trends!</div>\r\n        <div class=\"title-1\">Personalized Bra Fittings</div>\r\n        <a class=\"link-custom\" href=\"{{store url=\'\'}}lingerie.html\">Shop now!</a>\r\n    </div>\r\n    <div class=\"custom-img-content\">\r\n        <img src=\"{{view url=\'\'}}/images/media/img_26_lingeria.jpg\"/>\r\n    </div>\r\n</div>','2016-12-18 21:11:07','2016-12-18 21:11:07',1),(25,'block_6_2_layout_2','block_6_2_layout_2','<ul class=\"custom-item-13 row\">\r\n    <li class=\"col-sm-4\">\r\n        <div class=\"custom-content\">\r\n            <span class=\"icon-telephone\"></span>\r\n            <div class=\"title\">+3(800) 2345-6789</div>\r\n            <div class=\"desc-content\">Round-the-clock free hotline (24/7)</div>\r\n        </div>\r\n    </li>\r\n    <li class=\"col-sm-4\">\r\n        <div class=\"custom-content\">\r\n            <span class=\"icon-truck\"></span>\r\n            <div class=\"title\">Free Shipping</div>\r\n            <div class=\"desc-content\">Shipping cost for any delivery method and order cost <br /> is $49. Free delivery on orders of $99.</div>\r\n        </div>\r\n    </li>\r\n    <li class=\"col-sm-4\">\r\n        <div class=\"custom-content\">\r\n            <span class=\"icon-sync\"></span>\r\n            <div class=\"title\">Return & Exchange</div>\r\n            <div class=\"desc-content\">You can return or exchange the item <br />within 30 days.</div>\r\n        </div>\r\n    </li>\r\n</ul>','2016-12-18 23:42:47','2016-12-19 00:10:09',1),(31,'footer_block_3','footer_block_3','<div class=\"footer-block-3 footer-col\">\r\n    <h4 class=\"hidden-title\">Information</h4>\r\n    <div class=\"footer-col-content\">\r\n        <div class=\"footer-logo\">\r\n            <div class=\"logoAfter\"></div>\r\n        </div>\r\n\r\n        <div class=\"desc-footer\">\r\n            We are an anyone’s ultimate destination for getting this perfect kitchen table, cozy armchair or a beautiful and comfy king sized bed! All in all, whatever home furniture you’ll be looking for, look no further!\r\n        </div>\r\n        <ul class=\"list-icon\">\r\n            <li><a target=\"_blank\" href=\"//www.facebook.com/TemplateMonster/\"><i class=\"fa fa-facebook\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//twitter.com/TemplateMonster\"><i class=\"fa fa-twitter\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//plus.google.com/+TemplateMonster\"><i class=\"fa fa-google-plus\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//www.instagram.com/template_monster/\"><i class=\"fa fa-instagram\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//www.pinterest.com/templatemonster/\"><i class=\"fa fa-pinterest\"></i></a></li>\r\n        </ul>\r\n    </div>\r\n</div>\r\n','2016-12-23 22:27:42','2016-12-23 22:29:21',1),(37,'footer_block_4','footer_block_4','<div class=\"footer-block-4 footer-col\">\r\n    <h4 class=\"hidden-title\">Information</h4>\r\n    <div class=\"footer-col-content\">\r\n        <div class=\"footer-logo\">\r\n            <div class=\"logoAfter\"></div>\r\n        </div>\r\n        <ul class=\"list-icon\">\r\n            <li><a target=\"_blank\" href=\"//www.facebook.com/TemplateMonster/\"><i class=\"fa fa-facebook\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//twitter.com/TemplateMonster\"><i class=\"fa fa-twitter\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//plus.google.com/+TemplateMonster\"><i class=\"fa fa-google-plus\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//www.instagram.com/template_monster/\"><i class=\"fa fa-instagram\"></i></a></li>\r\n            <li><a target=\"_blank\" href=\"//www.pinterest.com/templatemonster/\"><i class=\"fa fa-pinterest\"></i></a></li>\r\n        </ul>\r\n    </div>\r\n</div>','2017-01-13 06:03:36','2017-01-13 06:03:36',1),(38,'AMP Footer Links','amp_footer_links','<ul><li><a href=\"{{store url=\'about-us\'}}\">About Us</a></li><li><a href=\"{{store url=\'contact\'}}\">Contact Us</a></li><li><a href=\"{{store url=\'customer-service\'}}\">Customer Service</a></li><li><a href=\"{{store url=\'privacy-policy-cookie-restriction-mode\'}}\">Privacy Policy</a></li><li><a href=\"{{store url=\'template-settings\'}}\">Templates Settings</a></li></ul>','2018-01-19 14:48:35','2018-01-19 14:48:35',1);

--
-- Table structure for table `cms_block_store`
--

CREATE TABLE `cms_block_store` (
  `block_id` smallint(6) NOT NULL COMMENT 'Block ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`block_id`,`store_id`),
  KEY `CMS_BLOCK_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS Block To Store Linkage Table';

--
-- Dumping data for table `cms_block_store`
--

INSERT INTO `cms_block_store` VALUES (1,0),(2,0),(3,0),(4,0),(5,0),(6,0),(7,0),(11,0),(12,0),(13,0),(14,0),(15,0),(23,0),(24,0),(25,0),(31,0),(37,0),(38,0);

--
-- Table structure for table `cms_page`
--

CREATE TABLE `cms_page` (
  `page_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Page ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `meta_keywords` text COMMENT 'Page Meta Keywords',
  `meta_description` text COMMENT 'Page Meta Description',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Page String Identifier',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Page Content Heading',
  `content` mediumtext COMMENT 'Page Content',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Page Creation Time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Page Modification Time',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Page Active',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Page Sort Order',
  `layout_update_xml` text COMMENT 'Page Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Page Custom Theme',
  `custom_root_template` varchar(255) DEFAULT NULL COMMENT 'Page Custom Template',
  `custom_layout_update_xml` text COMMENT 'Page Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Page Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Page Custom Theme Active To Date',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Meta Title',
  PRIMARY KEY (`page_id`),
  KEY `CMS_PAGE_IDENTIFIER` (`identifier`),
  FULLTEXT KEY `CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='CMS Page Table';

--
-- Dumping data for table `cms_page`
--

INSERT INTO `cms_page` VALUES (1,'404 Not Found','1column','Page keywords','Page description','no-route','Whoops, our bad...','<div class=\"not-found-page\">\r\n    <dl>\r\n        <dt class=\"not-found-page_top\">\r\n            <img src=\"{{view url=\'images/404.png\'}}\" alt=\"404-img\">\r\n            <div>\r\n                <strong>Sorry...</strong>\r\n                <span>It’s not you. It’s us.</span>\r\n            </div>\r\n        </dt>\r\n    </dl>\r\n    <dl class=\"not-found-page_bottom\">\r\n        <dt>The page you are looking for can’t be found.</dt>\r\n        <dd><a href=\"{{store url=\"\"}}\">Go Home!</a></dd>\r\n    </dl>\r\n</div>','2017-10-21 08:06:12','2017-10-21 08:06:12',1,0,'','','',NULL,NULL,NULL,''),(2,'Magetique','1column','','','home','','\r\n','2017-10-21 08:06:12','2017-10-21 08:06:12',1,0,'<!--\r\n    <referenceContainer name=\"right\">\r\n        <action method=\"unsetChild\"><argument name=\"alias\" xsi:type=\"string\">right.reports.product.viewed</argument></action>\r\n        <action method=\"unsetChild\"><argument name=\"alias\" xsi:type=\"string\">right.reports.product.compared</argument></action>\r\n    </referenceContainer>-->','','',NULL,NULL,NULL,''),(3,'Enable Cookies','1column',NULL,NULL,'enable-cookies','What are Cookies?','<div class=\"enable-cookies cms-content\">\r\n<p>\"Cookies\" are little pieces of data we send when you visit our store. Cookies help us get to know you better and personalize your experience. Plus they help protect you and other shoppers from fraud.</p>\r\n<p style=\"margin-bottom: 20px;\">Set your browser to accept cookies so you can buy items, save items, and receive customized recommendations. Here’s how:</p>\r\n<ul>\r\n<li><a href=\"https://support.google.com/accounts/answer/61416?hl=en\" target=\"_blank\">Google Chrome</a></li>\r\n<li><a href=\"http://windows.microsoft.com/en-us/internet-explorer/delete-manage-cookies\" target=\"_blank\">Internet Explorer</a></li>\r\n<li><a href=\"http://support.apple.com/kb/PH19214\" target=\"_blank\">Safari</a></li>\r\n<li><a href=\"https://support.mozilla.org/en-US/kb/enable-and-disable-cookies-website-preferences\" target=\"_blank\">Mozilla/Firefox</a></li>\r\n</ul>\r\n</div>','2017-10-21 08:06:12','2017-10-21 08:06:12',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Privacy Policy','1column','','','privacy-policy-cookie-restriction-mode','','<div class=\"change-message\">\r\n    <span>Please replace this text with your Privacy Policy.</span>\r\n</div>\r\n<dl class=\"custom-page privacy-policy-page\">\r\n    <dt class=\"heading-2\">General information</dt>\r\n    <dd>Welcome to our Privacy Policy page! When you use our store services, you trust us with your information. This Privacy Policy is meant to help you understand what data we collect, why we collect it, and what we do with it. When you share information with us, we can make our services even better for you. For instance, we can show you more relevant search results and ads, help you connect with people or to make sharing with others quicker and easier. As you use our services, we want you to be clear how we’re using information and the ways in which you can protect your privacy. This is important; we hope you will take time to read it carefully. Remember, you can find controls to manage your information and protect your privacy and security. We’ve tried to keep it as simple as possible.</dd>\r\n    <dt class=\"heading-2\">Right to access, correct and delete data and to object to data processing</dt>\r\n    <dd>Our customers have the right to access, correct and delete personal data relating to them, and to object to the processing of such data, by addressing a written request, at any time. The Company makes every effort to put in place suitable precautions to safeguard the security and privacy of personal data, and to prevent it from being altered, corrupted, destroyed or accessed by unauthorized third parties. However, the Company does not control each and every risk related to the use of the Internet, and therefore warns the Site users of the potential risks involved in the functioning and use of the Internet. The Site may include links to other web sites or other internet sources. As the Company cannot control these web sites and external sources, the Company cannot be held responsible for the provision or display of these web sites and external sources, and may not be held liable for the content, advertising, products, services or any other material available on or from these web sites or external sources.</dd>\r\n    <dt class=\"heading-2\">Management of personal data</dt>\r\n    <dd>You can view or edit your personal data online for many of our services. You can also make choices about our collection and use of your data. How you can access or control your personal data will depend on which services you use. You can choose whether you wish to receive promotional communications from our store by email, SMS, physical mail, and telephone. If you receive promotional email or SMS messages from us and would like to opt out, you can do so by following the directions in that message. You can also make choices about the receipt of promotional email, telephone calls, and postal mail by visiting and signing into Company Promotional Communications Manager, which allows you to update contact information, manage contact preferences, opt out of email subscriptions, and choose whether to share your contact information with our partners. These choices do not apply to mandatory service communications that are part of certain store services.</dd>\r\n    <dt class=\"heading-2\">Information We Collect</dt>\r\n    <dd>Our store collects data to operate effectively and provide you the best experiences with our services. You provide some of this data directly, such as when you create a personal account. We get some of it by recording how you interact with our services by, for example, using technologies like cookies, and receiving error reports or usage data from software running on your device. We also obtain data from third parties (including other companies). For example, we supplement the data we collect by purchasing demographic data from other companies. We also use services from other companies to help us determine a location based on your IP address in order to customize certain services to your location. The data we collect depends on the services and features you use.</dd>\r\n    <dt class=\"heading-2\">How We Use Your Information</dt>\r\n    <dd>Our store uses the data we collect for three basic purposes: to operate our business and provide (including improving and personalizing) the services we offer, to send communications, including promotional communications, and to display advertising. In carrying out these purposes, we combine data we collect through the various store services you use to give you a more seamless, consistent and personalized experience. However, to enhance privacy, we have built in technological and procedural safeguards designed to prevent certain data combinations. For example, we store data we collect from you when you are unauthenticated (not signed in) separately from any account information that directly identifies you, such as your name, email address or phone number.</dd>\r\n    <dt class=\"heading-2\">Sharing Your Information</dt>\r\n    <dd>We share your personal data with your consent or as necessary to complete any transaction or provide any service you have requested or authorized. For example, we share your content with third parties when you tell us to do so. When you provide payment data to make a purchase, we will share payment data with banks and other entities that process payment transactions or provide other financial services, and for fraud prevention and credit risk reduction. In addition, we share personal data among our controlled affiliates and subsidiaries. We also share personal data with vendors or agents working on our behalf for the purposes described in this statement. For example, companies we\'ve hired to provide customer service support or assist in protecting and securing our systems and services may need access to personal data in order to provide those functions. In such cases, these companies must abide by our data privacy and security requirements and are not allowed to use personal data they receive from us for any other purpose. We may also disclose personal data as part of a corporate transaction such as a merger or sale of assets.</dd>\r\n</dl>','2017-10-21 08:06:13','2017-10-21 08:06:13',1,0,'','','',NULL,NULL,NULL,''),(5,'Customer Service','1column','','','customer-service',' Customer Service','<div class=\"customer-service\">\r\n    <div class=\"text-block customer-service__block\">\r\n        <h3>Delivery</h3>\r\n        <h4>Hello and welcome to the shipping and delivery information page! Here you can get acquainted with useful information on terms \r\nand conditions of our goods delivery</h4>\r\n        <p>You can purchase your items online and pick them up at our street store, or ship them directly to your doorstep. Shipping is free on some orders. We use the best carriers in the business to make sure your order gets to you on time. From the Secure Checkout page you\'ll see your item description, price and delivery timing. Where available, you can also choose a faster delivery method for each item on your order, for an additional fee. Delivery times vary according to your selected delivery address, availability of your items and the time of day you place your order.</p>\r\n    </div>\r\n    <div class=\"table-block  customer-service__block\">\r\n        <h3>Cost</h3>\r\n        <div class=\"table-block_wrapper\">\r\n            <table>\r\n                <thead>\r\n                    <th>Services</th>\r\n                    <th>Locations</th>\r\n                    <th>Delivery Schedule</th>\r\n                    <th>Cost Per Shipment</th>\r\n                </thead>\r\n                <tbody>\r\n                    <tr>\r\n                        <td>Royal mail 1st Class Service (Order value $20 or less)</td>\r\n                        <td>All of UK & some European Countries</td>\r\n                        <td>1-3 days Monday - Saturday</td>\r\n                        <td>$5</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Royal mail Tracker (Order value $50 or less)</td>\r\n                        <td>All of UK</td>\r\n                        <td>1-3 days Delivery 7.30am - 5.30am Monday - Friday</td>\r\n                        <td>$45</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Standard Courier Delivery</td>\r\n                        <td>UK mainland only</td>\r\n                        <td>1-3 days Monday - Saturday</td>\r\n                        <td>$124</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Standard Courier Delivery</td>\r\n                        <td>Northern Ireland, Eire, Scilly Isles</td>\r\n                        <td>1-3 days Delivery 7.30am - 5.30am Monday - Friday</td>\r\n                        <td>$11</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Royal mail 1st Class Service (Order value $20 or less)</td>\r\n                        <td>All of UK & some European Countries</td>\r\n                        <td>1-3 days Monday - Saturday</td>\r\n                        <td>$5</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Priority courier pre 12pm Next Working Day</td>\r\n                        <td>UK mainland only</td>\r\n                        <td>1-3 days Delivery 7.30am - 5.30am Monday - Friday</td>\r\n                        <td>$89</td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td>Royal mail 1st Class Service (Order value $20 or less)</td>\r\n                        <td>All of UK & some European Countries</td>\r\n                        <td>1-3 days Monday - Saturday</td>\r\n                        <td>$72</td>\r\n                    </tr>\r\n                </tbody>\r\n            </table>            \r\n        </div>\r\n    </div>\r\n    <div class=\"text-block  customer-service__block\">\r\n        <h3>Free Delivery</h3>\r\n        <p>Free two-day shipping is available on in-stock items. You can see in your bag if your item is in stock. Free two-day shipping is not available on customized, engraved products, and for certain order types, including orders paid for with financing or by bank transfer. To get free two-day shipping, you will need to place your order by 5pm, Monday to Friday. For instance, if you order your goods before 5:00 pm, Monday to Friday we will deliver them in two business days.</p>\r\n    </div>\r\n    <div class=\"list-block  customer-service__block\">\r\n        <h3>Terms & Conditions</h3>\r\n        <ul class=\"row\">\r\n            <li class=\"col-md-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Entire agreement</h4>\r\n                <p>If you require a complete delivery of your orders, please enter an X in the Complete Delivery field on the shipping screen of the customer master record. The indicator is copied into the order header, which you can also use for the purpose.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n            <li class=\"col-md-6\">\r\n                <h4>Controlling terms</h4>\r\n                <p>Buyer expressly agrees that Seller’s Invoice and these Terms and Conditions of Sale represent the complete agreement of the parties with respect to the sale of the product(s) listed on the Invoice and no different or additional terms or conditions in Buyer’s purchase order or in any other prior or subsequent communications in any way adding to, modifying or otherwise changing these Terms and Conditions of Sale shall be binding upon Seller.</p>\r\n            </li>\r\n        </ul>\r\n    </div>\r\n</div>\r\n\r\n<script>\r\nvar headertext = [];\r\nvar headers = document.querySelectorAll(\".table-block thead\");\r\nvar tablebody = document.querySelectorAll(\".table-block tbody\");\r\n\r\nfor (var i = 0; i < headers.length; i++) {\r\n    headertext[i]=[];\r\n    for (var j = 0, headrow; headrow = headers[i].rows[0].cells[j]; j++) {\r\n      var current = headrow;\r\n      headertext[i].push(current.textContent);\r\n      }\r\n} \r\n\r\nfor (var h = 0, tbody; tbody = tablebody[h]; h++) {\r\n    for (var i = 0, row; row = tbody.rows[i]; i++) {\r\n      for (var j = 0, col; col = row.cells[j]; j++) {\r\n        col.setAttribute(\"data-th\", headertext[h][j]);\r\n      } \r\n    }\r\n}\r\n</script>','2017-11-25 19:52:19','2017-11-25 19:52:19',1,0,'','','',NULL,NULL,NULL,''),(6,'About Us','1column','','','about-us','About Us','<div class=\"about-us-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2 col-sm-12 \">\r\n        <img src=\"{{view url=\'images/media/aboutus.jpg\'}}\" alt=\"page-img\">\r\n        <p>\r\n            If we talk about our founder, Mary Harris, her interest in furniture and everything related to it began in her father\'s local chairs & tables store in Virginia... Starting off as his helper and accountant, she eventually grew fond of the whole thing and began to consider an option of starting her own furniture store in the big city. With her first store in Arlington in 1999, Mary\'s chain began to gradually expand, now consisting of more than 5 furniture stores nationwide... We sell only the best furniture sets and pieces, manufactured in either US, Canada or the UK... All of our range includes only brands with long-lasting reputation, which have been proved as popular among people for years...\r\n        </p>\r\n        <p>\r\n            Ultimate Quality and Comfort <br> When you\'re looking for a sofa or a chair, comfort and durability must come first! With our range of cozy daybeds, recliners and many other pieces we can guarantee that you\'ll find it!\r\n        </p>\r\n        <p>\r\n            Agreeable pricing for a great quality <br> The pricing policy that we have put in place makes affordability a centre point... While for some people quality means sky-high cost, for us the balance between these two is reached easily.\r\n        </p>     \r\n    </div>\r\n</div>','2017-11-25 19:53:02','2017-11-25 19:53:02',1,0,'','','',NULL,NULL,NULL,''),(7,'Shipping & Delivery','1column','','','shipping-delivery','Shipping & Delivery','<div class=\"shipping-delivery-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <p>\r\n            So you’ve done your shopping; just how long will it be till you can rock that swanky new Axolotl-themed laptop skin? The calculator below will give you the average amount of days it takes to ship a product to your door and the best time to contact our support team. Please note that every order at Redbubble is custom printed just for you, and will take 1-3 business days to print prior to shipping.\r\n        </p>\r\n        <span class=\"heading-3\">Here are a few things to consider while you wait for your order:</span>\r\n        <ul>\r\n            <li><span>We ship in business days. Monday - Friday, excluding national holidays.</span></li>\r\n            <li><span>Shipping starts from the date you received the “Your Order Has Shipped!” email.</span></li>\r\n            <li><span>The estimate above does not include manufacturing time - we need 1-3 business days to make sure your custom order is everything you hoped it would be.</span></li>\r\n        </ul>\r\n        <p>\r\n            Redbubble is a global company - we work with production and shipping partners all over the world to get your things to your doorstep, wherever that may be. Although the vast majority of our customers will get their orders by the day listed above, actual timeframes may vary from region to region.\r\n        </p>\r\n        <div class=\"shipping-delivery-page__border\">\r\n            <span class=\"heading-3\">So when do you contact Redbubble?</span>\r\n            <span>The calculator above lets you know the best time to message us. When that day rolls around.</span>\r\n            <span>Even if your order hasn’t arrived by the listed date, it’s probably still on its way (and worth the wait).</span>\r\n        </div>\r\n        <ol class=\"shipping-delivery-page__list\">\r\n            <li>\r\n                <span class=\"heading-3 shipping-delivery-page_shipping-icon\">How much is shipping?</span>\r\n                <p>Once you’ve clicked through to Secure Checkout, you can enter your delivery address and choose a shipping method. Shipping costs are then calculated and tacked on to your subtotal at the bottom of the page.</p>\r\n            </li>\r\n            <li>\r\n                <span class=\"heading-3 shipping-delivery-page_track-icon\">Can I track my order?</span>\r\n                <p>We rely on a global network of shipping partners (UPS, FedEx, DHL) as well as local postal services (USPS) to get your order to your doorstep as soon as possible. For this reason, tracking is not always available. If your order is being sent by a trackable service, these details will be included on your orders page as well as on the shipping email we send you.</p>\r\n            </li>\r\n            <li>\r\n                <span class=\"heading-3 shipping-delivery-page_order-icon\">Where does my order ship from?</span>\r\n                <p>We rely on a global network of shipping partners (UPS, FedEx, DHL) as well as local postal services (USPS) to get your order to your doorstep as soon as possible. For this reason, tracking is not always available. If your order is being sent by a trackable service, these details will be included on your orders page as well as on the shipping email we send you.</p>\r\n            </li>\r\n        </ol>\r\n    </div>\r\n</div>','2017-11-25 19:53:09','2017-11-25 19:53:09',1,0,'','','',NULL,NULL,NULL,''),(9,'FAQ','1column','','','faq','FAQ','<div class=\"faq-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <div id=\"faq-accordion\">\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>Is it necessary for me to register an account in order to buy an item?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>Which shipping providers do you use?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>How long it will take to receive the furniture?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>How long it will take to receive the furniture?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>Do you offer any kind of discounts?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n            <div class=\"accordion-block close\">\r\n                <div class=\"accordion-trigger close\">\r\n                    <span>Do you accept orders from all 50 US states?</span>\r\n                </div>\r\n                <div class=\"accordion-content\">\r\n                    <p> Yes and this is made with your own convenience in mind.  By creating (or using) an account during the  purchasing process you will have 3 things made so much easier for yourself:</p>\r\n                    <ul>\r\n                        <li>- keeping track of your order\'s delivery status</li>\r\n                        <li>- changing or canceling the order</li>\r\n                        <li>- using your previous purchase history to become eligible for a Loyal Customer\'s discount</li>\r\n                    </ul>\r\n                  </div>                \r\n            </div>\r\n        </div>\r\n    </div>\r\n</div>','2017-11-25 19:55:09','2017-11-25 19:55:09',1,0,'','','',NULL,NULL,NULL,''),(10,'Support','empty','','','support','Support','<div class=\"support-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <div class=\"text-block\">\r\n            <p>Our customer support department is ready to come to your aid in a 24/7 manner, be your request in a form on email ticket or a phone call... We have a team of professional managers who will consult you regarding any technical, in-stock or billing question you might have. Also, should there be any problems with the delivery or if you would want to file a return, we will help you as well!</p>\r\n        </div>\r\n        <div class=\"boxes-block\">\r\n            <h3>Have a Question?</h3>\r\n            <ul class=\"row\">\r\n                <li class=\"col-md-6\"><a href=\"#\"><div>\r\n                    <span class=\"support-page__archive-icon\">Knowledge Base</span>\r\n                </div></a></li>\r\n                <li class=\"col-md-6\"><a href=\"#\"><div>\r\n                    <span class=\"support-page__bubbles-icon\">Community Forum</span>\r\n                </div></a></li>\r\n                <li class=\"col-md-6\"><a href=\"#\"><div>\r\n                    <span class=\"support-page__bubble-question-icon\">24/7Ticket Support</span>\r\n                </div></a></li>\r\n                <li class=\"col-md-6\"><a href=\"#\"><div>\r\n                    <span class=\"support-page__envelope-icon\">Contact us</span>\r\n                </div></a></li>\r\n            </ul>\r\n        </div>        \r\n    </div>\r\n</div>\r\n','2017-11-25 19:55:27','2017-11-25 19:55:27',1,0,'','','',NULL,NULL,NULL,'');
INSERT INTO `cms_page` VALUES (11,'Guarantee','1column','','','guarantee','Guarantee & After-Sales Service','<div class=\"guarantee-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <div class=\"text-block\">\r\n            <p>Quite often, even after we’ve chosen an item and purchased it successfully, there may be some things we might want to change or repair afterward - either during or following the delivery process, when filing a return or applying for using our warranty. Here we\'ll try to explain in plain terms how does our store’s warranty policy works and how you can be using it when shopping with us!</p>\r\n        </div>\r\n        <div class=\"text-block\">\r\n            <h3>What Products are Provided with the Warranty?</h3>\r\n            <p>Some of our furniture items apply for an almost unconditional Lifetime Warranty. The items included in this policy are sofas, couches, love seats, upholstered chairs, ottomans, sectionals, and sleepers. As a retailer we warrant these components to you, the original retail purchaser, to be free from material manufacturing defects. The lifetime duration of the Warranty means the standardized usage cycle for a specific furniture item.</p>\r\n            <ul>\r\n                <li>\r\n                    <h4>Repair & Refurbishing</h4>\r\n                    <span>Our store will pay, within one year from the date of purchase, reasonable and conditional labor rates for refurbishing or replacing the defective parts and shipping costs.</span>\r\n                </li>\r\n                <li>\r\n                    <h4>Different Types of Warranty</h4>\r\n                    <span>While for some items we have a lifetime warranty, the springs in all of our items are offered with a 5 Year Limited type of a Warranty.</span>\r\n                </li>\r\n                <li>\r\n                    <h4>Warranty Exceptions</h4>\r\n                    <span>All seat cushion cores have a natural tendency to become softer during a normal usage cycle, and will conform to the shape of the user. A Limited 1 Year Warranty applies.</span>\r\n                </li>\r\n            </ul>\r\n        </div>\r\n        <div class=\"text-block\">\r\n            <h3>Where to Apply for Warranty Services?</h3>\r\n            <p>Under these Limited Warranties, all of the legal liability of our store is limited to repair, or  if required (or requested by the customer), replacement. We are  ready to pay, within one year from the date of purchase, reasonable and customary labor rates to repair or replace the defective parts and shipping costs from the retailer...</p>\r\n            <p>These Limited Warranties are not applicable for any of our products which ave been altered by any person, dealer, or company without the express written authorization of our store. PLease note, that some States Do Not Allow Limitations On How Long An Implied Warranty Lasts, So The Above Limitations May Not Apply To You.</p>\r\n        </div>\r\n        <div class=\"text-block\">\r\n            <h3>In What Cases the Warranty is Not Provided?</h3>\r\n            <p>There can be two limits for the Warranties issued with the purchase of the furniture items on our website.</p>\r\n            <ul class=\"row\">\r\n                <li class=\"col-md-6\">\r\n                    <h4>1, 3 & 5 Years Limited Warranty</h4>\r\n                    <span>The first one is the Warranty time frame, if it is limited to 1, 3 or 5 years. Hence the Lifetime Warranty is not time-restricted.</span>\r\n                </li>\r\n                <li class=\"col-md-6\">\r\n                    <h4>Regular Usage Check</h4>\r\n                    <span>The second one is the examination of the item by our customer support agent, making sure the usage was regular.</span>\r\n                </li>\r\n            </ul>\r\n        </div>\r\n        <div class=\"text-block\">\r\n            <h3>Change and Return</h3>\r\n            <p>Filing a change or a return is an easy process, requiring nothing more than your proof of purchase (which usually is the receipt you received), the item itself and the return label printed out by you and put at the top of the package...</p>\r\n        </div>    \r\n    </div>\r\n</div>','2017-11-25 19:55:56','2017-11-25 19:55:56',1,0,'','','',NULL,NULL,NULL,''),(12,'Secure payment','1column','','','secure-payment','Secure payment','<div class=\"secure-payment-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <p>\r\n            When it comes to purchasing something, anything online, the security question towers above everything else. We do not take our store’s overall cyber security and particularly the billing process security lightly. We can assure you that all of your shopping here will be a fun and safe experience, enhanced by the all of the factors listed below.\r\n        </p>\r\n        <ul>\r\n            <li>\r\n                <h4>SSL Certificate</h4>\r\n                <span>If the website has an SLL certificate, this means that the owners care about your shopping experience being secure, safe and sound and want to make sure that all the data (including financial) that you enter on our website will be securely encrypted!</span>\r\n            </li>\r\n            <li>\r\n                <h4>Multiple Gateways</h4>\r\n                <span>When we were considering which payment gateways to use on our website, the choice narrowed down to 5 most universal ones: Visa; MasterCard; PayPal; Discover; Stripe.</span>\r\n            </li>\r\n            <li>\r\n                <h4>24/7 Customer Support</h4>\r\n                <span>Also, it is comforting to know that should you experience any kind of technical bump in the road during the checkout process, you can always address our customer support department with your billing questions!</span>\r\n            </li>\r\n        </ul>\r\n        <div class=\"secure-payment_icons\">\r\n            <ul>\r\n                <li><a href=\"#\" class=\"fa fa-cc-visa\"></a></li>\r\n                <li><a href=\"#\" class=\"fa fa-cc-mastercard\"></a></li>\r\n                <li><a href=\"#\" class=\"fa fa-cc-paypal\"></a></li>\r\n                <li><a href=\"#\" class=\"fa fa-cc-discover\"></a></li>\r\n                <li><a href=\"#\" class=\"fa fa-cc-stripe\"></a></li>\r\n            </ul>\r\n        </div>\r\n    </div>\r\n</div>','2017-11-25 19:56:34','2017-11-25 19:56:34',1,0,'','','',NULL,NULL,NULL,''),(13,'Terms & Conditions','1column','','','terms-conditions','Terms & Conditions','<div class=\"terms-conditions-page row\">\r\n    <div class=\"col-md-8 col-md-preffix-2\">\r\n        <div class=\"text-block\">\r\n            <p>This Policy is projected to all personal information and sensitive personal data or information that is given by or obtained from any person who visits or uses or accesses the website (\"User\"). We reserve the right to modify or review the details of this Policy without prior notice and the revised Policy will be in effect from the day of uploading.  Therefore, Users are requested to periodically visit the website and review the policy.</p>\r\n            <ul>\r\n                <li>\r\n                    <h4>Rule 1</h4>\r\n                    <p>A User may be required to give away some Personal Information, including Sensitive Personal Information while browsing through the website or for availing services at the website.\r\n</p>\r\n                </li>\r\n                <li>\r\n                    <h4>Rule 2</h4>\r\n                    <p>Personal Information disclosed to Us by a User will be used by Us for one or more of the following purposes: (a) to help Us in creating content that is relevant to the User; (b)  to collect a database of all the Personal Information collected from User</p>\r\n                </li>\r\n                <li>\r\n                    <h4>Rule 3</h4>\r\n                    <p>When a User visits the website, one or more cookies shall be sent to a computer or the device being used by the User to visit the websites. Cookies are used upscale the quality of the services provided by Us, including for keeping User preferences...</p>\r\n                </li>\r\n            </ul>\r\n        </div>        \r\n    </div>\r\n</div>','2017-11-25 19:56:56','2017-11-25 19:56:56',1,0,'','','',NULL,NULL,NULL,''),(14,'Template settings','1column','','','template-settings','Template settings','<h3><em>Home pages configuration all stores</em></h3>\r\n<table class=\"data-table data-table-indent\">\r\n    <thead>\r\n    <tr>\r\n        <th>#</th>\r\n        <th>Page Name</th>\r\n        <th>Page HTML (Content tab)</th>\r\n        <th>Page XML (Design tab)</th>\r\n        <th>Layout</th>\r\n    </tr>\r\n    </thead>\r\n    <tbody>\r\n    <tr>\r\n        <td>1.</td>\r\n        <td>Home Page</td>\r\n        <td>sources\\demo\\pages\\home_page.phtml</td>\r\n        <td>sources\\demo\\pages\\home_page.xml</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>2.</td>\r\n        <td>About  Us</td>\r\n        <td>sources\\demo\\pages\\about_us.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>3.</td>\r\n        <td>Customer Service</td>\r\n        <td>sources\\demo\\pages\\customer_service.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>4.</td>\r\n        <td>Privacy Policy</td>\r\n        <td>sources\\demo\\pages\\privacy_policy.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>5.</td>\r\n        <td>404 Not Found</td>\r\n        <td>sources\\demo\\pages\\no-route.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>6.</td>\r\n        <td>Shipping & Delivery</td>\r\n        <td>sources\\demo\\pages\\shipping_delivery.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>7.</td>\r\n        <td>FAQ</td>\r\n        <td>sources\\demo\\pages\\faq.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>8.</td>\r\n        <td>Support</td>\r\n        <td>sources\\demo\\pages\\support.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>9.</td>\r\n        <td>Guarantee</td>\r\n        <td>sources\\demo\\pages\\guarantee.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>10.</td>\r\n        <td>Secure payment</td>\r\n        <td>sources\\demo\\pages\\secure_payment.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    <tr>\r\n        <td>11.</td>\r\n        <td>Terms & Conditions</td>\r\n        <td>sources\\demo\\pages\\terms_conditions.phtml</td>\r\n        <td>NA</td>\r\n        <td>1 column</td>\r\n    </tr>\r\n    </tbody>\r\n</table>\r\n\r\n\r\n\r\n<h3><em>Static blocks configuration all stores</em></h3>\r\n\r\n<table class=\"data-table data-table-indent\">\r\n    <thead>\r\n    <tr>\r\n        <th>#</th>\r\n        <th>Block Title</th>\r\n        <th>Identifier</th>\r\n        <th>Content</th>\r\n    </tr>\r\n    </thead>\r\n    <tbody>\r\n    <tr>\r\n        <td>1.</td>\r\n        <td>Footer column content 1</td>\r\n        <td>footer_col_1</td>\r\n        <td>sources\\demo\\blocks\\footer_col_1.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>2.</td>\r\n        <td>Footer column content 2</td>\r\n        <td>footer_col_2</td>\r\n        <td>sources\\demo\\blocks\\footer_col_2.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>3.</td>\r\n        <td>Footer column content 3</td>\r\n        <td>footer_col_3</td>\r\n        <td>sources\\demo\\blocks\\footer_col_3.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>3.</td>\r\n        <td>header_info</td>\r\n        <td>header_info</td>\r\n        <td>sources\\demo\\blocks\\header_info.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>4.</td>\r\n        <td>footer_block_1</td>\r\n        <td>footer_block_1</td>\r\n        <td>sources\\demo\\blocks\\footer_block_1.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>5.</td>\r\n        <td>footer_block_2</td>\r\n        <td>footer_block_2</td>\r\n        <td>sources\\demo\\blocks\\footer_block_2.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>6.</td>\r\n        <td>footer_block_3</td>\r\n        <td>footer_block_3</td>\r\n        <td>sources\\demo\\blocks\\footer_block_3.phtml</td>\r\n    </tr>\r\n    </tbody>\r\n</table>\r\n\r\n\r\n<h3 class=\"extra-title-settings\">Lingerie ---------------------------------------</h3>\r\n\r\n<h3><em>Static blocks Lingerie layout 1</em></h3>\r\n\r\n<table class=\"data-table data-table-indent\">\r\n    <thead>\r\n    <tr>\r\n        <th>#</th>\r\n        <th>Block Title</th>\r\n        <th>Identifier</th>\r\n        <th>Content</th>\r\n    </tr>\r\n    </thead>\r\n    <tbody>\r\n    <tr>\r\n        <td>1.</td>\r\n        <td>block_1_layout_2</td>\r\n        <td>block_1_layout_2</td>\r\n        <td>sources\\demo\\static_blocks\\layout_2\\block_1_layout_2.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>2.</td>\r\n        <td>block_2_layout_2</td>\r\n        <td>block_2_layout_2</td>\r\n        <td>sources\\demo\\static_blocks\\layout_2\\block_2_layout_2.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>3.</td>\r\n        <td>block_3_layout_2</td>\r\n        <td>block_3_layout_2</td>\r\n        <td>sources\\demo\\static_blocks\\layout_2\\block_3_layout_2.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>5.</td>\r\n        <td>menu_block_2</td>\r\n        <td>menu_block_2</td>\r\n        <td>sources\\demo\\static_blocks\\layout_2\\menu_block_2.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>6.</td>\r\n        <td>menu_block_3</td>\r\n        <td>menu_block_3</td>\r\n        <td>sources\\demo\\static_blocks\\layout_2\\menu_block_3.phtml</td>\r\n    </tr>\r\n    </tbody>\r\n</table>\r\n\r\n\r\n<h3><em>Widgets configuration Lingerie layout 1</em></h3>\r\n\r\n<table class=\"data-table data-table-indent\">\r\n    <thead>\r\n    <tr>\r\n        <th>#</th>\r\n        <th>Widget Name</th>\r\n        <th>Widget type</th>\r\n        <th>Container</th>\r\n        <th>Template / (Static blocks)</th>\r\n        <th>Sort Order</th>\r\n    </tr>\r\n    </thead>\r\n    <tbody>\r\n    <tr>\r\n        <td>1.</td>\r\n        <td>Slider_layout_2</td>\r\n        <td>Template Monster FilmSlider</td>\r\n        <td>After Page Header</td>\r\n        <td>Slider_layout_2</td>\r\n        <td>1</td>\r\n    </tr>\r\n    <tr>\r\n        <td>2.</td>\r\n        <td>block_1_layout_2</td>\r\n        <td>CMS Static Block</td>\r\n        <td>Main Content Area</td>\r\n        <td>block_1_layout_2</td>\r\n        <td>1</td>\r\n    </tr>\r\n    <tr>\r\n        <td>3.</td>\r\n        <td>block_2_layout_2</td>\r\n        <td>CMS Static Block</td>\r\n        <td>Main Content Area</td>\r\n        <td>block_2_layout_2</td>\r\n        <td>2</td>\r\n    </tr>\r\n    <tr>\r\n        <td>4.</td>\r\n        <td>New Product</td>\r\n        <td>Featured products</td>\r\n        <td>Main Content Area</td>\r\n        <td>Products Grid</td>\r\n        <td>3</td>\r\n    </tr>\r\n    <tr>\r\n        <td>5.</td>\r\n        <td>Special Products</td>\r\n        <td>Featured products</td>\r\n        <td>Main Content Area</td>\r\n        <td>Products Grid</td>\r\n        <td>4</td>\r\n    </tr>\r\n    <tr>\r\n        <td>6.</td>\r\n        <td>block_3_layout_2</td>\r\n        <td>CMS Static Block</td>\r\n        <td>Main Content Area</td>\r\n        <td>block_3_layout_2</td>\r\n        <td>7</td>\r\n    </tr>\r\n    <tr>\r\n        <td>7.</td>\r\n        <td>Brands</td>\r\n        <td>Shop by Brand</td>\r\n        <td>Main Content Area</td>\r\n        <td>N/A</td>\r\n        <td>6</td>\r\n    </tr>\r\n    </tbody>\r\n</table>\r\n\r\n\r\n<h3><em>Static blocks Lingerie layout 2</em></h3>\r\n\r\n<table class=\"data-table data-table-indent\">\r\n    <thead>\r\n    <tr>\r\n        <th>#</th>\r\n        <th>Block Title</th>\r\n        <th>Identifier</th>\r\n        <th>Content</th>\r\n    </tr>\r\n    </thead>\r\n    <tbody>\r\n    <tr>\r\n        <td>1.</td>\r\n        <td>block_4_2_layout_2</td>\r\n        <td>block_4_2_layout_2</td>\r\n        <td>sources\\demo\\static_blocks\\layout_2\\layout_home_2\\block_4_2_layout_2.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>2.</td>\r\n        <td>block_5_2_layout_2</td>\r\n        <td>block_5_2_layout_2</td>\r\n        <td>sources\\demo\\static_blocks\\layout_2\\layout_home_2\\block_5_2_layout_2.phtml</td>\r\n    </tr>\r\n    <tr>\r\n        <td>3.</td>\r\n        <td>block_6_2_layout_2</td>\r\n        <td>block_6_2_layout_2</td>\r\n        <td>sources\\demo\\static_blocks\\layout_2\\layout_home_2\\block_6_2_layout_2.phtml</td>\r\n    </tr>\r\n    </tbody>\r\n</table>\r\n\r\n\r\n\r\n<h3><em>Widgets configuration Lingerie layout 2</em></h3>\r\n\r\n<table class=\"data-table data-table-indent\">\r\n    <thead>\r\n    <tr>\r\n        <th>#</th>\r\n        <th>Widget Name</th>\r\n        <th>Widget type</th>\r\n        <th>Container</th>\r\n        <th>Template / (Static blocks)</th>\r\n        <th>Sort Order</th>\r\n    </tr>\r\n    </thead>\r\n    <tbody>\r\n    <tr>\r\n        <td>1.</td>\r\n        <td>Slider_layout_2</td>\r\n        <td>Template Monster FilmSlider</td>\r\n        <td>After Page Header</td>\r\n        <td>Slider_layout_2</td>\r\n        <td>1</td>\r\n    </tr>\r\n    <tr>\r\n        <td>2.</td>\r\n        <td>block_4_2_layout_2</td>\r\n        <td>CMS Static Block</td>\r\n        <td>Main Content Area</td>\r\n        <td>block_4_2_layout_2</td>\r\n        <td>10</td>\r\n    </tr>\r\n    <tr>\r\n        <td>3.</td>\r\n        <td>New Product</td>\r\n        <td>Featured products</td>\r\n        <td>Main Content Area</td>\r\n        <td>Products Grid</td>\r\n        <td>20</td>\r\n    </tr>\r\n    <tr>\r\n        <td>4.</td>\r\n        <td>block_5_2_layout_2</td>\r\n        <td>CMS Static Block</td>\r\n        <td>Main Content Area</td>\r\n        <td>block_5_2_layout_2</td>\r\n        <td>30</td>\r\n    </tr>\r\n    <tr>\r\n        <td>5.</td>\r\n        <td>From the Blog</td>\r\n        <td>Blog: Latest posts</td>\r\n        <td>Main Content Area</td>\r\n        <td>Post grid</td>\r\n        <td>40</td>\r\n    </tr>\r\n    <tr>\r\n        <td>5.</td>\r\n        <td>block_6_2_layout_2</td>\r\n        <td>CMS Static Block</td>\r\n        <td>Main Content Area</td>\r\n        <td>block_6_2_layout_2</td>\r\n        <td>50</td>\r\n    </tr>\r\n    </tbody>\r\n</table>\r\n\r\n\r\n\r\n\r\n<h3><em>Widgets configuration Lingerie layout 3</em></h3>\r\n\r\n<table class=\"data-table data-table-indent\">\r\n    <thead>\r\n    <tr>\r\n        <th>#</th>\r\n        <th>Widget Name</th>\r\n        <th>Widget type</th>\r\n        <th>Container</th>\r\n        <th>Template / (Static blocks)</th>\r\n        <th>Sort Order</th>\r\n    </tr>\r\n    </thead>\r\n    <tbody>\r\n    <tr>\r\n        <td>1.</td>\r\n        <td>Slider_layout_2 Lingerie lt_2</td>\r\n        <td>Template Monster FilmSlider</td>\r\n        <td>After Page Header</td>\r\n        <td>N/A</td>\r\n        <td>10</td>\r\n    </tr>\r\n    </tbody>\r\n</table>\r\n\r\n','2017-11-25 19:59:07','2017-11-25 19:59:07',1,0,'','','',NULL,NULL,NULL,'');

--
-- Table structure for table `cms_page_store`
--

CREATE TABLE `cms_page_store` (
  `page_id` smallint(6) NOT NULL COMMENT 'Page ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`page_id`,`store_id`),
  KEY `CMS_PAGE_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS Page To Store Linkage Table';

--
-- Dumping data for table `cms_page_store`
--

INSERT INTO `cms_page_store` VALUES (1,0),(2,0),(3,0),(4,0),(5,0),(6,0),(7,0),(9,0),(10,0),(11,0),(12,0),(13,0),(14,0);

--
-- Table structure for table `core_config_data`
--

CREATE TABLE `core_config_data` (
  `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Config Id',
  `scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Config Scope',
  `scope_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Config Scope Id',
  `path` varchar(255) NOT NULL DEFAULT 'general' COMMENT 'Config Path',
  `value` text COMMENT 'Config Value',
  PRIMARY KEY (`config_id`),
  UNIQUE KEY `CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB AUTO_INCREMENT=428 DEFAULT CHARSET=utf8 COMMENT='Config Data';

--
-- Dumping data for table `core_config_data`
--

INSERT INTO `core_config_data` VALUES ('1','default','0','web/seo/use_rewrites','1'),('2','default','0','web/unsecure/base_url','http://192.168.9.43/2016/lingerie_222_007/'),('3','default','0','general/locale/code','en_US'),('4','default','0','general/locale/timezone','UTC'),('5','default','0','currency/options/base','USD'),('6','default','0','currency/options/default','USD'),('7','default','0','currency/options/allow','USD'),('8','default','0','general/region/display_all','1'),('9','default','0','general/region/state_required','AT,BR,CA,CH,EE,ES,FI,HR,LT,LV,RO,US'),('10','default','0','catalog/category/root_id','2'),('11','default','0','design/theme/theme_id','4'),('12','default','0','design/pagination/pagination_frame','5'),('13','default','0','design/pagination/pagination_frame_skip',NULL),('14','default','0','design/pagination/anchor_text_for_previous',NULL),('15','default','0','design/pagination/anchor_text_for_next',NULL),('16','default','0','design/head/default_title','Magento Commerce'),('17','default','0','design/head/title_prefix',NULL),('18','default','0','design/head/title_suffix',NULL),('19','default','0','design/head/default_description',NULL),('20','default','0','design/head/default_keywords',NULL),('21','default','0','design/head/includes',NULL),('22','default','0','design/head/demonotice','0'),('23','default','0','design/header/logo_width',NULL),('24','default','0','design/header/logo_height',NULL),('25','default','0','design/header/logo_alt',NULL),('26','default','0','design/header/welcome','Default welcome msg!'),('27','default','0','design/footer/copyright','Copyright © 2013-2017 Magento, Inc. All rights reserved.'),('28','default','0','design/footer/absolute_footer',NULL),('29','default','0','design/search_engine_robots/default_robots','INDEX,FOLLOW'),('30','default','0','design/search_engine_robots/custom_instructions',NULL),('31','default','0','design/watermark/image_size',NULL),('32','default','0','design/watermark/image_imageOpacity',NULL),('33','default','0','design/watermark/image_position','stretch'),('34','default','0','design/watermark/small_image_size',NULL),('35','default','0','design/watermark/small_image_imageOpacity',NULL),('36','default','0','design/watermark/small_image_position','stretch'),('37','default','0','design/watermark/thumbnail_size',NULL),('38','default','0','design/watermark/thumbnail_imageOpacity',NULL),('39','default','0','design/watermark/thumbnail_position','stretch'),('40','default','0','design/email/logo_alt',NULL),('41','default','0','design/email/logo_width',NULL),('42','default','0','design/email/logo_height',NULL),('43','default','0','design/email/header_template','design_email_header_template'),('44','default','0','design/email/footer_template','design_email_footer_template'),('45','default','0','design/watermark/swatch_image_size',NULL),('46','default','0','design/watermark/swatch_image_imageOpacity',NULL),('47','default','0','design/watermark/swatch_image_position','stretch'),('48','default','0','cms/wysiwyg/enabled','hidden'),('49','default','0','cms/wysiwyg/use_static_urls_in_catalog','0'),('50','default','0','cataloginventory/options/stock_threshold_qty','1000'),('51','default','0','cataloginventory/item_options/auto_return','0'),('52','default','0','catalog/frontend/list_allow_all','0'),('53','default','0','catalog/frontend/flat_catalog_category','1'),('54','default','0','catalog/frontend/flat_catalog_product','1'),('55','default','0','catalog/productalert_cron/frequency','D'),('56','default','0','crontab/default/jobs/catalog_product_alert/schedule/cron_expr','0 0 * * *'),('57','default','0','crontab/default/jobs/catalog_product_alert/run/model',NULL),('58','default','0','catalog/productalert_cron/time','00,00,00'),('59','default','0','catalog/productalert_cron/error_email',NULL),('60','default','0','catalog/product_video/youtube_api_key','AIzaSyCIMveVYEZDh6Ok-cmppYaU7m14gz_qadE'),('61','default','0','catalog/price/scope','0'),('62','default','0','catalog/downloadable/shareable','0'),('63','default','0','catalog/downloadable/content_disposition','inline'),('64','default','0','catalog/custom_options/use_calendar','0'),('65','default','0','catalog/custom_options/year_range',','),('66','default','0','catalog/placeholder/image_placeholder',NULL),('67','default','0','catalog/placeholder/small_image_placeholder',NULL),('68','default','0','catalog/placeholder/swatch_image_placeholder',NULL),('69','default','0','catalog/placeholder/thumbnail_placeholder',NULL),('70','default','0','google_map/general/api_key',NULL),('71','default','0','google_map/home/active','0'),('72','default','0','google_map/home/styles','[{\"featureType\":\"water\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#e9e9e9\"},{\"lightness\":17}]},{\"featureType\":\"landscape\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#f5f5f5\"},{\"lightness\":20}]},{\"featureType\":\"road.highway\",\"elementType\":\"geometry.fill\",\"stylers\":[{\"color\":\"#ffffff\"},{\"lightness\":17}]},{\"featureType\":\"road.highway\",\"elementType\":\"geometry.stroke\",\"stylers\":[{\"color\":\"#ffffff\"},{\"lightness\":29},{\"weight\":0.2}]},{\"featureType\":\"road.arterial\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#ffffff\"},{\"lightness\":18}]},{\"featureType\":\"road.local\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#ffffff\"},{\"lightness\":16}]},{\"featureType\":\"poi\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#f5f5f5\"},{\"lightness\":21}]},{\"featureType\":\"poi.park\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#dedede\"},{\"lightness\":21}]},{\"elementType\":\"labels.text.stroke\",\"stylers\":[{\"visibility\":\"on\"},{\"color\":\"#ffffff\"},{\"lightness\":16}]},{\"elementType\":\"labels.text.fill\",\"stylers\":[{\"saturation\":36},{\"color\":\"#333333\"},{\"lightness\":40}]},{\"elementType\":\"labels.icon\",\"stylers\":[{\"visibility\":\"off\"}]},{\"featureType\":\"transit\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#f2f2f2\"},{\"lightness\":19}]},{\"featureType\":\"administrative\",\"elementType\":\"geometry.fill\",\"stylers\":[{\"color\":\"#fefefe\"},{\"lightness\":20}]},{\"featureType\":\"administrative\",\"elementType\":\"geometry.stroke\",\"stylers\":[{\"color\":\"#fefefe\"},{\"lightness\":17},{\"weight\":1.2}]}]'),('73','default','0','google_map/home/markers','{\"_1514217508648_648\":{\"infowindow\":\" Address: Glasgow D04 89GR <br \\/>\\r\\nPhones: 800-2345-6789; 800-2345-6789 \"}}'),('74','default','0','google_map/contacts/active','1'),('75','default','0','google_map/contacts/coordinates','40.5899796,-73.8820439'),('76','default','0','google_map/contacts/zoom','8'),('77','default','0','google_map/contacts/map_type','ROADMAP'),('78','default','0','google_map/contacts/width','100%'),('79','default','0','google_map/contacts/height','725'),('80','default','0','google_map/contacts/styles','[{\"featureType\":\"water\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#e9e9e9\"},{\"lightness\":17}]},{\"featureType\":\"landscape\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#f5f5f5\"},{\"lightness\":20}]},{\"featureType\":\"road.highway\",\"elementType\":\"geometry.fill\",\"stylers\":[{\"color\":\"#ffffff\"},{\"lightness\":17}]},{\"featureType\":\"road.highway\",\"elementType\":\"geometry.stroke\",\"stylers\":[{\"color\":\"#ffffff\"},{\"lightness\":29},{\"weight\":0.2}]},{\"featureType\":\"road.arterial\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#ffffff\"},{\"lightness\":18}]},{\"featureType\":\"road.local\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#ffffff\"},{\"lightness\":16}]},{\"featureType\":\"poi\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#f5f5f5\"},{\"lightness\":21}]},{\"featureType\":\"poi.park\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#dedede\"},{\"lightness\":21}]},{\"elementType\":\"labels.text.stroke\",\"stylers\":[{\"visibility\":\"on\"},{\"color\":\"#ffffff\"},{\"lightness\":16}]},{\"elementType\":\"labels.text.fill\",\"stylers\":[{\"saturation\":36},{\"color\":\"#333333\"},{\"lightness\":40}]},{\"elementType\":\"labels.icon\",\"stylers\":[{\"visibility\":\"off\"}]},{\"featureType\":\"transit\",\"elementType\":\"geometry\",\"stylers\":[{\"color\":\"#f2f2f2\"},{\"lightness\":19}]},{\"featureType\":\"administrative\",\"elementType\":\"geometry.fill\",\"stylers\":[{\"color\":\"#fefefe\"},{\"lightness\":20}]},{\"featureType\":\"administrative\",\"elementType\":\"geometry.stroke\",\"stylers\":[{\"color\":\"#fefefe\"},{\"lightness\":17},{\"weight\":1.2}]}]'),('81','default','0','google_map/contacts/ui','0'),('82','default','0','google_map/contacts/scrollwheel','1'),('83','default','0','google_map/contacts/draggable','1'),('84','default','0','google_map/contacts/markers','{\"_1514217402372_372\":{\"icon\":\"marker.png\",\"coordinates\":\"40.5899796,-73.8820439\",\"infowindow\":\" Address: Glasgow D04 89GR <br \\/>\\r\\nPhones: 800-2345-6789; 800-2345-6789 \"}}'),('85','default','0','google_map/footer/active','0'),('86','default','0','google_map/footer/styles',NULL),('87','default','0','google_map/footer/markers','[]'),('88','default','0','layout_switcher/general/default_theme','base'),('89','default','0','layout_switcher/general/default_homepage','lt_lingerie_1'),('90','default','0','cataloginventory/options/show_out_of_stock','1'),('91','default','0','web/secure/base_url','https://192.168.9.43/2016/lingerie_222_007/'),('92','default','0','web/secure/use_in_frontend',NULL),('93','default','0','web/secure/use_in_adminhtml',NULL),('94','default','0','analytics/subscription/enabled','1'),('95','default','0','crontab/default/jobs/analytics_subscribe/schedule/cron_expr','0 * * * *'),('96','website','0','connector_configuration/transactional_data/order_statuses','canceled,closed,complete,fraud,holded,payment_review,paypal_canceled_reversal,paypal_reversed,pending,pending_payment,pending_paypal,processing'),('97','website','0','connector_configuration/catalog_sync/catalog_type','simple,virtual,downloadable,bundle,grouped,configurable'),('98','website','0','connector_configuration/catalog_sync/catalog_visibility','1,2,3,4'),('99','default','0','site_maintenance/general/active','0'),('100','default','0','site_maintenance/general/title','This Site is Down for Maintenance'),('101','default','0','site_maintenance/general/whitelist',NULL),('102','default','0','site_maintenance/general/background_type','1'),('103','default','0','site_maintenance/general/background_color',NULL),('104','default','0','site_maintenance/general/background_repeat','0'),('105','default','0','site_maintenance/general/background_position','0'),('106','default','0','site_maintenance/general/background_size','0'),('107','default','0','site_maintenance/general/background_attachment','0'),('108','default','0','site_maintenance/general/page_description','We are very sorry for this inconvenience. We are currently working on something new and we will be back soon with awesome new features. Thanks for your patience.'),('109','default','0','site_maintenance/general/logo',NULL),('110','default','0','site_maintenance/general/background_image','default/sm-container-wrapper.jpg'),('111','default','0','site_maintenance/timer/active','1'),('112','default','0','site_maintenance/timer/timer_text',NULL),('113','default','0','site_maintenance/timer/datetime',NULL),('114','default','0','site_maintenance/timer/format','%D days %H:%M:%S'),('115','default','0','site_maintenance/form/active','1'),('116','default','0','site_maintenance/form/title','Get Notified when we launch!'),('117','default','0','site_maintenance/form/text',NULL),('118','default','0','countdown_timer/general/product_page/enabled','1'),('119','default','0','countdown_timer/general/product_page/format','<div>%D<b>:</b><span>Days</span></div>  <div>%H<b>:</b><span>Hrs</span></div>  <div>%M<b>:</b><span>Min</span></div> <div>%S<span>Sec</span></div>'),('120','default','0','countdown_timer/general/product_page/selector','.old-price'),('121','default','0','countdown_timer/general/catalog_page/enabled','1'),('122','default','0','countdown_timer/general/catalog_page/format','<div>%D<b>:</b><span>Days</span></div>  <div>%H<b>:</b><span>Hrs</span></div>  <div>%M<b>:</b><span>Min</span></div> <div>%S<span>Sec</span></div>'),('123','default','0','countdown_timer/general/catalog_page/selector','.product-image-container'),('124','default','0','countdown_timer/general/widget/enabled','1'),('125','default','0','countdown_timer/general/widget/format','<div>%D<b>:</b><span>Days</span></div>  <div>%H<b>:</b><span>Hrs</span></div>  <div>%M<b>:</b><span>Min</span></div> <div>%S<span>Sec</span></div>'),('126','default','0','countdown_timer/general/widget/selector','.product-image-container'),('127','default','0','megamenu/config/megamenu_general_active','1'),('128','default','0','megamenu/config/megamenu_general_show_left','0'),('129','default','0','social_login/general/enabled','1'),('130','default','0','social_login/providers/google/enabled','1'),('131','default','0','social_login/providers/google/client_id','154053089669-tpel9jam14q09pl26t0kiioqme2rlvu1.apps.googleusercontent.com'),('132','default','0','social_login/providers/google/client_secret','8zRhFRrROM-JtylZHtNELXI-'),('133','default','0','social_login/providers/google/sort_order',NULL),('134','default','0','social_login/providers/facebook/enabled','1'),('135','default','0','social_login/providers/facebook/client_id','1610267192629303'),('136','default','0','social_login/providers/facebook/client_secret','0779622354b2f55b622417d5d21f42c8'),('137','default','0','social_login/providers/facebook/sort_order',NULL),('138','default','0','social_login/providers/instagram/enabled','1'),('139','default','0','social_login/providers/instagram/client_id','2d61dbb9c7e648988ba653747485086b'),('140','default','0','social_login/providers/instagram/client_secret','3cb0b0159c534c9c8344e59a49d2f591'),('141','default','0','social_login/providers/instagram/sort_order',NULL),('142','default','0','social_login/providers/twitter/enabled','1'),('143','default','0','social_login/providers/twitter/client_id','719814350782013440'),('144','default','0','social_login/providers/twitter/client_secret','duX39ioDbR7JbjxHocYbA0KrqvxGX3eHogsgnddzUXswUKekPb'),('145','default','0','social_login/providers/twitter/sort_order',NULL),('146','default','0','social_sharing/general/enabled','1'),('147','default','0','social_sharing/general/profile_id',NULL),('148','default','0','social_sharing/look_and_feel/style','style3'),('149','default','0','social_sharing/look_and_feel/custom_button',NULL),('150','default','0','social_sharing/look_and_feel/custom_code',NULL),('151','default','0','social_sharing/custom_metadata/url',NULL),('152','default','0','social_sharing/custom_metadata/title',NULL),('153','default','0','social_sharing/custom_metadata/description',NULL),('154','default','0','social_sharing/custom_service/name',NULL),('155','default','0','social_sharing/custom_service/url',NULL),('156','default','0','social_sharing/custom_service/icon',NULL),('157','default','0','social_sharing/api/exclude_services',NULL),('158','default','0','social_sharing/api/compact_menu_services',NULL),('159','default','0','social_sharing/api/expanded_menu_services',NULL),('160','default','0','social_sharing/api/compact_menu_hover','0'),('161','default','0','social_sharing/api/delay',NULL),('162','default','0','social_sharing/api/compact_menu_direction','0'),('163','default','0','social_sharing/api/new_window','0'),('164','default','0','social_sharing/api/menu_language',NULL),('165','default','0','social_sharing/api/offset_top',NULL),('166','default','0','social_sharing/api/offset_left',NULL),('167','default','0','social_sharing/api/load_addthis_css','0'),('168','default','0','social_sharing/api/track_clickbacks','0'),('169','default','0','social_sharing/api/google_analytics_id',NULL),('170','default','0','ajaxcatalog/general/ajaxcatalog_layer_active','1'),('171','default','0','ajaxcatalog/general/ajaxcatalog_viewmode_active','1'),('172','default','0','ajaxcatalog/general/ajaxcatalog_listorder_active','1'),('173','default','0','ajaxcatalog/general/ajaxcatalog_sortby_active','1'),('174','default','0','ajaxcatalog/general/ajaxcatalog_pagination_active','1'),('175','default','0','ajaxcatalog/general/ajaxcatalog_shownumber_active','1'),('176','default','0','ajaxcatalog/general/ajaxcatalog_show_price_slider','0'),('177','default','0','ajaxcatalog/general/ajaxcatalog_infinite_scroll','0'),('178','default','0','ajaxcatalog/general/ajaxcatalog_attribute_multy','manufacturer,embellishment,bra_type,style,color,brand_id'),('179','default','0','layout_switcher/general/enabled','1'),('180','default','0','layout_switcher/general/frontend_panel','1'),('181','default','0','layout_switcher/general/default_header_layout','header_layout_2'),('182','default','0','layout_switcher/general/default_listing_layout','listing_layout_2'),('183','default','0','layout_switcher/general/default_product_layout','product_layout_2'),('184','default','0','layout_switcher/general/default_footer_layout','footer_layout_2'),('185','default','0','ajaxcompare/config/ajaxcompare_product_active','1'),('186','default','0','ajaxsearch/ajaxsearch/ajaxsearch_default_active','1'),('187','default','0','ajaxsearch/ajaxsearch/ajaxsearch_category_active','1'),('188','default','0','ajaxsearch/ajaxsearch/ajaxsearch_product_active','1'),('189','default','0','ajaxsearch/ajaxsearch/ajaxsearch_default_number','10'),('190','default','0','ajaxsearch/ajaxsearch/ajaxsearch_category_number','10'),('191','default','0','ajaxsearch/ajaxsearch/ajaxsearch_product_number','10'),('192','default','0','tm_blog/general/active','1'),('193','default','0','tm_blog/general/toplink_active','0'),('194','default','0','tm_blog/general/menu_active','1'),('195','default','0','tm_blog/general/title','Blog'),('196','default','0','tm_blog/general/meta_keywords',NULL),('197','default','0','tm_blog/general/meta_description',NULL),('198','default','0','tm_blog/general/route','blog'),('199','default','0','tm_blog/general/limits','3/6/9'),('200','default','0','tm_blog/general/list_layout',NULL),('201','default','0','tm_blog/general/post_layout',NULL),('202','default','0','tm_blog/general/recaptcha','0'),('203','default','0','tm_blog/general/data_format','M d, Y'),('204','default','0','tm_blog/post_view/related_posts/enabled','1'),('205','default','0','tm_blog/post_view/related_posts/posts_number','5'),('206','default','0','tm_blog/post_view/related_posts/layout_view','0'),('207','default','0','tm_blog/post_view/related_posts/posts_number_per_view','4'),('208','default','0','tm_blog/post_view/related_products/enabled','1'),('209','default','0','tm_blog/post_view/related_products/products_number','5'),('210','default','0','tm_blog/post_view/related_products/products_number_per_view','3'),('211','default','0','tm_blog/post_view/related_products/show_links','1'),('212','default','0','tm_blog/sidebar/show_categories','0'),('213','default','0','tm_blog/sidebar/show_posts','0'),('214','default','0','tm_blog/sidebar/show_comments','0'),('215','default','0','tm_blog/social_sharing/general/enabled','1'),('216','default','0','tm_blog/social_sharing/general/profile_id',NULL),('217','default','0','tm_blog/social_sharing/look_and_feel/style','style1'),('218','default','0','tm_blog/social_sharing/look_and_feel/custom_button',NULL),('219','default','0','tm_blog/social_sharing/look_and_feel/custom_code',NULL),('220','default','0','tm_blog/social_sharing/custom_metadata/url',NULL),('221','default','0','tm_blog/social_sharing/custom_metadata/title',NULL),('222','default','0','tm_blog/social_sharing/custom_metadata/description',NULL),('223','default','0','tm_blog/social_sharing/custom_service/name',NULL),('224','default','0','tm_blog/social_sharing/custom_service/url',NULL),('225','default','0','tm_blog/social_sharing/custom_service/icon',NULL),('226','default','0','tm_blog/social_sharing/api/exclude_services',NULL),('227','default','0','tm_blog/social_sharing/api/compact_menu_services',NULL),('228','default','0','tm_blog/social_sharing/api/expanded_menu_services',NULL),('229','default','0','tm_blog/social_sharing/api/compact_menu_hover','0'),('230','default','0','tm_blog/social_sharing/api/delay',NULL),('231','default','0','tm_blog/social_sharing/api/compact_menu_direction','0'),('232','default','0','tm_blog/social_sharing/api/new_window','0'),('233','default','0','tm_blog/social_sharing/api/menu_language',NULL),('234','default','0','tm_blog/social_sharing/api/offset_top',NULL),('235','default','0','tm_blog/social_sharing/api/offset_left',NULL),('236','default','0','tm_blog/social_sharing/api/load_addthis_css','0'),('237','default','0','tm_blog/social_sharing/api/track_clickbacks','0'),('238','default','0','tm_blog/social_sharing/api/google_analytics_id',NULL),('239','default','0','newsletter_popup/general/enabled','1'),('240','default','0','newsletter_popup/general/show_on_startup','1'),('241','default','0','newsletter_popup/general/show_on_footer','0'),('242','default','0','newsletter_popup/general/title','Get the latest news  <br />delivered daily.'),('243','default','0','newsletter_popup/general/content','Give us your email and you will be daily updated\r\nwith the latest events, in detail.'),('244','default','0','newsletter_popup/general/submit_button','Subscribe'),('245','default','0','newsletter_popup/general/cancel_button',NULL),('246','default','0','newsletter_popup/general/popup_width','810'),('247','default','0','newsletter_popup/general/show_subscription_link_in_footer','1'),('248','default','0','newsletter_popup/general/footer_link_text','Newsletter Subscription'),('249','default','0','newsletter_popup/general/popup_show_delay','0'),('250','default','0','newsletter_popup/general/button_color','#000000'),('251','default','0','newsletter_popup/general/button_hover_color','#947272'),('252','default','0','newsletter_popup/general/custom_css_class',NULL),('253','default','0','newsletter_popup/social/enabled_all','0'),('254','default','0','newsletter_popup/social/facebook_settings/icon_background','#4e69a2'),('255','default','0','newsletter_popup/social/facebook_settings/icon_color','#ffffff'),('256','default','0','newsletter_popup/social/facebook_settings/icon_background_hover','#4e69a2'),('257','default','0','newsletter_popup/social/facebook_settings/icon_hover_color','#ffffff'),('258','default','0','newsletter_popup/social/twitter_settings/icon_background','#1da1f2'),('259','default','0','newsletter_popup/social/twitter_settings/icon_color','#ffffff'),('260','default','0','newsletter_popup/social/twitter_settings/icon_background_hover','#1da1f2'),('261','default','0','newsletter_popup/social/twitter_settings/icon_hover_color','#ffffff'),('262','default','0','newsletter_popup/social/linkedin_settings/icon_background','#0083be'),('263','default','0','newsletter_popup/social/linkedin_settings/icon_color','#ffffff'),('264','default','0','newsletter_popup/social/linkedin_settings/icon_background_hover','#0083be'),('265','default','0','newsletter_popup/social/linkedin_settings/icon_hover_color','#ffffff'),('266','default','0','newsletter_popup/social/google_settings/icon_background','#e02f2f'),('267','default','0','newsletter_popup/social/google_settings/icon_color','#ffffff'),('268','default','0','newsletter_popup/social/google_settings/icon_background_hover','#e02f2f'),('269','default','0','newsletter_popup/social/google_settings/icon_hover_color','#ffffff'),('270','default','0','newsletter_popup/social/youtube_settings/icon_background','#e02f2f'),('271','default','0','newsletter_popup/social/youtube_settings/icon_color','#ffffff'),('272','default','0','newsletter_popup/social/youtube_settings/icon_background_hover','#e02f2f'),('273','default','0','newsletter_popup/social/youtube_settings/icon_hover_color','#ffffff'),('274','default','0','newsletter_popup/social/vimeo_settings/icon_background','#20b9eb'),('275','default','0','newsletter_popup/social/vimeo_settings/icon_color','#ffffff'),('276','default','0','newsletter_popup/social/vimeo_settings/icon_background_hover','#20b9eb'),('277','default','0','newsletter_popup/social/vimeo_settings/icon_hover_color','#ffffff'),('278','default','0','newsletter_popup/social/pinterest_settings/icon_background','#e02f2f'),('279','default','0','newsletter_popup/social/pinterest_settings/icon_color','#ffffff'),('280','default','0','newsletter_popup/social/pinterest_settings/icon_background_hover','#e02f2f'),('281','default','0','newsletter_popup/social/pinterest_settings/icon_hover_color','#ffffff'),('282','default','0','newsletter_popup/social/instagram_settings/icon_background','#316699'),('283','default','0','newsletter_popup/social/instagram_settings/icon_color','#ffffff'),('284','default','0','newsletter_popup/social/instagram_settings/icon_background_hover','#316699'),('285','default','0','newsletter_popup/social/instagram_settings/icon_hover_color','#ffffff'),('286','default','0','newsletter_popup/social/foursquare_settings/icon_background','#f94877'),('287','default','0','newsletter_popup/social/foursquare_settings/icon_color','#ffffff'),('288','default','0','newsletter_popup/social/foursquare_settings/icon_background_hover','#f94877'),('289','default','0','newsletter_popup/social/foursquare_settings/icon_hover_color','#ffffff'),('290','default','0','newsletter_popup/social/tumblr_settings/icon_background','#44556b'),('291','default','0','newsletter_popup/social/tumblr_settings/icon_color','#ffffff'),('292','default','0','newsletter_popup/social/tumblr_settings/icon_background_hover','#44556b'),('293','default','0','newsletter_popup/social/tumblr_settings/icon_hover_color','#ffffff'),('294','default','0','newsletter_popup/social/rss_settings/icon_background','#eb7b1d'),('295','default','0','newsletter_popup/social/rss_settings/icon_color','#ffffff'),('296','default','0','newsletter_popup/social/rss_settings/icon_background_hover','#eb7b1d'),('297','default','0','newsletter_popup/social/rss_settings/icon_hover_color','#ffffff'),('298','default','0','shopbybrand/general/enabled','1'),('299','default','0','shopbybrand/general/show_top_link','0'),('300','default','0','shopbybrand/general/number','5'),('301','default','0','shopbybrand/brand/layout','2columns-left'),('302','default','0','shopbybrand/brand/show_banner','0'),('303','default','0','shopbybrand/brand/show_logo','1'),('304','default','0','shopbybrand/brand/show_description','1'),('305','default','0','shopbybrand/product/show_name','1'),('306','default','0','shopbybrand/product/show_logo','1'),('307','default','0','shopbybrand/product/brand_logo_width','200'),('308','default','0','shopbybrand/product/selector','.product-info-price'),('309','default','0','shopbybrand/brand_listing/show_name','1'),('310','default','0','shopbybrand/brand_listing/show_logo','1'),('311','default','0','shopbybrand/brand_listing/show_short_description','0'),('312','default','0','shopbybrand/brand_sidebar/enabled','0'),('313','default','0','shopbybrand/brand_sidebar/show_name','1'),('314','default','0','shopbybrand/brand_sidebar/show_logo','1'),('315','default','0','shopbybrand/brand_sidebar/quantity','8'),('316','default','0','catalog/seo/category_canonical_tag','1'),('317','default','0','catalog/seo/product_canonical_tag','1'),('318','default','0','catalog/placeholder/on_hover_placeholder',NULL),('319','default','0','theme_options/general/logo_width','264'),('320','default','0','theme_options/general/logo_height','52'),('321','default','0','theme_options/general/logo_alt',NULL),('322','default','0','theme_options/general/welcome_text',NULL),('323','default','0','theme_options/general/site_title',NULL),('324','default','0','theme_options/general/description',NULL),('325','default','0','theme_options/general/keywords',NULL),('326','default','0','theme_options/general/copyright','&copy; <script type=\"text/javascript\">var mdate = new Date(); document.write(mdate.getFullYear());</script> Magento Demo Store. All Rights Reserved.'),('327','default','0','theme_options/general/import_file',',,,4,0,,,,4,0,,,,4,0'),('328','default','0','theme_options/general/logo','default/logo_2.png'),('329','default','0','theme_options/general/favicon','default/favicon.ico'),('330','default','0','theme_options/category_page/grid_view/hover_type','0'),('331','default','0','theme_options/category_page/grid_view/image_width','477'),('332','default','0','theme_options/category_page/grid_view/image_height','609'),('333','default','0','theme_options/category_page/grid_view/image_aspect_ratio','0'),('334','default','0','theme_options/category_page/grid_view/show_swatches','1'),('335','default','0','theme_options/category_page/grid_view/show_compare','1'),('336','default','0','theme_options/category_page/grid_view/show_wishlist','1'),('337','default','0','theme_options/category_page/grid_view/show_reviews','1'),('338','default','0','theme_options/category_page/grid_view/show_desc','0'),('339','default','0','theme_options/category_page/list_view/image_width',NULL),('340','default','0','theme_options/category_page/list_view/image_height',NULL),('341','default','0','theme_options/category_page/list_view/image_aspect_ratio','1'),('342','default','0','theme_options/category_page/list_view/show_swatches','1'),('343','default','0','theme_options/category_page/list_view/show_compare','1'),('344','default','0','theme_options/category_page/list_view/show_wishlist','1'),('345','default','0','theme_options/category_page/list_view/show_reviews','1'),('346','default','0','theme_options/category_page/list_view/show_desc','1'),('347','default','0','theme_options/product_page/general/show_stock','1'),('348','default','0','theme_options/product_page/general/show_sku','1'),('349','default','0','theme_options/product_page/general/show_compare','1'),('350','default','0','theme_options/product_page/general/show_wishlist','1'),('351','default','0','theme_options/product_page/general/show_email_to_friend','1'),('352','default','0','theme_options/product_page/general/show_reviews','1'),('353','default','0','theme_options/product_page/general/show_short_desc','1'),('354','default','0','theme_options/product_page/general/show_related','1'),('355','default','0','theme_options/product_page/general/related_limit',NULL),('356','default','0','theme_options/product_page/general/related_image_width','470'),('357','default','0','theme_options/product_page/general/related_image_height','609'),('358','default','0','theme_options/product_page/general/show_related_checkbox','1'),('359','default','0','theme_options/product_page/general/show_upsell','1'),('360','default','0','theme_options/product_page/general/upsell_limit',NULL),('361','default','0','theme_options/product_page/general/upsell_image_width','470'),('362','default','0','theme_options/product_page/general/upsell_image_height','609'),('363','default','0','theme_options/product_page/tabs/description','1'),('364','default','0','theme_options/product_page/tabs/description_tab_title',NULL),('365','default','0','theme_options/product_page/tabs/additional','1'),('366','default','0','theme_options/product_page/tabs/additional_tab_title',NULL),('367','default','0','theme_options/product_page/tabs/review','1'),('368','default','0','theme_options/product_page/tabs/review_tab_title',NULL),('369','default','0','theme_options/product_page/gallery/image_width','624'),('370','default','0','theme_options/product_page/gallery/image_height','726'),('371','default','0','theme_options/product_page/gallery/image_zoom','0'),('372','default','0','theme_options/header/social/show_social','0'),('373','default','0','theme_options/header/social/image_icon','[]'),('374','default','0','theme_options/header/social/font_icon','[]'),('375','default','0','theme_options/footer/social/show_social','0'),('376','default','0','theme_options/footer/social/image_icon','[]'),('377','default','0','theme_options/footer/social/font_icon','[]'),('378','default','0','theme_options/sidebar/wishlist','1'),('379','default','0','theme_options/sidebar/compare','1'),('380','default','0','theme_options/sidebar/recently_viewed','1'),('381','default','0','theme_options/sidebar/recently_compared','1'),('382','default','0','theme_options/sidebar/orders','1'),('383','websites','1','theme_options/general/color_scheme','theme_color_1'),('384','websites','1','theme_options/color_settings/theme_color_1/body_background_image_active','0'),('385','websites','1','theme_options/color_settings/theme_color_1/footer_background_image_active','0'),('386','websites','1','theme_options/sample_data_installer/cms_pages/override','0'),('387','websites','1','theme_options/sample_data_installer/cms_blocks/override','0'),('388','websites','1','theme_options/sample_data_installer/widgets/override','0'),('389','default','0','instagram_feed/general/enabled','1'),('390','default','0','instagram_feed/general/client_id','65465654646545'),('391','default','0','instagram_feed/homepage/enabled','1'),('392','default','0','instagram_feed/homepage/widget_block_title','sdfgfdgfdgd'),('393','default','0','instagram_feed/homepage/position','content'),('394','default','0','instagram_feed/homepage/show_by','user'),('395','default','0','instagram_feed/homepage/user','demomagento'),('396','default','0','instagram_feed/homepage/count','6'),('397','default','0','instagram_feed/homepage/format','thumbnail'),('398','default','0','instagram_feed/homepage/image_width','200'),('399','default','0','instagram_feed/category/enabled','1'),('400','default','0','instagram_feed/product/enabled','1'),('401','default','0','instagram_feed/cmspage/enabled','1'),('402','default','0','instagram_feed/advanced/selector_left','.sidebar-main'),('403','default','0','instagram_feed/advanced/selector_right','.sidebar-additional'),('404','default','0','instagram_feed/advanced/selector_content','.columns'),('405','default','0','instagram_feed/advanced/selector_footer','.footer.content'),('406','default','0','instagram_feed/category/widget_block_title',NULL),('407','default','0','instagram_feed/category/position','left'),('408','default','0','instagram_feed/category/show_by','user'),('409','default','0','instagram_feed/category/user','demomagento'),('410','default','0','instagram_feed/category/count','6'),('411','default','0','instagram_feed/category/format','thumbnail'),('412','default','0','instagram_feed/category/image_width',NULL),('413','default','0','instagram_feed/product/widget_block_title',NULL),('414','default','0','instagram_feed/product/position','left'),('415','default','0','instagram_feed/product/show_by','user'),('416','default','0','instagram_feed/product/user','demomagento'),('417','default','0','instagram_feed/product/count','6'),('418','default','0','instagram_feed/product/format','thumbnail'),('419','default','0','instagram_feed/product/image_width',NULL),('420','default','0','instagram_feed/cmspage/widget_block_title',NULL),('421','default','0','instagram_feed/cmspage/position','left'),('422','default','0','instagram_feed/cmspage/show_by','user'),('423','default','0','instagram_feed/cmspage/user','demomagento'),('424','default','0','instagram_feed/cmspage/count','6'),('425','default','0','instagram_feed/cmspage/format','thumbnail'),('426','default','0','instagram_feed/cmspage/image_width',NULL),('427','default','0','tm_amp/general/enabled','1');

--
-- Table structure for table `cron_schedule`
--

CREATE TABLE `cron_schedule` (
  `schedule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Schedule Id',
  `job_code` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Job Code',
  `status` varchar(7) NOT NULL DEFAULT 'pending' COMMENT 'Status',
  `messages` text COMMENT 'Messages',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `scheduled_at` timestamp NULL DEFAULT NULL COMMENT 'Scheduled At',
  `executed_at` timestamp NULL DEFAULT NULL COMMENT 'Executed At',
  `finished_at` timestamp NULL DEFAULT NULL COMMENT 'Finished At',
  PRIMARY KEY (`schedule_id`),
  KEY `CRON_SCHEDULE_JOB_CODE` (`job_code`),
  KEY `CRON_SCHEDULE_SCHEDULED_AT_STATUS` (`scheduled_at`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cron Schedule';

--
-- Table structure for table `customer_address_entity`
--

CREATE TABLE `customer_address_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment Id',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Active',
  `city` varchar(255) NOT NULL COMMENT 'City',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `country_id` varchar(255) NOT NULL COMMENT 'Country',
  `fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
  `firstname` varchar(255) NOT NULL COMMENT 'First Name',
  `lastname` varchar(255) NOT NULL COMMENT 'Last Name',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name',
  `postcode` varchar(255) DEFAULT NULL COMMENT 'Zip/Postal Code',
  `prefix` varchar(40) DEFAULT NULL COMMENT 'Name Prefix',
  `region` varchar(255) DEFAULT NULL COMMENT 'State/Province',
  `region_id` int(10) unsigned DEFAULT NULL COMMENT 'State/Province',
  `street` text NOT NULL COMMENT 'Street Address',
  `suffix` varchar(40) DEFAULT NULL COMMENT 'Name Suffix',
  `telephone` varchar(255) NOT NULL COMMENT 'Phone Number',
  `vat_id` varchar(255) DEFAULT NULL COMMENT 'VAT number',
  `vat_is_valid` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validity',
  `vat_request_date` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request date',
  `vat_request_id` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request ID',
  `vat_request_success` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validation request success',
  PRIMARY KEY (`entity_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity';

--
-- Table structure for table `customer_address_entity_datetime`
--

CREATE TABLE `customer_address_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Datetime';

--
-- Table structure for table `customer_address_entity_decimal`
--

CREATE TABLE `customer_address_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Decimal';

--
-- Table structure for table `customer_address_entity_int`
--

CREATE TABLE `customer_address_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Int';

--
-- Table structure for table `customer_address_entity_text`
--

CREATE TABLE `customer_address_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Text';

--
-- Table structure for table `customer_address_entity_varchar`
--

CREATE TABLE `customer_address_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Varchar';

--
-- Table structure for table `customer_eav_attribute`
--

CREATE TABLE `customer_eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  `is_visible` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Visible',
  `input_filter` varchar(255) DEFAULT NULL COMMENT 'Input Filter',
  `multiline_count` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Multiline Count',
  `validate_rules` text COMMENT 'Validate Rules',
  `is_system` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is System',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `data_model` varchar(255) DEFAULT NULL COMMENT 'Data Model',
  `is_used_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used in Grid',
  `is_visible_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible in Grid',
  `is_filterable_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Filterable in Grid',
  `is_searchable_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Searchable in Grid',
  PRIMARY KEY (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Eav Attribute';

--
-- Dumping data for table `customer_eav_attribute`
--

INSERT INTO `customer_eav_attribute` VALUES (1,1,NULL,0,NULL,1,'10',NULL,1,1,1,0),(2,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(3,1,NULL,0,NULL,1,'20',NULL,1,1,0,1),(4,0,NULL,0,NULL,0,'30',NULL,0,0,0,0),(5,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'40',NULL,0,0,0,0),(6,0,NULL,0,NULL,0,'50',NULL,0,0,0,0),(7,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'60',NULL,0,0,0,0),(8,0,NULL,0,NULL,0,'70',NULL,0,0,0,0),(9,1,NULL,0,'{\"input_validation\":\"email\"}',1,'80',NULL,1,1,1,1),(10,1,NULL,0,NULL,1,'25',NULL,1,1,1,0),(11,0,'date',0,'{\"input_validation\":\"date\"}',0,'90',NULL,1,1,1,0),(12,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(13,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(14,0,NULL,0,'{\"input_validation\":\"date\"}',1,'0',NULL,0,0,0,0),(15,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(16,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(17,0,NULL,0,'{\"max_text_length\":255}',0,'100',NULL,1,1,0,1),(18,0,NULL,0,NULL,1,'0',NULL,1,1,1,0),(19,0,NULL,0,NULL,0,'0',NULL,1,1,1,0),(20,0,NULL,0,'[]',0,'110',NULL,1,1,1,0),(21,1,NULL,0,NULL,1,'28',NULL,0,0,0,0),(22,0,NULL,0,NULL,0,'10',NULL,0,0,0,0),(23,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'20',NULL,1,0,0,1),(24,0,NULL,0,NULL,0,'30',NULL,0,0,0,0),(25,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'40',NULL,1,0,0,1),(26,0,NULL,0,NULL,0,'50',NULL,0,0,0,0),(27,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'60',NULL,1,0,0,1),(28,1,NULL,2,'{\"max_text_length\":255,\"min_text_length\":1}',1,'70',NULL,1,0,0,1),(29,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'80',NULL,1,0,0,1),(30,1,NULL,0,NULL,1,'90',NULL,1,1,1,0),(31,1,NULL,0,NULL,1,'100',NULL,1,1,0,1),(32,1,NULL,0,NULL,1,'100',NULL,0,0,0,0),(33,1,NULL,0,'[]',1,'110','Magento\\Customer\\Model\\Attribute\\Data\\Postcode',1,1,1,1),(34,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,'120',NULL,1,1,1,1),(35,0,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',0,'130',NULL,1,0,0,1),(36,1,NULL,0,NULL,1,'140',NULL,0,0,0,0),(37,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(38,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(39,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(40,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(41,0,NULL,0,NULL,0,'0',NULL,0,0,0,0),(42,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(43,0,NULL,0,NULL,1,'0',NULL,0,0,0,0),(44,0,NULL,0,NULL,1,'0',NULL,0,0,0,0);

--
-- Table structure for table `customer_eav_attribute_website`
--

CREATE TABLE `customer_eav_attribute_website` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `is_visible` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Visible',
  `is_required` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Required',
  `default_value` text COMMENT 'Default Value',
  `multiline_count` smallint(5) unsigned DEFAULT NULL COMMENT 'Multiline Count',
  PRIMARY KEY (`attribute_id`,`website_id`),
  KEY `CUSTOMER_EAV_ATTRIBUTE_WEBSITE_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Eav Attribute Website';

--
-- Dumping data for table `customer_eav_attribute_website`
--

INSERT INTO `customer_eav_attribute_website` VALUES (1,1,NULL,NULL,NULL,NULL),(3,1,NULL,NULL,NULL,NULL),(9,1,NULL,NULL,NULL,NULL),(10,1,NULL,NULL,NULL,NULL),(11,1,NULL,NULL,NULL,NULL),(17,1,NULL,NULL,NULL,NULL),(18,1,NULL,NULL,NULL,NULL),(19,1,NULL,NULL,NULL,NULL),(20,1,NULL,NULL,NULL,NULL),(21,1,NULL,NULL,NULL,NULL),(23,1,NULL,NULL,NULL,NULL),(25,1,NULL,NULL,NULL,NULL),(27,1,NULL,NULL,NULL,NULL),(28,1,NULL,NULL,NULL,NULL),(29,1,NULL,NULL,NULL,NULL),(30,1,NULL,NULL,NULL,NULL),(31,1,NULL,NULL,NULL,NULL),(32,1,NULL,NULL,NULL,NULL),(33,1,NULL,NULL,NULL,NULL),(34,1,NULL,NULL,NULL,NULL),(35,1,NULL,NULL,NULL,NULL),(36,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customer_entity_datetime`
--

CREATE TABLE `customer_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Datetime';

--
-- Table structure for table `customer_entity_decimal`
--

CREATE TABLE `customer_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Decimal';

--
-- Table structure for table `customer_entity_int`
--

CREATE TABLE `customer_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Int';

--
-- Table structure for table `customer_entity_text`
--

CREATE TABLE `customer_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Text';

--
-- Table structure for table `customer_entity_varchar`
--

CREATE TABLE `customer_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Varchar';

--
-- Table structure for table `customer_form_attribute`
--

CREATE TABLE `customer_form_attribute` (
  `form_code` varchar(32) NOT NULL COMMENT 'Form Code',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  PRIMARY KEY (`form_code`,`attribute_id`),
  KEY `CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Form Attribute';

--
-- Dumping data for table `customer_form_attribute`
--

INSERT INTO `customer_form_attribute` VALUES ('adminhtml_customer',1),('adminhtml_customer',3),('adminhtml_customer',4),('customer_account_create',4),('customer_account_edit',4),('adminhtml_customer',5),('customer_account_create',5),('customer_account_edit',5),('adminhtml_customer',6),('customer_account_create',6),('customer_account_edit',6),('adminhtml_customer',7),('customer_account_create',7),('customer_account_edit',7),('adminhtml_customer',8),('customer_account_create',8),('customer_account_edit',8),('adminhtml_checkout',9),('adminhtml_customer',9),('customer_account_create',9),('customer_account_edit',9),('adminhtml_checkout',10),('adminhtml_customer',10),('adminhtml_checkout',11),('adminhtml_customer',11),('customer_account_create',11),('customer_account_edit',11),('adminhtml_checkout',17),('adminhtml_customer',17),('customer_account_create',17),('customer_account_edit',17),('adminhtml_customer',19),('customer_account_create',19),('customer_account_edit',19),('adminhtml_checkout',20),('adminhtml_customer',20),('customer_account_create',20),('customer_account_edit',20),('adminhtml_customer',21),('adminhtml_customer_address',22),('customer_address_edit',22),('customer_register_address',22),('adminhtml_customer_address',23),('customer_address_edit',23),('customer_register_address',23),('adminhtml_customer_address',24),('customer_address_edit',24),('customer_register_address',24),('adminhtml_customer_address',25),('customer_address_edit',25),('customer_register_address',25),('adminhtml_customer_address',26),('customer_address_edit',26),('customer_register_address',26),('adminhtml_customer_address',27),('customer_address_edit',27),('customer_register_address',27),('adminhtml_customer_address',28),('customer_address_edit',28),('customer_register_address',28),('adminhtml_customer_address',29),('customer_address_edit',29),('customer_register_address',29),('adminhtml_customer_address',30),('customer_address_edit',30),('customer_register_address',30),('adminhtml_customer_address',31),('customer_address_edit',31),('customer_register_address',31),('adminhtml_customer_address',32),('customer_address_edit',32),('customer_register_address',32),('adminhtml_customer_address',33),('customer_address_edit',33),('customer_register_address',33),('adminhtml_customer_address',34),('customer_address_edit',34),('customer_register_address',34),('adminhtml_customer_address',35),('customer_address_edit',35),('customer_register_address',35),('adminhtml_customer_address',36),('customer_address_edit',36),('customer_register_address',36);

--
-- Table structure for table `customer_grid_flat`
--

CREATE TABLE `customer_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `name` text COMMENT 'Name',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `group_id` int(11) DEFAULT NULL COMMENT 'Group_id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created_at',
  `website_id` int(11) DEFAULT NULL COMMENT 'Website_id',
  `confirmation` varchar(255) DEFAULT NULL COMMENT 'Confirmation',
  `created_in` text COMMENT 'Created_in',
  `dob` date DEFAULT NULL COMMENT 'Dob',
  `gender` int(11) DEFAULT NULL COMMENT 'Gender',
  `taxvat` varchar(255) DEFAULT NULL COMMENT 'Taxvat',
  `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock_expires',
  `shipping_full` text COMMENT 'Shipping_full',
  `billing_full` text COMMENT 'Billing_full',
  `billing_firstname` varchar(255) DEFAULT NULL COMMENT 'Billing_firstname',
  `billing_lastname` varchar(255) DEFAULT NULL COMMENT 'Billing_lastname',
  `billing_telephone` varchar(255) DEFAULT NULL COMMENT 'Billing_telephone',
  `billing_postcode` varchar(255) DEFAULT NULL COMMENT 'Billing_postcode',
  `billing_country_id` varchar(255) DEFAULT NULL COMMENT 'Billing_country_id',
  `billing_region` varchar(255) DEFAULT NULL COMMENT 'Billing_region',
  `billing_street` varchar(255) DEFAULT NULL COMMENT 'Billing_street',
  `billing_city` varchar(255) DEFAULT NULL COMMENT 'Billing_city',
  `billing_fax` varchar(255) DEFAULT NULL COMMENT 'Billing_fax',
  `billing_vat_id` varchar(255) DEFAULT NULL COMMENT 'Billing_vat_id',
  `billing_company` varchar(255) DEFAULT NULL COMMENT 'Billing_company',
  PRIMARY KEY (`entity_id`),
  KEY `CUSTOMER_GRID_FLAT_GROUP_ID` (`group_id`),
  KEY `CUSTOMER_GRID_FLAT_CREATED_AT` (`created_at`),
  KEY `CUSTOMER_GRID_FLAT_WEBSITE_ID` (`website_id`),
  KEY `CUSTOMER_GRID_FLAT_CONFIRMATION` (`confirmation`),
  KEY `CUSTOMER_GRID_FLAT_DOB` (`dob`),
  KEY `CUSTOMER_GRID_FLAT_GENDER` (`gender`),
  KEY `CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID` (`billing_country_id`),
  FULLTEXT KEY `FTI_8746F705702DD5F6D45B8C7CE7FE9F2F` (`name`,`email`,`created_in`,`taxvat`,`shipping_full`,`billing_full`,`billing_firstname`,`billing_lastname`,`billing_telephone`,`billing_postcode`,`billing_region`,`billing_city`,`billing_fax`,`billing_company`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='customer_grid_flat';

--
-- Dumping data for table `customer_grid_flat`
--

INSERT INTO `customer_grid_flat` VALUES ('1','Anika Land','anika@gmail.com','1','2017-11-26 09:40:36','1',NULL,'Layout 1',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customer_group`
--

CREATE TABLE `customer_group` (
  `customer_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_group_code` varchar(32) NOT NULL COMMENT 'Customer Group Code',
  `tax_class_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tax Class Id',
  PRIMARY KEY (`customer_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Customer Group';

--
-- Dumping data for table `customer_group`
--

INSERT INTO `customer_group` VALUES ('0','NOT LOGGED IN','3'),('1','General','3'),('2','Wholesale','3'),('3','Retailer','3');

--
-- Table structure for table `customer_log`
--

CREATE TABLE `customer_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `customer_id` int(11) NOT NULL COMMENT 'Customer ID',
  `last_login_at` timestamp NULL DEFAULT NULL COMMENT 'Last Login Time',
  `last_logout_at` timestamp NULL DEFAULT NULL COMMENT 'Last Logout Time',
  PRIMARY KEY (`log_id`),
  UNIQUE KEY `CUSTOMER_LOG_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Customer Log Table';

--
-- Dumping data for table `customer_log`
--

INSERT INTO `customer_log` VALUES ('1','1','2017-11-26 09:40:38',NULL);

--
-- Table structure for table `design_change`
--

CREATE TABLE `design_change` (
  `design_change_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Design Change Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `design` varchar(255) DEFAULT NULL COMMENT 'Design',
  `date_from` date DEFAULT NULL COMMENT 'First Date of Design Activity',
  `date_to` date DEFAULT NULL COMMENT 'Last Date of Design Activity',
  PRIMARY KEY (`design_change_id`),
  KEY `DESIGN_CHANGE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Design Changes';

--
-- Table structure for table `design_config_grid_flat`
--

CREATE TABLE `design_config_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `store_website_id` int(11) DEFAULT NULL COMMENT 'Store_website_id',
  `store_group_id` int(11) DEFAULT NULL COMMENT 'Store_group_id',
  `store_id` int(11) DEFAULT NULL COMMENT 'Store_id',
  `theme_theme_id` varchar(255) DEFAULT NULL COMMENT 'Theme_theme_id',
  PRIMARY KEY (`entity_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`),
  FULLTEXT KEY `DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='design_config_grid_flat';

--
-- Dumping data for table `design_config_grid_flat`
--

INSERT INTO `design_config_grid_flat` VALUES ('0',NULL,NULL,NULL,'4'),('1','1',NULL,NULL,'4'),('2','1','1','1','4'),('3','1','1','2','4'),('4','1','1','3','4');

--
-- Table structure for table `directory_country`
--

CREATE TABLE `directory_country` (
  `country_id` varchar(2) NOT NULL COMMENT 'Country Id in ISO-2',
  `iso2_code` varchar(2) DEFAULT NULL COMMENT 'Country ISO-2 format',
  `iso3_code` varchar(3) DEFAULT NULL COMMENT 'Country ISO-3',
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country';

--
-- Dumping data for table `directory_country`
--

INSERT INTO `directory_country` VALUES ('AD','AD','AND'),('AE','AE','ARE'),('AF','AF','AFG'),('AG','AG','ATG'),('AI','AI','AIA'),('AL','AL','ALB'),('AM','AM','ARM'),('AN','AN','ANT'),('AO','AO','AGO'),('AQ','AQ','ATA'),('AR','AR','ARG'),('AS','AS','ASM'),('AT','AT','AUT'),('AU','AU','AUS'),('AW','AW','ABW'),('AX','AX','ALA'),('AZ','AZ','AZE'),('BA','BA','BIH'),('BB','BB','BRB'),('BD','BD','BGD'),('BE','BE','BEL'),('BF','BF','BFA'),('BG','BG','BGR'),('BH','BH','BHR'),('BI','BI','BDI'),('BJ','BJ','BEN'),('BL','BL','BLM'),('BM','BM','BMU'),('BN','BN','BRN'),('BO','BO','BOL'),('BR','BR','BRA'),('BS','BS','BHS'),('BT','BT','BTN'),('BV','BV','BVT'),('BW','BW','BWA'),('BY','BY','BLR'),('BZ','BZ','BLZ'),('CA','CA','CAN'),('CC','CC','CCK'),('CD','CD','COD'),('CF','CF','CAF'),('CG','CG','COG'),('CH','CH','CHE'),('CI','CI','CIV'),('CK','CK','COK'),('CL','CL','CHL'),('CM','CM','CMR'),('CN','CN','CHN'),('CO','CO','COL'),('CR','CR','CRI'),('CU','CU','CUB'),('CV','CV','CPV'),('CX','CX','CXR'),('CY','CY','CYP'),('CZ','CZ','CZE'),('DE','DE','DEU'),('DJ','DJ','DJI'),('DK','DK','DNK'),('DM','DM','DMA'),('DO','DO','DOM'),('DZ','DZ','DZA'),('EC','EC','ECU'),('EE','EE','EST'),('EG','EG','EGY'),('EH','EH','ESH'),('ER','ER','ERI'),('ES','ES','ESP'),('ET','ET','ETH'),('FI','FI','FIN'),('FJ','FJ','FJI'),('FK','FK','FLK'),('FM','FM','FSM'),('FO','FO','FRO'),('FR','FR','FRA'),('GA','GA','GAB'),('GB','GB','GBR'),('GD','GD','GRD'),('GE','GE','GEO'),('GF','GF','GUF'),('GG','GG','GGY'),('GH','GH','GHA'),('GI','GI','GIB'),('GL','GL','GRL'),('GM','GM','GMB'),('GN','GN','GIN'),('GP','GP','GLP'),('GQ','GQ','GNQ'),('GR','GR','GRC'),('GS','GS','SGS'),('GT','GT','GTM'),('GU','GU','GUM'),('GW','GW','GNB'),('GY','GY','GUY'),('HK','HK','HKG'),('HM','HM','HMD'),('HN','HN','HND'),('HR','HR','HRV'),('HT','HT','HTI'),('HU','HU','HUN'),('ID','ID','IDN'),('IE','IE','IRL'),('IL','IL','ISR'),('IM','IM','IMN'),('IN','IN','IND'),('IO','IO','IOT'),('IQ','IQ','IRQ'),('IR','IR','IRN'),('IS','IS','ISL'),('IT','IT','ITA'),('JE','JE','JEY'),('JM','JM','JAM'),('JO','JO','JOR'),('JP','JP','JPN'),('KE','KE','KEN'),('KG','KG','KGZ'),('KH','KH','KHM'),('KI','KI','KIR'),('KM','KM','COM'),('KN','KN','KNA'),('KP','KP','PRK'),('KR','KR','KOR'),('KW','KW','KWT'),('KY','KY','CYM'),('KZ','KZ','KAZ'),('LA','LA','LAO'),('LB','LB','LBN'),('LC','LC','LCA'),('LI','LI','LIE'),('LK','LK','LKA'),('LR','LR','LBR'),('LS','LS','LSO'),('LT','LT','LTU'),('LU','LU','LUX'),('LV','LV','LVA'),('LY','LY','LBY'),('MA','MA','MAR'),('MC','MC','MCO'),('MD','MD','MDA'),('ME','ME','MNE'),('MF','MF','MAF'),('MG','MG','MDG'),('MH','MH','MHL'),('MK','MK','MKD'),('ML','ML','MLI'),('MM','MM','MMR'),('MN','MN','MNG'),('MO','MO','MAC'),('MP','MP','MNP'),('MQ','MQ','MTQ'),('MR','MR','MRT'),('MS','MS','MSR'),('MT','MT','MLT'),('MU','MU','MUS'),('MV','MV','MDV'),('MW','MW','MWI'),('MX','MX','MEX'),('MY','MY','MYS'),('MZ','MZ','MOZ'),('NA','NA','NAM'),('NC','NC','NCL'),('NE','NE','NER'),('NF','NF','NFK'),('NG','NG','NGA'),('NI','NI','NIC'),('NL','NL','NLD'),('NO','NO','NOR'),('NP','NP','NPL'),('NR','NR','NRU'),('NU','NU','NIU'),('NZ','NZ','NZL'),('OM','OM','OMN'),('PA','PA','PAN'),('PE','PE','PER'),('PF','PF','PYF'),('PG','PG','PNG'),('PH','PH','PHL'),('PK','PK','PAK'),('PL','PL','POL'),('PM','PM','SPM'),('PN','PN','PCN'),('PS','PS','PSE'),('PT','PT','PRT'),('PW','PW','PLW'),('PY','PY','PRY'),('QA','QA','QAT'),('RE','RE','REU'),('RO','RO','ROU'),('RS','RS','SRB'),('RU','RU','RUS'),('RW','RW','RWA'),('SA','SA','SAU'),('SB','SB','SLB'),('SC','SC','SYC'),('SD','SD','SDN'),('SE','SE','SWE'),('SG','SG','SGP'),('SH','SH','SHN'),('SI','SI','SVN'),('SJ','SJ','SJM'),('SK','SK','SVK'),('SL','SL','SLE'),('SM','SM','SMR'),('SN','SN','SEN'),('SO','SO','SOM'),('SR','SR','SUR'),('ST','ST','STP'),('SV','SV','SLV'),('SY','SY','SYR'),('SZ','SZ','SWZ'),('TC','TC','TCA'),('TD','TD','TCD'),('TF','TF','ATF'),('TG','TG','TGO'),('TH','TH','THA'),('TJ','TJ','TJK'),('TK','TK','TKL'),('TL','TL','TLS'),('TM','TM','TKM'),('TN','TN','TUN'),('TO','TO','TON'),('TR','TR','TUR'),('TT','TT','TTO'),('TV','TV','TUV'),('TW','TW','TWN'),('TZ','TZ','TZA'),('UA','UA','UKR'),('UG','UG','UGA'),('UM','UM','UMI'),('US','US','USA'),('UY','UY','URY'),('UZ','UZ','UZB'),('VA','VA','VAT'),('VC','VC','VCT'),('VE','VE','VEN'),('VG','VG','VGB'),('VI','VI','VIR'),('VN','VN','VNM'),('VU','VU','VUT'),('WF','WF','WLF'),('WS','WS','WSM'),('YE','YE','YEM'),('YT','YT','MYT'),('ZA','ZA','ZAF'),('ZM','ZM','ZMB'),('ZW','ZW','ZWE');

--
-- Table structure for table `directory_country_format`
--

CREATE TABLE `directory_country_format` (
  `country_format_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Country Format Id',
  `country_id` varchar(2) DEFAULT NULL COMMENT 'Country Id in ISO-2',
  `type` varchar(30) DEFAULT NULL COMMENT 'Country Format Type',
  `format` text NOT NULL COMMENT 'Country Format',
  PRIMARY KEY (`country_format_id`),
  UNIQUE KEY `DIRECTORY_COUNTRY_FORMAT_COUNTRY_ID_TYPE` (`country_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country Format';

--
-- Table structure for table `directory_country_region`
--

CREATE TABLE `directory_country_region` (
  `region_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Region Id',
  `country_id` varchar(4) NOT NULL DEFAULT '0' COMMENT 'Country Id in ISO-2',
  `code` varchar(32) DEFAULT NULL COMMENT 'Region code',
  `default_name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
  PRIMARY KEY (`region_id`),
  KEY `DIRECTORY_COUNTRY_REGION_COUNTRY_ID` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=533 DEFAULT CHARSET=utf8 COMMENT='Directory Country Region';

--
-- Dumping data for table `directory_country_region`
--

INSERT INTO `directory_country_region` VALUES ('1','US','AL','Alabama'),('2','US','AK','Alaska'),('3','US','AS','American Samoa'),('4','US','AZ','Arizona'),('5','US','AR','Arkansas'),('6','US','AE','Armed Forces Africa'),('7','US','AA','Armed Forces Americas'),('8','US','AE','Armed Forces Canada'),('9','US','AE','Armed Forces Europe'),('10','US','AE','Armed Forces Middle East'),('11','US','AP','Armed Forces Pacific'),('12','US','CA','California'),('13','US','CO','Colorado'),('14','US','CT','Connecticut'),('15','US','DE','Delaware'),('16','US','DC','District of Columbia'),('17','US','FM','Federated States Of Micronesia'),('18','US','FL','Florida'),('19','US','GA','Georgia'),('20','US','GU','Guam'),('21','US','HI','Hawaii'),('22','US','ID','Idaho'),('23','US','IL','Illinois'),('24','US','IN','Indiana'),('25','US','IA','Iowa'),('26','US','KS','Kansas'),('27','US','KY','Kentucky'),('28','US','LA','Louisiana'),('29','US','ME','Maine'),('30','US','MH','Marshall Islands'),('31','US','MD','Maryland'),('32','US','MA','Massachusetts'),('33','US','MI','Michigan'),('34','US','MN','Minnesota'),('35','US','MS','Mississippi'),('36','US','MO','Missouri'),('37','US','MT','Montana'),('38','US','NE','Nebraska'),('39','US','NV','Nevada'),('40','US','NH','New Hampshire'),('41','US','NJ','New Jersey'),('42','US','NM','New Mexico'),('43','US','NY','New York'),('44','US','NC','North Carolina'),('45','US','ND','North Dakota'),('46','US','MP','Northern Mariana Islands'),('47','US','OH','Ohio'),('48','US','OK','Oklahoma'),('49','US','OR','Oregon'),('50','US','PW','Palau'),('51','US','PA','Pennsylvania'),('52','US','PR','Puerto Rico'),('53','US','RI','Rhode Island'),('54','US','SC','South Carolina'),('55','US','SD','South Dakota'),('56','US','TN','Tennessee'),('57','US','TX','Texas'),('58','US','UT','Utah'),('59','US','VT','Vermont'),('60','US','VI','Virgin Islands'),('61','US','VA','Virginia'),('62','US','WA','Washington'),('63','US','WV','West Virginia'),('64','US','WI','Wisconsin'),('65','US','WY','Wyoming'),('66','CA','AB','Alberta'),('67','CA','BC','British Columbia'),('68','CA','MB','Manitoba'),('69','CA','NL','Newfoundland and Labrador'),('70','CA','NB','New Brunswick'),('71','CA','NS','Nova Scotia'),('72','CA','NT','Northwest Territories'),('73','CA','NU','Nunavut'),('74','CA','ON','Ontario'),('75','CA','PE','Prince Edward Island'),('76','CA','QC','Quebec'),('77','CA','SK','Saskatchewan'),('78','CA','YT','Yukon Territory'),('79','DE','NDS','Niedersachsen'),('80','DE','BAW','Baden-Württemberg'),('81','DE','BAY','Bayern'),('82','DE','BER','Berlin'),('83','DE','BRG','Brandenburg'),('84','DE','BRE','Bremen'),('85','DE','HAM','Hamburg'),('86','DE','HES','Hessen'),('87','DE','MEC','Mecklenburg-Vorpommern'),('88','DE','NRW','Nordrhein-Westfalen'),('89','DE','RHE','Rheinland-Pfalz'),('90','DE','SAR','Saarland'),('91','DE','SAS','Sachsen'),('92','DE','SAC','Sachsen-Anhalt'),('93','DE','SCN','Schleswig-Holstein'),('94','DE','THE','Thüringen'),('95','AT','WI','Wien'),('96','AT','NO','Niederösterreich'),('97','AT','OO','Oberösterreich'),('98','AT','SB','Salzburg'),('99','AT','KN','Kärnten'),('100','AT','ST','Steiermark'),('101','AT','TI','Tirol'),('102','AT','BL','Burgenland'),('103','AT','VB','Vorarlberg'),('104','CH','AG','Aargau'),('105','CH','AI','Appenzell Innerrhoden'),('106','CH','AR','Appenzell Ausserrhoden'),('107','CH','BE','Bern'),('108','CH','BL','Basel-Landschaft'),('109','CH','BS','Basel-Stadt'),('110','CH','FR','Freiburg'),('111','CH','GE','Genf'),('112','CH','GL','Glarus'),('113','CH','GR','Graubünden'),('114','CH','JU','Jura'),('115','CH','LU','Luzern'),('116','CH','NE','Neuenburg'),('117','CH','NW','Nidwalden'),('118','CH','OW','Obwalden'),('119','CH','SG','St. Gallen'),('120','CH','SH','Schaffhausen'),('121','CH','SO','Solothurn'),('122','CH','SZ','Schwyz'),('123','CH','TG','Thurgau'),('124','CH','TI','Tessin'),('125','CH','UR','Uri'),('126','CH','VD','Waadt'),('127','CH','VS','Wallis'),('128','CH','ZG','Zug'),('129','CH','ZH','Zürich'),('130','ES','A Coruсa','A Coruña'),('131','ES','Alava','Alava'),('132','ES','Albacete','Albacete'),('133','ES','Alicante','Alicante'),('134','ES','Almeria','Almeria'),('135','ES','Asturias','Asturias'),('136','ES','Avila','Avila'),('137','ES','Badajoz','Badajoz'),('138','ES','Baleares','Baleares'),('139','ES','Barcelona','Barcelona'),('140','ES','Burgos','Burgos'),('141','ES','Caceres','Caceres'),('142','ES','Cadiz','Cadiz'),('143','ES','Cantabria','Cantabria'),('144','ES','Castellon','Castellon'),('145','ES','Ceuta','Ceuta'),('146','ES','Ciudad Real','Ciudad Real'),('147','ES','Cordoba','Cordoba'),('148','ES','Cuenca','Cuenca'),('149','ES','Girona','Girona'),('150','ES','Granada','Granada'),('151','ES','Guadalajara','Guadalajara'),('152','ES','Guipuzcoa','Guipuzcoa'),('153','ES','Huelva','Huelva'),('154','ES','Huesca','Huesca'),('155','ES','Jaen','Jaen'),('156','ES','La Rioja','La Rioja'),('157','ES','Las Palmas','Las Palmas'),('158','ES','Leon','Leon'),('159','ES','Lleida','Lleida'),('160','ES','Lugo','Lugo'),('161','ES','Madrid','Madrid'),('162','ES','Malaga','Malaga'),('163','ES','Melilla','Melilla'),('164','ES','Murcia','Murcia'),('165','ES','Navarra','Navarra'),('166','ES','Ourense','Ourense'),('167','ES','Palencia','Palencia'),('168','ES','Pontevedra','Pontevedra'),('169','ES','Salamanca','Salamanca'),('170','ES','Santa Cruz de Tenerife','Santa Cruz de Tenerife'),('171','ES','Segovia','Segovia'),('172','ES','Sevilla','Sevilla'),('173','ES','Soria','Soria'),('174','ES','Tarragona','Tarragona'),('175','ES','Teruel','Teruel'),('176','ES','Toledo','Toledo'),('177','ES','Valencia','Valencia'),('178','ES','Valladolid','Valladolid'),('179','ES','Vizcaya','Vizcaya'),('180','ES','Zamora','Zamora'),('181','ES','Zaragoza','Zaragoza'),('182','FR','1','Ain'),('183','FR','2','Aisne'),('184','FR','3','Allier'),('185','FR','4','Alpes-de-Haute-Provence'),('186','FR','5','Hautes-Alpes'),('187','FR','6','Alpes-Maritimes'),('188','FR','7','Ardèche'),('189','FR','8','Ardennes'),('190','FR','9','Ariège'),('191','FR','10','Aube'),('192','FR','11','Aude'),('193','FR','12','Aveyron'),('194','FR','13','Bouches-du-Rhône'),('195','FR','14','Calvados'),('196','FR','15','Cantal'),('197','FR','16','Charente'),('198','FR','17','Charente-Maritime'),('199','FR','18','Cher'),('200','FR','19','Corrèze'),('201','FR','2A','Corse-du-Sud'),('202','FR','2B','Haute-Corse'),('203','FR','21','Côte-d\'Or'),('204','FR','22','Côtes-d\'Armor'),('205','FR','23','Creuse'),('206','FR','24','Dordogne'),('207','FR','25','Doubs'),('208','FR','26','Drôme'),('209','FR','27','Eure'),('210','FR','28','Eure-et-Loir'),('211','FR','29','Finistère'),('212','FR','30','Gard'),('213','FR','31','Haute-Garonne'),('214','FR','32','Gers'),('215','FR','33','Gironde'),('216','FR','34','Hérault'),('217','FR','35','Ille-et-Vilaine'),('218','FR','36','Indre'),('219','FR','37','Indre-et-Loire'),('220','FR','38','Isère'),('221','FR','39','Jura'),('222','FR','40','Landes'),('223','FR','41','Loir-et-Cher'),('224','FR','42','Loire'),('225','FR','43','Haute-Loire'),('226','FR','44','Loire-Atlantique'),('227','FR','45','Loiret'),('228','FR','46','Lot'),('229','FR','47','Lot-et-Garonne'),('230','FR','48','Lozère'),('231','FR','49','Maine-et-Loire'),('232','FR','50','Manche'),('233','FR','51','Marne'),('234','FR','52','Haute-Marne'),('235','FR','53','Mayenne'),('236','FR','54','Meurthe-et-Moselle'),('237','FR','55','Meuse'),('238','FR','56','Morbihan'),('239','FR','57','Moselle'),('240','FR','58','Nièvre'),('241','FR','59','Nord'),('242','FR','60','Oise'),('243','FR','61','Orne'),('244','FR','62','Pas-de-Calais'),('245','FR','63','Puy-de-Dôme'),('246','FR','64','Pyrénées-Atlantiques'),('247','FR','65','Hautes-Pyrénées'),('248','FR','66','Pyrénées-Orientales'),('249','FR','67','Bas-Rhin'),('250','FR','68','Haut-Rhin'),('251','FR','69','Rhône'),('252','FR','70','Haute-Saône'),('253','FR','71','Saône-et-Loire'),('254','FR','72','Sarthe'),('255','FR','73','Savoie'),('256','FR','74','Haute-Savoie'),('257','FR','75','Paris'),('258','FR','76','Seine-Maritime'),('259','FR','77','Seine-et-Marne'),('260','FR','78','Yvelines'),('261','FR','79','Deux-Sèvres'),('262','FR','80','Somme'),('263','FR','81','Tarn'),('264','FR','82','Tarn-et-Garonne'),('265','FR','83','Var'),('266','FR','84','Vaucluse'),('267','FR','85','Vendée'),('268','FR','86','Vienne'),('269','FR','87','Haute-Vienne'),('270','FR','88','Vosges'),('271','FR','89','Yonne'),('272','FR','90','Territoire-de-Belfort'),('273','FR','91','Essonne'),('274','FR','92','Hauts-de-Seine'),('275','FR','93','Seine-Saint-Denis'),('276','FR','94','Val-de-Marne'),('277','FR','95','Val-d\'Oise'),('278','RO','AB','Alba'),('279','RO','AR','Arad'),('280','RO','AG','Argeş'),('281','RO','BC','Bacău'),('282','RO','BH','Bihor'),('283','RO','BN','Bistriţa-Năsăud'),('284','RO','BT','Botoşani'),('285','RO','BV','Braşov'),('286','RO','BR','Brăila'),('287','RO','B','Bucureşti'),('288','RO','BZ','Buzău'),('289','RO','CS','Caraş-Severin'),('290','RO','CL','Călăraşi'),('291','RO','CJ','Cluj'),('292','RO','CT','Constanţa'),('293','RO','CV','Covasna'),('294','RO','DB','Dâmboviţa'),('295','RO','DJ','Dolj'),('296','RO','GL','Galaţi'),('297','RO','GR','Giurgiu'),('298','RO','GJ','Gorj'),('299','RO','HR','Harghita'),('300','RO','HD','Hunedoara'),('301','RO','IL','Ialomiţa'),('302','RO','IS','Iaşi'),('303','RO','IF','Ilfov'),('304','RO','MM','Maramureş'),('305','RO','MH','Mehedinţi'),('306','RO','MS','Mureş'),('307','RO','NT','Neamţ'),('308','RO','OT','Olt'),('309','RO','PH','Prahova'),('310','RO','SM','Satu-Mare'),('311','RO','SJ','Sălaj'),('312','RO','SB','Sibiu'),('313','RO','SV','Suceava'),('314','RO','TR','Teleorman'),('315','RO','TM','Timiş'),('316','RO','TL','Tulcea'),('317','RO','VS','Vaslui'),('318','RO','VL','Vâlcea'),('319','RO','VN','Vrancea'),('320','FI','Lappi','Lappi'),('321','FI','Pohjois-Pohjanmaa','Pohjois-Pohjanmaa'),('322','FI','Kainuu','Kainuu'),('323','FI','Pohjois-Karjala','Pohjois-Karjala'),('324','FI','Pohjois-Savo','Pohjois-Savo'),('325','FI','Etelä-Savo','Etelä-Savo'),('326','FI','Etelä-Pohjanmaa','Etelä-Pohjanmaa'),('327','FI','Pohjanmaa','Pohjanmaa'),('328','FI','Pirkanmaa','Pirkanmaa'),('329','FI','Satakunta','Satakunta'),('330','FI','Keski-Pohjanmaa','Keski-Pohjanmaa'),('331','FI','Keski-Suomi','Keski-Suomi'),('332','FI','Varsinais-Suomi','Varsinais-Suomi'),('333','FI','Etelä-Karjala','Etelä-Karjala'),('334','FI','Päijät-Häme','Päijät-Häme'),('335','FI','Kanta-Häme','Kanta-Häme'),('336','FI','Uusimaa','Uusimaa'),('337','FI','Itä-Uusimaa','Itä-Uusimaa'),('338','FI','Kymenlaakso','Kymenlaakso'),('339','FI','Ahvenanmaa','Ahvenanmaa'),('340','EE','EE-37','Harjumaa'),('341','EE','EE-39','Hiiumaa'),('342','EE','EE-44','Ida-Virumaa'),('343','EE','EE-49','Jõgevamaa'),('344','EE','EE-51','Järvamaa'),('345','EE','EE-57','Läänemaa'),('346','EE','EE-59','Lääne-Virumaa'),('347','EE','EE-65','Põlvamaa'),('348','EE','EE-67','Pärnumaa'),('349','EE','EE-70','Raplamaa'),('350','EE','EE-74','Saaremaa'),('351','EE','EE-78','Tartumaa'),('352','EE','EE-82','Valgamaa'),('353','EE','EE-84','Viljandimaa'),('354','EE','EE-86','Võrumaa'),('355','LV','LV-DGV','Daugavpils'),('356','LV','LV-JEL','Jelgava'),('357','LV','Jēkabpils','Jēkabpils'),('358','LV','LV-JUR','Jūrmala'),('359','LV','LV-LPX','Liepāja'),('360','LV','LV-LE','Liepājas novads'),('361','LV','LV-REZ','Rēzekne'),('362','LV','LV-RIX','Rīga'),('363','LV','LV-RI','Rīgas novads'),('364','LV','Valmiera','Valmiera'),('365','LV','LV-VEN','Ventspils'),('366','LV','Aglonas novads','Aglonas novads'),('367','LV','LV-AI','Aizkraukles novads'),('368','LV','Aizputes novads','Aizputes novads'),('369','LV','Aknīstes novads','Aknīstes novads'),('370','LV','Alojas novads','Alojas novads'),('371','LV','Alsungas novads','Alsungas novads'),('372','LV','LV-AL','Alūksnes novads'),('373','LV','Amatas novads','Amatas novads'),('374','LV','Apes novads','Apes novads'),('375','LV','Auces novads','Auces novads'),('376','LV','Babītes novads','Babītes novads'),('377','LV','Baldones novads','Baldones novads'),('378','LV','Baltinavas novads','Baltinavas novads'),('379','LV','LV-BL','Balvu novads'),('380','LV','LV-BU','Bauskas novads'),('381','LV','Beverīnas novads','Beverīnas novads'),('382','LV','Brocēnu novads','Brocēnu novads'),('383','LV','Burtnieku novads','Burtnieku novads'),('384','LV','Carnikavas novads','Carnikavas novads'),('385','LV','Cesvaines novads','Cesvaines novads'),('386','LV','Ciblas novads','Ciblas novads'),('387','LV','LV-CE','Cēsu novads'),('388','LV','Dagdas novads','Dagdas novads'),('389','LV','LV-DA','Daugavpils novads'),('390','LV','LV-DO','Dobeles novads'),('391','LV','Dundagas novads','Dundagas novads'),('392','LV','Durbes novads','Durbes novads'),('393','LV','Engures novads','Engures novads'),('394','LV','Garkalnes novads','Garkalnes novads'),('395','LV','Grobiņas novads','Grobiņas novads'),('396','LV','LV-GU','Gulbenes novads'),('397','LV','Iecavas novads','Iecavas novads'),('398','LV','Ikšķiles novads','Ikšķiles novads'),('399','LV','Ilūkstes novads','Ilūkstes novads'),('400','LV','Inčukalna novads','Inčukalna novads'),('401','LV','Jaunjelgavas novads','Jaunjelgavas novads'),('402','LV','Jaunpiebalgas novads','Jaunpiebalgas novads'),('403','LV','Jaunpils novads','Jaunpils novads'),('404','LV','LV-JL','Jelgavas novads'),('405','LV','LV-JK','Jēkabpils novads'),('406','LV','Kandavas novads','Kandavas novads'),('407','LV','Kokneses novads','Kokneses novads'),('408','LV','Krimuldas novads','Krimuldas novads'),('409','LV','Krustpils novads','Krustpils novads'),('410','LV','LV-KR','Krāslavas novads'),('411','LV','LV-KU','Kuldīgas novads'),('412','LV','Kārsavas novads','Kārsavas novads'),('413','LV','Lielvārdes novads','Lielvārdes novads'),('414','LV','LV-LM','Limbažu novads'),('415','LV','Lubānas novads','Lubānas novads'),('416','LV','LV-LU','Ludzas novads'),('417','LV','Līgatnes novads','Līgatnes novads'),('418','LV','Līvānu novads','Līvānu novads'),('419','LV','LV-MA','Madonas novads'),('420','LV','Mazsalacas novads','Mazsalacas novads'),('421','LV','Mālpils novads','Mālpils novads'),('422','LV','Mārupes novads','Mārupes novads'),('423','LV','Naukšēnu novads','Naukšēnu novads'),('424','LV','Neretas novads','Neretas novads'),('425','LV','Nīcas novads','Nīcas novads'),('426','LV','LV-OG','Ogres novads'),('427','LV','Olaines novads','Olaines novads'),('428','LV','Ozolnieku novads','Ozolnieku novads'),('429','LV','LV-PR','Preiļu novads'),('430','LV','Priekules novads','Priekules novads'),('431','LV','Priekuļu novads','Priekuļu novads'),('432','LV','Pārgaujas novads','Pārgaujas novads'),('433','LV','Pāvilostas novads','Pāvilostas novads'),('434','LV','Pļaviņu novads','Pļaviņu novads'),('435','LV','Raunas novads','Raunas novads'),('436','LV','Riebiņu novads','Riebiņu novads'),('437','LV','Rojas novads','Rojas novads'),('438','LV','Ropažu novads','Ropažu novads'),('439','LV','Rucavas novads','Rucavas novads'),('440','LV','Rugāju novads','Rugāju novads'),('441','LV','Rundāles novads','Rundāles novads'),('442','LV','LV-RE','Rēzeknes novads'),('443','LV','Rūjienas novads','Rūjienas novads'),('444','LV','Salacgrīvas novads','Salacgrīvas novads'),('445','LV','Salas novads','Salas novads'),('446','LV','Salaspils novads','Salaspils novads'),('447','LV','LV-SA','Saldus novads'),('448','LV','Saulkrastu novads','Saulkrastu novads'),('449','LV','Siguldas novads','Siguldas novads'),('450','LV','Skrundas novads','Skrundas novads'),('451','LV','Skrīveru novads','Skrīveru novads'),('452','LV','Smiltenes novads','Smiltenes novads'),('453','LV','Stopiņu novads','Stopiņu novads'),('454','LV','Strenču novads','Strenču novads'),('455','LV','Sējas novads','Sējas novads'),('456','LV','LV-TA','Talsu novads'),('457','LV','LV-TU','Tukuma novads'),('458','LV','Tērvetes novads','Tērvetes novads'),('459','LV','Vaiņodes novads','Vaiņodes novads'),('460','LV','LV-VK','Valkas novads'),('461','LV','LV-VM','Valmieras novads'),('462','LV','Varakļānu novads','Varakļānu novads'),('463','LV','Vecpiebalgas novads','Vecpiebalgas novads'),('464','LV','Vecumnieku novads','Vecumnieku novads'),('465','LV','LV-VE','Ventspils novads'),('466','LV','Viesītes novads','Viesītes novads'),('467','LV','Viļakas novads','Viļakas novads'),('468','LV','Viļānu novads','Viļānu novads'),('469','LV','Vārkavas novads','Vārkavas novads'),('470','LV','Zilupes novads','Zilupes novads'),('471','LV','Ādažu novads','Ādažu novads'),('472','LV','Ērgļu novads','Ērgļu novads'),('473','LV','Ķeguma novads','Ķeguma novads'),('474','LV','Ķekavas novads','Ķekavas novads'),('475','LT','LT-AL','Alytaus Apskritis'),('476','LT','LT-KU','Kauno Apskritis'),('477','LT','LT-KL','Klaipėdos Apskritis'),('478','LT','LT-MR','Marijampolės Apskritis'),('479','LT','LT-PN','Panevėžio Apskritis'),('480','LT','LT-SA','Šiaulių Apskritis'),('481','LT','LT-TA','Tauragės Apskritis'),('482','LT','LT-TE','Telšių Apskritis'),('483','LT','LT-UT','Utenos Apskritis'),('484','LT','LT-VL','Vilniaus Apskritis'),('485','BR','AC','Acre'),('486','BR','AL','Alagoas'),('487','BR','AP','Amapá'),('488','BR','AM','Amazonas'),('489','BR','BA','Bahia'),('490','BR','CE','Ceará'),('491','BR','ES','Espírito Santo'),('492','BR','GO','Goiás'),('493','BR','MA','Maranhão'),('494','BR','MT','Mato Grosso'),('495','BR','MS','Mato Grosso do Sul'),('496','BR','MG','Minas Gerais'),('497','BR','PA','Pará'),('498','BR','PB','Paraíba'),('499','BR','PR','Paraná'),('500','BR','PE','Pernambuco'),('501','BR','PI','Piauí'),('502','BR','RJ','Rio de Janeiro'),('503','BR','RN','Rio Grande do Norte'),('504','BR','RS','Rio Grande do Sul'),('505','BR','RO','Rondônia'),('506','BR','RR','Roraima'),('507','BR','SC','Santa Catarina'),('508','BR','SP','São Paulo'),('509','BR','SE','Sergipe'),('510','BR','TO','Tocantins'),('511','BR','DF','Distrito Federal'),('512','HR','HR-01','Zagrebačka županija'),('513','HR','HR-02','Krapinsko-zagorska županija'),('514','HR','HR-03','Sisačko-moslavačka županija'),('515','HR','HR-04','Karlovačka županija'),('516','HR','HR-05','Varaždinska županija'),('517','HR','HR-06','Koprivničko-križevačka županija'),('518','HR','HR-07','Bjelovarsko-bilogorska županija'),('519','HR','HR-08','Primorsko-goranska županija'),('520','HR','HR-09','Ličko-senjska županija'),('521','HR','HR-10','Virovitičko-podravska županija'),('522','HR','HR-11','Požeško-slavonska županija'),('523','HR','HR-12','Brodsko-posavska županija'),('524','HR','HR-13','Zadarska županija'),('525','HR','HR-14','Osječko-baranjska županija'),('526','HR','HR-15','Šibensko-kninska županija'),('527','HR','HR-16','Vukovarsko-srijemska županija'),('528','HR','HR-17','Splitsko-dalmatinska županija'),('529','HR','HR-18','Istarska županija'),('530','HR','HR-19','Dubrovačko-neretvanska županija'),('531','HR','HR-20','Međimurska županija'),('532','HR','HR-21','Grad Zagreb');

--
-- Table structure for table `directory_country_region_name`
--

CREATE TABLE `directory_country_region_name` (
  `locale` varchar(8) NOT NULL COMMENT 'Locale',
  `region_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Region Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
  PRIMARY KEY (`locale`,`region_id`),
  KEY `DIRECTORY_COUNTRY_REGION_NAME_REGION_ID` (`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country Region Name';

--
-- Dumping data for table `directory_country_region_name`
--

INSERT INTO `directory_country_region_name` VALUES ('en_US','1','Alabama'),('en_US','2','Alaska'),('en_US','3','American Samoa'),('en_US','4','Arizona'),('en_US','5','Arkansas'),('en_US','6','Armed Forces Africa'),('en_US','7','Armed Forces Americas'),('en_US','8','Armed Forces Canada'),('en_US','9','Armed Forces Europe'),('en_US','10','Armed Forces Middle East'),('en_US','11','Armed Forces Pacific'),('en_US','12','California'),('en_US','13','Colorado'),('en_US','14','Connecticut'),('en_US','15','Delaware'),('en_US','16','District of Columbia'),('en_US','17','Federated States Of Micronesia'),('en_US','18','Florida'),('en_US','19','Georgia'),('en_US','20','Guam'),('en_US','21','Hawaii'),('en_US','22','Idaho'),('en_US','23','Illinois'),('en_US','24','Indiana'),('en_US','25','Iowa'),('en_US','26','Kansas'),('en_US','27','Kentucky'),('en_US','28','Louisiana'),('en_US','29','Maine'),('en_US','30','Marshall Islands'),('en_US','31','Maryland'),('en_US','32','Massachusetts'),('en_US','33','Michigan'),('en_US','34','Minnesota'),('en_US','35','Mississippi'),('en_US','36','Missouri'),('en_US','37','Montana'),('en_US','38','Nebraska'),('en_US','39','Nevada'),('en_US','40','New Hampshire'),('en_US','41','New Jersey'),('en_US','42','New Mexico'),('en_US','43','New York'),('en_US','44','North Carolina'),('en_US','45','North Dakota'),('en_US','46','Northern Mariana Islands'),('en_US','47','Ohio'),('en_US','48','Oklahoma'),('en_US','49','Oregon'),('en_US','50','Palau'),('en_US','51','Pennsylvania'),('en_US','52','Puerto Rico'),('en_US','53','Rhode Island'),('en_US','54','South Carolina'),('en_US','55','South Dakota'),('en_US','56','Tennessee'),('en_US','57','Texas'),('en_US','58','Utah'),('en_US','59','Vermont'),('en_US','60','Virgin Islands'),('en_US','61','Virginia'),('en_US','62','Washington'),('en_US','63','West Virginia'),('en_US','64','Wisconsin'),('en_US','65','Wyoming'),('en_US','66','Alberta'),('en_US','67','British Columbia'),('en_US','68','Manitoba'),('en_US','69','Newfoundland and Labrador'),('en_US','70','New Brunswick'),('en_US','71','Nova Scotia'),('en_US','72','Northwest Territories'),('en_US','73','Nunavut'),('en_US','74','Ontario'),('en_US','75','Prince Edward Island'),('en_US','76','Quebec'),('en_US','77','Saskatchewan'),('en_US','78','Yukon Territory'),('en_US','79','Niedersachsen'),('en_US','80','Baden-Württemberg'),('en_US','81','Bayern'),('en_US','82','Berlin'),('en_US','83','Brandenburg'),('en_US','84','Bremen'),('en_US','85','Hamburg'),('en_US','86','Hessen'),('en_US','87','Mecklenburg-Vorpommern'),('en_US','88','Nordrhein-Westfalen'),('en_US','89','Rheinland-Pfalz'),('en_US','90','Saarland'),('en_US','91','Sachsen'),('en_US','92','Sachsen-Anhalt'),('en_US','93','Schleswig-Holstein'),('en_US','94','Thüringen'),('en_US','95','Wien'),('en_US','96','Niederösterreich'),('en_US','97','Oberösterreich'),('en_US','98','Salzburg'),('en_US','99','Kärnten'),('en_US','100','Steiermark'),('en_US','101','Tirol'),('en_US','102','Burgenland'),('en_US','103','Vorarlberg'),('en_US','104','Aargau'),('en_US','105','Appenzell Innerrhoden'),('en_US','106','Appenzell Ausserrhoden'),('en_US','107','Bern'),('en_US','108','Basel-Landschaft'),('en_US','109','Basel-Stadt'),('en_US','110','Freiburg'),('en_US','111','Genf'),('en_US','112','Glarus'),('en_US','113','Graubünden'),('en_US','114','Jura'),('en_US','115','Luzern'),('en_US','116','Neuenburg'),('en_US','117','Nidwalden'),('en_US','118','Obwalden'),('en_US','119','St. Gallen'),('en_US','120','Schaffhausen'),('en_US','121','Solothurn'),('en_US','122','Schwyz'),('en_US','123','Thurgau'),('en_US','124','Tessin'),('en_US','125','Uri'),('en_US','126','Waadt'),('en_US','127','Wallis'),('en_US','128','Zug'),('en_US','129','Zürich'),('en_US','130','A Coruña'),('en_US','131','Alava'),('en_US','132','Albacete'),('en_US','133','Alicante'),('en_US','134','Almeria'),('en_US','135','Asturias'),('en_US','136','Avila'),('en_US','137','Badajoz'),('en_US','138','Baleares'),('en_US','139','Barcelona'),('en_US','140','Burgos'),('en_US','141','Caceres'),('en_US','142','Cadiz'),('en_US','143','Cantabria'),('en_US','144','Castellon'),('en_US','145','Ceuta'),('en_US','146','Ciudad Real'),('en_US','147','Cordoba'),('en_US','148','Cuenca'),('en_US','149','Girona'),('en_US','150','Granada'),('en_US','151','Guadalajara'),('en_US','152','Guipuzcoa'),('en_US','153','Huelva'),('en_US','154','Huesca'),('en_US','155','Jaen'),('en_US','156','La Rioja'),('en_US','157','Las Palmas'),('en_US','158','Leon'),('en_US','159','Lleida'),('en_US','160','Lugo'),('en_US','161','Madrid'),('en_US','162','Malaga'),('en_US','163','Melilla'),('en_US','164','Murcia'),('en_US','165','Navarra'),('en_US','166','Ourense'),('en_US','167','Palencia'),('en_US','168','Pontevedra'),('en_US','169','Salamanca'),('en_US','170','Santa Cruz de Tenerife'),('en_US','171','Segovia'),('en_US','172','Sevilla'),('en_US','173','Soria'),('en_US','174','Tarragona'),('en_US','175','Teruel'),('en_US','176','Toledo'),('en_US','177','Valencia'),('en_US','178','Valladolid'),('en_US','179','Vizcaya'),('en_US','180','Zamora'),('en_US','181','Zaragoza'),('en_US','182','Ain'),('en_US','183','Aisne'),('en_US','184','Allier'),('en_US','185','Alpes-de-Haute-Provence'),('en_US','186','Hautes-Alpes'),('en_US','187','Alpes-Maritimes'),('en_US','188','Ardèche'),('en_US','189','Ardennes'),('en_US','190','Ariège'),('en_US','191','Aube'),('en_US','192','Aude'),('en_US','193','Aveyron'),('en_US','194','Bouches-du-Rhône'),('en_US','195','Calvados'),('en_US','196','Cantal'),('en_US','197','Charente'),('en_US','198','Charente-Maritime'),('en_US','199','Cher'),('en_US','200','Corrèze'),('en_US','201','Corse-du-Sud'),('en_US','202','Haute-Corse'),('en_US','203','Côte-d\'Or'),('en_US','204','Côtes-d\'Armor'),('en_US','205','Creuse'),('en_US','206','Dordogne'),('en_US','207','Doubs'),('en_US','208','Drôme'),('en_US','209','Eure'),('en_US','210','Eure-et-Loir'),('en_US','211','Finistère'),('en_US','212','Gard'),('en_US','213','Haute-Garonne'),('en_US','214','Gers'),('en_US','215','Gironde'),('en_US','216','Hérault'),('en_US','217','Ille-et-Vilaine'),('en_US','218','Indre'),('en_US','219','Indre-et-Loire'),('en_US','220','Isère'),('en_US','221','Jura'),('en_US','222','Landes'),('en_US','223','Loir-et-Cher'),('en_US','224','Loire'),('en_US','225','Haute-Loire'),('en_US','226','Loire-Atlantique'),('en_US','227','Loiret'),('en_US','228','Lot'),('en_US','229','Lot-et-Garonne'),('en_US','230','Lozère'),('en_US','231','Maine-et-Loire'),('en_US','232','Manche'),('en_US','233','Marne'),('en_US','234','Haute-Marne'),('en_US','235','Mayenne'),('en_US','236','Meurthe-et-Moselle'),('en_US','237','Meuse'),('en_US','238','Morbihan'),('en_US','239','Moselle'),('en_US','240','Nièvre'),('en_US','241','Nord'),('en_US','242','Oise'),('en_US','243','Orne'),('en_US','244','Pas-de-Calais'),('en_US','245','Puy-de-Dôme'),('en_US','246','Pyrénées-Atlantiques'),('en_US','247','Hautes-Pyrénées'),('en_US','248','Pyrénées-Orientales'),('en_US','249','Bas-Rhin'),('en_US','250','Haut-Rhin'),('en_US','251','Rhône'),('en_US','252','Haute-Saône'),('en_US','253','Saône-et-Loire'),('en_US','254','Sarthe'),('en_US','255','Savoie'),('en_US','256','Haute-Savoie'),('en_US','257','Paris'),('en_US','258','Seine-Maritime'),('en_US','259','Seine-et-Marne'),('en_US','260','Yvelines'),('en_US','261','Deux-Sèvres'),('en_US','262','Somme'),('en_US','263','Tarn'),('en_US','264','Tarn-et-Garonne'),('en_US','265','Var'),('en_US','266','Vaucluse'),('en_US','267','Vendée'),('en_US','268','Vienne'),('en_US','269','Haute-Vienne'),('en_US','270','Vosges'),('en_US','271','Yonne'),('en_US','272','Territoire-de-Belfort'),('en_US','273','Essonne'),('en_US','274','Hauts-de-Seine'),('en_US','275','Seine-Saint-Denis'),('en_US','276','Val-de-Marne'),('en_US','277','Val-d\'Oise'),('en_US','278','Alba'),('en_US','279','Arad'),('en_US','280','Argeş'),('en_US','281','Bacău'),('en_US','282','Bihor'),('en_US','283','Bistriţa-Năsăud'),('en_US','284','Botoşani'),('en_US','285','Braşov'),('en_US','286','Brăila'),('en_US','287','Bucureşti'),('en_US','288','Buzău'),('en_US','289','Caraş-Severin'),('en_US','290','Călăraşi'),('en_US','291','Cluj'),('en_US','292','Constanţa'),('en_US','293','Covasna'),('en_US','294','Dâmboviţa'),('en_US','295','Dolj'),('en_US','296','Galaţi'),('en_US','297','Giurgiu'),('en_US','298','Gorj'),('en_US','299','Harghita'),('en_US','300','Hunedoara'),('en_US','301','Ialomiţa'),('en_US','302','Iaşi'),('en_US','303','Ilfov'),('en_US','304','Maramureş'),('en_US','305','Mehedinţi'),('en_US','306','Mureş'),('en_US','307','Neamţ'),('en_US','308','Olt'),('en_US','309','Prahova'),('en_US','310','Satu-Mare'),('en_US','311','Sălaj'),('en_US','312','Sibiu'),('en_US','313','Suceava'),('en_US','314','Teleorman'),('en_US','315','Timiş'),('en_US','316','Tulcea'),('en_US','317','Vaslui'),('en_US','318','Vâlcea'),('en_US','319','Vrancea'),('en_US','320','Lappi'),('en_US','321','Pohjois-Pohjanmaa'),('en_US','322','Kainuu'),('en_US','323','Pohjois-Karjala'),('en_US','324','Pohjois-Savo'),('en_US','325','Etelä-Savo'),('en_US','326','Etelä-Pohjanmaa'),('en_US','327','Pohjanmaa'),('en_US','328','Pirkanmaa'),('en_US','329','Satakunta'),('en_US','330','Keski-Pohjanmaa'),('en_US','331','Keski-Suomi'),('en_US','332','Varsinais-Suomi'),('en_US','333','Etelä-Karjala'),('en_US','334','Päijät-Häme'),('en_US','335','Kanta-Häme'),('en_US','336','Uusimaa'),('en_US','337','Itä-Uusimaa'),('en_US','338','Kymenlaakso'),('en_US','339','Ahvenanmaa'),('en_US','340','Harjumaa'),('en_US','341','Hiiumaa'),('en_US','342','Ida-Virumaa'),('en_US','343','Jõgevamaa'),('en_US','344','Järvamaa'),('en_US','345','Läänemaa'),('en_US','346','Lääne-Virumaa'),('en_US','347','Põlvamaa'),('en_US','348','Pärnumaa'),('en_US','349','Raplamaa'),('en_US','350','Saaremaa'),('en_US','351','Tartumaa'),('en_US','352','Valgamaa'),('en_US','353','Viljandimaa'),('en_US','354','Võrumaa'),('en_US','355','Daugavpils'),('en_US','356','Jelgava'),('en_US','357','Jēkabpils'),('en_US','358','Jūrmala'),('en_US','359','Liepāja'),('en_US','360','Liepājas novads'),('en_US','361','Rēzekne'),('en_US','362','Rīga'),('en_US','363','Rīgas novads'),('en_US','364','Valmiera'),('en_US','365','Ventspils'),('en_US','366','Aglonas novads'),('en_US','367','Aizkraukles novads'),('en_US','368','Aizputes novads'),('en_US','369','Aknīstes novads'),('en_US','370','Alojas novads'),('en_US','371','Alsungas novads'),('en_US','372','Alūksnes novads'),('en_US','373','Amatas novads'),('en_US','374','Apes novads'),('en_US','375','Auces novads'),('en_US','376','Babītes novads'),('en_US','377','Baldones novads'),('en_US','378','Baltinavas novads'),('en_US','379','Balvu novads'),('en_US','380','Bauskas novads'),('en_US','381','Beverīnas novads'),('en_US','382','Brocēnu novads'),('en_US','383','Burtnieku novads'),('en_US','384','Carnikavas novads'),('en_US','385','Cesvaines novads'),('en_US','386','Ciblas novads'),('en_US','387','Cēsu novads'),('en_US','388','Dagdas novads'),('en_US','389','Daugavpils novads'),('en_US','390','Dobeles novads'),('en_US','391','Dundagas novads'),('en_US','392','Durbes novads'),('en_US','393','Engures novads'),('en_US','394','Garkalnes novads'),('en_US','395','Grobiņas novads'),('en_US','396','Gulbenes novads'),('en_US','397','Iecavas novads'),('en_US','398','Ikšķiles novads'),('en_US','399','Ilūkstes novads'),('en_US','400','Inčukalna novads'),('en_US','401','Jaunjelgavas novads'),('en_US','402','Jaunpiebalgas novads'),('en_US','403','Jaunpils novads'),('en_US','404','Jelgavas novads'),('en_US','405','Jēkabpils novads'),('en_US','406','Kandavas novads'),('en_US','407','Kokneses novads'),('en_US','408','Krimuldas novads'),('en_US','409','Krustpils novads'),('en_US','410','Krāslavas novads'),('en_US','411','Kuldīgas novads'),('en_US','412','Kārsavas novads'),('en_US','413','Lielvārdes novads'),('en_US','414','Limbažu novads'),('en_US','415','Lubānas novads'),('en_US','416','Ludzas novads'),('en_US','417','Līgatnes novads'),('en_US','418','Līvānu novads'),('en_US','419','Madonas novads'),('en_US','420','Mazsalacas novads'),('en_US','421','Mālpils novads'),('en_US','422','Mārupes novads'),('en_US','423','Naukšēnu novads'),('en_US','424','Neretas novads'),('en_US','425','Nīcas novads'),('en_US','426','Ogres novads'),('en_US','427','Olaines novads'),('en_US','428','Ozolnieku novads'),('en_US','429','Preiļu novads'),('en_US','430','Priekules novads'),('en_US','431','Priekuļu novads'),('en_US','432','Pārgaujas novads'),('en_US','433','Pāvilostas novads'),('en_US','434','Pļaviņu novads'),('en_US','435','Raunas novads'),('en_US','436','Riebiņu novads'),('en_US','437','Rojas novads'),('en_US','438','Ropažu novads'),('en_US','439','Rucavas novads'),('en_US','440','Rugāju novads'),('en_US','441','Rundāles novads'),('en_US','442','Rēzeknes novads'),('en_US','443','Rūjienas novads'),('en_US','444','Salacgrīvas novads'),('en_US','445','Salas novads'),('en_US','446','Salaspils novads'),('en_US','447','Saldus novads'),('en_US','448','Saulkrastu novads'),('en_US','449','Siguldas novads'),('en_US','450','Skrundas novads'),('en_US','451','Skrīveru novads'),('en_US','452','Smiltenes novads'),('en_US','453','Stopiņu novads'),('en_US','454','Strenču novads'),('en_US','455','Sējas novads'),('en_US','456','Talsu novads'),('en_US','457','Tukuma novads'),('en_US','458','Tērvetes novads'),('en_US','459','Vaiņodes novads'),('en_US','460','Valkas novads'),('en_US','461','Valmieras novads'),('en_US','462','Varakļānu novads'),('en_US','463','Vecpiebalgas novads'),('en_US','464','Vecumnieku novads'),('en_US','465','Ventspils novads'),('en_US','466','Viesītes novads'),('en_US','467','Viļakas novads'),('en_US','468','Viļānu novads'),('en_US','469','Vārkavas novads'),('en_US','470','Zilupes novads'),('en_US','471','Ādažu novads'),('en_US','472','Ērgļu novads'),('en_US','473','Ķeguma novads'),('en_US','474','Ķekavas novads'),('en_US','475','Alytaus Apskritis'),('en_US','476','Kauno Apskritis'),('en_US','477','Klaipėdos Apskritis'),('en_US','478','Marijampolės Apskritis'),('en_US','479','Panevėžio Apskritis'),('en_US','480','Šiaulių Apskritis'),('en_US','481','Tauragės Apskritis'),('en_US','482','Telšių Apskritis'),('en_US','483','Utenos Apskritis'),('en_US','484','Vilniaus Apskritis'),('en_US','485','Acre'),('en_US','486','Alagoas'),('en_US','487','Amapá'),('en_US','488','Amazonas'),('en_US','489','Bahia'),('en_US','490','Ceará'),('en_US','491','Espírito Santo'),('en_US','492','Goiás'),('en_US','493','Maranhão'),('en_US','494','Mato Grosso'),('en_US','495','Mato Grosso do Sul'),('en_US','496','Minas Gerais'),('en_US','497','Pará'),('en_US','498','Paraíba'),('en_US','499','Paraná'),('en_US','500','Pernambuco'),('en_US','501','Piauí'),('en_US','502','Rio de Janeiro'),('en_US','503','Rio Grande do Norte'),('en_US','504','Rio Grande do Sul'),('en_US','505','Rondônia'),('en_US','506','Roraima'),('en_US','507','Santa Catarina'),('en_US','508','São Paulo'),('en_US','509','Sergipe'),('en_US','510','Tocantins'),('en_US','511','Distrito Federal'),('en_US','512','Zagrebačka županija'),('en_US','513','Krapinsko-zagorska županija'),('en_US','514','Sisačko-moslavačka županija'),('en_US','515','Karlovačka županija'),('en_US','516','Varaždinska županija'),('en_US','517','Koprivničko-križevačka županija'),('en_US','518','Bjelovarsko-bilogorska županija'),('en_US','519','Primorsko-goranska županija'),('en_US','520','Ličko-senjska županija'),('en_US','521','Virovitičko-podravska županija'),('en_US','522','Požeško-slavonska županija'),('en_US','523','Brodsko-posavska županija'),('en_US','524','Zadarska županija'),('en_US','525','Osječko-baranjska županija'),('en_US','526','Šibensko-kninska županija'),('en_US','527','Vukovarsko-srijemska županija'),('en_US','528','Splitsko-dalmatinska županija'),('en_US','529','Istarska županija'),('en_US','530','Dubrovačko-neretvanska županija'),('en_US','531','Međimurska županija'),('en_US','532','Grad Zagreb');

--
-- Table structure for table `directory_currency_rate`
--

CREATE TABLE `directory_currency_rate` (
  `currency_from` varchar(3) NOT NULL COMMENT 'Currency Code Convert From',
  `currency_to` varchar(3) NOT NULL COMMENT 'Currency Code Convert To',
  `rate` decimal(24,12) NOT NULL DEFAULT '0.000000000000' COMMENT 'Currency Conversion Rate',
  PRIMARY KEY (`currency_from`,`currency_to`),
  KEY `DIRECTORY_CURRENCY_RATE_CURRENCY_TO` (`currency_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Currency Rate';

--
-- Dumping data for table `directory_currency_rate`
--

INSERT INTO `directory_currency_rate` VALUES ('EUR','EUR','1.000000000000'),('EUR','USD','1.415000000000'),('USD','EUR','0.706700000000'),('USD','USD','1.000000000000');

--
-- Table structure for table `downloadable_link`
--

CREATE TABLE `downloadable_link` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort order',
  `number_of_downloads` int(11) DEFAULT NULL COMMENT 'Number of downloads',
  `is_shareable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Shareable flag',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'Link Url',
  `link_file` varchar(255) DEFAULT NULL COMMENT 'Link File',
  `link_type` varchar(20) DEFAULT NULL COMMENT 'Link Type',
  `sample_url` varchar(255) DEFAULT NULL COMMENT 'Sample Url',
  `sample_file` varchar(255) DEFAULT NULL COMMENT 'Sample File',
  `sample_type` varchar(20) DEFAULT NULL COMMENT 'Sample Type',
  PRIMARY KEY (`link_id`),
  KEY `DOWNLOADABLE_LINK_PRODUCT_ID_SORT_ORDER` (`product_id`,`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Table';

--
-- Table structure for table `downloadable_link_price`
--

CREATE TABLE `downloadable_link_price` (
  `price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Price ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  PRIMARY KEY (`price_id`),
  KEY `DOWNLOADABLE_LINK_PRICE_LINK_ID` (`link_id`),
  KEY `DOWNLOADABLE_LINK_PRICE_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Price Table';

--
-- Table structure for table `downloadable_link_purchased`
--

CREATE TABLE `downloadable_link_purchased` (
  `purchased_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Purchased ID',
  `order_id` int(10) unsigned DEFAULT '0' COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order Item ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date of creation',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of modification',
  `customer_id` int(10) unsigned DEFAULT '0' COMMENT 'Customer ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product name',
  `product_sku` varchar(255) DEFAULT NULL COMMENT 'Product sku',
  `link_section_title` varchar(255) DEFAULT NULL COMMENT 'Link_section_title',
  PRIMARY KEY (`purchased_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ORDER_ID` (`order_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ORDER_ITEM_ID` (`order_item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Table';

--
-- Table structure for table `downloadable_link_purchased_item`
--

CREATE TABLE `downloadable_link_purchased_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
  `purchased_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Purchased ID',
  `order_item_id` int(10) unsigned DEFAULT '0' COMMENT 'Order Item ID',
  `product_id` int(10) unsigned DEFAULT '0' COMMENT 'Product ID',
  `link_hash` varchar(255) DEFAULT NULL COMMENT 'Link hash',
  `number_of_downloads_bought` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of downloads bought',
  `number_of_downloads_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of downloads used',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `link_title` varchar(255) DEFAULT NULL COMMENT 'Link Title',
  `is_shareable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Shareable Flag',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'Link Url',
  `link_file` varchar(255) DEFAULT NULL COMMENT 'Link File',
  `link_type` varchar(255) DEFAULT NULL COMMENT 'Link Type',
  `status` varchar(50) DEFAULT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update Time',
  PRIMARY KEY (`item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_LINK_HASH` (`link_hash`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_ORDER_ITEM_ID` (`order_item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_PURCHASED_ID` (`purchased_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Item Table';

--
-- Table structure for table `downloadable_link_title`
--

CREATE TABLE `downloadable_link_title` (
  `title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Title ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`title_id`),
  UNIQUE KEY `DOWNLOADABLE_LINK_TITLE_LINK_ID_STORE_ID` (`link_id`,`store_id`),
  KEY `DOWNLOADABLE_LINK_TITLE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link Title Table';

--
-- Table structure for table `downloadable_sample`
--

CREATE TABLE `downloadable_sample` (
  `sample_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Sample ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `sample_url` varchar(255) DEFAULT NULL COMMENT 'Sample URL',
  `sample_file` varchar(255) DEFAULT NULL COMMENT 'Sample file',
  `sample_type` varchar(20) DEFAULT NULL COMMENT 'Sample Type',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`sample_id`),
  KEY `DOWNLOADABLE_SAMPLE_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Table';

--
-- Table structure for table `downloadable_sample_title`
--

CREATE TABLE `downloadable_sample_title` (
  `title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Title ID',
  `sample_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sample ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`title_id`),
  UNIQUE KEY `DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID_STORE_ID` (`sample_id`,`store_id`),
  KEY `DOWNLOADABLE_SAMPLE_TITLE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Title Table';

--
-- Table structure for table `eav_attribute`
--

CREATE TABLE `eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_code` varchar(255) NOT NULL COMMENT 'Attribute Code',
  `attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
  `backend_model` varchar(255) DEFAULT NULL COMMENT 'Backend Model',
  `backend_type` varchar(8) NOT NULL DEFAULT 'static' COMMENT 'Backend Type',
  `backend_table` varchar(255) DEFAULT NULL COMMENT 'Backend Table',
  `frontend_model` varchar(255) DEFAULT NULL COMMENT 'Frontend Model',
  `frontend_input` varchar(50) DEFAULT NULL COMMENT 'Frontend Input',
  `frontend_label` varchar(255) DEFAULT NULL COMMENT 'Frontend Label',
  `frontend_class` varchar(255) DEFAULT NULL COMMENT 'Frontend Class',
  `source_model` varchar(255) DEFAULT NULL COMMENT 'Source Model',
  `is_required` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is Required',
  `is_user_defined` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is User Defined',
  `default_value` text COMMENT 'Default Value',
  `is_unique` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is Unique',
  `note` varchar(255) DEFAULT NULL COMMENT 'Note',
  PRIMARY KEY (`attribute_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE` (`entity_type_id`,`attribute_code`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute';

--
-- Dumping data for table `eav_attribute`
--



--
-- Table structure for table `eav_attribute_group`
--

CREATE TABLE `eav_attribute_group` (
  `attribute_group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Group Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `attribute_group_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Group Name',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `default_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Default Id',
  `attribute_group_code` varchar(255) NOT NULL COMMENT 'Attribute Group Code',
  `tab_group_code` varchar(255) DEFAULT NULL COMMENT 'Tab Group Code',
  PRIMARY KEY (`attribute_group_id`),
  UNIQUE KEY `CATALOG_CATEGORY_PRODUCT_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE` (`attribute_set_id`,`attribute_group_code`),
  UNIQUE KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME` (`attribute_set_id`,`attribute_group_name`),
  KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Group';

--
-- Dumping data for table `eav_attribute_group`
--

INSERT INTO `eav_attribute_group` VALUES (1,1,'General',1,1,'general',NULL),(2,2,'General',1,1,'general',NULL),(3,3,'General',10,1,'general',NULL),(4,3,'General Information',2,0,'general-information',NULL),(5,3,'Display Settings',20,0,'display-settings',NULL),(6,3,'Custom Design',30,0,'custom-design',NULL),(7,4,'Product Details',1,1,'product-details','basic'),(8,4,'Advanced Pricing',6,0,'advanced-pricing','advanced'),(9,4,'Search Engine Optimization',5,0,'search-engine-optimization','basic'),(10,4,'Images',4,0,'image-management','basic'),(11,4,'Design',7,0,'design','advanced'),(12,4,'Autosettings',9,0,'autosettings','advanced'),(13,4,'Content',2,0,'content','basic'),(14,4,'Schedule Design Update',8,0,'schedule-design-update','advanced'),(15,4,'Bundle Items',3,0,'bundle-items',NULL),(16,5,'General',1,1,'general',NULL),(17,6,'General',1,1,'general',NULL),(18,7,'General',1,1,'general',NULL),(19,8,'General',1,1,'general',NULL),(20,4,'Gift Options',10,0,'gift-options',NULL),(21,9,'Gift Options',10,0,'gift-options',NULL),(22,9,'Autosettings',9,0,'autosettings','advanced'),(23,9,'Schedule Design Update',8,0,'schedule-design-update','advanced'),(24,9,'Design',7,0,'design','advanced'),(25,9,'Advanced Pricing',6,0,'advanced-pricing','advanced'),(26,9,'Search Engine Optimization',5,0,'search-engine-optimization','basic'),(27,9,'Images',4,0,'image-management','basic'),(28,9,'Bundle Items',3,0,'bundle-items',NULL),(29,9,'Content',2,0,'content','basic'),(30,9,'Product Details',1,1,'product-details','basic'),(31,3,'Content',31,0,'content',NULL),(32,3,'Catalog Images Grid',60,0,'catalog-images-grid',NULL),(33,3,'Megamenu',61,0,'megamenu',NULL),(34,9,'Shop by Brand',11,0,'shop-by-brand',NULL),(35,4,'Shop by Brand',11,0,'shop-by-brand',NULL);

--
-- Table structure for table `eav_attribute_label`
--

CREATE TABLE `eav_attribute_label` (
  `attribute_label_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Label Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`attribute_label_id`),
  KEY `EAV_ATTRIBUTE_LABEL_STORE_ID` (`store_id`),
  KEY `EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID` (`attribute_id`,`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Label';

--
-- Dumping data for table `eav_attribute_label`
--

INSERT INTO `eav_attribute_label` VALUES ('1',135,1,'Manufacturer'),('2',135,2,'Manufacturer'),('3',135,3,'Manufacturer'),('4',136,1,'Embellishment'),('5',136,2,'Embellishment'),('6',136,3,'Embellishment'),('7',137,1,'Bra type'),('8',137,2,'Bra type'),('9',137,3,'Bra type'),('10',138,1,'Fit'),('11',138,2,'Fit'),('12',138,3,'Fit'),('13',139,1,'Closure'),('14',139,2,'Closure'),('15',139,3,'Closure'),('16',140,1,'Features'),('17',140,2,'Features'),('18',140,3,'Features'),('19',141,1,'Style'),('20',141,2,'Style'),('21',141,3,'Style'),('22',142,1,'Care'),('23',142,2,'Care'),('24',142,3,'Care'),('28',143,1,'Color'),('29',143,2,'Color'),('30',143,3,'Color');

--
-- Table structure for table `eav_attribute_option`
--

CREATE TABLE `eav_attribute_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option';

--
-- Dumping data for table `eav_attribute_option`
--

INSERT INTO `eav_attribute_option` VALUES ('1',20,0),('2',20,1),('3',20,3),('4',135,1),('5',135,2),('6',135,3),('7',135,4),('8',136,1),('9',136,2),('10',136,3),('11',137,1),('12',137,2),('13',137,3),('14',137,4),('15',138,1),('16',138,2),('17',138,3),('18',139,1),('19',139,2),('20',139,3),('21',140,1),('22',140,2),('23',141,1),('24',141,2),('25',141,3),('26',142,1),('27',142,2),('28',143,1),('29',143,2),('30',143,3),('31',143,4),('32',143,5);

--
-- Table structure for table `eav_attribute_option_swatch`
--

CREATE TABLE `eav_attribute_option_swatch` (
  `swatch_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Swatch ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `type` smallint(5) unsigned NOT NULL COMMENT 'Swatch type: 0 - text, 1 - visual color, 2 - visual image',
  `value` varchar(255) DEFAULT NULL COMMENT 'Swatch Value',
  PRIMARY KEY (`swatch_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_OPTION_ID` (`store_id`,`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_SWATCH_SWATCH_ID` (`swatch_id`),
  KEY `EAV_ATTR_OPT_SWATCH_OPT_ID_EAV_ATTR_OPT_OPT_ID` (`option_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Magento Swatches table';

--
-- Dumping data for table `eav_attribute_option_swatch`
--

INSERT INTO `eav_attribute_option_swatch` VALUES ('1','28',0,1,'#000000'),('2','29',0,1,'#ffffff'),('3','30',0,1,'#ffb8ff'),('4','31',0,1,'#3a87f2'),('5','32',0,1,'#d91c1c');

--
-- Table structure for table `eav_attribute_option_value`
--

CREATE TABLE `eav_attribute_option_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  KEY `EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID` (`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option Value';

--
-- Dumping data for table `eav_attribute_option_value`
--

INSERT INTO `eav_attribute_option_value` VALUES ('1','1',0,'Male'),('2','2',0,'Female'),('3','3',0,'Not Specified'),('4','4',1,'China'),('5','4',0,'China'),('6','4',2,'China'),('7','4',3,'China'),('8','5',1,'USA'),('9','5',0,'USA'),('10','5',2,'USA'),('11','5',3,'USA'),('12','6',1,'Germany'),('13','6',0,'Germany'),('14','6',2,'Germany'),('15','6',3,'Germany'),('16','7',1,'France'),('17','7',0,'France'),('18','7',2,'France'),('19','7',3,'France'),('20','8',1,'Hollow Out'),('21','8',0,'Hollow Out'),('22','8',2,'Hollow Out'),('23','8',3,'Hollow Out'),('24','9',1,'Lace '),('25','9',0,'Lace '),('26','9',2,'Lace '),('27','9',3,'Lace '),('28','10',1,'Backless'),('29','10',0,'Backless'),('30','10',2,'Backless'),('31','10',3,'Backless'),('32','11',1,'Push Up Bra '),('33','11',0,'Push Up Bra '),('34','11',2,'Push Up Bra '),('35','11',3,'Push Up Bra '),('36','12',1,'T-Shirt Bra'),('37','12',0,'T-Shirt Bra'),('38','12',2,'T-Shirt Bra'),('39','12',3,'T-Shirt Bra'),('40','13',1,'Support Bra'),('41','13',0,'Support Bra'),('42','13',2,'Support Bra'),('43','13',3,'Support Bra'),('44','14',1,'Basic Bra'),('45','14',0,'Basic Bra'),('46','14',2,'Basic Bra'),('47','14',3,'Basic Bra'),('48','15',1,'Comfort'),('49','15',0,'Comfort'),('50','15',2,'Comfort'),('51','15',3,'Comfort'),('52','16',1,'Loose Fit'),('53','16',0,'Loose Fit'),('54','16',2,'Loose Fit'),('55','16',3,'Loose Fit'),('56','17',1,'Regular'),('57','17',0,'Regular'),('58','17',2,'Regular'),('59','17',3,'Regular'),('60','18',1,'Hasp'),('61','18',0,'Hasp'),('62','18',2,'Hasp'),('63','18',3,'Hasp'),('64','19',1,'Zipper'),('65','19',0,'Zipper'),('66','19',2,'Zipper'),('67','19',3,'Zipper'),('68','20',1,'String'),('69','20',0,'String'),('70','20',2,'String'),('71','20',3,'String'),('72','21',1,'Elastic waistband with drawcord adjustment'),('73','21',0,'Elastic waistband with drawcord adjustment'),('74','21',2,'Elastic waistband with drawcord adjustment'),('75','21',3,'Elastic waistband with drawcord adjustment'),('76','22',1,'Flat lock seams for extra comfort'),('77','22',0,'Flat lock seams for extra comfort'),('78','22',2,'Flat lock seams for extra comfort'),('79','22',3,'Flat lock seams for extra comfort'),('80','23',1,'Classic'),('81','23',0,'Classic'),('82','23',2,'Classic'),('83','23',3,'Classic'),('84','24',1,'Romantic'),('85','24',0,'Romantic'),('86','24',2,'Romantic'),('87','24',3,'Romantic'),('88','25',1,'Sexy'),('89','25',0,'Sexy'),('90','25',2,'Sexy'),('91','25',3,'Sexy'),('92','26',1,'Hand wash'),('93','26',0,'Hand wash'),('94','26',2,'Hand wash'),('95','26',3,'Hand wash'),('96','27',1,'Machine wash'),('97','27',0,'Machine wash'),('98','27',2,'Machine wash'),('99','27',3,'Machine wash'),('100','28',1,'black'),('101','28',0,'black'),('102','28',2,'black'),('103','28',3,'black'),('104','29',1,'white'),('105','29',0,'white'),('106','29',2,'white'),('107','29',3,'white'),('108','30',1,'pink'),('109','30',0,'pink'),('110','30',2,'pink'),('111','30',3,'pink'),('112','31',1,'blue'),('113','31',0,'blue'),('114','31',2,'blue'),('115','31',3,'blue'),('116','32',1,'red'),('117','32',0,'red'),('118','32',2,'red'),('119','32',3,'red');

--
-- Table structure for table `eav_attribute_set`
--

CREATE TABLE `eav_attribute_set` (
  `attribute_set_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Set Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Set Name',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`attribute_set_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME` (`entity_type_id`,`attribute_set_name`),
  KEY `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_SORT_ORDER` (`entity_type_id`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Set';

--
-- Dumping data for table `eav_attribute_set`
--

INSERT INTO `eav_attribute_set` VALUES (1,1,'Default',2),(2,2,'Default',2),(3,3,'Default',1),(4,4,'Default',1),(5,5,'Default',1),(6,6,'Default',1),(7,7,'Default',1),(8,8,'Default',1),(9,4,'Configurable',0);

--
-- Table structure for table `eav_entity`
--

CREATE TABLE `eav_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment Id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Defines Is Entity Active',
  PRIMARY KEY (`entity_id`),
  KEY `EAV_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `EAV_ENTITY_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity';

--
-- Table structure for table `eav_entity_attribute`
--

CREATE TABLE `eav_entity_attribute` (
  `entity_attribute_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Attribute Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `attribute_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Group Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`entity_attribute_id`),
  UNIQUE KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID` (`attribute_set_id`,`attribute_id`),
  UNIQUE KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID` (`attribute_group_id`,`attribute_id`),
  KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
  KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=323 DEFAULT CHARSET=utf8 COMMENT='Eav Entity Attributes';

--
-- Dumping data for table `eav_entity_attribute`
--

INSERT INTO `eav_entity_attribute` VALUES ('1',1,1,1,1,10),('2',1,1,1,2,20),('3',1,1,1,3,20),('4',1,1,1,4,30),('5',1,1,1,5,40),('6',1,1,1,6,50),('7',1,1,1,7,60),('8',1,1,1,8,70),('9',1,1,1,9,80),('10',1,1,1,10,25),('11',1,1,1,11,90),('12',1,1,1,12,81),('13',1,1,1,13,115),('14',1,1,1,14,120),('15',1,1,1,15,82),('16',1,1,1,16,83),('17',1,1,1,17,100),('18',1,1,1,18,0),('19',1,1,1,19,0),('20',1,1,1,20,110),('21',1,1,1,21,28),('22',2,2,2,22,10),('23',2,2,2,23,20),('24',2,2,2,24,30),('25',2,2,2,25,40),('26',2,2,2,26,50),('27',2,2,2,27,60),('28',2,2,2,28,70),('29',2,2,2,29,80),('30',2,2,2,30,90),('31',2,2,2,31,100),('32',2,2,2,32,100),('33',2,2,2,33,110),('34',2,2,2,34,120),('35',2,2,2,35,130),('36',2,2,2,36,140),('37',2,2,2,37,132),('38',2,2,2,38,133),('39',2,2,2,39,134),('40',2,2,2,40,135),('41',1,1,1,41,87),('42',1,1,1,42,100),('43',1,1,1,43,110),('44',1,1,1,44,120),('45',3,3,4,45,1),('46',3,3,4,46,2),('47',3,3,4,47,4),('48',3,3,4,48,5),('49',3,3,4,49,6),('50',3,3,4,50,7),('51',3,3,4,51,8),('52',3,3,5,52,10),('53',3,3,5,53,20),('54',3,3,5,54,30),('55',3,3,4,55,12),('56',3,3,4,56,13),('57',3,3,4,57,14),('58',3,3,4,58,15),('59',3,3,4,59,16),('60',3,3,6,60,10),('61',3,3,6,61,30),('62',3,3,6,62,40),('63',3,3,6,63,50),('64',3,3,6,64,60),('65',3,3,4,65,24),('66',3,3,4,66,25),('67',3,3,5,67,40),('68',3,3,5,68,50),('69',3,3,4,69,10),('70',3,3,6,70,5),('71',3,3,6,71,6),('72',3,3,5,72,51),('90',4,4,7,91,6),('96',4,4,8,98,8),('105',4,4,7,107,14),('106',4,4,7,108,15),('107',4,4,7,109,16),('108',4,4,7,110,17),('109',4,4,7,111,18),('110',4,4,7,112,19),('111',4,4,7,113,20),('115',3,3,4,117,3),('116',3,3,4,118,17),('118',4,4,7,120,11),('126',4,4,7,128,111),('127',4,4,7,129,112),('128',4,4,7,130,113),('129',4,4,7,131,114),('133',4,4,7,73,2),('134',4,4,7,74,3),('135',4,4,7,77,5),('136',4,4,7,82,9),('137',4,4,7,94,21),('138',4,4,7,95,22),('139',4,4,7,97,1),('140',4,4,7,99,20),('141',4,4,7,105,7),('142',4,4,7,114,23),('143',4,4,7,115,10),('144',4,4,7,123,6),('145',4,4,7,124,4),('146',4,4,7,125,19),('147',4,4,7,134,8),('148',4,4,7,135,11),('149',4,4,7,136,13),('150',4,4,7,137,12),('151',4,4,7,138,16),('152',4,4,7,139,15),('153',4,4,7,140,14),('154',4,4,7,141,17),('155',4,4,7,142,18),('156',4,4,13,75,1),('157',4,4,13,76,2),('158',4,4,15,127,1),('159',4,4,10,87,1),('160',4,4,10,88,2),('161',4,4,10,89,3),('162',4,4,10,90,5),('163',4,4,10,96,6),('164',4,4,10,133,4),('165',4,4,9,84,2),('166',4,4,9,85,3),('167',4,4,9,86,4),('168',4,4,9,119,1),('169',4,4,8,78,1),('170',4,4,8,79,2),('171',4,4,8,80,3),('172',4,4,8,81,4),('173',4,4,8,92,5),('174',4,4,8,121,6),('175',4,4,8,122,7),('176',4,4,8,126,8),('177',4,4,11,103,3),('178',4,4,11,104,1),('179',4,4,11,106,2),('180',4,4,14,100,3),('181',4,4,14,101,1),('182',4,4,14,102,2),('183',4,4,14,116,4),('184',4,4,20,132,1),('200',4,9,25,98,8),('220',4,9,30,91,6),('227',4,9,30,120,11),('231',4,9,30,107,14),('232',4,9,30,108,15),('234',4,9,30,109,16),('237',4,9,30,110,17),('239',4,9,30,111,18),('240',4,9,30,112,19),('243',4,9,30,113,20),('247',4,9,30,128,111),('248',4,9,30,129,112),('249',4,9,30,130,113),('250',4,9,30,131,114),('251',4,9,30,73,2),('252',4,9,30,74,3),('253',4,9,30,77,5),('254',4,9,30,82,9),('255',4,9,30,94,22),('256',4,9,30,95,23),('257',4,9,30,97,1),('258',4,9,30,99,21),('259',4,9,30,105,7),('260',4,9,30,114,24),('261',4,9,30,115,10),('262',4,9,30,123,6),('263',4,9,30,124,4),('264',4,9,30,125,20),('265',4,9,30,134,8),('266',4,9,30,135,11),('267',4,9,30,136,14),('268',4,9,30,137,13),('269',4,9,30,138,17),('270',4,9,30,139,16),('271',4,9,30,140,15),('272',4,9,30,141,18),('273',4,9,30,142,19),('274',4,9,30,143,12),('275',4,9,29,75,1),('276',4,9,29,76,2),('277',4,9,28,127,1),('278',4,9,27,87,1),('279',4,9,27,88,2),('280',4,9,27,89,3),('281',4,9,27,90,5),('282',4,9,27,96,6),('283',4,9,27,133,4),('284',4,9,26,84,2),('285',4,9,26,85,3),('286',4,9,26,86,4),('287',4,9,26,119,1),('288',4,9,25,78,1),('289',4,9,25,79,2),('290',4,9,25,80,3),('291',4,9,25,81,4),('292',4,9,25,92,5),('293',4,9,25,121,6),('294',4,9,25,122,7),('295',4,9,25,126,8),('296',4,9,24,103,3),('297',4,9,24,104,1),('298',4,9,24,106,2),('299',4,9,23,100,3),('300',4,9,23,101,1),('301',4,9,23,102,2),('302',4,9,23,116,4),('303',4,9,21,132,1),('305',4,4,7,143,116),('306',3,3,32,144,5),('307',3,3,32,145,6),('308',3,3,32,146,7),('309',4,9,30,147,10),('310',4,4,10,147,10),('311',4,9,30,148,10),('312',4,4,10,148,10),('313',3,3,33,149,10),('314',3,3,33,150,50),('315',3,3,33,151,110),('316',3,3,33,152,120),('317',3,3,33,153,130),('318',3,3,33,154,140),('319',3,3,33,155,150),('320',3,3,33,156,160),('321',4,9,34,157,44),('322',4,4,35,157,44);

--
