DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'slideshow';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'featured';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'account';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'category';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'banner';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'carousel';

DELETE FROM ?:banner where `banner_id`= 100;
DELETE FROM ?:banner_image where `banner_id`= 100;
DELETE FROM ?:banner_image_description where `banner_id`= 100;

INSERT INTO ?:banner VALUES
(100, 'Top Slider', 1);

INSERT INTO ?:banner_image (`banner_image_id`, `banner_id`, `link`, `image`, `sort_order`) VALUES
(100, 100, 'index.php', 'catalog/slider_img1.jpg', 1),
(101, 100, 'index.php', 'catalog/slider_img2.jpg', 2),
(102, 100, 'index.php', 'catalog/slider_img3.jpg', 3),
(103, 100, 'index.php', 'catalog/slider_img4.jpg', 4),
(104, 100, 'index.php', 'catalog/slider_img5.jpg', 5),
(105, 100, 'index.php', 'catalog/slider_img6.jpg', 6);


INSERT INTO ?:banner_image_description (`banner_image_id`, `language_id`, `banner_id`, `title`) VALUES
(100, 1, 100, 'slide1'),
(101, 1, 100, 'slide2'),
(102, 1, 100, 'slide3'),
(103, 1, 100, 'slide4'),
(104, 1, 100, 'slide5'),
(105, 1, 100, 'slide6');

UPDATE ?:setting SET `value` = 'catalog/logo.png' WHERE `key` = 'config_logo';
UPDATE ?:setting SET `value` = 'catalog/favicon.png' WHERE `key` = 'config_icon';


UPDATE ?:setting SET `value` = '328' WHERE `key` = 'config_image_product_width';
UPDATE ?:setting SET `value` = '418' WHERE `key` = 'config_image_product_height';

UPDATE ?:setting SET `value` = '328' WHERE `key` = 'config_image_additional_width';
UPDATE ?:setting SET `value` = '418' WHERE `key` = 'config_image_additional_height';

UPDATE ?:setting SET `value` = '328' WHERE `key` = 'config_image_thumb_width';
UPDATE ?:setting SET `value` = '418' WHERE `key` = 'config_image_thumb_height';

UPDATE ?:setting SET `value` = '329' WHERE `key` = 'config_image_related_width';
UPDATE ?:setting SET `value` = '418' WHERE `key` = 'config_image_related_height';

UPDATE ?:setting SET `value` = '625' WHERE `key` = 'config_image_popup_width';
UPDATE ?:setting SET `value` = '794' WHERE `key` = 'config_image_popup_height';

UPDATE ?:setting SET `value` = '40' WHERE `key` = 'config_image_wishlist_width';
UPDATE ?:setting SET `value` = '51' WHERE `key` = 'config_image_wishlist_height';

UPDATE ?:setting SET `value` = '40' WHERE `key` = 'config_image_cart_width';
UPDATE ?:setting SET `value` = '51' WHERE `key` = 'config_image_cart_height';

DELETE FROM ?:information where `information_id`= 7;
DELETE FROM ?:information where `information_id`= 8;
DELETE FROM ?:information where `information_id`= 9;
DELETE FROM ?:information where `information_id`= 10;
INSERT INTO ?:information (`information_id`, `bottom`, `sort_order`, `status`) VALUES
(7, 0, 5, 1),
(8, 0, 6, 1),
(9, 0, 7, 1),
(10, 0, 8, 1);

DELETE FROM ?:information_description where `information_id`= 7;
DELETE FROM ?:information_description where `information_id`= 8;
DELETE FROM ?:information_description where `information_id`= 9;
DELETE FROM ?:information_description where `information_id`= 10;
INSERT INTO ?:information_description (`information_id`, `language_id`, `title`, `description`) VALUES
(7, 1, 'original products', '&lt;p&gt;	See exclusive information about our original products&lt;/p&gt;'),
(8, 1, 'free shipping', '&lt;p&gt; 	FREE SHIPPING FREE SHIPPING FREE SHIPPING&lt;/p&gt;'),
(9, 1, 'cash on delivery', '&lt;p&gt;cash on delivery cash on delivery&lt;/p&gt;'),
(10, 1, '30 days returns', '&lt;p&gt;30 days returns 30 days returns&lt;/p&gt;');

DELETE FROM ?:information_to_store where `information_id`= 7;
DELETE FROM ?:information_to_store where `information_id`= 8;
DELETE FROM ?:information_to_store where `information_id`= 9;
DELETE FROM ?:information_to_store where `information_id`= 10;
INSERT INTO ?:information_to_store (`information_id`, `store_id`) VALUES
(7, 0),
(8, 0),
(9, 0),
(10, 0);


DELETE FROM ?:filter;
DELETE FROM ?:filter_description;
DELETE FROM ?:filter_group;
DELETE FROM ?:filter_group_description;
DELETE FROM ?:category_filter;
DELETE FROM ?:product_filter;

INSERT INTO ?:filter VALUES
(3, 1, 3),
(2, 1, 2),
(1, 1, 1),
(4, 2, 1),
(5, 2, 2),
(6, 2, 3);
INSERT INTO ?:filter_description VALUES
(3, 1, 1, 'black'),
(2, 1, 1, 'blue'),
(1, 1, 1, 'brown'),
(4, 1, 2, '$0 - $100'),
(5, 1, 2, '$101 - $200'),
(6, 1, 2, '$201 - $500');
INSERT INTO ?:filter_group VALUES
(1, 1),
(2, 2);
INSERT INTO ?:filter_group_description VALUES
(1, 1, 'Color'),
(2, 1, 'Price');

