use shopping450
go
set identity_insert categories on
Insert into categories(categoryid,catdescription,highercategoryid,catimage,hassubcategory,catmemo) values(1,'Toys',0,'vpdemo_toys.jpg','Yes','Extensive set of new exciting toys');
Insert into categories(categoryid,catdescription,highercategoryid,catimage,catmemo) values(2,'Travel Packages',0,'vpdemo_travel.jpg','Travel the world. Great packagesfor all ages.');
Insert into categories(categoryid,catdescription,highercategoryid,catimage,catmemo) values(3,'Stationery',0,'vpdemo_stationery.jpg','Full range of laser and fax paper');
Insert into categories(categoryid,catdescription,highercategoryid,catimage,catmemo) values(4,'Services',0,'vpdemo_services.jpg','Full set of professional services and inexpensive rates.');
Insert into categories(categoryid,catdescription,highercategoryid,catimage,catmemo) values(5,'Clothes',0,'vpdemo_clothes.jpg','The latest fashions and bargain prices.');
Insert into categories(categoryid,catdescription,highercategoryid,catimage,catmemo) values(6,'Groceries',0,'vpdemo_grocery.jpg','Compare and save with internet shopping');
Insert into categories(categoryid,catdescription,highercategoryid,cathide) values(7,'Hidden Category',0,'Yes');
Insert into categories(categoryid,catdescription,highercategoryid,catimage) values(8,'New Dolls',1,'vpdemo_doll.jpg');
Insert into categories(categoryid,catdescription,highercategoryid,catimage) values(9,'New Toys',1,'vpdemo_cannon.gif');
Insert into categories(categoryid,catdescription,highercategoryid,catimage,hassubcategory) values(10,'New Puzzles',1,'vpdemo_toys.jpg','Yes');
Insert into categories(categoryid,catdescription,highercategoryid) values(11,'Small Puzzles',10);
Insert into categories(categoryid,catdescription,highercategoryid) values(12,'Large Puzzles',10);
set identity_insert categories off
go

