mysql_demo.sql

Zen Cart是真正的电子商务艺术

(21, 1, 'Gift Certificates', 'Send a Gift Certificate today!<br /><br />Gift Certificates are good for anything in the store.'),
(57, 1, 'Text Pricing', ''),
(56, 1, 'Attributes', ''),
(22, 1, 'Big Linked', 'All of these products are &quot;Linked Products&quot;.<br /><br />This means that they appear in more than one Category.<br /><br />However, you only have to maintain the product in one place.<br /><br />The Master Product is used for pricing purposes.'),
(55, 1, 'Discount Qty', '<p>Discount Quantities can be set for Products or on the individual attributes.<br /><br />Discounts on the Product do NOT reflect on the attributes price.<br /><br />Only discounts based on Special and Sale Prices are applied to attribute prices.</p>'),
(23, 1, 'Test Examples', ''),
(24, 1, 'Free Call Stuff', ''),
(25, 1, 'Test 10% by Attrib', ''),
(27, 1, '$5.00 off', ''),
(28, 1, 'Test 10%', ''),
(31, 1, '10% off Skip', ''),
(32, 1, '10% off Price', ''),
(47, 1, '10% off Attrib', ''),
(33, 1, 'A Top Level Cat', '<p>This is a top level category description.</p>'),
(34, 1, 'SubLevel 2 A', 'This is a sublevel category description.'),
(35, 1, 'SubLevel 2 B', ''),
(36, 1, 'SubLevel 2 C', ''),
(37, 1, 'Sub Sub Cat 2B1', ''),
(38, 1, 'Sub Sub Cat 2B2', ''),
(39, 1, 'Sub Sub Cat 2B3', ''),
(40, 1, 'Sub Sub Cat 2A1', 'This is a sub-sub level category description.'),
(41, 1, 'Sub Sub Cat 2C1', ''),
(42, 1, 'Sub Sub Cat 2C3', ''),
(43, 1, 'Sub Sub Cat 2A2', ''),
(44, 1, 'Sub Sub Cat 2C2', ''),
(45, 1, '10% off', ''),
(46, 1, 'Set $100', ''),
(48, 1, 'Sale Percentage', ''),
(49, 1, 'Sale Deduction', ''),
(50, 1, 'Sale New Price', ''),
(51, 1, 'Set $100 Skip', ''),
(52, 1, '$5.00 off Skip', ''),
(53, 1, 'Big Unlinked', ''),
(54, 1, 'New v1.2', '<p>The New Products show many of the newest features that have been added to Zen Cart.<br /><br />Take the time to review these and the other Demo Products to better understand all the options and features that Zen Cart has to offer.</p>'),
(61, 1, 'Real', ''),
(62, 1, 'Music', ''),
(63, 1, 'Documents', 'Documents can now be added to the category tree. For example you may want to add servicing/Technical documents. Or use Documents as an integrated FAQ system on your site. The implemetation here is fairly spartan, but could be expanded to offer PDF downloads, links to purchaseable download files. The possibilities are endless and left to your imagination.'),
(64, 1, 'Mixed Product Types', 'This is a category with mixed product types.\r\n\r\nThis includes both products and documents. There are two types of documents - Documents that are for reading and Documents that are for reading and purchasing.');

#
# Dumping data for table `customers`
#

# INSERT INTO customers (customers_id, customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_nick, customers_default_address_id, customers_telephone, customers_fax, customers_password, customers_newsletter, customers_group_pricing, customers_email_format, customers_authorization, customers_referral) VALUES (NULL, 'm', '张', '无忌', '2001-01-01 00:00:00', '[e-mail]', '', 1, '1234567', '', 'd95e8fa7f20a009372eb3477473fcd34:1c', '0', 0, 'TEXT', 0, '');

#
# Dumping data for table `customers_info`
#

# INSERT INTO customers_info (customers_info_id, customers_info_date_of_last_logon, customers_info_number_of_logons, customers_info_date_account_created, customers_info_date_account_last_modified, global_product_notifications) VALUES (1, '0001-01-01 00:00:00', 0, '2004-01-21 01:35:28', '0001-01-01 00:00:00', 0);

#
# Dumping data for table `featured`
#