INSERT INTO ?:category_filter (`category_id`, `filter_id`) VALUES
(20, 1),
(20, 2),
(20, 3),
(20, 4),
(20, 5),
(20, 6),
(20, 7),
(20, 8);
INSERT INTO ?:product_filter (`product_id`, `filter_id`) VALUES
(28, 1),
(28, 2),
(28, 3),
(28, 7),
(28, 8),
(20, 1),
(20, 2),
(20, 3);

UPDATE  ?:product_description SET `tag` =  'Smartphone' WHERE  `product_id` = 28;
UPDATE  ?:product_description SET `tag` =  'Phone,Mobile' WHERE  `product_id` = 29;
UPDATE  ?:product_description SET `tag` =  'Camera,Canon' WHERE  `product_id` = 30;
UPDATE  ?:product_description SET `tag` =  'Camera' WHERE  `product_id` = 31;
UPDATE  ?:product_description SET `tag` =  'iPod' WHERE  `product_id` = 32;
UPDATE  ?:product_description SET `tag` =  'Monitor,Laptop' WHERE  `product_id` = 33;
UPDATE  ?:product_description SET `tag` =  'iPod,Phone' WHERE  `product_id` = 34;
UPDATE  ?:product_description SET `tag` =  'Cool,modern' WHERE  `product_id` = 35;
UPDATE  ?:product_description SET `tag` =  'iPod' WHERE  `product_id` = 36;
UPDATE  ?:product_description SET `tag` =  'iPhone,Mobile' WHERE  `product_id` = 40;
UPDATE  ?:product_description SET `tag` =  'Laptop,iMac' WHERE  `product_id` = 41;
UPDATE  ?:product_description SET `tag` =  'Monitor,Apple' WHERE  `product_id` = 42;
UPDATE  ?:product_description SET `tag` =  'Macbook' WHERE  `product_id` = 43;
UPDATE  ?:product_description SET `tag` =  'Macbook,Laptop' WHERE  `product_id` = 44;
UPDATE  ?:product_description SET `tag` =  'Macbook' WHERE  `product_id` = 45;
UPDATE  ?:product_description SET `tag` =  'Laptop,Sony' WHERE  `product_id` = 46;
UPDATE  ?:product_description SET `tag` =  'Cool,Laptop,Usefull' WHERE  `product_id` = 47;
UPDATE  ?:product_description SET `tag` =  'iPod' WHERE  `product_id` = 48;
UPDATE  ?:product_description SET `tag` =  'Mobile' WHERE  `product_id` = 49;

