SET IDENTITY_INSERT savedquery ON;
INSERT INTO savedquery (id,sqlqueryname,sqlquery) VALUES (1,'Order amounts with certain period','select * from orders where orderamount >= 100 and odate >= ''1/1/2009'' and odate <= ''11/30/2009'' order by odate asc');
INSERT INTO savedquery (id,sqlqueryname,sqlquery) VALUES (2,'Orders certain product with certain period','select * from orders a, oitems b where a.orderid = b.orderid and b.catalogid = 1 and a.odate >= ''1/1/2009'' and odate <= ''11/30/2009'' order by a.odate asc');
INSERT INTO savedquery (id,sqlqueryname,sqlquery) VALUES (3,'Orders from country US','select distinct b.contactid from orders a, customers b where a.ocustomerid = b.contactid and b.country = ''US'' order by b.contactid asc');
INSERT INTO savedquery (id,sqlqueryname,sqlquery) VALUES (4,'Orders certain item in last 3 months with processed and valid payment','select distinct c.contactid from customers c,orders o, oitems oi Where c.contactid = o.ocustomerid and o.orderid = oi.orderid and o.odate <= now() and o.odate >= DATEADD(m, -3,now()) and oi.catalogid = 1 and o.oprocessed = 1 and o.ocardtype in (''Visa'',''Mastercard'',''Cash'')');
INSERT INTO savedquery (id,sqlqueryname,sqlquery) VALUES (5,'Orders certain item in last 6 months with processed and valid payment','select distinct c.contactid from customers c,orders o, oitems oi Where c.contactid = o.ocustomerid and o.orderid = oi.orderid and o.odate <= now() and o.odate >= DATEADD(m, -6,now()) and oi.catalogid = 1 and o.oprocessed = 1 and o.ocardtype in (''Visa'',''Mastercard'',''Cash'')');
INSERT INTO savedquery (id,sqlqueryname,sqlquery) VALUES (6,'Orders certain item in last 12 months with processed and valid payment','select distinct c.contactid from customers c,orders o, oitems oi Where c.contactid = o.ocustomerid and o.orderid = oi.orderid and o.odate <= now() and o.odate >= DATEADD(m, -12,now()) and oi.catalogid = 1 and o.oprocessed = 1 and o.ocardtype in (''Visa'',''Mastercard'',''Cash'')');
SET IDENTITY_INSERT savedquery OFF;

SET IDENTITY_INSERT blogs ON;
INSERT INTO blogs (blogsid,messagetype,headline,hide,loggedin,impressions,cdateadded,cdateupdated,showonbox,showonhomepage,archive,message) VALUES (1,'first','Welcome to our Blog!','0','0',0,'6/6/2010 11:49:22 AM','6/6/2010 1:38:11 PM','1','1','0','With the new release of VPASP 700 we have included not only a News Article system but also a Blog Manager! How cool!<br /><br />You can post your blogs and separate by category and by date.<br /><br />Your visitors can also leave comments directly on the blog page using powerful and interactive tools from the new Web 2.0 technology.<br /><br />We hope you like the new feature!');
SET IDENTITY_INSERT blogs OFF;

SET IDENTITY_INSERT categories ON;
INSERT INTO categories (categoryid,catdescription,highercategoryid,catimage,hassubcategory,impressions) VALUES (1,'Office',0,'images/thumbs/vpaspdemo_officedesk.jpg',NULL,0);
INSERT INTO categories (categoryid,catdescription,highercategoryid,catimage,hassubcategory,impressions) VALUES (2,'Living',0,'images/thumbs/vpaspdemo_green_sofa.jpg','Yes',0);
INSERT INTO categories (categoryid,catdescription,highercategoryid,catimage,hassubcategory,impressions) VALUES (3,'Dining',0,'images/thumbs/vpaspdemo_dining_table2.jpg',NULL,0);
INSERT INTO categories (categoryid,catdescription,highercategoryid,catimage,hassubcategory,impressions) VALUES (4,'Kitchen',0,'images/thumbs/vpaspdemo_coffee_maker.jpg',NULL,0);
INSERT INTO categories (categoryid,catdescription,highercategoryid,catimage,hassubcategory,impressions) VALUES (5,'Donation',0,'images/no-image.gif',NULL,0);
INSERT INTO categories (categoryid,catdescription,highercategoryid,catimage,hassubcategory,impressions) VALUES (6,'Seating',2,'images/thumbs/vpaspdemo_red_sofa.jpg',NULL,0);
INSERT INTO categories (categoryid,catdescription,highercategoryid,catimage,hassubcategory,impressions) VALUES (7,'Coffee tables',2,'images/thumbs/vpaspdemo_glass_coffee_table.jpg',NULL,0);
SET IDENTITY_INSERT categories OFF;