INSERT INTO featured (featured_id, products_id, featured_date_added, featured_last_modified, expires_date, date_status_change, status, featured_date_available) VALUES (1, 34, '2004-02-21 16:34:31', '2004-02-21 16:34:31', '0001-01-01', '2004-02-21 16:34:31', 1, '0001-01-01'),
(2, 8, '2004-02-21 17:04:54', '2004-02-21 22:31:52', '2004-02-27', '2004-04-25 22:50:50', 0, '2004-02-21'),
(3, 12, '2004-02-21 17:10:49', '2004-02-21 17:10:49', '0001-01-01', '2004-02-21 17:10:49', 1, '0001-01-01'),
(4, 27, '2004-02-21 22:30:53', NULL, '0001-01-01', NULL, 1, '0001-01-01'),
(5, 26, '2004-02-21 22:31:24', NULL, '0001-01-01', NULL, 1, '0001-01-01'),
(6, 40, '2004-05-13 22:50:33', NULL, '0001-01-01', NULL, 1, '0001-01-01'),
(7, 171, '2004-07-12 15:47:22', NULL, '0001-01-01', NULL, 1, '0001-01-01'),
(8, 172, '2004-07-12 15:47:29', NULL, '0001-01-01', NULL, 1, '0001-01-01'),
(9, 168, '2004-07-12 15:47:37', NULL, '0001-01-01', NULL, 1, '0001-01-01'),
(10, 169, '2004-07-12 15:47:45', NULL, '0001-01-01', NULL, 1, '0001-01-01');

#
# Dumping data for table `group_pricing`
#

INSERT INTO group_pricing (group_id, group_name, group_percentage, last_modified, date_added) VALUES (1, 'VIP客户', '10.00', NULL, '2004-04-29 00:21:04');

#
# Dumping data for table `manufacturers`
#

INSERT INTO manufacturers (manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified) VALUES (1, 'Matrox', 'manufacturers/manufacturer_matrox.gif', '2003-12-23 03:18:19', NULL),
(2, 'Microsoft', 'manufacturers/manufacturer_microsoft.gif', '2003-12-23 03:18:19', NULL),
(3, 'Warner', 'manufacturers/manufacturer_warner.gif', '2003-12-23 03:18:19', NULL),
(4, 'Fox', 'manufacturers/manufacturer_fox.gif', '2003-12-23 03:18:19', NULL),
(5, 'Logitech', 'manufacturers/manufacturer_logitech.gif', '2003-12-23 03:18:19', NULL),
(6, 'Canon', 'manufacturers/manufacturer_canon.gif', '2003-12-23 03:18:19', NULL),
(7, 'Sierra', 'manufacturers/manufacturer_sierra.gif', '2003-12-23 03:18:19', NULL),
(8, 'GT Interactive', 'manufacturers/manufacturer_gt_interactive.gif', '2003-12-23 03:18:19', NULL),
(9, 'Hewlett Packard', 'manufacturers/manufacturer_hewlett_packard.gif', '2003-12-23 03:18:19', NULL);

#
# Dumping data for table `manufacturers_info`
#

INSERT INTO manufacturers_info (manufacturers_id, languages_id, manufacturers_url, url_clicked, date_last_click) VALUES (1, 1, 'http://www.matrox.com', 0, NULL),
(2, 1, 'http://www.microsoft.com', 0, NULL),
(3, 1, 'http://www.warner.com', 0, NULL),
(4, 1, 'http://www.fox.com', 0, NULL),
(5, 1, 'http://www.logitech.com', 0, NULL),
(6, 1, 'http://www.canon.com', 0, NULL),
(7, 1, 'http://www.sierra.com', 0, NULL),
(8, 1, 'http://www.infogrames.com', 0, NULL),
(9, 1, 'http://www.hewlettpackard.com', 0, NULL);

#
# Dumping data for table `media_clips`
#

INSERT INTO media_clips (clip_id, media_id, clip_type, clip_filename, date_added, last_modified) VALUES (1, 1, 1, 'thehunter.mp3', '2004-06-01 20:57:43', '0000-00-00 00:00:00'),
(6, 2, 1, 'thehunter.mp3', '2004-07-13 00:45:09', '0000-00-00 00:00:00');