UPDATE ?:user_group SET `permission` = 'a:2:{s:6:"access";a:217:{i:0;s:17:"catalog/attribute";i:1;s:23:"catalog/attribute_group";i:2;s:17:"catalog/bcategory";i:3;s:16:"catalog/bproduct";i:4;s:16:"catalog/category";i:5;s:16:"catalog/download";i:6;s:14:"catalog/filter";i:7;s:19:"catalog/information";i:8;s:20:"catalog/manufacturer";i:9;s:17:"catalog/mcategory";i:10;s:14:"catalog/option";i:11;s:15:"catalog/product";i:12;s:17:"catalog/recurring";i:13;s:14:"catalog/review";i:14;s:18:"common/column_left";i:15;s:18:"common/filemanager";i:16;s:11:"common/menu";i:17;s:14:"common/profile";i:18;s:12:"common/stats";i:19;s:18:"dashboard/activity";i:20;s:15:"dashboard/chart";i:21;s:18:"dashboard/customer";i:22;s:13:"dashboard/map";i:23;s:16:"dashboard/online";i:24;s:15:"dashboard/order";i:25;s:16:"dashboard/recent";i:26;s:14:"dashboard/sale";i:27;s:13:"design/banner";i:28;s:13:"design/layout";i:29;s:14:"extension/feed";i:30;s:19:"extension/installer";i:31;s:22:"extension/modification";i:32;s:16:"extension/module";i:33;s:17:"extension/openbay";i:34;s:17:"extension/payment";i:35;s:18:"extension/shipping";i:36;s:15:"extension/total";i:37;s:16:"feed/google_base";i:38;s:19:"feed/google_sitemap";i:39;s:15:"feed/openbaypro";i:40;s:20:"localisation/country";i:41;s:21:"localisation/currency";i:42;s:21:"localisation/geo_zone";i:43;s:21:"localisation/language";i:44;s:25:"localisation/length_class";i:45;s:21:"localisation/location";i:46;s:25:"localisation/order_status";i:47;s:26:"localisation/return_action";i:48;s:26:"localisation/return_reason";i:49;s:26:"localisation/return_status";i:50;s:25:"localisation/stock_status";i:51;s:22:"localisation/tax_class";i:52;s:21:"localisation/tax_rate";i:53;s:25:"localisation/weight_class";i:54;s:17:"localisation/zone";i:55;s:19:"marketing/affiliate";i:56;s:17:"marketing/contact";i:57;s:16:"marketing/coupon";i:58;s:19:"marketing/marketing";i:59;s:14:"module/account";i:60;s:16:"module/affiliate";i:61;s:20:"module/amazon_button";i:62;s:13:"module/banner";i:63;s:17:"module/bestseller";i:64;s:14:"module/buyshop";i:65;s:15:"module/carousel";i:66;s:15:"module/category";i:67;s:27:"module/dresscode_bestseller";i:68;s:32:"module/dresscode_custom_menu_box";i:69;s:35:"module/dresscode_custom_product_box";i:70;s:25:"module/dresscode_featured";i:71;s:31:"module/dresscode_featured_multi";i:72;s:23:"module/dresscode_latest";i:73;s:24:"module/dresscode_special";i:74;s:19:"module/ebay_listing";i:75;s:15:"module/featured";i:76;s:13:"module/filter";i:77;s:22:"module/google_hangouts";i:78;s:11:"module/html";i:79;s:18:"module/information";i:80;s:13:"module/latest";i:81;s:16:"module/pp_button";i:82;s:15:"module/pp_login";i:83;s:16:"module/slideshow";i:84;s:14:"module/special";i:85;s:12:"module/store";i:86;s:14:"openbay/amazon";i:87;s:22:"openbay/amazon_listing";i:88;s:22:"openbay/amazon_product";i:89;s:16:"openbay/amazonus";i:90;s:24:"openbay/amazonus_listing";i:91;s:24:"openbay/amazonus_product";i:92;s:12:"openbay/ebay";i:93;s:20:"openbay/ebay_profile";i:94;s:21:"openbay/ebay_template";i:95;s:12:"openbay/etsy";i:96;s:20:"openbay/etsy_product";i:97;s:21:"openbay/etsy_shipping";i:98;s:17:"openbay/etsy_shop";i:99;s:23:"payment/amazon_checkout";i:100;s:24:"payment/authorizenet_aim";i:101;s:24:"payment/authorizenet_sim";i:102;s:21:"payment/bank_transfer";i:103;s:22:"payment/bluepay_hosted";i:104;s:24:"payment/bluepay_redirect";i:105;s:14:"payment/cheque";i:106;s:11:"payment/cod";i:107;s:17:"payment/firstdata";i:108;s:24:"payment/firstdata_remote";i:109;s:21:"payment/free_checkout";i:110;s:22:"payment/klarna_account";i:111;s:22:"payment/klarna_invoice";i:112;s:14:"payment/liqpay";i:113;s:14:"payment/nochex";i:114;s:15:"payment/paymate";i:115;s:16:"payment/paypoint";i:116;s:13:"payment/payza";i:117;s:26:"payment/perpetual_payments";i:118;s:18:"payment/pp_express";i:119;s:18:"payment/pp_payflow";i:120;s:25:"payment/pp_payflow_iframe";i:121;s:14:"payment/pp_pro";i:122;s:21:"payment/pp_pro_iframe";i:123;s:19:"payment/pp_standard";i:124;s:14:"payment/realex";i:125;s:21:"payment/realex_remote";i:126;s:22:"payment/sagepay_direct";i:127;s:22:"payment/sagepay_server";i:128;s:18:"payment/sagepay_us";i:129;s:24:"payment/securetrading_pp";i:130;s:24:"payment/securetrading_ws";i:131;s:14:"payment/skrill";i:132;s:19:"payment/twocheckout";i:133;s:28:"payment/web_payment_software";i:134;s:16:"payment/worldpay";i:135;s:16:"report/affiliate";i:136;s:25:"report/affiliate_activity";i:137;s:22:"report/affiliate_login";i:138;s:24:"report/customer_activity";i:139;s:22:"report/customer_credit";i:140;s:21:"report/customer_login";i:141;s:22:"report/customer_online";i:142;s:21:"report/customer_order";i:143;s:22:"report/customer_reward";i:144;s:16:"report/marketing";i:145;s:24:"report/product_purchased";i:146;s:21:"report/product_viewed";i:147;s:18:"report/sale_coupon";i:148;s:17:"report/sale_order";i:149;s:18:"report/sale_return";i:150;s:20:"report/sale_shipping";i:151;s:15:"report/sale_tax";i:152;s:17:"sale/custom_field";i:153;s:13:"sale/customer";i:154;s:20:"sale/customer_ban_ip";i:155;s:19:"sale/customer_group";i:156;s:10:"sale/order";i:157;s:14:"sale/recurring";i:158;s:11:"sale/return";i:159;s:12:"sale/voucher";i:160;s:18:"sale/voucher_theme";i:161;s:15:"setting/setting";i:162;s:13:"setting/store";i:163;s:16:"shipping/auspost";i:164;s:17:"shipping/citylink";i:165;s:14:"shipping/fedex";i:166;s:13:"shipping/flat";i:167;s:13:"shipping/free";i:168;s:13:"shipping/item";i:169;s:23:"shipping/parcelforce_48";i:170;s:15:"shipping/pickup";i:171;s:19:"shipping/royal_mail";i:172;s:12:"shipping/ups";i:173;s:13:"shipping/usps";i:174;s:15:"shipping/weight";i:175;s:11:"tool/backup";i:176;s:14:"tool/error_log";i:177;s:11:"tool/upload";i:178;s:12:"total/coupon";i:179;s:12:"total/credit";i:180;s:14:"total/handling";i:181;s:16:"total/klarna_fee";i:182;s:19:"total/low_order_fee";i:183;s:12:"total/reward";i:184;s:14:"total/shipping";i:185;s:15:"total/sub_total";i:186;s:9:"total/tax";i:187;s:11:"total/total";i:188;s:13:"total/voucher";i:189;s:8:"user/api";i:190;s:9:"user/user";i:191;s:20:"user/user_permission";i:192;s:14:"module/buyshop";i:193;s:14:"module/buyshop";i:194;s:14:"module/buyshop";i:195;s:14:"module/buyshop";i:196;s:14:"module/buyshop";i:197;s:14:"module/buyshop";i:198;s:14:"module/buyshop";i:199;s:14:"module/buyshop";i:200;s:14:"module/buyshop";i:201;s:11:"module/html";i:202;s:15:"module/category";i:203;s:31:"module/dresscode_featured_multi";i:204;s:15:"module/featured";i:205;s:31:"module/dresscode_featured_multi";i:206;s:14:"module/account";i:207;s:11:"module/blog";i:208;s:11:"module/blog";i:209;s:13:"blog/category";i:210;s:12:"blog/comment";i:211;s:9:"blog/post";i:212;s:9:"blog/roll";i:213;s:13:"blog/settings";i:214;s:20:"blog/rss_feed_import";i:215;s:9:"blog/tags";i:216;s:14:"video/settings";}s:6:"modify";a:217:{i:0;s:17:"catalog/attribute";i:1;s:23:"catalog/attribute_group";i:2;s:17:"catalog/bcategory";i:3;s:16:"catalog/bproduct";i:4;s:16:"catalog/category";i:5;s:16:"catalog/download";i:6;s:14:"catalog/filter";i:7;s:19:"catalog/information";i:8;s:20:"catalog/manufacturer";i:9;s:17:"catalog/mcategory";i:10;s:14:"catalog/option";i:11;s:15:"catalog/product";i:12;s:17:"catalog/recurring";i:13;s:14:"catalog/review";i:14;s:18:"common/column_left";i:15;s:18:"common/filemanager";i:16;s:11:"common/menu";i:17;s:14:"common/profile";i:18;s:12:"common/stats";i:19;s:18:"dashboard/activity";i:20;s:15:"dashboard/chart";i:21;s:18:"dashboard/customer";i:22;s:13:"dashboard/map";i:23;s:16:"dashboard/online";i:24;s:15:"dashboard/order";i:25;s:16:"dashboard/recent";i:26;s:14:"dashboard/sale";i:27;s:13:"design/banner";i:28;s:13:"design/layout";i:29;s:14:"extension/feed";i:30;s:19:"extension/installer";i:31;s:22:"extension/modification";i:32;s:16:"extension/module";i:33;s:17:"extension/openbay";i:34;s:17:"extension/payment";i:35;s:18:"extension/shipping";i:36;s:15:"extension/total";i:37;s:16:"feed/google_base";i:38;s:19:"feed/google_sitemap";i:39;s:15:"feed/openbaypro";i:40;s:20:"localisation/country";i:41;s:21:"localisation/currency";i:42;s:21:"localisation/geo_zone";i:43;s:21:"localisation/language";i:44;s:25:"localisation/length_class";i:45;s:21:"localisation/location";i:46;s:25:"localisation/order_status";i:47;s:26:"localisation/return_action";i:48;s:26:"localisation/return_reason";i:49;s:26:"localisation/return_status";i:50;s:25:"localisation/stock_status";i:51;s:22:"localisation/tax_class";i:52;s:21:"localisation/tax_rate";i:53;s:25:"localisation/weight_class";i:54;s:17:"localisation/zone";i:55;s:19:"marketing/affiliate";i:56;s:17:"marketing/contact";i:57;s:16:"marketing/coupon";i:58;s:19:"marketing/marketing";i:59;s:14:"module/account";i:60;s:16:"module/affiliate";i:61;s:20:"module/amazon_button";i:62;s:13:"module/banner";i:63;s:17:"module/bestseller";i:64;s:14:"module/buyshop";i:65;s:15:"module/carousel";i:66;s:15:"module/category";i:67;s:27:"module/dresscode_bestseller";i:68;s:32:"module/dresscode_custom_menu_box";i:69;s:35:"module/dresscode_custom_product_box";i:70;s:25:"module/dresscode_featured";i:71;s:31:"module/dresscode_featured_multi";i:72;s:23:"module/dresscode_latest";i:73;s:24:"module/dresscode_special";i:74;s:19:"module/ebay_listing";i:75;s:15:"module/featured";i:76;s:13:"module/filter";i:77;s:22:"module/google_hangouts";i:78;s:11:"module/html";i:79;s:18:"module/information";i:80;s:13:"module/latest";i:81;s:16:"module/pp_button";i:82;s:15:"module/pp_login";i:83;s:16:"module/slideshow";i:84;s:14:"module/special";i:85;s:12:"module/store";i:86;s:14:"openbay/amazon";i:87;s:22:"openbay/amazon_listing";i:88;s:22:"openbay/amazon_product";i:89;s:16:"openbay/amazonus";i:90;s:24:"openbay/amazonus_listing";i:91;s:24:"openbay/amazonus_product";i:92;s:12:"openbay/ebay";i:93;s:20:"openbay/ebay_profile";i:94;s:21:"openbay/ebay_template";i:95;s:12:"openbay/etsy";i:96;s:20:"openbay/etsy_product";i:97;s:21:"openbay/etsy_shipping";i:98;s:17:"openbay/etsy_shop";i:99;s:23:"payment/amazon_checkout";i:100;s:24:"payment/authorizenet_aim";i:101;s:24:"payment/authorizenet_sim";i:102;s:21:"payment/bank_transfer";i:103;s:22:"payment/bluepay_hosted";i:104;s:24:"payment/bluepay_redirect";i:105;s:14:"payment/cheque";i:106;s:11:"payment/cod";i:107;s:17:"payment/firstdata";i:108;s:24:"payment/firstdata_remote";i:109;s:21:"payment/free_checkout";i:110;s:22:"payment/klarna_account";i:111;s:22:"payment/klarna_invoice";i:112;s:14:"payment/liqpay";i:113;s:14:"payment/nochex";i:114;s:15:"payment/paymate";i:115;s:16:"payment/paypoint";i:116;s:13:"payment/payza";i:117;s:26:"payment/perpetual_payments";i:118;s:18:"payment/pp_express";i:119;s:18:"payment/pp_payflow";i:120;s:25:"payment/pp_payflow_iframe";i:121;s:14:"payment/pp_pro";i:122;s:21:"payment/pp_pro_iframe";i:123;s:19:"payment/pp_standard";i:124;s:14:"payment/realex";i:125;s:21:"payment/realex_remote";i:126;s:22:"payment/sagepay_direct";i:127;s:22:"payment/sagepay_server";i:128;s:18:"payment/sagepay_us";i:129;s:24:"payment/securetrading_pp";i:130;s:24:"payment/securetrading_ws";i:131;s:14:"payment/skrill";i:132;s:19:"payment/twocheckout";i:133;s:28:"payment/web_payment_software";i:134;s:16:"payment/worldpay";i:135;s:16:"report/affiliate";i:136;s:25:"report/affiliate_activity";i:137;s:22:"report/affiliate_login";i:138;s:24:"report/customer_activity";i:139;s:22:"report/customer_credit";i:140;s:21:"report/customer_login";i:141;s:22:"report/customer_online";i:142;s:21:"report/customer_order";i:143;s:22:"report/customer_reward";i:144;s:16:"report/marketing";i:145;s:24:"report/product_purchased";i:146;s:21:"report/product_viewed";i:147;s:18:"report/sale_coupon";i:148;s:17:"report/sale_order";i:149;s:18:"report/sale_return";i:150;s:20:"report/sale_shipping";i:151;s:15:"report/sale_tax";i:152;s:17:"sale/custom_field";i:153;s:13:"sale/customer";i:154;s:20:"sale/customer_ban_ip";i:155;s:19:"sale/customer_group";i:156;s:10:"sale/order";i:157;s:14:"sale/recurring";i:158;s:11:"sale/return";i:159;s:12:"sale/voucher";i:160;s:18:"sale/voucher_theme";i:161;s:15:"setting/setting";i:162;s:13:"setting/store";i:163;s:16:"shipping/auspost";i:164;s:17:"shipping/citylink";i:165;s:14:"shipping/fedex";i:166;s:13:"shipping/flat";i:167;s:13:"shipping/free";i:168;s:13:"shipping/item";i:169;s:23:"shipping/parcelforce_48";i:170;s:15:"shipping/pickup";i:171;s:19:"shipping/royal_mail";i:172;s:12:"shipping/ups";i:173;s:13:"shipping/usps";i:174;s:15:"shipping/weight";i:175;s:11:"tool/backup";i:176;s:14:"tool/error_log";i:177;s:11:"tool/upload";i:178;s:12:"total/coupon";i:179;s:12:"total/credit";i:180;s:14:"total/handling";i:181;s:16:"total/klarna_fee";i:182;s:19:"total/low_order_fee";i:183;s:12:"total/reward";i:184;s:14:"total/shipping";i:185;s:15:"total/sub_total";i:186;s:9:"total/tax";i:187;s:11:"total/total";i:188;s:13:"total/voucher";i:189;s:8:"user/api";i:190;s:9:"user/user";i:191;s:20:"user/user_permission";i:192;s:14:"module/buyshop";i:193;s:14:"module/buyshop";i:194;s:14:"module/buyshop";i:195;s:14:"module/buyshop";i:196;s:14:"module/buyshop";i:197;s:14:"module/buyshop";i:198;s:14:"module/buyshop";i:199;s:14:"module/buyshop";i:200;s:14:"module/buyshop";i:201;s:11:"module/html";i:202;s:15:"module/category";i:203;s:31:"module/dresscode_featured_multi";i:204;s:15:"module/featured";i:205;s:31:"module/dresscode_featured_multi";i:206;s:14:"module/account";i:207;s:11:"module/blog";i:208;s:11:"module/blog";i:209;s:13:"blog/category";i:210;s:12:"blog/comment";i:211;s:9:"blog/post";i:212;s:9:"blog/roll";i:213;s:13:"blog/settings";i:214;s:20:"blog/rss_feed_import";i:215;s:9:"blog/tags";i:216;s:14:"video/settings";}}' WHERE `name` = 'Administrator';

