
--
-- Table structure for table `wp_term_relationships`
--

CREATE TABLE `wp_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=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_term_relationships`
--

INSERT INTO `wp_term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`) VALUES (1,2,0),(2,2,0),(3,2,0),(4,2,0),(5,2,0),(6,2,0),(7,2,0),(1,1,0),(118,10,0),(34,3,0),(35,3,0),(406,39,0),(132,14,0),(407,39,0),(39,1,0),(69,10,0),(71,1,0),(584,39,0),(412,39,0),(94,1,0),(94,5,0),(455,40,0),(102,14,0),(573,3,0),(486,33,0),(101,13,0),(103,15,0),(414,39,0),(104,16,0),(413,39,0),(108,10,0),(109,10,0),(113,7,0),(121,18,0),(410,39,0),(125,18,0),(126,18,0),(127,7,0),(408,39,0),(131,13,0),(133,15,0),(392,34,0),(134,16,0),(388,34,0),(409,39,0),(137,7,0),(372,36,0),(374,38,0),(405,39,0),(141,22,0),(140,23,0),(142,21,0),(403,39,0),(143,24,0),(404,39,0),(583,3,0),(144,20,0),(375,34,0),(266,30,0),(149,26,0),(148,27,0),(373,37,0),(341,7,0),(333,32,0),(150,25,0),(364,7,0),(274,18,0),(443,18,0),(227,17,0),(229,17,0),(232,17,0),(235,17,0),(237,17,0),(355,32,0),(560,7,0),(361,33,0),(254,29,0),(256,29,0),(258,29,0),(262,7,0),(539,32,0),(313,3,0),(329,3,0),(556,41,0);

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) NOT NULL DEFAULT '',
  `description` longtext 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=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_term_taxonomy`
--

INSERT INTO `wp_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES (1,1,'category','Essential oil room sprays can make a wonderful addition to any home, not only as a fabulous odour eliminator but also to create ambience and harmony. The different blends create balance and well being whilst lifting the spirit to bring about a calm, happy environment. Nurture all aspects of your environment with these beautiful blends.\r\n\r\n(Please note that the room sprays created are made with 100 per cent pure essential oils and may not be suitable for use during pregnancy or if epileptic. Citrus room sprays are photosensitising and must be kept away from direct sunlight. Please do not ingest although they smell amazing they don’t taste so good.)',7,4),(2,2,'link_category','',0,7),(3,3,'nav_menu','',0,6),(4,4,'category','Lip Balms description etc etc etc',7,0),(5,5,'category','Eye pillows description......',7,1),(6,6,'category','Household products description....',7,0),(7,7,'nav_menu','',0,7),(8,7,'category','Products descriptions',0,0),(9,8,'wpsc_product_category','',0,0),(10,9,'wpsc_product_category','',0,4),(11,10,'wpsc-variation','',0,0),(12,11,'wpsc-variation','',0,0),(13,12,'wpsc-variation','',11,0),(14,13,'wpsc-variation','',11,0),(15,14,'wpsc-variation','',11,0),(16,15,'wpsc-variation','',11,0),(36,32,'wpsc-variation','',31,0),(32,28,'wpsc_product_category','',0,3),(17,5,'wpsc_product_category','',0,4),(18,4,'wpsc_product_category','',0,5),(30,26,'wpsc_product_category','',0,1),(20,16,'wpsc-variation','',11,0),(21,17,'wpsc-variation','',11,0),(22,18,'wpsc-variation','',11,0),(23,19,'wpsc-variation','',11,0),(24,20,'wpsc-variation','',11,0),(37,33,'wpsc-variation','',31,0),(29,25,'wpsc_product_category','',0,3),(25,21,'wpsc-variation','',11,0),(26,22,'wpsc-variation','',11,0),(27,23,'wpsc-variation','',11,0),(31,27,'wpsc_product_category','',0,0),(28,24,'wpsc_product_category','',0,0),(33,29,'wpsc_product_category','',0,2),(34,30,'wpsc_product_category','',0,1),(35,31,'wpsc-variation','',0,0),(38,34,'wpsc-variation','',31,0),(39,35,'nav_menu','',0,12),(40,36,'category','The Partridge &amp; Pear blog.',0,1),(41,37,'wpsc_product_category','',0,1);

--
-- Table structure for table `wp_terms`
--

CREATE TABLE `wp_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(200) NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_terms`
--

INSERT INTO `wp_terms` (`term_id`, `name`, `slug`, `term_group`) VALUES (1,'Room Sprays','roomsprays',0),(2,'Blogroll','blogroll',0),(3,'Main Menu','main-menu',0),(4,'Lip Balms','lip-balms',0),(5,'Eye Pillows','eye-pillows',0),(6,'Household','household',0),(7,'Products','products',0),(8,'Product Category','product-category',0),(9,'Room Sprays','room_sprays',0),(10,'Material/Design','materialdesign',0),(11,'Design','design',0),(12,'Partridge and Pear (cotton)','partridge',0),(13,'Peonies (cotton)','peonies',0),(14,'Spring Blossom (cotton)','spring-blossom',0),(15,'Aqua Dragonfly','dragonfly',0),(16,'Rainbow Swirl','rainbow-swirl',0),(17,'Hibiscus','hibiscus',0),(18,'Flax is back','flax-is-back',0),(19,'Eiffel Tower','eiffel-tower',0),(20,'White Butterfly','white-butterfly',0),(21,'Vintage','vintage',0),(22,'Lime Sprig','lime-sprig',0),(23,'Country House','country-house',0),(24,'Featured Products','featured-products',0),(25,'Draw Sachets','draw-sachets',0),(26,'Perfume Pots','perfume-pots',0),(27,'House','house',0),(28,'Salves &amp; Body Sprays','salves',0),(29,'Massage Oil','massage-oil',0),(30,'Homewares','homewares',0),(31,'Material','material',0),(32,'Patchwork','patchwork',0),(33,'Shopping in Paris','shopping-in-paris',0),(34,'Tulips','tulips',0),(35,'Menu','menu',0),(36,'Blog','blog',0),(37,'Scrubs','scrubs',0);

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_usermeta`
--

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (1,1,'first_name',''),(2,1,'last_name',''),(3,1,'nickname','Miss Partridge'),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'comment_shortcuts','false'),(7,1,'admin_color','fresh'),(8,1,'use_ssl','0'),(9,1,'show_admin_bar_front','true'),(10,1,'wp_capabilities','a:1:{s:13:\"administrator\";s:1:\"1\";}'),(11,1,'wp_user_level','10'),(12,1,'dismissed_wp_pointers','wp330_toolbar,wp330_media_uploader,wp330_saving_widgets,wp340_choose_image_from_library,wp340_customize_current_theme_link,aioseop_menu_220,aioseop_welcome_220,wp350_media,wp360_revisions'),(13,1,'show_welcome_panel','1'),(14,1,'wp_dashboard_quick_press_last_post_id','589'),(15,1,'managenav-menuscolumnshidden','a:4:{i:0;s:11:\"link-target\";i:1;s:11:\"css-classes\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";}'),(16,1,'metaboxhidden_nav-menus','a:2:{i:0;s:8:\"add-post\";i:1;s:12:\"add-post_tag\";}'),(17,1,'nav_menu_recently_edited','35'),(18,1,'wp_user-settings','mfold=o&editor=html&imgsize=medium&galcols=4&align=left&hidetb=1'),(19,1,'wp_user-settings-time','1408767244'),(60,2,'_wpsc_shipping_country','AU'),(61,2,'_wpsc_billing_country','AU'),(62,2,'_wpsc_cart','s:1127:\"O:9:\"wpsc_cart\":37:{s:16:\"delivery_country\";s:2:\"AU\";s:16:\"selected_country\";s:2:\"AU\";s:15:\"delivery_region\";b:0;s:15:\"selected_region\";b:0;s:24:\"selected_shipping_method\";s:10:\"weightrate\";s:24:\"selected_shipping_option\";s:11:\"Weight Rate\";s:24:\"selected_shipping_amount\";N;s:6:\"coupon\";N;s:14:\"tax_percentage\";N;s:9:\"unique_id\";s:40:\"c8835708f3bf0e0175c2ce8a044597d40d773992\";s:6:\"errors\";a:0:{}s:9:\"total_tax\";N;s:13:\"base_shipping\";N;s:19:\"total_item_shipping\";N;s:14:\"total_shipping\";N;s:8:\"subtotal\";N;s:11:\"total_price\";N;s:13:\"uses_shipping\";N;s:13:\"is_incomplete\";b:1;s:10:\"cart_items\";a:0:{}s:9:\"cart_item\";N;s:15:\"cart_item_count\";i:0;s:17:\"current_cart_item\";i:-1;s:11:\"in_the_loop\";b:0;s:16:\"shipping_methods\";a:1:{i:0;s:10:\"weightrate\";}s:15:\"shipping_method\";N;s:21:\"shipping_method_count\";i:1;s:23:\"current_shipping_method\";i:-1;s:18:\"in_the_method_loop\";b:0;s:15:\"shipping_quotes\";a:1:{s:11:\"Weight Rate\";d:25;}s:14:\"shipping_quote\";N;s:20:\"shipping_quote_count\";i:0;s:22:\"current_shipping_quote\";i:-1;s:17:\"in_the_quote_loop\";b:0;s:12:\"coupons_name\";s:0:\"\";s:14:\"coupons_amount\";i:0;s:15:\"shipping_option\";N;}\";'),(44,1,'_wpsc_cart','s:1127:\"O:9:\"wpsc_cart\":37:{s:16:\"delivery_country\";s:2:\"AU\";s:16:\"selected_country\";s:2:\"AU\";s:15:\"delivery_region\";b:0;s:15:\"selected_region\";b:0;s:24:\"selected_shipping_method\";s:10:\"weightrate\";s:24:\"selected_shipping_option\";s:11:\"Weight Rate\";s:24:\"selected_shipping_amount\";N;s:6:\"coupon\";N;s:14:\"tax_percentage\";N;s:9:\"unique_id\";s:40:\"80823d2fa06373dbfd3ee3d0e21c92ae56aed9fb\";s:6:\"errors\";a:0:{}s:9:\"total_tax\";N;s:13:\"base_shipping\";N;s:19:\"total_item_shipping\";N;s:14:\"total_shipping\";N;s:8:\"subtotal\";N;s:11:\"total_price\";N;s:13:\"uses_shipping\";N;s:13:\"is_incomplete\";b:1;s:10:\"cart_items\";a:0:{}s:9:\"cart_item\";N;s:15:\"cart_item_count\";i:0;s:17:\"current_cart_item\";i:-1;s:11:\"in_the_loop\";b:0;s:16:\"shipping_methods\";a:1:{i:0;s:10:\"weightrate\";}s:15:\"shipping_method\";N;s:21:\"shipping_method_count\";i:1;s:23:\"current_shipping_method\";i:-1;s:18:\"in_the_method_loop\";b:0;s:15:\"shipping_quotes\";a:1:{s:11:\"Weight Rate\";d:25;}s:14:\"shipping_quote\";N;s:20:\"shipping_quote_count\";i:0;s:22:\"current_shipping_quote\";i:-1;s:17:\"in_the_quote_loop\";b:0;s:12:\"coupons_name\";s:0:\"\";s:14:\"coupons_amount\";i:0;s:15:\"shipping_option\";N;}\";'),(45,1,'_wpsc_shipping_country','AU'),(46,1,'_wpsc_billing_country','AU'),(47,1,'_wpsc_checkout_details','a:18:{i:1;s:0:\"\";i:2;s:3:\"Cam\";i:3;s:6:\"Merton\";i:4;s:15:\"22 Burnside Way\";i:5;s:7:\"Waikiki\";i:6;s:2:\"WA\";i:7;a:1:{i:0;s:2:\"AU\";}i:8;s:4:\"6169\";i:18;s:10:\"0895284315\";i:9;s:19:\"cam@hiddenshoal.com\";i:10;s:0:\"\";i:11;s:3:\"Cam\";i:12;s:6:\"Merton\";i:13;s:15:\"22 Burnside Way\";i:14;s:7:\"Waikiki\";i:15;s:2:\"WA\";i:16;s:2:\"AU\";i:17;s:4:\"6169\";}'),(48,1,'_wpsc_selected_gateway','wpsc_merchant_paypal_express'),(49,1,'_wpsc_checkout_session_id','9791375409974'),(50,1,'_wpsc_paypal_express_converted_amount','21.50'),(51,1,'_wpsc_paypal_express_original_amount','21.50'),(52,1,'_wpsc_paypal_express_sessionid','9791375409974'),(53,1,'_wpsc_paypal_express_currency_code_type','AUD'),(54,1,'_wpsc_paypal_express_payment_type','Sale'),(55,1,'_wpsc_paypal_express_nvp_req_array','a:25:{s:6:\"METHOD\";s:18:\"SetExpressCheckout\";s:7:\"VERSION\";s:2:\"71\";s:3:\"PWD\";s:16:\"MMB2AJ8DQCFWN7FE\";s:4:\"USER\";s:27:\"belle_api1.yvettemerton.com\";s:9:\"SIGNATURE\";s:56:\"AFcWxV21C7fd0v3bYYYRCpSSRl31AR1F9rBtozfqeo2R-Fli8WL97QJj\";s:30:\"PAYMENTREQUEST_0_PAYMENTACTION\";s:4:\"Sale\";s:9:\"RETURNURL\";s:89:\"http://partridgeandpear.com.au/products-page/transaction-results/?sessionid=9791375409974\";s:7:\"gateway\";s:6:\"paypal\";s:9:\"CANCELURL\";s:54:\"http://partridgeandpear.com.au/products-page/checkout/\";s:29:\"PAYMENTREQUEST_0_CURRENCYCODE\";s:3:\"AUD\";s:27:\"PAYMENTREQUEST_0_SHIPTONAME\";s:10:\"Cam Merton\";s:29:\"PAYMENTREQUEST_0_SHIPTOSTREET\";s:15:\"22 Burnside Way\";s:27:\"PAYMENTREQUEST_0_SHIPTOCITY\";s:7:\"Waikiki\";s:34:\"PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE\";s:2:\"AU\";s:26:\"PAYMENTREQUEST_0_SHIPTOZIP\";s:4:\"6169\";s:28:\"PAYMENTREQUEST_0_SHIPTOSTATE\";s:2:\"WA\";s:24:\"L_PAYMENTREQUEST_0_NAME0\";s:33:\"Aqua Dragonfly Scented Eye Pillow\";s:23:\"L_PAYMENTREQUEST_0_AMT0\";s:5:\"13.00\";s:26:\"L_PAYMENTREQUEST_0_NUMBER0\";s:1:\"0\";s:23:\"L_PAYMENTREQUEST_0_QTY0\";s:1:\"1\";s:24:\"PAYMENTREQUEST_0_ITEMAMT\";s:5:\"13.00\";s:28:\"PAYMENTREQUEST_0_SHIPPINGAMT\";s:4:\"8.50\";s:23:\"PAYMENTREQUEST_0_TAXAMT\";s:4:\"0.00\";s:20:\"PAYMENTREQUEST_0_AMT\";s:5:\"21.50\";s:12:\"BUTTONSOURCE\";s:11:\"PP-ECWizard\";}'),(21,1,'wp_wpsc_settings_selected_shipping_module','australiapost'),(23,2,'first_name','Yvette'),(24,2,'last_name','Merton'),(25,2,'nickname','Yvette'),(26,2,'description',''),(27,2,'rich_editing','true'),(28,2,'comment_shortcuts','false'),(29,2,'admin_color','fresh'),(30,2,'use_ssl','0'),(31,2,'show_admin_bar_front','true'),(32,2,'wp_capabilities','a:1:{s:6:\"editor\";s:1:\"1\";}'),(33,2,'wp_user_level','7'),(34,2,'dismissed_wp_pointers','wp330_toolbar,wp330_media_uploader,wp330_saving_widgets,wp340_choose_image_from_library,wp340_customize_current_theme_link'),(63,1,'_wpsc_visitor_id','3'),(64,1,'wp_wpsc_settings_selected_payment_gateway',''),(65,1,'_wpsc_customer_profile','a:8:{s:4:\"cart\";s:3927:\"O:9:\"wpsc_cart\":37:{s:16:\"delivery_country\";s:2:\"AU\";s:16:\"selected_country\";s:2:\"AU\";s:15:\"delivery_region\";b:0;s:15:\"selected_region\";b:0;s:24:\"selected_shipping_method\";s:10:\"weightrate\";s:24:\"selected_shipping_option\";s:11:\"Weight Rate\";s:24:\"selected_shipping_amount\";N;s:6:\"coupon\";N;s:14:\"tax_percentage\";i:0;s:9:\"unique_id\";s:40:\"3abdf3f08bc58e8b01c8c32abb9f61ec307946c9\";s:6:\"errors\";a:0:{}s:9:\"total_tax\";i:0;s:13:\"base_shipping\";d:2;s:19:\"total_item_shipping\";i:0;s:14:\"total_shipping\";N;s:8:\"subtotal\";d:8;s:11:\"total_price\";d:10;s:13:\"uses_shipping\";i:1;s:13:\"is_incomplete\";b:1;s:10:\"cart_items\";a:1:{i:0;O:14:\"wpsc_cart_item\":36:{s:4:\"cart\";r:1;s:10:\"product_id\";i:254;s:16:\"variation_values\";N;s:18:\"product_variations\";R:25;s:14:\"variation_data\";N;s:8:\"quantity\";i:1;s:14:\"provided_price\";N;s:12:\"product_name\";s:22:\"Aqua Birds Draw Sachet\";s:13:\"category_list\";a:1:{i:0;s:12:\"draw-sachets\";}s:16:\"category_id_list\";a:1:{i:0;i:25;}s:10:\"unit_price\";d:8;s:11:\"total_price\";d:8;s:13:\"taxable_price\";i:0;s:3:\"tax\";i:0;s:6:\"weight\";s:4:\"0.03\";s:8:\"shipping\";i:0;s:3:\"sku\";s:0:\"\";s:11:\"product_url\";s:88:\"http://www.partridgeandpear.com.au/products-page/draw-sachets/country-house-draw-sachet/\";s:8:\"image_id\";N;s:15:\"thumbnail_image\";O:7:\"WP_Post\":24:{s:2:\"ID\";i:550;s:11:\"post_author\";s:1:\"1\";s:9:\"post_date\";s:19:\"2014-05-20 06:11:43\";s:13:\"post_date_gmt\";s:19:\"2014-05-20 06:11:43\";s:12:\"post_content\";s:0:\"\";s:10:\"post_title\";s:13:\"leaves_sachet\";s:12:\"post_excerpt\";s:0:\"\";s:11:\"post_status\";s:7:\"inherit\";s:14:\"comment_status\";s:4:\"open\";s:11:\"ping_status\";s:4:\"open\";s:13:\"post_password\";s:0:\"\";s:9:\"post_name\";s:13:\"leaves_sachet\";s:7:\"to_ping\";s:0:\"\";s:6:\"pinged\";s:0:\"\";s:13:\"post_modified\";s:19:\"2014-05-20 06:11:43\";s:17:\"post_modified_gmt\";s:19:\"2014-05-20 06:11:43\";s:21:\"post_content_filtered\";s:0:\"\";s:11:\"post_parent\";i:254;s:4:\"guid\";s:75:\"http://partridgeandpear.com.au/wp-content/uploads/2012/12/leaves_sachet.jpg\";s:10:\"menu_order\";i:0;s:9:\"post_type\";s:10:\"attachment\";s:14:\"post_mime_type\";s:10:\"image/jpeg\";s:13:\"comment_count\";s:1:\"0\";s:6:\"filter\";s:3:\"raw\";}s:15:\"custom_tax_rate\";N;s:4:\"meta\";a:1:{i:0;a:20:{s:25:\"wpec_taxes_taxable_amount\";s:0:\"\";s:13:\"external_link\";s:0:\"\";s:18:\"external_link_text\";s:0:\"\";s:20:\"external_link_target\";s:0:\"\";s:11:\"no_shipping\";s:1:\"0\";s:11:\"weight_unit\";s:5:\"pound\";s:10:\"dimensions\";a:6:{s:6:\"height\";s:1:\"0\";s:11:\"height_unit\";s:2:\"in\";s:5:\"width\";s:1:\"0\";s:10:\"width_unit\";s:2:\"in\";s:6:\"length\";s:1:\"0\";s:11:\"length_unit\";s:2:\"in\";}s:8:\"shipping\";a:2:{s:5:\"local\";s:1:\"0\";s:13:\"international\";s:1:\"0\";}s:14:\"merchant_notes\";s:0:\"\";s:8:\"engraved\";s:1:\"0\";s:23:\"can_have_uploaded_image\";s:1:\"0\";s:15:\"enable_comments\";s:0:\"\";s:21:\"notify_when_none_left\";s:1:\"0\";s:24:\"unpublish_when_none_left\";s:1:\"0\";s:16:\"quantity_limited\";s:1:\"0\";s:7:\"special\";s:1:\"0\";s:17:\"display_weight_as\";s:5:\"pound\";s:16:\"table_rate_price\";a:2:{s:8:\"quantity\";a:0:{}s:11:\"table_price\";a:0:{}}s:17:\"google_prohibited\";s:1:\"0\";s:6:\"weight\";s:4:\"0.03\";}}s:11:\"is_donation\";s:1:\"0\";s:9:\"apply_tax\";b:1;s:16:\"priceandstock_id\";i:0;s:14:\"custom_message\";N;s:11:\"custom_file\";N;s:7:\"comment\";N;s:14:\"time_requested\";N;s:9:\"file_data\";N;s:15:\"is_customisable\";b:0;s:5:\"stock\";s:1:\"4\";s:13:\"uses_shipping\";i:1;s:17:\"has_limited_stock\";b:1;s:7:\"file_id\";N;s:15:\"is_downloadable\";b:0;}}s:9:\"cart_item\";r:22;s:15:\"cart_item_count\";i:1;s:17:\"current_cart_item\";i:-1;s:11:\"in_the_loop\";b:0;s:16:\"shipping_methods\";a:1:{i:0;s:10:\"weightrate\";}s:15:\"shipping_method\";s:10:\"weightrate\";s:21:\"shipping_method_count\";i:1;s:23:\"current_shipping_method\";i:-1;s:18:\"in_the_method_loop\";b:0;s:15:\"shipping_quotes\";a:1:{s:11:\"Weight Rate\";s:1:\"2\";}s:14:\"shipping_quote\";a:2:{s:4:\"name\";s:11:\"Weight Rate\";s:5:\"value\";d:2;}s:20:\"shipping_quote_count\";i:1;s:22:\"current_shipping_quote\";i:-1;s:17:\"in_the_quote_loop\";b:0;s:12:\"coupons_name\";s:0:\"\";s:14:\"coupons_amount\";i:0;s:15:\"shipping_option\";N;}\";s:16:\"shipping_country\";s:2:\"AU\";s:15:\"billing_country\";s:2:\"AU\";s:15:\"shipping_region\";b:0;s:14:\"billing_region\";b:0;s:40:\"category_shipping_target_market_conflict\";b:1;s:26:\"category_shipping_conflict\";s:148:\"Some of your cart items are targeted specifically to certain markets. As a result, you can only select those countries as your shipping destination.\";s:24:\"shipping_same_as_billing\";N;}'),(36,2,'wp_dashboard_quick_press_last_post_id','421'),(38,2,'aim',''),(39,2,'yim',''),(40,2,'jabber',''),(41,1,'aim',''),(42,1,'yim',''),(43,1,'jabber',''),(56,1,'_wpsc_paypal_express_token','EC-67B358120A626183X'),(57,1,'_wpsc_paypal_express_reshash','a:25:{s:5:\"TOKEN\";s:20:\"EC-0EE93824JM3404714\";s:28:\"SUCCESSPAGEREDIRECTREQUESTED\";s:5:\"false\";s:9:\"TIMESTAMP\";s:20:\"2012-12-05T14:21:22Z\";s:13:\"CORRELATIONID\";s:13:\"7f470268abfe2\";s:3:\"ACK\";s:7:\"Success\";s:7:\"VERSION\";s:2:\"71\";s:5:\"BUILD\";s:7:\"4181146\";s:23:\"INSURANCEOPTIONSELECTED\";s:5:\"false\";s:23:\"SHIPPINGOPTIONISDEFAULT\";s:5:\"false\";s:27:\"PAYMENTINFO_0_TRANSACTIONID\";s:17:\"21W21788H82308248\";s:29:\"PAYMENTINFO_0_TRANSACTIONTYPE\";s:4:\"cart\";s:25:\"PAYMENTINFO_0_PAYMENTTYPE\";s:7:\"instant\";s:23:\"PAYMENTINFO_0_ORDERTIME\";s:20:\"2012-12-05T14:21:22Z\";s:17:\"PAYMENTINFO_0_AMT\";s:5:\"15.00\";s:20:\"PAYMENTINFO_0_FEEAMT\";s:4:\"0.66\";s:20:\"PAYMENTINFO_0_TAXAMT\";s:4:\"0.00\";s:26:\"PAYMENTINFO_0_CURRENCYCODE\";s:3:\"AUD\";s:27:\"PAYMENTINFO_0_PAYMENTSTATUS\";s:9:\"Completed\";s:27:\"PAYMENTINFO_0_PENDINGREASON\";s:4:\"None\";s:24:\"PAYMENTINFO_0_REASONCODE\";s:4:\"None\";s:35:\"PAYMENTINFO_0_PROTECTIONELIGIBILITY\";s:10:\"Ineligible\";s:39:\"PAYMENTINFO_0_PROTECTIONELIGIBILITYTYPE\";s:4:\"None\";s:37:\"PAYMENTINFO_0_SECUREMERCHANTACCOUNTID\";s:13:\"GX2WT2KJBC3J4\";s:23:\"PAYMENTINFO_0_ERRORCODE\";s:1:\"0\";s:17:\"PAYMENTINFO_0_ACK\";s:7:\"Success\";}'),(58,1,'_wpsc_paypal_express_payer_id','4YK4UX6D3B6UL'),(59,1,'_wpsc_coupon','ilovemymum');

--
-- Table structure for table `wp_users`
--

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

--
-- Dumping data for table `wp_users`
--

INSERT INTO `wp_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$BQLaTvuKYtbsvEU0684yxNzZUgMn84.','admin','cam@hiddenshoal.com','','2012-09-07 03:04:06','',0,'Miss Partridge'),(2,'Yvette','$P$Bz/7/4udoLrvJmvZnOb11RpY7mYEKA.','yvette','belle@yvettemerton.com','','2012-11-26 02:52:38','',0,'Yvette');