set identity_insert prodfeatures on
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(1,1,'Colors','White',0,'Radio',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(2,1,'Colors','Grey',1,'Radio',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(3,1,'Colors','Striped',2,'Radio',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(4,2,'Size','Extra Large',6,'Dropdown',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(5,2,'Size','Small',-1,'DropDown',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(6,2,'Size','Medium',0,'DropDown',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(7,2,'Size','Large',2,'DropDown',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featurerequired) values(10,1,'Colors','Orange and Purple',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featurerequired) values(11,7,'Upgrades','Upgrade to deluxe suite',20,0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featurerequired) values(12,7,'Upgrades','Upgrade to family room',15,0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(13,4,'Paper Color','Glossy Red',0,'Radio',1);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(14,4,'Paper Color','Glossy White',0,'Radio',1);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featurerequired) values(15,4,'Paper Color','Glossy Yellow',1,'Radio',1);
Insert into prodfeatures(id,featurenum,featurecaption,featureprice,featuretype,featurerequired) values(16,16,'Size',0,'SelectList',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featuremulti,featurerequired) values(17,5,'Topping','Mushrooms',0.5,'Checkbox','Yes',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featuremulti,featurerequired) values(18,5,'Topping','Onions',0,'Checkbox','Yes',0);
Insert into prodfeatures(id,featurenum,featurecaption,featurename,featureprice,featuretype,featuremulti,featurerequired) values(19,5,'Topping','Anchovies',1,'Checkbox','Yes',0);
Insert into prodfeatures(id,featurenum,featurecaption,featureprice,featuretype,featurerequired) values(20,15,'Hard Easy',0,'UserText',0);
Insert into prodfeatures(id,featurenum,featurecaption,featureprice,featuretype,featurerequired) values(21,14,'Picture Type',0,'UserText',0);
Insert into prodfeatures(id,featurenum,featurecaption,featureprice,featuretype,featurerequired) values(22,6,'Donation',0,'UserPrice',0);
set identity_insert prodfeatures off
go

set identity_insert shipmethods on
Insert into shipmethods(shipmethodid,shipmethod,smprice) values(1,'Express',5);
Insert into shipmethods(shipmethodid,shipmethod,smprice) values(2,'Normal',3);
Insert into shipmethods(shipmethodid,shipmethod,smprice) values(3,'Airmail',10);
Insert into shipmethods(shipmethodid,shipmethod,smprice) values(4,'Download',0);
Insert into shipmethods(shipmethodid,shipmethod,smprice) values(5,'Attachment',0);
set identity_insert shipmethods off
go

set identity_insert prodcategories on
Insert into prodcategories(id,intcategoryid,intcatalogid) values(2,2,2);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(3,1,3);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(4,1,4);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(5,3,5);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(6,3,6);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(7,3,7);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(8,4,8);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(9,2,9);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(10,2,10);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(11,5,11);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(12,5,12);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(13,1,13);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(14,1,14);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(15,1,15);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(16,1,16);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(17,1,17);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(18,1,18);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(19,1,19);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(20,6,20);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(21,6,21);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(22,6,22);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(23,4,23);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(24,9,3);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(33,11,15);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(34,11,16);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(25,8,4);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(35,12,17);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(26,9,13);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(27,8,14);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(28,10,15);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(29,10,16);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(30,10,17);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(31,9,18);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(32,9,19);
Insert into prodcategories(id,intcategoryid,intcatalogid) values(45,2,1);
set identity_insert prodcategories off
go

set identity_insert products on
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,features,cstock,weight,subcategoryid,specialoffer,cdateavailable,allowusertext,userid,extendeddesc,supplierid,crossselling,hide) values(1,'11111','Hotel Room','Great suite overlooking the ocean',85,2,'7',100,'1',0,'Stay three nights and pay for only two','7/03/00','Special requirements','admin','This is a description of the product generated from the database',1,'2,9',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,category,cdateavailable,userid,crossselling,hide) values(2,'22222','City Tour','Tour the city with a local guide. See all the great sights',27,2,100,'2','Travel Packages','7/03/00','admin','1',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cdescurl,cimageurl,cstock,weight,subcategoryid,category,cdateavailable,userid,hide) values(3,'33333','Electronic Cannon','Plastic toy cannon that requires battery',1.5,1,'vpdemo_cannon.htm','vpdemo_cannon.gif',100,'3',2,'Toys','8/03/00','admin',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cimageurl,cstock,weight,subcategoryid,category,cdateavailable,userid,hide) values(4,'44444','The doll collection','A collection of small dolls',22.5,1,'vpdemo_doll.jpg',93,'4',1,'Toys','8/03/00','admin',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,category,cdateavailable,hide) values(5,'55555','Ream White','Ream of  white paper - 500 sheets',5.87,3,100,'5','Stationery','8/03/00',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,features,cstock,weight,category,cdateavailable,hide) values(6,'66666','Glossy paper','100 Sheets of Gloss paper suitable for all laser and inkjet printers',3.9,3,'4',100,'6','Stationery ','8/03/00',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,category,buttonimage,cdateavailable,hide) values(7,'77777','Pens and Pencils','A package of 20 pens and pencils of assorted colors and sizes',3.5,3,1,'7','Stationery','vpdemo_new020.gif','8/03/00',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,mfg,category,cdateavailable,hide) values(8,'88888','Professional fireworks Displays','We will build and design the greatest fireworks displays',2995,4,1,'8','Virtual Programming','Professional Services','10/03/00',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cimageurl,cstock,weight,category,buttonimage,cdateavailable,extendedimage,hide) values(9,'99999','Flight from New York to Paris','Round trip flight from Paris to New York',400,2,'vpdemo_newyork.jpg',1,'9','Travel Packages ','vpdemo_new020.gif width=61 height=42','','vpdemo_travel.jpg',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cdescurl,cimageurl,cstock,weight,category,hide) values(10,'aaaaa','Cruise','Mexican cruise with five meals per day, entertainment and gambling. Price Per person',570,2,'vpdemo_sample.htm','vpdemo_cruise.jpg',1,'1','Travel Packages',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,features,cimageurl,cstock,weight,category,cdateavailable,extendedimage,hide) values(11,'bbbbb','Girls tops','Summer tops in assorted size and colors',9.85,5,'1,2','vpdemo_clothes.jpg',1,'2','Clothes','','vpdemo_clothesext.jpg',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,features,cstock,weight,category,cdateavailable,hide) values(12,'ccccc','Mens Business Shirts','Great value men''s business shirts in assorted colors and sizes',18,5,'2',1,'3','Clothes','',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cimageurl,cstock,weight,subcategoryid,retailprice,specialoffer,category,cdateavailable,hide) values(13,'ddddd','Adult Play Swing','Play toy for adults runs for years on one battery',14.95,1,'vpdemo_whacky.gif',5,'2.5',2,29.95,'Super great value','Toys','',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,subcategoryid,category,cdateavailable,supplierid,hide) values(14,'eeeee','Small girl doll','A very pretty doll with multi-colored dress',4.5,1,1,'2',1,'Toys','6/04/00',1,0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,features,cstock,weight,subcategoryid,category,cdateavailable,allowusertext,supplierid,hide) values(15,'ffffff','100 Piece Puzzle','Suitable for small children',2.5,1,'15',10,'20',3,'Toys','','Picture Type',1,0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,subcategoryid,category,cdateavailable,hide) values(16,'ggggg','200 Piece Puzzle','Suitable for small children 8-11 years',3.5,1,10,'4',3,'Toys','6/04/00',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,subcategoryid,category,cdateavailable,allowusertext,hide) values(17,'hhhhh','1000 Piece Puzzle','Suitable for only for puzzle experts',19.95,1,10,'5',3,'Toys','6/04/00','Hard, Easy and Difficult',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,subcategoryid,category,cdateavailable,hide) values(18,'iiiii','Hand held game for small children','Hours of fun trying to find you way',7.95,1,66,'6',2,'Toys','6/04/00',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,cstock,weight,subcategoryid,retailprice,specialoffer,category,cdateavailable,userid,hide) values(19,'jjjjj','Your own radio set','Make our own short wave radio. Multiple parts but no soldering required',49.95,1,1,'7',2,69.95,'Great Price!','Toys','','ABC',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,features,category,userid,selectlist,hide) values(20,'Milk','Milk','A full liter of full cream milk',1.19,6,'16','Groceries','vpasp','half liter [-.50],2 liters [1.00], half gallon [2.00]',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,category,userid,hide) values(21,'Tuna','Tuna Fish','425 grams of the finest tuna fish. Dolphin friendly',3.25,6,'Groceries','vpasp',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,features,specialoffer,category,userid,hide) values(22,'Pizza','Pizza Frozen','The finest ingredients and self rising crust make this the perfect pizza',5.95,6,'5','Marked down today at our special price','Groceries','vpasp',0);
Insert into products(catalogid,ccode,cname,cdescription,cprice,ccategory,features,category,userid,hide) values(23,'Donation','Enter your donation','Please give generously to this wonderful charity',0,4,'6','Donations','vpasp',0);
set identity_insert products off
go