UPDATE ?:category SET `top` = 0 WHERE `category_id` = 18;
UPDATE ?:category SET `top` = 0 WHERE `category_id` = 24;
UPDATE ?:category SET `top` = 0 WHERE `category_id` = 34;
UPDATE ?:category SET `top` = 0 WHERE `category_id` = 57;
UPDATE ?:category SET `top` = 0 WHERE `category_id` = 33;
UPDATE ?:category SET `top` = 0 WHERE `category_id` = 17;

UPDATE ?:category_description SET `name` = 'Woman' WHERE `category_id` = 20;
UPDATE ?:category_description SET `name` = 'Men' WHERE `category_id` = 25;

DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'buyshop';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'filter';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'dresscode_special';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'dresscode_bestseller';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'dresscode_latest';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'dresscode_featured';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'html';
DELETE FROM ?:extension WHERE `type` = 'module' AND `code` = 'banner';

INSERT INTO ?:extension (`extension_id`, `type`, `code`) VALUES
(null, 'module', 'filter'),
(null, 'module', 'dresscode_special'),
(null, 'module', 'dresscode_bestseller'),
(null, 'module', 'dresscode_latest'),
(null, 'module', 'dresscode_featured'),
(null, 'module', 'html'),
(null, 'module', 'banner'),
(null, 'module', 'carousel'),
(null, 'module', 'category');