--
-- Table structure for table `wp_websitez_stats`
--

CREATE TABLE `wp_websitez_stats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data` text NOT NULL,
  `device_type` int(2) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`created_at`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_websitez_stats`
--

INSERT INTO `wp_websitez_stats` (`id`, `data`, `device_type`, `created_at`) VALUES (1,'a:30:{s:15:\"SERVER_SOFTWARE\";s:6:\"Apache\";s:11:\"REQUEST_URI\";s:1:\"/\";s:4:\"PATH\";s:29:\"/sbin:/bin:/usr/sbin:/usr/bin\";s:9:\"FCGI_ROLE\";s:9:\"RESPONDER\";s:9:\"UNIQUE_ID\";s:24:\"UvBKQ654kroAAJxxh-AAAAA5\";s:9:\"HTTP_HOST\";s:23:\"partridgeandpear.com.au\";s:15:\"HTTP_CONNECTION\";s:5:\"close\";s:11:\"HTTP_ACCEPT\";s:74:\"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8\";s:15:\"HTTP_USER_AGENT\";s:128:\"Mozilla/5.0 (Linux; Android 4.4.2; Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1700.99 Mobile Safari/537.36\";s:12:\"HTTP_REFERER\";s:26:\"https://www.google.com.au/\";s:20:\"HTTP_ACCEPT_ENCODING\";s:17:\"gzip,deflate,sdch\";s:20:\"HTTP_ACCEPT_LANGUAGE\";s:26:\"en-GB,en-US;q=0.8,en;q=0.6\";s:16:\"SERVER_SIGNATURE\";s:68:\"<address>Apache Server at partridgeandpear.com.au Port 80</address>\n\";s:11:\"SERVER_NAME\";s:23:\"partridgeandpear.com.au\";s:11:\"SERVER_ADDR\";s:15:\"174.120.146.186\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"REMOTE_ADDR\";s:13:\"59.101.38.120\";s:13:\"DOCUMENT_ROOT\";s:50:\"/home/fluxustv/public_html/partridgeandpear.com.au\";s:12:\"SERVER_ADMIN\";s:39:\"webmaster@partridgeandpear.fluxustv.com\";s:15:\"SCRIPT_FILENAME\";s:60:\"/home/fluxustv/public_html/partridgeandpear.com.au/index.php\";s:11:\"REMOTE_PORT\";s:5:\"10164\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.1\";s:14:\"REQUEST_METHOD\";s:3:\"GET\";s:12:\"QUERY_STRING\";s:0:\"\";s:11:\"SCRIPT_NAME\";s:10:\"/index.php\";s:8:\"PHP_SELF\";s:10:\"/index.php\";s:12:\"REQUEST_TIME\";i:1391479363;s:4:\"argv\";a:0:{}s:4:\"argc\";i:0;}',1,'2014-02-04 02:02:43'),(2,'a:31:{s:15:\"SERVER_SOFTWARE\";s:6:\"Apache\";s:11:\"REQUEST_URI\";s:60:\"/index.php?wpsc_user_dynamic_js=true&ver=3.8.11.1.74e9456712\";s:4:\"PATH\";s:29:\"/sbin:/bin:/usr/sbin:/usr/bin\";s:9:\"FCGI_ROLE\";s:9:\"RESPONDER\";s:9:\"UNIQUE_ID\";s:24:\"UvBKRa54kroAAJF3hqoAAAAJ\";s:9:\"HTTP_HOST\";s:23:\"partridgeandpear.com.au\";s:15:\"HTTP_CONNECTION\";s:5:\"close\";s:11:\"HTTP_ACCEPT\";s:3:\"*/*\";s:15:\"HTTP_USER_AGENT\";s:128:\"Mozilla/5.0 (Linux; Android 4.4.2; Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1700.99 Mobile Safari/537.36\";s:12:\"HTTP_REFERER\";s:31:\"http://partridgeandpear.com.au/\";s:20:\"HTTP_ACCEPT_ENCODING\";s:17:\"gzip,deflate,sdch\";s:20:\"HTTP_ACCEPT_LANGUAGE\";s:26:\"en-GB,en-US;q=0.8,en;q=0.6\";s:11:\"HTTP_COOKIE\";s:259:\"websitez_is_mobile=true; websitez_mobile_detector_v1-8=true%7C1%7C0dd108e291dfc166df3f6ecad1826b81; PHPSESSID=a2208e720396e43f909a1c2727b7c39b; wpsc_customer_cookie_fbfa3592173c4c44dcfa7c161b849cc7=_oi4iJ7dusfM1%7C1391652163%7C01d04c8788fb93f0b7d586c469934fe9\";s:16:\"SERVER_SIGNATURE\";s:68:\"<address>Apache Server at partridgeandpear.com.au Port 80</address>\n\";s:11:\"SERVER_NAME\";s:23:\"partridgeandpear.com.au\";s:11:\"SERVER_ADDR\";s:15:\"174.120.146.186\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"REMOTE_ADDR\";s:13:\"59.101.38.120\";s:13:\"DOCUMENT_ROOT\";s:50:\"/home/fluxustv/public_html/partridgeandpear.com.au\";s:12:\"SERVER_ADMIN\";s:39:\"webmaster@partridgeandpear.fluxustv.com\";s:15:\"SCRIPT_FILENAME\";s:60:\"/home/fluxustv/public_html/partridgeandpear.com.au/index.php\";s:11:\"REMOTE_PORT\";s:5:\"10169\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.1\";s:14:\"REQUEST_METHOD\";s:3:\"GET\";s:12:\"QUERY_STRING\";s:49:\"wpsc_user_dynamic_js=true&ver=3.8.11.1.74e9456712\";s:11:\"SCRIPT_NAME\";s:10:\"/index.php\";s:8:\"PHP_SELF\";s:10:\"/index.php\";s:12:\"REQUEST_TIME\";i:1391479365;s:4:\"argv\";a:1:{i:0;s:49:\"wpsc_user_dynamic_js=true&ver=3.8.11.1.74e9456712\";}s:4:\"argc\";i:1;}',1,'2014-02-04 02:02:45');

--
-- Table structure for table `wp_wpsc_also_bought`
--

CREATE TABLE `wp_wpsc_also_bought` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `selected_product` bigint(20) unsigned NOT NULL DEFAULT '0',
  `associated_product` bigint(20) unsigned NOT NULL DEFAULT '0',
  `quantity` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=113 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_also_bought`
--

INSERT INTO `wp_wpsc_also_bought` (`id`, `selected_product`, `associated_product`, `quantity`) VALUES (1,118,69,1),(2,118,121,1),(3,118,274,1),(4,118,125,1),(5,69,118,1),(6,69,121,1),(7,69,274,1),(8,69,125,1),(9,121,118,1),(10,121,69,1),(11,121,274,1),(12,121,125,3),(13,274,118,1),(14,274,69,1),(15,274,121,1),(16,274,125,1),(17,125,118,1),(18,125,69,1),(19,125,121,2),(20,125,274,1),(21,118,69,1),(22,118,121,1),(23,118,274,1),(24,118,125,1),(25,69,118,1),(26,69,121,1),(27,69,274,1),(28,69,125,1),(29,121,118,1),(30,121,69,1),(31,121,274,1),(32,121,125,3),(33,274,118,1),(34,274,69,1),(35,274,121,1),(36,274,125,1),(37,125,118,1),(38,125,69,1),(39,125,121,2),(40,125,274,1),(41,69,121,2),(42,69,274,2),(43,69,125,1),(44,69,118,2),(45,69,256,1),(46,121,69,2),(47,121,274,2),(48,121,125,3),(49,121,118,2),(50,121,256,1),(51,274,69,2),(52,274,121,2),(53,274,125,1),(54,274,118,2),(55,274,256,1),(56,125,69,2),(57,125,121,3),(58,125,274,2),(59,125,118,2),(60,125,256,1),(61,118,69,2),(62,118,121,2),(63,118,274,2),(64,118,125,1),(65,118,256,1),(66,256,69,2),(67,256,121,2),(68,256,274,2),(69,256,125,1),(70,256,118,2),(71,126,266,1),(72,126,254,1),(73,266,126,1),(74,266,254,1),(75,254,126,1),(76,254,266,1),(77,109,249,1),(78,109,125,3),(79,109,254,1),(80,249,109,1),(81,249,125,1),(82,249,254,1),(83,125,109,3),(84,125,249,1),(85,125,254,1),(86,254,109,1),(87,254,249,1),(88,254,125,1),(89,258,69,1),(90,258,243,1),(91,258,125,1),(92,69,258,2),(93,69,243,1),(94,69,125,1),(95,243,258,2),(96,243,69,1),(97,243,125,1),(98,125,258,2),(99,125,69,1),(100,125,243,1),(101,274,109,1),(102,109,274,1),(103,109,355,2),(104,109,121,1),(105,355,109,2),(106,355,125,2),(107,355,121,1),(108,125,355,2),(109,121,109,2),(110,121,355,2),(111,121,333,1),(112,333,121,1);

--
-- Table structure for table `wp_wpsc_cart_contents`
--

CREATE TABLE `wp_wpsc_cart_contents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `prodid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `purchaseid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `price` decimal(11,2) NOT NULL DEFAULT '0.00',
  `pnp` decimal(11,2) NOT NULL DEFAULT '0.00',
  `tax_charged` decimal(11,2) NOT NULL DEFAULT '0.00',
  `gst` decimal(11,2) NOT NULL DEFAULT '0.00',
  `quantity` int(10) unsigned NOT NULL DEFAULT '0',
  `donation` varchar(1) NOT NULL DEFAULT '0',
  `no_shipping` varchar(1) NOT NULL DEFAULT '0',
  `custom_message` text NOT NULL,
  `files` text NOT NULL,
  `meta` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_cart_contents`
--

