# ************************************************************
# Sequel Pro SQL dump
# Version 4135
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: 127.0.0.1 (MySQL 5.5.38)
# Database: venetian_blinds
# Generation Time: 2015-06-15 09:57:16 +0000
# ************************************************************




# Dump of table ven_blinds_commentmeta
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table ven_blinds_comments
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `comment_author` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`),
  KEY `comment_author_email` (`comment_author_email`(10))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_comments` (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`)
VALUES
	(1,1,'Mr WordPress','','https://wordpress.org/','','2015-05-28 16:04:52','2015-05-28 15:04:52','Hi, this is a comment.\nTo delete a comment, just log in and view the post&#039;s comments. There you will have the option to edit or delete them.',0,'1','','',0,0);



# Dump of table ven_blinds_links
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_links` (
  `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `link_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_target` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_visible` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
  `link_rating` int(11) NOT NULL DEFAULT '0',
  `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `link_rel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_notes` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_rss` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`),
  KEY `link_visible` (`link_visible`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table ven_blinds_options
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name` (`option_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1691 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;








# Dump of table ven_blinds_postmeta
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`)
VALUES
	(6,6,'_edit_last','1'),
	(7,6,'_edit_lock','1432828587:1'),
	(26,10,'_edit_last','1'),
	(27,10,'_edit_lock','1433519922:1'),
	(28,12,'_edit_last','1'),
	(29,12,'_edit_lock','1433521060:1'),
	(30,14,'_edit_last','1'),
	(31,14,'_edit_lock','1432900043:1'),
	(32,16,'_edit_last','1'),
	(33,16,'_edit_lock','1432900053:1'),
	(34,18,'_edit_last','1'),
	(35,18,'_edit_lock','1432900064:1'),
	(36,20,'_edit_last','1'),
	(37,20,'_edit_lock','1432900085:1'),
	(38,22,'_menu_item_type','post_type'),
	(39,22,'_menu_item_menu_item_parent','0'),
	(40,22,'_menu_item_object_id','20'),
	(41,22,'_menu_item_object','page'),
	(42,22,'_menu_item_target',''),
	(43,22,'_menu_item_classes','a:3:{i:0;s:26:\"lightblue-bg-sm-with-hover\";i:1;s:26:\"lightblue-bg-md-with-hover\";i:2;s:26:\"lightblue-bg-lg-with-hover\";}'),
	(44,22,'_menu_item_xfn',''),
	(45,22,'_menu_item_url',''),
	(47,23,'_menu_item_type','post_type'),
	(48,23,'_menu_item_menu_item_parent','0'),
	(49,23,'_menu_item_object_id','18'),
	(50,23,'_menu_item_object','page'),
	(51,23,'_menu_item_target',''),
	(52,23,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(53,23,'_menu_item_xfn',''),
	(54,23,'_menu_item_url',''),
	(56,24,'_menu_item_type','post_type'),
	(57,24,'_menu_item_menu_item_parent','0'),
	(58,24,'_menu_item_object_id','16'),
	(59,24,'_menu_item_object','page'),
	(60,24,'_menu_item_target',''),
	(61,24,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(62,24,'_menu_item_xfn',''),
	(63,24,'_menu_item_url',''),
	(65,25,'_menu_item_type','post_type'),
	(66,25,'_menu_item_menu_item_parent','0'),
	(67,25,'_menu_item_object_id','14'),
	(68,25,'_menu_item_object','page'),
	(69,25,'_menu_item_target',''),
	(70,25,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(71,25,'_menu_item_xfn',''),
	(72,25,'_menu_item_url',''),
	(74,26,'_menu_item_type','post_type'),
	(75,26,'_menu_item_menu_item_parent','0'),
	(76,26,'_menu_item_object_id','12'),
	(77,26,'_menu_item_object','page'),
	(78,26,'_menu_item_target',''),
	(79,26,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(80,26,'_menu_item_xfn',''),
	(81,26,'_menu_item_url',''),
	(83,27,'_menu_item_type','post_type'),
	(84,27,'_menu_item_menu_item_parent','0'),
	(85,27,'_menu_item_object_id','10'),
	(86,27,'_menu_item_object','page'),
	(87,27,'_menu_item_target',''),
	(88,27,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(89,27,'_menu_item_xfn',''),
	(90,27,'_menu_item_url',''),
	(91,28,'_menu_item_type','post_type'),
	(92,28,'_menu_item_menu_item_parent','0'),
	(93,28,'_menu_item_object_id','20'),
	(94,28,'_menu_item_object','page'),
	(95,28,'_menu_item_target',''),
	(96,28,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(97,28,'_menu_item_xfn',''),
	(98,28,'_menu_item_url',''),
	(100,29,'_menu_item_type','post_type'),
	(101,29,'_menu_item_menu_item_parent','0'),
	(102,29,'_menu_item_object_id','18'),
	(103,29,'_menu_item_object','page'),
	(104,29,'_menu_item_target',''),
	(105,29,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(106,29,'_menu_item_xfn',''),
	(107,29,'_menu_item_url',''),
	(109,30,'_menu_item_type','post_type'),
	(110,30,'_menu_item_menu_item_parent','0'),
	(111,30,'_menu_item_object_id','16'),
	(112,30,'_menu_item_object','page'),
	(113,30,'_menu_item_target',''),
	(114,30,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(115,30,'_menu_item_xfn',''),
	(116,30,'_menu_item_url',''),
	(118,31,'_menu_item_type','post_type'),
	(119,31,'_menu_item_menu_item_parent','0'),
	(120,31,'_menu_item_object_id','14'),
	(121,31,'_menu_item_object','page'),
	(122,31,'_menu_item_target',''),
	(123,31,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(124,31,'_menu_item_xfn',''),
	(125,31,'_menu_item_url',''),
	(127,32,'_menu_item_type','post_type'),
	(128,32,'_menu_item_menu_item_parent','0'),
	(129,32,'_menu_item_object_id','12'),
	(130,32,'_menu_item_object','page'),
	(131,32,'_menu_item_target',''),
	(132,32,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(133,32,'_menu_item_xfn',''),
	(134,32,'_menu_item_url',''),
	(136,33,'_menu_item_type','post_type'),
	(137,33,'_menu_item_menu_item_parent','0'),
	(138,33,'_menu_item_object_id','10'),
	(139,33,'_menu_item_object','page'),
	(140,33,'_menu_item_target',''),
	(141,33,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(142,33,'_menu_item_xfn',''),
	(143,33,'_menu_item_url',''),
	(145,34,'_edit_last','1'),
	(146,34,'_edit_lock','1433521252:1'),
	(151,37,'_wp_attached_file','2015/06/340x230.gif'),
	(152,37,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:340;s:6:\"height\";i:230;s:4:\"file\";s:19:\"2015/06/340x230.gif\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:19:\"340x230-150x150.gif\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/gif\";}s:6:\"medium\";a:4:{s:4:\"file\";s:19:\"340x230-300x203.gif\";s:5:\"width\";i:300;s:6:\"height\";i:203;s:9:\"mime-type\";s:9:\"image/gif\";}}s:10:\"image_meta\";a:11:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";s:11:\"orientation\";i:0;}}'),
	(153,34,'_thumbnail_id','37'),
	(156,1,'_edit_lock','1433240652:1'),
	(157,1,'_thumbnail_id','37'),
	(158,1,'_edit_last','1'),
	(169,50,'_edit_last','1'),
	(170,50,'_edit_lock','1434028851:1'),
	(171,50,'_visibility','visible'),
	(172,50,'_stock_status','instock'),
	(173,50,'total_sales','0'),
	(174,50,'_downloadable','no'),
	(175,50,'_virtual','no'),
	(176,50,'_regular_price',''),
	(177,50,'_sale_price','9.99'),
	(178,50,'_purchase_note',''),
	(179,50,'_featured','no'),
	(180,50,'_weight',''),
	(181,50,'_length',''),
	(182,50,'_width',''),
	(183,50,'_height',''),
	(184,50,'_sku','3454'),
	(185,50,'_product_attributes','a:0:{}'),
	(186,50,'_sale_price_dates_from',''),
	(187,50,'_sale_price_dates_to',''),
	(188,50,'_price','9.99'),
	(189,50,'_sold_individually',''),
	(190,50,'_manage_stock','no'),
	(191,50,'_backorders','no'),
	(192,50,'_stock',''),
	(193,50,'_upsell_ids','a:0:{}'),
	(194,50,'_crosssell_ids','a:0:{}'),
	(195,50,'_product_image_gallery',''),
	(196,51,'_edit_last','1'),
	(197,51,'_edit_lock','1433513813:1'),
	(198,53,'_menu_item_type','post_type'),
	(199,53,'_menu_item_menu_item_parent','0'),
	(200,53,'_menu_item_object_id','51'),
	(201,53,'_menu_item_object','page'),
	(202,53,'_menu_item_target',''),
	(203,53,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(204,53,'_menu_item_xfn',''),
	(205,53,'_menu_item_url',''),
	(207,54,'_menu_item_type','post_type'),
	(208,54,'_menu_item_menu_item_parent','0'),
	(209,54,'_menu_item_object_id','51'),
	(210,54,'_menu_item_object','page'),
	(211,54,'_menu_item_target',''),
	(212,54,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(213,54,'_menu_item_xfn',''),
	(214,54,'_menu_item_url',''),
	(216,55,'_menu_item_type','post_type'),
	(217,55,'_menu_item_menu_item_parent','0'),
	(218,55,'_menu_item_object_id','47'),
	(219,55,'_menu_item_object','page'),
	(220,55,'_menu_item_target',''),
	(221,55,'_menu_item_classes','a:1:{i:0;s:0:\"\";}'),
	(222,55,'_menu_item_xfn',''),
	(223,55,'_menu_item_url',''),
	(224,55,'_menu_item_orphaned','1433336594'),
	(235,48,'_edit_lock','1433345283:1'),
	(236,47,'_edit_lock','1433343999:1'),
	(237,50,'_tax_status','taxable'),
	(238,50,'_tax_class',''),
	(239,61,'_wp_attached_file','2015/06/product-placeholder.png'),
	(240,61,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:220;s:6:\"height\";i:218;s:4:\"file\";s:31:\"2015/06/product-placeholder.png\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:31:\"product-placeholder-150x150.png\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/png\";}s:14:\"shop_thumbnail\";a:4:{s:4:\"file\";s:31:\"product-placeholder-180x180.png\";s:5:\"width\";i:180;s:6:\"height\";i:180;s:9:\"mime-type\";s:9:\"image/png\";}}s:10:\"image_meta\";a:11:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";s:11:\"orientation\";i:0;}}'),
	(241,50,'_thumbnail_id','61'),
	(242,51,'_wp_page_template','templates/template-product-category.php'),
	(243,10,'_wp_page_template','templates/template-product-category.php'),
	(244,63,'_edit_last','1'),
	(245,63,'_edit_lock','1434361787:1'),
	(247,63,'_visibility','visible'),
	(248,63,'_stock_status','instock'),
	(250,63,'_downloadable','no'),
	(251,63,'_virtual','no'),
	(252,63,'_regular_price',''),
	(253,63,'_sale_price','48.99'),
	(254,63,'_tax_status','taxable'),
	(255,63,'_tax_class',''),
	(256,63,'_purchase_note',''),
	(257,63,'_featured','no'),
	(258,63,'_weight',''),
	(259,63,'_length',''),
	(260,63,'_width',''),
	(261,63,'_height',''),
	(262,63,'_sku','1234'),
	(263,63,'_product_attributes','a:3:{s:19:\"venetian-slat-width\";a:6:{s:4:\"name\";s:19:\"Venetian Slat Width\";s:5:\"value\";s:4:\"25mm\";s:8:\"position\";s:1:\"0\";s:10:\"is_visible\";i:1;s:12:\"is_variation\";i:0;s:11:\"is_taxonomy\";i:0;}s:12:\"measurements\";a:6:{s:4:\"name\";s:12:\"Measurements\";s:5:\"value\";s:21:\"Width 26cm\r\nDrop 20cm\";s:8:\"position\";s:1:\"1\";s:10:\"is_visible\";i:1;s:12:\"is_variation\";i:0;s:11:\"is_taxonomy\";i:0;}s:12:\"fitting-type\";a:6:{s:4:\"name\";s:12:\"Fitting Type\";s:5:\"value\";s:45:\"Exact - fitting your blind outside the window\";s:8:\"position\";s:1:\"2\";s:10:\"is_visible\";i:1;s:12:\"is_variation\";i:0;s:11:\"is_taxonomy\";i:0;}}'),
	(264,63,'_sale_price_dates_from',''),
	(265,63,'_sale_price_dates_to',''),
	(266,63,'_price','48.99'),
	(267,63,'_sold_individually',''),
	(268,63,'_manage_stock','no'),
	(269,63,'_backorders','no'),
	(270,63,'_stock',''),
	(271,63,'_upsell_ids','a:0:{}'),
	(272,63,'_crosssell_ids','a:0:{}'),
	(273,63,'_product_image_gallery','66,65,64'),
	(274,12,'_wp_page_template','templates/template-product-category.php'),
	(275,64,'_wp_attached_file','2015/06/Pleated_blinds_high_quality_low_price_export.jpg_220x220.jpg'),
	(276,64,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:220;s:6:\"height\";i:218;s:4:\"file\";s:68:\"2015/06/Pleated_blinds_high_quality_low_price_export.jpg_220x220.jpg\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:68:\"Pleated_blinds_high_quality_low_price_export.jpg_220x220-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:14:\"shop_thumbnail\";a:4:{s:4:\"file\";s:68:\"Pleated_blinds_high_quality_low_price_export.jpg_220x220-180x180.jpg\";s:5:\"width\";i:180;s:6:\"height\";i:180;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:11:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";s:11:\"orientation\";i:0;}}'),
	(277,65,'_wp_attached_file','2015/06/fabric-vertical-blinds22.jpg'),
	(278,65,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:220;s:6:\"height\";i:218;s:4:\"file\";s:36:\"2015/06/fabric-vertical-blinds22.jpg\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:36:\"fabric-vertical-blinds22-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:14:\"shop_thumbnail\";a:4:{s:4:\"file\";s:36:\"fabric-vertical-blinds22-180x180.jpg\";s:5:\"width\";i:180;s:6:\"height\";i:180;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:11:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";s:11:\"orientation\";i:0;}}'),
	(279,66,'_wp_attached_file','2015/06/Fast-shipping-100-Real-basswood-venetian-font-b-blinds-b-font-font-b-mini-b-font.jpg_220x220.jpg'),
	(280,66,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:220;s:6:\"height\";i:218;s:4:\"file\";s:104:\"2015/06/Fast-shipping-100-Real-basswood-venetian-font-b-blinds-b-font-font-b-mini-b-font.jpg_220x220.jpg\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:104:\"Fast-shipping-100-Real-basswood-venetian-font-b-blinds-b-font-font-b-mini-b-font.jpg_220x220-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:14:\"shop_thumbnail\";a:4:{s:4:\"file\";s:104:\"Fast-shipping-100-Real-basswood-venetian-font-b-blinds-b-font-font-b-mini-b-font.jpg_220x220-180x180.jpg\";s:5:\"width\";i:180;s:6:\"height\";i:180;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:11:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";s:11:\"orientation\";i:0;}}'),
	(285,69,'_wp_attached_file','2015/06/text.png'),
	(286,69,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:460;s:6:\"height\";i:281;s:4:\"file\";s:16:\"2015/06/text.png\";s:5:\"sizes\";a:4:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:16:\"text-150x150.png\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/png\";}s:6:\"medium\";a:4:{s:4:\"file\";s:16:\"text-300x183.png\";s:5:\"width\";i:300;s:6:\"height\";i:183;s:9:\"mime-type\";s:9:\"image/png\";}s:14:\"shop_thumbnail\";a:4:{s:4:\"file\";s:16:\"text-180x180.png\";s:5:\"width\";i:180;s:6:\"height\";i:180;s:9:\"mime-type\";s:9:\"image/png\";}s:12:\"shop_catalog\";a:4:{s:4:\"file\";s:16:\"text-300x281.png\";s:5:\"width\";i:300;s:6:\"height\";i:281;s:9:\"mime-type\";s:9:\"image/png\";}}s:10:\"image_meta\";a:11:{s:8:\"aperture\";i:0;s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:0;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";i:0;s:3:\"iso\";i:0;s:13:\"shutter_speed\";i:0;s:5:\"title\";s:0:\"\";s:11:\"orientation\";i:0;}}'),
	(287,63,'_thumbnail_id','69'),
	(292,63,'total_sales','0'),
	(295,72,'_edit_last','1'),
	(296,72,'field_557e9ddd097be','a:13:{s:3:\"key\";s:19:\"field_557e9ddd097be\";s:5:\"label\";s:8:\"Brackets\";s:4:\"name\";s:8:\"brackets\";s:4:\"type\";s:8:\"repeater\";s:12:\"instructions\";s:21:\"Add bracket locations\";s:8:\"required\";s:1:\"1\";s:10:\"sub_fields\";a:1:{i:0;a:13:{s:3:\"key\";s:19:\"field_557e9e23097bf\";s:5:\"label\";s:8:\"Location\";s:4:\"name\";s:8:\"location\";s:4:\"type\";s:4:\"text\";s:12:\"instructions\";s:0:\"\";s:12:\"column_width\";s:0:\"\";s:13:\"default_value\";s:0:\"\";s:11:\"placeholder\";s:0:\"\";s:7:\"prepend\";s:0:\"\";s:6:\"append\";s:0:\"\";s:10:\"formatting\";s:4:\"none\";s:9:\"maxlength\";s:0:\"\";s:8:\"order_no\";i:0;}}s:7:\"row_min\";s:1:\"1\";s:9:\"row_limit\";s:0:\"\";s:6:\"layout\";s:3:\"row\";s:12:\"button_label\";s:20:\"Add Bracket Location\";s:17:\"conditional_logic\";a:3:{s:6:\"status\";s:1:\"0\";s:5:\"rules\";a:1:{i:0;a:2:{s:5:\"field\";s:4:\"null\";s:8:\"operator\";s:2:\"==\";}}s:8:\"allorany\";s:3:\"all\";}s:8:\"order_no\";i:0;}'),
	(297,72,'rule','a:5:{s:5:\"param\";s:9:\"post_type\";s:8:\"operator\";s:2:\"==\";s:5:\"value\";s:7:\"product\";s:8:\"order_no\";i:0;s:8:\"group_no\";i:0;}'),
	(298,72,'position','normal'),
	(299,72,'layout','no_box'),
	(300,72,'hide_on_screen',''),
	(301,72,'_edit_lock','1434361603:1'),
	(302,63,'brackets_0_location','Top Fix'),
	(303,63,'_brackets_0_location','field_557e9e23097bf'),
	(304,63,'brackets','1'),
	(305,63,'_brackets','field_557e9ddd097be');



# Dump of table ven_blinds_posts
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_posts` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_excerpt` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_status` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'publish',
  `comment_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `ping_status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `post_password` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `post_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `to_ping` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pinged` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content_filtered` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `guid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `menu_order` int(11) NOT NULL DEFAULT '0',
  `post_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'post',
  `post_mime_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `post_name` (`post_name`(191)),
  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  KEY `post_parent` (`post_parent`),
  KEY `post_author` (`post_author`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`)
VALUES
	(1,1,'2015-05-28 16:04:52','2015-05-28 15:04:52','Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!','Hello world!','','publish','open','open','','hello-world','','','2015-06-02 10:51:52','2015-06-02 09:51:52','',0,'http://venetian-blinds.rcg-dev.com/?p=1',0,'post','',1),
	(6,1,'2015-05-28 16:58:16','2015-05-28 15:58:16','','Home','','publish','open','open','','home','','','2015-05-28 16:58:16','2015-05-28 15:58:16','',0,'http://venetian-blinds.rcg-dev.com/?page_id=6',0,'page','',0),
	(7,1,'2015-05-28 16:58:16','2015-05-28 15:58:16','','Home','','inherit','open','open','','6-revision-v1','','','2015-05-28 16:58:16','2015-05-28 15:58:16','',6,'http://venetian-blinds.rcg-dev.com/2015/05/28/6-revision-v1/',0,'revision','',0),
	(10,1,'2015-05-29 12:49:31','2015-05-29 11:49:31','','Wooden Venetian Blinds','','publish','open','closed','','wooden-venetian-blinds','','','2015-06-05 16:58:42','2015-06-05 15:58:42','',0,'http://venetian-blinds.rcg-dev.com/?page_id=10',0,'page','',0),
	(11,1,'2015-05-29 12:49:31','2015-05-29 11:49:31','','Wooden Venetian Blinds','','inherit','open','open','','10-revision-v1','','','2015-05-29 12:49:31','2015-05-29 11:49:31','',10,'http://venetian-blinds.rcg-dev.com/2015/05/10-revision-v1/',0,'revision','',0),
	(12,1,'2015-05-29 12:49:39','2015-05-29 11:49:39','','Perfect Fit','','publish','open','closed','','perfect-fit','','','2015-06-05 17:17:39','2015-06-05 16:17:39','',0,'http://venetian-blinds.rcg-dev.com/?page_id=12',0,'page','',0),
	(13,1,'2015-05-29 12:49:39','2015-05-29 11:49:39','','Perfect Fit','','inherit','open','open','','12-revision-v1','','','2015-05-29 12:49:39','2015-05-29 11:49:39','',12,'http://venetian-blinds.rcg-dev.com/2015/05/12-revision-v1/',0,'revision','',0),
	(14,1,'2015-05-29 12:49:47','2015-05-29 11:49:47','','Measure & Fit','','publish','open','open','','measure-fit','','','2015-05-29 12:49:47','2015-05-29 11:49:47','',0,'http://venetian-blinds.rcg-dev.com/?page_id=14',0,'page','',0),
	(15,1,'2015-05-29 12:49:47','2015-05-29 11:49:47','','Measure & Fit','','inherit','open','open','','14-revision-v1','','','2015-05-29 12:49:47','2015-05-29 11:49:47','',14,'http://venetian-blinds.rcg-dev.com/2015/05/14-revision-v1/',0,'revision','',0),
	(16,1,'2015-05-29 12:49:52','2015-05-29 11:49:52','','Blog','','publish','open','open','','blog','','','2015-05-29 12:49:52','2015-05-29 11:49:52','',0,'http://venetian-blinds.rcg-dev.com/?page_id=16',0,'page','',0),
	(17,1,'2015-05-29 12:49:52','2015-05-29 11:49:52','','Blog','','inherit','open','open','','16-revision-v1','','','2015-05-29 12:49:52','2015-05-29 11:49:52','',16,'http://venetian-blinds.rcg-dev.com/2015/05/16-revision-v1/',0,'revision','',0),
	(18,1,'2015-05-29 12:50:03','2015-05-29 11:50:03','','Why Us?','','publish','open','open','','why-us','','','2015-05-29 12:50:03','2015-05-29 11:50:03','',0,'http://venetian-blinds.rcg-dev.com/?page_id=18',0,'page','',0),
	(19,1,'2015-05-29 12:50:03','2015-05-29 11:50:03','','Why Us?','','inherit','open','open','','18-revision-v1','','','2015-05-29 12:50:03','2015-05-29 11:50:03','',18,'http://venetian-blinds.rcg-dev.com/2015/05/18-revision-v1/',0,'revision','',0),
	(20,1,'2015-05-29 12:50:13','2015-05-29 11:50:13','','Deals','','publish','open','closed','','deals','','','2015-05-29 12:50:28','2015-05-29 11:50:28','',0,'http://venetian-blinds.rcg-dev.com/?page_id=20',0,'page','',0),
	(21,1,'2015-05-29 12:50:24','2015-05-29 11:50:24','','Deals','','inherit','open','open','','20-revision-v1','','','2015-05-29 12:50:24','2015-05-29 11:50:24','',20,'http://venetian-blinds.rcg-dev.com/2015/05/20-revision-v1/',0,'revision','',0),
	(22,1,'2015-05-29 12:51:28','2015-05-29 11:51:28',' ','','','publish','open','open','','22','','','2015-06-03 11:43:26','2015-06-03 10:43:26','',0,'http://venetian-blinds.rcg-dev.com/?p=22',7,'nav_menu_item','',0),
	(23,1,'2015-05-29 12:51:28','2015-05-29 11:51:28',' ','','','publish','open','open','','23','','','2015-06-03 11:43:26','2015-06-03 10:43:26','',0,'http://venetian-blinds.rcg-dev.com/?p=23',6,'nav_menu_item','',0),
	(24,1,'2015-05-29 12:51:28','2015-05-29 11:51:28',' ','','','publish','open','open','','24','','','2015-06-03 11:43:26','2015-06-03 10:43:26','',0,'http://venetian-blinds.rcg-dev.com/?p=24',5,'nav_menu_item','',0),
	(25,1,'2015-05-29 12:51:28','2015-05-29 11:51:28',' ','','','publish','open','open','','25','','','2015-06-03 11:43:26','2015-06-03 10:43:26','',0,'http://venetian-blinds.rcg-dev.com/?p=25',4,'nav_menu_item','',0),
	(26,1,'2015-05-29 12:51:28','2015-05-29 11:51:28',' ','','','publish','open','open','','26','','','2015-06-03 11:43:26','2015-06-03 10:43:26','',0,'http://venetian-blinds.rcg-dev.com/?p=26',3,'nav_menu_item','',0),
	(27,1,'2015-05-29 12:51:28','2015-05-29 11:51:28',' ','','','publish','open','open','','27','','','2015-06-03 11:43:26','2015-06-03 10:43:26','',0,'http://venetian-blinds.rcg-dev.com/?p=27',2,'nav_menu_item','',0),
	(28,1,'2015-06-02 10:31:24','2015-06-02 09:31:24',' ','','','publish','open','open','','28','','','2015-06-03 11:42:56','2015-06-03 10:42:56','',0,'http://venetian-blinds.rcg-dev.com/?p=28',7,'nav_menu_item','',0),
	(29,1,'2015-06-02 10:31:24','2015-06-02 09:31:24',' ','','','publish','open','open','','29','','','2015-06-03 11:42:56','2015-06-03 10:42:56','',0,'http://venetian-blinds.rcg-dev.com/?p=29',6,'nav_menu_item','',0),
	(30,1,'2015-06-02 10:31:24','2015-06-02 09:31:24',' ','','','publish','open','open','','30','','','2015-06-03 11:42:56','2015-06-03 10:42:56','',0,'http://venetian-blinds.rcg-dev.com/?p=30',5,'nav_menu_item','',0),
	(31,1,'2015-06-02 10:31:24','2015-06-02 09:31:24',' ','','','publish','open','open','','31','','','2015-06-03 11:42:56','2015-06-03 10:42:56','',0,'http://venetian-blinds.rcg-dev.com/?p=31',4,'nav_menu_item','',0),
	(32,1,'2015-06-02 10:31:24','2015-06-02 09:31:24',' ','','','publish','open','open','','32','','','2015-06-03 11:42:56','2015-06-03 10:42:56','',0,'http://venetian-blinds.rcg-dev.com/?p=32',3,'nav_menu_item','',0),
	(33,1,'2015-06-02 10:31:24','2015-06-02 09:31:24',' ','','','publish','open','open','','33','','','2015-06-03 11:42:56','2015-06-03 10:42:56','',0,'http://venetian-blinds.rcg-dev.com/?p=33',2,'nav_menu_item','',0),
	(34,1,'2015-06-02 10:50:23','2015-06-02 09:50:23','Pommy ipsum completely crackers the old bill cottage pie Queen Elizabeth had a barney with the inlaws, stiff upper lip Elementary my dear Watson Kate and Will pot noodle. Sorted it hedgehog a right corker on the pull pigeons in Trafalgar Square bossy britches a bit wonky, bloody shambles mush wellies Union Jack ear hole the chippy, that\'s ace tad barmy you mean it ain\'t me noggin\' like a kipper. Lug hole old girl lass working class give you a bell Queen Elizabeth, fish fingers and custard jolly good squiffy shortbread had a barney with the inlaws, nose rag big light squiffy scatterbrained.\r\n\r\nEver so lovely morris dancers don\'t get your knickers in a twist, driving a mini.','Pommy ipsum completely crackers the old bill','','publish','open','open','','this-is-a-test-post','','','2015-06-02 10:51:43','2015-06-02 09:51:43','',0,'http://venetian-blinds.rcg-dev.com/?p=34',0,'post','',0),
	(35,1,'2015-06-02 10:50:23','2015-06-02 09:50:23','Pommy ipsum completely crackers the old bill cottage pie Queen Elizabeth had a barney with the inlaws, stiff upper lip Elementary my dear Watson Kate and Will pot noodle. Sorted it hedgehog a right corker on the pull pigeons in Trafalgar Square bossy britches a bit wonky, bloody shambles mush wellies Union Jack ear hole the chippy, that\'s ace tad barmy you mean it ain\'t me noggin\' like a kipper. Lug hole old girl lass working class give you a bell Queen Elizabeth, fish fingers and custard jolly good squiffy shortbread had a barney with the inlaws, nose rag big light squiffy scatterbrained.\r\n\r\nEver so lovely morris dancers don\'t get your knickers in a twist, driving a mini.','This is a test post','','inherit','open','open','','34-revision-v1','','','2015-06-02 10:50:23','2015-06-02 09:50:23','',34,'http://venetian-blinds.rcg-dev.com/2015/06/34-revision-v1/',0,'revision','',0),
	(36,1,'2015-06-02 10:50:39','2015-06-02 09:50:39','Pommy ipsum completely crackers the old bill cottage pie Queen Elizabeth had a barney with the inlaws, stiff upper lip Elementary my dear Watson Kate and Will pot noodle. Sorted it hedgehog a right corker on the pull pigeons in Trafalgar Square bossy britches a bit wonky, bloody shambles mush wellies Union Jack ear hole the chippy, that\'s ace tad barmy you mean it ain\'t me noggin\' like a kipper. Lug hole old girl lass working class give you a bell Queen Elizabeth, fish fingers and custard jolly good squiffy shortbread had a barney with the inlaws, nose rag big light squiffy scatterbrained.\r\n\r\nEver so lovely morris dancers don\'t get your knickers in a twist, driving a mini.','Pommy ipsum completely crackers the old bill','','inherit','open','open','','34-revision-v1','','','2015-06-02 10:50:39','2015-06-02 09:50:39','',34,'http://venetian-blinds.rcg-dev.com/2015/06/34-revision-v1/',0,'revision','',0),
	(37,1,'2015-06-02 10:51:32','2015-06-02 09:51:32','','340x230','','inherit','open','open','','340x230','','','2015-06-02 10:51:32','2015-06-02 09:51:32','',34,'http://venetian-blinds.rcg-dev.com/wp-content/uploads/2015/06/340x230.gif',0,'attachment','image/gif',0),
	(38,1,'2015-06-02 10:51:52','2015-06-02 09:51:52','Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!','Hello world!','','inherit','open','open','','1-revision-v1','','','2015-06-02 10:51:52','2015-06-02 09:51:52','',1,'http://venetian-blinds.rcg-dev.com/2015/06/1-revision-v1/',0,'revision','',0),
	(46,1,'2015-06-03 10:25:51','2015-06-03 09:25:51','','Shop','','publish','closed','open','','shop','','','2015-06-03 10:25:51','2015-06-03 09:25:51','',0,'http://venetian-blinds.rcg-dev.com/shop/',0,'page','',0),
	(47,1,'2015-06-03 10:25:51','2015-06-03 09:25:51','[woocommerce_cart]','Cart','','publish','closed','open','','cart','','','2015-06-03 15:57:22','2015-06-03 14:57:22','',0,'http://venetian-blinds.rcg-dev.com/cart/',0,'page','',0),
	(48,1,'2015-06-03 10:25:51','2015-06-03 09:25:51','[woocommerce_checkout]','Checkout','','publish','closed','open','','checkout','','','2015-06-03 10:25:51','2015-06-03 09:25:51','',0,'http://venetian-blinds.rcg-dev.com/checkout/',0,'page','',0),
	(49,1,'2015-06-03 10:25:51','2015-06-03 09:25:51','[woocommerce_my_account]','My Account','','publish','closed','open','','my-account','','','2015-06-03 10:25:51','2015-06-03 09:25:51','',0,'http://venetian-blinds.rcg-dev.com/my-account/',0,'page','',0),
	(50,1,'2015-06-03 10:44:32','2015-06-03 09:44:32','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam ac tempus libero. Sed efficitur neque pellentesque massa suscipit semper tempor sit amet enim. Phasellus eu diam non ipsum feugiat venenatis. Maecenas quis dolor erat. Nam eros nibh, feugiat non metus quis, placerat porttitor sem. Nullam hendrerit nisi augue, non ullamcorper elit porttitor eget. Maecenas at maximus nunc. Etiam lacus nulla, aliquet et metus eget, posuere auctor risus. Ut vehicula vehicula interdum. Nulla ac felis leo. Duis nec ultricies quam. Nullam maximus, eros a molestie mattis, ligula leo tempus sapien, a consequat nunc nulla et risus. Nulla luctus ex ac ipsum lobortis dignissim. Nullam lobortis tempor sagittis.\r\n\r\nCurabitur maximus vel quam quis dignissim. Aenean rhoncus ante in lorem ultricies, at efficitur eros mattis. Morbi hendrerit orci placerat leo suscipit, ut semper mi mattis. Phasellus lorem ipsum, lobortis nec mollis sed, lobortis in enim. Suspendisse molestie sodales rutrum. In rhoncus, purus nec fringilla sagittis, libero leo porta risus, vitae consectetur nibh erat nec diam. Aliquam luctus dui eu lacus porta, nec molestie orci viverra. Aenean pellentesque quam sit amet dui porttitor, sed fermentum augue ultrices. Phasellus finibus erat quis est accumsan congue.','Test venetian blind','','publish','open','closed','','test-product','','','2015-06-08 10:57:23','2015-06-08 09:57:23','',0,'http://venetian-blinds.rcg-dev.com/?post_type=product&#038;p=50',0,'product','',0),
	(51,1,'2015-06-03 11:38:40','2015-06-03 10:38:40','','Venetian Blinds','','publish','open','open','','venetian-blinds','','','2015-06-05 10:27:50','2015-06-05 09:27:50','',0,'http://venetian-blinds.rcg-dev.com/?page_id=51',0,'page','',0),
	(52,1,'2015-06-03 11:38:40','2015-06-03 10:38:40','','Venetian Blinds','','inherit','open','open','','51-revision-v1','','','2015-06-03 11:38:40','2015-06-03 10:38:40','',51,'http://venetian-blinds.rcg-dev.com/51-revision-v1/',0,'revision','',0),
	(53,1,'2015-06-03 11:42:56','2015-06-03 10:42:56',' ','','','publish','open','open','','53','','','2015-06-03 11:42:56','2015-06-03 10:42:56','',0,'http://venetian-blinds.rcg-dev.com/?p=53',1,'nav_menu_item','',0),
	(54,1,'2015-06-03 11:43:26','2015-06-03 10:43:26',' ','','','publish','open','open','','54','','','2015-06-03 11:43:26','2015-06-03 10:43:26','',0,'http://venetian-blinds.rcg-dev.com/?p=54',1,'nav_menu_item','',0),
	(55,1,'2015-06-03 14:03:14','0000-00-00 00:00:00',' ','','','draft','open','open','','','','','2015-06-03 14:03:14','0000-00-00 00:00:00','',0,'http://venetian-blinds.rcg-dev.com/?p=55',1,'nav_menu_item','',0),
	(58,1,'2015-06-03 15:54:07','2015-06-03 14:54:07','[woocommerce_cart]','Cart','','inherit','open','open','','47-revision-v1','','','2015-06-03 15:54:07','2015-06-03 14:54:07','',47,'http://venetian-blinds.rcg-dev.com/47-revision-v1/',0,'revision','',0),
	(61,1,'2015-06-05 10:21:45','2015-06-05 09:21:45','','product-placeholder','','inherit','open','open','','product-placeholder','','','2015-06-05 10:21:45','2015-06-05 09:21:45','',50,'http://venetian-blinds.rcg-dev.com/wp-content/uploads/2015/06/product-placeholder.png',0,'attachment','image/png',0),
	(63,1,'2015-06-05 17:03:04','2015-06-05 16:03:04','Blah blah blah','Wooden test product','','publish','open','closed','','wooden-test-product','','','2015-06-15 10:49:46','2015-06-15 09:49:46','',0,'http://venetian-blinds.rcg-dev.com/?post_type=product&#038;p=63',0,'product','',0),
	(64,1,'2015-06-08 10:57:41','2015-06-08 09:57:41','','Pleated_blinds_high_quality_low_price_export.jpg_220x220','','inherit','open','open','','pleated_blinds_high_quality_low_price_export-jpg_220x220','','','2015-06-08 10:57:41','2015-06-08 09:57:41','',50,'http://venetian-blinds.rcg-dev.com/wp-content/uploads/2015/06/Pleated_blinds_high_quality_low_price_export.jpg_220x220.jpg',0,'attachment','image/jpeg',0),
	(65,1,'2015-06-08 10:57:42','2015-06-08 09:57:42','','fabric-vertical-blinds22','','inherit','open','open','','fabric-vertical-blinds22','','','2015-06-08 10:57:42','2015-06-08 09:57:42','',50,'http://venetian-blinds.rcg-dev.com/wp-content/uploads/2015/06/fabric-vertical-blinds22.jpg',0,'attachment','image/jpeg',0),
	(66,1,'2015-06-08 10:57:44','2015-06-08 09:57:44','','Fast-shipping-100-Real-basswood-venetian-font-b-blinds-b-font-font-b-mini-b-font.jpg_220x220','','inherit','open','open','','fast-shipping-100-real-basswood-venetian-font-b-blinds-b-font-font-b-mini-b-font-jpg_220x220','','','2015-06-08 10:57:44','2015-06-08 09:57:44','',50,'http://venetian-blinds.rcg-dev.com/wp-content/uploads/2015/06/Fast-shipping-100-Real-basswood-venetian-font-b-blinds-b-font-font-b-mini-b-font.jpg_220x220.jpg',0,'attachment','image/jpeg',0),
	(69,1,'2015-06-11 16:04:23','2015-06-11 15:04:23','','-text','','inherit','open','open','','text','','','2015-06-11 16:04:23','2015-06-11 15:04:23','',63,'http://venetian-blinds.rcg-dev.com/wp-content/uploads/2015/06/text.png',0,'attachment','image/png',0),
	(70,1,'2015-06-15 10:39:53','0000-00-00 00:00:00','','Auto Draft','','auto-draft','open','open','','','','','2015-06-15 10:39:53','0000-00-00 00:00:00','',0,'http://venetian-blinds.rcg-dev.com/?post_type=acf&p=70',0,'acf','',0),
	(72,1,'2015-06-15 10:46:05','2015-06-15 09:46:05','','Special Product Attributes','','publish','closed','closed','','acf_special-product-attributes','','','2015-06-15 10:46:05','2015-06-15 09:46:05','',0,'http://venetian-blinds.rcg-dev.com/?post_type=acf&#038;p=72',0,'acf','',0);



# Dump of table ven_blinds_term_relationships
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`)
VALUES
	(1,1,0),
	(22,2,0),
	(23,2,0),
	(24,2,0),
	(25,2,0),
	(26,2,0),
	(27,2,0),
	(28,3,0),
	(29,3,0),
	(30,3,0),
	(31,3,0),
	(32,3,0),
	(33,3,0),
	(34,1,0),
	(50,4,0),
	(50,8,0),
	(53,3,0),
	(54,2,0),
	(63,4,0),
	(63,9,0);



# Dump of table ven_blinds_term_taxonomy
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`)
VALUES
	(1,1,'category','',0,2),
	(2,2,'nav_menu','',0,7),
	(3,3,'nav_menu','',0,7),
	(4,4,'product_type','',0,2),
	(5,5,'product_type','',0,0),
	(6,6,'product_type','',0,0),
	(7,7,'product_type','',0,0),
	(8,8,'product_cat','Standard venetian blinds',0,1),
	(9,9,'product_cat','Wooden venetian blinds',0,1);



# Dump of table ven_blinds_terms
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_terms` (`term_id`, `name`, `slug`, `term_group`)
VALUES
	(1,'Uncategorised','uncategorised',0),
	(2,'Header Menu','header-menu',0),
	(3,'Mobile Menu','mobile-menu',0),
	(4,'simple','simple',0),
	(5,'grouped','grouped',0),
	(6,'variable','variable',0),
	(7,'external','external',0),
	(8,'Venetian Blinds','venetian-blinds',0),
	(9,'Wooden Venetian Blinds','wooden-venetian-blinds',0);



# Dump of table ven_blinds_usermeta
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES
	(1,1,'nickname','admin'),
	(2,1,'first_name',''),
	(3,1,'last_name',''),
	(4,1,'description',''),
	(5,1,'rich_editing','true'),
	(6,1,'comment_shortcuts','false'),
	(7,1,'admin_color','midnight'),
	(8,1,'use_ssl','0'),
	(9,1,'show_admin_bar_front','false'),
	(10,1,'ven_blinds_capabilities','a:1:{s:13:\"administrator\";b:1;}'),
	(11,1,'ven_blinds_user_level','10'),
	(12,1,'dismissed_wp_pointers','wp360_locks,wp390_widgets,wp410_dfw'),
	(13,1,'show_welcome_panel','0'),
	(14,1,'session_tokens','a:1:{s:64:\"a23aa8b5dc6cacd48cbd4d123ed6f8c3f685bd7c29d6b0a80e06101715a93ec6\";a:4:{s:10:\"expiration\";i:1434533923;s:2:\"ip\";s:9:\"127.0.0.1\";s:2:\"ua\";s:120:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.81 Safari/537.36\";s:5:\"login\";i:1434361123;}}'),
	(15,1,'ven_blinds_dashboard_quick_press_last_post_id','62'),
	(16,1,'closedpostboxes_page','a:0:{}'),
	(17,1,'metaboxhidden_page','a:4:{i:0;s:10:\"postcustom\";i:1;s:16:\"commentstatusdiv\";i:2;s:7:\"slugdiv\";i:3;s:9:\"authordiv\";}'),
	(18,1,'managenav-menuscolumnshidden','a:1:{i:0;s:0:\"\";}'),
	(19,1,'metaboxhidden_nav-menus','a:2:{i:0;s:8:\"add-post\";i:1;s:12:\"add-post_tag\";}'),
	(20,1,'nav_menu_recently_edited','3'),
	(21,1,'ven_blinds_user-settings','libraryContent=browse'),
	(22,1,'ven_blinds_user-settings-time','1433238700'),
	(23,1,'_woocommerce_persistent_cart','a:1:{s:4:\"cart\";a:1:{s:32:\"c0c7c76d30bd3dcaefc96f40275bdc0a\";a:9:{s:10:\"product_id\";i:50;s:12:\"variation_id\";s:0:\"\";s:9:\"variation\";a:0:{}s:8:\"quantity\";i:1;s:10:\"line_total\";d:9.9900000000000002131628207280300557613372802734375;s:8:\"line_tax\";d:1.9979999999999999982236431605997495353221893310546875;s:13:\"line_subtotal\";d:9.9900000000000002131628207280300557613372802734375;s:17:\"line_subtotal_tax\";d:1.9979999999999999982236431605997495353221893310546875;s:13:\"line_tax_data\";a:2:{s:5:\"total\";a:1:{i:1;d:1.9979999999999999982236431605997495353221893310546875;}s:8:\"subtotal\";a:1:{i:1;d:1.9979999999999999982236431605997495353221893310546875;}}}}}'),
	(24,1,'meta-box-order_dashboard','a:4:{s:6:\"normal\";s:38:\"dashboard_right_now,dashboard_activity\";s:4:\"side\";s:65:\"woocommerce_dashboard_status,woocommerce_dashboard_recent_reviews\";s:7:\"column3\";s:17:\"dashboard_primary\";s:7:\"column4\";s:21:\"dashboard_quick_press\";}'),
	(25,1,'closedpostboxes_dashboard','a:0:{}'),
	(26,1,'metaboxhidden_dashboard','a:0:{}'),
	(27,1,'billing_first_name',''),
	(28,1,'billing_last_name',''),
	(29,1,'billing_company',''),
	(30,1,'billing_address_1',''),
	(31,1,'billing_address_2',''),
	(32,1,'billing_city',''),
	(33,1,'billing_postcode',''),
	(34,1,'billing_country',''),
	(35,1,'billing_state',''),
	(36,1,'billing_phone',''),
	(37,1,'billing_email',''),
	(38,1,'shipping_first_name',''),
	(39,1,'shipping_last_name',''),
	(40,1,'shipping_company',''),
	(41,1,'shipping_address_1',''),
	(42,1,'shipping_address_2',''),
	(43,1,'shipping_city',''),
	(44,1,'shipping_postcode',''),
	(45,1,'shipping_country',''),
	(46,1,'shipping_state','');



# Dump of table ven_blinds_users
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_users` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_pass` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_nicename` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT '0',
  `display_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`)
VALUES
	(1,'admin','$P$BDFVgBEDBSpRtt6R.KkgaamS/yxnJM0','admin','myke.howells@rarecreativegroup.com','','2015-05-28 15:04:52','',0,'admin');



# Dump of table ven_blinds_woocommerce_attribute_taxonomies
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_label` longtext COLLATE utf8mb4_unicode_ci,
  `attribute_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_orderby` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_public` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`attribute_id`),
  KEY `attribute_name` (`attribute_name`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table ven_blinds_woocommerce_downloadable_product_permissions
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `download_id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `order_key` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_email` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `access_expires` datetime DEFAULT NULL,
  `download_count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`permission_id`),
  KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(191),`download_id`),
  KEY `download_order_product` (`download_id`,`order_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table ven_blinds_woocommerce_order_itemmeta
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_order_itemmeta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_item_id` bigint(20) NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `order_item_id` (`order_item_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table ven_blinds_woocommerce_order_items
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_order_items` (
  `order_item_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_item_name` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_item_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `order_id` bigint(20) NOT NULL,
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table ven_blinds_woocommerce_sagepaycw_customer_contexts
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_sagepaycw_customer_contexts` (
  `contextId` bigint(20) NOT NULL AUTO_INCREMENT,
  `customerId` varchar(255) DEFAULT NULL,
  `context_values` longtext,
  PRIMARY KEY (`contextId`),
  UNIQUE KEY `customerId` (`customerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table ven_blinds_woocommerce_sagepaycw_ecc
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_sagepaycw_ecc` (
  `contextId` bigint(20) NOT NULL AUTO_INCREMENT,
  `state` varchar(255) DEFAULT NULL,
  `failedErrorMessage` varchar(255) DEFAULT NULL,
  `cartUrl` varchar(255) DEFAULT NULL,
  `defaultCheckoutUrl` varchar(255) DEFAULT NULL,
  `invoiceItems` longtext,
  `orderAmountInDecimals` decimal(10,5) DEFAULT NULL,
  `currencyCode` varchar(255) DEFAULT NULL,
  `languageCode` varchar(255) DEFAULT NULL,
  `customerEmailAddress` varchar(255) DEFAULT NULL,
  `customerId` varchar(255) DEFAULT NULL,
  `transactionId` int(11) DEFAULT NULL,
  `shippingAddress` longtext,
  `billingAddress` longtext,
  `shippingMethodName` varchar(255) DEFAULT NULL,
  `paymentMethodMachineName` varchar(255) DEFAULT NULL,
  `providerData` longtext,
  `createdOn` datetime DEFAULT NULL,
  `updatedOn` datetime DEFAULT NULL,
  `securityToken` varchar(255) DEFAULT NULL,
  `securityTokenExpiryDate` datetime DEFAULT NULL,
  `authenticationSuccessUrl` varchar(512) DEFAULT NULL,
  `authenticationEmailAddress` varchar(255) DEFAULT NULL,
  `cookieKey` varchar(255) DEFAULT NULL,
  `additionalValues` longtext,
  `selectedShippingMethods` longtext,
  `verificationHash` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`contextId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table ven_blinds_woocommerce_sagepaycw_schema_version
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_sagepaycw_schema_version` (
  `version_id` int(10) NOT NULL AUTO_INCREMENT,
  `version_number` varchar(20) NOT NULL,
  `comment` varchar(255) DEFAULT '',
  `installed_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`version_id`),
  UNIQUE KEY `version_number` (`version_number`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;


INSERT INTO `ven_blinds_woocommerce_sagepaycw_schema_version` (`version_id`, `version_number`, `comment`, `installed_on`)
VALUES
	(1,'1.0.0','InitiateSchema','2015-06-03 15:51:49'),
	(2,'1.1.0','AddStorage','2015-06-03 15:51:49'),
	(3,'2.0.0','EntityManager','2015-06-03 15:51:52'),
	(4,'2.0.1','OrderStatus','2015-06-03 15:51:52'),
	(5,'2.1.0','ExternalCheckout','2015-06-03 15:51:52'),
	(6,'2.1.1','RenameEcc','2015-06-03 15:51:52');



# Dump of table ven_blinds_woocommerce_sagepaycw_storage
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_sagepaycw_storage` (
  `keyId` bigint(20) NOT NULL AUTO_INCREMENT,
  `keyName` varchar(165) DEFAULT NULL,
  `keySpace` varchar(165) DEFAULT NULL,
  `keyValue` longtext,
  PRIMARY KEY (`keyId`),
  UNIQUE KEY `keyName_keySpace` (`keyName`,`keySpace`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;


INSERT INTO `ven_blinds_woocommerce_sagepaycw_storage` (`keyId`, `keyName`, `keySpace`, `keyValue`)
VALUES
	(1,'is_update_running','scheduled_update_processor','czoyOiJubyI7'),
	(2,'last_start_update','scheduled_update_processor','aToxNDM0MzYyMjEzOw==');



# Dump of table ven_blinds_woocommerce_sagepaycw_transactions
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_sagepaycw_transactions` (
  `transactionId` bigint(20) NOT NULL AUTO_INCREMENT,
  `transactionExternalId` varchar(255) DEFAULT NULL,
  `orderId` varchar(255) DEFAULT NULL,
  `aliasForDisplay` varchar(255) DEFAULT NULL,
  `aliasActive` char(1) DEFAULT NULL,
  `paymentMachineName` varchar(255) DEFAULT NULL,
  `paymentClass` varchar(255) DEFAULT NULL,
  `transactionObject` longtext,
  `authorizationType` varchar(255) DEFAULT NULL,
  `customerId` varchar(255) DEFAULT NULL,
  `updatedOn` datetime DEFAULT NULL,
  `createdOn` datetime DEFAULT NULL,
  `paymentId` varchar(255) DEFAULT NULL,
  `updatable` char(1) DEFAULT NULL,
  `executeUpdateOn` datetime DEFAULT NULL,
  `authorizationAmount` decimal(10,5) DEFAULT NULL,
  `authorizationStatus` varchar(255) DEFAULT NULL,
  `paid` char(1) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `lastSetOrderStatusSettingKey` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`transactionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table ven_blinds_woocommerce_tax_rate_locations
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `location_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_rate_id` bigint(20) NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  KEY `location_type` (`location_type`),
  KEY `location_type_code` (`location_type`,`location_code`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table ven_blinds_woocommerce_tax_rates
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tax_rate_country` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate_priority` bigint(20) NOT NULL,
  `tax_rate_compound` int(1) NOT NULL DEFAULT '0',
  `tax_rate_shipping` int(1) NOT NULL DEFAULT '1',
  `tax_rate_order` bigint(20) NOT NULL,
  `tax_rate_class` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`tax_rate_id`),
  KEY `tax_rate_country` (`tax_rate_country`(191)),
  KEY `tax_rate_state` (`tax_rate_state`(191)),
  KEY `tax_rate_class` (`tax_rate_class`(191)),
  KEY `tax_rate_priority` (`tax_rate_priority`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_woocommerce_tax_rates` (`tax_rate_id`, `tax_rate_country`, `tax_rate_state`, `tax_rate`, `tax_rate_name`, `tax_rate_priority`, `tax_rate_compound`, `tax_rate_shipping`, `tax_rate_order`, `tax_rate_class`)
VALUES
	(1,'GB','','20.0000','UK Tax',1,0,1,0,'');



# Dump of table ven_blinds_woocommerce_termmeta
# ------------------------------------------------------------


CREATE TABLE `ven_blinds_woocommerce_termmeta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `woocommerce_term_id` bigint(20) NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `woocommerce_term_id` (`woocommerce_term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `ven_blinds_woocommerce_termmeta` (`meta_id`, `woocommerce_term_id`, `meta_key`, `meta_value`)
VALUES
	(1,8,'order','0'),
	(2,8,'display_type','products'),
	(3,8,'thumbnail_id','0'),
	(4,8,'product_count_product_cat','1'),
	(5,9,'order','0'),
	(6,9,'display_type','products'),
	(7,9,'thumbnail_id','0'),
	(8,9,'product_count_product_cat','1');