DELETE FROM ?:setting WHERE `code` = 'buyshop';
DELETE FROM ?:setting WHERE `code` = 'filter';
DELETE FROM ?:setting WHERE `code` = 'account';
DELETE FROM ?:setting WHERE `code` = 'category';
DELETE FROM ?:setting WHERE `code` = 'carousel';

INSERT INTO ?:setting VALUES
(null, 0, 'category', 'category_status', '1', 0),
(null, 0, 'filter', 'filter_status', '1', 0),
(null, 0, 'account', 'account_status', '1', 0),

(null, 0, 'buyshop', 'buyshop_general', 'a:10:{i:1;a:2:{s:16:"footer_copyright";a:2:{i:0;s:138:"&amp;copy; 2015 DRESSCODE. All Rights Reserved.&lt;br&gt; Designed by &lt;a href=&quot;index.php&quot;&gt;ETHEMEUK.COM&lt;/a&gt;&lt;br&gt;";i:1;s:0:"";}s:16:"customblock_html";a:2:{i:0;s:907:"&lt;div&gt;\r\n    &lt;h3&gt;CONTACT INFO&lt;/h3&gt;\r\n    &lt;p class=&quot;clearfix contact_phone&quot;&gt;\r\n        &lt;strong&gt;Contact phone:&lt;/strong&gt;&lt;br&gt;\r\n        321321321,  321321321\r\n    &lt;/p&gt;\r\n    &lt;p class=&quot;clearfix contact_cell_phone&quot;&gt;\r\n        &lt;strong&gt;CELL phone:&lt;/strong&gt;&lt;br&gt;\r\n        321321321,  321321321\r\n    &lt;/p&gt;\r\n    &lt;p class=&quot;clearfix contact_addresses&quot;&gt;\r\n        &lt;strong&gt;E-mail addresses:&lt;/strong&gt;&lt;br&gt;\r\n        &lt;a href=&quot;mailto:sales@mydomain.com&quot;&gt;sales@mydomain.com&lt;/a&gt;&lt;br&gt;\r\n        &lt;a href=&quot;mailto:info@mydomain.com&quot;&gt;info@mydomain.com&lt;/a&gt;\r\n    &lt;/p&gt;\r\n    &lt;p class=&quot;clearfix contact_skype&quot;&gt;\r\n        &lt;strong&gt;SKYPE:&lt;/strong&gt;&lt;br&gt;\r\n        test.shop, shop.test                    \r\n    &lt;/p&gt;\r\n&lt;/div&gt;\r\n";i:1;s:0:"";}}s:4:"font";a:2:{i:0;s:1:"-";i:1;s:1:"-";}s:9:"bgpattern";a:1:{i:0;s:1:"0";}s:10:"themecolor";a:2:{i:0;s:0:"";i:1;s:0:"";}s:14:"contentbgcolor";a:2:{i:0;s:0:"";i:1;s:0:"";}s:9:"fontcolor";a:2:{i:0;s:0:"";i:1;s:0:"";}s:15:"productrollover";a:1:{i:0;s:1:"1";}s:8:"ajaxcart";a:1:{i:0;s:1:"1";}s:8:"response";a:1:{i:0;s:1:"1";}s:9:"blog_link";a:1:{i:0;s:1:"0";}}', 1),
(null, 0, 'buyshop', 'buyshop_social', 'a:6:{s:6:"apikey";a:2:{i:0;s:0:"";i:1;s:0:"";}s:14:"list_unique_id";a:2:{i:0;s:0:"";i:1;s:0:"";}i:1;a:3:{s:22:"newsletter_placeholder";a:2:{i:0;s:17:"NEWSLETTER SIGNUP";i:1;s:0:"";}s:13:"twitter_title";a:2:{i:0;s:13:"TWITTER FEEDS";i:1;s:0:"";}s:14:"facebook_title";a:2:{i:0;s:8:"FACEBOOK";i:1;s:0:"";}}s:17:"newsletter_status";a:1:{i:0;s:1:"1";}s:7:"twitter";a:2:{i:0;s:11:"themeforest";i:1;s:0:"";}s:8:"facebook";a:2:{i:0;s:11:"themeforest";i:1;s:0:"";}}', 1),
(null, 0, 'buyshop', 'buyshop_productlabels', 'a:4:{s:4:"sale";a:1:{i:0;s:1:"1";}s:12:"saleposition";a:2:{i:0;s:8:"top_left";i:1;s:8:"top_left";}s:5:"video";a:1:{i:0;s:1:"1";}s:13:"videoposition";a:2:{i:0;s:9:"top_right";i:1;s:8:"top_left";}}', 1),

