· 6 years ago · Mar 28, 2019, 10:36 PM
1
2Creating table: m_tbl_field_group_metadata ... success! Inserting Data into: m_tbl_field_group_metadata ... success!
3Creating table: m_tbl_field_metadata ... success! Inserting Data into: m_tbl_field_metadata ... success!
4Creating table: m_tbl_field_type_metadata ... success! Inserting Data into: m_tbl_field_type_metadata ... success!
5Creating table: m_tbl_table_metadata ... success! Inserting Data into: m_tbl_table_metadata ... success!
6Creating table: tbl_anet_sale_method ...
7CREATE TABLE tbl_anet_sale_method (
8 anet_sale_method_id int(11) NOT NULL default '0',
9 anet_sale_method varchar(255) NOT NULL default '',
10 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
11 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
12 PRIMARY KEY (anet_sale_method_id)
13)
14Invalid default value for 'date_time_created'
15
16Inserting Data into: tbl_anet_sale_method ...
17INSERT INTO tbl_anet_sale_method (anet_sale_method_id, anet_sale_method, date_time_created, date_time_modified) VALUES (1,'AUTH_ONLY','2004-12-03 15:04:16','2004-12-03 15:04:16'),(2,'AUTH_CAPTURE','2004-12-03 15:04:26','2004-12-03 15:04:26')
18Table 'cartkeeper.tbl_anet_sale_method' doesn't exist
19
20
21Creating table: tbl_answer ...
22CREATE TABLE tbl_answer (
23 answer_id int(11) NOT NULL auto_increment,
24 question_id int(11) NOT NULL default '0',
25 answer varchar(255) NOT NULL default '',
26 answer_sequence int(11) NOT NULL default '0',
27 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
28 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
29 PRIMARY KEY (answer_id),
30 KEY question_id_idx (question_id)
31)
32Invalid default value for 'date_time_created'
33
34Inserting Data into: tbl_answer ...
35INSERT INTO tbl_answer (answer_id, question_id, answer, answer_sequence, date_time_created, date_time_modified) VALUES (1,1,'Search Engine',1,'2005-05-18 09:19:53','2005-09-30 12:37:54'),(2,1,'Word of Mouth',2,'2005-05-18 09:19:53','2005-09-30 12:37:54'),(3,1,'Newspaper',3,'2005-05-18 09:19:53','2005-09-30 12:37:54'),(4,1,'Radio',4,'2005-05-18 09:19:53','2005-09-30 12:37:54'),(5,1,'TV',5,'2005-05-18 09:19:53','2005-09-30 12:37:54')
36Table 'cartkeeper.tbl_answer' doesn't exist
37
38
39Creating table: tbl_answer_type ...
40CREATE TABLE tbl_answer_type (
41 answer_type_id int(11) NOT NULL auto_increment,
42 answer_type varchar(255) NOT NULL default '',
43 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
44 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
45 PRIMARY KEY (answer_type_id)
46)
47Invalid default value for 'date_time_created'
48
49Inserting Data into: tbl_answer_type ...
50INSERT INTO tbl_answer_type (answer_type_id, answer_type, date_time_created, date_time_modified) VALUES (1,'select','2004-09-09 16:05:22','2004-09-09 16:05:22'),(2,'radio','2004-09-09 16:05:45','2004-09-09 16:05:45'),(3,'checkbox','2004-09-09 16:05:51','2004-09-09 16:05:51'),(4,'text','2004-09-09 16:05:56','2004-09-09 16:05:56'),(5,'textarea','2004-09-09 16:05:59','2004-09-09 16:05:59')
51Table 'cartkeeper.tbl_answer_type' doesn't exist
52
53
54Creating table: tbl_availability_status_map ... success!
55Creating table: tbl_billing ...
56CREATE TABLE tbl_billing (
57 billing_id int(11) NOT NULL auto_increment,
58 user_id int(11) NOT NULL default '0',
59 payment_type_id int(11) NOT NULL default '0',
60 additional_payment_data varchar(255) default NULL,
61 billing_first_name varchar(255) NOT NULL default '',
62 billing_last_name varchar(255) default NULL,
63 billing_company_name varchar(255) default NULL,
64 billing_address_1 varchar(255) NOT NULL default '',
65 billing_address_2 varchar(255) default NULL,
66 billing_city varchar(255) NOT NULL default '',
67 state_id int(11) default '0',
68 billing_state_province varchar(255) default NULL,
69 billing_postal_code varchar(255) NOT NULL default '',
70 country_id int(11) default NULL,
71 billing_phone varchar(255) NOT NULL default '',
72 billing_alt_phone varchar(255) default NULL,
73 billing_fax varchar(255) default NULL,
74 cc_no tinyblob,
75 cc_exp_month int(11) default NULL,
76 cc_exp_year int(11) default NULL,
77 cc_type_id int(11) default NULL,
78 cc_cvvs varchar(255) default NULL,
79 also_ship_to tinyint(4) default NULL,
80 billing_default tinyint(4) default NULL,
81 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
82 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
83 PRIMARY KEY (billing_id),
84 KEY user_id_idx (user_id)
85)
86Invalid default value for 'date_time_created'
87
88
89Creating table: tbl_bound_content ...
90CREATE TABLE tbl_bound_content (
91 bound_content_id int(11) NOT NULL auto_increment,
92 name varchar(255) NOT NULL default '',
93 content mediumtext,
94 image varchar(255) default NULL,
95 active tinyint(4) NOT NULL default '1',
96 bound_content_category_id int(11) default '0',
97 allow_image tinyint(4) default '0',
98 field_type enum('wysiwyg','textarea','text','text or image','image') default NULL,
99 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
100 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
101 PRIMARY KEY (bound_content_id),
102 UNIQUE KEY content_name (name),
103 KEY cat_idx (bound_content_category_id)
104)
105Invalid default value for 'date_time_created'
106
107Inserting Data into: tbl_bound_content ...
108INSERT INTO tbl_bound_content (bound_content_id, name, content, image, active, bound_content_category_id, allow_image, field_type, date_time_created, date_time_modified) VALUES (83,'Login Information Label','Login Information',NULL,1,5,0,'text','2005-08-11 08:47:55','2005-08-11 08:47:55'),(84,'Click to Track','Click to Track','track.gif',1,2,0,'text or image','2005-09-26 03:49:14','2005-09-26 03:49:14'),(85,'Manufacturers','Manufacturers',NULL,1,3,0,'text','2005-09-26 10:10:53','2005-09-26 10:11:24'),(3,'Cart Header','
109Please review the contents of your cart below.
110
111',NULL,1,14,0,'wysiwyg','2004-08-26 10:32:13','2005-09-26 10:03:09'),(4,'Cart Footer','
112 Use the Update Cart button to adjust item quantities and shipping.
113
114',NULL,1,14,0,'wysiwyg','2004-08-26 10:32:22','2005-09-27 07:07:11'),(5,'Cart Shipping Message','
115To calculate shipping select the appropriate inputs and click update cart.
116
117',NULL,1,14,0,'wysiwyg','2004-08-26 10:32:39','2005-09-27 07:07:11'),(6,'Invoice Header','The Demo Shop
118',NULL,1,2,0,'wysiwyg','2004-08-26 12:29:38','2005-05-19 13:22:35'),(7,'Invoice Footer','
119© 2005 - The Demo Shop
120\r\n
121',NULL,1,2,0,'wysiwyg','2004-08-26 12:29:48','2005-05-19 13:22:35'),(8,'Cart Confirmation Header','
122Please review your order below. Your order isn\'t final until clicking the "Finalize Order" button below.
123
124',NULL,1,15,0,'wysiwyg','2004-08-26 12:34:17','2005-10-06 08:29:08'),(9,'Cart Confirmation Footer','
125 Please click the \"finalize Order\" button only once.
126
127',NULL,1,15,0,'wysiwyg','2004-08-26 12:34:24','2005-10-06 08:29:08'),(10,'Cart Confirmation Message','
128 All orders are processed over a secure server connection.
129
130',NULL,1,15,0,'wysiwyg','2004-08-26 12:34:37','2005-10-06 08:29:08'),(11,'Order Complete Header','
131THANK YOU!
132
133',NULL,1,16,0,'wysiwyg','2004-08-26 12:34:52','2005-09-26 10:03:09'),(12,'Order Complete Footer','Please reference your order number in all communications.',NULL,1,16,0,'wysiwyg','2004-08-26 12:35:00','2005-09-26 10:03:09'),(13,'Order Complete Message','
134
135
136',NULL,1,16,0,'wysiwyg','2004-08-26 12:35:11','2005-09-26 10:03:09'),(14,'Plain Email header','The Demo Shop\r\n================================',NULL,1,2,0,'textarea','2004-08-26 13:20:19','2005-06-26 09:36:36'),(15,'Plain Email Footer','© 2005 - The Demo Shop',NULL,1,2,0,'textarea','2004-08-26 13:20:27','2005-06-26 09:36:36'),(16,'Left Nav Label','Products','',1,1,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:36'),(17,'Update Cart Button','Update Cart',NULL,1,8,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:36'),(18,'Check Out Button','Check Out',NULL,1,8,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:36'),(19,'Continue Shopping Button','Continue Shopping',NULL,1,8,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(21,'Create New Billing Record Button','Create New Billing Record',NULL,1,10,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(22,'Create New Shipping Record Button','Create New Shipping Record',NULL,1,10,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(23,'Proceed to Confirmation Button','Proceed to Confirmation',NULL,1,8,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(24,'Place Order Button','Finalize Order',NULL,1,8,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(25,'Update Billing Record Button','Update Billing Record',NULL,1,10,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(26,'Update Shipping Record Button','Update Shipping Record',NULL,1,10,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(27,'Edit Your Registration Details Button','Edit Your Registration Details',NULL,1,10,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(28,'Insert Billing Record Button','Insert Billing Record',NULL,1,10,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(29,'Insert Shipping Record Button','Insert Shipping Record',NULL,1,10,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(31,'Billing Information Section Label','Billing Information',NULL,1,13,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(32,'Shipping Information Section Label','Shipping Information',NULL,1,13,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(33,'Payment Information Section Label','Payment Information',NULL,1,13,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(34,'Billing Records Section Label','Billing Records',NULL,1,13,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(35,'Shipping Records Section Label','Shipping Records',NULL,1,13,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(36,'Billing Address Section Label','Billing Address',NULL,1,13,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(37,'Ship-to Address Section Label','Shipping Address',NULL,1,13,0,'text','0000-00-00 00:00:00','2005-06-26 09:36:37'),(38,'Required Input Asterick','*',NULL,1,1,0,'text','0000-00-00 00:00:00','2005-09-27 06:56:23'),(39,'Required Checkout Questions Error Message','You must answer all the required questions in order to complete your order.\r\n',NULL,1,15,0,'textarea','0000-00-00 00:00:00','2005-09-26 10:03:09'),(41,'Default Meta Keywords','',NULL,1,18,0,'textarea','2004-09-30 08:03:58','2005-09-27 06:32:26'),(42,'Default Meta Description','',NULL,1,18,0,'textarea','2004-09-30 08:04:52','2005-09-27 06:32:26'),(45,'Wishlist Button','Add to Wishlist',NULL,1,7,1,'text or image','2004-10-01 12:19:08','2005-06-26 09:36:37'),(46,'Email A Friend Button','Email A Friend',NULL,1,7,1,'text or image','2004-10-01 12:19:43','2005-06-26 09:36:37'),(47,'Request Info Button','Request Info',NULL,1,7,1,'text or image','2004-10-01 12:20:02','2005-06-26 09:36:37'),(48,'More Details Button','More Details',NULL,1,7,1,'text or image','2004-10-01 12:20:16','2005-06-26 09:36:37'),(49,'Order Button','Order',NULL,1,7,1,'text or image','2004-10-01 12:20:26','2005-06-26 09:36:37'),(53,'Default Back Order Message','This item is backordered.',NULL,1,12,0,'text','2004-10-01 14:33:16','2005-07-05 22:41:56'),(54,'Default Out of Stock Message','OUT OF STOCK',NULL,1,12,0,'text','2004-10-01 14:33:59','2005-07-05 22:41:56'),(55,'Related Items Text','Here are some other items you may be interested in.',NULL,1,19,0,'text','2004-10-01 15:18:22','2005-09-27 06:45:10'),(56,'New Products Header','These are our newest products!',NULL,1,17,0,'wysiwyg','2004-10-12 10:28:59','2005-09-26 10:04:23'),(57,'Sale Products Header','These products are on sale!',NULL,1,17,0,'wysiwyg','2004-10-12 10:36:15','2005-09-26 10:04:23'),(58,'All Products Header','All Products',NULL,1,17,0,'wysiwyg','2004-10-12 10:36:27','2005-09-26 10:04:23'),(59,'Featured Items','Featured Items',NULL,1,3,0,'text','2004-11-10 11:13:48','2005-09-27 07:05:31'),(60,'Search Button','Go','gosearch.gif',1,1,1,'text or image','2004-11-10 12:38:17','2005-09-26 07:26:41'),(61,'Other Manufacturers','Other Manufacturers',NULL,1,3,0,'text','2004-11-22 17:01:38','2005-09-27 06:59:11'),(63,'Items left in stock','Items left in stock.',NULL,1,12,0,'textarea','2004-12-06 13:06:07','2005-06-26 09:36:37'),(65,'Related items','You may be interested in these related items:',NULL,1,19,0,'text','2004-12-06 13:06:59','2005-09-27 06:45:10'),(67,'Category Available Message','The products in this category are not currently available, they will be available for purchase:',NULL,1,12,0,'text','2004-12-06 13:07:59','2005-06-26 09:36:37'),(68,'Keyword Search','Keyword Search',NULL,1,1,0,'text','2004-12-06 13:08:34','2005-06-26 09:36:37'),(69,'Advanced Search','Advanced Search',NULL,1,1,0,'text','2004-12-06 13:08:48','2005-06-26 09:36:37'),(70,'Top Sellers','Top Sellers',NULL,1,3,0,'text','2004-12-06 13:08:57','2005-09-27 06:51:51'),(71,'Promotional Code Text','Only one promotional code may be used per order.',NULL,1,14,0,'text','2004-12-20 05:45:45','2005-09-26 10:03:09'),(72,'Products','Products',NULL,1,3,0,'text','2005-01-18 04:27:55','2005-06-26 09:36:37'),(73,'Categories','Categories',NULL,1,3,0,'text','2005-01-18 04:28:06','2005-06-26 09:36:37'),(74,'Related Categories Label','You may be interested in these categories.',NULL,1,19,0,'text','2005-06-08 11:05:10','2005-09-27 06:45:54'),(75,'Related Manufacturers Label','You may be interested in these manufacturers.',NULL,1,19,0,'text','2005-06-08 11:05:10','2005-09-27 06:45:54'),(76,'Order Complete Conversion Codes','',NULL,1,16,0,'textarea','0000-00-00 00:00:00','2005-09-27 07:02:29'),(77,'Checkout Instructions','Enter your billing and shipping information for this order',NULL,1,5,0,'wysiwyg','2005-06-29 18:31:24','2005-09-30 08:48:17'),(78,'Login Message','You may log in to retrieve previous account information',NULL,1,5,0,'textarea','2005-06-29 18:31:24','2005-06-29 18:31:24'),(79,'Optional Login Instructions','Note: If you do not select a password, your account information will be stored temporarily, but you will not be able to retrieve it for future purchases.',NULL,1,5,0,'textarea','2005-06-29 18:31:24','2005-06-29 18:31:24'),(80,'Account Information Label','Contact Information',NULL,1,13,0,'textarea','2005-06-29 18:31:24','2005-09-26 07:23:20'),(81,'Login Label','Account Login',NULL,1,5,0,'textarea','2005-06-29 18:31:24','2005-06-29 18:31:24'),(82,'Checkout Screen Header','Checkout Screen',NULL,1,5,0,'wysiwyg','2005-06-29 18:31:25','2005-09-30 08:48:17'),(86,'View Image Gallery','View Image Gallery',NULL,1,7,0,'text','2005-09-28 11:12:23','2005-09-28 11:12:23'),(87,'View Larger Image','View Larger Image',NULL,1,7,0,'text','2005-09-28 11:19:31','2005-09-28 11:19:31'),(88,'All Manufacturers','All Manufacturers',NULL,1,17,0,'wysiwyg','2005-09-28 11:26:19','2005-09-28 11:26:19'),(89,'Mfg Drop Down','Manufacturers',NULL,1,3,0,'text','2005-09-28 18:27:16','2005-09-28 18:27:16'),(90,'Select Manufacturer','
137select a manufacturer to shop by
138 from the list above
139',NULL,1,3,0,'text','2005-09-28 18:31:27','2005-09-28 18:33:39'),(91,'Re-stock Request','Request re-stock notice?',NULL,1,7,0,'text or image','2005-09-28 22:56:35','2005-09-28 23:12:37'),(92,'Modify Cart','Modify Cart',NULL,1,15,1,'text or image','2005-10-06 08:28:30','2005-10-06 08:28:30'),(93,'New Items Link','New Items',NULL,1,17,0,'text','2006-04-14 12:43:58','2006-04-14 12:43:58'),(94,'Sale Items Link','Sale Items',NULL,1,17,0,'text','2006-04-14 12:43:58','2006-04-14 12:43:58'),(95,'All Items Link','All Items',NULL,1,17,0,'text','2006-04-14 12:43:58','2006-04-14 12:43:58'),(96,'All Manufacturers Link','All Manufacturers',NULL,1,17,0,'text','2006-04-14 12:43:58','2006-04-14 12:43:58'),(97,'New Icon','New','new.gif',1,12,1,'text or image','2006-04-15 12:12:04','2006-04-15 12:12:49'),(98,'Download Time Limit Error','The Download time limit has been reache for this file.',NULL,1,20,0,'wysiwyg','2006-04-25 12:32:46','2006-04-25 12:32:46'),(99,'Download Attempts Limit Error','You have already downloaded this file the alotted number of times.',NULL,1,20,0,'wysiwyg','2006-04-25 12:32:46','2006-04-25 12:32:46'),(100,'Download Icon','Download','dl.gif',1,2,0,'text or image','2006-04-25 13:59:04','2006-04-25 13:59:38'),(101,'Gift Certificate Email Header','
140Gift Certificate
141',NULL,1,21,0,'wysiwyg','2007-05-17 13:45:06','2007-05-17 13:45:06'),(102,'Gift Certificate Email Footer','Gift Certificate Footer',NULL,1,21,0,'wysiwyg','2007-05-17 13:45:06','2007-05-17 13:45:06'),(103,'Gift Certificate Email Header Plaintext','Gift Certificate Header',NULL,1,21,0,'textarea','2007-05-21 16:04:53','2007-05-21 16:05:17'),(104,'Gift Certificate Email Footer Plaintext','Gift Certificate Footer',NULL,1,21,0,'textarea','2007-05-21 16:04:53','2007-05-21 16:05:17'),(105,'What to call wishlist','Wishlist',NULL,1,22,0,'text','2007-09-24 18:13:51','2007-09-24 18:13:51'),(106,'Wishlist Instructions','
142To add items to your Wishlist, first add them to your cart, and then you can transfer them (all at once) to your Wishlist.
143
144',NULL,1,22,0,'wysiwyg','2007-09-24 18:13:51','2007-09-24 18:13:51'),(107,'Special Header','Special',NULL,1,17,0,'text','2008-02-26 16:18:30','2008-02-26 16:18:30'),(108,'Mals-e Place Order Button','Proceed to Payment','',1,8,0,'text','2009-03-13 17:17:54','2009-03-13 17:17:54'),(109,'Home Page Link Anchor Text','Home','',1,1,0,'text','2009-04-14 17:56:55','2009-04-14 17:56:55')
145Table 'cartkeeper.tbl_bound_content' doesn't exist
146
147
148Creating table: tbl_bound_content_category ...
149CREATE TABLE tbl_bound_content_category (
150 bound_content_category_id int(11) NOT NULL auto_increment,
151 bound_content_category varchar(255) NOT NULL default '',
152 description mediumtext,
153 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
154 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
155 PRIMARY KEY (bound_content_category_id)
156)
157Invalid default value for 'date_time_created'
158
159Inserting Data into: tbl_bound_content_category ...
160INSERT INTO tbl_bound_content_category (bound_content_category_id, bound_content_category, description, date_time_created, date_time_modified) VALUES (1,'Site',NULL,'2005-05-09 13:24:44','2005-05-09 13:24:44'),(2,'Invoice','Headers and footers that appear on the printable invoice page in \"My Account\"','2005-05-09 13:24:44','2005-09-26 10:21:55'),(3,'Catalog Headings','Headings on the main catalog page describing the various sections.','2005-05-09 13:24:44','2005-09-26 10:21:55'),(5,'Checkout - 1st Page','Labels and buttons that appear on the checkout page.','2005-05-09 13:24:44','2005-09-27 06:28:29'),(14,'Cart - Headers and Footers',NULL,'0000-00-00 00:00:00','2005-09-27 06:27:25'),(7,'Item Buttons and Links',NULL,'2005-05-09 13:24:44','2005-09-27 07:09:27'),(8,'Cart Button',NULL,'2005-05-09 13:24:44','2005-05-09 13:24:44'),(16,'Checkout - Order Complete Page (thank you)',NULL,'0000-00-00 00:00:00','2005-09-27 06:24:27'),(10,'Checkout - Account Buttons',NULL,'2005-05-09 13:24:44','2005-09-27 06:20:55'),(15,'Checkout - Confirmation Page',NULL,'0000-00-00 00:00:00','2005-09-27 06:24:27'),(12,'Item Messages',NULL,'2005-05-09 13:24:44','2005-09-27 06:41:32'),(13,'Checkout - Account Label',NULL,'2005-05-09 13:24:44','2005-09-27 06:20:55'),(17,'Special Pages',NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'Default Meta Info','the keywords and description that will appear if no other entries exist','2005-09-27 06:30:16','2005-09-27 06:30:16'),(19,'Item Section Labels',NULL,'2005-09-27 06:42:08','2005-09-27 06:42:08'),(20,'Error Messages',NULL,'2006-04-25 12:29:14','2006-04-25 12:33:24'),(21,'Gift Certificates','Gift Certificates','2007-05-17 13:42:57','2007-05-17 13:42:57'),(22,'Wishlist/Gift Registry','Wishlist/Gift Registry','2007-09-24 17:59:21','2007-09-24 18:00:12')
161Table 'cartkeeper.tbl_bound_content_category' doesn't exist
162
163
164Creating table: tbl_cart ...
165CREATE TABLE tbl_cart (
166 cart_id int(11) NOT NULL auto_increment,
167 session_id varchar(255) NOT NULL default '',
168 user_id int(11) NOT NULL default '0',
169 item_id int(11) NOT NULL default '0',
170 cart_item_price decimal(9,2) NOT NULL default '0.00',
171 cart_item_name varchar(255) NOT NULL default '',
172 dwall tinyint(4) default NULL,
173 wishlist_id int(11) default NULL,
174 quantity decimal(9,2) default NULL,
175 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
176 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
177 PRIMARY KEY (cart_id),
178 KEY session_id_idx (session_id),
179 KEY user_id_idx (user_id),
180 KEY item_id_idx (item_id)
181)
182Invalid default value for 'date_time_created'
183
184
185Creating table: tbl_cart_control ...
186CREATE TABLE tbl_cart_control (
187 cart_control_id int(11) NOT NULL auto_increment,
188 show_thumbnails tinyint(4) default '0',
189 cart_thumb_height int(11) default NULL,
190 cart_thumb_width int(11) default NULL,
191 hide_cart_quantity tinyint(4) default '0',
192 disable_alt_shipping tinyint(4) default '0',
193 vouchers_enabled tinyint(4) default NULL,
194 gift_certificates_enabled tinyint(4) default '0',
195 disable_billing_form tinyint(4) default '0',
196 minimum_order_amount decimal(9,2) default NULL,
197 wholesale_minimum_order_amount decimal(9,2) default NULL,
198 no_wholesale_tax tinyint(4) default NULL,
199 usps_insurance_enabled tinyint(4) default NULL,
200 usps_insurance_required tinyint(4) default NULL,
201 ups_insurance_enabled tinyint(4) default NULL,
202 ups_insurance_required tinyint(4) default NULL,
203 hide_state_province tinyint(4) default NULL,
204 default_country int(11) default NULL,
205 country_shipping tinyint(4) default NULL,
206 tax_on_shipping tinyint(4) default NULL,
207 taxable_state_determination enum('Shipping','Billing','EITHER') default NULL,
208 allowed_decimal_quantities varchar(255) default NULL,
209 cart_redirect tinyint(4) default NULL,
210 cart_ssl tinyint(4) default NULL,
211 cvvs_required tinyint(4) default NULL,
212 site_registration enum('optional','required','none') default NULL,
213 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
214 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
215 PRIMARY KEY (cart_control_id)
216)
217Invalid default value for 'date_time_created'
218
219Inserting Data into: tbl_cart_control ...
220INSERT INTO tbl_cart_control (cart_control_id, show_thumbnails, cart_thumb_height, cart_thumb_width, hide_cart_quantity, disable_alt_shipping, vouchers_enabled, gift_certificates_enabled, disable_billing_form, minimum_order_amount, wholesale_minimum_order_amount, no_wholesale_tax, usps_insurance_enabled, usps_insurance_required, ups_insurance_enabled, ups_insurance_required, hide_state_province, default_country, country_shipping, tax_on_shipping, taxable_state_determination, allowed_decimal_quantities, cart_redirect, cart_ssl, cvvs_required, site_registration, date_time_created, date_time_modified) VALUES (1,1,NULL,32,0,0,1,1,0,NULL,NULL,NULL,1,0,1,0,1,762,NULL,0,'Shipping','0',0,1,1,'optional','2004-09-20 09:35:47','2005-09-28 23:22:58')
221Table 'cartkeeper.tbl_cart_control' doesn't exist
222
223
224Creating table: tbl_cart_option ...
225CREATE TABLE tbl_cart_option (
226 cart_option_id int(11) NOT NULL auto_increment,
227 cart_id int(11) NOT NULL default '0',
228 option_id int(11) NOT NULL default '0',
229 option_attribute_id int(11) NOT NULL default '0',
230 cart_attribute_name varchar(255) default NULL,
231 cart_attribute_price decimal(9,2) NOT NULL default '0.00',
232 cart_attribute_ship decimal(9,2) NOT NULL default '0.00',
233 cart_attribute_text mediumtext,
234 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
235 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
236 PRIMARY KEY (cart_option_id),
237 KEY cart_id_idx (cart_id)
238)
239Invalid default value for 'date_time_created'
240
241
242Creating table: tbl_catalog_discount ... success!
243Creating table: tbl_category ...
244CREATE TABLE tbl_category (
245 category_id int(11) NOT NULL auto_increment,
246 parent_category_id int(11) default NULL,
247 category_name varchar(255) NOT NULL default '',
248 manufacturer_id int(11) default NULL,
249 category_graphic varchar(255) default NULL,
250 page_title varchar(255) default NULL,
251 page_keywords mediumtext,
252 page_description mediumtext,
253 short_description mediumtext,
254 short_description_2 mediumtext,
255 long_description mediumtext,
256 long_description_2 mediumtext,
257 thumbnail_image varchar(255) default NULL,
258 thumbnail_image_2 varchar(255) default NULL,
259 large_image varchar(255) default NULL,
260 large_image_2 varchar(255) default NULL,
261 nav_button varchar(255) default NULL,
262 nav_button_on varchar(255) default NULL,
263 category_sequence int(11) default NULL,
264 category_active tinyint(4) NOT NULL default '1',
265 item_columns int(11) default NULL,
266 mfg_columns int(11) default NULL,
267 number_of_items int(11) default NULL,
268 category_columns int(11) default NULL,
269 category_display_type_id int(11) default NULL,
270 discount_percentage int(11) default NULL,
271 show_manufacturers tinyint(4) default NULL,
272 discount_start_date datetime default NULL,
273 discount_expire_date datetime default NULL,
274 date_available datetime default NULL,
275 new_until datetime default NULL,
276 item_order_by_id int(11) default NULL,
277 gallery_thumbs enum('Yes','No','default') default 'default',
278 gallery_thumb_columns int(11) default NULL,
279 hide_order_button tinyint(4) default NULL,
280 hide_quantity_box tinyint(4) default NULL,
281 message mediumtext,
282 message_expire_date datetime default NULL,
283 show_message_for_item tinyint(4) default NULL,
284 category_detail_template_id int(11) default '1',
285 item_detail_template_id int(11) default '1',
286 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
287 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
288 PRIMARY KEY (category_id),
289 KEY parent_category_id (parent_category_id),
290 KEY cat_active_idx (category_active)
291)
292Invalid default value for 'date_time_created'
293
294Inserting Data into: tbl_category ...
295INSERT INTO tbl_category (category_id, parent_category_id, category_name, manufacturer_id, category_graphic, page_title, page_keywords, page_description, short_description, short_description_2, long_description, long_description_2, thumbnail_image, thumbnail_image_2, large_image, large_image_2, nav_button, nav_button_on, category_sequence, category_active, item_columns, mfg_columns, number_of_items, category_columns, category_display_type_id, discount_percentage, show_manufacturers, discount_start_date, discount_expire_date, date_available, new_until, item_order_by_id, gallery_thumbs, gallery_thumb_columns, hide_order_button, hide_quantity_box, message, message_expire_date, show_message_for_item, category_detail_template_id, item_detail_template_id, date_time_created, date_time_modified) VALUES (21,NULL,'Apparel',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3,NULL,3,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-24 17:24:39','2005-09-30 00:53:14'),(22,21,'Children',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-24 17:26:49','2005-09-24 17:26:49'),(23,21,'Infant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-24 17:29:42','2005-09-24 17:29:42'),(24,21,'Socks',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-24 17:30:23','2005-09-24 17:30:23'),(25,22,'T-Shirts',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-24 18:05:26','2005-09-24 18:05:26'),(26,22,'Shorts',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-24 18:06:52','2005-09-30 00:33:05'),(27,NULL,'Fine Art Gallery',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3,NULL,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,1,0,NULL,NULL,0,1,1,'2005-09-26 14:22:12','2005-09-30 04:18:01'),(28,NULL,'Crafts',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,4,1,NULL,1,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:37:42','2005-10-05 06:15:24'),(29,28,'Fabric',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\r\n \r\n \r\n \r\n \r\n \r\n
296\r\n
297Enter decimal values for fabric cuts.
298\r\n In example: 1 yd, .5yd, .25yd
299\r\n Prices listed below are per yard
300
301\r\n
302',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3,NULL,6,NULL,2,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:38:59','2005-09-30 03:33:02'),(30,28,'Buttons',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3,NULL,9,NULL,3,20,0,'2005-01-01 00:00:00','2007-01-01 00:00:00',NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:39:40','2005-09-30 03:27:44'),(31,28,'Stencils',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:40:04','2005-09-30 03:34:33'),(32,NULL,'Home Garden',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,9,NULL,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:40:39','2005-09-28 08:13:20'),(33,NULL,'Jewelry',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3,NULL,8,NULL,NULL,NULL,0,NULL,NULL,NULL,'2008-12-12 00:00:00',NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:41:22','2005-09-30 02:41:10'),(34,NULL,'Toys',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:41:47','2005-09-26 14:41:47'),(35,34,'Electronic',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Check out our great selection of kid electronic learning toys and gadgets. \r\n',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3,NULL,6,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:42:04','2005-09-30 03:05:57'),(36,34,'Musical Toys',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Fun instruments for your budding modern-day Mozart. \r\n',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,'2008-12-12 00:00:00',NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-26 14:42:22','2005-09-30 02:15:36'),(37,28,'Beads',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Large barrels of transparent glass, 12X9mm, made in India. \r\nIndian glass beads are suitable for your jewelry and craft projects',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3,NULL,3,NULL,4,NULL,0,NULL,NULL,NULL,NULL,3,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-27 02:24:38','2005-12-06 07:27:26'),(38,NULL,'Desktop Computers',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Computers, printers, TVs and other consumer electronics and accessories for you and your family.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3,NULL,3,3,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-29 10:59:13','2005-09-30 03:56:08'),(39,38,'Gaming Systems',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'We take your gaming experience as seriously as you do. XXX shows just how serious we are.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,1,NULL,3,30,0,'2005-09-01 00:00:00','2010-01-01 00:00:00',NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-29 11:08:03','2005-09-30 04:12:16'),(40,38,'Home Office',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Computers, printers, TVs and other consumer electronics and accessories for you and your family.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,1,NULL,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-29 11:08:57','2005-09-30 04:12:28'),(41,38,'Small Business',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Shop computers, servers, printers, TVs and other electronics to power your small business.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,1,NULL,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-29 11:09:52','2005-09-30 04:09:36'),(42,32,'Barbeque',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-30 03:58:20','2005-09-30 03:58:20'),(43,32,'Lawn Furniture',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-30 03:58:40','2005-09-30 03:58:40'),(44,32,'Lawn Tools',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2005-09-30 03:59:13','2005-09-30 04:03:42'),(45,NULL,'Gift Certificate',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,2,NULL,0,NULL,NULL,NULL,NULL,NULL,'default',NULL,0,0,NULL,NULL,0,1,1,'2007-06-06 10:26:25','2007-06-06 10:26:25')
303Table 'cartkeeper.tbl_category' doesn't exist
304
305
306Creating table: tbl_category_display_type ...
307CREATE TABLE tbl_category_display_type (
308 category_display_type_id int(11) NOT NULL auto_increment,
309 category_display_type varchar(255) NOT NULL default '',
310 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
311 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
312 PRIMARY KEY (category_display_type_id)
313)
314Invalid default value for 'date_time_created'
315
316Inserting Data into: tbl_category_display_type ...
317INSERT INTO tbl_category_display_type (category_display_type_id, category_display_type, date_time_created, date_time_modified) VALUES (1,'Thumbnails Only','2004-09-19 10:57:21','2004-10-04 17:39:09'),(2,'All Item Details','2004-09-19 10:57:26','2004-10-07 11:26:31'),(3,'Two Column Detail','2005-01-10 05:38:06','2005-01-10 05:38:06'),(4,'Tabular','2005-01-10 05:38:12','2005-01-10 05:38:12'),(5,'Multi-Add','2007-10-18 13:37:37','2007-10-18 13:37:37')
318Table 'cartkeeper.tbl_category_display_type' doesn't exist
319
320
321Creating table: tbl_category_featured_item_map ... success! Inserting Data into: tbl_category_featured_item_map ... success!
322Creating table: tbl_category_item_map ... success! Inserting Data into: tbl_category_item_map ... success!
323Creating table: tbl_category_mfg_map ... success!
324Creating table: tbl_category_template ...
325CREATE TABLE tbl_category_template (
326 category_template_id int(11) NOT NULL auto_increment,
327 template_id int(11) NOT NULL default '0',
328 category_template_name varchar(255) NOT NULL default '',
329 category_template_description varchar(255) NOT NULL default '',
330 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
331 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
332 PRIMARY KEY (category_template_id)
333)
334Invalid default value for 'date_time_created'
335
336Inserting Data into: tbl_category_template ...
337INSERT INTO tbl_category_template (category_template_id, template_id, category_template_name, category_template_description, date_time_created, date_time_modified) VALUES (1,1,'category.php','Default Category Template','2004-11-04 22:52:51','2004-11-04 22:52:51')
338Table 'cartkeeper.tbl_category_template' doesn't exist
339
340
341Creating table: tbl_cc_type ...
342CREATE TABLE tbl_cc_type (
343 cc_type_id int(11) NOT NULL auto_increment,
344 cc_name varchar(255) NOT NULL default '',
345 accepted tinyint(4) NOT NULL default '0',
346 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
347 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
348 PRIMARY KEY (cc_type_id)
349)
350Invalid default value for 'date_time_created'
351
352Inserting Data into: tbl_cc_type ...
353INSERT INTO tbl_cc_type (cc_type_id, cc_name, accepted, date_time_created, date_time_modified) VALUES (1,'Visa',1,'2004-09-02 10:22:34','2004-09-02 10:22:34'),(2,'MasterCard',1,'2004-09-02 10:22:39','2004-09-02 10:22:39'),(3,'Amex',0,'2004-09-02 10:22:51','2004-09-02 10:22:51'),(4,'Discover',0,'2004-09-02 10:22:55','2004-09-02 10:22:55')
354Table 'cartkeeper.tbl_cc_type' doesn't exist
355
356
357Creating table: tbl_checkout_question ...
358CREATE TABLE tbl_checkout_question (
359 question_id int(11) NOT NULL auto_increment,
360 question varchar(255) NOT NULL default '',
361 answer_type_id int(11) NOT NULL default '0',
362 question_sequence int(11) NOT NULL default '0',
363 required tinyint(4) default NULL,
364 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
365 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
366 PRIMARY KEY (question_id)
367)
368Invalid default value for 'date_time_created'
369
370Inserting Data into: tbl_checkout_question ...
371INSERT INTO tbl_checkout_question (question_id, question, answer_type_id, question_sequence, required, date_time_created, date_time_modified) VALUES (1,'How did you hear about us?',2,0,1,'2005-05-18 09:19:53','2005-09-30 12:37:54'),(2,'Comments:',5,0,0,'2005-09-09 10:13:00','2005-09-30 12:37:33')
372Table 'cartkeeper.tbl_checkout_question' doesn't exist
373
374
375Creating table: tbl_content ...
376CREATE TABLE tbl_content (
377 content_id int(11) NOT NULL auto_increment,
378 sequence int(11) NOT NULL default '0',
379 title varchar(255) NOT NULL default '',
380 show_title tinyint(4) NOT NULL default '1',
381 navigation tinyint(4) NOT NULL default '0',
382 page_title varchar(255) default NULL,
383 meta_keywords mediumtext,
384 meta_description mediumtext,
385 content_page mediumtext NOT NULL,
386 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
387 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
388 PRIMARY KEY (content_id)
389)
390Invalid default value for 'date_time_created'
391
392Inserting Data into: tbl_content ...
393INSERT INTO tbl_content (content_id, sequence, title, show_title, navigation, page_title, meta_keywords, meta_description, content_page, date_time_created, date_time_modified) VALUES (1,30,'Home Page',0,0,NULL,NULL,NULL,'
394\r\n
395Welcome to the Demo Shop
396\r\n
397\r\n
398\"XXX600
399\r\n\"new\" PCG01 XXX600 Gamer Bell Computers
400\r\n
401The XXX 600 is armed to the teeth
402\r\n
403$1500.00
404\r\n
405\r\n
406
407\r\nYou can edit this page in the admin!
408\r\n
409','2004-10-01 23:35:42','2005-09-30 04:27:00'),(2,0,'About Us',1,1,NULL,NULL,NULL,'Lorem ipsum (lipsum for short) is the standard placeholder text used in the publishing and graphic design industry. It is often found in demonstrations of fonts and other places where typography and layout are on display. In particular, it is often used in mock-ups of visual design projects as a text placeholder, before actual copy is inserted into the finished product. When used in this manner, it is also called greeking.
410\r\n
411Here is some Lorem ipsum:
412\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.
413\r\n
414This is some more Lorem ipsum:
415\r\nNam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.
416','2005-09-28 17:57:21','2005-09-28 21:56:46'),(3,0,'Ordering Information',1,1,NULL,NULL,NULL,'Lorem ipsum (lipsum for short) is the standard placeholder text used in the publishing and graphic design industry. It is often found in demonstrations of fonts and other places where typography and layout are on display. In particular, it is often used in mock-ups of visual design projects as a text placeholder, before actual copy is inserted into the finished product. When used in this manner, it is also called greeking.
417\r\n
418 Here is some Lorem ipsum:
419\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.
420\r\n
421 This is some more Lorem ipsum:
422\r\nNam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.','2005-09-28 17:57:35','2005-09-28 21:55:57'),(4,0,'Hours and Location',1,1,NULL,NULL,NULL,'Lorem ipsum (lipsum for short) is the standard placeholder text used in the publishing and graphic design industry. It is often found in demonstrations of fonts and other places where typography and layout are on display. In particular, it is often used in mock-ups of visual design projects as a text placeholder, before actual copy is inserted into the finished product. When used in this manner, it is also called greeking.
423\r\n
424 Here is some Lorem ipsum:
425\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat.
426\r\n
427 This is some more Lorem ipsum:
428\r\nNam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.','2005-09-28 18:01:50','2005-09-28 21:55:27'),(1000,0,'Cookies Disabled',1,0,NULL,NULL,NULL,'
429Cookies are disabled in your browser. This site uses cookies. You must have cookies enabled to add items to your shopping cart.
430','2006-04-14 16:31:38','2006-04-24 14:38:38'),(1001,0,'Site Map',1,1,NULL,NULL,NULL,'This is the site map page.
431','2006-04-24 15:03:53','2006-04-24 15:03:53')
432Table 'cartkeeper.tbl_content' doesn't exist
433
434
435Creating table: tbl_content_snippet ...
436CREATE TABLE tbl_content_snippet (
437 content_snippet_id int(11) NOT NULL auto_increment,
438 name varchar(255) NOT NULL default '',
439 content_snippet mediumtext NOT NULL,
440 show_name tinyint(4) NOT NULL default '0',
441 active tinyint(4) NOT NULL default '1',
442 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
443 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
444 PRIMARY KEY (content_snippet_id),
445 UNIQUE KEY name_uni_idx (name)
446)
447Invalid default value for 'date_time_created'
448
449Inserting Data into: tbl_content_snippet ...
450INSERT INTO tbl_content_snippet (content_snippet_id, name, content_snippet, show_name, active, date_time_created, date_time_modified) VALUES (3,'Site Top','
451The Demo Shop
452',0,1,'2004-10-01 23:33:48','2005-09-28 20:43:12'),(4,'Site Bottom','© 2005 - The Demo Shop',0,1,'2004-10-01 23:34:11','2005-09-28 20:44:07')
453Table 'cartkeeper.tbl_content_snippet' doesn't exist
454
455
456Creating table: tbl_country ...
457CREATE TABLE tbl_country (
458 country_id int(11) NOT NULL auto_increment,
459 country_name varchar(255) NOT NULL default '',
460 usps_name varchar(255) NOT NULL default '',
461 country_active tinyint(4) NOT NULL default '1',
462 country_code varchar(255) default NULL,
463 postal_code_required tinyint(4) default NULL,
464 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
465 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
466 PRIMARY KEY (country_id)
467)
468Invalid default value for 'date_time_created'
469
470Inserting Data into: tbl_country ...
471INSERT INTO tbl_country (country_id, country_name, usps_name, country_active, country_code, postal_code_required, date_time_created, date_time_modified) VALUES (13,'Albania','Albania',1,'AL',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'Algeria','Algeria',0,'DZ',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,'American Samoa','US Possession',1,'AS',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'Andorra','Andorra',0,'AD',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'Angola','Angola',0,'AO',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,'Anguilla','Anguilla',0,'AI',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,'Argentina','Argentina',0,'AR',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,'Armenia','Armenia',0,'AM',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,'Aruba','Aruba',0,'AW',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(44,'Australia','Australia',1,'AU',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,'Austria','Austria',1,'AT',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(48,'Azerbaijan','Azerbaijan',0,'AZ',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(49,'Azores','Portugal',0,'PT',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(51,'Bahamas','Bahamas',1,'BS',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(52,'Bahrain','Bahrain',0,'BH',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(58,'Bangladesh','Bangladesh',0,'BD',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(61,'Barbados','Barbados',0,'BB',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(66,'Belarus','Belarus',1,'BY',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(67,'Belgium','Belgium',1,'BE',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(68,'Belize','Belize',0,'BZ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(69,'Benin','Benin',0,'BJ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(70,'Bermuda','Bermuda',1,'BM',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(71,'Bhutan','Bhutan',0,'BT',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(74,'Bolivia','Bolivia',0,'BO',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(75,'Bonaire','Netherlands Antilles',0,'NL',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(83,'Botswana','Botswana',0,'BW',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(88,'Brazil','Brazil',1,'BR',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(98,'Bulgaria','Bulgaria',0,'BG',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(99,'Burkina Faso','Burkina Faso',0,'BF',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(101,'Burundi','Burundi',0,'BI',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(104,'Cambodia','Cambodia',0,'KH',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(105,'Cameroon','Cameroon',0,'CM',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(106,'Canada','Canada',1,'CA',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(107,'Canary Islands','Spain',0,'ES',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(111,'Cape Verde','Cape Verde',0,'CV',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(112,'Cayman Islands','Cayman Islands',0,'KY',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(113,'Central African Republic','Central African Republic',0,'CF',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(118,'Chad','Chad',0,'TD',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(125,'Chile','Chile',1,'CL',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(126,'China','China',0,'CN',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(133,'Colombia','Colombia',0,'CO',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(138,'Cook Islands','New Zealand',0,'CK',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(144,'Costa Rica','Costa Rica',1,'CR',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(149,'Croatia','Croatia',0,'HR',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(153,'Curacao','Netherlands Antilles',0,'NL',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(157,'Cyprus','Cyprus',0,'CY',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(158,'Czech Republic','Czech Republic',1,'CZ',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(167,'Denmark','Denmark',1,'DK',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(172,'Djibouti','Djibouti',0,'DJ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(177,'Dominica','Dominica',0,'DM',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(178,'Dominican Republic','Dominican Republic',0,'DO',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(185,'Ecuador','Ecuador',0,'EC',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(186,'Egypt','Egypt',0,'EG',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(189,'El Salvador','El Salvador',0,'SV',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(196,'England','Great Britain and Northern Ireland',0,'GB',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(198,'Equatorial Guinea','Equatorial Guinea',0,'GQ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(199,'Eritrea','Eritrea',0,'ER',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(200,'Estonia','Estonia',1,'EE',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(201,'Ethiopia','Ethiopia',0,'ET',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(213,'Fiji','Fiji',0,'FJ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(214,'Finland','Finland',1,'FI',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(217,'France','France',1,'FR',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(220,'French Guiana','French Guiana',0,'GF',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(223,'French Polynesia','French Polynesia',0,'PF',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(236,'Gabon','Gabon',0,'GA',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(237,'Gambia','Gambia',0,'GM',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(241,'Germany','Germany',1,'DE',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(242,'Ghana','Ghana',0,'GH',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(243,'Gibraltar','Gibraltar',0,'GI',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(254,'Greece','Greece',1,'GR',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(255,'Greenland','Greenland',0,'GL',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(256,'Grenada','Grenada',0,'GD',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(259,'Guadeloupe','Guadeloupe',0,'GP',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(260,'Guam','US Possession',1,'GU',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(261,'Guatemala','Guatemala',0,'GT',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(262,'Guernsey','Great Britain and Northern Ireland',0,'GG',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(264,'Guinea','Guinea',0,'GN',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(265,'Guinea-Bissau','Guinea-Bissau',0,'GW',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(266,'Guyana','Guyana',0,'GY',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(269,'Haiti','Haiti',0,'HT',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(276,'Holland','Netherlands',0,'NL',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(278,'Honduras','Honduras',0,'HN',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(279,'Hong Kong','Hong Kong',0,'HK',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(285,'Hungary','Hungary',1,'HU',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(286,'Iceland','Iceland',1,'IS',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(287,'India','India',0,'IN',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(288,'Indonesia','Indonesia',0,'ID',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(290,'Iraq','Iraq',0,'IQ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(291,'Ireland','Ireland',1,'IE',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(299,'Israel','Israel',0,'IL',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(301,'Italy','Italy',1,'IT',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(302,'Jamaica','Jamaica',0,'JM',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(303,'Japan','Japan',0,'JP',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(305,'Jersey','Great Britain and Northern Ireland',0,'JE',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(310,'Jordan','Jordan',0,'JO',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(322,'Kazakhstan','Kazakhstan',0,'KZ',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(329,'Kenya','Kenya',0,'KE',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(332,'Kiribati','Kiribati',0,'KI',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(341,'Kuwait','Kuwait',0,'KW',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(343,'Kyrgyzstan','Kyrgyzstan',0,'KG',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(348,'Laos','Laos',0,'LA',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(349,'Latvia','Latvia',1,'LV',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(350,'Lebanon','Lebanon',0,'LB',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(357,'Lesotho','Lesotho',0,'LS',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(358,'Liberia','Liberia',0,'LR',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(360,'Liechtenstein','Liechtenstein',1,'LI',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(361,'Lithuania','Lithuania',1,'LT',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(366,'Luxembourg','Luxembourg',0,'LU',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(368,'Macau','Macao',0,'MO',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(371,'Madagascar','Madagascar',0,'MG',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(380,'Malawi','Malawi',0,'MW',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(383,'Malaysia','Malaysia',0,'MY',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(384,'Maldives','Maldives',0,'MV',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(385,'Mali','Mali',0,'ML',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(386,'Malta','Malta',0,'MT',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(401,'Marshall Islands','US Possession',0,'MH',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(402,'Martinique','Martinique',0,'MQ',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(405,'Mauritania','Mauritania',0,'MR',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(406,'Mauritius','Mauritius',0,'MU',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(411,'Mexico','Mexico',1,'MX',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(421,'Moldova','Moldova',0,'MD',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(422,'Monaco','France',0,'MC',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(424,'Mongolia','Mongolia',0,'MN',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(425,'Montserrat','Montserrat',0,'MS',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(428,'Morocco','Morocco',0,'MA',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(429,'Mozambique','Mozambique',0,'MZ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(434,'Namibia','Namibia',0,'NA',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(441,'Nepal','Nepal',0,'NP',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(442,'Netherlands','Netherlands',1,'NL',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(443,'Netherlands Antilles','Netherlands Antilles',0,'AN',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(455,'New Caledonia','New Caledonia',0,'NC',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(464,'New Zealand','New Zealand',0,'NZ',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(467,'Nicaragua','Nicaragua',0,'NI',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(468,'Niger','Niger',0,'NE',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(469,'Nigeria','Nigeria',0,'NG',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(474,'Norfolk Island','Australia',0,'NF',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(480,'Northern Ireland','Great Britain and Northern Ireland',0,'GB',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(484,'Norway','Norway',1,'NO',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(497,'Oman','Oman',0,'OM',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(502,'Pakistan','Pakistan',0,'PK',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(503,'Palau','US Possession',0,'PW',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(507,'Panama','Panama',0,'PA',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(508,'Papua New Guinea','Papua New Guinea',0,'PG',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(509,'Paraguay','Paraguay',0,'PY',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(530,'Peru','Peru',1,'PE',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(535,'Philippines','Philippines',0,'PH',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(538,'Poland','Poland',1,'PL',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(539,'Portugal','Portugal',1,'PT',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(543,'Puerto Rico','US Possession',1,'PR',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(546,'Qatar','Qatar',0,'QA',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(568,'Reunion','Reunion',0,'RE',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(577,'Romania','Romania',0,'RO',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(579,'Russia','Russia',1,'RU',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(580,'Rwanda','Rwanda',0,'RW',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(581,'Saba','Netherlands Antilles',0,'NL',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(610,'San Marino','San Marino',0,'SM',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(620,'Saudi Arabia','Saudi Arabia',0,'SA',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(625,'Scotland','Great Britain and Northern Ireland',0,'GB',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(629,'Senegal','Senegal',0,'SN',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(631,'Seychelles','Seychelles',0,'SC',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(638,'Sierra Leone','Sierra Leone',0,'SL',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(641,'Singapore','Singapore',0,'SG',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(643,'Slovenia','Slovenia',0,'SI',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(646,'Solomon Islands','Solomon Islands',0,'SB',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(652,'South Africa','South Africa',0,'ZA',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(657,'South Korea','Korea, Republic of (South Korea)',0,'KR',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(661,'Spain','Spain',1,'ES',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(664,'Sri Lanka','Sri Lanka',0,'LK',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(665,'St. Barthelemy','Guadeloupe',0,'FR',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(670,'St. Lucia','St. Lucia',0,'LC',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(679,'Suriname','Suriname',0,'SR',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(685,'Swaziland','Swaziland',0,'SZ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(686,'Sweden','Sweden',1,'SE',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(687,'Switzerland','Switzerland',1,'CH',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(693,'Tahiti','French Polynesia',0,'FR',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(695,'Taiwan','Taiwan',0,'TW',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(696,'Tajikistan','Tajikistan',0,'TJ',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(697,'Tanzania','Tanzania',0,'TZ',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(702,'Thailand','Thailand',0,'TH',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(714,'Togo','Togo',0,'TG',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(717,'Tonga','Tonga',0,'TO',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(741,'Tunisia','Tunisia',0,'TN',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(742,'Turkey','Turkey',1,'TR',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(743,'Turkmenistan','Turkmenistan',0,'TM',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(746,'Tuvalu','Tuvalu',0,'TV',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(750,'Uganda','Uganda',0,'UG',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(751,'Ukraine','Ukraine',1,'UA',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(758,'United Arab Emirates','United Arab Emirates',0,'AE',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(759,'United Kingdom','Great Britain and Northern Ireland',1,'GB',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(762,'United States','USA',1,'US',1,'0000-00-00 00:00:00','2007-09-19 12:46:00'),(765,'Uruguay','Uruguay',0,'UY',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(766,'Uzbekistan','Uzbekistan',0,'UZ',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(767,'Vanuatu','Vanuatu',0,'VU',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(769,'Venezuela','Venezuela',0,'VE',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(772,'Vietnam','Vietnam',0,'VN',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(776,'Wales','Great Britain and Northern Ireland',0,'GB',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(785,'Western Samoa','Western Samoa',0,'WS',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(787,'Yemen','Yemen',0,'YE',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(788,'Yugoslavia','Serbia-Montenegro',0,'CS',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(794,'Zambia','Zambia',0,'ZM',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(797,'Zimbabwe','Zimbabwe',0,'ZW',0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(798,'Slovakia','Slovakia',1,'SK',0,'2009-08-22 10:26:41','2009-08-22 10:26:41')
472Table 'cartkeeper.tbl_country' doesn't exist
473
474
475Creating table: tbl_download_control ...
476CREATE TABLE tbl_download_control (
477 download_control_id int(11) NOT NULL auto_increment,
478 availability_days int(11) NOT NULL default '0',
479 number_of_downloads int(11) NOT NULL default '0',
480 auto_availability tinyint(4) NOT NULL default '0',
481 email_notify tinyint(4) NOT NULL default '0',
482 notification_email varchar(255) default NULL,
483 download_file_path varchar(255) default NULL,
484 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
485 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
486 PRIMARY KEY (download_control_id)
487)
488Invalid default value for 'date_time_created'
489
490Inserting Data into: tbl_download_control ...
491INSERT INTO tbl_download_control (download_control_id, availability_days, number_of_downloads, auto_availability, email_notify, notification_email, download_file_path, date_time_created, date_time_modified) VALUES (1,0,30,0,1,NULL,'/home/username/download_folder','2006-03-29 17:50:22','2007-10-19 12:26:06')
492Table 'cartkeeper.tbl_download_control' doesn't exist
493
494
495Creating table: tbl_download_history ...
496CREATE TABLE tbl_download_history (
497 download_history_id int(11) NOT NULL auto_increment,
498 user_id int(11) NOT NULL default '0',
499 order_id int(11) default NULL,
500 item_id int(11) NOT NULL default '0',
501 file_name varchar(255) NOT NULL default '',
502 ip_address varchar(255) NOT NULL default '',
503 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
504 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
505 PRIMARY KEY (download_history_id),
506 KEY user_id_idx (user_id)
507)
508Invalid default value for 'date_time_created'
509
510
511Creating table: tbl_froogle_control ...
512CREATE TABLE tbl_froogle_control (
513 froogle_control_id int(11) NOT NULL auto_increment,
514 froogle_server varchar(255) NOT NULL default '',
515 froogle_username varchar(255) NOT NULL default '',
516 froogle_password varchar(255) NOT NULL default '',
517 froogle_filename varchar(255) NOT NULL default '',
518 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
519 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
520 PRIMARY KEY (froogle_control_id)
521)
522Invalid default value for 'date_time_created'
523
524Inserting Data into: tbl_froogle_control ...
525INSERT INTO tbl_froogle_control (froogle_control_id, froogle_server, froogle_username, froogle_password, froogle_filename, date_time_created, date_time_modified) VALUES (1,'127.0.0.1','froogleuser','password','froogle.txt','2004-12-04 14:10:21','2005-09-30 11:02:04')
526Table 'cartkeeper.tbl_froogle_control' doesn't exist
527
528
529Creating table: tbl_gateway_control ...
530CREATE TABLE tbl_gateway_control (
531 gateway_control_id int(11) NOT NULL auto_increment,
532 payment_gateway_id int(11) default NULL,
533 anet_login varchar(255) default NULL,
534 anet_tran_key varchar(255) default NULL,
535 anet_test_param tinyint(4) default '0',
536 anet_sale_method_id int(11) default NULL,
537 anet_host varchar(255) default NULL,
538 anet_path varchar(255) default NULL,
539 anet_echeck tinyint(4) default NULL,
540 linkpoint_store_number varchar(255) default NULL,
541 linkpoint_certificate_file varchar(255) default NULL,
542 linkpoint_sale_method_id int(11) default NULL,
543 linkpoint_host varchar(255) default NULL,
544 linkpoint_port int(11) default NULL,
545 paypal_account_email varchar(255) default NULL,
546 paypal_currency enum('USD','GBP','JPY','CAD','EUR','AUD','NZD','CHF','HKD','SGD','SEK','DKK','PLN','NOK','HUF','CZK') default NULL,
547 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
548 trustcommerce_custid varchar(255) default NULL,
549 trustcommerce_password varchar(255) default NULL,
550 trustcommerce_sale_method_id int(11) default '0',
551 trustcommerce_avs tinyint(4) default '0',
552 trustcommerce_demo tinyint(4) default '0',
553 pwpp_username varchar(255) default NULL,
554 pwpp_password varchar(255) default NULL,
555 pwpp_certificate_file_path varchar(255) default NULL,
556 pwpp_payment_action enum('Sale','Authorization') default NULL,
557 pwpp_express_checkout_only tinyint(4) default NULL,
558 pwpp_express_checkout_button tinyint(4) default NULL,
559 viaklix_merchant_id varchar(255) default NULL,
560 viaklix_user_id varchar(255) default NULL,
561 viaklix_pin varchar(255) default NULL,
562 viaklix_test_mode tinyint(4) default NULL,
563 virtualmerchant tinyint(4) default NULL,
564 skipjack_serial varchar(255) default NULL,
565 skipjack_host varchar(255) default NULL,
566 fastcharge_account_id varchar(255) default NULL,
567 fastcharge_merchant_pin varchar(255) default NULL,
568 usaepay_key varchar(255) default NULL,
569 usaepay_test_mode tinyint(4) default NULL,
570 usaepay_pin varchar(255) default NULL,
571 usaepay_sale_method enum('sale','authonly') default NULL,
572 moneris_store_id varchar(255) default NULL,
573 moneris_api_token varchar(255) default NULL,
574 moneris_trans_type enum('preauth','purchase') default NULL,
575 eway_customer_id varchar(255) default NULL,
576 google_merchant_id varchar(255) default NULL,
577 google_merchant_key varchar(255) default NULL,
578 google_shipped_status_id int(11) default NULL,
579 google_email_notify tinyint(4) default NULL,
580 google_server enum('sandbox','production') default NULL,
581 google_currency enum('USD','GBP') default NULL,
582 protx_vsp_vendor_name varchar(255) default NULL,
583 protx_vsp_encryption_password varchar(255) default NULL,
584 protx_vsp_currency enum('GBP','EUR','USD') default NULL,
585 protx_vsp_connect enum('LIVE','TEST','SIMULATOR') default NULL,
586 mals_username varchar(255) default NULL,
587 mals_hostname varchar(255) default NULL,
588 pwpp_environment enum('Live','Sandbox') default NULL,
589 innovative_username varchar(255) default NULL,
590 innovative_pw varchar(255) default NULL,
591 innovative_trantype enum('sale','preauth') default NULL,
592 innovative_test_mode tinyint(4) default NULL,
593 pwpp_uk_user varchar(255) default NULL,
594 pwpp_uk_vendor varchar(255) default NULL,
595 pwpp_uk_partner varchar(255) default NULL,
596 pwpp_uk_password varchar(255) default NULL,
597 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
598 PRIMARY KEY (gateway_control_id)
599)
600Invalid default value for 'date_time_created'
601
602Inserting Data into: tbl_gateway_control ...
603INSERT INTO tbl_gateway_control (gateway_control_id, payment_gateway_id, anet_login, anet_tran_key, anet_test_param, anet_sale_method_id, anet_host, anet_path, anet_echeck, linkpoint_store_number, linkpoint_certificate_file, linkpoint_sale_method_id, linkpoint_host, linkpoint_port, paypal_account_email, paypal_currency, date_time_created, trustcommerce_custid, trustcommerce_password, trustcommerce_sale_method_id, trustcommerce_avs, trustcommerce_demo, pwpp_username, pwpp_password, pwpp_certificate_file_path, pwpp_payment_action, pwpp_express_checkout_only, pwpp_express_checkout_button, viaklix_merchant_id, viaklix_user_id, viaklix_pin, viaklix_test_mode, virtualmerchant, skipjack_serial, skipjack_host, fastcharge_account_id, fastcharge_merchant_pin, usaepay_key, usaepay_test_mode, usaepay_pin, usaepay_sale_method, moneris_store_id, moneris_api_token, moneris_trans_type, eway_customer_id, google_merchant_id, google_merchant_key, google_shipped_status_id, google_email_notify, google_server, google_currency, protx_vsp_vendor_name, protx_vsp_encryption_password, protx_vsp_currency, protx_vsp_connect, mals_username, mals_hostname, pwpp_environment, innovative_username, innovative_pw, innovative_trantype, innovative_test_mode, pwpp_uk_user, pwpp_uk_vendor, pwpp_uk_partner, pwpp_uk_password, date_time_modified) VALUES (1,1,NULL,NULL,1,1,'secure.authorize.net','/gateway/transact.dll',0,NULL,NULL,NULL,NULL,NULL,NULL,'USD','2004-12-03 12:55:10',NULL,NULL,2,0,1,NULL,NULL,NULL,'Sale',0,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0,NULL,'sale',NULL,NULL,'preauth',NULL,NULL,NULL,4,1,'sandbox','USD',NULL,NULL,'GBP','SIMULATOR',NULL,NULL,'Live','','','',0,'','','','','2008-09-16 00:00:00')
604Table 'cartkeeper.tbl_gateway_control' doesn't exist
605
606
607Creating table: tbl_gift_certificate ...
608CREATE TABLE tbl_gift_certificate (
609 gift_certificate_id int(11) NOT NULL auto_increment,
610 order_id int(11) NOT NULL default '0',
611 order_item_id int(11) NOT NULL default '0',
612 item_id int(11) NOT NULL default '0',
613 certificate_code varchar(255) NOT NULL default '',
614 certificate_active tinyint(4) default '0',
615 certificate_recipient_email varchar(255) default NULL,
616 certificate_recipient_name varchar(255) default NULL,
617 certificate_message mediumtext,
618 purchaser_email varchar(255) default NULL,
619 purchaser_name varchar(255) default NULL,
620 initial_certificate_amount decimal(9,2) NOT NULL default '0.00',
621 current_certificate_amount decimal(9,2) NOT NULL default '0.00',
622 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
623 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
624 PRIMARY KEY (gift_certificate_id),
625 UNIQUE KEY certificate_code (certificate_code),
626 KEY order_id_idx (order_id)
627)
628Invalid default value for 'date_time_created'
629
630
631Creating table: tbl_global_option ...
632CREATE TABLE tbl_global_option (
633 global_option_id int(11) NOT NULL auto_increment,
634 global_option_sequence int(11) default NULL,
635 option_type_id int(11) NOT NULL default '0',
636 global_option_name varchar(255) NOT NULL default '',
637 global_option_required tinyint(4) default '0',
638 global_option_description mediumtext,
639 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
640 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
641 PRIMARY KEY (global_option_id)
642)
643Invalid default value for 'date_time_created'
644
645Inserting Data into: tbl_global_option ...
646INSERT INTO tbl_global_option (global_option_id, global_option_sequence, option_type_id, global_option_name, global_option_required, global_option_description, date_time_created, date_time_modified) VALUES (1,1,1,'Color',0,NULL,'2005-01-21 02:15:05','2005-01-21 02:15:05'),(2,2,1,'Size',0,NULL,'2005-01-24 01:19:38','2005-01-24 01:19:38'),(3,10,1,'Extras',0,NULL,'2005-07-11 07:27:12','2005-07-11 07:27:12'),(4,1,1,'Children Denim Shorts Boys',0,NULL,'2005-09-25 12:02:08','2005-09-25 12:02:08'),(5,1,1,'Jacket Size',0,NULL,'2005-09-25 12:58:57','2005-09-25 12:58:57'),(6,1,1,'Shoe Size',0,NULL,'2005-09-25 14:34:51','2005-09-25 14:34:51'),(7,1,2,'Sock Size',0,NULL,'2005-09-26 13:27:48','2005-09-26 13:27:48'),(8,1,1,'Sock Colors',0,NULL,'2005-09-26 13:29:26','2005-09-26 13:29:26'),(9,1,3,'Shirt Size',0,NULL,'2005-09-26 14:04:08','2005-09-26 14:04:08'),(10,1,1,'Ring Size',0,NULL,'2005-09-26 15:41:56','2005-09-26 15:41:56'),(11,1,1,'Button Size',0,NULL,'2005-09-26 16:31:21','2005-09-26 16:31:21'),(12,1,1,'PC Display Type',0,NULL,'2005-09-29 11:17:48','2005-09-29 11:17:48'),(13,2,3,'PC Extras',0,NULL,'2005-09-29 11:19:41','2005-09-29 11:19:41'),(14,3,2,'PC Warrenty',1,NULL,'2005-09-29 11:20:34','2005-09-30 01:00:03')
647Table 'cartkeeper.tbl_global_option' doesn't exist
648
649
650Creating table: tbl_global_option_attribute ...
651CREATE TABLE tbl_global_option_attribute (
652 global_option_attribute_id int(11) NOT NULL auto_increment,
653 global_option_id int(11) NOT NULL default '0',
654 global_attribute_name varchar(255) NOT NULL default '',
655 global_attribute_price decimal(9,2) NOT NULL default '0.00',
656 global_attribute_ship decimal(9,2) default NULL,
657 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
658 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
659 PRIMARY KEY (global_option_attribute_id),
660 KEY attr_idx (global_option_id)
661)
662Invalid default value for 'date_time_created'
663
664Inserting Data into: tbl_global_option_attribute ...
665INSERT INTO tbl_global_option_attribute (global_option_attribute_id, global_option_id, global_attribute_name, global_attribute_price, global_attribute_ship, date_time_created, date_time_modified) VALUES (1,1,'Black','0.00','0.00','2005-01-21 02:15:05','2005-09-24 21:59:21'),(2,1,'Red','0.00','0.00','2005-01-21 02:15:05','2005-09-24 21:59:21'),(3,1,'Blue','0.00','0.00','2005-01-21 02:15:05','2005-09-24 21:59:21'),(4,2,'Small','0.00','0.00','2005-01-24 01:19:38','2005-09-24 22:01:07'),(5,2,'Med','0.00','0.00','2005-01-24 01:19:38','2005-09-24 22:01:07'),(6,2,'Large','0.00','0.00','2005-01-24 01:19:38','2005-09-24 22:01:07'),(7,1,'Green','0.00','0.00','2005-04-18 16:04:58','2005-09-24 21:59:21'),(23,4,'Boys Husky Age 8-18','5.00','0.00','2005-09-25 12:02:08','2005-09-25 12:02:08'),(22,4,'Boys Husky Age 4-7','4.00','0.00','2005-09-25 12:02:08','2005-09-25 12:02:08'),(21,4,'Boys Slim Age 8-18','3.00','0.00','2005-09-25 12:02:08','2005-09-25 12:02:08'),(20,4,'Boys Slim Age 4-7','2.00','0.00','2005-09-25 12:02:08','2005-09-25 12:02:08'),(16,3,'this','1.00','0.00','2005-07-11 07:27:12','2005-07-11 07:27:12'),(17,3,'that','2.00','0.00','2005-07-11 07:27:12','2005-07-11 07:27:12'),(18,3,'theother','3.00','0.00','2005-07-11 07:27:12','2005-07-11 07:27:12'),(19,2,'XLarge','0.00','0.00','2005-09-24 18:39:28','2005-09-24 22:01:07'),(24,5,'12 Months','0.00','0.00','2005-09-25 12:58:57','2005-09-25 12:59:08'),(25,5,'18 Months','0.00','0.00','2005-09-25 12:58:57','2005-09-25 12:59:08'),(26,5,'2 Years','0.00','0.00','2005-09-25 12:58:57','2005-09-25 12:59:08'),(27,5,'3 Years','0.00','0.00','2005-09-25 12:58:57','2005-09-25 12:59:08'),(28,5,'4 Years','0.00','0.00','2005-09-25 12:58:57','2005-09-25 12:59:08'),(29,6,'S (Fits 12-13)','0.00','0.00','2005-09-25 14:34:51','2005-09-25 14:34:51'),(30,6,'M (Fits 1-2)','0.00','0.00','2005-09-25 14:34:51','2005-09-25 14:34:51'),(31,6,'L (Fits 3-4)','0.00','0.00','2005-09-25 14:34:51','2005-09-25 14:34:51'),(32,6,'XL (Fits 5-6)','0.00','0.00','2005-09-25 14:34:51','2005-09-25 14:34:51'),(33,7,'Toddler','0.00','0.00','2005-09-26 13:27:48','2005-09-26 13:28:16'),(34,7,'Childrens','0.00','0.00','2005-09-26 13:27:48','2005-09-26 13:28:16'),(35,7,'Womens','1.00','0.00','2005-09-26 13:27:48','2005-09-26 13:28:16'),(36,7,'Mens','2.00','0.00','2005-09-26 13:27:48','2005-09-26 13:28:16'),(37,8,'Red','0.00','0.00','2005-09-26 13:29:26','2005-09-26 13:29:52'),(38,8,'Blue','0.00','0.00','2005-09-26 13:29:26','2005-09-26 13:29:52'),(39,8,'White','0.00','0.00','2005-09-26 13:29:26','2005-09-26 13:29:52'),(40,8,'Black','0.00','0.00','2005-09-26 13:29:26','2005-09-26 13:29:52'),(41,8,'Yellow','0.00','0.00','2005-09-26 13:29:26','2005-09-26 13:29:52'),(42,8,'Pink','0.00','0.00','2005-09-26 13:29:52','2005-09-26 13:29:52'),(43,8,'Grey','0.00','0.00','2005-09-26 13:29:52','2005-09-26 13:29:52'),(44,9,'Small','0.00','0.00','2005-09-26 14:04:08','2005-09-26 14:04:24'),(45,9,'Medium','0.00','0.00','2005-09-26 14:04:08','2005-09-26 14:04:24'),(46,9,'Large','0.00','0.00','2005-09-26 14:04:08','2005-09-26 14:04:24'),(47,9,'X-Large','0.00','0.00','2005-09-26 14:04:08','2005-09-26 14:04:24'),(48,9,'XX-Large','1.00','0.00','2005-09-26 14:04:08','2005-09-26 14:04:24'),(49,10,'Small','0.00','0.00','2005-09-26 15:41:56','2005-09-26 15:41:56'),(50,10,'Medium','0.00','0.00','2005-09-26 15:41:56','2005-09-26 15:41:56'),(51,10,'Large','0.00','0.00','2005-09-26 15:41:56','2005-09-26 15:41:56'),(52,10,'X-Large Add','20.00','0.00','2005-09-26 15:41:56','2005-09-26 15:41:56'),(53,11,'1 3/16in','1.25','0.00','2005-09-26 16:31:21','2005-09-26 16:32:31'),(54,11,'1 1/8in','1.15','0.00','2005-09-26 16:31:21','2005-09-26 16:32:31'),(55,11,'1in','1.00','0.00','2005-09-26 16:31:21','2005-09-26 16:32:31'),(56,11,'7/8in','0.90','0.00','2005-09-26 16:31:21','2005-09-26 16:32:31'),(57,11,'3/4in','0.80','0.00','2005-09-26 16:31:21','2005-09-26 16:32:31'),(58,11,'5/8in','0.70','0.00','2005-09-26 16:32:31','2005-09-26 16:32:31'),(59,11,'1/2in','0.60','0.00','2005-09-26 16:32:31','2005-09-26 16:32:31'),(60,11,'7/16in','0.50','0.00','2005-09-26 16:32:31','2005-09-26 16:32:31'),(61,11,'3/8in','0.40','0.00','2005-09-26 16:32:31','2005-09-26 16:32:31'),(62,12,'15 Inch Flat Panel','0.00','80.00','2005-09-29 11:17:48','2005-09-30 13:05:03'),(63,12,'17 Inch Flat Panel','25.00','96.00','2005-09-29 11:17:48','2005-09-30 13:05:03'),(64,12,'19 Inch Flat Panel','75.00','112.00','2005-09-29 11:17:48','2005-09-30 13:05:03'),(65,12,'21 Inch Flat Panel','150.00','128.00','2005-09-29 11:17:48','2005-09-30 13:05:03'),(66,13,'3 Button Optical Mouse','5.00','16.00','2005-09-29 11:19:41','2005-09-30 13:13:52'),(67,13,'250 Button Keyboard','10.00','32.00','2005-09-29 11:19:41','2005-09-30 13:13:52'),(68,13,'Display Stand with Drawer','15.00','64.00','2005-09-29 11:19:41','2005-09-30 13:13:52'),(69,14,'1 Year Warrenty','25.00','0.00','2005-09-29 11:20:34','2005-09-30 01:00:03'),(70,14,'2 Year Warrenty','50.00','0.00','2005-09-29 11:20:34','2005-09-30 01:00:03'),(71,14,'3 Year Warrenty','75.00','0.00','2005-09-29 11:20:34','2005-09-30 01:00:03')
666Table 'cartkeeper.tbl_global_option_attribute' doesn't exist
667
668
669Creating table: tbl_home_page ... success! Inserting Data into: tbl_home_page ... success!
670Creating table: tbl_home_page_behavior ...
671CREATE TABLE tbl_home_page_behavior (
672 behavior_id int(11) NOT NULL auto_increment,
673 behavior_description varchar(255) NOT NULL default '',
674 query_string varchar(255) NOT NULL default '',
675 date_time_modified datetime default NULL,
676 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
677 PRIMARY KEY (behavior_id)
678)
679Invalid default value for 'date_time_created'
680
681Inserting Data into: tbl_home_page_behavior ...
682INSERT INTO tbl_home_page_behavior (behavior_id, behavior_description, query_string, date_time_modified, date_time_created) VALUES (1,'Home','','2004-09-29 06:18:06','2004-09-29 06:18:06'),(2,'Sale Items','','2004-09-29 06:19:04','2004-09-29 06:19:04'),(3,'New Items','','2004-09-29 06:20:01','2004-09-29 06:20:01'),(4,'All Items','','2004-09-29 06:20:11','2004-09-29 06:20:11'),(5,'Home Page Sections','',NULL,'0000-00-00 00:00:00')
683Table 'cartkeeper.tbl_home_page_behavior' doesn't exist
684
685
686Creating table: tbl_home_page_featured_item_map ... success! Inserting Data into: tbl_home_page_featured_item_map ... success!
687Creating table: tbl_item ...
688CREATE TABLE tbl_item (
689 item_id int(11) NOT NULL auto_increment,
690 category_id int(11) NOT NULL default '0',
691 manufacturer_id int(11) default NULL,
692 item_name varchar(255) NOT NULL default '',
693 page_title varchar(255) default NULL,
694 meta_description mediumtext,
695 meta_keywords mediumtext,
696 downloadable_file varchar(255) default NULL,
697 f_condition varchar(255) default 'new',
698 gift_certificate tinyint(4) default '0',
699 qty_discount_type enum('None','Dollar Off','Percentage') default NULL,
700 short_description mediumtext,
701 short_description_2 varchar(255) default NULL,
702 long_description mediumtext,
703 long_description_2 mediumtext,
704 thumbnail_image varchar(255) default NULL,
705 thumbnail_image_2 varchar(255) default NULL,
706 large_image varchar(255) default NULL,
707 large_image_2 varchar(255) default NULL,
708 price decimal(9,2) default NULL,
709 list_price decimal(9,2) default NULL,
710 sale_price decimal(9,2) default NULL,
711 taxable tinyint(4) default '1',
712 sale_price_start_date datetime default NULL,
713 sale_price_expire_date datetime default NULL,
714 wholesale_discount int(11) default NULL,
715 minimum_quantity decimal(9,2) default NULL,
716 wholesale_minimum_quantity decimal(9,2) default NULL,
717 unit_label varchar(255) default NULL,
718 item_active tinyint(4) NOT NULL default '1',
719 item_sequence int(11) default NULL,
720 manufacturer_code varchar(255) default NULL,
721 upc varchar(255) default NULL,
722 isbn varchar(255) default NULL,
723 catalog_code varchar(255) default NULL,
724 number_available decimal(7,2) default NULL,
725 out_of_stock tinyint(4) default '0',
726 date_available datetime default NULL,
727 hide_order_button tinyint(4) default '0',
728 hide_quantity_box tinyint(4) default NULL,
729 gallery_thumbs enum('Yes','No','default') default 'default',
730 gallery_thumb_columns int(11) default NULL,
731 item_template_id int(11) default NULL,
732 item_detail_template_id int(11) default NULL,
733 item_message varchar(255) default NULL,
734 message_expire_date datetime default NULL,
735 free_shipping tinyint(4) default '0',
736 weight decimal(8,2) default NULL,
737 weight_units varchar(255) default NULL,
738 ship_cost decimal(9,2) default NULL,
739 volume decimal(8,2) default NULL,
740 volume_unit varchar(255) default NULL,
741 new_until datetime default NULL,
742 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
743 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
744 low_stock_threshold int(11) default '5',
745 PRIMARY KEY (item_id),
746 KEY category_id_idx (category_id),
747 KEY manufacturer_id (manufacturer_id),
748 KEY active_idx (item_active)
749)
750Invalid default value for 'date_time_created'
751
752Inserting Data into: tbl_item ...
753INSERT INTO tbl_item (item_id, category_id, manufacturer_id, item_name, page_title, meta_description, meta_keywords, downloadable_file, f_condition, gift_certificate, qty_discount_type, short_description, short_description_2, long_description, long_description_2, thumbnail_image, thumbnail_image_2, large_image, large_image_2, price, list_price, sale_price, taxable, sale_price_start_date, sale_price_expire_date, wholesale_discount, minimum_quantity, wholesale_minimum_quantity, unit_label, item_active, item_sequence, manufacturer_code, catalog_code, number_available, out_of_stock, date_available, hide_order_button, hide_quantity_box, gallery_thumbs, gallery_thumb_columns, item_template_id, item_detail_template_id, item_message, message_expire_date, free_shipping, weight, weight_units, ship_cost, volume, volume_unit, new_until, date_time_created, date_time_modified, low_stock_threshold) VALUES (133,26,30,'Denim Shorts',NULL,NULL,'Denim,Shorts,Cotton shorts',NULL,'new',0,NULL,'Denim Shorts',NULL,'Front and back pockets. Cotton. Preschool sizes have elastic backwaist and are made in USA or imported of domestic or imported materials; other sizes are imported. Washable. 1 lb. ',NULL,'thumb.gif',NULL,'large.gif',NULL,'5.99',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'CHI03','14.00',0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'8.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-25 11:57:09','2005-10-05 03:46:36',5),(135,23,32,'Toddler Boys\' Warm-Up Parka',NULL,NULL,NULL,NULL,'new',0,NULL,'Toddler Boys\' Warm-Up Parka',NULL,'A great value, this parka is made of nylon treated with Teflon for water and stain resistance. Body and hood lined with polyester fleece, sleeves have lightweight polyester fill insulation. Knit cuffs, owner ID label, reflective back triangle. No pockets on size 12 Months and 18 Months. Imported. Machine wash and dry.',NULL,'thumb.gif',NULL,'large.gif',NULL,'55.00',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'INF01',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'32.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-25 12:48:34','2005-10-05 03:51:24',5),(136,23,32,'Toddlers\' Fleece Hat and Mittens Set',NULL,NULL,NULL,NULL,'new',0,NULL,'Toddlers\' Fleece Hat and Mittens Set',NULL,'Plush, warm polyester fleece. Cozy earflaps fasten with Velcro-closure under chin. Easy-on mittens secure with elasticized wrist. Imported. Machine wash and dry. \r\nLimited Quantities for this item',NULL,'thumb.gif',NULL,'large.gif',NULL,'10.00',NULL,'9.00',1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'INF02',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'16.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-25 13:19:09','2005-10-05 03:51:28',5),(138,23,32,'Toddlers\' Fleece Slippers','Toddlers\' Fleece Slippers',NULL,NULL,NULL,'new',0,NULL,'Toddlers\' Fleece Slippers',NULL,'A new style in slippers. Double-layer polyester fleece is warm and tough. Suede bottom. Lined with foam for extra comfort. Imported.',NULL,'thumb.gif',NULL,'large.gif',NULL,'22.00',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'INF03',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'8.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-25 13:53:43','2005-10-05 03:51:32',5),(142,24,32,'Fuzzy Glitter Slippers',NULL,NULL,NULL,NULL,'new',0,NULL,'Fuzzy Glitter Slippers',NULL,'Polyester with skid-free sole. Do not wash. Imported.',NULL,'thumb.gif',NULL,'large.gif',NULL,'5.99',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'INF07',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'8.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-25 14:37:33','2005-10-05 03:48:45',5),(143,22,31,'Long-Sleeve Cotton Knit Shirt',NULL,NULL,NULL,NULL,'new',0,NULL,'Long-Sleeve Cotton Knit Pajamas',NULL,'You\'ll be the hit of the party in your adorable and whimsical fun print shirt. Ribbed crewneck and cuffs. Elastic waist. Snug-fitting cotton.* Washable.',NULL,'thumb.gif',NULL,'large.gif',NULL,'12.99',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'CHI02',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'8.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-25 14:56:28','2005-10-05 04:03:59',5),(144,22,NULL,'Sleeping Bag',NULL,NULL,NULL,NULL,'new',0,NULL,'Sleeping Bag',NULL,'Self-adhesive backpack opens up to a full-size sleeping bag. 21x18 1/2x20 1/2\". Polyester shell and fill. Cotton lining. Machine wash, line dry.','This warm sleeping bag is sure to be a hit at the next sleep over party.
754','thumb.gif',NULL,'large.gif',NULL,'14.99',NULL,'12.99',1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'CHI04',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'32.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-25 14:59:32','2005-10-05 03:52:53',5),(145,24,NULL,'Crew Socks',NULL,NULL,NULL,NULL,'new',0,'Dollar Off','Everyday wool crew sock',NULL,'Everyday wool crew sock for everyday use with an integrated Olefin liner for the ultimate in dry-lined comfort. Because the liner is fully integrated with the outer fabric, we are able to achieve enough \"give\" in the sock to reduce friction and are able to increase the effective moisture movement properties of the fabric. 1x1 true rib top. 3x1 mock rib leg. Lightweight jersey sole. Ultra smooth lin-toe closure. Content: Outer Layer: 100% Olefin - Inner Layer: 38% Merino Wool, 38% Stretch Nylon, 18% 4-Channel Polyester, 6% Spandex',NULL,'thumb.gif',NULL,'large.gif',NULL,'5.99',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'SSC01',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,0,'2.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 13:23:01','2008-02-19 10:09:59',5),(146,24,33,'Ski Socks',NULL,NULL,NULL,NULL,'new',0,'None','Ski Socks',NULL,'Heel - High-density pad cushions ankles, reduces heel slippage. Shin - Medium-density pad takes the bang out of the bumps, protects against bruises and abrasion. Ball/Over Toe - High-density pad cushions ball, provides warmth and protects toes. Side Panels - Flat knit side panel reduces compression on the foot, enhances moisture ventilation. Content: 27% wool, 27% silk, 27% acrylic, 16% stretch nylon, 3% spandex ',NULL,'thumb.gif',NULL,'large.gif',NULL,'10.00',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'SSC02','1.00',0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,0,'8.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 13:34:27','2008-03-17 11:34:06',5),(147,25,33,'Spiderman Screened T-Shirt',NULL,NULL,NULL,NULL,'new',0,NULL,'From Marvel, Spidey Shirts',NULL,'From Marvel. Spidey spins into action! Screen-printed crewneck tee of 100% cotton. Washable. Imported of domestic fabric.',NULL,'thumb.gif',NULL,'large.gif',NULL,'12.99',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'CHI05',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'8.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 14:08:57','2005-10-05 04:03:34',5),(148,27,NULL,'Cinderella',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,'large.gif',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'AG01',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'3.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 14:30:56','2005-09-30 12:57:07',5),(149,27,NULL,'Morning',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,'large.gif',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'AG02',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'64.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 14:30:56','2005-09-30 12:57:07',5),(150,27,NULL,'Mountain Ecstasy',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,'large.gif',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'AG03',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'64.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 14:30:56','2005-09-30 12:57:07',5),(154,33,NULL,'10kt Dangle Dolphin Ring',NULL,NULL,NULL,NULL,'new',0,NULL,'She\'ll flip for this!',NULL,NULL,NULL,'thumb.gif',NULL,'large.gif',NULL,'16.97',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'JE01',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'3.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 14:55:57','2005-09-30 12:57:07',5),(156,33,NULL,'Black Hills Gold on Sterling Silver Men\'s Eagle Ring',NULL,NULL,NULL,NULL,'new',0,NULL,'A carved eagle with diamond-cut wings \r\n',NULL,'
755A carved eagle with diamond-cut wings enhances the open center of this handsome, sterling silver ring. Rose gold and green gold leaves adorn the sides of the ring.
756
757\r\n
758\r\n
759\r\n
760Sterling silver with 12kt rose gold and green gold leaves
761\r\n
762\r\n
763\r\n
764Sterling silver eagle with diamond-cut wings
765\r\n
766\r\n
767\r\n
768Available in size 10
769\r\n
770\r\n
771\r\n
772Handcrafted in the Black Hills of South Dakota
773\r\n
774\r\n
775',NULL,'thumb.gif',NULL,'large.gif',NULL,'59.97',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'JE03',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'3.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 14:55:57','2005-09-30 12:57:07',5),(157,33,NULL,'Tri-Color Rolling Ring',NULL,NULL,NULL,NULL,'new',0,NULL,'This piece of jewelry has an extra touch',NULL,'
776This piece of jewelry has an extra touch of flair-- three different-colored gold rings interlock to form one ring.
777
778\r\n
779\r\n
780\r\n
781\r\n
78210kt gold
783\r\n
784\r\n
785\r\n
786Yellow gold, white gold and pink gold bands
787\r\n
788\r\n
789\r\n
790Polished finish
791\r\n
792\r\n
793\r\n
794Rolling-ring design
795\r\n
796\r\n
797\r\n
798Available in size 7
799\r\n
800\r\n
801\r\n
802',NULL,'thumb.gif',NULL,'large.gif',NULL,'59.97',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'JE04',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'3.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 14:55:57','2005-09-30 12:57:07',5),(170,30,NULL,'Aqua Button',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'006bt',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'1.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 16:47:15','2005-09-30 12:57:07',5),(173,30,34,'Hot Pink Button',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,50,NULL,NULL,NULL,1,NULL,NULL,'002bt',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'1.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 16:47:15','2005-09-30 11:30:14',5),(175,30,34,'Pink Button',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'003bt','0.00',0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'1.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 16:47:15','2005-09-30 11:30:34',5),(177,30,NULL,'Royal Button',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'007abt',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'1.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 16:49:59','2005-09-30 11:32:38',5),(182,29,39,'BG-Print',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,'large.gif',NULL,'8.95',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'Yards',1,NULL,NULL,'FAB04',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'64.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 22:41:29','2005-09-30 11:21:49',5),(183,29,39,'BG-Print',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,'large.gif',NULL,'8.95',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'Yards',1,NULL,NULL,'FAB05',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'64.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 22:42:09','2005-09-30 11:17:44',5),(184,29,39,'BG-Print',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,NULL,NULL,'thumb.gif',NULL,'large.gif',NULL,'8.95',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'Yards',1,NULL,NULL,'FAB06',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'64.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 22:42:55','2005-09-30 11:18:33',5),(185,31,NULL,'Blue Jay',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,'Because of its large size, blue coloration and crest the Blue Jay is quite distinctive.',NULL,'thumb.gif',NULL,'large.gif',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'ST01',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'16.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 22:53:23','2005-09-30 11:19:24',5),(186,31,NULL,'Lark',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,'The Lark Bunting is a migrant bird. Flocks arrive in April and inhabit the plains regions and areas up to 8,000 feet in elevation.',NULL,'thumb.gif',NULL,'large.gif',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'ST02',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'16.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-26 23:00:28','2005-09-30 11:32:48',5),(187,44,NULL,'150-Foot Hose Reel Cart',NULL,NULL,NULL,NULL,'new',0,NULL,'150-Foot Hose Reel Cart',NULL,'
803\r\n
804\r\n
805Quick-connect system for easy faucet attachment
806\r\n
807\r\n
808\r\n
809Double O-rings help prevent leaks
810\r\n
811\r\n
812\r\n
8134-foot leader hose
814\r\n
815\r\n
816\r\n
8178-inch wheels
818\r\n
819\r\n
820\r\n
821Cart is 16-inches tall
822\r\n
823\r\n
824\r\n
825Reel is 9-7/8-inches in diameter
826\r\n
827\r\n
828',NULL,'thumb.gif',NULL,'large.gif',NULL,'24.93',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'HG7',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'320.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 00:24:10','2005-09-30 13:07:06',5),(188,43,NULL,'61-inch Oil Lamp',NULL,NULL,NULL,NULL,'new',0,NULL,'Add indirect light to your patio with this stylish bronze-colored torchere.',NULL,'Add indirect light to your patio with this stylish bronze-colored torchere.\r\n
829\r\n
830Copper container and wick
831\r\n
832Cast-iron base for stability
833\r\n
834\r\n',NULL,'thumb.gif',NULL,'large.gif',NULL,'33.78',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'HG5',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'32.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 00:30:50','2005-09-30 13:10:08',5),(190,42,NULL,'Char-Broil American Gourmet Grill',NULL,NULL,NULL,NULL,'new',0,NULL,'Char-Broil American Gourmet Grill\r\n',NULL,'With 738 square inches of cooking surface, you can barbeque for a hungry crowd without taking up much space on your patio or deck.\r\n
835\r\n
836\r\n
837Offset firebox design
838\r\n
839\r\n
840\r\n
841Heavy-duty steel construction
842\r\n
843\r\n
844\r\n
845Durable, heat-resistant powder coat finish
846\r\n
847\r\n
848\r\n
849Porcelain-coated cooking grates
850\r\n
851\r\n
852\r\n
853Dual air damper system to control heat and smoke
854\r\n
855\r\n
856\r\n
857Convenient access door for tending the fire
858\r\n
859\r\n
860\r\n
861Warming plate
862\r\n
863\r\n
864\r\n
865Convenient front shelf
866\r\n
867\r\n
868\r\n',NULL,'thumb.gif',NULL,'large.gif',NULL,'79.96',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'HG3',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'480.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 00:39:54','2005-09-30 13:09:35',5),(191,43,NULL,'Claymore 3-Piece Swivel Rocker Set',NULL,NULL,NULL,NULL,'new',0,NULL,'Claymore 3-Piece Swivel Rocker Set',NULL,'Relax in these cushioned chairs as you enjoy refreshments or meals at the matching table.\r\n
869\r\n
870\r\n
871Easy-care, spun polyester cushions made for full-time outdoor use
872\r\n
873\r\n
874\r\n
875Adjustable table height
876\r\n
877\r\n
878\r\n
879Table measures 20 inches in diameter
880\r\n
881\r\n
882\r\n
883Table surface made of wavy tempered glass
884\r\n
885\r\n
886\r\n
8871-year warranty
888\r\n
889\r\n
890\r\n',NULL,'thumb.gif',NULL,'large.gif',NULL,'199.97',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'HG4',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'480.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 00:50:25','2005-09-30 13:10:46',5),(192,42,NULL,'Coleman Outdoor Fireplace',NULL,NULL,NULL,NULL,'new',0,NULL,'Coleman Outdoor Fireplace',NULL,'This outdoor fireplace and grill from Coleman provides extra warmth and comfort on chilly evenings. It\'s great for grilling, too.\r\n
891\r\n
892\r\n
893Heavy-duty, warp-resistant grate is sturdily built to support wood logs
894\r\n
895\r\n
896\r\n
897Hinged doors make adding wood easy
898\r\n
899\r\n
900\r\n
901Weather-resistant porcelainized lid and base
902\r\n
903\r\n
904\r\n
905Folds into a single, easy-to-carry portable unit
906\r\n
907\r\n
908\r\n
909Assembled size is 16-1/2\"D x 27-1/2\"W x 35\"H
910\r\n
911\r\n
912\r\n',NULL,'thumb.gif',NULL,'large.gif',NULL,'78.34',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'HG2',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'480.00',NULL,'0.00',NULL,NULL,'2008-12-12 00:00:00','2005-09-27 00:56:55','2005-09-30 13:09:07',5),(193,44,NULL,' Gilmour Metal Oscillating Sprinkler',NULL,NULL,NULL,NULL,'new',0,NULL,'Gilmour Metal Oscillating Sprinkler',NULL,'This oscillating sprinkler easily attaches to your garden hose, so you can place it anywhere in the garden or on your lawn.\r\n
913\r\n
914\r\n
915Covers up to 3,600 square feet
916\r\n
917\r\n
918\r\n
919Heavy-duty zinc, one-piece, die-cast construction
920\r\n
921\r\n
922\r\n
92319 solid-brass spray jets set into aluminum spray tube
924\r\n
925\r\n
926\r\n
927Quiet, state-of-the-art turbine-drive motor
928\r\n
929\r\n
930\r\n
931Width-adjusting levers for changing side-to-side coverage
932\r\n
933\r\n
934\r\n',NULL,'thumb.gif',NULL,'large.gif',NULL,'29.93',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'HG8',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'32.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 01:13:36','2005-09-30 13:07:30',5),(194,42,NULL,'Uniflame Gas Grill',NULL,NULL,NULL,NULL,'new',0,NULL,'Uniflame Gas Grill',NULL,'This family-size, stainless steel/steel model features powerful 40,000-BTU cast-iron burners and an 8,000-BTU side burner.\r\n
935\r\n
936\r\n
937Total cooking area of 543 square inches, including a warming rack
938\r\n
939\r\n
940\r\n
9414 independently controlled cast iron burners
942\r\n
943\r\n
944\r\n
945Side shelf for added food preparation area
946\r\n
947\r\n
948\r\n
9498,000-BTU side burner
950\r\n
951\r\n
952\r\n
953Bottom cabinet with storage racks
954\r\n
955\r\n
956\r\n
957Easy assembly with no tools required
958\r\n
959\r\n
960\r\n
961Liquid propane cylinder sold separately
962\r\n
963\r\n
964\r\n
9651-year warranty
966\r\n
967\r\n
968\r\n
969Certified by CSA
970\r\n
971\r\n
972\r\n
973For outdoor use only
974\r\n
975\r\n
976\r\n',NULL,'thumb.gif',NULL,'large.gif',NULL,'248.00',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'HG1',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'960.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 01:18:27','2005-09-30 10:45:36',5),(195,35,NULL,'LeapFrog Turbo Twist Spelling With Mind Station',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,'
977Become a spelling bee pro! The LeapFrog Turbo Twist Spelling teaches core spelling words for grades 1 through 6 with fun games, animations and sound effects. Create and download your own school spelling test lists from our Merriam-Webster database using the Mind Station Connector.
978\r\n
979\r\n
980\r\n
981\r\n
982Twist and turn as you learn core spelling words and rules.
983\r\n
984\r\n
985\r\n
986Comes with 5 fun-filled games, including multi-player to challenge your friends
987\r\n
988\r\n
989\r\n
990Adjusts automatically to each player\'s skill level
991\r\n
992\r\n
993\r\n
994Approved by edcational experts
995\r\n
996\r\n
997\r\n
998Two ways to expand the learning fun are to upgrate with a Turbo Twist Spelling cartridge to add over 1,000 new words based on your grade
999\r\n
1000\r\n
1001\r\n
1002You can also download custom spelling lists and additional activity packs with the Mind Station and a membership to the LeapFrog Never-Ending Leanring Club
1003\r\n
1004\r\n
1005\r\n
1006The Mind Station connector plugs right into your computer\'s serial port for hours of learning fun
1007\r\n
1008\r\n
1009\r\n
1010',NULL,'thumb.gif',NULL,'large.gif',NULL,'49.88',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'TOY3',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'32.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 01:28:07','2005-10-05 04:25:21',5),(196,35,NULL,'QuadWalker',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,'
1011Design and build the J-227 Quadwalker for combat.
1012\r\n
1013\r\n
1014\r\n
1015\r\n
1016Use the Warriors Future Force Camo Stik to customize your J-227 Quadwalker the way you want
1017\r\n
1018\r\n
1019\r\n
1020Add military insignia to make your vehicle truly distinct
1021\r\n
1022\r\n
1023\r\n
1024Whatever the terrain, J-227 Quadwalker is camouflaged and ready for action
1025\r\n
1026\r\n
1027\r\n
1028Comes with a fully functional missile array for realistic combat
1029\r\n
1030\r\n
1031\r\n
1032',NULL,'thumb.gif',NULL,'large.gif',NULL,'19.88',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'TOY5',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'32.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 01:32:33','2005-10-05 06:22:18',5),(197,35,NULL,'R2-D2',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,'
1033Finally a droid to call your own! R2-D2 is easy to control, functional and walks, talks and responds to your commands! Long Description Resourceful and adventurous, R2-D2 is ready, willing and able to serve. This spunky, brave droid is packed with all sorts of cool features that make him an invaluable ally.
1034
1035\r\n
1036Features:
1037
1038\r\n
1039\r\n
1040\r\n
1041\r\n
1042Droid companion navigates to find you, recognizes more than 30 phrases, dances, sings, plays multiple games and much more
1043\r\n
1044\r\n
1045\r\n
1046He has infrared sensors for location and tracking, sophisticated sonar for navigation, directional microphones, motorized wheels, voice-recognition software and an extendible arm that can carry a 12-ounce can
1047\r\n
1048\r\n
1049\r\n
1050Responds to names of Star Wars characters
1051\r\n
1052\r\n
1053\r\n
1054Plays 6 different songs plus Princess Leia\'s distress call
1055\r\n
1056\r\n
1057\r\n
1058Stands over 15 inches tall
1059\r\n
1060\r\n
1061\r\n
1062For ages 6 and up
1063\r\n
1064\r\n
1065\r\n
1066Requires 4 AA and 4 D alkaline batteries (not included)
1067\r\n
1068\r\n
1069\r\n
1070',NULL,'thumb.gif',NULL,'large.gif',NULL,'69.99',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'TOY1',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'16.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 01:38:33','2005-10-05 04:25:28',5),(201,36,NULL,'Student Guitar',NULL,NULL,NULL,NULL,'new',0,NULL,NULL,NULL,'Learn to play the guitar with this all-wood, 30-inch student guitar.\r\n
1071Accessories Included
1072
1073\r\n
1074\r\n
1075\r\n
1076Bonus E and B strings
1077\r\n
1078\r\n
1079\r\n
108030-inch student guitar features:
1081
1082\r\n
1083\r\n
1084\r\n
1085All-wood construction
1086\r\n
1087\r\n
1088\r\n
1089Glossy sunburst finish
1090\r\n
1091\r\n
1092\r\n
1093Steel strings
1094\r\n
1095\r\n
1096\r\n
1097Steel-reinforced neck
1098\r\n
1099\r\n
1100\r\n
1101Strap button
1102\r\n
1103\r\n
1104\r\n
1105Bonus E and B strings
1106\r\n
1107\r\n
1108\r\n
1109Individual tuning gears
1110\r\n
1111\r\n
1112\r\n',NULL,'thumb.gif',NULL,'large.gif',NULL,'30.00',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'TOY6',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'240.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 02:06:23','2005-10-05 04:25:39',5),(202,37,35,'Green',NULL,NULL,NULL,NULL,'new',0,NULL,'Rich grass green',NULL,NULL,NULL,'thumb.gif',NULL,NULL,NULL,'0.75',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'18089','3.00',0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,0,'1.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 02:38:11','2008-01-17 09:12:24',5),(204,37,35,'Blue',NULL,NULL,NULL,NULL,'new',0,NULL,'Vibrant royal blue',NULL,NULL,NULL,'thumb.gif',NULL,NULL,NULL,'0.75',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'18095',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'1.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 02:38:11','2005-09-30 09:56:27',5),(208,37,35,'Red',NULL,NULL,NULL,NULL,'new',0,NULL,'Deep red the color of wine',NULL,NULL,NULL,'thumb.gif',NULL,NULL,NULL,'0.75',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'18087',NULL,0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'1.00',NULL,'0.00',NULL,NULL,NULL,'2005-09-27 02:38:11','2005-09-30 12:57:07',5),(210,39,38,'XXX600 Gamer',NULL,NULL,NULL,NULL,'new',0,NULL,'The XXX 600 is armed to the teeth',NULL,'The XXX 600 is armed to the teeth. It is built with some of the latest technologies including dual core processors and dual graphics, delivered in a sleek, expandable chassis. Hard-core gamers and multimedia users can get serious, cutting-edge power.','The XXX 600 is armed to the teeth. It is built with some of the latest technologies including dual core processors and dual graphics, delivered in a sleek, expandable chassis. Hard-core gamers and multimedia users can get serious, cutting-edge power.','thumb.gif',NULL,NULL,NULL,'1500.00',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'PCG01','5.00',0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'320.00',NULL,'0.00',NULL,NULL,'2005-10-31 00:00:00','2005-09-29 11:54:25','2005-10-05 04:20:11',5),(211,40,38,'XXX510 Home',NULL,NULL,NULL,NULL,'new',0,'None','The XXX 510 will do the homework for you',NULL,'
1113XXX 510
1114\r\n
1115\r\n
1116Uncompromising Performance
1117\r\n
1118\r\n
1119
1120\r\n
1121\r\n
1122\r\n
1123Intel© Pentium© 4 Processor 630 w/HT Technology (3.0GHz,800FSB)
1124\r\n
1125Microsoft© Windows© XP Media Center 2005 Edition
1126\r\n
1127256MB DDR2 SDRAM at 400MHz (1x256M)
1128\r\n
112980GB2 Serial ATA Hard Drive (7200RPM) w/DataBurst Cache©
1130\r\n
1131Single Drive: 48x CD-RW / DVD-ROM Combo Drive
1132\r\n
1133\r\n
1134',NULL,'thumb.gif',NULL,NULL,NULL,'1000.00',NULL,NULL,1,NULL,NULL,25,NULL,NULL,NULL,1,NULL,NULL,'PCH01','2.00',0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,0,'320.00',NULL,'0.00',NULL,NULL,'2005-10-31 00:00:00','2005-09-29 11:59:40','2008-03-17 11:34:35',1),(212,41,38,'XXX380 Small Business',NULL,NULL,NULL,NULL,'new',0,NULL,'The XXX 380 is loaded and ready to burn',NULL,'
1135XXX 380 Convertible Mini-Tower
1136BASE
1137\r\n
1138\r\n
1139 Intel© Pentium© 4 Processor 630, 3.00GHz, 2MB L2, 800MHz
1140\r\n
1141 Microsoft© Windows© XP Professional, SP2 with Media
1142\r\n
1143 512MB, 533MHz, DDR2 SDRAM Memory, NECC (2 DIMMS)
1144\r\n
1145 80GB1 SATA, 7200 RPM Hard Drive with 8MB DataBurst Cache© without RAID
1146\r\n
1147',NULL,'thumb.gif',NULL,NULL,NULL,'1300.00',NULL,'1150.00',1,'2005-09-25 00:00:00','2005-10-06 00:00:00',NULL,NULL,NULL,NULL,1,NULL,NULL,'PCSB01','8.00',0,NULL,0,0,'default',NULL,1,NULL,NULL,NULL,NULL,'320.00',NULL,'0.00',NULL,NULL,'2005-10-31 00:00:00','2005-09-29 12:05:26','2005-10-05 04:19:12',5),(213,45,NULL,'Gift Certificate',NULL,NULL,NULL,NULL,'new',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,0,NULL,0,0,'default',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,'2007-06-06 10:31:09','2007-06-06 10:53:27',5)
1148Table 'cartkeeper.tbl_item' doesn't exist
1149
1150
1151Creating table: tbl_item_discount ... success!
1152Creating table: tbl_item_display_control ...
1153CREATE TABLE tbl_item_display_control (
1154 item_display_control_id int(11) NOT NULL auto_increment,
1155 default_category_columns int(11) NOT NULL default '0',
1156 default_item_columns int(11) NOT NULL default '0',
1157 default_mfg_columns int(11) NOT NULL default '0',
1158 items_per_page int(11) NOT NULL default '0',
1159 featured_item_columns int(11) NOT NULL default '0',
1160 number_featured_items int(11) NOT NULL default '0',
1161 low_inventory_threshold int(11) NOT NULL default '0',
1162 tiny_thumbnail_height int(11) default '0',
1163 tiny_thumbnail_width int(11) default NULL,
1164 allow_show_all tinyint(4) default NULL,
1165 condition_default varchar(255) default '',
1166 show_mfg_nav tinyint(4) default NULL,
1167 show_mfg_items tinyint(4) default NULL,
1168 show_special_nav tinyint(4) default NULL,
1169 show_adv_search tinyint(4) default NULL,
1170 item_order_by_id int(11) NOT NULL default '0',
1171 use_inventory tinyint(4) default NULL,
1172 category_display_type_id int(11) NOT NULL default '0',
1173 zero_quantity_items_visible tinyint(4) default '0',
1174 enable_wishlist tinyint(4) default NULL,
1175 downloadable_items tinyint(4) default NULL,
1176 show_email_to_friend_link tinyint(4) default NULL,
1177 show_request_info_link tinyint(4) default NULL,
1178 gallery_thumbs tinyint(4) default NULL,
1179 gallery_thumb_columns int(11) default NULL,
1180 num_recent_view int(11) default NULL,
1181 show_top_sellers tinyint(4) default NULL,
1182 num_top_sellers int(11) default NULL,
1183 show_additional_description_link tinyint(4) default NULL,
1184 popup_window_width int(11) default NULL,
1185 popup_window_height int(11) default NULL,
1186 currency_symbol varchar(255) default NULL,
1187 reviews_enabled tinyint(4) default '0',
1188 reviews_moderated tinyint(4) default NULL,
1189 allow_backordering tinyint(4) default '0',
1190 navigation_levels int(11) NOT NULL default '0',
1191 navigation_type_id int(11) default NULL,
1192 breadcrumb_separator mediumtext,
1193 qty_discount_type enum('None','Dollar Off','Percentage') default NULL,
1194 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1195 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1196 PRIMARY KEY (item_display_control_id)
1197)
1198Invalid default value for 'date_time_created'
1199
1200Inserting Data into: tbl_item_display_control ...
1201INSERT INTO tbl_item_display_control (item_display_control_id, default_category_columns, default_item_columns, default_mfg_columns, items_per_page, featured_item_columns, number_featured_items, low_inventory_threshold, tiny_thumbnail_height, tiny_thumbnail_width, allow_show_all, condition_default, show_mfg_nav, show_mfg_items, show_special_nav, show_adv_search, item_order_by_id, use_inventory, category_display_type_id, zero_quantity_items_visible, enable_wishlist, downloadable_items, show_email_to_friend_link, show_request_info_link, gallery_thumbs, gallery_thumb_columns, num_recent_view, show_top_sellers, num_top_sellers, show_additional_description_link, popup_window_width, popup_window_height, currency_symbol, reviews_enabled, reviews_moderated, allow_backordering, navigation_levels, navigation_type_id, breadcrumb_separator, qty_discount_type, date_time_created, date_time_modified) VALUES (1,2,3,3,9,2,2,2,50,NULL,1,'',1,1,1,1,3,1,1,1,1,0,1,1,1,3,5,1,3,0,640,480,'$',0,NULL,0,4,4,' » ','None','2004-09-19 11:29:02','2006-10-17 16:17:22')
1202Table 'cartkeeper.tbl_item_display_control' doesn't exist
1203
1204
1205Creating table: tbl_item_image_gallery ...
1206CREATE TABLE tbl_item_image_gallery (
1207 gallery_image_id int(11) NOT NULL auto_increment,
1208 item_id int(11) NOT NULL default '0',
1209 gallery_image_description mediumtext,
1210 gallery_thumb_image varchar(255) default NULL,
1211 gallery_large_image varchar(255) default NULL,
1212 gallery_sequence int(11) default NULL,
1213 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1214 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1215 PRIMARY KEY (gallery_image_id),
1216 KEY item_id_idx (item_id)
1217)
1218Invalid default value for 'date_time_created'
1219
1220Inserting Data into: tbl_item_image_gallery ...
1221INSERT INTO tbl_item_image_gallery (gallery_image_id, item_id, gallery_image_description, gallery_thumb_image, gallery_large_image, gallery_sequence, date_time_created, date_time_modified) VALUES (29,210,'Test view 1',NULL,'large.gif',1,'2005-09-30 04:29:55','2005-10-05 06:37:02'),(30,210,'Test view 2',NULL,'large.gif',2,'2005-09-30 04:29:55','2005-10-05 06:37:02'),(31,210,'Test view 3',NULL,'large.gif',3,'2005-09-30 04:29:55','2005-10-05 06:37:02'),(32,210,'Test view 4',NULL,'large.gif',4,'2005-09-30 04:29:55','2005-10-05 06:37:02')
1222Table 'cartkeeper.tbl_item_image_gallery' doesn't exist
1223
1224
1225Creating table: tbl_item_order_by ...
1226CREATE TABLE tbl_item_order_by (
1227 item_order_by_id int(11) NOT NULL auto_increment,
1228 order_by_description varchar(255) NOT NULL default '',
1229 order_by_clause varchar(255) NOT NULL default '',
1230 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1231 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1232 PRIMARY KEY (item_order_by_id)
1233)
1234Invalid default value for 'date_time_created'
1235
1236Inserting Data into: tbl_item_order_by ...
1237INSERT INTO tbl_item_order_by (item_order_by_id, order_by_description, order_by_clause, date_time_created, date_time_modified) VALUES (1,'sequence ascending','item_sequence, catalog_code, item_name','2004-09-19 11:24:49','2004-09-19 11:24:49'),(2,'sequence descending','item_sequence DESC, catalog_code, item_name','2004-09-19 11:25:04','2004-09-30 07:29:03'),(3,'item name ascending','item_name','2004-09-30 07:29:27','2004-09-30 07:29:27'),(4,'item name descending','item_name DESC','2004-09-30 07:29:49','2004-09-30 07:29:49'),(5,'catalog code ascending','catalog_code','2004-09-30 07:30:46','2004-09-30 07:30:46'),(6,'catalog code descending','catalog_code DESC','2004-09-30 07:31:01','2004-09-30 07:31:01'),(7,'price ascending','price','2004-09-30 12:54:21','2004-09-30 12:54:21'),(8,'price descending','price DESC','2004-09-30 12:54:51','2004-09-30 12:54:51'),(9,'entry time ascending','date_time_created','2005-12-06 03:12:59','2005-12-06 03:12:59'),(10,'entry time descending','date_time_created DESC','2005-12-06 03:13:16','2005-12-06 03:13:16'),(11,'modified time ascending','date_time_modified','0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,'modified time descending','date_time_modified DESC','0000-00-00 00:00:00','0000-00-00 00:00:00')
1238Table 'cartkeeper.tbl_item_order_by' doesn't exist
1239
1240
1241Creating table: tbl_item_related_category ... success! Inserting Data into: tbl_item_related_category ... success!
1242Creating table: tbl_item_related_item ... success! Inserting Data into: tbl_item_related_item ... success!
1243Creating table: tbl_item_related_manufacturer ... success! Inserting Data into: tbl_item_related_manufacturer ... success!
1244Creating table: tbl_item_template ...
1245CREATE TABLE tbl_item_template (
1246 item_template_id int(11) NOT NULL auto_increment,
1247 template_id int(11) NOT NULL default '0',
1248 item_template_name varchar(255) NOT NULL default '',
1249 item_template_description varchar(255) NOT NULL default '',
1250 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1251 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1252 PRIMARY KEY (item_template_id)
1253)
1254Invalid default value for 'date_time_created'
1255
1256Inserting Data into: tbl_item_template ...
1257INSERT INTO tbl_item_template (item_template_id, template_id, item_template_name, item_template_description, date_time_created, date_time_modified) VALUES (1,1,'item.php','Default Item Template','2004-11-04 18:26:05','2004-11-04 18:26:05')
1258Table 'cartkeeper.tbl_item_template' doesn't exist
1259
1260
1261Creating table: tbl_linkpoint_sale_method ...
1262CREATE TABLE tbl_linkpoint_sale_method (
1263 linkpoint_sale_method_id int(11) NOT NULL auto_increment,
1264 linkpoint_sale_method varchar(255) NOT NULL default '',
1265 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1266 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1267 PRIMARY KEY (linkpoint_sale_method_id)
1268)
1269Invalid default value for 'date_time_created'
1270
1271Inserting Data into: tbl_linkpoint_sale_method ...
1272INSERT INTO tbl_linkpoint_sale_method (linkpoint_sale_method_id, linkpoint_sale_method, date_time_created, date_time_modified) VALUES (1,'SALE','2005-04-07 13:01:29','2005-04-07 13:01:29'),(2,'PREAUTH','2005-04-07 13:01:37','2005-04-07 13:01:37')
1273Table 'cartkeeper.tbl_linkpoint_sale_method' doesn't exist
1274
1275
1276Creating table: tbl_mailing_list_configuration ...
1277CREATE TABLE tbl_mailing_list_configuration (
1278 mailing_list_configuration_id int(11) NOT NULL auto_increment,
1279 enabled tinyint(4) NOT NULL default '0',
1280 from_address varchar(255) NOT NULL default '',
1281 reply_to_address varchar(255) default NULL,
1282 return_path_address varchar(255) default NULL,
1283 require_verification tinyint(4) default NULL,
1284 admin_signup_notification tinyint(4) default NULL,
1285 batch_size int(11) NOT NULL default '0',
1286 batch_timer int(11) NOT NULL default '0',
1287 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1288 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1289 PRIMARY KEY (mailing_list_configuration_id)
1290)
1291Invalid default value for 'date_time_created'
1292
1293Inserting Data into: tbl_mailing_list_configuration ...
1294INSERT INTO tbl_mailing_list_configuration (mailing_list_configuration_id, enabled, from_address, reply_to_address, return_path_address, require_verification, admin_signup_notification, batch_size, batch_timer, date_time_created, date_time_modified) VALUES (1,0,'user@example.com',NULL,NULL,0,0,40,3,'2010-01-12 18:30:47','2010-01-12 18:31:03')
1295Table 'cartkeeper.tbl_mailing_list_configuration' doesn't exist
1296
1297
1298Creating table: tbl_mailing_list_job ...
1299CREATE TABLE tbl_mailing_list_job (
1300 mailing_list_job_id int(11) NOT NULL auto_increment,
1301 job_name varchar(255) NOT NULL default '',
1302 message_subject varchar(255) default NULL,
1303 job_status enum('new','started','completed','cancelled') default 'new',
1304 mailing_list_template_id int(11) default NULL,
1305 message_text mediumtext NOT NULL,
1306 message_html mediumtext,
1307 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1308 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1309 PRIMARY KEY (mailing_list_job_id)
1310)
1311Invalid default value for 'date_time_created'
1312
1313
1314Creating table: tbl_mailing_list_queue ...
1315CREATE TABLE tbl_mailing_list_queue (
1316 queue_id int(11) NOT NULL auto_increment,
1317 user_id int(11) default NULL,
1318 job_id int(11) default NULL,
1319 first_name varchar(255) NOT NULL default '',
1320 last_name varchar(255) NOT NULL default '',
1321 email varchar(255) NOT NULL default '',
1322 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1323 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1324 PRIMARY KEY (queue_id),
1325 UNIQUE KEY email_uni_idx (email),
1326 UNIQUE KEY user_id_uni_idx (user_id)
1327)
1328Invalid default value for 'date_time_created'
1329
1330
1331Creating table: tbl_mailing_list_template ...
1332CREATE TABLE tbl_mailing_list_template (
1333 mailing_list_template_id int(11) NOT NULL auto_increment,
1334 template_name varchar(255) NOT NULL default '',
1335 template_html mediumtext NOT NULL,
1336 template_text mediumtext NOT NULL,
1337 note mediumtext NOT NULL,
1338 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1339 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1340 PRIMARY KEY (mailing_list_template_id)
1341)
1342Invalid default value for 'date_time_created'
1343
1344
1345Creating table: tbl_mailing_list_user ...
1346CREATE TABLE tbl_mailing_list_user (
1347 mailing_list_user_id int(11) NOT NULL auto_increment,
1348 user_id int(11) default NULL,
1349 email varchar(255) NOT NULL default '',
1350 first_name varchar(255) default NULL,
1351 last_name varchar(255) default NULL,
1352 mailing_list_status enum('unconfirmed','confirmed') default 'confirmed',
1353 confirmation_key varchar(255) default NULL,
1354 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1355 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1356 PRIMARY KEY (mailing_list_user_id),
1357 UNIQUE KEY email (email),
1358 KEY user_id_idx (user_id),
1359 KEY mailing_list_status_idx (mailing_list_status)
1360)
1361Invalid default value for 'date_time_created'
1362
1363
1364Creating table: tbl_manufacturer ...
1365CREATE TABLE tbl_manufacturer (
1366 manufacturer_id int(11) NOT NULL auto_increment,
1367 parent_manufacturer_id int(11) default NULL,
1368 manufacturer varchar(255) NOT NULL default '',
1369 page_title varchar(255) default NULL,
1370 page_keywords mediumtext,
1371 page_description mediumtext,
1372 short_description mediumtext,
1373 long_description mediumtext,
1374 thumbnail_image varchar(255) default NULL,
1375 large_image varchar(255) default NULL,
1376 active tinyint(4) default '1',
1377 new_until datetime default NULL,
1378 category_columns int(11) default NULL,
1379 item_columns int(11) default NULL,
1380 number_of_items int(11) default NULL,
1381 category_display_type_id int(11) default NULL,
1382 message mediumtext,
1383 message_expire_date datetime default NULL,
1384 discount_percentage int(11) default NULL,
1385 discount_start_date datetime default NULL,
1386 discount_expire_date datetime default NULL,
1387 category_detail_template_id int(11) default '1',
1388 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1389 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1390 PRIMARY KEY (manufacturer_id),
1391 KEY parent_manufacturer_id (parent_manufacturer_id)
1392)
1393Invalid default value for 'date_time_created'
1394
1395Inserting Data into: tbl_manufacturer ...
1396INSERT INTO tbl_manufacturer (manufacturer_id, parent_manufacturer_id, manufacturer, page_title, page_keywords, page_description, short_description, long_description, thumbnail_image, large_image, active, new_until, category_columns, item_columns, number_of_items, category_display_type_id, message, message_expire_date, discount_percentage, discount_start_date, discount_expire_date, category_detail_template_id, date_time_created, date_time_modified) VALUES (30,NULL,'LL-Queen',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2005-09-24 18:15:08','2005-09-24 18:15:08'),(31,NULL,'Leveye',NULL,NULL,NULL,NULL,'Leveye Clothing Manufacture an all American Standard',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2005-09-25 12:09:04','2005-09-30 03:42:31'),(32,NULL,'Oh-Mygosh','Oh Mygosh Infant Clothing',NULL,NULL,NULL,'Oh Mygosh infant clothing will never wear out or stain before your infants out grow them!',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2005-09-25 12:16:05','2005-09-30 03:41:53'),(33,NULL,'Jay-Krew',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2005-09-26 13:24:07','2005-09-26 13:24:47'),(34,NULL,'Buttons Unlimited',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,1,'2005-09-28 08:15:28','2005-09-30 03:46:48'),(35,NULL,'Acme Bobbles',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,1,'2005-09-28 08:29:49','2005-09-30 11:36:03'),(39,NULL,'Fabric Co',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2005-09-30 03:37:11','2005-09-30 03:37:11'),(38,NULL,'Bell Computers',NULL,NULL,NULL,NULL,'Bell Delivers Unprecedented Performance',NULL,NULL,1,NULL,NULL,3,3,NULL,NULL,NULL,NULL,NULL,NULL,1,'2005-09-29 11:27:49','2005-09-29 23:57:49')
1397Table 'cartkeeper.tbl_manufacturer' doesn't exist
1398
1399
1400Creating table: tbl_manufacturer_featured_item_map ... success!
1401Creating table: tbl_navigation_type ...
1402CREATE TABLE tbl_navigation_type (
1403 navigation_type_id int(11) NOT NULL auto_increment,
1404 navigation_type varchar(255) NOT NULL default '',
1405 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1406 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1407 PRIMARY KEY (navigation_type_id)
1408)
1409Invalid default value for 'date_time_created'
1410
1411Inserting Data into: tbl_navigation_type ...
1412INSERT INTO tbl_navigation_type (navigation_type_id, navigation_type, date_time_created, date_time_modified) VALUES (1,'Horizontal','2004-09-19 08:16:00','2004-09-19 08:16:00'),(2,'Vertical','2004-09-19 08:16:11','2004-09-19 08:16:11'),(3,'BOTH','2004-10-12 14:14:08','2004-10-12 14:14:08'),(4,'Vertical-Expand','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'BOTH Vertical-Expand','0000-00-00 00:00:00','0000-00-00 00:00:00')
1413Table 'cartkeeper.tbl_navigation_type' doesn't exist
1414
1415
1416Creating table: tbl_option ...
1417CREATE TABLE tbl_option (
1418 option_id int(11) NOT NULL auto_increment,
1419 item_id int(11) NOT NULL default '0',
1420 option_sequence int(11) default NULL,
1421 option_type_id int(11) NOT NULL default '0',
1422 option_name varchar(255) NOT NULL default '',
1423 option_required tinyint(4) default '0',
1424 global_option_id int(11) default NULL,
1425 option_description mediumtext,
1426 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1427 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1428 PRIMARY KEY (option_id),
1429 KEY item_id_idx (item_id)
1430)
1431Invalid default value for 'date_time_created'
1432
1433Inserting Data into: tbl_option ...
1434INSERT INTO tbl_option (option_id, item_id, option_sequence, option_type_id, option_name, option_required, global_option_id, option_description, date_time_created, date_time_modified) VALUES (68,133,1,1,'Children Denim Shorts Boys',0,4,NULL,'0000-00-00 00:00:00','2005-10-05 03:46:36'),(71,135,1,1,'Jacket Size',0,5,NULL,'0000-00-00 00:00:00','2005-10-05 03:51:24'),(72,135,1,1,'Color',0,1,NULL,'0000-00-00 00:00:00','2005-10-05 03:51:24'),(73,136,1,1,'Size',0,5,NULL,'0000-00-00 00:00:00','2005-10-05 03:51:29'),(74,136,1,1,'Color',0,1,NULL,'0000-00-00 00:00:00','2005-10-05 03:51:29'),(77,138,2,1,'Size',0,5,NULL,'0000-00-00 00:00:00','2005-10-05 03:51:33'),(78,138,1,1,'Color',0,1,NULL,'0000-00-00 00:00:00','2005-10-05 03:51:33'),(86,142,2,1,'Color',0,1,NULL,'0000-00-00 00:00:00','2005-10-05 03:48:46'),(88,144,1,1,'Color',0,1,NULL,'0000-00-00 00:00:00','2005-10-05 03:52:53'),(87,142,1,1,'Shoe Size',0,6,NULL,'0000-00-00 00:00:00','2005-10-05 03:48:46'),(89,145,1,1,'Colors',0,8,NULL,'0000-00-00 00:00:00','2008-02-19 10:09:59'),(90,145,1,2,'Size',0,7,NULL,'0000-00-00 00:00:00','2008-02-19 10:09:59'),(91,146,1,2,'Sock Size',0,7,NULL,'0000-00-00 00:00:00','2008-03-17 11:34:06'),(92,147,1,1,'Color',0,1,NULL,'0000-00-00 00:00:00','2005-10-05 04:04:11'),(93,147,1,3,'Shirt Size',0,9,NULL,'0000-00-00 00:00:00','2005-10-05 04:04:11'),(94,154,1,2,'Size',0,NULL,NULL,'2005-09-26 15:18:53','2005-09-26 15:18:53'),(95,154,2,2,'Engrave',0,NULL,NULL,'2005-09-26 15:18:53','2005-09-26 15:18:53'),(96,154,3,5,'Engrave Message',0,NULL,NULL,'2005-09-26 15:18:53','2005-09-26 15:18:53'),(99,156,1,1,'Size',0,NULL,NULL,'2005-09-26 15:25:58','2005-09-26 15:29:10'),(100,157,1,1,'Size',0,NULL,NULL,'2005-09-26 15:38:17','2005-09-26 15:40:30'),(101,157,2,3,'Ring Insurance',0,NULL,NULL,'2005-09-26 15:38:17','2005-09-26 15:40:30'),(109,175,1,1,'Button Size',0,11,NULL,'0000-00-00 00:00:00','2005-09-30 11:34:15'),(111,173,1,1,'Button Size',0,11,NULL,'0000-00-00 00:00:00','2005-09-30 11:34:08'),(114,170,1,1,'Button Size',0,11,NULL,'0000-00-00 00:00:00','2005-09-30 11:33:59'),(116,177,1,1,'Button Size',0,11,NULL,'0000-00-00 00:00:00','2005-09-30 11:34:29'),(118,185,1,2,'Size',0,NULL,NULL,'2005-09-26 22:53:23','2005-09-30 11:19:48'),(119,185,2,1,'Accessories',0,NULL,NULL,'2005-09-26 22:53:23','2005-09-30 11:19:48'),(120,185,3,2,'Surfaces',0,NULL,NULL,'2005-09-26 22:53:23','2005-09-30 11:19:48'),(121,185,4,3,'Tote',0,NULL,NULL,'2005-09-26 22:54:57','2005-09-30 11:19:48'),(122,186,1,2,'Size',0,NULL,NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(123,186,2,1,'Accessories',0,NULL,NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(124,186,3,2,'Surfaces',0,NULL,NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(125,186,4,3,'Tote',0,NULL,NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(126,187,1,1,'Extra Hose Length',0,NULL,NULL,'2005-09-27 00:24:10','2005-09-30 13:07:06'),(127,187,2,3,'Adapter',0,NULL,NULL,'2005-09-27 00:24:10','2005-09-30 13:07:06'),(128,188,1,3,'Extra',0,NULL,NULL,'2005-09-27 00:30:50','2005-09-30 13:10:08'),(129,190,1,3,'Extras',0,NULL,NULL,'2005-09-27 00:39:54','2005-09-30 13:09:35'),(130,191,1,1,'Locking Umbrella Base',0,NULL,NULL,'2005-09-27 00:50:25','2005-09-30 13:10:46'),(131,191,2,3,'Extra',0,NULL,NULL,'2005-09-27 00:50:25','2005-09-30 13:10:46'),(132,192,1,3,'Extras',0,NULL,NULL,'2005-09-27 00:56:55','2005-09-30 13:09:08'),(133,193,1,3,'Extra Hose Length',0,NULL,NULL,'2005-09-27 01:13:36','2005-09-30 13:07:30'),(134,194,1,1,'Extra Propane',0,NULL,NULL,'2005-09-27 01:18:27','2005-09-30 10:45:36'),(135,194,2,3,'Extras',0,NULL,NULL,'2005-09-27 01:18:27','2005-09-30 10:45:36'),(136,195,1,1,'Extras Batteris',0,NULL,NULL,'2005-09-27 01:28:07','2005-10-05 04:25:22'),(137,195,2,3,'Activity Pack',0,NULL,NULL,'2005-09-27 01:28:07','2005-10-05 04:25:22'),(138,196,1,3,'Extras',0,NULL,NULL,'2005-09-27 01:32:33','2005-10-05 06:22:19'),(139,197,1,3,'Extras',0,NULL,NULL,'2005-09-27 01:38:33','2005-10-05 04:25:29'),(143,201,1,1,'Extra Strings',0,NULL,NULL,'2005-09-27 02:06:23','2005-10-05 04:25:40'),(144,210,1,1,'PC Display Type',0,12,NULL,'0000-00-00 00:00:00','2005-10-05 04:20:11'),(145,210,2,3,'PC Extras',0,13,NULL,'0000-00-00 00:00:00','2005-10-05 04:20:11'),(146,210,3,2,'PC Warrantee',1,14,NULL,'0000-00-00 00:00:00','2005-10-05 04:20:11'),(147,211,1,1,'PC Display Type',0,12,NULL,'2005-09-29 11:59:40','2008-03-17 11:34:35'),(148,211,2,3,'PC Extras',0,13,NULL,'2005-09-29 11:59:40','2008-03-17 11:34:35'),(149,211,3,2,'PC Warrantee',1,14,NULL,'2005-09-29 11:59:40','2008-03-17 11:34:35'),(150,212,1,1,'PC Display Type',0,12,NULL,'2005-09-29 12:05:26','2005-10-05 04:19:12'),(151,212,2,3,'PC Extras',0,13,NULL,'2005-09-29 12:05:26','2005-10-05 04:19:12'),(152,212,3,2,'PC Warrantee',1,14,NULL,'2005-09-29 12:05:26','2005-10-05 04:19:12'),(153,213,0,1,'Amount',1,NULL,NULL,'2007-06-06 10:31:09','2008-01-23 12:53:55'),(154,213,0,5,'Recipient\'s Name',0,NULL,NULL,'2007-06-06 10:31:09','2008-01-23 12:53:55'),(155,213,0,5,'Recipient\'s Email',0,NULL,NULL,'2007-06-06 10:31:09','2008-01-23 12:53:55'),(156,213,0,4,'Message',0,NULL,NULL,'2007-06-06 10:31:40','2008-01-23 12:53:55')
1435Table 'cartkeeper.tbl_option' doesn't exist
1436
1437
1438Creating table: tbl_option_attribute ...
1439CREATE TABLE tbl_option_attribute (
1440 option_attribute_id int(11) NOT NULL auto_increment,
1441 option_id int(11) NOT NULL default '0',
1442 attribute_name varchar(255) NOT NULL default '',
1443 attribute_quantity decimal(8,2) default NULL,
1444 attribute_price decimal(9,2) NOT NULL default '0.00',
1445 attribute_ship decimal(8,2) default NULL,
1446 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1447 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1448 PRIMARY KEY (option_attribute_id),
1449 KEY option_id_idx (option_id)
1450)
1451Invalid default value for 'date_time_created'
1452
1453Inserting Data into: tbl_option_attribute ...
1454INSERT INTO tbl_option_attribute (option_attribute_id, option_id, attribute_name, attribute_quantity, attribute_price, attribute_ship, date_time_created, date_time_modified) VALUES (334,68,'Boys Slim Age 4-7',NULL,'2.00','0.00','0000-00-00 00:00:00','2005-10-05 03:46:36'),(333,68,'Boys Slim Age 8-18',NULL,'3.00','0.00','0000-00-00 00:00:00','2005-10-05 03:46:36'),(332,68,'Boys Husky Age 4-7',NULL,'4.00','0.00','0000-00-00 00:00:00','2005-10-05 03:46:36'),(331,68,'Boys Husky Age 8-18',NULL,'5.00','0.00','0000-00-00 00:00:00','2005-10-05 03:46:36'),(342,71,'12 Months',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(343,71,'18 Months',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(344,71,'2 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(345,71,'3 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(346,71,'4 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(347,72,'Black',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(348,72,'Red',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(349,72,'Blue',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(350,72,'Green',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:24'),(351,71,'Value',NULL,'0.00',NULL,'2005-09-25 13:14:22','2005-10-05 03:51:24'),(352,73,'12 Months',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(353,73,'18 Months',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(354,73,'2 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(355,73,'3 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(356,73,'4 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(357,74,'Black',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(358,74,'Red',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(359,74,'Blue',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(360,74,'Green',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:29'),(372,77,'12 Months',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(373,77,'18 Months',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(374,77,'2 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(375,77,'3 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(376,77,'4 Years',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(377,78,'Black',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(378,78,'Red',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(379,78,'Blue',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(380,78,'Green',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:51:33'),(429,88,'Green',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:52:53'),(427,88,'Red',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:52:53'),(416,86,'Black',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:48:46'),(417,86,'Red',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:48:46'),(418,86,'Blue',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:48:46'),(419,86,'Green',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:48:46'),(421,87,'S (Fits 12-13)',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:48:46'),(428,88,'Blue',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:52:53'),(422,87,'M (Fits 1-2)',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:48:46'),(423,87,'L (Fits 3-4)',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:48:46'),(424,87,'XL (Fits 5-6)',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:48:46'),(426,88,'Black',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 03:52:53'),(431,89,'Red',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(432,89,'Blue',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(433,89,'White',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(434,89,'Black',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(435,89,'Yellow',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(436,89,'Pink',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(437,89,'Grey',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(438,90,'Toddler',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(439,90,'Childrens',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(440,90,'Womens',NULL,'1.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(441,90,'Mens',NULL,'2.00','0.00','0000-00-00 00:00:00','2008-02-19 10:09:59'),(443,91,'Toddler',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-03-17 11:34:06'),(444,91,'Childrens',NULL,'0.00','0.00','0000-00-00 00:00:00','2008-03-17 11:34:06'),(445,91,'Womens',NULL,'1.00','0.00','0000-00-00 00:00:00','2008-03-17 11:34:06'),(446,91,'Mens',NULL,'2.00','0.00','0000-00-00 00:00:00','2008-03-17 11:34:06'),(448,92,'Black',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 04:04:11'),(449,92,'Red',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 04:04:11'),(452,93,'Small',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 04:04:11'),(453,93,'Medium',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 04:04:11'),(454,93,'Large',NULL,'0.00','0.00','0000-00-00 00:00:00','2005-10-05 04:04:11'),(460,95,'Half Unit',NULL,'0.00',NULL,'2005-09-26 15:18:53','2005-09-26 15:18:53'),(458,94,'Half Unit',NULL,'0.00',NULL,'2005-09-26 15:18:53','2005-09-26 15:18:53'),(459,94,'Full Unit',NULL,'0.00',NULL,'2005-09-26 15:18:53','2005-09-26 15:18:53'),(461,95,'Full Unit',NULL,'0.00',NULL,'2005-09-26 15:18:53','2005-09-26 15:18:53'),(468,99,'Small',NULL,'0.00',NULL,'2005-09-26 15:25:58','2005-09-26 15:29:10'),(469,99,'Medium',NULL,'0.00',NULL,'2005-09-26 15:25:58','2005-09-26 15:29:10'),(470,99,'Large',NULL,'0.00',NULL,'2005-09-26 15:25:58','2005-09-26 15:29:10'),(471,99,'X-Large',NULL,'20.00',NULL,'2005-09-26 15:25:58','2005-09-26 15:29:10'),(472,100,'Small',NULL,'0.00',NULL,'2005-09-26 15:38:17','2005-09-26 15:40:30'),(473,100,'Medium',NULL,'0.00',NULL,'2005-09-26 15:38:17','2005-09-26 15:40:30'),(474,100,'Large',NULL,'0.00',NULL,'2005-09-26 15:38:17','2005-09-26 15:40:30'),(475,100,'X-Large Add',NULL,'20.00',NULL,'2005-09-26 15:38:17','2005-09-26 15:40:30'),(476,101,'Ring Insurance Add',NULL,'50.00',NULL,'2005-09-26 15:38:17','2005-09-26 15:40:30'),(502,109,'1 3/16in',NULL,'1.25','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(503,109,'1 1/8in',NULL,'1.15','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(504,109,'1in',NULL,'1.00','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(505,109,'7/8in',NULL,'0.90','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(506,109,'3/4in',NULL,'0.80','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(507,109,'5/8in',NULL,'0.70','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(508,109,'1/2in',NULL,'0.60','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(509,109,'7/16in',NULL,'0.50','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(510,109,'3/8in',NULL,'0.40','0.00','0000-00-00 00:00:00','2005-09-30 11:34:15'),(522,111,'1 3/16in','0.00','1.25','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(523,111,'1 1/8in','0.00','1.15','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(524,111,'1in','0.00','1.00','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(525,111,'7/8in','0.00','0.90','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(526,111,'3/4in','0.00','0.80','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(527,111,'5/8in','4.00','0.70','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(528,111,'1/2in','0.00','0.60','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(529,111,'7/16in','0.00','0.50','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(530,111,'3/8in','0.00','0.40','0.00','0000-00-00 00:00:00','2005-09-30 11:34:08'),(552,114,'1 3/16in',NULL,'1.25','0.00','0000-00-00 00:00:00','2005-09-30 11:33:59'),(553,114,'1 1/8in',NULL,'1.15','0.00','0000-00-00 00:00:00','2005-09-30 11:33:59'),(554,114,'1in',NULL,'1.00','0.00','0000-00-00 00:00:00','2005-09-30 11:33:59'),(555,114,'7/8in',NULL,'0.90','0.00','0000-00-00 00:00:00','2005-09-30 11:34:00'),(556,114,'3/4in',NULL,'0.80','0.00','0000-00-00 00:00:00','2005-09-30 11:34:00'),(557,114,'5/8in',NULL,'0.70','0.00','0000-00-00 00:00:00','2005-09-30 11:34:00'),(558,114,'1/2in',NULL,'0.60','0.00','0000-00-00 00:00:00','2005-09-30 11:34:00'),(559,114,'7/16in',NULL,'0.50','0.00','0000-00-00 00:00:00','2005-09-30 11:34:00'),(560,114,'3/8in',NULL,'0.40','0.00','0000-00-00 00:00:00','2005-09-30 11:34:00'),(572,116,'1 3/16in',NULL,'1.25','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(573,116,'1 1/8in',NULL,'1.15','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(574,116,'1in',NULL,'1.00','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(575,116,'7/8in',NULL,'0.90','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(576,116,'3/4in',NULL,'0.80','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(577,116,'5/8in',NULL,'0.70','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(578,116,'1/2in',NULL,'0.60','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(579,116,'7/16in',NULL,'0.50','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(580,116,'3/8in',NULL,'0.40','0.00','0000-00-00 00:00:00','2005-09-30 11:34:29'),(592,118,'5X6',NULL,'10.00','8.00','2005-09-26 22:53:23','2005-09-30 11:19:48'),(593,118,'8X10',NULL,'15.00','16.00','2005-09-26 22:53:23','2005-09-30 11:19:48'),(594,118,'11X17',NULL,'25.00','32.00','2005-09-26 22:53:23','2005-09-30 11:19:48'),(595,118,'24X32',NULL,'35.00','64.00','2005-09-26 22:53:23','2005-09-30 11:19:48'),(596,119,'None',NULL,'0.00',NULL,'2005-09-26 22:53:23','2005-09-30 11:19:48'),(597,119,'P533 - Paintkit for Blue Jay Add',NULL,'20.00','16.00','2005-09-26 22:53:23','2005-09-30 11:19:48'),(598,119,'PK533 - Brushkit for Blue Jay Add',NULL,'10.00','32.00','2005-09-26 22:53:23','2005-09-30 11:19:48'),(599,119,'KT533 - Complete Brush and Paint Kit Add',NULL,'25.00','48.00','2005-09-26 22:53:23','2005-09-30 11:19:48'),(600,120,'None',NULL,'0.00',NULL,'2005-09-26 22:53:23','2005-09-30 11:19:48'),(601,120,'Watercolor Pad - Add',NULL,'10.00',NULL,'2005-09-26 22:53:23','2005-09-30 11:19:48'),(602,120,'10 x 8 Velour Board - Add',NULL,'5.00',NULL,'2005-09-26 22:53:23','2005-09-30 11:19:48'),(603,120,'11 x 9 Canvas - Add',NULL,'12.00',NULL,'2005-09-26 22:53:23','2005-09-30 11:19:48'),(604,121,'Artist Tote - Add',NULL,'10.00',NULL,'2005-09-26 22:54:57','2005-09-30 11:19:48'),(605,122,'5X6',NULL,'10.00','8.00','2005-09-26 23:00:28','2005-09-30 11:32:55'),(606,122,'8X10',NULL,'15.00','16.00','2005-09-26 23:00:28','2005-09-30 11:32:55'),(607,122,'11X17',NULL,'25.00','32.00','2005-09-26 23:00:28','2005-09-30 11:32:55'),(608,122,'24X32',NULL,'35.00','64.00','2005-09-26 23:00:28','2005-09-30 11:32:55'),(609,123,'None',NULL,'0.00',NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(610,123,'P533 - Paintkit for Lark Add',NULL,'20.00','16.00','2005-09-26 23:00:28','2005-09-30 11:32:55'),(611,123,'PK533 - Brushkit for Lark Add',NULL,'10.00','32.00','2005-09-26 23:00:28','2005-09-30 11:32:55'),(612,123,'KT533 - Complete Brush and Paint Kit Add',NULL,'25.00','48.00','2005-09-26 23:00:28','2005-09-30 11:32:55'),(613,124,'None',NULL,'0.00',NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(614,124,'Watercolor Pad - Add',NULL,'10.00',NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(615,124,'10 x 8 Velour Board - Add',NULL,'5.00',NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(616,124,'11 x 9 Canvas - Add',NULL,'12.00',NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(617,125,'Artist Tote - Add',NULL,'10.00',NULL,'2005-09-26 23:00:28','2005-09-30 11:32:55'),(618,126,'10 ft - Add',NULL,'10.00','32.00','2005-09-27 00:24:10','2005-09-30 13:07:06'),(619,126,'50 ft - Add',NULL,'20.00','64.00','2005-09-27 00:24:10','2005-09-30 13:07:06'),(620,126,'100 ft - Add',NULL,'40.00','128.00','2005-09-27 00:24:10','2005-09-30 13:07:06'),(621,127,'Sprinkler Adapter - Add',NULL,'5.00',NULL,'2005-09-27 00:24:10','2005-09-30 13:07:06'),(622,128,'Extra oil - Add',NULL,'15.00','64.00','2005-09-27 00:30:50','2005-09-30 13:10:08'),(623,129,'Rain Cover - Add',NULL,'15.00','32.00','2005-09-27 00:39:54','2005-09-30 13:09:35'),(624,129,'Charcoal - Add',NULL,'11.00','128.00','2005-09-27 00:39:54','2005-09-30 13:09:35'),(625,130,'Avacado - Add',NULL,'29.97','128.00','2005-09-27 00:50:25','2005-09-30 13:10:46'),(626,130,'Snow White - Add',NULL,'29.97','128.00','2005-09-27 00:50:25','2005-09-30 13:10:46'),(627,131,'Rain Cover',NULL,'15.00',NULL,'2005-09-27 00:50:25','2005-09-30 13:10:46'),(628,132,'Fire Starter - Add',NULL,'12.00','32.00','2005-09-27 00:56:55','2005-09-30 13:09:08'),(629,132,'Rain Cover - Add',NULL,'15.00','64.00','2005-09-27 00:56:55','2005-09-30 13:09:08'),(630,133,'10 ft - Add',NULL,'10.00','32.00','2005-09-27 01:13:36','2005-09-30 13:07:30'),(631,133,'50 ft - Add',NULL,'20.00','64.00','2005-09-27 01:13:36','2005-09-30 13:07:30'),(632,133,'100 ft - Add',NULL,'40.00','128.00','2005-09-27 01:13:36','2005-09-30 13:07:30'),(633,134,'1 Cylinder - Add',NULL,'25.00','128.00','2005-09-27 01:18:27','2005-09-30 10:45:36'),(634,134,'2 Cylinder - Add',NULL,'50.00','256.00','2005-09-27 01:18:27','2005-09-30 10:45:36'),(635,134,'3 Cylinder - Add','1.00','75.00','512.00','2005-09-27 01:18:27','2005-09-30 10:45:36'),(636,135,'Rain Cover - Add',NULL,'15.00',NULL,'2005-09-27 01:18:27','2005-09-30 10:45:36'),(637,136,'1- Pack - Add',NULL,'5.00','8.00','2005-09-27 01:28:07','2005-10-05 04:25:22'),(638,136,'2- Pack - Add',NULL,'10.00','16.00','2005-09-27 01:28:07','2005-10-05 04:25:22'),(639,136,'3- Pack - Add',NULL,'15.00','24.00','2005-09-27 01:28:07','2005-10-05 04:25:22'),(640,137,'Geography activity pack - Add',NULL,'20.00','32.00','2005-09-27 01:28:07','2005-10-05 04:25:22'),(641,138,'Replacement Missles -Add',NULL,'15.00','8.00','2005-09-27 01:32:33','2005-10-05 06:22:19'),(642,139,'Batteries - Add',NULL,'8.00','16.00','2005-09-27 01:38:33','2005-10-05 04:25:29'),(650,143,'1 - Pack - Add',NULL,'5.00','8.00','2005-09-27 02:06:23','2005-10-05 04:25:40'),(651,143,'2 - Packs - Add',NULL,'12.00','16.00','2005-09-27 02:06:23','2005-10-05 04:25:40'),(652,143,'3 - Packs - Add',NULL,'18.00','32.00','2005-09-27 02:06:23','2005-10-05 04:25:40'),(692,146,'1 Year Warrantee',NULL,'25.00','0.00','0000-00-00 00:00:00','2005-10-05 04:20:12'),(720,147,'21 Inch Flat Panel',NULL,'150.00','128.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(719,147,'19 Inch Flat Panel',NULL,'75.00','112.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(718,147,'17 Inch Flat Panel',NULL,'25.00','96.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(717,147,'15 Inch Flat Panel',NULL,'0.00','80.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(730,148,'Display Stand with Drawer',NULL,'15.00','64.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(729,148,'250 Button Keyboard',NULL,'10.00','32.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(728,148,'3 Button Optical Mouse',NULL,'5.00','16.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(697,149,'3 Year Warrantee',NULL,'75.00','0.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(696,149,'2 Year Warrantee',NULL,'50.00','0.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(695,149,'1 Year Warrantee',NULL,'25.00','0.00','0000-00-00 00:00:00','2008-03-17 11:34:35'),(724,150,'21 Inch Flat Panel',NULL,'150.00','128.00','0000-00-00 00:00:00','2005-10-05 04:19:12'),(723,150,'19 Inch Flat Panel',NULL,'75.00','112.00','0000-00-00 00:00:00','2005-10-05 04:19:12'),(722,150,'17 Inch Flat Panel',NULL,'25.00','96.00','0000-00-00 00:00:00','2005-10-05 04:19:12'),(721,150,'15 Inch Flat Panel',NULL,'0.00','80.00','0000-00-00 00:00:00','2005-10-05 04:19:12'),(733,151,'Display Stand with Drawer',NULL,'15.00','64.00','0000-00-00 00:00:00','2005-10-05 04:19:13'),(732,151,'250 Button Keyboard',NULL,'10.00','32.00','0000-00-00 00:00:00','2005-10-05 04:19:13'),(731,151,'3 Button Optical Mouse',NULL,'5.00','16.00','0000-00-00 00:00:00','2005-10-05 04:19:13'),(700,152,'3 Year Warrantee',NULL,'75.00','0.00','0000-00-00 00:00:00','2005-10-05 04:19:13'),(699,152,'2 Year Warrantee',NULL,'50.00','0.00','0000-00-00 00:00:00','2005-10-05 04:19:13'),(698,152,'1 Year Warrantee',NULL,'25.00','0.00','0000-00-00 00:00:00','2005-10-05 04:19:13'),(716,144,'21 Inch Flat Panel',NULL,'150.00','128.00','0000-00-00 00:00:00','2005-10-05 04:20:11'),(715,144,'19 Inch Flat Panel',NULL,'75.00','112.00','0000-00-00 00:00:00','2005-10-05 04:20:11'),(714,144,'17 Inch Flat Panel',NULL,'25.00','96.00','0000-00-00 00:00:00','2005-10-05 04:20:11'),(713,144,'15 Inch Flat Panel',NULL,'0.00','80.00','0000-00-00 00:00:00','2005-10-05 04:20:11'),(727,145,'Display Stand with Drawer',NULL,'15.00','64.00','0000-00-00 00:00:00','2005-10-05 04:20:11'),(726,145,'250 Button Keyboard',NULL,'10.00','32.00','0000-00-00 00:00:00','2005-10-05 04:20:11'),(725,145,'3 Button Optical Mouse',NULL,'5.00','16.00','0000-00-00 00:00:00','2005-10-05 04:20:11'),(694,146,'3 Year Warrantee',NULL,'75.00','0.00','0000-00-00 00:00:00','2005-10-05 04:20:12'),(693,146,'2 Year Warrantee',NULL,'50.00','0.00','0000-00-00 00:00:00','2005-10-05 04:20:12'),(734,153,'',NULL,'20.00',NULL,'2007-06-06 10:31:09','2008-01-23 12:53:55'),(735,153,'',NULL,'50.00',NULL,'2007-06-06 10:31:09','2008-01-23 12:53:55'),(736,153,'',NULL,'100.00',NULL,'2007-06-06 10:31:09','2008-01-23 12:53:55')
1455Table 'cartkeeper.tbl_option_attribute' doesn't exist
1456
1457
1458Creating table: tbl_option_type ...
1459CREATE TABLE tbl_option_type (
1460 option_type_id int(11) NOT NULL auto_increment,
1461 option_type_name varchar(255) NOT NULL default '',
1462 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1463 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1464 PRIMARY KEY (option_type_id)
1465)
1466Invalid default value for 'date_time_created'
1467
1468Inserting Data into: tbl_option_type ...
1469INSERT INTO tbl_option_type (option_type_id, option_type_name, date_time_created, date_time_modified) VALUES (1,'Drop Down','2004-04-13 15:46:17','2004-04-13 15:46:17'),(2,'Radio Buttons','2004-04-13 15:46:29','2004-04-13 15:46:29'),(5,'Text','2004-04-13 15:46:33','2004-04-13 15:46:33'),(4,'Memo','2004-04-13 15:46:39','2004-04-13 15:46:39'),(3,'Checkboxes','2004-04-13 15:46:44','2004-04-13 15:46:44'),(6,'Price','2004-09-07 11:19:25','2004-09-07 11:19:25')
1470Table 'cartkeeper.tbl_option_type' doesn't exist
1471
1472
1473Creating table: tbl_order ...
1474CREATE TABLE tbl_order (
1475 order_id int(11) NOT NULL auto_increment,
1476 user_id int(11) default '0',
1477 order_key varchar(255) default NULL,
1478 billing_id int(11) default NULL,
1479 status_id int(11) default NULL,
1480 payment_type_id int(11) NOT NULL default '0',
1481 order_subtotal decimal(9,2) default NULL,
1482 order_shipping_cost decimal(9,2) default NULL,
1483 order_tax decimal(9,2) default NULL,
1484 order_tax_pct decimal(5,3) default NULL,
1485 shipping_first_name varchar(255) default NULL,
1486 shipping_last_name varchar(255) default NULL,
1487 shipping_company_name varchar(255) default NULL,
1488 shipping_address_1 varchar(255) default NULL,
1489 shipping_address_2 varchar(255) default NULL,
1490 shipping_city varchar(255) default NULL,
1491 shipping_state_name varchar(255) default NULL,
1492 shipping_postal_code varchar(255) default NULL,
1493 shipping_country_id int(11) default NULL,
1494 shipping_phone varchar(255) default NULL,
1495 shipping_alt_phone varchar(255) default NULL,
1496 voucher_id int(11) default NULL,
1497 voucher_code varchar(255) default NULL,
1498 voucher_amount decimal(9,2) default NULL,
1499 voucher_free_shipping tinyint(4) default NULL,
1500 voucher_apply_before_shipping tinyint(4) default NULL,
1501 voucher_apply_before_taxes tinyint(4) default NULL,
1502 voucher_percentage int(11) default NULL,
1503 shipping_fax varchar(255) default NULL,
1504 order_total decimal(9,2) default NULL,
1505 order_quantity decimal(7,2) default NULL,
1506 order_first_name varchar(255) NOT NULL default '',
1507 order_last_name varchar(255) default NULL,
1508 order_company_name varchar(255) default NULL,
1509 order_email varchar(255) default NULL,
1510 order_instructions mediumtext,
1511 order_notes mediumtext,
1512 order_address_1 varchar(255) NOT NULL default '',
1513 order_address_2 varchar(255) default NULL,
1514 order_city varchar(255) NOT NULL default '',
1515 order_state_name varchar(255) NOT NULL default '',
1516 order_postal_code varchar(255) NOT NULL default '',
1517 country_id int(11) NOT NULL default '0',
1518 order_phone varchar(255) NOT NULL default '',
1519 order_alt_phone varchar(255) default NULL,
1520 order_fax varchar(255) default NULL,
1521 order_cc_no tinyblob,
1522 order_cc_exp_month int(11) default '0',
1523 order_cc_exp_year int(11) default '0',
1524 additional_payment_data varchar(255) default NULL,
1525 http_referer varchar(255) default NULL,
1526 gift_certificate_id int(11) default NULL,
1527 gift_certificate_amount_used decimal(9,2) default NULL,
1528 google_order_number varchar(255) default NULL,
1529 order_cc_type_id int(11) default NULL,
1530 order_cc_cvvs varchar(255) default NULL,
1531 order_ip_address varchar(255) default NULL,
1532 order_ship_method varchar(255) default NULL,
1533 tracking varchar(255) default NULL,
1534 tracking_url varchar(255) default NULL,
1535 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1536 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1537 PRIMARY KEY (order_id),
1538 KEY user_id_idx (user_id),
1539 KEY google_order_number_idx (google_order_number),
1540 KEY order_key_idx (order_key)
1541)
1542Invalid default value for 'date_time_created'
1543
1544
1545Creating table: tbl_order_item ...
1546CREATE TABLE tbl_order_item (
1547 order_item_id int(11) NOT NULL auto_increment,
1548 order_id int(11) NOT NULL default '0',
1549 item_id int(11) NOT NULL default '0',
1550 cart_id int(11) default NULL,
1551 manufacturer varchar(255) default NULL,
1552 order_item_price decimal(9,2) NOT NULL default '0.00',
1553 order_item_category_name varchar(255) default NULL,
1554 order_item_name varchar(255) NOT NULL,
1555 order_item_code varchar(255) NOT NULL,
1556 order_item_mfg_code varchar(255) default NULL,
1557 wishlist_id int(11) default NULL,
1558 quantity_discount_type varchar(255) default NULL,
1559 quantity_discount_amount decimal(9,2) default NULL,
1560 quantity_discount_pct decimal(5,2) default NULL,
1561 order_item_quantity decimal(5,2) NOT NULL default '0.00',
1562 order_item_discount decimal(4,2) default NULL,
1563 order_item_extended_price decimal(9,2) NOT NULL default '0.00',
1564 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1565 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1566 PRIMARY KEY (order_item_id),
1567 KEY order_id_idx (order_id),
1568 KEY item_id_idx (item_id)
1569)
1570Invalid default value for 'date_time_created'
1571
1572
1573Creating table: tbl_order_item_option ...
1574CREATE TABLE tbl_order_item_option (
1575 order_item_option_id int(11) NOT NULL auto_increment,
1576 order_item_id int(11) NOT NULL default '0',
1577 cart_option_id int(11) default NULL,
1578 option_id int(11) NOT NULL default '0',
1579 option_attribute_id int(11) NOT NULL default '0',
1580 option_name varchar(255) NOT NULL default '',
1581 order_attribute_name varchar(255) NOT NULL default '',
1582 order_attribute_price decimal(9,2) NOT NULL default '0.00',
1583 order_attribute_ship decimal(8,2) NOT NULL default '0.00',
1584 order_attribute_text mediumtext,
1585 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1586 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1587 PRIMARY KEY (order_item_option_id),
1588 KEY order_item_id_idx (order_item_id),
1589 KEY option_id_idx (option_id),
1590 KEY attribute_id_idx (option_attribute_id)
1591)
1592Invalid default value for 'date_time_created'
1593
1594
1595Creating table: tbl_order_question_answer ...
1596CREATE TABLE tbl_order_question_answer (
1597 order_question_answer_id int(11) NOT NULL auto_increment,
1598 question_id int(11) NOT NULL default '0',
1599 answer_id int(11) default '0',
1600 order_id int(11) NOT NULL default '0',
1601 answer_text mediumtext,
1602 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1603 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1604 PRIMARY KEY (order_question_answer_id),
1605 KEY question_id_idx (question_id),
1606 KEY order_id_idx (order_id)
1607)
1608Invalid default value for 'date_time_created'
1609
1610
1611Creating table: tbl_order_status ...
1612CREATE TABLE tbl_order_status (
1613 status_id int(11) NOT NULL auto_increment,
1614 status_description varchar(255) NOT NULL default '',
1615 plain_header mediumtext,
1616 html_header mediumtext,
1617 plain_footer mediumtext,
1618 html_footer mediumtext,
1619 email_subject varchar(255) default NULL,
1620 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1621 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1622 PRIMARY KEY (status_id)
1623)
1624Invalid default value for 'date_time_created'
1625
1626Inserting Data into: tbl_order_status ...
1627INSERT INTO tbl_order_status (status_id, status_description, plain_header, html_header, plain_footer, html_footer, email_subject, date_time_created, date_time_modified) VALUES (1,'New','Thank you for your order. Please review the details below.','
1628Thank you for your order. Please review the details below.
1629
1630','We appreciate your patronage. If you should have any questions please contact us at info@domain.com - please reference your order number in all correspondence.\r\nThank you!','
1631We appreciate your patronage. If you should have any questions please contact us at info@domain.com - please reference your order number in all correspondence. Thank you!
1632
1633','New Order','2004-06-16 11:17:15','2005-06-17 07:32:24'),(4,'Shipped','We thought you\'d like to know your order has shipped!','
1634We thought you\'d like to know your order has shipped!
1635
1636','If you have any questions about your order please contact us at user@domain.com Be sure to include your order number in all correspondence.\r\nThank you!','
1637If you have any questions about your order please contact us at user@domain.com
1638\r\nBe sure to include your order number in all correspondence.
1639\r\nThank you!
1640
1641','Your Order Has Shipped','2004-06-16 11:18:21','2005-09-27 08:09:12')
1642Table 'cartkeeper.tbl_order_status' doesn't exist
1643
1644
1645Creating table: tbl_payment ...
1646CREATE TABLE tbl_payment (
1647 payment_id int(11) NOT NULL auto_increment,
1648 order_id int(11) NOT NULL default '0',
1649 payment_type_id int(11) NOT NULL default '0',
1650 payment_status_id int(11) default NULL,
1651 auth_amount decimal(9,2) NOT NULL default '0.00',
1652 amount decimal(9,2) NOT NULL default '0.00',
1653 check_number int(11) default NULL,
1654 paypal_txn_type varchar(255) default NULL,
1655 paypal_first_name varchar(255) default NULL,
1656 paypal_last_name varchar(255) default NULL,
1657 paypal_payer_email varchar(255) default NULL,
1658 paypal_payment_type varchar(255) default NULL,
1659 paypal_payer_status varchar(255) default NULL,
1660 paypal_txn_id varchar(255) default NULL,
1661 paypal_payment_gross decimal(9,2) default NULL,
1662 paypal_mc_currency varchar(255) default NULL,
1663 paypal_verify_sign varchar(255) default NULL,
1664 paypal_item_name varchar(255) default NULL,
1665 paypal_payer_id varchar(255) default NULL,
1666 response_code int(11) NOT NULL default '0',
1667 response_sub_code int(11) NOT NULL default '0',
1668 response_reason_code int(11) NOT NULL default '0',
1669 response_reason_text varchar(255) NOT NULL default '',
1670 approval_code varchar(255) NOT NULL default '',
1671 avs_code varchar(255) NOT NULL default '',
1672 transaction_id varchar(255) NOT NULL default '',
1673 hash varchar(255) default NULL,
1674 cvv_response_code varchar(255) default NULL,
1675 cavv_response_code varchar(255) default NULL,
1676 transaction_date_stamp int(11) default NULL,
1677 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1678 paypal_receiver_id varchar(255) default NULL,
1679 paypal_receiver_email varchar(255) default NULL,
1680 paypal_payment_fee decimal(9,2) default NULL,
1681 paypal_payment_date varchar(255) default NULL,
1682 paypal_memo mediumtext,
1683 paypal_custom varchar(255) default NULL,
1684 paypal_mc_fee decimal(9,2) default NULL,
1685 paypal_mc_gross decimal(9,2) default NULL,
1686 other_data mediumtext,
1687 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1688 PRIMARY KEY (payment_id),
1689 KEY order_id_idx (order_id)
1690)
1691Invalid default value for 'date_time_created'
1692
1693
1694Creating table: tbl_payment_gateway ...
1695CREATE TABLE tbl_payment_gateway (
1696 payment_gateway_id int(11) NOT NULL auto_increment,
1697 payment_gateway varchar(255) NOT NULL default '',
1698 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1699 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1700 PRIMARY KEY (payment_gateway_id)
1701)
1702Invalid default value for 'date_time_created'
1703
1704Inserting Data into: tbl_payment_gateway ...
1705INSERT INTO tbl_payment_gateway (payment_gateway_id, payment_gateway, date_time_created, date_time_modified) VALUES (1,'NONE','2005-04-07 13:03:10','2005-04-07 13:03:10'),(2,'Authorize.net','2005-04-07 13:03:22','2005-04-07 13:03:22'),(3,'Linkpoint Select API','2005-04-07 13:03:49','2005-04-07 13:03:49'),(4,'TrustCommerce HTTPS POST','2005-05-16 11:40:09','2005-05-16 11:40:09'),(5,'Paypal Website Payments Pro','2005-09-01 00:00:00','2005-09-01 00:00:00'),(6,'ViaKLIX','2006-04-12 15:51:34','2006-04-12 15:51:34'),(9,'USA ePay','2008-03-12 12:00:20','2008-03-12 12:00:20'),(7,'SkipJack','2007-05-31 14:15:16','2007-05-31 14:15:16'),(8,'FastCharge','2007-05-31 14:15:16','2007-05-31 14:15:16'),(14,'Moneris eSelect Plus','2008-03-12 12:02:55','2008-03-12 12:02:55'),(15,'eWay','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'Innovative','2008-09-16 15:08:43','2008-09-16 15:08:43'),(16,'Paypal Website Payments Pro (UK)','2008-06-10 11:30:29','2008-06-10 11:30:29'),(17,'Nochex','2008-06-24 16:11:40','2008-06-24 16:11:40'),(18,'Network Merchants','2008-06-30 14:37:08','2008-06-30 14:37:08')
1706Table 'cartkeeper.tbl_payment_gateway' doesn't exist
1707
1708
1709Creating table: tbl_payment_status ...
1710CREATE TABLE tbl_payment_status (
1711 payment_status_id int(11) NOT NULL auto_increment,
1712 payment_status varchar(255) NOT NULL default '',
1713 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1714 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1715 PRIMARY KEY (payment_status_id)
1716)
1717Invalid default value for 'date_time_created'
1718
1719Inserting Data into: tbl_payment_status ...
1720INSERT INTO tbl_payment_status (payment_status_id, payment_status, date_time_created, date_time_modified) VALUES (1,'CC Authorized','2004-09-02 15:56:19','2004-09-02 15:56:19'),(2,'CC Declined','2004-09-02 15:56:24','2004-09-02 15:56:24'),(3,'CC Error','2004-09-02 15:56:29','2004-09-02 15:56:29'),(4,'CC Captured','2004-09-02 16:04:05','2004-09-02 16:04:05'),(5,'CC Voided','2004-09-02 16:04:08','2004-09-02 16:04:08'),(6,'Check Received','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'PayPal Started','2004-11-19 16:05:43','2004-11-19 16:05:43'),(8,'PayPal Completed','2004-11-19 16:06:04','2004-11-19 16:06:15'),(9,'PayPal INVALID','2004-11-19 16:06:39','2005-03-09 06:21:49'),(10,'Marked Paid','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'PayPal Refunded','2005-02-18 03:49:36','2005-02-18 03:49:36'),(12,'PayPal Denied','2005-02-18 03:59:01','2005-02-18 03:59:01'),(13,'PayPal Failed','2005-02-18 04:01:21','2005-02-18 04:01:21'),(14,'PayPal Pending','2005-02-18 04:03:05','2005-02-18 04:03:05'),(15,'PayPal Reversed','2005-02-18 04:17:39','2005-02-18 04:17:39'),(16,'PayPal Canceled_Reversal','2005-02-18 04:19:11','2005-03-09 06:24:27'),(17,'Google Checkout CHARGED','2007-10-03 10:20:07','2007-10-03 10:20:07')
1721Table 'cartkeeper.tbl_payment_status' doesn't exist
1722
1723
1724Creating table: tbl_payment_type ...
1725CREATE TABLE tbl_payment_type (
1726 payment_type_id int(11) NOT NULL auto_increment,
1727 payment_description varchar(255) NOT NULL default '',
1728 collect_info tinyint(4) default NULL,
1729 accepted tinyint(4) default NULL,
1730 internal_only tinyint(4) default NULL,
1731 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1732 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1733 PRIMARY KEY (payment_type_id)
1734)
1735Invalid default value for 'date_time_created'
1736
1737Inserting Data into: tbl_payment_type ...
1738INSERT INTO tbl_payment_type (payment_type_id, payment_description, collect_info, accepted, internal_only, date_time_created, date_time_modified) VALUES (1,'Credit Card',NULL,1,NULL,'2004-06-17 12:18:25','2004-06-17 12:18:25'),(2,'Check',NULL,1,NULL,'2004-06-17 12:18:47','2004-06-17 12:18:47'),(3,'PayPal',0,0,NULL,'2004-11-19 16:03:25','2004-11-19 16:03:25'),(6,'Invoice',1,0,NULL,'2007-05-01 17:56:32','2007-05-01 17:56:32'),(5,'Gift Certificate',0,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'Google Checkout',0,0,1,'2007-09-14 12:01:58','2007-09-14 12:01:58'),(7,'Credit Card (ProTx VSP Form)',0,0,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'Credit Card (Mals-e)',0,0,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(50,'eCheck',0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00')
1739Table 'cartkeeper.tbl_payment_type' doesn't exist
1740
1741
1742Creating table: tbl_session ...
1743CREATE TABLE tbl_session (
1744 session_id int(11) NOT NULL auto_increment,
1745 unique_session_id varchar(255) NOT NULL default '',
1746 user_id int(11) default NULL,
1747 items_in_cart decimal(8,2) default '0.00',
1748 cart_total decimal(9,2) default '0.00',
1749 original_total decimal(9,2) default NULL,
1750 estimated_total decimal(9,2) default NULL,
1751 cart_ship_method_id int(11) default NULL,
1752 cart_shipping_zip varchar(255) default NULL,
1753 cart_shipping_country varchar(255) default NULL,
1754 shipping_id int(11) default NULL,
1755 billing_id int(11) default NULL,
1756 order_id int(11) default NULL,
1757 order_complete tinyint(4) default NULL,
1758 state_id int(11) default NULL,
1759 voucher_id int(11) default NULL,
1760 gift_certificate_id int(11) default NULL,
1761 is_wholesaler tinyint(4) default NULL,
1762 cart_usps_insurance tinyint(4) default '0',
1763 cart_ups_insurance tinyint(4) default '0',
1764 http_referer varchar(255) default NULL,
1765 pwpp_token varchar(255) default NULL,
1766 pwpp_payer_id varchar(255) default NULL,
1767 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1768 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1769 PRIMARY KEY (session_id),
1770 KEY unique_session_id_idx (unique_session_id)
1771)
1772Invalid default value for 'date_time_created'
1773
1774Inserting Data into: tbl_session ...
1775INSERT INTO tbl_session (session_id, unique_session_id, user_id, items_in_cart, cart_total, original_total, estimated_total, cart_ship_method_id, cart_shipping_zip, cart_shipping_country, shipping_id, billing_id, order_id, order_complete, state_id, voucher_id, gift_certificate_id, is_wholesaler, cart_usps_insurance, cart_ups_insurance, http_referer, pwpp_token, pwpp_payer_id, date_time_created, date_time_modified) VALUES (1,'81ca5e7e0884fa732ecd128d4971f011',NULL,'0.00','0.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'',NULL,NULL,'2010-12-01 17:24:02','2010-12-01 17:24:02')
1776Table 'cartkeeper.tbl_session' doesn't exist
1777
1778
1779Creating table: tbl_ship_method ...
1780CREATE TABLE tbl_ship_method (
1781 ship_method_id int(11) NOT NULL auto_increment,
1782 ship_method_name varchar(255) NOT NULL default '',
1783 ship_method_value varchar(255) default NULL,
1784 ship_method_active tinyint(4) NOT NULL default '1',
1785 ship_method_max_weight int(11) default NULL,
1786 this_country_only int(11) default NULL,
1787 not_this_country int(11) default NULL,
1788 sequence int(11) default NULL,
1789 free_shipping_threshold decimal(9,2) default NULL,
1790 ship_method_type_id int(11) NOT NULL default '0',
1791 base_ship_cost decimal(9,2) NOT NULL default '0.00',
1792 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1793 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1794 PRIMARY KEY (ship_method_id)
1795)
1796Invalid default value for 'date_time_created'
1797
1798Inserting Data into: tbl_ship_method ...
1799INSERT INTO tbl_ship_method (ship_method_id, ship_method_name, ship_method_value, ship_method_active, ship_method_max_weight, this_country_only, not_this_country, sequence, free_shipping_threshold, ship_method_type_id, base_ship_cost, date_time_created, date_time_modified) VALUES (1,'UPS Next Day Air','1DA',1,NULL,762,NULL,NULL,NULL,7,'0.00','2004-11-06 14:51:17','2007-05-10 13:49:03'),(2,'UPS 2nd Day Air','2DA',1,NULL,762,NULL,NULL,NULL,7,'0.00','2004-11-06 14:51:39','2007-05-10 13:49:03'),(3,'UPS Ground','GND',1,NULL,762,NULL,NULL,NULL,7,'0.00','2004-11-06 14:52:02','2007-06-05 16:28:49'),(4,'UPS Canada Standard','STD',1,NULL,106,NULL,NULL,NULL,7,'0.00','2004-11-06 15:24:49','2007-05-10 13:49:03'),(5,'UPS Worldwide Express','XPR',1,NULL,NULL,762,NULL,NULL,7,'0.00','2004-11-06 15:25:14','2007-05-10 13:49:03'),(6,'UPS Next Day Air Early AM','1DM',1,NULL,762,NULL,NULL,NULL,7,'0.00','2004-12-03 13:09:11','2007-09-19 14:53:25'),(7,'UPS Next Day Air Saver','1DP',1,NULL,762,NULL,NULL,NULL,7,'0.00','2004-12-03 13:10:00','2007-05-10 13:49:03'),(8,'UPS 2nd Day Air AM','2DM',1,NULL,762,NULL,NULL,NULL,7,'0.00','2004-12-03 13:10:36','2007-09-19 14:53:25'),(9,'UPS 3 Day Select','3DS',1,NULL,762,NULL,NULL,NULL,7,'0.00','2004-12-03 13:11:27','2007-05-10 13:49:03'),(10,'UPS Worldwide Express Plus','XDM',1,NULL,NULL,762,NULL,NULL,7,'0.00','2004-12-03 13:12:35','2007-05-10 13:49:03'),(11,'UPS Worldwide Express Expedited','XPD',1,NULL,NULL,762,NULL,NULL,7,'0.00','2004-12-03 13:12:57','2007-05-10 13:49:03'),(12,'USPS Express Mail','Express Mail',1,1120,762,NULL,NULL,NULL,6,'0.00','2004-12-03 13:14:44','2007-09-19 12:28:56'),(13,'USPS Priority Mail','Priority Mail',1,1120,762,NULL,NULL,NULL,6,'0.00','2004-12-03 13:15:10','2007-09-19 12:28:56'),(14,'USPS Parcel Post','Parcel Post',1,1120,762,NULL,NULL,NULL,6,'0.00','2004-12-03 13:15:24','2007-09-19 12:28:56'),(33,'USPS Global Express Guaranteed Non-Doc. Rect','Global Express Guaranteed Non-Document Rectangular',1,64,NULL,762,NULL,NULL,6,'0.00','0000-00-00 00:00:00','2007-05-14 17:35:00'),(16,'USPS Express Mail International','Express Mail International',1,1056,NULL,762,NULL,NULL,6,'0.00','2004-12-03 13:17:11','2007-05-14 17:04:56'),(17,'USPS Global Express Guaranteed','Global Express Guaranteed Non-Document Rectangular',1,1120,NULL,762,NULL,NULL,6,'0.00','2004-12-03 13:17:38','2007-05-10 13:49:03'),(22,'USPS Priority Mail International','Priority Mail International',1,1056,NULL,762,NULL,NULL,6,'0.00','2005-02-16 05:54:20','2007-05-18 12:35:36'),(23,'USPS First-Class Mail International','First-Class Mail International Package',1,64,NULL,762,NULL,NULL,6,'0.00','2005-02-16 05:54:39','2007-05-18 12:35:36'),(24,'USPS Priority Mail Intl. Flat Rate Envelope','Priority Mail International Flat-Rate Envelope',1,64,NULL,762,NULL,NULL,6,'0.00','2005-02-16 05:55:09','2007-05-14 17:10:52'),(25,'USPS Express Mail Intl. Flat Rate Envelope','Express Mail International Flat-Rate Envelope',1,64,NULL,762,NULL,NULL,6,'0.00','2005-02-16 05:55:25','2007-05-14 17:10:04'),(26,'USPS Bound Printed Matter','Bound Printed Matter',1,240,762,NULL,NULL,NULL,6,'0.00','2005-02-16 06:33:01','2007-09-19 12:55:41'),(27,'free',NULL,1,NULL,762,NULL,NULL,NULL,1,'0.00','2005-04-18 14:06:36','2007-09-19 14:50:44'),(29,'Standard Flat Rate',NULL,1,NULL,762,NULL,NULL,NULL,2,'1.00','2005-09-25 03:33:11','2005-09-25 03:33:11'),(32,'USPS Media Mail','Media Mail',1,240,762,NULL,NULL,NULL,6,'0.00','2007-05-05 15:08:01','2007-09-19 12:29:19'),(34,'USPS Global Express Guaranteed Non-Doc. Non-Rect.','Global Express Guaranteed Non-Document Non-Rectangular',1,64,NULL,762,NULL,NULL,6,'0.00','0000-00-00 00:00:00','2007-05-14 17:35:00'),(35,'USPS Priority Mail Intl. Flat Rate Box (Med)','Priority Mail International Regular/Medium Flat-Rate Boxes',1,320,NULL,762,NULL,NULL,6,'0.00','0000-00-00 00:00:00','2009-11-05 15:14:09'),(44,'USPS Estimated','',1,NULL,762,NULL,NULL,NULL,4,'3.40','2008-12-10 10:58:53','2009-11-05 15:14:09'),(45,'FedEx 2 Day','FEDEX_2_DAY',0,NULL,762,NULL,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(46,'FedEx Express Saver','FEDEX_EXPRESS_SAVER',0,NULL,762,NULL,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(47,'FedEx Ground','FEDEX_GROUND',0,NULL,762,NULL,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(48,'FedEx First Overnight','FIRST_OVERNIGHT',0,NULL,762,NULL,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(49,'FedEx Priority Overnight','PRIORITY_OVERNIGHT',0,NULL,762,NULL,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(50,'FedEx Standard Overnight','STANDARD_OVERNIGHT',0,NULL,762,NULL,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(51,'FedEx International Economy','INTERNATIONAL_ECONOMY',0,NULL,NULL,762,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(52,'FedEx International First','INTERNATIONAL_FIRST',0,NULL,NULL,762,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(53,'FedEx Priority','INTERNATIONAL_PRIORITY',0,NULL,NULL,762,NULL,NULL,9,'0.00','2009-04-29 16:05:52','2009-12-18 10:37:15'),(54,'USPS Priority Mail Intl. Flat Rate Box (Small)','Priority Mail International Small Flat-Rate Box',1,64,NULL,762,NULL,NULL,6,'0.00','2009-06-27 14:02:18','2009-11-05 15:14:09'),(55,'USPS Priority Mail Intl. Flat Rate Box (Large)','Priority Mail International Large Flat-Rate Box',1,320,NULL,762,NULL,NULL,6,'0.00','2009-06-27 14:02:18','2009-11-05 15:14:09'),(56,'USPS Priority Mail Flat-Rate Envelope','Priority Mail Flat-Rate Envelope',1,64,762,NULL,NULL,NULL,6,'0.00','2009-06-27 14:08:43','2009-11-05 15:14:09'),(57,'USPS Priority Mail Small Flat Rate Box','Priority Mail Small Flat Rate Box',1,64,762,NULL,NULL,NULL,6,'0.00','2009-06-27 14:08:43','2009-11-05 15:14:09'),(58,'USPS Priority Mail Medium Flat Rate Box','Priority Mail Regular/Medium Flat Rate Boxes',1,320,762,NULL,NULL,NULL,6,'0.00','2009-06-27 14:08:43','2009-11-05 15:14:09'),(59,'USPS Priority Mail Large Flat Rate Box','Priority Mail Large Flat Rate Box',1,320,762,NULL,NULL,NULL,6,'0.00','2009-06-27 14:08:43','2009-11-05 15:14:09'),(60,'USPS First Class Mail Package','First-Class Mail Package',1,14,762,NULL,NULL,NULL,6,'0.00','2009-08-15 12:50:58','2009-11-05 15:14:09'),(61,'USPS First Class Mail Letter','First-Class Mail Flat',1,3,762,NULL,NULL,NULL,6,'0.00','2009-08-15 12:51:45','2009-11-05 15:14:09')
1800Table 'cartkeeper.tbl_ship_method' doesn't exist
1801
1802
1803Creating table: tbl_ship_method_type ...
1804CREATE TABLE tbl_ship_method_type (
1805 ship_method_type_id int(11) NOT NULL auto_increment,
1806 method_type varchar(255) NOT NULL default '',
1807 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1808 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1809 PRIMARY KEY (ship_method_type_id)
1810)
1811Invalid default value for 'date_time_created'
1812
1813Inserting Data into: tbl_ship_method_type ...
1814INSERT INTO tbl_ship_method_type (ship_method_type_id, method_type, date_time_created, date_time_modified) VALUES (1,'Flat Rate','2004-06-01 11:26:50','2004-06-01 11:26:50'),(2,'By total cost of order','2004-06-01 11:29:46','2004-06-01 11:32:03'),(3,'By # of items in order','2004-06-01 11:30:36','2004-06-01 11:32:23'),(4,'By total weight of order','2004-06-01 11:30:50','2004-06-01 11:32:35'),(5,'By total volume of order','2004-06-01 11:31:02','2004-06-01 11:31:02'),(6,'USPS Shipping Calculator','2004-08-11 15:54:29','2004-08-11 15:54:29'),(7,'UPS Shipping Calculator','2004-11-06 12:07:39','2004-11-06 12:07:39'),(8,'Shipping Quote','2005-01-04 03:40:06','2005-01-04 03:40:06'),(9,'FedEx Shipping Calculator','2009-04-29 15:26:33','2009-04-29 15:26:33')
1815Table 'cartkeeper.tbl_ship_method_type' doesn't exist
1816
1817
1818Creating table: tbl_ship_range ...
1819CREATE TABLE tbl_ship_range (
1820 ship_range_id int(11) NOT NULL auto_increment,
1821 ship_method_id int(11) NOT NULL default '0',
1822 low_range decimal(7,2) default NULL,
1823 high_range decimal(7,2) default NULL,
1824 cost decimal(9,2) NOT NULL default '0.00',
1825 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1826 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1827 PRIMARY KEY (ship_range_id)
1828)
1829Invalid default value for 'date_time_created'
1830
1831Inserting Data into: tbl_ship_range ...
1832INSERT INTO tbl_ship_range (ship_range_id, ship_method_id, low_range, high_range, cost, date_time_created, date_time_modified) VALUES (13,29,'20.00','35.00','10.00','2005-09-25 03:43:22','2005-09-25 03:43:22'),(12,29,'10.00','19.99','7.50','2005-09-25 03:43:01','2005-09-25 03:43:01'),(11,29,'0.00','9.99','5.00','2005-09-25 03:42:32','2005-09-25 03:42:32'),(9,19,'0.00',NULL,'20.00','2005-01-18 01:44:27','2005-01-18 01:44:27'),(14,29,'35.01',NULL,'15.00','2005-09-25 03:45:17','2005-09-25 03:45:17')
1833Table 'cartkeeper.tbl_ship_range' doesn't exist
1834
1835
1836Creating table: tbl_shipping ...
1837CREATE TABLE tbl_shipping (
1838 shipping_id int(11) NOT NULL auto_increment,
1839 user_id int(11) NOT NULL default '0',
1840 shipping_first_name varchar(255) NOT NULL default '',
1841 shipping_last_name varchar(255) NOT NULL default '',
1842 shipping_company_name varchar(255) default NULL,
1843 shipping_address_1 varchar(255) NOT NULL default '',
1844 shipping_address_2 varchar(255) NOT NULL default '',
1845 shipping_city varchar(255) NOT NULL default '',
1846 state_id int(11) default '0',
1847 shipping_state_province varchar(255) default NULL,
1848 shipping_postal_code varchar(255) NOT NULL default '',
1849 shipping_phone varchar(255) NOT NULL default '',
1850 shipping_alt_phone varchar(255) default NULL,
1851 shipping_fax varchar(255) NOT NULL default '',
1852 country_id int(11) NOT NULL default '0',
1853 shipping_default tinyint(4) default '0',
1854 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1855 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1856 PRIMARY KEY (shipping_id),
1857 KEY user_idx (user_id)
1858)
1859Invalid default value for 'date_time_created'
1860
1861
1862Creating table: tbl_shipping_calculator_control ... success! Inserting Data into: tbl_shipping_calculator_control ... success!
1863Creating table: tbl_state ...
1864CREATE TABLE tbl_state (
1865 state_id int(11) NOT NULL auto_increment,
1866 name varchar(255) NOT NULL default '',
1867 code varchar(255) NOT NULL default '',
1868 tax_rate decimal(5,3) default NULL,
1869 country_id int(11) default '0',
1870 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1871 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1872 PRIMARY KEY (state_id)
1873)
1874Invalid default value for 'date_time_created'
1875
1876Inserting Data into: tbl_state ...
1877INSERT INTO tbl_state (state_id, name, code, tax_rate, country_id, date_time_created, date_time_modified) VALUES (1,'Alabama','AL',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'Alaska','AK',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'American Samoa','AS',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'Arizona','AZ',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'Arkansas','AR',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'California','CA',NULL,1,'0000-00-00 00:00:00','2004-06-03 16:40:21'),(7,'Colorado','CO',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'Connecticut','CT',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'Delaware','DE',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'District Of Columbia','DC',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'Federated States Of Micronesia','FM',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,'Florida','FL',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,'Georgia','GA',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,'Guam','GU',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(15,'Hawaii','HI',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,'Idaho','ID',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'Illinois','IL',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'Indiana','IN',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,'Iowa','IA',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,'Kansas','KS',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,'Kentucky','KY',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,'Louisiana','LA',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,'Maine','ME',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,'Marshall Islands','MH',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'Maryland','MD',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'Massachusetts','MA',NULL,1,'0000-00-00 00:00:00','2005-07-12 05:41:51'),(27,'Michigan','MI',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,'Minnesota','MN',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(29,'Mississippi','MS',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,'Missouri','MO',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,'Montana','MT',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,'Nebraska','NE',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,'Nevada','NV',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,'New Hampshire','NH',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,'New Jersey','NJ',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,'New Mexico','NM',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(37,'New York','NY',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(38,'North Carolina','NC',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(39,'North Dakota','ND',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(40,'Northern Mariana Islands','MP',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(41,'Ohio','OH',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(42,'Oklahoma','OK',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(43,'Oregon','OR',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(44,'Palau','PW',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,'Pennsylvania','PA',NULL,1,'0000-00-00 00:00:00','2004-08-14 11:14:22'),(46,'Puerto Rico','PR',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(47,'Rhode Island','RI',NULL,1,'0000-00-00 00:00:00','2004-08-30 14:37:38'),(48,'South Carolina','SC',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(49,'South Dakota','SD',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(50,'Tennessee','TN',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(51,'Texas','TX',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(52,'Utah','UT',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(53,'Vermont','VT',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(54,'Virgin Islands','VI',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(55,'Virginia','VA',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(56,'Washington','WA',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(57,'West Virginia','WV',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(58,'Wisconsin','WI',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(59,'Wyoming','WY',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(60,'Alberta','AB',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(61,'British Columbia','BC',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(62,'Manitoba','MB',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(63,'New Brunswick','NB',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(64,'Newfoundland and Labrador','NL',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(65,'Northwest Territories','NT',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(66,'Nova Scotia','NS',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(67,'Nunavut','NU',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(68,'Ontario','ON',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(69,'Prince Edward Island','PE',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(70,'Quebec','QC',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(71,'Saskatchewan','SK',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(72,'Yukon Territory','YT',NULL,2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(73,'Outside The US','OT',NULL,0,'2004-06-30 10:20:52','2004-06-30 10:20:52'),(74,' Outside North America','XX',NULL,0,'2005-01-04 03:21:52','2005-01-04 03:23:34')
1878Table 'cartkeeper.tbl_state' doesn't exist
1879
1880
1881Creating table: tbl_system ...
1882CREATE TABLE tbl_system (
1883 system_id int(11) NOT NULL auto_increment,
1884 site_description varchar(255) NOT NULL default '',
1885 site_email varchar(255) NOT NULL default '',
1886 admin_email varchar(255) NOT NULL default '',
1887 admin_password varchar(255) default NULL,
1888 site_domain varchar(255) NOT NULL default '',
1889 site_path_prefix varchar(255) default NULL,
1890 ssl_domain varchar(255) default NULL,
1891 ssl_path_prefix varchar(255) default NULL,
1892 home_page varchar(255) NOT NULL default '',
1893 behavior_id int(11) NOT NULL default '0',
1894 email_method enum('multipart','plaintext') default NULL,
1895 template_id int(11) NOT NULL default '0',
1896 category_script_name varchar(255) NOT NULL default '',
1897 item_script_name varchar(255) NOT NULL default '',
1898 smtp_server varchar(255) NOT NULL default '',
1899 web_get_method enum('cURL','url_fopen') default NULL,
1900 smtp_username varchar(255) default NULL,
1901 smtp_password varchar(255) default NULL,
1902 debug tinyint(4) default '0',
1903 blank_options int(11) default NULL,
1904 blank_option_attributes int(11) default NULL,
1905 item_select tinyint(4) default NULL,
1906 num_search_results int(11) default NULL,
1907 admin_nav_type enum('left','top') default NULL,
1908 admin_home_page enum('Dashboard','Items','Orders') default NULL,
1909 wysiwyg tinyint(4) default NULL,
1910 wysiwyg_image_path varchar(255) default NULL,
1911 wysiwyg_toolbar enum('Full','Medium','Basic') default NULL,
1912 wysiwyg_display enum('inline','popup') default NULL,
1913 design_wall_enabled tinyint(4) default NULL,
1914 purge_carts_days int(11) default NULL,
1915 purge_sessions_hours int(11) default NULL,
1916 purge_users_months int(11) default NULL,
1917 purge_wishlist int(11) default NULL,
1918 erase_cc_info_order_status_id int(11) default NULL,
1919 cc_data_purge tinyint(4) default NULL,
1920 purge_level enum('Entire Billing Record','CVVS only','All Credit Card Data') default NULL,
1921 split_card_data tinyint(4) default NULL,
1922 system_version decimal(9,2) default NULL,
1923 secret_key varchar(255) default NULL,
1924 passwd_reset_key varchar(255) default NULL,
1925 license_key varchar(255) default NULL,
1926 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1927 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1928 PRIMARY KEY (system_id)
1929)
1930Invalid default value for 'date_time_created'
1931
1932Inserting Data into: tbl_system ...
1933INSERT INTO tbl_system (system_id, site_description, site_email, admin_email, admin_password, site_domain, site_path_prefix, ssl_domain, ssl_path_prefix, home_page, behavior_id, email_method, template_id, category_script_name, item_script_name, smtp_server, web_get_method, smtp_username, smtp_password, debug, blank_options, blank_option_attributes, item_select, num_search_results, admin_nav_type, admin_home_page, wysiwyg, wysiwyg_image_path, wysiwyg_toolbar, wysiwyg_display, design_wall_enabled, purge_carts_days, purge_sessions_hours, purge_users_months, purge_wishlist, erase_cc_info_order_status_id, cc_data_purge, purge_level, split_card_data, system_version, secret_key, passwd_reset_key, license_key, date_time_created, date_time_modified) VALUES (1,'Init','','','','','','','','index.php',5,'multipart',1,'category.php','item.php','localhost','url_fopen',NULL,NULL,0,3,4,1,12,'left','Dashboard',1,'/images','Medium','popup',0,1,8,6,6,4,1,'CVVS only',0,'3.10','','','','2008-09-16 00:00:00','2008-09-16 00:00:00')
1934Table 'cartkeeper.tbl_system' doesn't exist
1935
1936
1937Creating table: tbl_template ...
1938CREATE TABLE tbl_template (
1939 template_id int(11) NOT NULL auto_increment,
1940 template_name varchar(255) NOT NULL default '',
1941 template_description varchar(255) default NULL,
1942 css_folder varchar(255) default NULL,
1943 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1944 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1945 PRIMARY KEY (template_id)
1946)
1947Invalid default value for 'date_time_created'
1948
1949Inserting Data into: tbl_template ...
1950INSERT INTO tbl_template (template_id, template_name, template_description, css_folder, date_time_created, date_time_modified) VALUES (1,'default','Default Theme','default','2004-08-17 15:07:42','2004-11-04 15:47:40')
1951Table 'cartkeeper.tbl_template' doesn't exist
1952
1953
1954Creating table: tbl_trustcommerce_sale_method ...
1955CREATE TABLE tbl_trustcommerce_sale_method (
1956 trustcommerce_sale_method_id int(11) NOT NULL auto_increment,
1957 trustcommerce_sale_method varchar(255) NOT NULL default '',
1958 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1959 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1960 PRIMARY KEY (trustcommerce_sale_method_id)
1961)
1962Invalid default value for 'date_time_created'
1963
1964Inserting Data into: tbl_trustcommerce_sale_method ...
1965INSERT INTO tbl_trustcommerce_sale_method (trustcommerce_sale_method_id, trustcommerce_sale_method, date_time_created, date_time_modified) VALUES (1,'sale','2005-05-16 13:49:02','2005-05-16 13:49:02'),(2,'preauth','2005-05-16 13:49:11','2005-05-16 13:49:11')
1966Table 'cartkeeper.tbl_trustcommerce_sale_method' doesn't exist
1967
1968
1969Creating table: tbl_ups_rate_chart ...
1970CREATE TABLE tbl_ups_rate_chart (
1971 rate_chart_id int(11) NOT NULL auto_increment,
1972 rate_chart varchar(255) NOT NULL default '',
1973 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
1974 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
1975 PRIMARY KEY (rate_chart_id)
1976)
1977Invalid default value for 'date_time_created'
1978
1979Inserting Data into: tbl_ups_rate_chart ...
1980INSERT INTO tbl_ups_rate_chart (rate_chart_id, rate_chart, date_time_created, date_time_modified) VALUES (1,'Regular+Daily+Pickup','2005-01-18 04:43:02','2005-01-18 04:43:02'),(2,'Customer+Counter','2005-01-18 04:43:12','2005-01-18 04:43:12')
1981Table 'cartkeeper.tbl_ups_rate_chart' doesn't exist
1982
1983
1984Creating table: tbl_user ...
1985CREATE TABLE tbl_user (
1986 user_id int(11) NOT NULL auto_increment,
1987 email varchar(255) NOT NULL default '',
1988 password varchar(255) NOT NULL default '',
1989 first_name varchar(255) default NULL,
1990 last_name varchar(255) default NULL,
1991 company_name varchar(255) default NULL,
1992 address_1 varchar(255) default NULL,
1993 address_2 varchar(255) default NULL,
1994 city varchar(255) default NULL,
1995 state_id int(11) default NULL,
1996 state_province varchar(255) default NULL,
1997 postal_code varchar(255) default NULL,
1998 country_id int(11) default NULL,
1999 phone varchar(255) default NULL,
2000 alt_phone varchar(255) default NULL,
2001 fax varchar(255) default NULL,
2002 last_logged_in datetime default '0000-00-00 00:00:00',
2003 reset_key varchar(255) default NULL,
2004 user_status_id int(11) default NULL,
2005 is_wholesaler tinyint(4) default NULL,
2006 comments mediumtext,
2007 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
2008 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
2009 PRIMARY KEY (user_id),
2010 UNIQUE KEY email_uni_idx (email)
2011)
2012Invalid default value for 'last_logged_in'
2013
2014Inserting Data into: tbl_user ...
2015INSERT INTO tbl_user (user_id, email, password, first_name, last_name, company_name, address_1, address_2, city, state_id, state_province, postal_code, country_id, phone, alt_phone, fax, last_logged_in, reset_key, user_status_id, is_wholesaler, comments, date_time_created, date_time_modified) VALUES (1,'joey@domain.tld','test','Joe','Black',NULL,'22 noplace st.','','nowhere',32,'Nebraska','32154',762,'321-321-3214','','','2005-10-01 03:28:21',NULL,1,1,NULL,'2005-09-28 21:07:10','2005-10-05 05:01:23'),(4,'jack@domain.tld','test','Jack','Little',NULL,'2121 jump st','','leapfrog',22,'Louisiana','01803',762,'123.456.7890','','','2005-10-01 07:36:07',NULL,1,0,NULL,'2005-09-28 22:38:07','2005-10-05 05:01:12')
2016Table 'cartkeeper.tbl_user' doesn't exist
2017
2018
2019Creating table: tbl_user_item_notify ...
2020CREATE TABLE tbl_user_item_notify (
2021 item_id int(11) NOT NULL default '0',
2022 email varchar(255) NOT NULL default '',
2023 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
2024 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
2025 PRIMARY KEY (item_id,email),
2026 KEY item_id_idx (item_id),
2027 KEY ntfy_email_idx (email)
2028)
2029Invalid default value for 'date_time_created'
2030
2031
2032Creating table: tbl_user_review ...
2033CREATE TABLE tbl_user_review (
2034 user_review_id int(11) NOT NULL auto_increment,
2035 user_id int(11) NOT NULL default '0',
2036 item_id int(11) default NULL,
2037 rating int(11) NOT NULL default '0',
2038 title varchar(255) default NULL,
2039 review_active tinyint(4) default '0',
2040 comment mediumtext NOT NULL,
2041 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
2042 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
2043 PRIMARY KEY (user_review_id),
2044 KEY user_id_idx (user_id),
2045 KEY rating_idx (rating),
2046 KEY user_review_item_idx (item_id)
2047)
2048Invalid default value for 'date_time_created'
2049
2050
2051Creating table: tbl_voucher ...
2052CREATE TABLE tbl_voucher (
2053 voucher_id int(11) NOT NULL auto_increment,
2054 voucher_name varchar(255) NOT NULL default '',
2055 voucher_code varchar(255) NOT NULL default '',
2056 amount decimal(9,2) default '0.00',
2057 percentage int(11) default '0',
2058 free_shipping tinyint(4) default NULL,
2059 threshold decimal(9,2) default NULL,
2060 apply_voucher_before_shipping tinyint(4) default NULL,
2061 apply_voucher_before_taxes tinyint(4) default NULL,
2062 only_once tinyint(4) default NULL,
2063 expiration_date datetime default NULL,
2064 times_used int(11) default '0',
2065 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
2066 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
2067 PRIMARY KEY (voucher_id),
2068 UNIQUE KEY voucher_code (voucher_code)
2069)
2070Invalid default value for 'date_time_created'
2071
2072
2073Creating table: tbl_wishlist ...
2074CREATE TABLE tbl_wishlist (
2075 wishlist_id int(11) NOT NULL auto_increment,
2076 user_id int(11) NOT NULL default '0',
2077 item_id int(11) NOT NULL default '0',
2078 quantity decimal(9,2) default NULL,
2079 quantity_purchased decimal(9,2) default NULL,
2080 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
2081 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
2082 PRIMARY KEY (wishlist_id),
2083 KEY user_id_idx (user_id)
2084)
2085Invalid default value for 'date_time_created'
2086
2087
2088Creating table: tbl_wishlist_option ...
2089CREATE TABLE tbl_wishlist_option (
2090 wishlist_option_id int(11) NOT NULL auto_increment,
2091 wishlist_id int(11) NOT NULL default '0',
2092 option_id int(11) NOT NULL default '0',
2093 option_attribute_id int(11) NOT NULL default '0',
2094 wishlist_attribute_price decimal(9,2) NOT NULL default '0.00',
2095 wishlist_attribute_ship decimal(11,0) NOT NULL default '0',
2096 wishlist_attribute_name varchar(255) NOT NULL default '',
2097 wishlist_attribute_text varchar(255) NOT NULL default '',
2098 date_time_created datetime NOT NULL default '0000-00-00 00:00:00',
2099 date_time_modified datetime NOT NULL default '0000-00-00 00:00:00',
2100 PRIMARY KEY (wishlist_option_id),
2101 KEY wishlist_id_idx (wishlist_id)
2102)
2103Invalid default value for 'date_time_created'
2104
2105There was a problem creating one or more tables in your database