use shopping350;
alter table categories add  cathide [varchar](10) NULL;
alter table categories add  highercategoryid [int];
alter table categories add  customermatch [varchar] (100) NULL;
alter table categories add  productmatch [varchar] (100) NULL;

alter table oitems add  features [varchar](255) NULL;

alter table prodfeatures add  featureother1[varchar](50) NULL;

alter table orders add  ipaddress [varchar](100) NULL;
alter table orders add  hackeryesno [bit] NULL;
alter table orders add  customercancel [bit] NULL;

alter table products  add  productmatch [varchar](100) NULL;
alter table products  add  customermatch [varchar](100) NULL;
alter table products  add  orderattachment [varchar](255) NULL;
alter table products  add  orderdownload [varchar](255) NULL;
alter table products  add  groupfordiscount [varchar](50) NULL;
alter table products  add  clanguage [varchar](50) NULL;

alter table reviews  add  authorized [varchar](10) NULL;
alter table quantitydiscounts add  groupfordiscount [varchar](100) NULL;

alter table suppliers add  supplieruserid [varchar](100) NULL;
alter table suppliers add  supplierpassword [varchar](100) NULL;

alter table customers  add  productgroup [varchar](50) NULL;
alter table customers  add  cookiequestion [bit];

alter table subcategories add  subcathide [varchar](10) NULL;

alter table customers add pointstotal int NULL default 0;
alter table customers add pointsremaining int NULL default 0;
alter table customers add vatnumber varchar (50) NULL;
alter table orders add opoints int NULL default 0;
alter table orders add vatnumber varchar (50) NULL;
alter table orders add commission money NULL default 0;
alter table products add points int NULL default 0;
alter table products add pointstobuy int NULL;
alter table products add price2 money NULL;
alter table products add price3 money NULL;
alter table categories add catmemo varchar (2000) NULL ;
alter table tbllog add fldipaddress varchar(40) NULL ;
alter table affiliates add referralid int NULL ;
alter table affiliates add mastercommissionrate real NULL ;

create table [dbo].[ordertracking] (
	[trackid] [int] identity (1, 1) not null ,
	[orderid] [int] null ,
	[trackcomment] [varchar] (2000) null ,
	[trackname] [varchar] (100) null ,
	[trackdate] [datetime] null ,
	[tracktime] [datetime] null ,
	[trackview] [bit]  ,
	[trackemail] [varchar] (100) null ,
	[trackother] [varchar] (100) null 
	
) on [primary]; 
go

create table [dbo].[configuration] (
	[id] [int] identity (1, 1) not null ,
	[fieldname] [varchar] (100) null ,
	[fieldvalue] [varchar] (100) null ,
	[fieldgroup] [varchar] (50)  null ,
	[fieldyesno] [bit] 
	
) on [primary]; 
go

create table [dbo].[projects] (
	[pid] [int] identity (1, 1) not null ,
	[pdate] [datetime] null ,
	[description] [varchar] (255) null ,
	[customer] [varchar] (100) null ,
	[customeremail] [varchar] (100) null ,
	[price] [money] null ,
	[dualprice] [money] null ,
	[paid] [varchar] (100) null ,
	[datepaid] [datetime] null ,
	[processed] [bit]  null, 
	[orderid] int null,
	[canceled] bit null,
	[comments] [varchar] (1000) null,
	[other1] [varchar] (100) null ,
	[other2] [varchar] (100) null ,
	[other3] [varchar] (100) null 
	
) on [primary];
go
alter table [dbo].[projects] with nocheck add 
	constraint [df_projects_orderid] default (0) for [orderid],
	constraint [df_projects_price] default (0) for [price],
	constraint [df_projects_dualprice] default (0) for [dualprice],
	constraint [df_projects_processed] default (0) for [processed],
	constraint [df_projects_pdate] default (getdate()) for [pdate],
	constraint [pk_projects] primary key  nonclustered 
	(
		[pid]
	)  on [primary] ;
go