(null, 0, 'config', 'config_telephone', '1 (234) 5678900', 0),
(null, 0, 'dresscode_featured', 'dresscode_featured_product', '33', 0);


DELETE FROM ?:module;
INSERT INTO ?:module (`module_id`, `name`, `code`, `setting`) VALUES
(34, 'Home Page', 'dresscode_bestseller', 'a:5:{s:4:"name";s:9:"Home Page";s:5:"limit";s:1:"5";s:5:"width";s:3:"329";s:6:"height";s:3:"418";s:6:"status";s:1:"1";}'),
(35, 'Home Page', 'dresscode_special', 'a:5:{s:4:"name";s:9:"Home Page";s:5:"limit";s:1:"5";s:5:"width";s:3:"329";s:6:"height";s:3:"418";s:6:"status";s:1:"1";}'),
(36, 'Home Page', 'dresscode_latest', 'a:5:{s:4:"name";s:9:"Home Page";s:5:"limit";s:1:"5";s:5:"width";s:3:"329";s:6:"height";s:3:"418";s:6:"status";s:1:"1";}'),
(37, 'Home Page Top Slider', 'banner', 'a:5:{s:4:"name";s:20:"Home Page Top Slider";s:9:"banner_id";s:3:"100";s:5:"width";s:3:"900";s:6:"height";s:3:"484";s:6:"status";s:1:"1";}'),
(39, 'Home Page', 'dresscode_featured', 'a:6:{s:4:"name";s:9:"Home Page";s:26:"dresscode_featured_product";a:1:{i:0;s:2:"42";}s:5:"limit";s:1:"1";s:5:"width";s:3:"280";s:6:"height";s:3:"356";s:6:"status";s:1:"1";}'),
(40, 'Category Page', 'featured', 'a:6:{s:4:"name";s:8:"Category";s:7:"product";a:1:{i:0;s:2:"42";}s:5:"limit";s:1:"5";s:5:"width";s:3:"258";s:6:"height";s:3:"356";s:6:"status";s:1:"1";}'),
(41, 'Product Page', 'html', 'a:3:{s:4:"name";s:12:"Product Page";s:18:"module_description";a:1:{i:1;a:2:{s:5:"title";s:0:"";s:11:"description";s:2209:"&lt;div class=&quot;custom_block&quot;&gt;\r\n    &lt;h2 class=&quot;aligncenter&quot;&gt;PRODUCT CUSTOM BLOCK&lt;/h2&gt;\r\n    &lt;p class=&quot;aligncenter&quot;&gt;You can add your content here, like&lt;br&gt; promotions &lt;br&gt;or some additional info &lt;/p&gt;\r\n    &lt;div class=&quot;promo_box&quot;&gt;\r\n        &lt;div class=&quot;pull-left&quot;&gt;\r\n            &lt;div class=&quot;icon-stack&quot;&gt; &lt;i class=&quot;icon-circle icon-stack-base&quot;&gt;&amp;nbsp;&lt;/i&gt; &lt;i class=&quot;icon-gift icon-light&quot;&gt;&amp;nbsp;&lt;/i&gt; &lt;/div&gt;\r\n        &lt;/div&gt;\r\n        &lt;span&gt;&lt;a href=&quot;index.php&quot;&gt;Special offer: 1+1=3&lt;/a&gt; &lt;a href=&quot;3&quot;&gt;&lt;br&gt;Get a gift!&lt;/a&gt;&lt;/span&gt;\r\n    &lt;/div&gt;\r\n    &lt;div class=&quot;promo_box&quot;&gt;\r\n        &lt;div class=&quot;pull-left&quot;&gt;\r\n            &lt;div class=&quot;icon-stack&quot;&gt; &lt;i class=&quot;icon-circle icon-stack-base&quot;&gt;&lt;/i&gt; &lt;i class=&quot;icon-credit-card icon-light&quot;&gt;&amp;nbsp;&lt;/i&gt; &lt;/div&gt;\r\n        &lt;/div&gt;\r\n        &lt;span&gt; &lt;a href=&quot;index.php&quot;&gt;Free Reward Card&lt;/a&gt; &lt;a href=&quot;3&quot;&gt;&lt;br&gt;Worth $10, $50, $100.&lt;/a&gt;&lt;/span&gt;\r\n    &lt;/div&gt;\r\n    &lt;div class=&quot;promo_box&quot;&gt;\r\n        &lt;div class=&quot;pull-left&quot;&gt;\r\n            &lt;div class=&quot;icon-stack&quot;&gt; &lt;i class=&quot;icon-circle icon-stack-base&quot;&gt;&amp;nbsp;&lt;/i&gt; &lt;i class=&quot;icon-group icon-light&quot;&gt;&amp;nbsp;&lt;/i&gt; &lt;/div&gt;\r\n        &lt;/div&gt;\r\n        &lt;span&gt; &lt;a href=&quot;index.php&quot;&gt;Join to our Club&lt;/a&gt; &lt;/span&gt;\r\n    &lt;/div&gt;\r\n    &lt;div class=&quot;promo_box&quot;&gt;\r\n        &lt;div class=&quot;pull-left&quot;&gt;\r\n            &lt;div class=&quot;icon-stack&quot;&gt; &lt;i class=&quot;icon-circle icon-stack-base&quot;&gt;&amp;nbsp;&lt;/i&gt; &lt;i class=&quot;icon-truck icon-flip-horizontal icon-light&quot;&gt;&amp;nbsp;&lt;/i&gt; &lt;/div&gt;\r\n        &lt;/div&gt;\r\n        &lt;span&gt;&lt;a href=&quot;index.php&quot;&gt;Free shipping&lt;/a&gt;&lt;/span&gt;\r\n    &lt;/div&gt;\r\n\r\n&lt;/div&gt;\r\n";}}s:6:"status";s:1:"1";}'),
(42, 'Home Page', 'carousel', 'a:5:{s:4:"name";s:9:"Home Page";s:9:"banner_id";s:1:"8";s:5:"width";s:3:"130";s:6:"height";s:3:"100";s:6:"status";s:1:"1";}');


