Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.5.2.2
- -- http://www.phpmyadmin.net
- --
- -- Host: 127.0.0.1
- -- Generation Time: Apr 28, 2013 at 03:17 AM
- -- Server version: 5.5.27
- -- PHP Version: 5.4.7
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `wordpress`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `wp_woocommerce_order_itemmeta`
- --
- CREATE TABLE IF NOT EXISTS `wp_woocommerce_order_itemmeta` (
- `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
- `order_item_id` bigint(20) NOT NULL,
- `meta_key` varchar(255) DEFAULT NULL,
- `meta_value` longtext,
- PRIMARY KEY (`meta_id`),
- KEY `order_item_id` (`order_item_id`),
- KEY `meta_key` (`meta_key`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=139 ;
- --
- -- Dumping data for table `wp_woocommerce_order_itemmeta`
- --
- INSERT INTO `wp_woocommerce_order_itemmeta` (`meta_id`, `order_item_id`, `meta_key`, `meta_value`) VALUES
- (119, 16, '_line_tax', '19.43'),
- (118, 16, '_line_total', '111'),
- (117, 16, '_line_subtotal', '111'),
- (116, 16, '_variation_id', ''),
- (115, 16, '_product_id', '42'),
- (114, 16, '_tax_class', ''),
- (113, 16, '_qty', '1'),
- (112, 15, 'shipping_tax_amount', '0'),
- (111, 15, 'tax_amount', '20'),
- (110, 15, 'compound', '0'),
- (109, 15, 'label', 'Tax'),
- (108, 15, 'rate_id', '1'),
- (107, 14, '_line_subtotal_tax', '20'),
- (106, 14, '_line_tax', '20'),
- (105, 14, '_line_total', '100'),
- (104, 14, '_line_subtotal', '100'),
- (103, 14, '_variation_id', ''),
- (102, 14, '_product_id', '27'),
- (101, 14, '_tax_class', ''),
- (92, 13, '_qty', '4'),
- (93, 13, '_tax_class', ''),
- (94, 13, '_product_id', '42'),
- (95, 13, '_variation_id', ''),
- (96, 13, '_line_subtotal', '444'),
- (97, 13, '_line_total', '444'),
- (98, 13, '_line_tax', '0'),
- (99, 13, '_line_subtotal_tax', '0'),
- (100, 14, '_qty', '1'),
- (91, 12, '_line_subtotal_tax', '0'),
- (90, 12, '_line_tax', '0'),
- (89, 12, '_line_total', '100'),
- (88, 12, '_line_subtotal', '100'),
- (87, 12, '_variation_id', ''),
- (86, 12, '_product_id', '27'),
- (85, 12, '_tax_class', ''),
- (84, 12, '_qty', '1'),
- (83, 11, '_line_subtotal_tax', '52.5'),
- (82, 11, '_line_tax', '52.5'),
- (81, 11, '_line_total', '300.00'),
- (80, 11, '_line_subtotal', '300.00'),
- (79, 11, '_variation_id', ''),
- (78, 11, '_product_id', '27'),
- (77, 11, '_tax_class', ''),
- (76, 11, '_qty', '3'),
- (120, 16, '_line_subtotal_tax', '19.43'),
- (121, 17, 'rate_id', '1'),
- (122, 17, 'label', 'Tax'),
- (123, 17, 'compound', '0'),
- (124, 17, 'tax_amount', '19.43'),
- (125, 17, 'shipping_tax_amount', '0'),
- (126, 18, '_qty', '1'),
- (127, 18, '_tax_class', ''),
- (128, 18, '_product_id', '42'),
- (129, 18, '_variation_id', ''),
- (130, 18, '_line_subtotal', '111.00'),
- (131, 18, '_line_subtotal_tax', '19.43'),
- (132, 18, '_line_total', '111.00'),
- (133, 18, '_line_tax', '19.43'),
- (134, 19, 'rate_id', '1'),
- (135, 19, 'label', 'Tax'),
- (136, 19, 'compound', '0'),
- (137, 19, 'tax_amount', '71.93'),
- (138, 19, 'shipping_tax_amount', '0');
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- -- phpMyAdmin SQL Dump
- -- version 3.5.2.2
- -- http://www.phpmyadmin.net
- --
- -- Host: 127.0.0.1
- -- Generation Time: Apr 28, 2013 at 03:16 AM
- -- Server version: 5.5.27
- -- PHP Version: 5.4.7
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `wordpress`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `wp_woocommerce_order_items`
- --
- CREATE TABLE IF NOT EXISTS `wp_woocommerce_order_items` (
- `order_item_id` bigint(20) NOT NULL AUTO_INCREMENT,
- `order_item_name` longtext NOT NULL,
- `order_item_type` varchar(200) NOT NULL DEFAULT '',
- `order_id` bigint(20) NOT NULL,
- PRIMARY KEY (`order_item_id`),
- KEY `order_id` (`order_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
- --
- -- Dumping data for table `wp_woocommerce_order_items`
- --
- INSERT INTO `wp_woocommerce_order_items` (`order_item_id`, `order_item_name`, `order_item_type`, `order_id`) VALUES
- (16, 'Samsung TV 42″ (Copy)', 'line_item', 53),
- (15, 'TAX-1', 'tax', 52),
- (13, 'Samsung TV 42″ (Copy)', 'line_item', 51),
- (14, 'Samsung TV 42″', 'line_item', 52),
- (12, 'Samsung TV 42″', 'line_item', 51),
- (11, 'Samsung TV 42″', 'line_item', 50),
- (17, 'TAX-1', 'tax', 53),
- (18, 'Samsung TV 42″ (Copy)', 'line_item', 50),
- (19, 'TAX-1', 'tax', 50);
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- -- phpMyAdmin SQL Dump
- -- version 3.5.2.2
- -- http://www.phpmyadmin.net
- --
- -- Host: 127.0.0.1
- -- Generation Time: Apr 28, 2013 at 03:19 AM
- -- Server version: 5.5.27
- -- PHP Version: 5.4.7
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `wordpress`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `wp_postmeta`
- --
- CREATE TABLE IF NOT EXISTS `wp_postmeta` (
- `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
- `meta_key` varchar(255) DEFAULT NULL,
- `meta_value` longtext,
- PRIMARY KEY (`meta_id`),
- KEY `post_id` (`post_id`),
- KEY `meta_key` (`meta_key`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=638 ;
- --
- -- Dumping data for table `wp_postmeta`
- --
- INSERT INTO `wp_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES
- (1, 2, '_wp_page_template', 'page-templates/front-page.php'),
- (2, 1, '_edit_lock', '1365352772:1'),
- (3, 1, '_edit_last', '1'),
- (12, 2, '_edit_lock', '1365352092:1'),
- (13, 2, '_edit_last', '1'),
- (48, 27, '_weight', ''),
- (47, 27, '_featured', 'no'),
- (46, 27, '_purchase_note', ''),
- (45, 27, '_tax_class', ''),
- (44, 27, '_tax_status', 'taxable'),
- (43, 27, '_sale_price', '50'),
- (41, 27, '_product_image_gallery', ''),
- (42, 27, '_regular_price', '100'),
- (40, 27, '_virtual', 'no'),
- (39, 27, '_downloadable', 'no'),
- (38, 27, 'total_sales', '10'),
- (37, 27, '_stock_status', 'instock'),
- (36, 27, '_visibility', 'visible'),
- (35, 27, '_edit_lock', '1367097506:1'),
- (34, 27, '_edit_last', '1'),
- (49, 27, '_length', ''),
- (50, 27, '_width', ''),
- (51, 27, '_height', ''),
- (52, 27, '_sku', 'MOO123'),
- (53, 27, '_product_attributes', 'a:0:{}'),
- (54, 27, '_sale_price_dates_from', ''),
- (55, 27, '_sale_price_dates_to', ''),
- (56, 27, '_price', '50'),
- (57, 27, '_sold_individually', ''),
- (58, 27, '_stock', ''),
- (59, 27, '_backorders', 'no'),
- (60, 27, '_manage_stock', 'no'),
- (61, 15, '_edit_lock', '1365356277:1'),
- (224, 42, '_sale_price_dates_to', ''),
- (223, 42, '_sale_price_dates_from', ''),
- (222, 42, '_product_attributes', 'a:0:{}'),
- (221, 42, '_sku', ''),
- (220, 42, '_height', ''),
- (219, 42, '_width', ''),
- (218, 42, '_length', ''),
- (217, 42, '_edit_last', '1'),
- (216, 42, '_edit_lock', '1366915332:1'),
- (215, 42, '_visibility', 'visible'),
- (214, 42, '_stock_status', 'instock'),
- (213, 42, 'total_sales', '9'),
- (212, 42, '_downloadable', 'no'),
- (211, 42, '_virtual', 'no'),
- (210, 42, '_regular_price', '111'),
- (209, 42, '_product_image_gallery', ''),
- (208, 42, '_sale_price', ''),
- (207, 42, '_tax_status', ''),
- (206, 42, '_tax_class', ''),
- (205, 42, '_purchase_note', ''),
- (204, 42, '_featured', 'no'),
- (203, 42, '_weight', ''),
- (634, 53, '_recorded_coupon_usage_counts', 'yes'),
- (635, 53, '_edit_lock', '1367093962:1'),
- (636, 53, '_edit_last', '1'),
- (637, 53, 'Download Permissions Granted', '1'),
- (633, 53, '_recorded_sales', 'yes'),
- (632, 53, '_customer_user_agent', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0'),
- (631, 53, '_customer_ip_address', '::1'),
- (630, 53, '_prices_include_tax', 'no'),
- (626, 53, '_order_total', '163.43'),
- (627, 53, '_order_key', 'order_517b21ca47d87'),
- (628, 53, '_customer_user', '1'),
- (629, 53, '_order_currency', 'GBP'),
- (625, 53, '_order_shipping_tax', '0'),
- (225, 42, '_price', '111'),
- (226, 42, '_sold_individually', ''),
- (227, 42, '_stock', ''),
- (228, 42, '_backorders', 'no'),
- (229, 42, '_manage_stock', 'no'),
- (624, 53, '_order_tax', '19.43'),
- (623, 53, '_cart_discount', '0.00'),
- (622, 53, '_order_discount', '0.00'),
- (621, 53, '_order_shipping', '33'),
- (620, 53, '_payment_method_title', 'Cheque Payment'),
- (619, 53, '_payment_method', 'cheque'),
- (618, 53, '_shipping_method_title', 'Free Shipping'),
- (617, 53, '_shipping_method', 'flat_rate'),
- (616, 53, '_shipping_postcode', 'MM1 1MM'),
- (615, 53, '_shipping_state', 'Lancashire'),
- (614, 53, '_shipping_city', 'Manchester'),
- (613, 53, '_shipping_address_2', ''),
- (612, 53, '_shipping_address_1', '20 Street Name'),
- (611, 53, '_shipping_company', ''),
- (610, 53, '_shipping_last_name', 'Bloggs'),
- (609, 53, '_shipping_first_name', 'Joe'),
- (608, 53, '_shipping_country', 'GB'),
- (607, 53, '_billing_phone', '02365478962'),
- (605, 53, '_billing_postcode', 'MM1 1MM'),
- (604, 53, '_billing_state', 'Lancashire'),
- (603, 53, '_billing_city', 'Manchester'),
- (602, 53, '_billing_address_2', ''),
- (601, 53, '_billing_address_1', '20 Street Name'),
- (600, 53, '_billing_company', ''),
- (599, 53, '_billing_last_name', 'Bloggs'),
- (598, 53, '_billing_first_name', 'Joe'),
- (597, 53, '_billing_country', 'GB'),
- (596, 52, 'Download Permissions Granted', '1'),
- (594, 52, '_edit_lock', '1367023930:1'),
- (595, 52, '_edit_last', '1'),
- (592, 52, '_recorded_sales', 'yes'),
- (593, 52, '_recorded_coupon_usage_counts', 'yes'),
- (545, 51, '_order_key', 'order_517b19dbde032'),
- (546, 51, '_customer_user', '1'),
- (547, 51, '_order_currency', 'GBP'),
- (548, 51, '_prices_include_tax', 'no'),
- (549, 51, '_customer_ip_address', '::1'),
- (550, 51, '_customer_user_agent', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0'),
- (551, 51, '_recorded_sales', 'yes'),
- (552, 51, '_recorded_coupon_usage_counts', 'yes'),
- (553, 51, '_edit_lock', '1367022078:1'),
- (554, 51, '_edit_last', '1'),
- (555, 51, 'Download Permissions Granted', '1'),
- (556, 52, '_billing_country', 'GB'),
- (557, 52, '_billing_first_name', 'Joe'),
- (558, 52, '_billing_last_name', 'Bloggs'),
- (559, 52, '_billing_company', ''),
- (560, 52, '_billing_address_1', '20 Street Name'),
- (561, 52, '_billing_address_2', ''),
- (562, 52, '_billing_city', 'Manchester'),
- (563, 52, '_billing_state', 'Lancashire'),
- (564, 52, '_billing_postcode', 'MM1 1MM'),
- (566, 52, '_billing_phone', '02365478962'),
- (567, 52, '_shipping_country', 'GB'),
- (568, 52, '_shipping_first_name', 'Joe'),
- (569, 52, '_shipping_last_name', 'Bloggs'),
- (570, 52, '_shipping_company', ''),
- (571, 52, '_shipping_address_1', '20 Street Name'),
- (572, 52, '_shipping_address_2', ''),
- (573, 52, '_shipping_city', 'Manchester'),
- (574, 52, '_shipping_state', 'Lancashire'),
- (575, 52, '_shipping_postcode', 'MM1 1MM'),
- (576, 52, '_shipping_method', 'free_shipping'),
- (577, 52, '_shipping_method_title', 'Free Shipping'),
- (578, 52, '_payment_method', 'cheque'),
- (579, 52, '_payment_method_title', 'Cheque Payment'),
- (580, 52, '_order_shipping', '0.00'),
- (581, 52, '_order_discount', '0.00'),
- (582, 52, '_cart_discount', '0.00'),
- (583, 52, '_order_tax', '20'),
- (584, 52, '_order_shipping_tax', '0'),
- (585, 52, '_order_total', '120.00'),
- (586, 52, '_order_key', 'order_517b21263f2b3'),
- (587, 52, '_customer_user', '1'),
- (588, 52, '_order_currency', 'GBP'),
- (589, 52, '_prices_include_tax', 'no'),
- (590, 52, '_customer_ip_address', '::1'),
- (591, 52, '_customer_user_agent', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0'),
- (544, 51, '_order_total', '544.00'),
- (543, 51, '_order_shipping_tax', '0'),
- (542, 51, '_order_tax', '0'),
- (541, 51, '_cart_discount', '0.00'),
- (540, 51, '_order_discount', '0.00'),
- (539, 51, '_order_shipping', '0.00'),
- (538, 51, '_payment_method_title', 'Cheque Payment'),
- (537, 51, '_payment_method', 'cheque'),
- (536, 51, '_shipping_method_title', 'Free Shipping'),
- (535, 51, '_shipping_method', 'free_shipping'),
- (534, 51, '_shipping_postcode', 'MM1 1MM'),
- (533, 51, '_shipping_state', 'Lancashire'),
- (532, 51, '_shipping_city', 'Manchester'),
- (531, 51, '_shipping_address_2', ''),
- (530, 51, '_shipping_address_1', '20 Street Name'),
- (529, 51, '_shipping_company', ''),
- (528, 51, '_shipping_last_name', 'Bloggs'),
- (527, 51, '_shipping_first_name', 'Joe'),
- (526, 51, '_shipping_country', 'GB'),
- (525, 51, '_billing_phone', '02365478962'),
- (523, 51, '_billing_postcode', 'MM1 1MM'),
- (522, 51, '_billing_state', 'Lancashire'),
- (521, 51, '_billing_city', 'Manchester'),
- (520, 51, '_billing_address_2', ''),
- (519, 51, '_billing_address_1', '20 Street Name'),
- (518, 51, '_billing_company', ''),
- (517, 51, '_billing_last_name', 'Bloggs'),
- (516, 51, '_billing_first_name', 'Joe'),
- (515, 51, '_billing_country', 'GB'),
- (514, 50, 'Download Permissions Granted', '1'),
- (513, 50, '_edit_last', '1'),
- (512, 50, '_edit_lock', '1367092366:1'),
- (511, 50, '_recorded_coupon_usage_counts', 'yes'),
- (510, 50, '_recorded_sales', 'yes'),
- (509, 50, '_customer_user_agent', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0'),
- (508, 50, '_customer_ip_address', '::1'),
- (507, 50, '_prices_include_tax', 'no'),
- (506, 50, '_order_currency', 'GBP'),
- (505, 50, '_customer_user', '1'),
- (504, 50, '_order_key', 'order_517b0ec5645b9'),
- (503, 50, '_order_total', '482.93'),
- (502, 50, '_order_shipping_tax', '0'),
- (501, 50, '_order_tax', '71.93'),
- (500, 50, '_cart_discount', '0.00'),
- (499, 50, '_order_discount', '0.00'),
- (498, 50, '_order_shipping', '0.00'),
- (497, 50, '_payment_method_title', 'Cheque Payment'),
- (496, 50, '_payment_method', 'cheque'),
- (495, 50, '_shipping_method_title', 'Free Shipping'),
- (494, 50, '_shipping_method', 'free_shipping'),
- (493, 50, '_shipping_postcode', 'MM1 1MM'),
- (492, 50, '_shipping_state', 'Lancashire'),
- (490, 50, '_shipping_address_2', ''),
- (491, 50, '_shipping_city', 'Manchester'),
- (474, 50, '_billing_country', 'GB'),
- (475, 50, '_billing_first_name', 'Joe'),
- (476, 50, '_billing_last_name', 'Bloggs'),
- (477, 50, '_billing_company', ''),
- (478, 50, '_billing_address_1', '20 Street Name'),
- (479, 50, '_billing_address_2', ''),
- (480, 50, '_billing_city', 'Manchester'),
- (481, 50, '_billing_state', 'Lancashire'),
- (482, 50, '_billing_postcode', 'MM1 1MM'),
- (484, 50, '_billing_phone', '02365478962'),
- (485, 50, '_shipping_country', 'GB'),
- (486, 50, '_shipping_first_name', 'Joe'),
- (487, 50, '_shipping_last_name', 'Bloggs'),
- (488, 50, '_shipping_company', ''),
- (489, 50, '_shipping_address_1', '20 Street Name');
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement