include.sql

php做的网上商店系统。简单易懂

##插入信息

INSERT INTO shopper_group VALUES (5,1,'-default-','Default shopper group.');
INSERT INTO shopper_group VALUES (6,1,'Gold Level','Gold Level phpShoppers.');
INSERT INTO shopper_group VALUES (7,1,'Wholesale','Shoppers that can buy at wholesale.');


INSERT INTO product_price VALUES (1,5,24.99,'USD',0,0,950321309,950321309,5);
INSERT INTO product_price VALUES (2,1,4.99,'USD',0,0,950321324,950321324,5);
INSERT INTO product_price VALUES (3,2,49.99,'USD',0,0,950321340,950321340,5);
INSERT INTO product_price VALUES (4,3,24.99,'USD',0,0,950321368,950321368,5);
INSERT INTO product_price VALUES (5,4,19.99,'USD',0,0,950321385,950321385,5);
INSERT INTO product_price VALUES (6,6,1.00,'USD',0,0,950321686,963808699,5);
INSERT INTO product_price VALUES (7,7,149.99,'USD',0,0,950321754,966506270,5);
INSERT INTO product_price VALUES (8,8,220.90,'USD',0,0,950321833,955614388,5);
INSERT INTO product_price VALUES (9,9,48.12,'USD',0,0,950321933,950321933,5);
INSERT INTO product_price VALUES (10,10,74.99,'USD',0,0,950322005,950322005,5);
INSERT INTO product_price VALUES (11,1,2.99,'USD',0,0,955626841,955626841,6);
INSERT INTO product_price VALUES (12,13,14.99,'USD',0,0,955697213,955697213,5);
INSERT INTO product_price VALUES (13,14,79.99,'USD',0,0,962351197,962351271,5);
INSERT INTO product_price VALUES (14,15,49.99,'USD',0,0,962351233,962351233,5);
INSERT INTO product_price VALUES (15,16,59.99,'USD',0,0,962351259,962351259,5);
INSERT INTO product_price VALUES (16,7,2.99,'USD',0,0,966589140,966589140,6);

INSERT INTO product_category_xref VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992',1,NULL);
INSERT INTO product_category_xref VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a',2,NULL);
INSERT INTO product_category_xref VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a',3,NULL);
INSERT INTO product_category_xref VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a',4,NULL);
INSERT INTO product_category_xref VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992',5,NULL);
INSERT INTO product_category_xref VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992',6,NULL);
INSERT INTO product_category_xref VALUES ('f85e462baf927f8e53989dd969c0e430',7,NULL);
INSERT INTO product_category_xref VALUES ('1c914424d2569bea3439fbcca9123a27',8,NULL);
INSERT INTO product_category_xref VALUES ('2f34f8bf003a5f27bed2e8dfe0b6f33a',9,NULL);
INSERT INTO product_category_xref VALUES ('1c914424d2569bea3439fbcca9123a27',10,NULL);

INSERT INTO product_attribute_sku VALUES (1,'Color',1);
INSERT INTO product_attribute_sku VALUES (1,'Size',2);
INSERT INTO product_attribute_sku VALUES (2,'Material',1);

INSERT INTO product_attribute VALUES (11,'Color','Red');
INSERT INTO product_attribute VALUES (12,'Color','Green');
INSERT INTO product_attribute VALUES (13,'Color','Blue');
INSERT INTO product_attribute VALUES (11,'Size','Small');
INSERT INTO product_attribute VALUES (12,'Size','Medium');
INSERT INTO product_attribute VALUES (13,'Size','Large');
INSERT INTO product_attribute VALUES (14,'Material','Metal');
INSERT INTO product_attribute VALUES (15,'Material','Wood');
INSERT INTO product_attribute VALUES (16,'Material','Plastic');