DELETE FROM ?:layout_module;
INSERT INTO ?:layout_module (`layout_module_id`, `layout_id`, `code`, `position`, `sort_order`) VALUES
(null, 1, 'dresscode_bestseller.34', 'content_bottom', 3),
(null, 1, 'dresscode_featured.39', 'content_footer', 1),
(null, 1, 'dresscode_special.35', 'content_bottom', 2),
(null, 1, 'dresscode_latest.36', 'content_bottom', 1),
(null, 1, 'banner.37', 'content_top', 1),
(null, 1, 'carousel.42', 'content_blog', 2),

(null, 2, 'dresscode_featured.39', 'content_footer', 1),
(null, 2, 'html.41', 'column_right', 1),

(null, 3, 'dresscode_featured.39', 'content_footer', 1),
(null, 3, 'filter', 'column_left', 2),
(null, 3, 'category', 'column_left', 1),

(null, 4, 'dresscode_featured.39', 'content_footer', 1),
(null, 4, 'category', 'column_left', 1),

(null, 5, 'category', 'column_left', 1),
(null, 5, 'dresscode_featured.39', 'content_footer', 1),

(null, 6, 'category', 'column_left', 2),
(null, 6, 'dresscode_featured.39', 'content_footer', 1),
(null, 6, 'account', 'column_left', 1),