create table [dbo].[registrant] (
 [registrantid] [int] identity (1, 1) not null ,
 [firstname] [varchar] (100) null ,
 [lastname] [varchar] (100) null,
 [address] [varchar] (255) null ,
 [city] [varchar] (100) null ,
 [state] [varchar] (100) null ,
 [postcode] [varchar] (50) null ,
 [country] [varchar] (100) null ,
 [company] [varchar] (100) null ,
 [phone] [varchar] (50) null ,
 [workphone] [varchar] (50) null ,
 [mobilephone] [varchar] (50) null ,
 [fax] [varchar] (50) null ,
 [email] [varchar] (255)  null ,
 [comments] [varchar] (255) null ,
 [logincount] [int] null ,
 [lastlogindate] [datetime] null,
 [regpassword] [varchar] (50) null ,
 [publicpassword] [varchar] (50) null ,
 [eventdate] [datetime] null ,
 [eventtype] [varchar] (255) null ,
 [eventdateend] [datetime] null ,
 [cofirstname] [varchar] (100) null ,
 [colastname] [varchar] (100)  null,
 [coaddress] [varchar] (255) null ,
 [cocity] [varchar] (100) null ,
 [costate] [varchar] (100) null ,
 [copostcode] [varchar] (50) null ,
 [cocountry] [varchar] (100) null ,
 [cophone] [varchar] (50) null ,
 [coemail] [varchar] (255) null ,
 [sendfirstname] [varchar] (50) null ,
 [sendlastname] [varchar] (50)  null,
 [sendaddress] [varchar] (255) null ,
 [sendcity] [varchar] (100) null ,
 [sendstate] [varchar] (100) null ,
 [sendpostcode] [varchar] (50) null ,
 [sendcountry] [varchar] (100) null ,
 [sendphone] [varchar] (50) null ,
 [sendemail] [varchar] (255) null ,
 [regdate] [datetime] null,
 [regtime] [datetime] null,
 [thankyounote] [varchar] (2000) null,
 [shippingtype] [varchar] (50) null,
 [regorderid] [int] null,
 [publicallowed] [varchar] (10) null,
 [regother1] [varchar] (100) null,
 [regother2] [varchar] (100) null
) on [primary];
go

create table registryitems (
 [regitemid] [int] identity (1, 1) not null ,
 [registrantid] [int] null ,
 [orderid] [int] null,
 [regcatalogid] [int] null,
 [numitems] [int] null,
 [itemname] [varchar] (2000) null,
 [unitprice] [money] null,
 [dualprice] [real] null,
 [supplierid] [int] null,
 [address] [varchar] (255) null,
 [numpurchased] [int] null,
 [purchaseorderid] [int] null

) on [primary];
go


alter table [dbo].[registrant] with nocheck add 
	constraint [df_registrant_logincount] default (1) for [logincount],
	constraint [df_registrant_lastlogindate] default (getdate()) for [lastlogindate],
	constraint [pk_registrant] primary key  nonclustered 
	(
		[registrantid]
	)  on [primary]; 
go

alter table [dbo].[registryitems] with nocheck add 
	constraint [df_registryitems_orderid] default (0) for [orderid],
	constraint [df_registryitems_regcatalogid] default (0) for [regcatalogid],
	constraint [df_registryitems_numitems] default (0) for [numitems],
	constraint [df_registryitems_unitprice] default (0) for [unitprice],
	constraint [df_registryitems_dualprice] default (0) for [dualprice],
	constraint [df_registryitems_supplierid] default (0) for [supplierid],
	constraint [pk_registryitems] primary key  nonclustered 
	(
		[regitemid]
	)  on [primary] ;
go
	
	
update categories set highercategoryid=0; 