SET IDENTITY_INSERT concatcategories ON;
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (1,1,1);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (2,1,2);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (3,1,3);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (4,1,4);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (5,1,5);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (6,1,6);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (7,1,7);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (8,1,8);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (9,2,9);
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (10,1,10);
SET IDENTITY_INSERT concatcategories OFF;

SET IDENTITY_INSERT content ON;
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (1,'News',NULL,'0','tmp_content.htm','0',0,'0','1',NULL,'1','News','This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. <br /><br />This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration.');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (2,'AboutUs','images/misc/vpaspbox.jpg','0','tmp_content.htm','0',0,'0','1',NULL,'1','About Us','This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. <br /><br />This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration.');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (3,'affiliateinfo',NULL,'0','tmp_content.htm','0',0,'0','0',NULL,'1','Affiliates','This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. <br /><br />This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration.');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (4,'Terms and Conditions',NULL,'0','tmp_content.htm','0',0,'0','1',NULL,'1','Terms & Conditions','This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. <br /><br />This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration.');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (5,'features','images/misc/vpaspbox.jpg','0','tmp_content.htm','0',0,'0','0',NULL,'1','Features','This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. <br /><br />This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration.');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (6,'Shipping and Returns',NULL,'0','tmp_content.htm','0',0,'0','1',NULL,'1','Shipping & Returns','This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. <br /><br />This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration.');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (7,'Privacy',NULL,'0','tmp_content.htm','0',0,'0','1',NULL,'1','Privacy','This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. <br /><br />This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration. This is where you would enter your content in the content table. You can edit this text in your administration.');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (8,'home','images/site/red_sofa.gif','0','tmp_default.htm','0',0,'1','0',NULL,'1','Welcome to my Online Store','<p>Welcome to the VP-ASP Shopping Cart! This is the front page of your new store - you can add and edit your categories and products through the VP-ASP administration. You can also change this text in the Content section of the VP-ASP administration. You can find more information on how to customize your entire store by visiting the Help section of our website at <a href="http://helpnotes.vpasp.com/" target="_blank">http://helpnotes.vpasp.com/</a>.</p>');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (9,'Vpasp Link',NULL,'0','tmp_content.htm','0',0,'0','1','http://www.vpasp.com','2','VPASP','<P>&nbsp;</P>');
INSERT INTO content (contentid,messagetype,contentimage,hide,template,loggedin,impressions,homepage,showonbox,nurllink,ncategoryid,message,message2) VALUES (10,'Contact us',NULL,'0','tmp_content.htm','0',0,'0','1','shopcustcontact.asp','1','Contact us','<P>&nbsp;</P>');
SET IDENTITY_INSERT content OFF;

SET IDENTITY_INSERT contentcategories ON;
INSERT INTO contentcategories (ncategoryid,ncatdescription) VALUES (1,'Information');
INSERT INTO contentcategories (ncategoryid,ncatdescription) VALUES (2,'Links');
SET IDENTITY_INSERT contentcategories OFF;

SET IDENTITY_INSERT customergroups ON;
INSERT INTO customergroups (id,groupsid,contactid) VALUES (1,1,1);
SET IDENTITY_INSERT customergroups OFF;

SET IDENTITY_INSERT customers ON;
INSERT INTO customers (contactid,firstname,lastname,address,city,state,postcode,country,company,phone,workphone,mobilephone,email,logincount,discount,maillist,cookiequestion,pointstotal,pointsremaining,userid,[password]) VALUES (1,'Fred','Buyer','45 Demo Place','Demo City','CA','90001','US','Demo Co','555 6666','777 8888','999 1111','fred@abc.com',0,0,'0','0',0,0,'fred','fred');
SET IDENTITY_INSERT customers OFF;