(null, 7, 'dresscode_featured.39', 'content_footer', 1),

(null, 8, 'category', 'column_left', 1),
(null, 8, 'dresscode_featured.39', 'content_footer', 1),

(null, 9, 'category', 'column_left', 1),
(null, 9, 'dresscode_featured.39', 'content_footer', 1),

(null, 10, 'dresscode_featured.39', 'content_footer', 1),

(null, 11, 'dresscode_featured.39', 'content_footer', 1),

(null, 12, 'dresscode_featured.39', 'content_footer', 1),

(null, 13, 'category', 'column_left', 1),
(null, 13, 'dresscode_featured.39', 'content_footer', 1);




DELETE FROM ?:option WHERE `option_id` = 100;
DELETE FROM ?:option_description WHERE `option_id` = 100;
DELETE FROM ?:option_value WHERE `option_id` = 100;
DELETE FROM ?:option_value_description WHERE `option_id` = 100;
DELETE FROM ?:product_option WHERE `option_id` = 100;
DELETE FROM ?:product_option_value WHERE `option_id` = 100;

INSERT INTO ?:option (`option_id`, `type`, `sort_order`) VALUES
(100, 'image', 1);

INSERT INTO ?:option_description (`option_id`, `language_id`, `name`) VALUES
(100, 1, 'Colors');

INSERT INTO ?:option_value (`option_value_id`, `option_id`, `image`, `sort_order`) VALUES
(49, 100, 'catalog/colors/blue.jpg', 1),
(50, 100, 'catalog/colors/brown.jpg', 2),
(51, 100, 'catalog/colors/green.jpg', 3),
(52, 100, 'catalog/colors/red.jpg', 4),
(53, 100, 'catalog/colors/violet.jpg', 5);

INSERT INTO ?:option_value_description (`option_value_id`, `language_id`, `option_id`, `name`) VALUES
(49, 1, 100, 'blue'),
(50, 1, 100, 'brown'),
(51, 1, 100, 'green'),
(52, 1, 100, 'red'),
(53, 1, 100, 'violet');

DELETE FROM ?:product_option WHERE `product_id` = 28;
DELETE FROM ?:product_option WHERE `product_id` = 30;
DELETE FROM ?:product_option WHERE `product_id` = 40;
DELETE FROM ?:product_option WHERE `product_id` = 47;

INSERT INTO ?:product_option (`product_option_id`, `product_id`, `option_id`, `value`, `required`) VALUES
(227, 28, 100, '', 1),
(228, 30, 100, '', 1),
(229, 47, 100, '', 1),
(230, 40, 100, '', 1);

DELETE FROM ?:product_option_value WHERE `product_id` = 28;
DELETE FROM ?:product_option_value WHERE `product_id` = 30;
DELETE FROM ?:product_option_value WHERE `product_id` = 40;
DELETE FROM ?:product_option_value WHERE `product_id` = 47;

INSERT INTO ?:product_option_value (`product_option_value_id`, `product_option_id`, `product_id`, `option_id`, `option_value_id`, `quantity`, `subtract`, `price`, `price_prefix`, `points`, `points_prefix`, `weight`, `weight_prefix`) VALUES
(21, 227, 28, 100, 53, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(20, 227, 28, 100, 52, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(19, 227, 28, 100, 51, 10, 1, '0.0000', '-', 0, '+', '0.00000000', '+'),
(18, 227, 28, 100, 50, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(17, 227, 28, 100, 49, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),

(22, 228, 30, 100, 50, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(23, 228, 30, 100, 49, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),

(24, 229, 47, 100, 53, 10, 1, '5.00000000', '+', 0, '+', '0.00000000', '+'),
(25, 229, 47, 100, 52, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(26, 229, 47, 100, 51, 10, 1, '5.00000000', '-', 0, '+', '0.00000000', '+'),
(27, 229, 47, 100, 50, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),

(28, 230, 40, 100, 53, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(29, 230, 40, 100, 52, 10, 1, '5.00000000', '+', 0, '+', '0.00000000', '+'),
(30, 230, 40, 100, 51, 10, 1, '5.00000000', '-', 0, '+', '0.00000000', '+'),
(31, 230, 40, 100, 50, 10, 1, '0.0000', '+', 0, '+', '0.00000000', '+'),
(32, 230, 40, 100, 49, 10, 1, '5.00000000', '-', 0, '+', '0.00000000', '+');