INSERT INTO `wp_wpsc_cart_contents` (`id`, `prodid`, `name`, `purchaseid`, `price`, `pnp`, `tax_charged`, `gst`, `quantity`, `donation`, `no_shipping`, `custom_message`, `files`, `meta`) VALUES (1,69,'Floral Tea',1,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(2,69,'Floral Tea',2,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(3,108,'Oranges and Lemons',3,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(4,161,'Test Product',4,0.50,0.00,0.00,0.00,1,'0','0','','N;',''),(5,161,'Test Product',5,0.50,0.00,0.00,0.00,1,'0','0','','N;',''),(6,121,'Butter Orange',6,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(7,118,'Cinnamon Spice Room Spray',7,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(8,69,'Floral Tea Room Spray',7,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(9,121,'Butter Orange Lip Balm',7,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(10,274,'Honey Choc Bliss Lip Balm',7,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(11,125,'Pick Me Up Peppermint Lip Balm',7,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(12,118,'Cinnamon Spice Room Spray',8,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(13,69,'Floral Tea Room Spray',8,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(14,121,'Butter Orange Lip Balm',8,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(15,274,'Honey Choc Bliss Lip Balm',8,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(16,125,'Pick Me Up Peppermint Lip Balm',8,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(17,69,'Floral Tea Room Spray',9,15.00,0.00,0.00,0.00,2,'0','0','','N;',''),(18,121,'Butter Orange Lip Balm',9,6.50,0.00,0.00,0.00,2,'0','0','','N;',''),(19,274,'Honey Choc Bliss Lip Balm',9,6.50,0.00,0.00,0.00,2,'0','0','','N;',''),(20,125,'Pick Me Up Peppermint Lip Balm',9,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(21,118,'Cinnamon Spice Room Spray',9,15.00,0.00,0.00,0.00,2,'0','0','','N;',''),(22,256,'Lime Sprig Draw Sachet',9,7.50,0.00,0.00,0.00,1,'0','0','','N;',''),(23,126,'Cocoa Coconut Lip Balm',10,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(24,266,'Floral Tea Perfume Pot',10,9.00,0.00,0.00,0.00,1,'0','0','','N;',''),(25,254,'Country House Draw Sachet',10,7.50,0.00,0.00,0.00,1,'0','0','','N;',''),(26,109,'Lavender Room Spray',11,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(27,249,'Spring Blossom Scented Eye Pillow',11,13.00,0.00,0.00,0.00,1,'0','0','','N;',''),(28,125,'Pick Me Up Peppermint Lip Balm',11,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(29,254,'Country House Draw Sachet',11,7.50,0.00,0.00,0.00,1,'0','0','','N;',''),(30,274,'Honey Choc Bliss Lip Balm',12,6.50,0.00,0.00,0.00,4,'0','0','','N;',''),(31,258,'Vintage Draw Sachet',13,7.50,0.00,0.00,0.00,2,'0','0','','N;',''),(32,69,'Floral Tea Room Spray',13,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(33,243,'Peonies Scented Eye Pillow',13,13.00,0.00,0.00,0.00,1,'0','0','','N;',''),(34,125,'Pick Me Up Peppermint Lip Balm',13,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(35,274,'Honey Choc Bliss Lip Balm',14,6.50,0.00,0.00,0.00,1,'0','0','','N;',''),(36,109,'Lavender Room Spray',14,15.00,0.00,0.00,0.00,1,'0','0','','N;',''),(37,227,'Eiffel Tower Unscented Eye Pillow',15,13.00,0.00,0.00,0.00,1,'0','0','','N;',''),(38,237,'Partridge and Pear Scented Eye Pillow',16,13.00,0.00,0.00,0.00,1,'0','0','','N;',''),(39,240,'Aqua Dragonfly Scented Eye Pillow',17,13.00,0.00,0.00,0.00,1,'0','0','','N;',''),(40,118,'Cinnamon Spice Room Spray',18,15.95,0.00,0.00,0.00,2,'0','0','','N;',''),(41,235,'White Butterfly Unscented Eye Pillow',19,13.00,0.00,0.00,0.00,5,'0','0','','N;',''),(42,109,'Lavender Room Spray',20,16.95,0.00,0.00,0.00,2,'0','0','','N;',''),(43,355,'Lavender Infused All Over Salve',20,19.00,0.00,0.00,0.00,2,'0','0','','N;',''),(44,125,'Pick Me Up Peppermint Lip Balm',20,8.00,0.00,0.00,0.00,2,'0','0','','N;',''),(45,121,'Butter Orange Lip Balm',20,8.00,0.00,0.00,0.00,1,'0','0','','N;',''),(46,121,'Butter Orange Lip Balm',21,8.00,0.00,0.00,0.00,1,'0','0','','N;',''),(47,333,'Hand & Heel Salve',21,13.95,0.00,0.00,0.00,1,'0','0','','N;','');

--
-- Table structure for table `wp_wpsc_cart_item_meta`
--

CREATE TABLE `wp_wpsc_cart_item_meta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `wpsc_cart_item_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  `meta_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`meta_id`),
  KEY `wpsc_cart_item_id` (`wpsc_cart_item_id`),
  KEY `meta_key` (`meta_key`(191)),
  KEY `meta_value` (`meta_value`(20)),
  KEY `meta_key_and_value` (`meta_key`(191),`meta_value`(32)),
  KEY `meta_timestamp_index` (`meta_timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_cart_item_meta`
--

INSERT INTO `wp_wpsc_cart_item_meta` (`meta_id`, `wpsc_cart_item_id`, `meta_key`, `meta_value`, `meta_timestamp`) VALUES (1,1,'sku','','2014-08-23 01:10:46'),(2,2,'sku','','2014-08-23 01:10:46'),(3,3,'sku','','2014-08-23 01:10:46'),(4,4,'sku','','2014-08-23 01:10:46'),(5,5,'sku','','2014-08-23 01:10:46'),(6,6,'sku','','2014-08-23 01:10:46'),(7,7,'sku','','2014-08-23 01:10:46'),(8,8,'sku','','2014-08-23 01:10:46'),(9,9,'sku','','2014-08-23 01:10:46'),(10,10,'sku','','2014-08-23 01:10:46'),(11,11,'sku','','2014-08-23 01:10:46'),(12,12,'sku','','2014-08-23 01:10:46'),(13,13,'sku','','2014-08-23 01:10:46'),(14,14,'sku','','2014-08-23 01:10:46'),(15,15,'sku','','2014-08-23 01:10:46'),(16,16,'sku','','2014-08-23 01:10:46'),(17,17,'sku','','2014-08-23 01:10:46'),(18,18,'sku','','2014-08-23 01:10:46'),(19,19,'sku','','2014-08-23 01:10:46'),(20,20,'sku','','2014-08-23 01:10:46'),(21,21,'sku','','2014-08-23 01:10:46'),(22,22,'sku','','2014-08-23 01:10:46'),(23,23,'sku','','2014-08-23 01:10:46'),(24,24,'sku','','2014-08-23 01:10:46'),(25,25,'sku','','2014-08-23 01:10:46'),(26,26,'sku','','2014-08-23 01:10:46'),(27,27,'sku','','2014-08-23 01:10:46'),(28,28,'sku','','2014-08-23 01:10:46'),(29,29,'sku','','2014-08-23 01:10:46'),(30,30,'sku','','2014-08-23 01:10:46'),(31,31,'sku','','2014-08-23 01:10:46'),(32,32,'sku','','2014-08-23 01:10:46'),(33,33,'sku','','2014-08-23 01:10:46'),(34,34,'sku','','2014-08-23 01:10:46'),(35,35,'sku','','2014-08-23 01:10:46'),(36,36,'sku','','2014-08-23 01:10:46'),(37,37,'sku','','2014-08-23 01:10:46'),(38,38,'sku','','2014-08-23 01:10:46'),(39,39,'sku','','2014-08-23 01:10:46'),(40,40,'sku','','2014-08-23 01:10:46'),(41,41,'sku','','2014-08-23 01:10:46'),(42,42,'sku','','2014-08-23 01:10:46'),(43,43,'sku','','2014-08-23 01:10:46'),(44,44,'sku','','2014-08-23 01:10:46'),(45,45,'sku','','2014-08-23 01:10:46'),(46,46,'sku','','2014-08-23 01:10:46'),(47,47,'sku','','2014-08-23 01:10:46');

--
-- Table structure for table `wp_wpsc_checkout_forms`
--

CREATE TABLE `wp_wpsc_checkout_forms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `type` varchar(64) NOT NULL DEFAULT '',
  `mandatory` varchar(1) NOT NULL DEFAULT '0',
  `display_log` char(1) NOT NULL DEFAULT '0',
  `default` varchar(128) NOT NULL DEFAULT '0',
  `active` varchar(1) NOT NULL DEFAULT '1',
  `checkout_order` int(10) unsigned NOT NULL DEFAULT '0',
  `unique_name` varchar(255) NOT NULL DEFAULT '',
  `options` longtext NOT NULL,
  `checkout_set` varchar(64) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `checkout_order` (`checkout_order`),
  KEY `unique_name` (`unique_name`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_checkout_forms`
--

INSERT INTO `wp_wpsc_checkout_forms` (`id`, `name`, `type`, `mandatory`, `display_log`, `default`, `active`, `checkout_order`, `unique_name`, `options`, `checkout_set`) VALUES (1,'Your billing/contact details','heading','0','0','1','1',0,'your-billingcontact-details','','0'),(2,'First Name','text','1','1','1','1',1,'billingfirstname','','0'),(3,'Last Name','text','1','1','1','1',2,'billinglastname','','0'),(4,'Address','address','1','0','1','1',3,'billingaddress','','0'),(5,'City','city','1','0','1','1',4,'billingcity','','0'),(6,'State','text','0','0','1','1',5,'billingstate','','0'),(7,'Country','country','1','0','1','1',6,'billingcountry','','0'),(8,'Postal Code','text','0','0','1','1',7,'billingpostcode','','0'),(9,'Email','email','1','1','1','1',9,'billingemail','','0'),(10,'Shipping Address','heading','0','0','1','1',10,'delivertoafriend','','0'),(11,'First Name','text','0','0','1','1',11,'shippingfirstname','','0'),(12,'Last Name','text','0','0','1','1',12,'shippinglastname','','0'),(13,'Address','address','0','0','1','1',13,'shippingaddress','','0'),(14,'City','city','0','0','1','1',14,'shippingcity','','0'),(15,'State','text','0','0','1','1',15,'shippingstate','','0'),(16,'Country','delivery_country','0','0','1','1',16,'shippingcountry','','0'),(17,'Postal Code','text','0','0','1','1',17,'shippingpostcode','','0'),(18,'Phone','text','1','0','','1',8,'billingphone','','0');

--
-- Table structure for table `wp_wpsc_claimed_stock`
--

CREATE TABLE `wp_wpsc_claimed_stock` (
  `product_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `variation_stock_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `stock_claimed` float NOT NULL,
  `last_activity` datetime NOT NULL,
  `cart_id` varchar(255) NOT NULL DEFAULT '0',
  `cart_submitted` varchar(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `unique_key` (`product_id`,`variation_stock_id`,`cart_id`),
  KEY `last_activity` (`last_activity`),
  KEY `cart_submitted` (`cart_submitted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_claimed_stock`
--

INSERT INTO `wp_wpsc_claimed_stock` (`product_id`, `variation_stock_id`, `stock_claimed`, `last_activity`, `cart_id`, `cart_submitted`) VALUES (254,0,2,'2014-08-23 01:16:52','9807903b87fb7c5720e66d441dc31f7ab91428a8','0'),(227,0,1,'2014-08-23 01:40:44','9807903b87fb7c5720e66d441dc31f7ab91428a8','0'),(227,0,2,'2014-08-23 04:22:09','d465b19476172d6a25488d2a6b2473b9200cb817','0'),(254,0,1,'2014-08-23 04:22:51','e709e3d45a6194c93cd98f7aa2c1aa57d8b500c8','0'),(254,0,1,'2014-08-23 04:23:23','3abdf3f08bc58e8b01c8c32abb9f61ec307946c9','0');

--
-- Table structure for table `wp_wpsc_coupon_codes`
--

CREATE TABLE `wp_wpsc_coupon_codes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coupon_code` varchar(255) DEFAULT '',
  `value` decimal(11,2) NOT NULL DEFAULT '0.00',
  `is-percentage` char(1) NOT NULL DEFAULT '0',
  `use-once` char(1) NOT NULL DEFAULT '0',
  `is-used` char(1) NOT NULL DEFAULT '0',
  `active` char(1) NOT NULL DEFAULT '1',
  `every_product` varchar(255) NOT NULL DEFAULT '',
  `start` datetime NOT NULL,
  `expiry` datetime NOT NULL,
  `condition` text,
  PRIMARY KEY (`id`),
  KEY `coupon_code` (`coupon_code`),
  KEY `active` (`active`),
  KEY `start` (`start`),
  KEY `expiry` (`expiry`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_coupon_codes`
--

INSERT INTO `wp_wpsc_coupon_codes` (`id`, `coupon_code`, `value`, `is-percentage`, `use-once`, `is-used`, `active`, `every_product`, `start`, `expiry`, `condition`) VALUES (2,'ilovemymum',20.00,'1','0','0','0','1','2014-04-29 00:00:00','2015-05-29 23:59:59','a:1:{i:0;a:4:{s:8:\"operator\";s:0:\"\";s:8:\"property\";s:15:\"subtotal_amount\";s:5:\"logic\";s:7:\"greater\";s:5:\"value\";s:2:\"20\";}}');

--
-- Table structure for table `wp_wpsc_currency_list`
--

CREATE TABLE `wp_wpsc_currency_list` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(255) NOT NULL DEFAULT '',
  `isocode` char(2) DEFAULT '',
  `currency` varchar(255) NOT NULL DEFAULT '',
  `symbol` varchar(10) NOT NULL DEFAULT '',
  `symbol_html` varchar(10) NOT NULL DEFAULT '',
  `code` char(3) NOT NULL DEFAULT '',
  `has_regions` char(1) NOT NULL DEFAULT '0',
  `tax` varchar(8) NOT NULL DEFAULT '',
  `continent` varchar(20) NOT NULL DEFAULT '',
  `visible` varchar(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=254 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_currency_list`
--

INSERT INTO `wp_wpsc_currency_list` (`id`, `country`, `isocode`, `currency`, `symbol`, `symbol_html`, `code`, `has_regions`, `tax`, `continent`, `visible`) VALUES (1,'Mauritania','MR','Mauritanian Ouguiya','','','MRO','0','0','africa','0'),(2,'Martinique (French)','MQ','Euro','€','&#8364;','EUR','0','0','southamerica','0'),(3,'Malta','MT','Euro','€','&#8364;','EUR','0','0','europe','0'),(4,'Marshall Islands','MH','US Dollar','$','&#036;','USD','0','0','asiapacific','0'),(5,'Mali','ML','CFA Franc BCEAO','','','XOF','0','0','africa','0'),(6,'Maldives','MV','Maldive Rufiyaa','','','MVR','0','0','asiapacific','0'),(7,'Malaysia','MY','Malaysian Ringgit','','','MYR','0','0','asiapacific','0'),(8,'Malawi','MW','Malawi Kwacha','','','MWK','0','0','africa','0'),(9,'Madagascar','MG','Malagasy Ariary','','','MGA','0','0','africa','0'),(10,'Macau','MO','Macau Pataca','','','MOP','0','0','asiapacific','0'),(11,'Macedonia','MK','Denar','','','MKD','0','0','europe','0'),(12,'Luxembourg','LU','Euro','€','&#8364;','EUR','0','0','europe','0'),(13,'Lithuania','LT','Lithuanian Litas','','','LTL','0','0','europe','0'),(14,'Liechtenstein','LI','Swiss Franc','','','CHF','0','0','europe','0'),(15,'Libya','LY','Libyan Dinar','','','LYD','0','0','africa','0'),(16,'Liberia','LR','Liberian Dollar','$','&#036;','LRD','0','0','africa','0'),(17,'Lesotho','LS','Lesotho Loti','','','LSL','0','0','africa','0'),(18,'Lebanon','LB','Lebanese Pound','','','LBP','0','0','asiapacific','0'),(19,'Latvia','LV','Latvian Lats','','','LVL','0','0','europe','0'),(20,'Laos','LA','Lao Kip','','','LAK','0','0','asiapacific','0'),(21,'Kyrgyzstan','KG','Som','','','KGS','0','0','asiapacific','0'),(22,'Kuwait','KW','Kuwaiti Dinar','','','KWD','0','0','asiapacific','0'),(23,'Korea, South','KR','Korean Won','','','KRW','0','0','asiapacific','0'),(24,'Korea, North','KP','North Korean Won','','','KPW','0','0','asiapacific','0'),(25,'Kiribati','KI','Australian Dollar','$','&#036;','AUD','0','0','asiapacific','0'),(26,'Kenya','KE','Kenyan Shilling','','','KES','0','0','africa','0'),(27,'Kazakhstan','KZ','Kazakhstan Tenge','','','KZT','0','0','asiapacific','0'),(28,'Jordan','JO','Jordanian Dinar','','','JOD','0','0','asiapacific','0'),(29,'Jersey','JE','Pound Sterling','£','&#163;','GBP','0','0','europe','0'),(30,'Japan','JP','Japanese Yen','¥','&#165;','JPY','0','0','asiapacific','0'),(31,'Jamaica','JM','Jamaican Dollar','$','&#036;','JMD','0','0','southamerica','0'),(32,'Ivory Coast','CI','CFA Franc BCEAO','','','XOF','0','0','africa','0'),(33,'Italy','IT','Euro','€','&#8364;','EUR','0','0','europe','0'),(34,'Isle of Man','IM','Pound Sterling','£','&#163;','GBP','0','0','europe','0'),(35,'Israel','IL','Israeli New Shekel','₪','&#8362;','ILS','0','0','asiapacific','0'),(36,'Ireland','IE','Euro','€','&#8364;','EUR','0','0','europe','0'),(37,'Iraq','IQ','Iraqi Dinar','','','IQD','0','0','asiapacific','0'),(38,'Indonesia','ID','Indonesian Rupiah','','','IDR','0','0','asiapacific','0'),(39,'Iran','IR','Iranian Rial','','','IRR','0','0','asiapacific','0'),(40,'India','IN','Indian Rupee','','','INR','0','0','asiapacific','0'),(41,'Iceland','IS','Iceland Krona','','','ISK','0','0','europe','0'),(42,'Hungary','HU','Hungarian Forint','','','HUF','0','0','europe','0'),(43,'Hong Kong','HK','Hong Kong Dollar','$','&#036;','HKD','0','0','asiapacific','0'),(44,'Honduras','HN','Honduran Lempira','','','HNL','0','0','southamerica','0'),(45,'Heard Island and McDonald Islands','HM','Australian Dollar','$','&#036;','AUD','0','0','asiapacific','0'),(46,'Haiti','HT','Haitian Gourde','','','HTG','0','0','southamerica','0'),(47,'Guyana','GY','Guyana Dollar','$','&#036;','GYD','0','0','southamerica','0'),(48,'Guinea Bissau','GW','CFA Franc BEAC','','','XAF','0','0','africa','0'),(49,'Guinea','GN','Guinea Franc','','','GNF','0','0','africa','0'),(50,'Guernsey','GG','Pound Sterling','£','&#163;','GBP','0','0','europe','0'),(51,'Guatemala','GT','Guatemalan Quetzal','','','GTQ','0','0','southamerica','0'),(52,'Guam (USA)','GU','US Dollar','$','&#036;','USD','0','0','asiapacific','0'),(53,'Grenada','GD','East Carribean Dollar','$','&#036;','XCD','0','0','africa','0'),(54,'Guadeloupe (French)','GP','Euro','€','&#8364;','EUR','0','0','southamerica','0'),(55,'Greenland','GL','Danish Krone','','','DKK','0','0','europe','0'),(56,'Greece','GR','Euro','€','&#8364;','EUR','0','19','europe','0'),(57,'Gibraltar','GI','Gibraltar Pound','','','GIP','0','0','europe','0'),(58,'Ghana','GH','Ghanaian Cedi','','','GHS','0','0','africa','0'),(59,'Germany','DE','Euro','€','&#8364;','EUR','0','0','europe','0'),(60,'Georgia','GE','Georgian Lari','','','GEL','0','0','europe','0'),(61,'Gambia','GM','Gambian Dalasi','','','GMD','0','0','africa','0'),(62,'Gabon','GA','CFA Franc BEAC','','','XAF','0','0','africa','0'),(63,'French Southern Territories','TF','Euro','€','&#8364;','EUR','0','0','africa','0'),(64,'France','FR','Euro','€','&#8364;','EUR','0','0','europe','0'),(65,'Finland','FI','Euro','€','&#8364;','EUR','0','0','europe','0'),(66,'Fiji','FJ','Fiji Dollar','$','&#036;','FJD','0','0','asiapacific','0'),(67,'Faroe Islands','FO','Danish Krone','','','DKK','0','0','europe','0'),(68,'Falkland Islands','FK','Falkland Islands Pound','','','FKP','0','0','southamerica','0'),(69,'Ethiopia','ET','Ethiopian Birr','','','ETB','0','0','africa','0'),(70,'Estonia','EE','Euro','€','&#8364;','EUR','0','0','europe','0'),(71,'Eritrea','ER','Eritrean Nakfa','','','ERN','0','0','africa','0'),(72,'Equatorial Guinea','GQ','CFA Franc BEAC','','','XAF','0','0','africa','0'),(73,'El Salvador','SV','US Dollar','$','&#036;','USD','0','0','southamerica','0'),(74,'Egypt','EG','Egyptian Pound','','','EGP','0','0','africa','0'),(75,'Ecuador','EC','Ecuador Sucre','','','ECS','0','0','southamerica','0'),(76,'Timor-Leste','TL','US Dollar','$','&#036;','USD','0','0','asiapacific','0'),(77,'Dominican Republic','DO','Dominican Peso','','','DOP','0','0','southamerica','0'),(78,'Dominica','DM','East Caribbean Dollar','$','&#036;','XCD','0','0','southamerica','0'),(79,'Djibouti','DJ','Djibouti Franc','','','DJF','0','0','africa','0'),(80,'Denmark','DK','Danish Krone','','','DKK','0','0','europe','0'),(81,'Democratic Republic of Congo','CD','Francs','','','CDF','0','0','africa','0'),(82,'Czech Rep.','CZ','Czech Koruna','','','CZK','0','0','europe','0'),(83,'Cyprus','CY','Euro','€','&#8364;','EUR','0','0','europe','0'),(84,'Cuba','CU','Cuban Peso','','','CUP','0','0','northamerica','0'),(85,'Croatia','HR','Croatian Kuna','','','HRK','0','0','europe','0'),(86,'Costa Rica','CR','Costa Rican Colon','','','CRC','0','0','southamerica','0'),(87,'Cook Islands','CK','New Zealand Dollar','$','&#036;','NZD','0','0','asiapacific','0'),(88,'Republic of the Congo','CG','CFA Franc BEAC','','','XAF','0','0','africa','0'),(89,'Comoros','KM','Comoros Franc','','','KMF','0','0','africa','0'),(90,'Colombia','CO','Colombian Peso','$','&#036;','COP','0','0','southamerica','0'),(91,'Cocos (Keeling) Islands','CC','Australian Dollar','$','&#036;','AUD','0','0','asiapacific','0'),(92,'Christmas Island','CX','Australian Dollar','$','&#036;','AUD','0','0','asiapacific','0'),(93,'Chile','CL','Chilean Peso','','','CLP','0','0','asiapacific','0'),(94,'China','CN','Yuan Renminbi','','','CNY','0','0','asiapacific','0'),(95,'Chad','TD','CFA Franc BEAC','','','XAF','0','0','africa','0'),(96,'Central African Republic','CF','CFA Franc BEAC','','','XAF','0','0','africa','0'),(97,'Cayman Islands','KY','Cayman Islands Dollar','$','&#036;','KYD','0','0','northamerica','0'),(98,'Cape Verde','CV','Cape Verde Escudo','','','CVE','0','0','africa','0'),(99,'Cameroon','CM','CFA Franc BEAC','','','XAF','0','0','africa','0'),(100,'Canada','CA','Canadian Dollar','$','&#036;','CAD','1','','northamerica','0'),(101,'Cambodia','KH','Kampuchean Riel','','','KHR','0','0','asiapacific','0'),(102,'Burundi','BI','Burundi Franc','','','BIF','0','0','africa','0'),(103,'Burkina Faso','BF','CFA Franc BCEAO','','','XOF','0','0','africa','0'),(104,'Bulgaria','BG','Bulgarian Lev','','','BGN','0','0','europe','0'),(105,'Brunei Darussalam','BN','Brunei Dollar','$','&#036;','BND','0','0','asiapacific','0'),(106,'British Indian Ocean Territory','IO','US Dollar','$','&#036;','USD','0','0','asiapacific','0'),(107,'Brazil','BR','Brazilian Real','','','BRL','0','0','southamerica','0'),(108,'Bouvet Island','BV','Norwegian Krone','','','NOK','0','0','africa','0'),(109,'Botswana','BW','Botswana Pula','','','BWP','0','0','africa','0'),(110,'Bosnia-Herzegovina','BA','Marka','','','BAM','0','0','europe','0'),(111,'Bolivia','BO','Boliviano','','','BOB','0','0','southamerica','0'),(112,'Bhutan','BT','Bhutan Ngultrum','','','BTN','0','0','asiapacific','0'),(113,'Bermuda','BM','Bermudian Dollar','$','&#036;','BMD','0','0','europe','0'),(114,'Benin','BJ','CFA Franc BCEAO','','','XOF','0','0','africa','0'),(115,'Belize','BZ','Belize Dollar','$','&#036;','BZD','0','0','northamerica','0'),(116,'Belgium','BE','Euro','€','&#8364;','EUR','0','0','europe','0'),(117,'Belarus','BY','Belarussian Ruble','','','BYR','0','0','europe','0'),(118,'Barbados','BB','Barbados Dollar','$','&#036;','BBD','0','0','southamerica','0'),(119,'Bangladesh','BD','Bangladeshi Taka','','','BDT','0','0','asiapacific','0'),(120,'Bahrain','BH','Bahraini Dinar','','','BHD','0','0','asiapacific','0'),(121,'Bahamas','BS','Bahamian Dollar','$','&#036;','BSD','0','0','northamerica','0'),(122,'Azerbaijan','AZ','Azerbaijani Manat','m','m','AZN','0','0','asiapacific','0'),(123,'Austria','AT','Euro','€','&#8364;','EUR','0','0','europe','0'),(124,'Aruba','AW','Aruban Florin','Afl.','Afl.','AWG','0','0','southamerica','0'),(125,'Armenia','AM','Armenian Dram','','','AMD','0','0','asiapacific','0'),(126,'Argentina','AR','Argentine Peso','','','ARS','0','0','southamerica','0'),(127,'Antigua and Barbuda','AG','East Caribbean Dollar','$','&#036;','XCD','0','0','africa','0'),(128,'Antarctica','AQ','Dollar','$','&#036;','ATA','0','0','antarctica','0'),(129,'Anguilla','AI','East Caribbean Dollar','$','&#036;','XCD','0','0','northamerica','0'),(130,'Angola','AO','Angolan Kwanza','Kz','Kz','AOA','0','0','africa','0'),(131,'Andorra','AD','Euro','€','&#8364;','EUR','0','0','europe','0'),(132,'American Samoa','AS','US Dollar','$','&#036;','USD','0','0','asiapacific','0'),(133,'Algeria','DZ','Algerian Dinar','','','DZD','0','0','africa','0'),(134,'Albania','AL','Albanian Lek','','','ALL','0','0','europe','0'),(135,'Afghanistan','AF','Afghanistan Afghani','','','AFA','0','0','asiapacific','0'),(136,'USA','US','US Dollar','$','&#036;','USD','1','','northamerica','0'),(137,'Australia','AU','Australian Dollar','$','&#036;','AUD','0','0','asiapacific','1'),(139,'Mauritius','MU','Mauritius Rupee','','','MUR','0','0','africa','0'),(140,'Mayotte','YT','Euro','€','&#8364;','EUR','0','0','europe','0'),(141,'Mexico','MX','Mexican Peso','$','&#036;','MXN','1','','northamerica','0'),(142,'Micronesia','FM','US Dollar','$','&#036;','USD','0','0','asiapacific','0'),(143,'Moldova','MD','Moldovan Leu','','','MDL','0','0','europe','0'),(144,'Monaco','MC','Euro','€','&#8364;','EUR','0','0','europe','0'),(145,'Mongolia','MN','Mongolian Tugrik','','','MNT','0','0','asiapacific','0'),(146,'Montserrat','MS','East Caribbean Dollar','$','&#036;','XCD','0','0','africa','0'),(147,'Morocco','MA','Moroccan Dirham','','','MAD','0','0','africa','0'),(148,'Mozambique','MZ','Mozambique Metical','','','MZN','0','0','africa','0'),(149,'Myanmar','MM','Myanmar Kyat','','','MMK','0','0','asiapacific','0'),(150,'Namibia','NA','Namibian Dollar','$','&#036;','NAD','0','0','africa','0'),(151,'Nauru','NR','Australian Dollar','$','&#036;','AUD','0','0','asiapacific','0'),(152,'Nepal','NP','Nepalese Rupee','','','NPR','0','0','asiapacific','0'),(153,'Netherlands','NL','Euro','€','&#8364;','EUR','0','0','europe','0'),(154,'Netherlands Antilles','AN','Netherlands Antillean Guilder','ƒ','&#402;','ANG','0','0','africa','0'),(155,'New Caledonia (French)','NC','CFP Franc','','','XPF','0','0','asiapacific','0'),(156,'New Zealand','NZ','New Zealand Dollar','$','&#036;','NZD','0','12.5','asiapacific','0'),(157,'Nicaragua','NI','Nicaraguan Cordoba Oro','','','NIO','0','0','northamerica','0'),(158,'Niger','NE','CFA Franc BCEAO','','','XOF','0','0','africa','0'),(159,'Nigeria','NG','Nigerian Naira','','','NGN','0','0','africa','0'),(160,'Niue','NU','New Zealand Dollar','$','&#036;','NZD','0','0','asiapacific','0'),(161,'Norfolk Island','NF','Australian Dollar','$','&#036;','AUD','0','0','asiapacific','0'),(162,'Northern Mariana Islands','MP','US Dollar','$','&#036;','USD','0','0','asiapacific','0'),(163,'Norway','NO','Norwegian Krone','','','NOK','0','0','europe','0'),(164,'Oman','OM','Omani Rial','','','OMR','0','0','asiapacific','0'),(165,'Pakistan','PK','Pakistan Rupee','','','PKR','0','0','asiapacific','0'),(166,'Palau','PW','US Dollar','$','&#036;','USD','0','0','asiapacific','0'),(167,'Panama','PA','Panamanian Balboa','','','PAB','0','0','southamerica','0'),(168,'Papua New Guinea','PG','Papua New Guinea Kina','','','PGK','0','0','asiapacific','0'),(169,'Paraguay','PY','Paraguay Guarani','','','PYG','0','0','southamerica','0'),(170,'Peru','PE','Peruvian Nuevo Sol','','','PEN','0','0','southamerica','0'),(171,'Philippines','PH','Philippine Peso','','','PHP','0','0','asiapacific','0'),(172,'Pitcairn Island','PN','New Zealand Dollar','$','&#036;','NZD','0','0','asiapacific','0'),(173,'Poland','PL','Polish Zloty','','','PLN','0','0','europe','0'),(174,'Polynesia (French)','PF','CFP Franc','','','XPF','0','0','asiapacific','0'),(175,'Portugal','PT','Euro','€','&#8364;','EUR','0','0','europe','0'),(176,'Puerto Rico','PR','US Dollar','$','&#036;','USD','0','0','northamerica','0'),(177,'Qatar','QA','Qatari Rial','','','QAR','0','0','asiapacific','0'),(178,'Reunion (French)','RE','Euro','€','&#8364;','EUR','0','0','europe','0'),(179,'Romania','RO','Romanian New Leu','','','RON','0','0','europe','0'),(180,'Russia','RU','Russian Ruble','','','RUB','0','0','europe','0'),(181,'Rwanda','RW','Rwanda Franc','','','RWF','0','0','africa','0'),(182,'Saint Helena','SH','St. Helena Pound','','','SHP','0','0','africa','0'),(183,'Saint Kitts & Nevis Anguilla','KN','East Caribbean Dollar','$','&#036;','XCD','0','0','northamerica','0'),(184,'Saint Lucia','LC','East Caribbean Dollar','$','&#036;','XCD','0','0','northamerica','0'),(185,'Saint Pierre and Miquelon','PM','Euro','€','&#8364;','EUR','0','0','northamerica','0'),(186,'Saint Vincent & Grenadines','VC','East Caribbean Dollar','$','&#036;','XCD','0','0','northamerica','0'),(187,'Samoa','WS','Samoan Tala','','','WST','0','0','asiapacific','0'),(188,'San Marino','SM','Euro','€','&#8364;','EUR','0','0','europe','0'),(189,'Sao Tome and Principe','ST','Dobra','','','STD','0','0','africa','0'),(190,'Saudi Arabia','SA','Saudi Riyal','','','SAR','0','0','asiapacific','0'),(191,'Senegal','SN','CFA Franc BCEAO','','','XOF','0','0','africa','0'),(192,'Seychelles','SC','Seychelles Rupee','','','SCR','0','0','africa','0'),(193,'Sierra Leone','SL','Sierra Leone Leone','','','SLL','0','0','africa','0'),(194,'Singapore','SG','Singapore Dollar','$','&#036;','SGD','0','0','asiapacific','0'),(195,'Slovakia','SK','Euro','€','&#8364;','EUR','0','0','europe','0'),(196,'Slovenia','SI','Euro','€','&#8364;','EUR','0','0','europe','0'),(197,'Solomon Islands','SB','Solomon Islands Dollar','$','&#036;','SBD','0','0','asiapacific','0'),(198,'Somalia','SO','Somali Shilling','','','SOS','0','0','africa','0'),(199,'South Africa','ZA','South African Rand','','','ZAR','0','0','africa','0'),(200,'South Georgia & South Sandwich Islands','GS','Pound Sterling','£','&#163;','GBP','0','0','southamerica','0'),(201,'Spain','ES','Euro','€','&#8364;','EUR','0','0','europe','0'),(202,'Sri Lanka','LK','Sri Lanka Rupee','','','LKR','0','0','asiapacific','0'),(203,'Sudan','SD','Sudanese Pound','','','SDG','0','0','africa','0'),(204,'Suriname','SR','Surinamese Dollar','','','SRD','0','0','southamerica','0'),(205,'Svalbard and Jan Mayen Islands','SJ','Norwegian Krone','','','NOK','0','0','','0'),(206,'Swaziland','SZ','Swaziland Lilangeni','','','SZL','0','0','africa','0'),(207,'Sweden','SE','Swedish Krona','','','SEK','0','0','europe','0'),(208,'Switzerland','CH','Swiss Franc','','','CHF','0','0','europe','0'),(209,'Syria','SY','Syrian Pound','','','SYP','0','0','europe','0'),(210,'Taiwan','TW','New Taiwan Dollar','$','&#036;','TWD','0','0','asiapacific','0'),(211,'Tajikistan','TJ','Tajik Somoni','','','TJS','0','0','asiapacific','0'),(212,'Tanzania','TZ','Tanzanian Shilling','','','TZS','0','0','africa','0'),(213,'Thailand','TH','Thai Baht','','','THB','0','0','asiapacific','0'),(214,'Togo','TG','CFA Franc BCEAO','','','XOF','0','0','africa','0'),(215,'Tokelau','TK','New Zealand Dollar','$','&#036;','NZD','0','0','asiapacific','0'),(216,'Tonga','TO','Tongan Pa&#699;anga','','','TOP','0','0','asiapacific','0'),(217,'Trinidad and Tobago','TT','Trinidad and Tobago Dollar','$','&#036;','TTD','0','0','africa','0'),(218,'Tunisia','TN','Tunisian Dinar','$','&#036;','TND','0','0','africa','0'),(219,'Turkey','TR','Turkish Lira','','','TRY','0','0','asiapacific','0'),(220,'Turkmenistan','TM','Manat','','','TMM','0','0','asiapacific','0'),(221,'Turks and Caicos Islands','TC','US Dollar','$','&#036;','USD','0','0','northamerica','0'),(222,'Tuvalu','TV','Australian Dollar','$','&#036;','AUD','0','0','asiapacific','0'),(223,'United Kingdom','GB','Pound Sterling','£','&#163;','GBP','0','0','europe','1'),(224,'Uganda','UG','Uganda Shilling','','','UGX','0','0','africa','0'),(225,'Ukraine','UA','Ukraine Hryvnia','₴','&#8372;','UAH','0','0','europe','0'),(226,'United Arab Emirates','AE','Arab Emirates Dirham','','','AED','0','0','asiapacific','0'),(227,'Uruguay','UY','Uruguayan Peso','','','UYU','0','0','southamerica','0'),(228,'USA Minor Outlying Islands','UM','US Dollar','$','&#036;','USD','0','0','','0'),(229,'Uzbekistan','UZ','Uzbekistan Sum','','','UZS','0','0','asiapacific','0'),(230,'Vanuatu','VU','Vanuatu Vatu','','','VUV','0','0','asiapacific','0'),(231,'Vatican','VA','Euro','€','&#8364;','EUR','0','0','europe','0'),(232,'Venezuela','VE','Venezuelan Bolivar Fuerte','','','VEF','0','0','asiapacific','0'),(233,'Vietnam','VN','Vietnamese Dong','','','VND','0','0','asiapacific','0'),(234,'Virgin Islands (British)','VG','US Dollar','$','&#036;','USD','0','0','northamerica','0'),(235,'Virgin Islands (USA)','VI','US Dollar','$','&#036;','USD','0','0','northamerica','0'),(236,'Wallis and Futuna Islands','WF','CFP Franc','','','XPF','0','0','asiapacific','0'),(237,'Western Sahara','EH','Moroccan Dirham','','','MAD','0','0','africa','0'),(238,'Yemen','YE','Yemeni Rial','','','YER','0','0','asiapacific','0'),(240,'Zambia','ZM','Zambian Kwacha','','','ZMK','0','0','africa','0'),(241,'Zimbabwe','ZW','US Dollar','$','&#036;','USD','0','0','africa','0'),(242,'South Sudan','SS','South Sudanese Pound','','','SSP','0','0','africa','0'),(243,'Serbia','RS','Serbian Dinar','','','RSD','0','0','europe','0'),(244,'Montenegro','ME','Euro','€','&#8364;','EUR','0','0','europe','0'),(246,'Aland Islands','AX','Euro','€','&#8364;','EUR','0','0','europe','0'),(247,'Saint Barthelemy','BL','Euro','€','&#8364;','EUR','0','0','europe','0'),(248,'Bonaire, Sint Eustatius and Saba','BQ','US Dollar','$','&#036;','USD','0','0','southamerica','0'),(249,'Curacao','CW','Netherlands Antillean Guilder','ƒ','&#402;','ANG','0','0','southamerica','0'),(250,'Saint Martin (French Part)','MF','Euro','€','&#8364;','EUR','0','0','southamerica','0'),(251,'Palestinian Territories','PS','Israeli New Shekel','₪','&#8362;','ILS','0','0','asiapacific','0'),(252,'Sint Maarten (Dutch Part)','SX','Netherlands Antillean Guilder','ƒ','&#402;','ANG','0','0','africa','0'),(253,'French Guiana','GF','Euro','€','&#8364;','EUR','0','0','southamerica','0');

--
-- Table structure for table `wp_wpsc_download_status`
--

CREATE TABLE `wp_wpsc_download_status` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `fileid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `purchid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `cartid` bigint(20) unsigned DEFAULT NULL,
  `uniqueid` varchar(64) DEFAULT '',
  `downloads` int(11) NOT NULL DEFAULT '0',
  `ip_number` varchar(255) NOT NULL DEFAULT '',
  `active` varchar(1) NOT NULL DEFAULT '0',
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniqueid` (`uniqueid`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_download_status`
--


--
-- Table structure for table `wp_wpsc_meta`
--

CREATE TABLE `wp_wpsc_meta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `object_type` varchar(24) NOT NULL DEFAULT 'cart_Item',
  `object_id` bigint(20) NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`meta_id`),
  KEY `object_type__meta_key` (`object_type`,`meta_key`),
  KEY `object_type__object_id__meta_key` (`object_type`,`object_id`,`meta_key`)
) ENGINE=MyISAM AUTO_INCREMENT=155 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_meta`
--

INSERT INTO `wp_wpsc_meta` (`meta_id`, `object_type`, `object_id`, `meta_key`, `meta_value`) VALUES (1,'wpsc_category',8,'nicename','product-category'),(2,'wpsc_category',8,'description','This is a description'),(3,'wpsc_category',8,'image',''),(4,'wpsc_category',8,'fee','0'),(5,'wpsc_category',8,'active','1'),(6,'wpsc_category',8,'order','0'),(7,'wpsc_category',9,'fee','0'),(8,'wpsc_category',9,'active','1'),(9,'wpsc_category',9,'order','0'),(10,'wpsc_category',9,'uses_billing_address','0'),(11,'wpsc_category',9,'target_market',''),(12,'wpsc_cart_item',1,'sku',''),(13,'wpsc_category',5,'fee','0'),(14,'wpsc_category',5,'active','1'),(15,'wpsc_category',5,'order','0'),(16,'wpsc_category',5,'display_type','default'),(17,'wpsc_category',5,'image_height','0'),(18,'wpsc_category',5,'image_width','0'),(19,'wpsc_category',5,'uses_billing_address','0'),(20,'wpsc_category',5,'target_market','a:1:{i:136;s:3:\"137\";}'),(21,'wpsc_category',4,'fee','0'),(22,'wpsc_category',4,'active','1'),(23,'wpsc_category',4,'order','0'),(24,'wpsc_category',4,'display_type','default'),(25,'wpsc_category',4,'image_height','0'),(26,'wpsc_category',4,'image_width','0'),(27,'wpsc_category',4,'uses_billing_address','0'),(28,'wpsc_category',4,'target_market','a:1:{i:136;s:3:\"137\";}'),(29,'wpsc_category',6,'fee','0'),(30,'wpsc_category',6,'active','1'),(31,'wpsc_category',6,'order','0'),(32,'wpsc_category',6,'display_type','default'),(33,'wpsc_category',6,'image_height','0'),(34,'wpsc_category',6,'image_width','0'),(35,'wpsc_category',6,'uses_billing_address','0'),(36,'wpsc_category',6,'target_market','a:1:{i:136;s:3:\"137\";}'),(37,'wpsc_category',24,'fee','0'),(38,'wpsc_category',24,'active','1'),(39,'wpsc_category',24,'order','0'),(40,'wpsc_category',24,'display_type','default'),(41,'wpsc_category',24,'image_height','0'),(42,'wpsc_category',24,'image_width','0'),(43,'wpsc_category',24,'uses_billing_address','0'),(44,'wpsc_category',24,'target_market','a:1:{i:136;s:3:\"137\";}'),(45,'wpsc_cart_item',2,'sku',''),(46,'wpsc_cart_item',3,'sku',''),(47,'wpsc_cart_item',4,'sku',''),(48,'wpsc_cart_item',5,'sku',''),(49,'wpsc_category',5,'image','partridge_eye_pillow.jpg'),(50,'wpsc_category',25,'fee','0'),(51,'wpsc_category',25,'active','1'),(52,'wpsc_category',25,'order','0'),(53,'wpsc_category',25,'display_type','default'),(54,'wpsc_category',25,'image_height','0'),(55,'wpsc_category',25,'image_width','0'),(56,'wpsc_category',25,'uses_billing_address','0'),(57,'wpsc_category',25,'target_market','a:1:{i:136;s:3:\"137\";}'),(58,'wpsc_category',9,'display_type','default'),(59,'wpsc_category',9,'image_height','0'),(60,'wpsc_category',9,'image_width','0'),(61,'wpsc_category',26,'fee','0'),(62,'wpsc_category',26,'active','1'),(63,'wpsc_category',26,'order','0'),(64,'wpsc_category',26,'display_type','default'),(65,'wpsc_category',26,'image_height','0'),(66,'wpsc_category',26,'image_width','0'),(67,'wpsc_category',26,'uses_billing_address','0'),(68,'wpsc_category',26,'target_market','a:1:{i:136;s:3:\"137\";}'),(69,'wpsc_cart_item',6,'sku',''),(70,'wpsc_cart_item',7,'sku',''),(71,'wpsc_cart_item',8,'sku',''),(72,'wpsc_cart_item',9,'sku',''),(73,'wpsc_cart_item',10,'sku',''),(74,'wpsc_cart_item',11,'sku',''),(75,'wpsc_cart_item',12,'sku',''),(76,'wpsc_cart_item',13,'sku',''),(77,'wpsc_cart_item',14,'sku',''),(78,'wpsc_cart_item',15,'sku',''),(79,'wpsc_cart_item',16,'sku',''),(80,'wpsc_cart_item',17,'sku',''),(81,'wpsc_cart_item',18,'sku',''),(82,'wpsc_cart_item',19,'sku',''),(83,'wpsc_cart_item',20,'sku',''),(84,'wpsc_cart_item',21,'sku',''),(85,'wpsc_cart_item',22,'sku',''),(86,'wpsc_cart_item',23,'sku',''),(87,'wpsc_cart_item',24,'sku',''),(88,'wpsc_cart_item',25,'sku',''),(89,'wpsc_cart_item',26,'sku',''),(90,'wpsc_cart_item',27,'sku',''),(91,'wpsc_cart_item',28,'sku',''),(92,'wpsc_cart_item',29,'sku',''),(93,'wpsc_cart_item',30,'sku',''),(94,'wpsc_cart_item',31,'sku',''),(95,'wpsc_cart_item',32,'sku',''),(96,'wpsc_cart_item',33,'sku',''),(97,'wpsc_cart_item',34,'sku',''),(98,'wpsc_cart_item',35,'sku',''),(99,'wpsc_cart_item',36,'sku',''),(100,'wpsc_category',27,'fee','0'),(101,'wpsc_category',27,'active','1'),(102,'wpsc_category',27,'order','0'),(103,'wpsc_category',27,'display_type','default'),(104,'wpsc_category',27,'image_height','0'),(105,'wpsc_category',27,'image_width','0'),(106,'wpsc_category',27,'uses_billing_address','0'),(107,'wpsc_category',27,'target_market','a:1:{i:136;s:3:\"137\";}'),(108,'wpsc_category',28,'fee','0'),(109,'wpsc_category',28,'active','1'),(110,'wpsc_category',28,'order','0'),(111,'wpsc_category',28,'display_type','default'),(112,'wpsc_category',28,'image_height','0'),(113,'wpsc_category',28,'image_width','0'),(114,'wpsc_category',28,'uses_billing_address','0'),(115,'wpsc_category',28,'target_market',''),(116,'wpsc_cart_item',37,'sku',''),(117,'wpsc_cart_item',38,'sku',''),(118,'wpsc_cart_item',39,'sku',''),(119,'wpsc_category',29,'fee','0'),(120,'wpsc_category',29,'active','1'),(121,'wpsc_category',29,'order','0'),(122,'wpsc_category',29,'display_type','default'),(123,'wpsc_category',29,'image_height','0'),(124,'wpsc_category',29,'image_width','0'),(125,'wpsc_category',29,'uses_billing_address','0'),(126,'wpsc_category',29,'target_market',''),(127,'wpsc_category',30,'fee','0'),(128,'wpsc_category',30,'active','1'),(129,'wpsc_category',30,'order','0'),(130,'wpsc_category',30,'display_type','default'),(131,'wpsc_category',30,'image_height','0'),(132,'wpsc_category',30,'image_width','0'),(133,'wpsc_category',30,'uses_billing_address','0'),(134,'wpsc_category',30,'target_market',''),(135,'wpsc_cart_item',40,'sku',''),(136,'wpsc_cart_item',41,'sku',''),(137,'wpsc_cart_item',42,'sku',''),(138,'wpsc_cart_item',43,'sku',''),(139,'wpsc_cart_item',44,'sku',''),(140,'wpsc_cart_item',45,'sku',''),(141,'wpsc_category',37,'fee','0'),(142,'wpsc_category',37,'active','1'),(143,'wpsc_category',37,'order','0'),(144,'wpsc_category',37,'display_type','default'),(145,'wpsc_category',37,'image_height','0'),(146,'wpsc_category',37,'image_width','0'),(147,'wpsc_category',37,'uses_billing_address','0'),(148,'wpsc_category',37,'target_market',''),(149,'wpsc_cart_item',46,'sku',''),(150,'wpsc_cart_item',47,'sku',''),(151,'WPSC_Country',136,'region_label','State'),(152,'WPSC_Country',100,'region_label','Province'),(153,'WPSC_Country',154,'_is_country_legacy','1'),(154,'WPSC_Country',223,'region_label','County');

--
-- Table structure for table `wp_wpsc_product_rating`
--

CREATE TABLE `wp_wpsc_product_rating` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ipnum` varchar(30) NOT NULL DEFAULT '',
  `productid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `rated` tinyint(1) NOT NULL DEFAULT '0',
  `time` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_product_rating`
--


--
-- Table structure for table `wp_wpsc_purchase_logs`
--

CREATE TABLE `wp_wpsc_purchase_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `totalprice` decimal(11,2) NOT NULL DEFAULT '0.00',
  `statusno` smallint(6) NOT NULL DEFAULT '0',
  `sessionid` varchar(255) NOT NULL DEFAULT '',
  `transactid` varchar(255) NOT NULL DEFAULT '',
  `authcode` varchar(255) NOT NULL DEFAULT '',
  `processed` bigint(20) unsigned NOT NULL DEFAULT '1',
  `user_ID` bigint(20) unsigned DEFAULT '0',
  `date` varchar(255) NOT NULL DEFAULT '',
  `gateway` varchar(64) NOT NULL DEFAULT '',
  `billing_country` char(6) NOT NULL DEFAULT '',
  `shipping_country` char(6) NOT NULL DEFAULT '',
  `base_shipping` decimal(11,2) NOT NULL DEFAULT '0.00',
  `email_sent` char(1) NOT NULL DEFAULT '0',
  `stock_adjusted` char(1) NOT NULL DEFAULT '0',
  `discount_value` decimal(11,2) NOT NULL DEFAULT '0.00',
  `discount_data` text,
  `track_id` varchar(50) DEFAULT '',
  `billing_region` char(6) NOT NULL DEFAULT '',
  `shipping_region` char(6) NOT NULL DEFAULT '',
  `find_us` varchar(255) NOT NULL DEFAULT '',
  `engravetext` varchar(255) DEFAULT '',
  `shipping_method` varchar(64) DEFAULT NULL,
  `shipping_option` varchar(128) DEFAULT NULL,
  `affiliate_id` varchar(32) DEFAULT NULL,
  `plugin_version` varchar(32) DEFAULT NULL,
  `notes` text,
  `wpec_taxes_total` decimal(11,2) DEFAULT NULL,
  `wpec_taxes_rate` decimal(11,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sessionid` (`sessionid`),
  KEY `gateway` (`gateway`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_purchase_logs`
--

INSERT INTO `wp_wpsc_purchase_logs` (`id`, `totalprice`, `statusno`, `sessionid`, `transactid`, `authcode`, `processed`, `user_ID`, `date`, `gateway`, `billing_country`, `shipping_country`, `base_shipping`, `email_sent`, `stock_adjusted`, `discount_value`, `discount_data`, `track_id`, `billing_region`, `shipping_region`, `find_us`, `engravetext`, `shipping_method`, `shipping_option`, `affiliate_id`, `plugin_version`, `notes`, `wpec_taxes_total`, `wpec_taxes_rate`) VALUES (1,15.00,0,'7151353203042','','',2,1,'1353203042','wpsc_merchant_testmode','AU','AU',0.00,'0','0',0.00,'','','','','','0.000000','','','','3.8.9.2','',0.00,0.00),(2,20.00,0,'9281353896482','','',1,1,'1353896482','wpsc_merchant_paypal_express','AU','AU',5.00,'0','0',0.00,'','','jkh','','','','weightrate','Weight Rate',NULL,'3.8.9.2',NULL,0.00,0.00),(3,25.00,0,'2661353896667','','',1,1,'1353896667','wpsc_merchant_paypal_express','AU','AU',10.00,'0','0',0.00,'','','jkh','','','','weightrate','Weight Rate',NULL,'3.8.9.2',NULL,0.00,0.00),(4,0.60,0,'7811353897342','','',3,1,'1353897342','wpsc_merchant_paypal_express','AU','AU',0.10,'0','0',0.00,'','','WA','','','0.000000','weightrate','Weight Rate','','3.8.9.2','',0.00,0.00),(5,0.60,0,'1011353899896','','',1,1,'1353899896','wpsc_merchant_paypal_express','AU','AU',0.10,'0','0',0.00,'','','WA','','','','weightrate','Weight Rate',NULL,'3.8.9.2',NULL,0.00,0.00),(6,15.00,0,'9761354717223','','',3,1,'1354717223','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','WA','','','0.000000','weightrate','Weight Rate','','3.8.9.2','',0.00,0.00),(7,58.00,0,'7331354750861','','',1,0,'1354750861','wpsc_merchant_paypal_express','AU','AU',8.50,'0','0',0.00,'','','VIC','','','','weightrate','Weight Rate',NULL,'3.8.9.2',NULL,0.00,0.00),(8,58.00,0,'9681354750863','','',1,0,'1354750863','wpsc_merchant_paypal_express','AU','AU',8.50,'0','0',0.00,'','','VIC','','','','weightrate','Weight Rate',NULL,'3.8.9.2',NULL,0.00,0.00),(9,113.00,0,'1111354751284','','',3,0,'1354751284','wpsc_merchant_paypal_express','AU','AU',13.00,'1','0',0.00,'','','VIC','','','0.000000','weightrate','Weight Rate','','3.8.9.2','',0.00,0.00),(10,31.50,0,'6241354753912','','',3,0,'1354753912','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','WA','','','0.000000','weightrate','Weight Rate','','3.8.9.2','',0.00,0.00),(11,50.50,0,'8251355138108','','',3,0,'1355138108','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','WA','','','0.000000','weightrate','Weight Rate','','3.8.9.2','',0.00,0.00),(12,34.50,0,'9391355532931','','',3,0,'1355532931','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','WA','','','0.000000','weightrate','Weight Rate','','3.8.9.2','',0.00,0.00),(13,58.00,0,'9961356748602','','',3,0,'1356748602','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','ACT','','','0.000000','weightrate','Weight Rate','','3.8.9.2','',0.00,0.00),(14,30.00,0,'6911359010338','','',3,0,'1359010338','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','w.a.','','','0.000000','weightrate','Weight Rate','','3.8.9.2','',0.00,0.00),(15,21.50,0,'4751371441576','','',3,0,'1371441576','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','NSW','NSW','','0.000000','weightrate','Weight Rate','','3.8.11.1','',0.00,0.00),(16,21.50,0,'6091375266748','','',3,0,'1375266748','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','Qld','Qld','','0.000000','weightrate','Weight Rate','','3.8.11.1','',0.00,0.00),(17,21.50,0,'9791375409974','','',1,1,'1375409974','wpsc_merchant_paypal_express','AU','AU',8.50,'0','0',0.00,'','','WA','WA','','','weightrate','Weight Rate',NULL,'3.8.11.1',NULL,0.00,0.00),(18,40.40,0,'8371388640428','','',3,0,'1388640428','wpsc_merchant_paypal_express','AU','AU',8.50,'1','0',0.00,'','','WA','WA','','0.000000','weightrate','Weight Rate','','3.8.11.1','',0.00,0.00),(19,78.00,0,'9381394510924','','',3,0,'1394510924','wpsc_merchant_paypal_express','AU','AU',13.00,'1','0',0.00,'','','Vic','Vic','','0.000000','weightrate','Weight Rate','','3.8.11.1','',0.00,0.00),(20,89.72,0,'9571398910539','','',3,0,'1398910539','wpsc_merchant_paypal_express','AU','AU',13.00,'1','0',19.18,'ilovemymum','','VIC','VIC','','0.000000','weightrate','Weight Rate','','3.8.11.1','',0.00,0.00),(21,23.95,0,'3371401327557','','',3,0,'1401327557','wpsc_merchant_paypal_express','AU','AU',2.00,'1','0',0.00,'','','WA','WA','','0.000000','weightrate','Weight Rate','','3.8.11.1','',0.00,0.00),(22,0.00,0,'6851408755893','','',1,0,'1408755893','wpsc_merchant_paypal_express','AU','AU',0.00,'0','0',0.00,'','','wa','wa','','','','',NULL,'3.8.11.1',NULL,0.00,0.00),(23,0.00,0,'8351408756654','','',1,0,'1408756654','wpsc_merchant_paypal_express','AU','AU',0.00,'0','0',0.00,'','','','','','','','',NULL,'3.8.14.1',NULL,0.00,0.00),(24,0.00,0,'4351408756781','','',1,0,'1408756781','wpsc_merchant_paypal_express','','',0.00,'0','0',0.00,'','','','','','','','',NULL,'3.8.14.1',NULL,0.00,0.00),(25,0.00,0,'3081408756892','','',1,0,'1408756892','wpsc_merchant_paypal_express','AU','AU',0.00,'0','0',0.00,'','','','','','','','',NULL,'3.8.14.1',NULL,0.00,0.00),(26,0.00,0,'4071408757081','','',1,0,'1408757081','wpsc_merchant_paypal_express','AU','AU',0.00,'0','0',0.00,'','','','','','','','',NULL,'3.8.14.1',NULL,0.00,0.00),(27,0.00,0,'1611408757128','','',1,0,'1408757128','wpsc_merchant_paypal_express','','',0.00,'0','0',0.00,'','','','','','','','',NULL,'3.8.14.1',NULL,0.00,0.00),(28,0.00,0,'6661408757393','','',1,0,'1408757393','wpsc_merchant_paypal_express','AU','AU',0.00,'0','0',0.00,'','','','','','','','',NULL,'3.8.14.1',NULL,0.00,0.00),(29,0.00,0,'6471408758066','','',1,0,'1408758066','wpsc_merchant_paypal_express','AU','AU',0.00,'0','0',0.00,'','','','','','','','',NULL,'3.8.14.1',NULL,0.00,0.00),(30,0.00,0,'2361408758922','','',1,0,'1408758922','wpsc_merchant_paypal_express','AU','AU',0.00,'0','0',0.00,'','','','','','','','',NULL,'3.8.14.1',NULL,0.00,0.00),(31,0.00,0,'3371408763801','','',1,0,'1408763801','wpsc_merchant_paypal_express','AU','AU',0.00,'0','0',0.00,'','','WA','WA','','','','',NULL,'3.8.11.1',NULL,0.00,0.00);

--
-- Table structure for table `wp_wpsc_purchase_meta`
--

CREATE TABLE `wp_wpsc_purchase_meta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `wpsc_purchase_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  `meta_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`meta_id`),
  KEY `wpsc_purchase_id` (`wpsc_purchase_id`),
  KEY `meta_key` (`meta_key`(191)),
  KEY `meta_value` (`meta_value`(20)),
  KEY `meta_key_and_value` (`meta_key`(191),`meta_value`(32)),
  KEY `meta_timestamp_index` (`meta_timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_purchase_meta`
--

INSERT INTO `wp_wpsc_purchase_meta` (`meta_id`, `wpsc_purchase_id`, `meta_key`, `meta_value`, `meta_timestamp`) VALUES (1,23,'visitor_id','1','2014-08-23 01:17:34'),(2,24,'visitor_id','7','2014-08-23 01:19:41'),(3,25,'visitor_id','1','2014-08-23 01:21:32'),(4,26,'visitor_id','1','2014-08-23 01:24:41'),(5,27,'visitor_id','11','2014-08-23 01:25:28'),(6,28,'visitor_id','11','2014-08-23 01:29:53'),(7,29,'visitor_id','7','2014-08-23 01:41:06'),(8,30,'visitor_id','1','2014-08-23 01:55:22');

--
-- Table structure for table `wp_wpsc_region_tax`
--

CREATE TABLE `wp_wpsc_region_tax` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(64) NOT NULL DEFAULT '',
  `code` char(2) NOT NULL DEFAULT '',
  `tax` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `country_id` (`country_id`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_region_tax`
--

INSERT INTO `wp_wpsc_region_tax` (`id`, `country_id`, `name`, `code`, `tax`) VALUES (1,100,'Alberta','AB',0),(2,100,'British Columbia','BC',0),(3,100,'Manitoba','MB',0),(4,100,'New Brunswick','NB',0),(5,100,'Newfoundland and Labrador','NL',0),(6,100,'Northwest Territories','NT',0),(7,100,'Nova Scotia','NS',0),(8,100,'Nunavut','NU',0),(9,100,'Ontario','ON',0),(10,100,'Prince Edward Island','PE',0),(11,100,'Quebec','QC',0),(12,100,'Saskatchewan','SK',0),(13,100,'Yukon','YK',0),(14,136,'Alabama','AL',0),(15,136,'Alaska','AK',0),(16,136,'Arizona','AZ',0),(17,136,'Arkansas','AR',0),(18,136,'California','CA',0),(19,136,'Colorado','CO',0),(20,136,'Connecticut','CT',0),(21,136,'Delaware','DE',0),(22,136,'Florida','FL',0),(23,136,'Georgia','GA',0),(24,136,'Hawaii','HI',0),(25,136,'Idaho','ID',0),(26,136,'Illinois','IL',0),(27,136,'Indiana','IN',0),(28,136,'Iowa','IA',0),(29,136,'Kansas','KS',0),(30,136,'Kentucky','KY',0),(31,136,'Louisiana','LA',0),(32,136,'Maine','ME',0),(33,136,'Maryland','MD',0),(34,136,'Massachusetts','MA',0),(35,136,'Michigan','MI',0),(36,136,'Minnesota','MN',0),(37,136,'Mississippi','MS',0),(38,136,'Missouri','MO',0),(39,136,'Montana','MT',0),(40,136,'Nebraska','NE',0),(41,136,'Nevada','NV',0),(42,136,'New Hampshire','NH',0),(43,136,'New Jersey','NJ',0),(44,136,'New Mexico','NM',0),(45,136,'New York','NY',0),(46,136,'North Carolina','NC',0),(47,136,'North Dakota','ND',0),(48,136,'Ohio','OH',0),(49,136,'Oklahoma','OK',0),(50,136,'Oregon','OR',0),(51,136,'Pennsylvania','PA',0),(52,136,'Rhode Island','RI',0),(53,136,'South Carolina','SC',0),(54,136,'South Dakota','SD',0),(55,136,'Tennessee','TN',0),(56,136,'Texas','TX',0),(57,136,'Utah','UT',0),(58,136,'Vermont','VT',0),(59,136,'Virginia','VA',0),(60,136,'Washington','WA',0),(61,136,'Washington DC','DC',0),(62,136,'West Virginia','WV',0),(63,136,'Wisconsin','WI',0),(64,136,'Wyoming','WY',0);

--
-- Table structure for table `wp_wpsc_submited_form_data`
--

CREATE TABLE `wp_wpsc_submited_form_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `log_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `form_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `value` longtext,
  PRIMARY KEY (`id`),
  KEY `log_id` (`log_id`,`form_id`)
) ENGINE=MyISAM AUTO_INCREMENT=497 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_submited_form_data`
--

INSERT INTO `wp_wpsc_submited_form_data` (`id`, `log_id`, `form_id`, `value`) VALUES (1,1,2,'Cam'),(2,1,3,'Merton'),(3,1,4,'22 Burnside Way'),(4,1,5,'Waikiki'),(5,1,7,'AU'),(6,1,8,'6169'),(7,1,18,'0895284315'),(8,1,9,'cam@hiddenshoal.com'),(9,1,11,''),(10,1,12,''),(11,1,13,''),(12,1,14,''),(13,1,16,'AU'),(14,1,17,''),(15,1,15,''),(16,1,6,'WA'),(17,2,2,'Cam'),(18,2,3,'Merton'),(19,2,4,'22 Burnside Way'),(20,2,5,'Waikiki'),(21,2,7,'AU'),(22,2,8,'6169'),(23,2,18,'0895284315'),(24,2,9,'cam@hiddenshoal.com'),(25,2,11,'Cam Merton'),(26,2,12,''),(27,2,13,'kjhk'),(28,2,14,'jkh'),(29,2,16,'AU'),(30,2,17,'jkh'),(31,2,15,'jkh'),(32,2,6,'WA'),(33,3,2,'Cam'),(34,3,3,'Merton'),(35,3,4,'22 Burnside Way'),(36,3,5,'Waikiki'),(37,3,7,'AU'),(38,3,8,'6169'),(39,3,18,'0895284315'),(40,3,9,'cam@hiddenshoal.com'),(41,3,11,'Cam Merton'),(42,3,12,''),(43,3,13,'kjhk'),(44,3,14,'jkh'),(45,3,16,'AU'),(46,3,17,'jkh'),(47,3,15,'jkh'),(48,3,6,'WA'),(49,4,2,'Cam'),(50,4,3,'Merton'),(51,4,4,'22 Burnside Way'),(52,4,5,'Waikiki'),(53,4,7,'AU'),(54,4,8,'6169'),(55,4,18,'0895284315'),(56,4,9,'cam@hiddenshoal.com'),(57,4,11,'Cam'),(58,4,12,'Merton'),(59,4,13,'22 Burnside Way'),(60,4,14,'Waikiki'),(61,4,16,'AU'),(62,4,17,'6169'),(63,4,15,'WA'),(64,4,6,'WA'),(65,5,2,'Cam'),(66,5,3,'Merton'),(67,5,4,'22 Burnside Way'),(68,5,5,'Waikiki'),(69,5,7,'AU'),(70,5,8,'6169'),(71,5,18,'0895284315'),(72,5,9,'cam@hiddenshoal.com'),(73,5,11,'Cam'),(74,5,12,'Merton'),(75,5,13,'22 Burnside Way'),(76,5,14,'Waikiki'),(77,5,16,'AU'),(78,5,17,'6169'),(79,5,15,'WA'),(80,5,6,'WA'),(81,6,2,'Cam'),(82,6,3,'Merton'),(83,6,4,'22 Burnside Way'),(84,6,5,'Waikiki'),(85,6,7,'AU'),(86,6,8,'6169'),(87,6,18,'0895284315'),(88,6,9,'cam@hiddenshoal.com'),(89,6,11,'Cam'),(90,6,12,'Merton'),(91,6,13,'22 Burnside Way'),(92,6,14,'Waikiki'),(93,6,16,'AU'),(94,6,17,'6169'),(95,6,15,'WA'),(96,6,6,'WA'),(97,7,2,'Kristina'),(98,7,3,'Ditchfield'),(99,7,4,'40 West End Road'),(100,7,5,'Warrandyte'),(101,7,7,'AU'),(102,7,8,'3113'),(103,7,18,'0400425623'),(104,7,9,'kristinad@lighthousedc.com.au'),(105,7,11,'Kristina'),(106,7,12,'Ditchfield'),(107,7,13,'40 West End Road'),(108,7,14,'Warrandyte'),(109,7,16,'AU'),(110,7,17,'3113'),(111,7,15,'VIC'),(112,7,6,'VIC'),(113,8,2,'Kristina'),(114,8,3,'Ditchfield'),(115,8,4,'40 West End Road'),(116,8,5,'Warrandyte'),(117,8,7,'AU'),(118,8,8,'3113'),(119,8,18,'0400425623'),(120,8,9,'kristinad@lighthousedc.com.au'),(121,8,11,'Kristina'),(122,8,12,'Ditchfield'),(123,8,13,'40 West End Road'),(124,8,14,'Warrandyte'),(125,8,16,'AU'),(126,8,17,'3113'),(127,8,15,'VIC'),(128,8,6,'VIC'),(129,9,2,'Kristina'),(130,9,3,'Ditchfield'),(131,9,4,'40 West End Road'),(132,9,5,'Warrandyte'),(133,9,7,'AU'),(134,9,8,'3113'),(135,9,18,'0400425623'),(136,9,9,'kristinad@lighthousedc.com.au'),(137,9,11,'Kristina'),(138,9,12,'Ditchfield'),(139,9,13,'40 West End Road'),(140,9,14,'Warrandyte'),(141,9,16,'AU'),(142,9,17,'3113'),(143,9,15,'VIC'),(144,9,6,'VIC'),(145,10,2,'TAMMY'),(146,10,3,'GREAVES'),(147,10,4,'34 BINSTEAD COURT'),(148,10,5,'KOONDOOLA'),(149,10,7,'AU'),(150,10,8,'6064'),(151,10,18,'0403787501'),(152,10,9,'tammy.greaves@housing.wa.gov.au'),(153,10,11,'TAMMY'),(154,10,12,'GREAVES'),(155,10,13,'34 BINSTEAD COURT'),(156,10,14,'KOONDOOLA'),(157,10,16,'AU'),(158,10,17,'6064'),(159,10,15,'WA'),(160,10,6,'WA'),(161,11,2,'Lorraine'),(162,11,3,'McLellan'),(163,11,4,'20 Blue Mountain Link,Merriwa'),(164,11,5,'Perth'),(165,11,7,'AU'),(166,11,8,'6030'),(167,11,18,'0893057488'),(168,11,9,'maclorr@aapt.net.au'),(169,11,11,'Lorraine'),(170,11,12,'McLellan'),(171,11,13,'20 Blue Mountain Link,Merriwa'),(172,11,14,'Perth'),(173,11,16,'AU'),(174,11,17,'6030'),(175,11,15,'WA'),(176,11,6,'WA'),(177,12,2,'MARINA'),(178,12,3,'STRICKLAND'),(179,12,4,'79 VERNA ST'),(180,12,5,'GOSNELLS'),(181,12,7,'AU'),(182,12,8,'6110'),(183,12,18,'0412025482'),(184,12,9,'strickland.marina@gmail.com'),(185,12,11,'MARINA'),(186,12,12,'STRICKLAND'),(187,12,13,'79 VERNA ST'),(188,12,14,'GOSNELLS'),(189,12,16,'AU'),(190,12,17,'6110'),(191,12,15,'WA'),(192,12,6,'WA'),(193,13,2,'Kathy'),(194,13,3,'Hutchinson'),(195,13,4,'20 Colleano Street'),(196,13,5,'Ngunnawal'),(197,13,7,'AU'),(198,13,8,'2913'),(199,13,18,'0404492663'),(200,13,9,'annie.hutchinson@cch.com.au'),(201,13,11,'Kathy'),(202,13,12,'Hutchinson'),(203,13,13,'20 Colleano Street'),(204,13,14,'Ngunnawal'),(205,13,16,'AU'),(206,13,17,'2913'),(207,13,15,'ACT'),(208,13,6,'ACT'),(209,14,2,'kerry'),(210,14,3,'kuper'),(211,14,4,'2/18 crimea st morley'),(212,14,5,'perth'),(213,14,7,'AU'),(214,14,8,'6062'),(215,14,18,'92751924'),(216,14,9,'kuper50@iprimus.com.au'),(217,14,11,'kerry'),(218,14,12,'kuper'),(219,14,13,'2/18 crimea st morley'),(220,14,14,'perth'),(221,14,16,'AU'),(222,14,17,'6062'),(223,14,15,'w.a.'),(224,14,6,'w.a.'),(225,15,2,'Monique '),(226,15,3,'Thomas'),(227,15,4,'14 Alexander Avenue'),(228,15,5,'North Willoughby'),(229,15,7,'AU'),(230,15,8,'2068'),(231,15,18,'0447000653'),(232,15,9,'Thomas.cm@bigpond.com'),(233,15,11,'Monique '),(234,15,12,'Thomas'),(235,15,13,'14 Alexander Avenue'),(236,15,14,'North Willoughby'),(237,15,16,'AU'),(238,15,17,'2068'),(239,15,15,'NSW'),(240,15,6,'NSW'),(241,16,2,'Mark'),(242,16,3,'Rattray'),(243,16,4,'25 Sherriff St'),(244,16,5,'Hermit Park'),(245,16,7,'AU'),(246,16,8,'4812'),(247,16,18,'0418340446'),(248,16,9,'Markrattray80@hotmail.com'),(249,16,11,'Mark'),(250,16,12,'Rattray'),(251,16,13,'25 Sherriff St'),(252,16,14,'Hermit Park'),(253,16,16,'AU'),(254,16,17,'4812'),(255,16,15,'Qld'),(256,16,6,'Qld'),(257,17,2,'Cam'),(258,17,3,'Merton'),(259,17,4,'22 Burnside Way'),(260,17,5,'Waikiki'),(261,17,7,'AU'),(262,17,8,'6169'),(263,17,18,'0895284315'),(264,17,9,'cam@hiddenshoal.com'),(265,17,11,'Cam'),(266,17,12,'Merton'),(267,17,13,'22 Burnside Way'),(268,17,14,'Waikiki'),(269,17,16,'AU'),(270,17,17,'6169'),(271,17,15,'WA'),(272,17,6,'WA'),(273,18,2,'Meagan'),(274,18,3,'Smith'),(275,18,4,'40 Ashburton Drive'),(276,18,5,'Gosnells'),(277,18,7,'AU'),(278,18,8,'6110'),(279,18,18,'0408097377'),(280,18,9,'meagan_101@hotmail.com'),(281,18,11,'Meagan'),(282,18,12,'Smith'),(283,18,13,'40 Ashburton Drive'),(284,18,14,'Gosnells'),(285,18,16,'AU'),(286,18,17,'6110'),(287,18,15,'WA'),(288,18,6,'WA'),(289,19,2,'Kirsty'),(290,19,3,'Campbell'),(291,19,4,'58 moorabool st'),(292,19,5,'Geelong'),(293,19,7,'AU'),(294,19,8,'3220'),(295,19,18,'0408418978'),(296,19,9,'awckmc1@bigpond.com'),(297,19,11,'Kirsty'),(298,19,12,'Campbell'),(299,19,13,'58 moorabool st'),(300,19,14,'Geelong'),(301,19,16,'AU'),(302,19,17,'3220'),(303,19,15,'Vic'),(304,19,6,'Vic'),(305,20,2,'Kristina'),(306,20,3,'Ditchfield'),(307,20,4,'40 West End Road'),(308,20,5,'Warrandyte'),(309,20,7,'AU'),(310,20,8,'3113'),(311,20,18,'0400425623'),(312,20,9,'kristinad@lighthousedc.com.au'),(313,20,11,'Kristina'),(314,20,12,'Ditchfield'),(315,20,13,'40 West End Road'),(316,20,14,'Warrandyte'),(317,20,16,'AU'),(318,20,17,'3113'),(319,20,15,'VIC'),(320,20,6,'VIC'),(321,21,2,'Monique'),(322,21,3,'Thomas'),(323,21,4,'34 Glenelg St'),(324,21,5,'Applecross'),(325,21,7,'AU'),(326,21,8,'6153'),(327,21,18,'0893163693'),(328,21,9,'joiakai@icloud.com'),(329,21,11,'Monique'),(330,21,12,'Thomas'),(331,21,13,'34 Glenelg St'),(332,21,14,'Applecross'),(333,21,16,'AU'),(334,21,17,'6153'),(335,21,15,'WA'),(336,21,6,'WA'),(337,22,2,'V'),(338,22,3,'V'),(339,22,4,'V'),(340,22,5,'V'),(341,22,7,'AU'),(342,22,8,'6000'),(343,22,18,'38947839'),(344,22,9,'CAM@HIDDENSHOAL.COM'),(345,22,11,'V'),(346,22,12,'V'),(347,22,13,'V'),(348,22,14,'V'),(349,22,16,'AU'),(350,22,17,'6000'),(351,22,15,'wa'),(352,22,6,'wa'),(353,23,2,'Cam'),(354,23,3,'Merton'),(355,23,4,'22 Burnside Way'),(356,23,5,'Waikiki'),(357,23,6,'WA'),(358,23,7,'AU'),(359,23,8,'6169'),(360,23,18,'61895284315'),(361,23,9,'cam@hiddenshoal.com'),(362,23,11,''),(363,23,12,''),(364,23,13,''),(365,23,14,''),(366,23,15,'WA'),(367,23,16,'AU'),(368,23,17,''),(369,24,2,'Cam'),(370,24,3,'Merton'),(371,24,4,'22 Burnside Way'),(372,24,5,'Waikiki'),(373,24,6,''),(374,24,7,'AU'),(375,24,8,'6169'),(376,24,18,'61895284315'),(377,24,9,'cam@hiddenshoal.com'),(378,24,11,''),(379,24,12,''),(380,24,13,''),(381,24,14,''),(382,24,15,''),(383,24,16,'AU'),(384,24,17,''),(385,25,2,'Cam'),(386,25,3,'Merton'),(387,25,4,'22 Burnside Way'),(388,25,5,'Waikiki'),(389,25,6,'WA'),(390,25,7,'AU'),(391,25,8,'6169'),(392,25,18,'61895284315'),(393,25,9,'cam@hiddenshoal.com'),(394,25,11,''),(395,25,12,''),(396,25,13,''),(397,25,14,''),(398,25,15,'wa'),(399,25,16,'AU'),(400,25,17,''),(401,26,2,'Cam'),(402,26,3,'Merton'),(403,26,4,'22 Burnside Way'),(404,26,5,'Waikiki'),(405,26,6,'WA'),(406,26,7,'AU'),(407,26,8,'6169'),(408,26,18,'61895284315'),(409,26,9,'cam@hiddenshoal.com'),(410,26,11,''),(411,26,12,''),(412,26,13,''),(413,26,14,''),(414,26,15,'wa'),(415,26,16,'AU'),(416,26,17,''),(417,27,2,'Cam'),(418,27,3,'Merton'),(419,27,4,'22 Burnside Way'),(420,27,5,'Waikiki'),(421,27,6,''),(422,27,7,'AU'),(423,27,8,'6169'),(424,27,18,'61895284315'),(425,27,9,'cam@hiddenshoal.com'),(426,27,11,''),(427,27,12,''),(428,27,13,''),(429,27,14,''),(430,27,15,''),(431,27,16,'AU'),(432,27,17,''),(433,28,2,'Cam'),(434,28,3,'Merton'),(435,28,4,'22 Burnside Way'),(436,28,5,'Waikiki'),(437,28,6,'WA'),(438,28,7,'AU'),(439,28,8,'6169'),(440,28,18,'61895284315'),(441,28,9,'cam@hiddenshoal.com'),(442,28,11,''),(443,28,12,''),(444,28,13,''),(445,28,14,''),(446,28,15,'wa'),(447,28,16,'AU'),(448,28,17,''),(449,29,2,'Cam'),(450,29,3,'Merton'),(451,29,4,'22 Burnside Way'),(452,29,5,'Waikiki'),(453,29,6,'WA'),(454,29,7,'AU'),(455,29,8,'6169'),(456,29,18,'61895284315'),(457,29,9,'cam@hiddenshoal.com'),(458,29,11,''),(459,29,12,''),(460,29,13,''),(461,29,14,''),(462,29,15,'WA'),(463,29,16,'AU'),(464,29,17,''),(465,30,2,'Cam'),(466,30,3,'Merton'),(467,30,4,'22 Burnside Way'),(468,30,5,'Waikiki'),(469,30,6,'WA'),(470,30,7,'AU'),(471,30,8,'6169'),(472,30,18,'61895284315'),(473,30,9,'cam@hiddenshoal.com'),(474,30,11,''),(475,30,12,''),(476,30,13,''),(477,30,14,''),(478,30,15,''),(479,30,16,'AU'),(480,30,17,''),(481,31,2,'Cam'),(482,31,3,'Merton'),(483,31,4,'22 Burnside Way'),(484,31,5,'Waikiki'),(485,31,7,'AU'),(486,31,8,'6169'),(487,31,18,'61895284315'),(488,31,9,'cam@hiddenshoal.com'),(489,31,11,'Cam'),(490,31,12,'Merton'),(491,31,13,'22 Burnside Way'),(492,31,14,'Waikiki'),(493,31,16,'AU'),(494,31,17,'6169'),(495,31,15,'WA'),(496,31,6,'WA');

--
-- Table structure for table `wp_wpsc_visitor_meta`
--

CREATE TABLE `wp_wpsc_visitor_meta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `wpsc_visitor_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  `meta_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`meta_id`),
  KEY `wpsc_visitor_id` (`wpsc_visitor_id`),
  KEY `meta_key` (`meta_key`(191)),
  KEY `meta_value` (`meta_value`(20)),
  KEY `meta_key_and_value` (`meta_key`(191),`meta_value`(32)),
  KEY `meta_timestamp_index` (`meta_timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_visitor_meta`
--

INSERT INTO `wp_wpsc_visitor_meta` (`meta_id`, `wpsc_visitor_id`, `meta_key`, `meta_value`, `meta_timestamp`) VALUES (1,3,'_wpsc_key','_J7UfhJyrt7CB','2014-08-23 01:10:48'),(2,4,'_wpsc_key','_0urP56cygzbA','2014-08-23 01:10:48'),(3,1,'_wpsc_cart.unique_id','90575623e37baf18539024045a8a9c30ac764cca','2014-08-23 01:10:53'),(4,1,'_wpsc_cart.is_incomplete','1','2014-08-23 01:10:53'),(5,1,'_wpsc_cart.current_cart_item','-1','2014-08-23 01:10:53'),(6,1,'_wpsc_cart.current_shipping_method','-1','2014-08-23 01:10:53'),(7,1,'_wpsc_cart.current_shipping_quote','-1','2014-08-23 01:10:53'),(8,3,'_wpsc_cart.unique_id','f00a5de13056b496be178661888f9f78151e6833','2014-08-23 01:10:54'),(9,3,'_wpsc_cart.is_incomplete','1','2014-08-23 01:10:54'),(10,3,'_wpsc_cart.current_cart_item','-1','2014-08-23 01:10:54'),(11,3,'_wpsc_cart.current_shipping_method','-1','2014-08-23 01:10:54'),(12,3,'_wpsc_cart.current_shipping_quote','-1','2014-08-23 01:10:54'),(13,5,'_wpsc_key','_C3Xw7aasMsSb','2014-08-23 01:11:02'),(14,6,'_wpsc_key','_xHBMd5WBf6Zp','2014-08-23 01:11:02'),(15,5,'_wpsc_cart.unique_id','9807903b87fb7c5720e66d441dc31f7ab91428a8','2014-08-23 01:11:03'),(16,5,'_wpsc_cart.subtotal','42.95','2014-08-23 01:40:44'),(17,5,'_wpsc_cart.total_price','51.45','2014-08-23 01:40:44'),(18,5,'_wpsc_cart.uses_shipping','3','2014-08-23 01:40:44'),(19,5,'_wpsc_cart.is_incomplete','1','2014-08-23 01:11:03'),(20,5,'_wpsc_cart.cart_items','[encoded data, 16216 characters]','2014-08-23 01:40:44'),(21,5,'_wpsc_cart.cart_item','[encoded data, 5060 characters]','2014-08-23 01:16:52'),(22,5,'_wpsc_cart.cart_item_count','3','2014-08-23 01:40:44'),(23,5,'_wpsc_cart.current_cart_item','-1','2014-08-23 01:11:03'),(24,5,'_wpsc_cart.current_shipping_method','-1','2014-08-23 01:11:03'),(25,5,'_wpsc_cart.current_shipping_quote','-1','2014-08-23 01:11:03'),(26,5,'_wpsc_cart.selected_shipping_method','weightrate','2014-08-23 01:11:11'),(27,5,'_wpsc_cart.selected_shipping_option','Weight Rate','2014-08-23 01:11:11'),(28,5,'_wpsc_cart.base_shipping','8.5','2014-08-23 01:19:22'),(29,5,'_wpsc_cart.shipping_quotes','YToxOntzOjExOiJXZWlnaHQgUmF0ZSI7czo0OiI4LjUwIjt9','2014-08-23 01:19:23'),(30,5,'category_shipping_target_market_conflict','1','2014-08-23 01:11:38'),(32,5,'_wpsc_cart.selected_shipping_amount','8.5','2014-08-23 01:19:27'),(33,5,'_wpsc_cart.shipping_methods','YToxOntpOjA7czoxMDoid2VpZ2h0cmF0ZSI7fQ==','2014-08-23 01:11:38'),(34,5,'_wpsc_cart.shipping_method','weightrate','2014-08-23 01:11:38'),(35,5,'_wpsc_cart.shipping_method_count','1','2014-08-23 01:11:38'),(36,5,'_wpsc_cart.shipping_quote','a:2:{s:4:\"name\";s:11:\"Weight Rate\";s:5:\"value\";d:8.5;}','2014-08-23 01:19:27'),(37,5,'_wpsc_cart.shipping_quote_count','1','2014-08-23 01:19:27'),(38,1,'billingfirstname','Cam','2014-08-23 01:17:34'),(39,1,'billinglastname','Merton','2014-08-23 01:17:34'),(40,1,'billingaddress','22 Burnside Way','2014-08-23 01:17:34'),(41,1,'billingcity','Waikiki','2014-08-23 01:17:34'),(43,1,'billingcountry','AU','2014-08-23 01:11:43'),(44,1,'billingregion','','2014-08-23 01:11:43'),(45,1,'billingstate','WA','2014-08-23 01:17:34'),(46,1,'billingpostcode','6169','2014-08-23 01:17:34'),(47,1,'billingphone','61895284315','2014-08-23 01:17:34'),(48,1,'billingemail','cam@hiddenshoal.com','2014-08-23 01:17:34'),(49,1,'shippingfirstname','','2014-08-23 01:17:34'),(50,1,'shippinglastname','','2014-08-23 01:17:34'),(51,1,'shippingaddress','','2014-08-23 01:17:34'),(53,1,'shippingcity','','2014-08-23 01:17:34'),(55,1,'shippingcountry','AU','2014-08-23 01:11:43'),(56,1,'shippingregion','','2014-08-23 01:11:43'),(57,1,'shippingstate','','2014-08-23 01:55:22'),(58,1,'shippingpostcode','','2014-08-23 01:17:34'),(62,1,'selected_gateway','wpsc_merchant_paypal_express','2014-08-23 01:11:43'),(64,1,'category_shipping_target_market_conflict','','2014-08-23 01:11:43'),(66,1,'_wpsc_cart.delivery_country','AU','2014-08-23 01:16:55'),(67,1,'_wpsc_cart.selected_country','AU','2014-08-23 01:16:55'),(68,5,'shippingSameBilling','','2014-08-23 01:16:56'),(69,5,'shippingcountry','AU','2014-08-23 01:17:11'),(71,5,'shippingstate','WA','2014-08-23 01:17:16'),(72,5,'_wpsc_cart.delivery_country','AU','2014-08-23 01:17:16'),(74,5,'billingemail','cam@hiddenshoal.com','2014-08-23 01:17:24'),(75,5,'billingfirstname','Cam','2014-08-23 01:17:25'),(76,5,'billingaddress','22 Burnside Way','2014-08-23 01:17:25'),(77,5,'billingcity','Waikiki','2014-08-23 01:17:25'),(78,5,'billingcountry','AU','2014-08-23 01:17:26'),(79,5,'_wpsc_cart.selected_country','AU','2014-08-23 01:17:26'),(80,5,'billingpostcode','6169','2014-08-23 01:17:26'),(81,5,'billingphone','61895284315','2014-08-23 01:17:26'),(82,5,'billingstate','WA','2014-08-23 01:17:26'),(83,5,'billinglastname','Merton','2014-08-23 01:17:27'),(84,1,'location_attributes_changed','a:4:{s:15:\"shippingaddress\";s:0:\"\";s:12:\"shippingcity\";s:0:\"\";s:13:\"shippingstate\";s:2:\"WA\";s:16:\"shippingpostcode\";s:0:\"\";}','2014-08-23 01:17:34'),(86,1,'gateway_error_messages','a:1:{s:11:\"card_number\";s:0:\"\";}','2014-08-23 01:17:34'),(87,1,'registration_error_messages','a:0:{}','2014-08-23 01:17:34'),(88,1,'checkout_misc_error_messages','','2014-08-23 01:17:34'),(89,1,'checkout_session_id','2361408758922','2014-08-23 01:55:22'),(90,1,'purchase_id','23','2014-08-23 01:17:34'),(91,1,'paypal_express_converted_amount','0.00','2014-08-23 01:17:34'),(92,1,'paypal_express_original_amount','0.00','2014-08-23 01:17:34'),(93,1,'paypal_express_sessionid','2361408758922','2014-08-23 01:55:22'),(94,1,'paypal_express_currency_code_type','AUD','2014-08-23 01:17:34'),(95,1,'paypal_express_payment_type','Sale','2014-08-23 01:17:34'),(96,1,'paypal_express_nvp_req_array','a:20:{s:6:\"METHOD\";s:18:\"SetExpressCheckout\";s:7:\"VERSION\";s:2:\"71\";s:3:\"PWD\";s:16:\"MMB2AJ8DQCFWN7FE\";s:4:\"USER\";s:27:\"belle_api1.yvettemerton.com\";s:9:\"SIGNATURE\";s:56:\"AFcWxV21C7fd0v3bYYYRCpSSRl31AR1F9rBtozfqeo2R-Fli8WL97QJj\";s:30:\"PAYMENTREQUEST_0_PAYMENTACTION\";s:4:\"Sale\";s:9:\"RETURNURL\";s:89:\"http://partridgeandpear.com.au/products-page/transaction-results/?sessionid=2361408758922\";s:7:\"gateway\";s:6:\"paypal\";s:9:\"CANCELURL\";s:54:\"http://partridgeandpear.com.au/products-page/checkout/\";s:29:\"PAYMENTREQUEST_0_CURRENCYCODE\";s:3:\"AUD\";s:27:\"PAYMENTREQUEST_0_SHIPTONAME\";s:1:\" \";s:29:\"PAYMENTREQUEST_0_SHIPTOSTREET\";s:0:\"\";s:27:\"PAYMENTREQUEST_0_SHIPTOCITY\";s:0:\"\";s:34:\"PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE\";s:2:\"AU\";s:26:\"PAYMENTREQUEST_0_SHIPTOZIP\";s:0:\"\";s:24:\"PAYMENTREQUEST_0_ITEMAMT\";s:4:\"0.00\";s:28:\"PAYMENTREQUEST_0_SHIPPINGAMT\";s:4:\"0.00\";s:23:\"PAYMENTREQUEST_0_TAXAMT\";s:4:\"0.00\";s:20:\"PAYMENTREQUEST_0_AMT\";s:4:\"0.00\";s:12:\"BUTTONSOURCE\";s:11:\"PP-ECWizard\";}','2014-08-23 01:55:22'),(97,1,'_wpsc_cart.log_id','30','2014-08-23 01:55:23'),(98,7,'_wpsc_key','_pMYwK36RyuXc','2014-08-23 01:19:09'),(99,8,'_wpsc_key','_F7blWjlfejkJ','2014-08-23 01:19:09'),(100,7,'category_shipping_target_market_conflict','','2014-08-23 01:19:10'),(102,7,'_wpsc_cart.unique_id','15f58ee4e5d05c00797bb42535fa673916581702','2014-08-23 01:19:10'),(103,7,'_wpsc_cart.is_incomplete','1','2014-08-23 01:19:10'),(104,7,'_wpsc_cart.current_cart_item','-1','2014-08-23 01:19:10'),(105,7,'_wpsc_cart.current_shipping_method','-1','2014-08-23 01:19:10'),(106,7,'_wpsc_cart.current_shipping_quote','-1','2014-08-23 01:19:10'),(108,7,'billingfirstname','Cam','2014-08-23 01:19:41'),(109,7,'billinglastname','Merton','2014-08-23 01:19:41'),(110,7,'billingaddress','22 Burnside Way','2014-08-23 01:19:41'),(111,7,'billingcity','Waikiki','2014-08-23 01:19:41'),(113,7,'billingcountry','AU','2014-08-23 01:19:41'),(114,7,'billingregion','','2014-08-23 01:19:41'),(115,7,'billingstate','WA','2014-08-23 01:41:06'),(116,7,'billingpostcode','6169','2014-08-23 01:19:41'),(117,7,'billingphone','61895284315','2014-08-23 01:19:41'),(118,7,'billingemail','cam@hiddenshoal.com','2014-08-23 01:19:41'),(119,7,'shippingfirstname','','2014-08-23 01:19:41'),(120,7,'shippinglastname','','2014-08-23 01:19:41'),(121,7,'shippingaddress','','2014-08-23 01:19:41'),(122,7,'location_attributes_changed','a:6:{s:15:\"shippingaddress\";s:0:\"\";s:12:\"shippingcity\";s:0:\"\";s:13:\"shippingstate\";s:2:\"WA\";s:15:\"shippingcountry\";s:2:\"AU\";s:14:\"shippingregion\";s:0:\"\";s:16:\"shippingpostcode\";s:0:\"\";}','2014-08-23 01:19:41'),(123,7,'shippingcity','','2014-08-23 01:19:41'),(125,7,'shippingcountry','AU','2014-08-23 01:19:41'),(126,7,'shippingregion','','2014-08-23 01:19:41'),(127,7,'shippingstate','WA','2014-08-23 01:41:06'),(128,7,'shippingpostcode','','2014-08-23 01:19:41'),(130,7,'gateway_error_messages','a:1:{s:11:\"card_number\";s:0:\"\";}','2014-08-23 01:19:41'),(131,7,'registration_error_messages','a:0:{}','2014-08-23 01:19:41'),(132,7,'selected_gateway','wpsc_merchant_paypal_express','2014-08-23 01:19:41'),(133,7,'checkout_misc_error_messages','','2014-08-23 01:19:41'),(134,7,'checkout_session_id','6471408758066','2014-08-23 01:41:06'),(135,7,'purchase_id','24','2014-08-23 01:19:41'),(136,7,'paypal_express_converted_amount','0.00','2014-08-23 01:19:41'),(137,7,'paypal_express_original_amount','0.00','2014-08-23 01:19:41'),(138,7,'paypal_express_sessionid','6471408758066','2014-08-23 01:41:06'),(139,7,'paypal_express_currency_code_type','AUD','2014-08-23 01:19:41'),(140,7,'paypal_express_payment_type','Sale','2014-08-23 01:19:41'),(141,7,'paypal_express_nvp_req_array','a:21:{s:6:\"METHOD\";s:18:\"SetExpressCheckout\";s:7:\"VERSION\";s:2:\"71\";s:3:\"PWD\";s:16:\"MMB2AJ8DQCFWN7FE\";s:4:\"USER\";s:27:\"belle_api1.yvettemerton.com\";s:9:\"SIGNATURE\";s:56:\"AFcWxV21C7fd0v3bYYYRCpSSRl31AR1F9rBtozfqeo2R-Fli8WL97QJj\";s:30:\"PAYMENTREQUEST_0_PAYMENTACTION\";s:4:\"Sale\";s:9:\"RETURNURL\";s:89:\"http://partridgeandpear.com.au/products-page/transaction-results/?sessionid=6471408758066\";s:7:\"gateway\";s:6:\"paypal\";s:9:\"CANCELURL\";s:54:\"http://partridgeandpear.com.au/products-page/checkout/\";s:29:\"PAYMENTREQUEST_0_CURRENCYCODE\";s:3:\"AUD\";s:27:\"PAYMENTREQUEST_0_SHIPTONAME\";s:1:\" \";s:29:\"PAYMENTREQUEST_0_SHIPTOSTREET\";s:0:\"\";s:27:\"PAYMENTREQUEST_0_SHIPTOCITY\";s:0:\"\";s:34:\"PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE\";s:2:\"AU\";s:26:\"PAYMENTREQUEST_0_SHIPTOZIP\";s:0:\"\";s:28:\"PAYMENTREQUEST_0_SHIPTOSTATE\";s:2:\"WA\";s:24:\"PAYMENTREQUEST_0_ITEMAMT\";s:4:\"0.00\";s:28:\"PAYMENTREQUEST_0_SHIPPINGAMT\";s:4:\"0.00\";s:23:\"PAYMENTREQUEST_0_TAXAMT\";s:4:\"0.00\";s:20:\"PAYMENTREQUEST_0_AMT\";s:4:\"0.00\";s:12:\"BUTTONSOURCE\";s:11:\"PP-ECWizard\";}','2014-08-23 01:41:06'),(142,7,'_wpsc_cart.log_id','29','2014-08-23 01:41:06'),(143,9,'_wpsc_key','_QUrpQb0UEkHo','2014-08-23 01:20:22'),(144,10,'_wpsc_key','_3bnV0qTGRiZt','2014-08-23 01:20:22'),(145,9,'_wpsc_cart.unique_id','bde66de57b40fe6409753be6eb382a3d695ea024','2014-08-23 01:20:22'),(146,9,'_wpsc_cart.is_incomplete','1','2014-08-23 01:20:22'),(147,9,'_wpsc_cart.current_cart_item','-1','2014-08-23 01:20:22'),(148,9,'_wpsc_cart.current_shipping_method','-1','2014-08-23 01:20:22'),(149,9,'_wpsc_cart.current_shipping_quote','-1','2014-08-23 01:20:22'),(150,9,'_wpsc_cart.subtotal','55.8','2014-08-23 02:30:10'),(151,9,'_wpsc_cart.total_price','68.8','2014-08-23 02:30:10'),(152,9,'_wpsc_cart.uses_shipping','2','2014-08-23 02:30:10'),(153,9,'_wpsc_cart.cart_items','[encoded data, 10996 characters]','2014-08-23 02:30:10'),(154,9,'_wpsc_cart.cart_item','[encoded data, 5360 characters]','2014-08-23 01:30:21'),(155,9,'_wpsc_cart.cart_item_count','2','2014-08-23 02:30:10'),(156,9,'category_shipping_target_market_conflict','','2014-08-23 01:20:48'),(158,9,'shippingSameBilling','','2014-08-23 01:20:48'),(159,9,'_wpsc_cart.selected_shipping_method','weightrate','2014-08-23 01:20:49'),(160,9,'_wpsc_cart.shipping_methods','YToxOntpOjA7czoxMDoid2VpZ2h0cmF0ZSI7fQ==','2014-08-23 01:20:49'),(161,9,'_wpsc_cart.shipping_method_count','1','2014-08-23 01:20:49'),(162,9,'_wpsc_cart.shipping_quotes','YToxOntzOjExOiJXZWlnaHQgUmF0ZSI7czoyOiIxMyI7fQ==','2014-08-23 01:30:21'),(163,9,'_wpsc_cart.shipping_quote_count','1','2014-08-23 01:24:47'),(164,9,'shippingcountry','AU','2014-08-23 01:21:00'),(167,9,'_wpsc_cart.delivery_country','AU','2014-08-23 01:21:04'),(168,9,'_wpsc_cart.shipping_method','weightrate','2014-08-23 01:21:04'),(169,9,'_wpsc_cart.shipping_quote','a:2:{s:4:\"name\";s:11:\"Weight Rate\";s:5:\"value\";d:13;}','2014-08-23 01:30:26'),(170,9,'shippingstate','wa','2014-08-23 01:21:12'),(173,9,'_wpsc_cart.selected_shipping_option','Weight Rate','2014-08-23 01:21:16'),(174,9,'_wpsc_cart.base_shipping','13','2014-08-23 01:30:21'),(175,9,'billingaddress','22 Burnside Way','2014-08-23 01:21:24'),(176,9,'billingcity','Waikiki','2014-08-23 01:21:24'),(177,9,'billingemail','cam@hiddenshoal.com','2014-08-23 01:21:25'),(178,9,'billinglastname','Merton','2014-08-23 01:21:25'),(179,9,'billingcountry','AU','2014-08-23 01:21:25'),(180,9,'_wpsc_cart.selected_country','AU','2014-08-23 01:21:25'),(181,9,'billingstate','WA','2014-08-23 01:21:25'),(182,9,'billingphone','61895284315','2014-08-23 01:21:26'),(183,9,'billingfirstname','Cam','2014-08-23 01:21:26'),(184,9,'billingpostcode','6169','2014-08-23 01:21:26'),(186,1,'purchase_id','25','2014-08-23 01:21:32'),(188,1,'purchase_id','26','2014-08-23 01:24:41'),(190,9,'_wpsc_cart.selected_shipping_amount','13','2014-08-23 01:30:26'),(191,11,'_wpsc_key','_fGjL39T0QdDW','2014-08-23 01:24:51'),(192,12,'_wpsc_key','_HOyeRV4wf8tc','2014-08-23 01:24:51'),(193,11,'category_shipping_target_market_conflict','','2014-08-23 01:24:52'),(195,11,'_wpsc_cart.unique_id','396b434859b36282bbc562d4244d310bc6107409','2014-08-23 01:24:52'),(196,11,'_wpsc_cart.is_incomplete','1','2014-08-23 01:24:52'),(197,11,'_wpsc_cart.current_cart_item','-1','2014-08-23 01:24:52'),(198,11,'_wpsc_cart.current_shipping_method','-1','2014-08-23 01:24:52'),(199,11,'_wpsc_cart.current_shipping_quote','-1','2014-08-23 01:24:52'),(201,11,'billingfirstname','Cam','2014-08-23 01:25:28'),(202,11,'billinglastname','Merton','2014-08-23 01:25:28'),(203,11,'billingaddress','22 Burnside Way','2014-08-23 01:25:28'),(204,11,'billingcity','Waikiki','2014-08-23 01:25:28'),(206,11,'billingcountry','AU','2014-08-23 01:25:28'),(207,11,'billingregion','','2014-08-23 01:25:28'),(208,11,'billingstate','WA','2014-08-23 01:29:53'),(209,11,'billingpostcode','6169','2014-08-23 01:25:28'),(210,11,'billingphone','61895284315','2014-08-23 01:25:28'),(211,11,'billingemail','cam@hiddenshoal.com','2014-08-23 01:25:28'),(212,11,'shippingfirstname','','2014-08-23 01:25:28'),(213,11,'shippinglastname','','2014-08-23 01:25:28'),(214,11,'shippingaddress','','2014-08-23 01:25:28'),(216,11,'shippingcity','','2014-08-23 01:25:28'),(218,11,'shippingcountry','AU','2014-08-23 01:25:28'),(219,11,'shippingregion','','2014-08-23 01:25:28'),(220,11,'shippingstate','wa','2014-08-23 01:29:53'),(221,11,'shippingpostcode','','2014-08-23 01:25:28'),(225,11,'selected_gateway','wpsc_merchant_paypal_express','2014-08-23 01:25:28'),(227,11,'checkout_session_id','6661408757393','2014-08-23 01:29:53'),(228,11,'purchase_id','27','2014-08-23 01:25:28'),(229,11,'paypal_express_converted_amount','0.00','2014-08-23 01:25:28'),(230,11,'paypal_express_original_amount','0.00','2014-08-23 01:25:28'),(231,11,'paypal_express_sessionid','6661408757393','2014-08-23 01:29:53'),(232,11,'paypal_express_currency_code_type','AUD','2014-08-23 01:25:28'),(233,11,'paypal_express_payment_type','Sale','2014-08-23 01:25:28'),(234,11,'paypal_express_nvp_req_array','a:21:{s:6:\"METHOD\";s:18:\"SetExpressCheckout\";s:7:\"VERSION\";s:2:\"71\";s:3:\"PWD\";s:16:\"MMB2AJ8DQCFWN7FE\";s:4:\"USER\";s:27:\"belle_api1.yvettemerton.com\";s:9:\"SIGNATURE\";s:56:\"AFcWxV21C7fd0v3bYYYRCpSSRl31AR1F9rBtozfqeo2R-Fli8WL97QJj\";s:30:\"PAYMENTREQUEST_0_PAYMENTACTION\";s:4:\"Sale\";s:9:\"RETURNURL\";s:89:\"http://partridgeandpear.com.au/products-page/transaction-results/?sessionid=6661408757393\";s:7:\"gateway\";s:6:\"paypal\";s:9:\"CANCELURL\";s:54:\"http://partridgeandpear.com.au/products-page/checkout/\";s:29:\"PAYMENTREQUEST_0_CURRENCYCODE\";s:3:\"AUD\";s:27:\"PAYMENTREQUEST_0_SHIPTONAME\";s:1:\" \";s:29:\"PAYMENTREQUEST_0_SHIPTOSTREET\";s:0:\"\";s:27:\"PAYMENTREQUEST_0_SHIPTOCITY\";s:0:\"\";s:34:\"PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE\";s:2:\"AU\";s:26:\"PAYMENTREQUEST_0_SHIPTOZIP\";s:0:\"\";s:28:\"PAYMENTREQUEST_0_SHIPTOSTATE\";s:2:\"wa\";s:24:\"PAYMENTREQUEST_0_ITEMAMT\";s:4:\"0.00\";s:28:\"PAYMENTREQUEST_0_SHIPPINGAMT\";s:4:\"0.00\";s:23:\"PAYMENTREQUEST_0_TAXAMT\";s:4:\"0.00\";s:20:\"PAYMENTREQUEST_0_AMT\";s:4:\"0.00\";s:12:\"BUTTONSOURCE\";s:11:\"PP-ECWizard\";}','2014-08-23 01:29:53'),(235,11,'_wpsc_cart.log_id','28','2014-08-23 01:29:54'),(238,11,'purchase_id','28','2014-08-23 01:29:53'),(239,11,'_wpsc_cart.delivery_country','AU','2014-08-23 01:29:54'),(240,11,'_wpsc_cart.selected_country','AU','2014-08-23 01:29:54'),(245,7,'_wpsc_cart.delivery_country','AU','2014-08-23 01:40:47'),(246,7,'_wpsc_cart.selected_country','AU','2014-08-23 01:40:47'),(249,7,'checkout_error_messages','a:0:{}','2014-08-23 01:41:06'),(250,7,'purchase_id','29','2014-08-23 01:41:06'),(251,13,'_wpsc_key','_oibLp0UJzkJV','2014-08-23 01:54:21'),(252,14,'_wpsc_key','_c6r6ylNzV3SJ','2014-08-23 01:54:21'),(253,13,'_wpsc_cart.unique_id','4893a03fc256902b5089425fe1507c4ad55b1cf5','2014-08-23 01:54:21'),(254,13,'_wpsc_cart.is_incomplete','1','2014-08-23 01:54:21'),(255,13,'_wpsc_cart.current_cart_item','-1','2014-08-23 01:54:21'),(256,13,'_wpsc_cart.current_shipping_method','-1','2014-08-23 01:54:21'),(257,13,'_wpsc_cart.current_shipping_quote','-1','2014-08-23 01:54:21'),(258,13,'_wpsc_cart.subtotal','13.95','2014-08-23 01:54:38'),(259,13,'_wpsc_cart.total_price','22.45','2014-08-23 01:55:02'),(260,13,'_wpsc_cart.uses_shipping','1','2014-08-23 01:54:38'),(261,13,'_wpsc_cart.cart_items','[encoded data, 5396 characters]','2014-08-23 01:54:38'),(262,13,'_wpsc_cart.cart_item','[encoded data, 5384 characters]','2014-08-23 01:54:38'),(263,13,'_wpsc_cart.cart_item_count','1','2014-08-23 01:54:38'),(264,13,'category_shipping_target_market_conflict','','2014-08-23 01:54:42'),(266,13,'shippingSameBilling','','2014-08-23 01:54:42'),(267,13,'_wpsc_cart.selected_shipping_method','weightrate','2014-08-23 01:54:42'),(268,13,'_wpsc_cart.shipping_methods','YToxOntpOjA7czoxMDoid2VpZ2h0cmF0ZSI7fQ==','2014-08-23 01:54:42'),(269,13,'_wpsc_cart.shipping_method_count','1','2014-08-23 01:54:42'),(270,13,'_wpsc_cart.shipping_quotes','YToxOntzOjExOiJXZWlnaHQgUmF0ZSI7czo0OiI4LjUwIjt9','2014-08-23 01:54:42'),(271,13,'_wpsc_cart.shipping_quote_count','2','2014-08-23 01:55:12'),(272,13,'shippingcountry','AU','2014-08-23 01:54:48'),(275,13,'_wpsc_cart.delivery_country','AU','2014-08-23 01:54:54'),(276,13,'_wpsc_cart.shipping_method','weightrate','2014-08-23 01:54:54'),(277,13,'_wpsc_cart.shipping_quote','a:2:{s:4:\"name\";s:11:\"Weight Rate\";s:5:\"value\";d:8.5;}','2014-08-23 01:54:54'),(278,13,'_wpsc_cart.selected_shipping_option','Weight Rate','2014-08-23 01:55:01'),(279,13,'_wpsc_cart.base_shipping','8.5','2014-08-23 01:55:02'),(280,13,'billingfirstname','Cam','2014-08-23 01:55:12'),(281,13,'billingemail','cam@hiddenshoal.com','2014-08-23 01:55:12'),(282,13,'billingcity','Waikiki','2014-08-23 01:55:12'),(283,13,'billingcountry','AU','2014-08-23 01:55:13'),(284,13,'_wpsc_cart.selected_country','AU','2014-08-23 01:55:13'),(285,13,'billingstate','WA','2014-08-23 01:55:13'),(286,13,'billingphone','61895284315','2014-08-23 01:55:13'),(287,13,'billingaddress','22 Burnside Way','2014-08-23 01:55:14'),(288,13,'billingpostcode','6169','2014-08-23 01:55:14'),(289,13,'billinglastname','Merton','2014-08-23 01:55:14'),(291,1,'purchase_id','30','2014-08-23 01:55:22');

--
-- Table structure for table `wp_wpsc_visitors`
--

CREATE TABLE `wp_wpsc_visitors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `last_active` timestamp NULL DEFAULT NULL,
  `expires` timestamp NULL DEFAULT NULL,
  `created` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `expires` (`expires`),
  KEY `last_active` (`last_active`),
  KEY `created` (`created`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_wpsc_visitors`
--

INSERT INTO `wp_wpsc_visitors` (`id`, `user_id`, `last_active`, `expires`, `created`) VALUES (1,NULL,'2014-08-23 05:55:22','2014-08-25 05:55:22',NULL),(3,1,'2014-08-23 05:10:48',NULL,'2014-08-23 05:10:48'),(4,1,'2014-08-23 05:10:48',NULL,'2014-08-23 05:10:48'),(5,0,'2014-08-23 05:40:44','2014-08-25 05:40:44','2014-08-23 05:11:02'),(6,0,'2014-08-23 05:11:02','2014-08-23 07:11:02','2014-08-23 05:11:02'),(7,0,'2014-08-23 05:41:06','2014-08-25 05:41:06','2014-08-23 05:19:09'),(8,0,'2014-08-23 05:19:09','2014-08-23 07:19:09','2014-08-23 05:19:09'),(9,0,'2014-08-23 06:30:10','2014-08-25 06:30:10','2014-08-23 05:20:22'),(10,0,'2014-08-23 05:20:22','2014-08-23 07:20:22','2014-08-23 05:20:22'),(11,0,'2014-08-23 05:29:53','2014-08-25 05:29:53','2014-08-23 05:24:51'),(12,0,'2014-08-23 05:24:51','2014-08-23 07:24:51','2014-08-23 05:24:51'),(13,0,'2014-08-23 05:54:38','2014-08-25 05:54:38','2014-08-23 05:54:21'),(14,0,'2014-08-23 05:54:21','2014-08-23 07:54:21','2014-08-23 05:54:21');

--
-- Dumping events for database 'hiddensh_old_pp'
--

--
-- Dumping routines for database 'hiddensh_old_pp'
--