SET IDENTITY_INSERT prodcategories ON;
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (1,1,1);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (2,1,2);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (3,1,6);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (4,1,16);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (5,1,20);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (6,1,22);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (7,3,10);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (8,3,11);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (9,4,12);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (10,4,13);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (11,4,14);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (12,4,17);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (13,4,18);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (14,4,19);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (15,5,15);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (16,6,7);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (17,6,8);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (18,6,21);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (19,6,24);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (20,7,9);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (21,7,23);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (22,1,3);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (23,1,4);
INSERT INTO prodcategories (id,intcategoryid, intcatalogid) VALUES (24,1,5);
SET IDENTITY_INSERT prodcategories OFF;

SET IDENTITY_INSERT prodfeatures ON;
INSERT INTO prodfeatures (id,featurenum, featurecaption, featurename, featureprice, featuretype, featurerequired, featuredefault) VALUES (1,'1', 'Color', 'Black', 0, 'Dropdown', 1, 1);
INSERT INTO prodfeatures (id,featurenum, featurecaption, featurename, featureprice, featuretype, featurerequired, featuredefault) VALUES (2,'1', 'Color', 'White', 0, 'Dropdown', 1, 0);
INSERT INTO prodfeatures (id,featurenum, featurecaption, featurename, featureprice, featuretype, featurerequired, featuredefault) VALUES (3,'1', 'Color', 'Beige', 0, 'Dropdown', 1, 0);
INSERT INTO prodfeatures (id,featurenum, featurecaption, featurename, featureprice, featuretype, featurerequired, featuredefault) VALUES (4,'2', 'Options', 'Hutch', 99, 'Checkbox', 0, 0);
INSERT INTO prodfeatures (id,featurenum, featurecaption, featurename, featureprice, featuretype, featurerequired, featuredefault) VALUES (5,'2', 'Options', 'Monitor Stand', 59, 'Checkbox', 0, 0);
INSERT INTO prodfeatures (id,featurenum, featurecaption, featurename, featureprice, featuretype, featurerequired, featuredefault) VALUES (6,'3', 'Donation', 'Amount', 0, 'Userprice', 1, 0);
SET IDENTITY_INSERT prodfeatures OFF;