go
set identity_insert configuration on
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(1,'affallowaffiliatesrevieworders','No','aff',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(2,'affcommissionincludesallorders','No','aff',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(3,'affcommissionIncludesshipping','No','aff',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(4,'affcommissionrate','.10','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(5,'affdirecturl','shopdisplaycategories.asp','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(6,'affinfourl','http://www.yoursite.com/yourinfopage.htm','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(7,'affpaymenttypes','Bank Transfer,Paypal,Check','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(8,'affsubject','Your Affiliate System','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(9,'afftemplateaffiliate','tmp_affiliate.txt','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(10,'afftemplateMerchant','tmp_affmerchant.txt','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(11,'affwebsite','http://www.yoursite.com','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(12,'xaddcatalogid','Yes','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(13,'xaddproductsubcategorybycategory','No','security',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(14,'xaddproductsupplierdropdown','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(15,'xadminmenucheck','No','security',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(16,'xadminpage','shopadmin.asp','security',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(17,'xadminrestrictproducts','Yes','security',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(18,'xaffiliatedb','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(19,'xaffiliateusecookies','Yes','aff',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(20,'xallowcoupons','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(21,'xallowcreditcards','Yes','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(22,'xallowcustomerupdates','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(23,'xallowdecimalquantity','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(24,'xallowinvalidcards','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(25,'xallowmaillist','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(26,'xalloworderreview','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(27,'xallowotherpayments','Yes','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(28,'xallowratingproducts','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(29,'xallowratingsummary','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(30,'xallowrestoreorder','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(31,'xallowrevieworders','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(32,'xallowsavecart','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(33,'xallowsubsubcategories','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(34,'xallowsupplierlogin','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(35,'xallowsupplierregister','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(36,'xbuttonaddressadd','vpnav_addressadd.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(37,'xbuttonaddresschange','vpnav_addresschange.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(38,'xbuttoncancel','vpnav_cancelorder.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(39,'xbuttoncheckout','vpnav_checkout.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(40,'xbuttoncontinue','vpnav_continue.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(41,'xbuttoncontinueshopping','vpnav_continueshopping.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(42,'xbuttonimage','vpnav_buy.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(43,'xbuttonlogin','vpnav_login.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(44,'xbuttonmoreinfo','vpnav_moreinfo.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(45,'xbuttonorderproduct','vpnav_orderselected.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(46,'xbuttonreadreview','vpnav_readreview.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(47,'xbuttonrecalculate','vpnav_recalculate.gif','buttons',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(48,'xbuttonremove','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(49,'xbuttonreset','vpnav_reset.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(50,'xbuttonsearch','vpnav_search.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(51,'xbuttontellafriend','vpnav_tellafriend.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(52,'xbuttontext','Order','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(53,'xbuttonwritereview','vpnav_writereview.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(54,'xcardissueNumber','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(55,'xcartfields','cname,cdescription','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(56,'xcartremovechecked','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(57,'xcategoryproductsonly','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(58,'xcatmaxcolumns','3','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(59,'xcheckexistingcustomer','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(60,'xcheckmaillist','No','security',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(61,'xcheckout','shopcheckout.asp','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(62,'xcheckstocklevel','No','stock',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(63,'xcontinueshopping','shopdisplaycategories.asp','products1',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(64,'xconverteuropeannumbers','No','int',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(65,'xcookielogin','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(66,'xcountryrequired','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(67,'xcreditcardtypes','Visa,Mastercard,American Express','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(68,'xcrosslinkurl','shopquery.asp','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(69,'xcrossselling','Yes','products',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(70,'xcurrencysymbol','int',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(71,'xcustomerdb','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(72,'xcustomeremail','tmp_customeremail.txt','templates',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(73,'xcustomermaxotherfields','50','customer',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(74,'xcustomerothercaptions','customer',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(75,'xcustomerotherfields','customer',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(76,'xcustomerotherrequired','customer',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(77,'xcustomerprices','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(78,'xcvndisplay','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(79,'xcvnrequired','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(80,'xdebug','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(81,'xdecimalpoint','2','int',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(82,'xdefaultshippingmethod','Yes','shipping',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(83,'xdeliveryaddress','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(84,'xdeliveryrequired','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(85,'xdeliveryshipping','No','shipping',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(86,'xdisplaycategoryimages','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(87,'xdisplayoriginalprice','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(88,'xdisplayprices','Yes','products1',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(89,'xdualconversionrate','int',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(90,'xdualprice','No','int',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(91,'xeditdisplaymaxrecords','20','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(92,'xemail','you@youremail.com','main',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(93,'xemailcustomer','Yes','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(94,'xemailformat','Text','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(95,'xemaillist','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(96,'xemailmerchant','Yes','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(97,'xemailname','VP-ASP Shopping Cart','main',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(98,'xemailsubject','Shopping Order','main',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(99,'xemailsystem','mail.yourmailsystem.com','main',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(100,'xemailtype','CDONTS','main',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(101,'xencryptcreditcard','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(102,'xencryptkey','agabAhjBcG','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(103,'xendoforderattachmentfield','orderattachment','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(104,'xendoforderattachments','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(105,'xendoforderhyperlinkfield','orderdownload','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(106,'xendoforderhyperlinks','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(107,'xendofordervalidpayments','Visa,Mastercard','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(108,'xenvironment','NT','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(109,'xextendedpopup','No','products',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(110,'xfeaturesort','featurename','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(111,'xfeaturesrequired','No','products',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(112,'xfont','<font face=''verdana,arial,helvetica'' size=2 color=''#BB0000''>','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(113,'xframes','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(114,'xgenerateshopexdlink','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(115,'xgeneratesku','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(116,'xgiftautoenable','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(117,'xgiftcertificates','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(118,'xgiftexpirydays','365','option',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(119,'xgiftlimit','100','option',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(120,'xgiftprefix','Gift','option',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(121,'xgiftproductid','99999','option',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(122,'xgifttemplate','tmp_gift.txt','templates',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(123,'xhandlingprice','0','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(124,'xhome','default.htm','main',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(125,'xhome1','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(126,'ximportmatchfield','catalogid','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(127,'xincludecountries','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(128,'xincludeoidonlink','Yes','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(129,'xincludestates','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(130,'xkeepcanceleditems','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(131,'xkeepcanceledorders','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(132,'xlanguage','ENGLISH','int',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(133,'xlcid','int',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(134,'xlogonrequired','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(135,'xmaillistcheckbox','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(136,'xmaillisttable','customers','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(137,'xmaillisttomerchant','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(138,'xmailtosuppliers','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(139,'xmaxcartitems','20','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(140,'xmaxcategories','100','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(141,'xmaxfeaturecaptions','100','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(142,'xmaxfeatures','4','products1',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(143,'xmaxproductoptions','100','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(144,'xmaxsavedcarts','100','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(145,'xmaxsubcategories','100','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(146,'xmerchantemail','tmp_merchantemail.txt','templates',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(147,'xminimumorder','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(148,'xmysite','http://www.yourvpaspsite.com/shopping','products1',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(149,'xmysql','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(150,'xnavigatecategories','Yes','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(151,'xnavigateminicart','Yes','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(152,'xoldcategorymode','Yes','advanced',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(153,'xorderdb','advanced',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(154,'xotherdatabases','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(155,'xotherpaymenttypes','Check,Cash,Phone order','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(156,'xothertables','advanced',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(157,'xoutofstocklimit','stock',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(158,'xpassword','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(159,'xpasswordlastname','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(160,'xproductcatalogonly','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(161,'xproductcolumns','1','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(162,'xproductfields','cname,cdescription,quantity,cprice','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(163,'xproductgroupdiscount','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(164,'xratingproducthyperlink','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(165,'xproductlinktellafriend','No','products',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(166,'xproductmatch','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(167,'xproductmatchcustomer','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(168,'xproductmulticategories','No','advanced',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(169,'xproductothercaptions','advanced',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(170,'xproductotherfields','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(171,'xproductquantitylimit','9999','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(172,'xproductselect','Yes','products',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(173,'xproductsperpage','10','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(174,'xproducttemplate','tmp_product.htm','templates',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(175,'xproductwithhtml','No','products',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(176,'xpromptforcountry','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(177,'xpromptforlogin','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(178,'xpromptforoptional','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(179,'xpromptforstate','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(180,'xquantityprices','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(181,'xratingmailtomerchant','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(182,'xratingtemplate','tmp_rating.txt','templates',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(183,'xrestrictadmintables','Yes','security',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(184,'xrestrictedtoexisting','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(185,'xratingauthorize','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(186,'xsearchcapture','No','advanced',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(187,'xsearchdb','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(188,'xsearchdisplaycategories','Yes','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(189,'xsearchdisplaysubcat','Yes','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(190,'xsearchfields','cname,cdescription,ccode,mfg','products1',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(191,'xselectproductsbylanguage','No','int',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(192,'xsessiontimeout','10','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(193,'xshippingcalc','Lookup','shipping',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(194,'xshippingdatabaserecords','Yes','shipping',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(195,'xshippingform','Yes','shipping',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(196,'xshowadmin','Yes','security',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(197,'xsortcategories','catdescription','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(198,'xsortproducts','specialoffer desc,cname','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(199,'xsortsubcategories','subcategory','advanced',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(200,'xssl','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(201,'xstockcontrol','No','stock',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(202,'xstocklow','stock',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(203,'xsubcatmaxcolumns','1','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(204,'xsupplieremail','tmp_supplieremail.txt','templates',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(205,'xtaxbyproduct','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(206,'xtaxcountryname','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(207,'xtaxcountryrates','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(208,'xtaxstatename','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(209,'xtaxstaterates','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(210,'xtimedifference','int',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(211,'xtracking','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(212,'xtrackingcustomerread','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(213,'xtrackingcustomertemplate','tmp_trackingcustomer.txt','templates',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(214,'xtrackingmerchanttemplate','tmp_trackingmerchant.txt','templates',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(215,'xtrackingmessagetemplate','tmp_trackingmessage.txt','templates',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(216,'xprojectdb','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(217,'xprojectcatalogid','9998','option',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(218,'xstaterequired','Yes','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(219,'xbypasscreateorderpage','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(220,'xemailwithtemplates','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(221,'xemailremovehtml','Yes','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(222,'xfixedshippingmethod','How you want to ship','shipping',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(223,'xfixedshippingcost','0','shipping',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(224,'xmerchantshipzip','99999','shipping',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(225,'xshippingalternate','Lookup','shipping',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(226,'xtrackingcustomerwrite','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(227,'xshippingundercustomer','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(228,'xbuttonnextpage','vpnav_nextpage.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(229,'xbuttonpreviouspage','vpnav_previouspage.gif','buttons',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(230,'xproductpagingnextprevious','No','products',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(231,'xcustomerotherfieldsinorder','No','customer',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(232,'xuploaddirectory','advanced',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(233,'xupload','Yes','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(234,'xprojecttemplate','tmp_project.txt','templates',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(235,'xproductdisplaytemplate','tmp_productformat.htm','products',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(236,'xproductstayonpage','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(237,'xallowcustomerregister','Yes','customer',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(238,'xdiscountlimit','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(239,'xdiscountamount','payment',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(240,'xmaximumorder','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(241,'xshopclosed','No','customer',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(242,'xgiftregistry','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(243,'xdateformat','dd mm yyyy','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(244,'xprojectupdate','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(245,'xpointsredeem','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(246,'xcategorydisplaytext','Yes','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(247,'xcategoryusetemplate','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(248,'xcategorydisplaytemplate','tmp_categorytemplate.htm','products1',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(249,'xsearchsortfields','products1',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(250,'xsearchsortcaptions','products1',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(251,'xcustomerpricetypes','customer',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(252,'xcustomerpricefields','customer',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(253,'xcustomerpriceidentifier','contacttypeid','customer',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(254,'affmultilevel','Yes','aff',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(255,'affmastercommissionrate','.05','aff',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(256,'affcommissioncategory','No','aff',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(257,'affcommissionproduct','No','aff',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(258,'xtaxincludedinprice','No','payment',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(259,'xorderstatus','Shipped,Back Order,Waiting payment','customer',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(260,'xvatnumber','No','customer',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(261,'xvatcountry','customer',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(262,'xpoints','No','option',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(263,'xpointsfield','points','option',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(264,'xcartstaticquantity','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(265,'xautoloadconfiguration','Yes','advanced',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(266,'xshippingotherfields','shipping',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(267,'xshippingothercaptions','shipping',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(268,'xshippingotherequired','shipping',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(269,'xshippingsetfields','No','shipping',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(270,'xproductfiltering','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(271,'xtaxeucountries','UK,ES,IT,FR,DE,NL,DK,GR,EN,PT,FI,SE,IE,LU,BE','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(272,'xtaxeurate','.175','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(273,'xtaxeu','No','payment',1);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(274,'affcommissionproductfield','aff',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(275,'affcommissioncategories','aff',0);
Insert into configuration(id,fieldname,fieldgroup,fieldyesno) values(276,'xtaxexcludeproducts','payment',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(277,'xproductminimumquantity','No','products1',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(278,'xproductminimumlist','6','products1',0);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(279,'xcategoriessimple','No','advanced',1);
Insert into configuration(id,fieldname,fieldvalue,fieldgroup,fieldyesno) values(280,'xcontactform','Yes','customer',1);
go
set identity_insert configuration off
go