INSERT INTO product VALUES (1,1,0,'G01','<P>Nice hand shovel to dig with in the yard.</P>\r\n','<UL>\r\n<LI>Hand crafted handle with maximum grip torque\r\n<LI>Titanium tipped shovel platter\r\n<LI>Half degree offset for less accidents\r\n<LI>Includes HowTo Video narrated by Bob Costas\r\n</UL>\r\n\r\n<B>Specifications</B><BR>\r\n5\" Diameter<BR>\r\nTungsten handle tip with 5 point loft<BR>\r\n','8d886c5855770cc01a3b8a2db57f6600.jpg','cca3cd5db813ee6badf6a3598832f2fc.jpg','Y','10.0000','pounds','0.0000','0.0000','0.0000','inches','','10','0','','0','NULL','950320117','965878648','Hand Shovel');
INSERT INTO product VALUES (2,1,0,'G02','A really long ladder to reach high places.','<UL>\r\n<LI>Hand crafted handle with maximum grip torque\r\n<LI>Titanium tipped shovel platter\r\n<LI>Half degree offset for less accidents\r\n<LI>Includes HowTo Video narrated by Bob Costas\r\n</UL>\r\n\r\n<B>Specifications</B><BR>\r\n5\" Diameter<BR>\r\nTungsten handle tip with 5 point loft<BR>\r\n','ffd5d5ace2840232c8c32de59553cd8d.jpg','8cb8d644ef299639b7eab25829d13dbc.jpg','Y','10.0000','pounds','0.0000','0.0000','0.0000','inches','','0','0','','0','NULL','950320180','960375748','Ladder');
INSERT INTO product VALUES (3,1,0,'G03','Nice shovel.  You can dig your way to China with this one.','<UL>\r\n<LI>Hand crafted handle with maximum grip torque\r\n<LI>Titanium tipped shovel platter\r\n<LI>Half degree offset for less accidents\r\n<LI>Includes HowTo Video narrated by Bob Costas\r\n</UL>\r\n\r\n<B>Specifications</B><BR>\r\n5\" Diameter<BR>\r\nTungsten handle tip with 5 point loft<BR>\r\n','8147a3a9666aec0296525dbd81f9705e.jpg','520efefd6d7977f91b16fac1149c7438.jpg','Y','10.0000','pounds','0.0000','0.0000','0.0000','inches','','0','0','','0','NULL','950320243','965123675','Shovel');
INSERT INTO product VALUES (4,1,0,'G04','This shovel is smaller but you\'ll be able to dig real quick.','<UL>\r\n<LI>Hand crafted handle with maximum grip torque\r\n<LI>Titanium tipped shovel platter\r\n<LI>Half degree offset for less accidents\r\n<LI>Includes HowTo Video narrated by Bob Costas\r\n</UL>\r\n\r\n<B>Specifications</B><BR>\r\n5\" Diameter<BR>\r\nTungsten handle tip with 5 point loft<BR>\r\n','a04395a8aefacd9c1659ebca4dbfd4ba.jpg','1b0c96d67abdbea648cd0ea96fd6abcb.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',0,0,'',0,'NULL',950320378,960383149,'Smaller Shovel');
INSERT INTO product VALUES (5,1,0,'H01','This saw is great for getting cutting through downed limbs.','<UL>\r\n<LI>Hand crafted handle with maximum grip torque\r\n<LI>Titanium tipped shovel platter\r\n<LI>Half degree offset for less accidents\r\n<LI>Includes HowTo Video narrated by Bob Costas\r\n</UL>\r\n\r\n<B>Specifications</B><BR>\r\n5\" Diameter<BR>\r\nTungsten handle tip with 5 point loft<BR>\r\n','1aa8846d3cfe3504b2ccaf7c23bb748f.jpg','e614ba08c3ee0c2adc62fd9e5b9440eb.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',0,0,'',0,'NULL',950321256,960375831,'Nice Saw');
INSERT INTO product VALUES (6,1,0,'H02','A great hammer to hammer away with.','<UL>\r\n<LI>Hand crafted handle with maximum grip torque\r\n<LI>Titanium tipped shovel platter\r\n<LI>Half degree offset for less accidents\r\n<LI>Includes HowTo Video narrated by Bob Costas\r\n</UL>\r\n\r\n<B>Specifications</B><BR>\r\n5\" Diameter<BR>\r\nTungsten handle tip with 5 point loft<BR>\r\n','dccb8223891a17d752bfc1477d320da9.jpg','578563851019e01264a9b40dcf1c4ab6.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',0,0,'',0,'NULL',950321631,960375814,'Hammer');
INSERT INTO product VALUES (7,1,0,'P01','Don\'t do it with an axe.  Get a chain saw.','<ul>\r\n<li>Tool-free tensioner for easy, convenient chain adjustment\r\n<li>3-Way Auto Stop; stops chain a fraction of a second\r\n<li>Automatic chain oiler regulates oil for proper chain lubrication\r\n<li>Small radius guide bar reduces kick-back\r\n</ul>\r\n<br>\r\n<b>Specifications</b><br>\r\n12.5 AMPS   <br> \r\n16\" Bar Length   <br> \r\n3.5 HP   <br> \r\n8.05 LBS. Weight   <br> \r\n','8716aefc3b0dce8870360604e6eb8744.jpg','c3a5bf074da14f30c849d13a2dd87d2c.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',0,0,'',0,'NULL',950321725,965475132,'Chain Saw');
INSERT INTO product VALUES (8,1,0,'P02','Cut rings around wood.  This saw can handle the most delicate projects.','<ul>\r\n<li>Patented Sightline; Window provides maximum visibility for straight cuts\r\n<li>Adjustable dust chute for cleaner work area\r\n<li>Bail handle for controlled cutting in 90