SET IDENTITY_INSERT products ON;
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('1','COMPDESK','Computer Desk',100,'1','2','images/thumbs/vpaspdemo_computer_table2.jpg','images/full/computer_table2.jpg','A great desk for your home office.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, crossselling, hassubproduct, producttype) Values ('2','OFFICESET','Office Set',0,'1','','images/thumbs/vpaspdemo_office_set3.jpg','images/full/office_set3.jpg','A desk for all office types',NULL,'Checkbox',0,'1,6','Yes','Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('3','OS-DESK','Desk',299,'1','','images/thumbs/vpaspdemo_officedesk.jpg','images/full/officedesk.jpg','This desk will suit all your office requirements.',2,'',0,'');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('4','OS-HUTCH','Hutch',159,'1','','images/thumbs/vpaspdemo_atlantis_book.jpg','images/full/atlantis_book.jpg','This desk has a handy hutch to store your computer peripherals.',2,'',0,'');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('5','OS-RETURN','2-Drawer Return',129,'1','','images/thumbs/vpaspdemo_malvern_corner.jpg','images/full/malvern_corner.jpg','This two-drawer desk allows you to store important equipment and papers nearby.',2,'',0,'');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('6','OFFICEROUNDTABLE','Office Round Table',500,'1','','images/thumbs/vpaspdemo_office_round_table.jpg','images/full/office_round_table.jpg','Big round classic round table.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('7','REDCOUCH','Red Couch',350,'6','','images/thumbs/vpaspdemo_red_sofa.jpg','images/full/red_sofa.jpg','This funky red couch will look great in any living room.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype,extraimage1,extraimage2,extraimage3,extraimage4,largeextendedimage,largeextraimage1,largeextraimage2,largeextraimage3,largeextraimage4) Values ('8','TVCHAIR','TV Chair',150,'6','1','images/thumbs/vpaspdemo_tv_chair.jpg','images/full/tv_chair.jpg','Our leather couch is designed with both comfort and style in mind.',NULL,'',0,'Normal','images/full/tv_chair_view1.jpg','images/full/tv_chair_view2.jpg','images/full/tv_chair_view3.jpg','images/full/tv_chair_view4.jpg','images/full/tv_chair_big.jpg','images/full/tv_chair_big_view1.jpg','images/full/tv_chair_big_view2.jpg','images/full/tv_chair_big_view3.jpg','images/full/tv_chair_big_view4.jpg');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('9','HMCOFFEETBL','Home Coffee Table',99,'7','','images/thumbs/vpaspdemo_glass_coffee_table2.jpg','images/full/glass_coffee_table2.jpg','This coffee table is hand-crafted and very stylish.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype, featuredflag, featuredflagorder) Values ('10','DIN-GLASS','Modern Dining Table',300,'3','','images/thumbs/vpaspdemo_dining_table2.jpg','images/full/dining_table2.jpg','This glass table will compliment any dining room.',NULL,'',0,'Normal',1,5);
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype, featuredflag, featuredflagorder) Values ('11','DIN-WOOD','Classic Wood Dining Table',180,'3','','images/thumbs/vpaspdemo_dining_table.jpg','images/full/dining_table.jpg','The latest in style dining table perfect for your home.',NULL,'',0,'Normal',1,1);
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype, featuredflag, featuredflagorder) Values ('12','EKETTLE','Cordless Electric Kettle',11.99,'4','','images/thumbs/vpaspdemo_kettle.jpg','images/full/kettle.jpg','New cordless electric kettle.',NULL,'',0,'Normal',1,4);
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype, featuredflag, featuredflagorder) Values ('13','KNIVES','Cutlery Set Steak Knives Stainless Steel Kitchen Knife',9.99,'4','','images/thumbs/vpaspdemo_knives.jpg','images/full/knives.jpg','Made of stainless steel, these knives are dishwasher safe and never need sharpening.',NULL,'',0,'Normal',1,2);
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype, featuredflag, featuredflagorder) Values ('14','COOKWARE','Cookware Set',11.99,'4','','images/thumbs/vpaspdemo_cookware.jpg','images/full/cookware.jpg','Easy Grip, cool-touch handles and cover knobs cookware.',NULL,'',0,'Normal',1,3);
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('15','DONATION','Donation',0,'5','3','','','Please donate to this worthy cause.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('16','COMPSET','Computer Set',110,'1','','images/thumbs/vpaspdemo_computer_table.jpg','images/full/computer_table.jpg','Set of computer-related products.',NULL,'',0,'Bundled');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('17','KITSET','Kitchen set',1000,'4','','images/thumbs/vpaspdemo_kitchenware1.jpg','images/full/kitchenware1.jpg','Kitchen Set.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('18','COFFEEMAKER','Olive Green Coffee Maker',120.99,'4','','images/thumbs/vpaspdemo_coffee_maker.jpg','images/full/coffee_maker.jpg','Great 10-cup olive green coffee maker.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('19','STOVE','Stainless Steel Gas Stove',11.99,'4','','images/thumbs/vpaspdemo_stove.jpg','images/full/stove.jpg','Portable Stainless Steel Gas Stove for your family.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('20','ORANGECHAIR','Office Orange Chair',25,'1','','images/thumbs/vpaspdemo_orange_chair.jpg','images/full/orange_chair.jpg','Elegant orange chair for office.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('21','GREENCOUCH','Green Couch',350,'6','','images/thumbs/vpaspdemo_green_sofa.jpg','images/full/green_sofa.jpg','This funky green couch will look great in any living room.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('22','EXECUTIVECHAIR','Executive Chair',25,'1','','images/thumbs/vpaspdemo_executive_chair.jpg','images/full/executive_chair.jpg','Elegant executive chair for office.',NULL,'',0,'Normal');
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype, featuredflag, featuredflagorder) Values ('23','COFFEETBL','Glass Coffee Table',99,'7','','images/thumbs/vpaspdemo_glass_coffee_table.jpg','images/full/glass_coffee_table.jpg','This coffee table is hand-crafted and very stylish.',NULL,'',0,'Normal',1,0);
INSERT INTO products (catalogid, ccode, cname, cprice, ccategory, features, cimageurl, extendedimage, cdescription, highercatalogid, spdisplaytype, hide, producttype) Values ('24','REDCHAIR','Red Chair',25,'6','1','images/thumbs/vpaspdemo_redchair.jpg','images/full/redchair.jpg','Elegant red chair for your perfect living room.',NULL,'',0,'Normal');
SET IDENTITY_INSERT products OFF;

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;