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 ON;

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 concatcategories ON;
INSERT INTO concatcategories (id,intcategoryid,intcatalogid) VALUES (1,1,1);
SET IDENTITY_INSERT concatcategories OFF;