create table [dbo].[configuration] (
 [id] [int] identity (1, 1) not null,
 [fieldname] [nvarchar] (50) null,
 [fieldvalue] [nvarchar] (255) null,
 [fieldgroup] [nvarchar] (50) null,
 [fieldyesno] [bit] null,
 [message] [nvarchar] (2000) null,
 [showfield] [nvarchar] (50) null,
 [fieldgroup2] [nvarchar] (50) null
) on [primary];
create table [dbo].[configuration1] (
 [id] [int] identity (1, 1) not null,
 [fieldname] [nvarchar] (100) null,
 [fieldvalue] [nvarchar] (255) null,
 [fieldgroup] [nvarchar] (50) null,
 [fieldyesno] [bit] null,
 [message] [nvarchar] (2000) null,
 [showfield] [nvarchar] (50) null,
 [fieldgroup2] [nvarchar] (50) null
) on [primary];
create table [dbo].[content] (
 [contentid] [int] identity (1, 1) not null, 
 [messagetype] [nvarchar] (100) null, 
 [message] [ntext] null, 
 [message2] [ntext] null, 
 [contentimage] [nvarchar] (255) null, 
 [hide] [bit] null, 
 [template] [nvarchar] (255) null, 
 [contentlanguage] [nvarchar] (50) null, 
 [other1] [nvarchar] (255) null, 
 [other2] [nvarchar] (255) null, 
 [other3] [nvarchar] (255) null,
 [loggedin] [bit] null,
 [impressions] [int] null,
 [cdateadded] [datetime] null,
 [cdateupdated] [datetime] null
) on [primary];
create table [dbo].[ordertracking] (
 [trackid] [int] identity (1, 1) not null,
 [orderid] [int] null,
 [trackcomment] [nvarchar] (2000) null,
 [trackname] [nvarchar] (100) null,
 [trackdate] [datetime] null,
 [tracktime] [datetime] null,
 [trackview] [bit],
 [trackemail] [nvarchar] (100) null,
 [trackother] [nvarchar] (100) null
) on [primary];
create table [dbo].[prodcategories] (
 [id] [int] identity (1, 1) not null,
 [intcategoryid] [int] null,
 [intcatalogid] [int] null
) on [primary];
create table [dbo].[projects] (
 [pid] [int] identity (1, 1) not null,
 [pdate] [datetime] null,
 [description] [nvarchar] (255) null,
 [customer] [nvarchar] (100) null,
 [customeremail] [nvarchar] (100) null,
 [price] [money] null,
 [dualprice] [money] null,
 [paid] [nvarchar] (100) null,
 [datepaid] [datetime] null,
 [processed] [bit] null, 
 [orderid] int null,
 [canceled] bit null,
 [comments] [nvarchar] (1000) null,
 [other1] [nvarchar] (100) null,
 [other2] [nvarchar] (100) null,
 [other3] [nvarchar] (100) null, 
 [billid] int Null,
 [billdescription] nvarchar(2000) Null
) on [primary];
create table [dbo].[registrant] (
 [registrantid] [int] identity (1, 1) not null,
 [firstname] [nvarchar] (100) null,
 [lastname] [nvarchar] (100) null,
 [address] [nvarchar] (255) null,
 [city] [nvarchar] (100) null,
 [state] [nvarchar] (100) null,
 [postcode] [nvarchar] (50) null,
 [country] [nvarchar] (100) null,
 [company] [nvarchar] (100) null,
 [phone] [nvarchar] (50) null,
 [workphone] [nvarchar] (50) null,
 [mobilephone] [nvarchar] (50) null,
 [fax] [nvarchar] (50) null,
 [email] [nvarchar] (255) null,
 [comments] [nvarchar] (255) null,
 [logincount] [int] null,
 [lastlogindate] [datetime] null,
 [regpassword] [nvarchar] (50) null ,
 [publicpassword] [nvarchar] (50) null,
 [eventdate] [datetime] null,
 [eventtype] [nvarchar] (255) null,
 [eventdateend] [datetime] null,
 [cofirstname] [nvarchar] (100) null,
 [colastname] [nvarchar] (100) null,
 [coaddress] [nvarchar] (255) null,
 [cocity] [nvarchar] (100) null,
 [costate] [nvarchar] (100) null,
 [copostcode] [nvarchar] (50) null,
 [cocountry] [nvarchar] (100) null,
 [cophone] [nvarchar] (50) null,
 [coemail] [nvarchar] (255) null,
 [sendfirstname] [nvarchar] (50) null,
 [sendlastname] [nvarchar] (50)  null,
 [sendaddress] [nvarchar] (255) null,
 [sendcity] [nvarchar] (100) null,
 [sendstate] [nvarchar] (100) null,
 [sendpostcode] [nvarchar] (50) null,
 [sendcountry] [nvarchar] (100) null,
 [sendphone] [nvarchar] (50) null,
 [sendemail] [nvarchar] (255) null,
 [regdate] [datetime] null,
 [regtime] [datetime] null,
 [thankyounote] [nvarchar] (2000) null,
 [shippingtype] [nvarchar] (50) null,
 [regorderid] [int] null,
 [publicallowed] [nvarchar] (10) null,
 [processed] [bit] null
) on [primary];
create table [dbo].[registryitems] (
 [regitemid] [int] identity (1, 1) not null,
 [registrantid] [int] null,
 [orderid] [int] null,
 [regcatalogid] [int] null,
 [numitems] [int] null,
 [itemname] [nvarchar] (4000) null,
 [unitprice] [money] null,
 [dualprice] [real] null,
 [supplierid] [int] null,
 [address] [nvarchar] (255) null,
 [numpurchased] [int] null,
 [purchaseorderid] [nvarchar] (4000) null
) on [primary];
create table [dbo].[reviews] (
 [id] [int] identity (1,1) not null,
 [catalogid] [int] null,
 [reviewdate] [datetime] null,
 [reviewtime] [datetime] null,
 [rating] [int] null,
 [title] [nvarchar] (255) null,
 [comment] [nvarchar] (2000) null,
 [location] [nvarchar] (100) null,
 [name] [nvarchar] (100) null,
 [email] [nvarchar] (100) null,
 [other1] [nvarchar] (100) null,
 [other2] [nvarchar] (100) null,
 [authorized] [nvarchar] (10) null
) on [primary];
create table [dbo].[shopcountries] (
 [countryid] [int] identity (1,1) not null,
 [country] [nvarchar] (10) null,
 [countryname] [nvarchar] (100) null,
 [countrydisplayorder] [float] null,
 [countryhide] [bit] null,
 [countrytaxrate] [real] null,
 [countrygroup] [nvarchar] (50) null
) on [primary];
create table [dbo].[shoprma] (
 [rmaid] [int] identity (1,1) not null,
 [rma] [nvarchar] (100) null, 
 [rmacreationdate] [DateTime]  null,
 [rmacustomeraction] [nvarchar] (100) null,
 [rmamerchantaction] [nvarchar] (100) null,
 [rmaorderid] [float] null,
 [rmaitemid] [float] null,
 [rmacustomername] [nvarchar] (155) null,
 [rmacustomeremail] [nvarchar] (255) null,
 [rmacustomerid] [float] null,
 [rmarefundamount] [money] null,
 [rmamerchantdate] [DateTime] null,
 [rmamerchantname] [nvarchar] (155) null,
 [rmamerchantemail] [nvarchar] (100) null,
 [rmaother1] [nvarchar] (255) null,
 [rmaother2] [nvarchar] (255) null,
 [rmaprocessed] [bit] null,
 [rmaproductname] [nvarchar] (255) null,
 [rmacustomercomment] [nvarchar] (4000) null,
 [rmamerchantcomment] [nvarchar] (4000) null,
 [rmamerchantnotes] [nvarchar] (4000) null
) on [primary];
create table [dbo].[shopstates] (
 [stateid] [int] identity (1,1) not null,
 [stateabbrev] [nvarchar] (20) null,
 [statename] [nvarchar] (100) null,
 [statecountry] [nvarchar] (50) null,
 [statehide] [bit] null,
 [statetaxrate] [real] null,
 [statecanadapst] [real] null
) on [primary];
create table [dbo].[sitesessions] (
 [id] [int] identity (1,1) not null, 
 [sessionkey] [nvarchar] (50) null, 
 [sessionvaluename] [nvarchar] (100) null, 
 [sessiondate] [datetime] null,
 [sessiontime] [datetime] null,
 [sessionnow] [nvarchar] (50) null,
 [sessionvalue] [ntext] null
) on [primary];
create table [dbo].[suppliers] (
 [supplierid] [int] identity (1,1) not null, 
 [name] [nvarchar] (255) null, 
 [supplieruserid] [nvarchar] (100) null, 
 [firstname] [nvarchar] (50) null, 
 [lastname] [nvarchar] (50) null, 
 [address] [nvarchar] (255) null, 
 [city] [nvarchar] (100) null, 
 [state] [nvarchar] (100) null, 
 [postcode] [nvarchar] (20) null, 
 [country] [nvarchar] (100) null, 
 [company] [nvarchar] (255) null, 
 [phone] [nvarchar] (50) null, 
 [workphone] [nvarchar] (30) null, 
 [mobilephone] [nvarchar] (30) null, 
 [fax] [nvarchar] (30) null, 
 [email] [nvarchar] (50) null, 
 [comments] [nvarchar] (255) null, 
 [logincount] [Int] null, 
 [lastlogindate] [datetime] null, 
 [website] [nvarchar] (200) null, 
 [supplierpassword] [nvarchar] (50) null, 
 [accountno] [nvarchar] (50) null, 
 [template] [nvarchar] (100) null, 
 [commissionrate] [real] null, 
 [other1] [nvarchar] (100) null
) on [primary];
create table [dbo].[affiliatelog] (
 [afflogid] [int] identity (1,1) not null, 
 [affid] [Int] null, 
 [affdate] [Datetime] null, 
 [afftime] [Datetime] null, 
 [affdirecturl] [nvarchar] (255) null, 
 [affreferrer] [nvarchar] (255) null, 
 [affcookie] [bit] null, 
 [affother1] [nvarchar] (255) null
) on [primary];
create table [dbo].[billing] (
 [billid] [int] identity (1,1) not null, 
 [billamount] [money] Null,
 [billnextbilldate] [datetime] Null,
 [billcustomer] [nvarchar] (255) Null,
 [billemail] [nvarchar] (100) Null,
 [billdescription] [nvarchar] (2000) Null,
 [billinstallments] [int] Null,
 [billinstallmenttype] [nvarchar] (50) Null,
 [billinterval] [int] Null,
 [billlastbilldate] [datetime] Null,
 [billorderid] [int] Null,
 [billlastmaildate] [datetime] Null,
 [billsentcount] [int] Null,
 [billcanceled] [bit] Null,
 [billcompleted] [bit] Null,
 [billcreationdate] [datetime] Null,
 [billorderitemid] [int] Null,
 [billenddate] [datetime] Null,
 [billtemplate] [nvarchar] (100) Null,
 [billother1] [nvarchar] (100) Null,
 [billother2] [nvarchar] (100) Null
) on [primary];
create table [dbo].[pinnumbers] (
 [serialid] [int] identity (1, 1) not null,
 [catalogid] [int] null,
 [pinnumber] [nvarchar] (255) null,
 [orderid] [int] null,
 [pinproductmatch] [nvarchar] (40) null,
 [pinother1] [nvarchar] (255) null
)on [primary];
create table [dbo].[hackers] (
 [hackerid] [int] identity (1, 1) not null, 
 [ipaddress] [nvarchar] (50) null, 
 [email] [nvarchar] (200) null, 
 [comment] [nvarchar] (255) null, 
 [other] [nvarchar] (100) null
) on [primary];
create table [dbo].[languages] (
 [id] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (50) null, 
 [keyword] [nvarchar] (50) null, 
 [caption] [nvarchar] (2000) null
) on [primary];
create table [dbo].[savedcarts] (
 [id] [int] identity (1, 1) not null, 
 [cartname] [nvarchar] (100) null, 
 [customerid] [Int] null, 
 [cartcookies] [nvarchar] (2000) null, 
 [savedate] [Datetime] null, 
 [savetime] [Datetime] null, 
 [other1] [nvarchar] (100) null,
 [catalogid] int null
) on [primary];
create table [dbo].[templates] (
 [id] [int] identity (1, 1) not null, 
 [templatename] [nvarchar] (100) null, 
 [template] [nvarchar] (4000) null
) on [primary];
create table [dbo].[downloads] (
 [id] [int] identity (1, 1) not null, 
 [orderid] [Int] null, 
 [catalogid] [Int] null, 
 [customerid] [Int] null, 
 [filename] [nvarchar] (255) null, 
 [downloadcount] [Int] null, 
 [downloaddatelimit] [Datetime] null, 
 [downloadmaxcount] [Int] null, 
 [downloadcreatedate] [Datetime] null, 
 [downloadother] [nvarchar] (100) null, 
 [downloadother1] [nvarchar] (100) null, 
 [authorized] [nvarchar] (10) null, 
 [lastdownloaddate] [Datetime] null
) on [primary];
create table [dbo].[currencyvalues] (
 [id] [int] identity (1, 1) not null,
 [cid] [nvarchar] (50) null,
 [fullunitname] [nvarchar] (50) null,
 [conversionvalue] [float] null,
 [currencysymbol] [nvarchar] (100) null,
 [theimage] [nvarchar] (100) null,
 [hide] [bit] null
) on [primary];
create table [dbo].[searchresults] (
 [id] [int] identity (1, 1) not null,
 [rdate] [datetime] null,
 [rtime] [datetime] null,
 [categories] [nvarchar] (200) null,
 [subcategories] [nvarchar] (200) null,
 [words] [nvarchar] (255) null,
 [lastname] [nvarchar] (50) null,
 [customerid] [int] null,
 [ipaddress] [nvarchar] (50) null,
 [rother1] [nvarchar] (100) null,
 [rother2] [nvarchar] (100) null
) on [primary];
create table [dbo].[translatecategories] (
 [translateid] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (100) null, 
 [categoryid] [Int] null, 
 [catdescription] [nvarchar] (255) null
) on [primary];
create table [dbo].[translateprodfeatures] (
 [translateid] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (100) null, 
 [id] [Int] null, 
 [featurecaption] [nvarchar] (100) null, 
 [featurename] [nvarchar] (255) null
) on [primary];
create table [dbo].[translateproducts] (
 [translateid] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (100) null, 
 [catalogid] [Int] null, 
 [cdescription] [nvarchar] (2000) null, 
 [cname] [nvarchar] (255) null, 
 [extendeddesc] [nvarchar] (2000) null
) on [primary];
create table [dbo].[translatecontent] (
 [translateid] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (100) null, 
 [contentid] [Int] null, 
 [message] [ntext] null, 
 [message2] [ntext] null
) on [primary];
create table [dbo].[menuitem] (
 [id] [int] identity (1, 1) not null,
 [name] [nvarchar] (50) null,
 [seq] [int] null,
 [pmenuitemid] [int] null,
 [url] [nvarchar] (255) null,
 [contentid] [int] null,
 [openin] nvarchar (100) null,
 [productmatch] nvarchar (100) null

) on [primary];
create table [dbo].[ups_config] (
 [upsid] [int] identity (1, 1) not null, 
 [xzeroweighterror] [nvarchar] (10) null,
 [xautoseparateweight] [nvarchar] (10) null,
 [xautoseparatepackages] [nvarchar] (10) null,
 [xsuppliershipfield] [nvarchar] (30) null,
 [xusesupplierzip] [nvarchar] (10) null,
 [xindividualpackages] [nvarchar] (10) null,
 [ups_weightunits] [nvarchar] (10) null,
 [ups_residentialind] [nvarchar] (10) null,
 [ups_unitofmeasurement] [nvarchar] (10) null,
 [packagingtype] [nvarchar] (10) null,
 [pickuptype] [nvarchar] (10) null,
 [xmerchantcountry] [nvarchar] (10) null,
 [xmerchantstate] [nvarchar] (10) null,
 [xmerchantcity] [nvarchar] (50) null,
 [xmerchantpostcode] [nvarchar] (20) null,
 [accesslicencenum] [nvarchar] (50) null,
 [username] [nvarchar] (50) null,
 [password] [nvarchar] (50) null,
 [developerkey] [nvarchar] (50) null,
 [gatewaylocation_license] [nvarchar] (50) null,
 [gatewaylocation_register] [nvarchar] (50) null,
 [xml] [nvarchar] (10) null,
 [xcheckindividualproductfield] [nvarchar] (10) null,
 [xcheckindividualproduct] [nvarchar] (10) null,
 [xdimensionfield] [nvarchar] (30) null,
 [ups_dimensions] [nvarchar] (20) null,
 [gatewaylocation_paymenttesting] [nvarchar] (50) null,
 [gatewaylocation_payment] [nvarchar] (50) null,
 [testmode] [nvarchar] (10) null,
 [xupsacctno] [nvarchar] (20) null,
 [dimensions] [nvarchar] (20) null,
 [xtrace] [nvarchar] (10) null,
 [xtracexml] [nvarchar] (10) null,
 [gatewaylocation_trackingtesting] [nvarchar] (50) null,
 [gatewaylocation_tracking] [nvarchar] (50) null	
) on [primary];
table catgories;
alter table categories add cathide nvarchar(10) NULL;
alter table categories add highercategoryid int;
alter table categories add customermatch nvarchar(50) Null;
alter table categories add productmatch nvarchar(50) Null;
alter table categories add catmemo nvarchar(2000) NULL ;
alter table categories add catlanguage nvarchar (50) null;
alter table categories add catproducttemplate nvarchar (255) null;
table prodfeatures;
alter table prodfeatures add featurerequired bit NULL;
alter table prodfeatures add featureother1 nvarchar(50) NULL;
alter table prodfeatures add featureimage nvarchar (255) null;
alter table prodfeatures add featureweight real null;
alter table prodfeatures add featurepercent real null;
alter table prodfeatures add featuredefault bit null;
table oitems;
alter table oitems add address nvarchar(2000) NULL;
alter table oitems add supplierid real NULL;
alter table oitems add features nvarchar(255) NULL;
alter table oitems add pinnumber nvarchar (255) null;
table orders;
alter table orders add canceled bit NULL;
alter table orders add ipaddress nvarchar(100) NULL;
alter table orders add hackeryesno bit NULL;
alter table orders add customercancel bit NULL;
alter table orders add opoints int NULL default 0;
alter table orders add vatnumber nvarchar (50) NULL;
alter table orders add commission money NULL Default 0;
alter table orders add opending nvarchar (100) null;
alter table orders add shipmessage nvarchar (255) null;
alter table orders add hearaboutus nvarchar (100) null;
alter table orders add affdatepaid datetime null;
alter table orders add affpaid bit null;
table products;
alter table products add crossselling nvarchar(255) NULL;
alter table products add supplierid real NULL;
alter table products add hide bit NULL;
alter table products add productmatch nvarchar(100) NULL;
alter table products add customermatch nvarchar(100) NULL;
alter table products add orderattachment nvarchar(255) NULL;
alter table products add orderdownload nvarchar(255) NULL;
alter table products add groupfordiscount nvarchar(50) NULL;
alter table products add clanguage nvarchar(50) NULL;
alter table products add points int NULL default 0;
alter table products add price2 money NULL;
alter table products add price3 money NULL;
alter table products add pointstobuy int NULL default 0;
alter table products add billprice money  null;
alter table products add billinstallments int  null; 
alter table products add billinstallmenttype nvarchar (50) null;
alter table products add billinterval int  null;
alter table products add maximumquantity int  null;
alter table products add frontpage nvarchar (100) null;
table projects;
alter table projects add  billid int  null;
alter table projects add billdescription nvarchar (2000) null;
table reviews;
alter table reviews add authorized nvarchar(10) NULL;
table shipmethods;
alter table shipmethods add shipcountry nvarchar (50) NULL;
table quantitydiscounts;
alter table quantitydiscounts add groupfordiscount nvarchar(100) NULL;
table suppliers;
alter table suppliers add supplieruserid nvarchar(100) NULL;
alter table suppliers add supplierpassword nvarchar(100) NULL;
table customers;
alter table customers add maillist bit NULL;
alter table customers add productgroup nvarchar(50) NULL;
alter table customers add cookiequestion bit;
alter table customers add pointstotal int NULL default 0;
alter table customers add pointsremaining int NULL default 0;
alter table customers add vatnumber nvarchar (50) NULL;
alter table customers add userid nvarchar (50) null;
alter table customers add hearaboutus nvarchar (100) null;
alter table customers add taxexempt nvarchar (50) null;
table tbllog;
alter table tbllog add fldipaddress nvarchar(40) NULL ;
table affiliates;
alter table affiliates add template nvarchar (200) null;
alter table affiliates add referralid int null;
alter table affiliates add mastercommissionrate real NULL ;
update categories set highercategoryid=0 where highercategoryid is null;

' 5.50
table orders;
alter table orders add oaddress2  nvarchar(100) NULL;
alter table orders add oshipaddress2  nvarchar(100) NULL;
alter table orders add deliverydate nvarchar(20) NULL;
alter table orders add deliverytime nvarchar(20) NULL;
alter table orders add producttotal money NULL;
table customers;
alter table customers add address2 nvarchar(100) NULL;
table coupons;
alter table coupons add couponcustomers nvarchar(255) NULL;
alter table coupons add couponminimum money NULL;
table configuration;
alter table configuration add message nvarchar(2000) NULL;
table registrant;
alter table registrant add processed bit NULL;
table products;
alter table products add inventoryproducts  nvarchar(255) NULL;
alter table products add taxfree  bit NULL;
alter table products add freeshipping bit NULL;
table savedcarts;
alter table savedcarts add catalogid int null;
table configuration1;
alter table configuration1 add message nvarchar(2000) NULL;

' 6.00
table categories;
alter table categories add [impressions] [int] null;
table configuration;
alter table configuration add [showfield] [nvarchar] (50) null;
alter table configuration add [fieldgroup2] [nvarchar] (50) null;
table configuration1;
alter table configuration1 add [showfield] [nvarchar] (50) null;
alter table configuration1 add [fieldgroup2] [nvarchar] (50) null;
table content;
alter table content add [loggedin] [bit] null;
alter table content add [impressions] [int] null;
alter table content add [cdateadded] [datetime] null;
alter table content add [cdateupdated] [datetime] null;
table coupons;
alter table coupons add [couponaffid] [int] null;
table products;
alter table products add [highercatalogid] [int] null;
alter table products add [spdisplaytype] [nvarchar] (50) null;
alter table products add [hassubproduct] [nvarchar] (50) null;
alter table products add [impressions] [float] null;
alter table products add [cdateadded] [datetime] null;
alter table products add [cdateupdated] [datetime] null;
alter table products add [templatelisting] [nvarchar] (100) null;
alter table products add [rmadays] [float] null;
table tblaccess;
alter table tblaccess add [fldsection] [nvarchar] (50) null;
alter table tblaccess add [fldmenu] [nvarchar] (50) null;
alter table tblaccess add [fldorder] [nvarchar] (50) null ;
table orders;
ALTER TABLE orders ADD [upstrackno] nvarchar (50) null;

'6.50
table categories;
alter table categories add catextra2 nvarchar (255) null;
alter table categories add catextra3 nvarchar (255) null;
table customers;
ALTER TABLE customers ADD authorized nvarchar(10) NULL;
table menuitem;
alter table menuitem ADD productmatch nvarchar(255) null;
table oitems;
alter table oitems ADD customerimage nvarchar(255) null;
table orders;
alter table orders add opst money null;
alter table orders add odualpst money null;
alter table orders add otermsagreed nvarchar (10) null;
alter table orders add ocurrency nvarchar (50) null;
alter table orders add ocurrencyrate real null;
alter table orders add affpaid bit null;
alter table orders add affdatepaid datetime null;
table products;
alter table products add extraimage1 nvarchar (100) null;
alter table products add extraimage2 nvarchar (100) null;
alter table products add extraimage3 nvarchar (100) null;
alter table products add extraimage4 nvarchar (100) null;
alter table products add extraimage5 nvarchar (100) null;
alter table products add featuredflag bit null;
alter table products add customerimage bit null;
table tbluser;
alter table tbluser add shortcut nvarchar (1000);
table content;
alter table content add homepage bit null;

'7.01
table affiliatelog;
alter table [dbo].[affiliatelog] with nocheck add constraint [pk_affiliatelog] primary key nonclustered ([afflogid]) on [primary];

create table [dbo].[blogs] (
 [blogsid] [int] identity (1, 1) not null ,
 [messagetype] [nvarchar] (100) null, 
 [headline] [nvarchar] (100) null,
 [blogsimage] [nvarchar] (255) null,
 [hide] [bit] null, 
 [template] [nvarchar] (255) null,
 [blogslanguage] [nvarchar] (50) null,
 [other1] [nvarchar] (255) null, 
 [other2] [nvarchar] (255) null, 
 [other3] [nvarchar] (255) null,
 [loggedin] [bit] null,
 [impressions] [float] null, 
 [cdateadded] [Datetime] null, 
 [cdateupdated] [Datetime] null,
 [fullname] [nvarchar] (255) null,
 [contactid] [nvarchar] (255) null,
 [contentgroups] [nvarchar] (255) null,
 [excontentgroups] [nvarchar] (255) null,
 [showonbox] [bit] null,
 [cBlogsStartDate] [Datetime] null,
 [cBlogsEndDate] [Datetime] null,
 [showonhomepage] [bit] null,
 [archive] [bit] null,
 [metatitle] [nvarchar] (255) null,
 [smFrequency] [nvarchar] (255) null,
 [smPriority] [nvarchar] (255) null,
 [gsmincluded] [nvarchar] (10) null,
 [metakeywords] [ntext] null,
 [metadescription] [ntext] null,
 [message] [ntext] null,
 [userid] [nvarchar] (50) null
) on [primary];
alter table [dbo].[blogs] with nocheck add constraint [pk_blogs] primary key nonclustered ([blogsid]) on [primary];

table configuration;
alter table [dbo].[configuration] with nocheck add constraint [pk_configuration] primary key nonclustered ([id]) on [primary];
alter table configuration add newfieldgroup nvarchar (50) null;
alter table configuration add newfieldgroup2 nvarchar (50) null;

table configuration1;
alter table [dbo].[configuration1] with nocheck add constraint [pk_configuration1] primary key nonclustered ([id]) on [primary];
alter table configuration1 add newfieldgroup nvarchar (50) null;
alter table configuration1 add newfieldgroup2 nvarchar (50) null;

table content;
alter table [dbo].[content] with nocheck add constraint [pk_content] primary key nonclustered ([contentid]) on [primary];
alter table content add fullname nvarchar (255) null;
alter table content add contactid nvarchar (255) null;
alter table content add contentgroups nvarchar (255) null;
alter table content add excontentgroups nvarchar (255) null;
alter table content add showonbox [bit] null;
alter table content add nurllink nvarchar (255) null;
alter table content add ncategoryid nvarchar (50) null;
alter table content add cNewsStartDate datetime null;
alter table content add cNewsEndDate datetime null;
alter table content add metatitle nvarchar (255) null;
alter table content add smFrequency nvarchar (255) null;
alter table content add smPriority nvarchar (255) null;
alter table content add gsmincluded nvarchar (10) null;
alter table content add metakeywords ntext null;
alter table content add metadescription ntext null;
alter table content add userid nvarchar (50) null;

table searchresults;
alter table [dbo].[searchresults] with nocheck add constraint [pk_searchresults] primary key nonclustered ([id]) on [primary];

table ordertracking;
alter table [dbo].[ordertracking] with nocheck add constraint [pk_ordertracking] primary key nonclustered ([trackid]) on [primary];

table prodcategories;
alter table [dbo].[prodcategories] with nocheck add constraint [pk_prodcategories] primary key nonclustered ([id]) on [primary];

table projects;
alter table [dbo].[projects] with nocheck add constraint [pk_projects] primary key nonclustered ([pid]) on [primary];

table registrant;
alter table registrant add regother1 nvarchar (100) null;
alter table registrant add regother2 nvarchar (100) null;

table reviews;
alter table [dbo].[reviews] with nocheck add constraint [pk_reviews] primary key nonclustered ([id]) on [primary];

table shopcountries;
alter table [dbo].[shopcountries] with nocheck add constraint [pk_shopcountries] primary key nonclustered ([countryid]) on [primary];

table shoprma;
alter table [dbo].[shoprma] with nocheck add constraint [pk_shoprma] primary key nonclustered ([rmaid]) on [primary];

table shopstates;
alter table [dbo].[shopstates] with nocheck add constraint [pk_shopstates] primary key nonclustered ([stateid]) on [primary];

table sitesessions;
alter table [dbo].[sitesessions] with nocheck add constraint [pk_sitesessions] primary key nonclustered ([id]) on [primary];

table suppliers;
alter table [dbo].[suppliers] with nocheck add constraint [pk_suppliers] primary key nonclustered ([supplierid]) on [primary];

table billing;
alter table [dbo].[billing] with nocheck add constraint [pk_billing] primary key nonclustered ([billid]) on [primary];

table pinnumbers;
alter table [dbo].[pinnumbers] with nocheck add constraint [pk_pinnumbers] primary key nonclustered ([serialid]) on [primary];

table hackers;
alter table [dbo].[hackers] with nocheck add constraint [pk_hackers] primary key nonclustered ([hackerid]) on [primary];

table languages;
alter table [dbo].[languages] with nocheck add constraint [pk_languages] primary key nonclustered ([id]) on [primary];

table savedcarts;
alter table [dbo].[savedcarts] with nocheck add constraint [pk_savedcarts] primary key nonclustered ([id]) on [primary];

table templates;
alter table [dbo].[templates] with nocheck add constraint [pk_templates] primary key nonclustered ([id]) on [primary];

table downloads;
alter table [dbo].[downloads] with nocheck add constraint [pk_downloads] primary key nonclustered ([id]) on [primary];

table currencyvalues;
alter table [dbo].[currencyvalues] with nocheck add constraint [pk_currencyvalues] primary key nonclustered ([id]) on [primary];

table translatecategories;
alter table [dbo].[translatecategories] with nocheck add constraint [pk_translatecategories] primary key nonclustered ([translateid]) on [primary];
alter table [dbo].[translatecategories] add categorymetatitle nvarchar (255) null;
alter table [dbo].[translatecategories] add categorymetakeyword ntext null;
alter table [dbo].[translatecategories] add categorymetadescription ntext null;

table translateprodfeatures;
alter table [dbo].[translateprodfeatures] with nocheck add constraint [pk_translateprodfeatures] primary key nonclustered ([translateid]) on [primary];

table translateproducts;
alter table [dbo].[translateproducts] with nocheck add constraint [pk_translateproducts] primary key nonclustered ([translateid]) on [primary];
alter table [dbo].[translateproducts] add productmetatitle nvarchar (255) null;
alter table [dbo].[translateproducts] add productmetakeyword ntext null;
alter table [dbo].[translateproducts] add productmetadescription ntext null;

table translatecontent;
alter table [dbo].[translatecontent] with nocheck add constraint [pk_translatecontent] primary key nonclustered ([translateid]) on [primary];
alter table translatecontent add metatitle nvarchar (255) null;
alter table translatecontent add metadescription ntext null;
alter table translatecontent add metakeywords ntext null;

table menuitem;
alter table [dbo].[menuitem] with nocheck add constraint [pk_menuitem] primary key nonclustered ([id]) on [primary];

table ups_config;
alter table [dbo].[ups_config] with nocheck add constraint [pk_ups_config] primary key nonclustered ([upsid]) on [primary];

table categories;
alter table [dbo].[categories] with nocheck add constraint [pk_categories] primary key nonclustered ([categoryid]) on [primary];
alter table categories add CatProCatDisplayCategoryID [nvarchar] (4000) null;
alter table categories add excustomermatch nvarchar (255) null;
alter table categories add categorymetatitle nvarchar (255) null;
alter table categories add categorymetakeyword ntext null;
alter table categories add categorymetadescription ntext null;
alter table categories add smFrequency nvarchar (255) null;
alter table categories add smPriority nvarchar (255) null;
alter table categories add gsmincluded nvarchar (10) null;
alter table categories add loggedin bit null;

table prodfeatures;
alter table [dbo].[prodfeatures] with nocheck add constraint [pk_prodfeatures] primary key nonclustered ([id]) on [primary];
alter table prodfeatures add featureorder real null;

table oitems;
alter table [dbo].[oitems] with nocheck add constraint [pk_oitems] primary key nonclustered ([orderitemid]) on [primary];
alter table oitems add downloadurl nvarchar (255) null;
alter table oitems add producttype nvarchar (255) null;
alter table oitems add bundleparentid real null;
alter table oitems add bundleqty real null;
alter table oitems add variants nvarchar (255) null;

table orders;
alter table [dbo].[orders] with nocheck add constraint [pk_orders] primary key nonclustered ([orderid]) on [primary];
alter table orders add storematch nvarchar (100) null;
alter table orders add osurchargefees money null;
alter table orders add odualsurchargefees money null;
alter table orders add osurchargefeespercentage real null;
alter table orders add osurchargefeespercentagefees real null;
alter table orders add osurchargefeesfixed real null;
alter table orders add osurchargetype nvarchar (50) null;

table products;
alter table [dbo].[products] with nocheck add constraint [pk_products] primary key nonclustered ([catalogid]) on [primary];
alter table products add producttype nvarchar (255) null;
alter table products add youtube nvarchar (255) null;
alter table products add movie nvarchar (255) null;
alter table products add productmetatitle nvarchar (255) null;
alter table products add variants nvarchar (100) null;
alter table products add smFrequency nvarchar (255) null;
alter table products add smPriority nvarchar (255) null;
alter table products add gsmincluded nvarchar (10) null;
alter table products add loggedin bit null;
alter table products add excustomermatch nvarchar (255) null;
alter table products add featuredflagorder real null;
alter table products add ProProCatDisplayCategoryID nvarchar (4000) null;
alter table products add productmetakeyword ntext null;
alter table products add productmetadescription ntext null;
alter table products add bundleproidqty nvarchar (4000) null;

table shipmethods;
alter table [dbo].[shipmethods] with nocheck add constraint [pk_shipmethods] primary key nonclustered ([shipmethodid]) on [primary];
alter table shipmethods add shipstate nvarchar (50) null;

table quantitydiscounts;
alter table [dbo].[quantitydiscounts] with nocheck add constraint [pk_quantitydiscounts] primary key nonclustered ([id]) on [primary];

table customers;
alter table [dbo].[customers] with nocheck add constraint [pk_customers] primary key nonclustered ([contactid]) on [primary];

table tbllog;
alter table [dbo].[tbllog] with nocheck add constraint [pk_tbllog] primary key nonclustered ([fldauto]) on [primary];

table coupons;
alter table [dbo].[coupons] with nocheck add constraint [pk_coupons] primary key nonclustered ([couponId]) on [primary];

table tblaccess;
alter table [dbo].[tblaccess] with nocheck add constraint [pk_tblaccess] primary key nonclustered ([fldauto]) on [primary];
alter table tblaccess add fldimage nvarchar (255) null;
alter table tblaccess add fldlevel real null;

table tbluser;
alter table [dbo].[tbluser] with nocheck add constraint [pk_tbluser] primary key nonclustered ([fldauto]) on [primary];
alter table tbluser add logincnt real null;

create table [dbo].[contentcategories] (
 [ncategoryid] [int] identity (1, 1) not null,
 [ncatdescription] [nvarchar] (255) null,
 [ncathide] [nvarchar] (50) null,
 [ncatlanguage] [nvarchar] (50) null,
 [ncattemplate] [nvarchar] (255) null,
 [impressions] [int] null
) on [primary];
alter table [dbo].[contentcategories] with nocheck add constraint [pk_contentcategories] primary key nonclustered ([ncategoryid]) on [primary];

create table [dbo].[concatcategories] (
 [id] [int] identity (1, 1) not null,
 [intcategoryid] [int] null,
 [intcatalogid] [int] null
) on [primary];
alter table [dbo].[concatcategories] with nocheck add constraint [pk_concatcategories] primary key nonclustered ([id]) on [primary];

create table [dbo].[newsletter] (
 [nletterid] [int] identity (1, 1) not null, 
 [nletteremail] [nvarchar] (100) null, 
 [nlettercontactid] [real] null, 
 [nletterfirstname] [nvarchar] (50) null, 
 [nletterlastname] [nvarchar] (50) null, 
 [nletterip] [nvarchar] (50) null, 
 [nlettergroup] [nvarchar] (255) null, 
 [nletterauthorized] [bit] null,
 [nletterreason] [nvarchar] (255) null
) on [primary];
alter table [dbo].[newsletter] with nocheck add constraint [pk_newsletter] primary key nonclustered ([nletterid]) on [primary];

create table [dbo].[news] (
 [newsid] [int] identity (1, 1) not null,
 [messagetype] [nvarchar] (100) null,
 [headline] [nvarchar] (100) null,
 [newsimage] [nvarchar] (255) null,
 [hide] [bit] null,
 [template] [nvarchar] (255) null,
 [newslanguage] [nvarchar] (50) null,
 [other1] [nvarchar] (255) null,
 [other2] [nvarchar] (255) null,
 [other3] [nvarchar] (255) null,
 [loggedin] [bit] null,
 [impressions] [float] null,
 [cdateadded] [Datetime] null,
 [cdateupdated] [Datetime] null,
 [fullname] [nvarchar] (255) null,
 [contactid] [nvarchar] (255) null,
 [contentgroups] [nvarchar] (255) null,
 [excontentgroups] [nvarchar] (255) null,
 [showonbox] [bit] null,
 [cNewsStartDate] [Datetime] null,
 [cNewsEndDate] [Datetime] null,
 [showonhomepage] [bit] null,
 [archive] [bit] null,
 [metatitle] [nvarchar] (255) null,
 [smFrequency] [nvarchar] (255) null,
 [smPriority] [nvarchar] (255) null,
 [gsmincluded] [nvarchar] (10) null,
 [metakeywords] [ntext] null,
 [metadescription] [ntext] null,
 [message] [ntext] null,
 [userid] [nvarchar] (50) null
) on [primary];
alter table [dbo].[news] with nocheck add constraint [pk_news] primary key nonclustered ([newsid]) on [primary];

create table [dbo].[translatenews] (
 [translateid] [int] identity (1, 1) not null,
 [lang] [nvarchar] (100) null,
 [newsid] [Int] null,
 [headline] [nvarchar] (255) null,
 [message] [ntext] null,
 [metatitle] [nvarchar] (255) null,
 [metadescription] [ntext] null,
 [metakeywords] [ntext] null
) on [primary];
alter table [dbo].[translatenews] with nocheck add constraint [pk_translatenews] primary key nonclustered ([translateid]) on [primary];

create table [dbo].[newsreviews] (
 [id] [int] identity (1, 1) not null,
 [contentid] [int] null,
 [reviewdate] [datetime] null,
 [reviewtime] [datetime] null,
 [title] [nvarchar] (255) null,
 [comment] [nvarchar] (4000) null,
 [location] [nvarchar] (100) null,
 [name] [nvarchar] (100) null,
 [email] [nvarchar] (100) null,
 [other1] [nvarchar] (100) null,
 [other2] [nvarchar] (100) null,
 [authorized] [nvarchar] (10) null
) on [primary];
alter table [dbo].[newsreviews] with nocheck add 
	constraint [df_newsreviews_contentid] default (0) for [contentid],
	constraint [pk_newsreviews] primary key  nonclustered 
	(
		[id]
	)  on [primary];

create table [dbo].[blogsreviews] (
 [id] [int] identity (1, 1) not null,
 [contentid] [int] null,
 [reviewdate] [datetime] null,
 [reviewtime] [datetime] null,
 [title] [nvarchar] (255) null,
 [comment] [nvarchar] (4000) null,
 [location] [nvarchar] (100) null,
 [name] [nvarchar] (100) null,
 [email] [nvarchar] (100) null,
 [other1] [nvarchar] (100) null,
 [other2] [nvarchar] (100) null,
 [authorized] [nvarchar] (10) null
) on [primary];
alter table [dbo].[blogsreviews] with nocheck add 
	constraint [df_blogsreviews_contentid] default (0) for [contentid],
	constraint [pk_blogsreviews] primary key  nonclustered 
	(
		[id]
	)  on [primary];

create table [dbo].[translateblogs] (
 [translateid] [int] identity (1, 1) not null,
 [lang] [nvarchar] (100) null,
 [blogsid] [Int] null,
 [headline] [nvarchar] (255) null,
 [message] [ntext] null,
 [metatitle] [nvarchar] (255) null,
 [metadescription] [ntext] null,
 [metakeywords] [ntext] null
) on [primary];
alter table [dbo].[translateblogs] with nocheck add constraint [pk_translateblogs] primary key  nonclustered ([translateid]) on [primary];

create table [dbo].[tblmenuheader] (
 [fldauto] [int] identity (1, 1) not null,
 [fldsection] [nvarchar] (50) null,
 [fldlink] [nvarchar] (255) null,
 [fldorder] [nvarchar] (100) null
) on [primary];
alter table [dbo].[tblmenuheader] with nocheck add constraint [pk_tblmenuheader] primary key nonclustered ([fldauto]) on [primary];

create table [dbo].[containerbox] (
 [id] [int] identity (1, 1) not null,
 [ContainerName] [nvarchar] (100) null,
 [containerdivname] [nvarchar] (255) null,
 [labelfield] [nvarchar] (100) null,
 [otheroptions1] [nvarchar] (255) null,
 [otheroptions2] [nvarchar] (255) null,
 [otheroptions3] [nvarchar] (4000) null,
 [otheroptions4] [nvarchar] (4000) null,
 [otheroptions5] [nvarchar] (4000) null,
 [otheroptions6] [nvarchar] (4000) null,
 [otheroptions7] [nvarchar] (4000) null,
 [otheroptions8] [nvarchar] (4000) null,
 [otheroptions9] [nvarchar] (4000) null,
 [otheroptions10] [nvarchar] (4000) null,
 [otheroptions11] [nvarchar] (4000) null,
 [otheroptions12] [nvarchar] (4000) null,
 [otheroptions13] [nvarchar] (4000) null,
 [otheroptions14] [nvarchar] (4000) null,
 [otheroptions15] [nvarchar] (4000) null,
 [otheroptions16] [nvarchar] (4000) null,
 [otheroptions17] [nvarchar] (4000) null,
 [otheroptions18] [nvarchar] (4000) null,
 [otheroptions19] [nvarchar] (4000) null,
 [otheroptions20] [nvarchar] (4000) null,
 [otheroptions21] [nvarchar] (4000) null,
 [otheroptions22] [nvarchar] (4000) null,
 [otheroptions23] [nvarchar] (4000) null,
 [otheroptions24] [nvarchar] (4000) null,
 [otheroptions25] [nvarchar] (4000) null,
 [HowManyItems] [nvarchar] (50) null,
 [IDs] [ntext] null
) on [primary];
alter table [dbo].[containerbox] with nocheck add constraint [pk_containerbox] primary key nonclustered ([id]) on [primary];

create table [dbo].[groups] (
 [groupid] [int] identity (1, 1) not null,
 [groupname] [nvarchar] (100) null,
 [grouptype] [nvarchar] (50) null,
 [groupdiscount] [nvarchar] (50) null,
 [grouppropricefield] [nvarchar] (50) null,
 [grouppriority] [int] null,
 [groupdescription] [nvarchar] (4000) null,
 [groupsqlquery] [nvarchar] (4000) null
) on [primary];
alter table [dbo].[groups] with nocheck add constraint [pk_groups] primary key nonclustered ([groupid]) on [primary];

create table [dbo].[customergroups] (
 [id] [bigint] identity (1, 1) not null,
 [groupsid] [float] null,
 [contactid] [float] null
) on [primary];
alter table [dbo].[customergroups] with nocheck add constraint [pk_customergroups] primary key nonclustered ([id]) on [primary];

create table [dbo].[savedquery] (
 [id] [bigint] identity (1, 1) not null,
 [sqlqueryname] [nvarchar] (255) null,
 [sqlquery] [nvarchar] (4000) null
) on [primary];
alter table [dbo].[savedquery] with nocheck add constraint [pk_savedquery] primary key nonclustered ([id]) on [primary];

create table [dbo].[stocknotification] (
 [id] [bigint] identity (1, 1) not null,
 [contactid] [bigint] null,
 [catalogid] [bigint] null
) on [primary];
alter table [dbo].[stocknotification] with nocheck add constraint [pk_stocknotification] primary key nonclustered ([id]) on [primary];

create table [dbo].[checkoutsteps] (
 [id] [bigint] identity (1, 1) not null,
 [stepseqno] [int] null,
 [stepdesc] [nvarchar] (255) null,
 [stepfile] [nvarchar] (255) null,
 [stepimage] [nvarchar] (255) null
) on [primary];
alter table [dbo].[checkoutsteps] with nocheck add constraint [pk_checkoutsteps] primary key nonclustered ([id]) on [primary];

create table [dbo].[productvariants] (
 [variantid] [bigint] identity (1, 1) not null,
 [productid] [bigint] null,
 [stock] [float] null,
 [featureid] [nvarchar] (4000) null
) on [primary];
alter table [dbo].[productvariants] with nocheck add constraint [pk_productvariants] primary key nonclustered ([variantid]) on [primary];

create table [dbo].[tblaudithist] (
 [id] [bigint] identity (1, 1) not null,
 [userid] [nvarchar] (255) null,
 [createdate] [datetime] null,
 [createtime] [datetime] null,
 [description] [nvarchar] (255) null,
 [ipaddress] [nvarchar] (50) null
) on [primary];
alter table [dbo].[tblaudithist] with nocheck add constraint [pk_tblaudithist] primary key nonclustered ([id]) on [primary];

table products;
alter table products add featuredflag2 bit null;
alter table products add featuredflagorder2 real null;
alter table products add cdateend datetime null;
alter table products add tapcaption [nvarchar] (255) null;
alter table products add tapdescription [ntext] null;

table containerbox;
alter table containerbox add otheroptions7 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions8 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions9 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions10 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions11 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions12 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions13 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions14 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions15 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions16 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions17 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions18 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions19 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions20 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions21 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions22 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions23 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions24 [nvarchar] (4000) NULL;
alter table containerbox add otheroptions25 [nvarchar] (4000) NULL;

create table [dbo].[translatecontentcategories] (
 [translateid] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (100) null, 
 [ncategoryid] [Int] null, 
 [ncatdescription] [nvarchar] (255) null
) on [primary];
alter table [dbo].[translatecontentcategories] with nocheck add constraint [pk_translatecontentcategories] primary key nonclustered ([translateid])  on [primary];

table affiliatelog;
ALTER TABLE affiliatelog ALTER COLUMN affdirecturl nvarchar(255) NULL;
ALTER TABLE affiliatelog ALTER COLUMN affreferrer nvarchar(255) NULL; 
ALTER TABLE affiliatelog ALTER COLUMN affother1 nvarchar(255) NULL;

table affiliates;
ALTER TABLE affiliates ALTER COLUMN firstname nvarchar(50) NULL;
ALTER TABLE affiliates ALTER COLUMN lastname nvarchar(50) NULL;
ALTER TABLE affiliates ALTER COLUMN address nvarchar(255) NULL;
ALTER TABLE affiliates ALTER COLUMN city nvarchar(100) NULL;
ALTER TABLE affiliates ALTER COLUMN [state] nvarchar(100) NULL;
ALTER TABLE affiliates ALTER COLUMN postcode nvarchar(20) NULL;
ALTER TABLE affiliates ALTER COLUMN country nvarchar(100) NULL;
ALTER TABLE affiliates ALTER COLUMN company nvarchar(255) NULL;
ALTER TABLE affiliates ALTER COLUMN phone nvarchar(50) NULL;
ALTER TABLE affiliates ALTER COLUMN website nvarchar(50) NULL;
ALTER TABLE affiliates ALTER COLUMN workphone nvarchar(30) NULL;
ALTER TABLE affiliates ALTER COLUMN mobilephone nvarchar(30) NULL;
ALTER TABLE affiliates ALTER COLUMN fax nvarchar(30) NULL;
ALTER TABLE affiliates ALTER COLUMN email nvarchar(50) NULL;
ALTER TABLE affiliates ALTER COLUMN comment nvarchar(255) NULL;
ALTER TABLE affiliates ALTER COLUMN affother1 nvarchar(100) NULL;
ALTER TABLE affiliates ALTER COLUMN affother2 nvarchar(255) NULL;
ALTER TABLE affiliates ALTER COLUMN affother3 nvarchar(100) NULL;
ALTER TABLE affiliates ALTER COLUMN typeofpayment nvarchar(50) NULL;
ALTER TABLE affiliates ALTER COLUMN bank nvarchar(100) NULL;
ALTER TABLE affiliates ALTER COLUMN bankaccount nvarchar(50) NULL;
ALTER TABLE affiliates ALTER COLUMN bankbranch nvarchar(100) NULL;
ALTER TABLE affiliates ALTER COLUMN bankaddress nvarchar(255) NULL;
ALTER TABLE affiliates ALTER COLUMN bankother nvarchar(255) NULL;
ALTER TABLE affiliates ALTER COLUMN password nvarchar(50) NULL;
ALTER TABLE affiliates ALTER COLUMN directurl nvarchar(255) NULL;
ALTER TABLE affiliates ALTER COLUMN template nvarchar(200) NULL;

table billing;
ALTER TABLE billing ALTER COLUMN billcustomer nvarchar(255) NULL;
ALTER TABLE billing ALTER COLUMN billemail nvarchar(100) NULL;
ALTER TABLE billing ALTER COLUMN billdescription nvarchar(2000) NULL;
ALTER TABLE billing ALTER COLUMN billinstallmenttype nvarchar(50) NULL;
ALTER TABLE billing ALTER COLUMN billtemplate nvarchar(100) NULL;
ALTER TABLE billing ALTER COLUMN billother1 nvarchar(100) NULL;
ALTER TABLE billing ALTER COLUMN billother2 nvarchar(100) NULL;

table blogs;
ALTER TABLE blogs ALTER COLUMN messagetype nvarchar(100) NULL;
ALTER TABLE blogs ALTER COLUMN headline nvarchar(100) NULL;
ALTER TABLE blogs ALTER COLUMN blogsimage nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN template nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN blogslanguage nvarchar(50) NULL;
ALTER TABLE blogs ALTER COLUMN other1 nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN other2 nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN other3 nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN fullname nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN contactid nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN contentgroups nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN excontentgroups nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN metatitle nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN smFrequency nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN smPriority nvarchar(255) NULL;
ALTER TABLE blogs ALTER COLUMN gsmincluded nvarchar(10) NULL;
ALTER TABLE blogs ALTER COLUMN metakeywords nvarchar(max) NULL;
ALTER TABLE blogs ALTER COLUMN metakeywords ntext NULL;
ALTER TABLE blogs ALTER COLUMN metadescription nvarchar(max) NULL;
ALTER TABLE blogs ALTER COLUMN metadescription ntext NULL;
ALTER TABLE blogs ALTER COLUMN message nvarchar(max) NULL;
ALTER TABLE blogs ALTER COLUMN message ntext NULL;
ALTER TABLE blogs ALTER COLUMN userid nvarchar(50) NULL;

table blogsreviews;
ALTER TABLE blogsreviews ALTER COLUMN title nvarchar(255) NULL;
ALTER TABLE blogsreviews ALTER COLUMN comment nvarchar(4000) NULL;
ALTER TABLE blogsreviews ALTER COLUMN location nvarchar(100) NULL;
ALTER TABLE blogsreviews ALTER COLUMN name nvarchar(100) NULL;
ALTER TABLE blogsreviews ALTER COLUMN email nvarchar(100) NULL;
ALTER TABLE blogsreviews ALTER COLUMN other1 nvarchar(100) NULL;
ALTER TABLE blogsreviews ALTER COLUMN other2 nvarchar(100) NULL;
ALTER TABLE blogsreviews ALTER COLUMN authorized nvarchar(10) NULL;

table categories;
ALTER TABLE categories ALTER COLUMN catdescription nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN catimage nvarchar(100) NULL;
ALTER TABLE categories ALTER COLUMN hassubcategory nvarchar(5) NULL;
ALTER TABLE categories ALTER COLUMN cathide nvarchar(10) NULL;
ALTER TABLE categories ALTER COLUMN catextra nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN catextra2 nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN catextra3 nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN productmatch nvarchar(50) NULL;
ALTER TABLE categories ALTER COLUMN customermatch nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN excustomermatch nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN catlanguage nvarchar(50) NULL;
ALTER TABLE categories ALTER COLUMN catproducttemplate nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN categorymetatitle nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN smFrequency nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN smPriority nvarchar(255) NULL;
ALTER TABLE categories ALTER COLUMN gsmincluded nvarchar(10) NULL;
ALTER TABLE categories ALTER COLUMN categorymetakeyword nvarchar(max) NULL;
ALTER TABLE categories ALTER COLUMN categorymetakeyword ntext NULL;
ALTER TABLE categories ALTER COLUMN categorymetadescription nvarchar(max) NULL;
ALTER TABLE categories ALTER COLUMN categorymetadescription ntext NULL;
ALTER TABLE categories ALTER COLUMN catmemo nvarchar(max) NULL;
ALTER TABLE categories ALTER COLUMN catmemo ntext NULL;
ALTER TABLE categories ALTER COLUMN CatProCatDisplayCategoryID nvarchar(4000) NULL;

table checkoutsteps;
ALTER TABLE checkoutsteps ALTER COLUMN stepdesc nvarchar(255) NULL;
ALTER TABLE checkoutsteps ALTER COLUMN stepfile nvarchar(255) NULL;
ALTER TABLE checkoutsteps ALTER COLUMN stepimage nvarchar(255) NULL;

table configuration;
ALTER TABLE configuration ALTER COLUMN fieldname nvarchar(50) NULL;
ALTER TABLE configuration ALTER COLUMN fieldvalue nvarchar(255) NULL;
ALTER TABLE configuration ALTER COLUMN fieldgroup nvarchar(50) NULL;
ALTER TABLE configuration ALTER COLUMN showfield nvarchar(50) NULL;
ALTER TABLE configuration ALTER COLUMN fieldgroup2 nvarchar(50) NULL;
ALTER TABLE configuration ALTER COLUMN newfieldgroup nvarchar(50) NULL;
ALTER TABLE configuration ALTER COLUMN newfieldgroup2 nvarchar(50) NULL;
ALTER TABLE configuration ALTER COLUMN message nvarchar(2000) NULL;

table configuration1;
ALTER TABLE configuration1 ALTER COLUMN fieldname nvarchar(50) NULL;
ALTER TABLE configuration1 ALTER COLUMN fieldvalue nvarchar(255) NULL;
ALTER TABLE configuration1 ALTER COLUMN fieldgroup nvarchar(50) NULL;
ALTER TABLE configuration1 ALTER COLUMN showfield nvarchar(50) NULL;
ALTER TABLE configuration1 ALTER COLUMN fieldgroup2 nvarchar(50) NULL;
ALTER TABLE configuration1 ALTER COLUMN newfieldgroup nvarchar(50) NULL;
ALTER TABLE configuration1 ALTER COLUMN newfieldgroup2 nvarchar(50) NULL;
ALTER TABLE configuration1 ALTER COLUMN message nvarchar(2000) NULL;

table containerbox;
ALTER TABLE containerbox ALTER COLUMN ContainerName nvarchar(100) NULL;
ALTER TABLE containerbox ALTER COLUMN containerdivname nvarchar(255) NULL;
ALTER TABLE containerbox ALTER COLUMN labelfield nvarchar(100) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions1 nvarchar(255) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions2 nvarchar(255) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions3 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions4 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions5 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions6 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions7 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions8 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions9 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions10 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions11 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions12 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions13 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions14 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions15 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions16 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions17 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions18 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions19 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions20 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions21 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions22 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions23 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions24 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN otheroptions25 nvarchar(4000) NULL;
ALTER TABLE containerbox ALTER COLUMN HowManyItems nvarchar(50) NULL;
ALTER TABLE containerbox ALTER COLUMN IDs nvarchar(max) NULL;
ALTER TABLE containerbox ALTER COLUMN IDs ntext NULL;

table content;
ALTER TABLE content ALTER COLUMN messagetype nvarchar(100) NULL;
ALTER TABLE content ALTER COLUMN contentimage nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN template nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN contentlanguage nvarchar(50) NULL;
ALTER TABLE content ALTER COLUMN other1 nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN other2 nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN other3 nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN fullname nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN contactid nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN contentgroups nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN excontentgroups nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN nurllink nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN ncategoryid nvarchar(50) NULL;
ALTER TABLE content ALTER COLUMN metatitle nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN smFrequency nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN smPriority nvarchar(255) NULL;
ALTER TABLE content ALTER COLUMN gsmincluded nvarchar(10) NULL;
ALTER TABLE content ALTER COLUMN metakeywords nvarchar(max) NULL;
ALTER TABLE content ALTER COLUMN metakeywords ntext NULL;
ALTER TABLE content ALTER COLUMN metadescription nvarchar(max) NULL;
ALTER TABLE content ALTER COLUMN metadescription ntext NULL;
ALTER TABLE content ALTER COLUMN message nvarchar(max) NULL;
ALTER TABLE content ALTER COLUMN message ntext NULL;
ALTER TABLE content ALTER COLUMN message2 nvarchar(max) NULL;
ALTER TABLE content ALTER COLUMN message2 ntext NULL;
ALTER TABLE content ALTER COLUMN userid nvarchar(50) NULL;

table contentcategories;
ALTER TABLE contentcategories ALTER COLUMN ncatdescription nvarchar(255) NULL;
ALTER TABLE contentcategories ALTER COLUMN ncathide nvarchar(50) NULL;
ALTER TABLE contentcategories ALTER COLUMN ncatlanguage nvarchar(50) NULL;
ALTER TABLE contentcategories ALTER COLUMN ncattemplate nvarchar(255) NULL;

table coupons;
ALTER TABLE coupons ALTER COLUMN couponname nvarchar(100) NULL;
ALTER TABLE coupons ALTER COLUMN couponcategories nvarchar(255) NULL;
ALTER TABLE coupons ALTER COLUMN couponproducts nvarchar(255) NULL;
ALTER TABLE coupons ALTER COLUMN couponcomment nvarchar(255) NULL;
ALTER TABLE coupons ALTER COLUMN couponother nvarchar(100) NULL;
ALTER TABLE coupons ALTER COLUMN couponcustomers nvarchar(255) NULL;


table currencyvalues;
ALTER TABLE currencyvalues ALTER COLUMN cid nvarchar(50) NULL;
ALTER TABLE currencyvalues ALTER COLUMN fullunitname nvarchar(50) NULL;
ALTER TABLE currencyvalues ALTER COLUMN currencysymbol nvarchar(100) NULL;
ALTER TABLE currencyvalues ALTER COLUMN theimage nvarchar(100) NULL;

table customers;
DROP INDEX ix_customers ON customers;
DROP INDEX ix_customers_3 ON customers;
ALTER TABLE customers ALTER COLUMN firstname nvarchar(50) NULL;
ALTER TABLE customers ALTER COLUMN lastname nvarchar(50) NULL;
ALTER TABLE customers ALTER COLUMN address nvarchar(255) NULL;
ALTER TABLE customers ALTER COLUMN address2 nvarchar(255) NULL;
ALTER TABLE customers ALTER COLUMN city nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN [state] nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN postcode nvarchar(20) NULL;
ALTER TABLE customers ALTER COLUMN country nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN company nvarchar(255) NULL;
ALTER TABLE customers ALTER COLUMN phone nvarchar(50) NULL;
ALTER TABLE customers ALTER COLUMN workphone nvarchar(30) NULL;
ALTER TABLE customers ALTER COLUMN mobilephone nvarchar(30) NULL;
ALTER TABLE customers ALTER COLUMN fax nvarchar(30) NULL;
ALTER TABLE customers ALTER COLUMN email nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN comments nvarchar(255) NULL;
ALTER TABLE customers ALTER COLUMN contactreason nvarchar(20) NULL;
ALTER TABLE customers ALTER COLUMN website nvarchar(200) NULL;
ALTER TABLE customers ALTER COLUMN password nvarchar(50) NULL;
ALTER TABLE customers ALTER COLUMN custother1 nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN accountno nvarchar(50) NULL;
ALTER TABLE customers ALTER COLUMN cardno nvarchar(20) NULL;
ALTER TABLE customers ALTER COLUMN cardexpires nvarchar(10) NULL;
ALTER TABLE customers ALTER COLUMN cardname nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN cardaddress nvarchar(200) NULL;
ALTER TABLE customers ALTER COLUMN cardcvn nvarchar(50) NULL;
ALTER TABLE customers ALTER COLUMN productgroup nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN vatnumber nvarchar(50) NULL;
ALTER TABLE customers ALTER COLUMN userid nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN hearaboutus nvarchar(100) NULL;
ALTER TABLE customers ALTER COLUMN taxexempt nvarchar(50) NULL;
ALTER TABLE customers ALTER COLUMN authorized nvarchar(50) NULL;
create index [ix_customers] on [dbo].[customers]([lastname]) on [primary];
create index [ix_customers_3] on [dbo].[customers]([email]) on [primary];

table downloads;
ALTER TABLE downloads ALTER COLUMN filename nvarchar(255) NULL;
ALTER TABLE downloads ALTER COLUMN downloadother nvarchar(100) NULL;
ALTER TABLE downloads ALTER COLUMN downloadother1 nvarchar(100) NULL;
ALTER TABLE downloads ALTER COLUMN authorized nvarchar(10) NULL;

table gifts;
ALTER TABLE gifts ALTER COLUMN giftnumber nvarchar(100) NULL;
ALTER TABLE gifts ALTER COLUMN giftauthorized nvarchar(10) NULL;
ALTER TABLE gifts ALTER COLUMN gifttoname nvarchar(255) NULL;
ALTER TABLE gifts ALTER COLUMN giftfromname nvarchar(255) NULL;
ALTER TABLE gifts ALTER COLUMN gifttoemail nvarchar(255) NULL;
ALTER TABLE gifts ALTER COLUMN giftmessage nvarchar(255) NULL;
ALTER TABLE gifts ALTER COLUMN giftfromemail nvarchar(255) NULL;
ALTER TABLE gifts ALTER COLUMN giftother nvarchar(255) NULL;
ALTER TABLE gifts ALTER COLUMN giftusedtrace nvarchar(255) NULL;

table groups;
ALTER TABLE groups ALTER COLUMN groupname nvarchar(100) NULL;
ALTER TABLE groups ALTER COLUMN grouptype nvarchar(50) NULL;
ALTER TABLE groups ALTER COLUMN groupdiscount nvarchar(50) NULL;
ALTER TABLE groups ALTER COLUMN grouppropricefield nvarchar(50) NULL;
ALTER TABLE groups ALTER COLUMN groupdescription nvarchar(4000) NULL;
ALTER TABLE groups ALTER COLUMN groupsqlquery nvarchar(4000) NULL;

table hackers;
ALTER TABLE hackers ALTER COLUMN ipaddress nvarchar(50) NULL;
ALTER TABLE hackers ALTER COLUMN email nvarchar(200) NULL;
ALTER TABLE hackers ALTER COLUMN comment nvarchar(255) NULL;
ALTER TABLE hackers ALTER COLUMN other nvarchar(100) NULL;

table languages;
ALTER TABLE languages ALTER COLUMN lang nvarchar(50) NULL;
ALTER TABLE languages ALTER COLUMN keyword nvarchar(50) NULL;
ALTER TABLE languages ALTER COLUMN caption nvarchar(2000) NULL;

table menuitem;
ALTER TABLE menuitem ALTER COLUMN name nvarchar(50) NULL;
ALTER TABLE menuitem ALTER COLUMN url nvarchar(255) NULL;
ALTER TABLE menuitem ALTER COLUMN openin nvarchar(100) NULL;
ALTER TABLE menuitem ALTER COLUMN productmatch nvarchar(255) NULL;

table mycompany;
ALTER TABLE mycompany ALTER COLUMN companyname nvarchar(255) NULL;
ALTER TABLE mycompany ALTER COLUMN address nvarchar(255) NULL;
ALTER TABLE mycompany ALTER COLUMN city nvarchar(100) NULL;
ALTER TABLE mycompany ALTER COLUMN [state] nvarchar(50) NULL;
ALTER TABLE mycompany ALTER COLUMN postalcode nvarchar(20) NULL;
ALTER TABLE mycompany ALTER COLUMN country nvarchar(50) NULL;
ALTER TABLE mycompany ALTER COLUMN phonenumber nvarchar(50) NULL;
ALTER TABLE mycompany ALTER COLUMN faxnumber nvarchar(50) NULL;
ALTER TABLE mycompany ALTER COLUMN myemail nvarchar(255) NULL;
ALTER TABLE mycompany ALTER COLUMN other1 nvarchar(255) NULL;
ALTER TABLE mycompany ALTER COLUMN other2 nvarchar(100) NULL;
ALTER TABLE mycompany ALTER COLUMN other3 nvarchar(100) NULL;
ALTER TABLE mycompany ALTER COLUMN other4 nvarchar(100) NULL;

table news;
ALTER TABLE news ALTER COLUMN messagetype nvarchar(100) NULL;
ALTER TABLE news ALTER COLUMN headline nvarchar(100) NULL;
ALTER TABLE news ALTER COLUMN newsimage nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN template nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN newslanguage nvarchar(50) NULL;
ALTER TABLE news ALTER COLUMN other1 nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN other2 nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN other3 nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN fullname nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN contactid nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN contentgroups nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN excontentgroups nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN metatitle nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN smFrequency nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN smPriority nvarchar(255) NULL;
ALTER TABLE news ALTER COLUMN gsmincluded nvarchar(10) NULL;
ALTER TABLE news ALTER COLUMN metakeywords nvarchar(max) NULL;
ALTER TABLE news ALTER COLUMN metakeywords ntext NULL;
ALTER TABLE news ALTER COLUMN metadescription nvarchar(max) NULL;
ALTER TABLE news ALTER COLUMN metadescription ntext NULL;
ALTER TABLE news ALTER COLUMN message nvarchar(max) NULL;
ALTER TABLE news ALTER COLUMN message ntext NULL;
ALTER TABLE news ALTER COLUMN userid nvarchar(50) NULL;

table newsletter;
ALTER TABLE newsletter ALTER COLUMN nletteremail nvarchar(100) NULL;
ALTER TABLE newsletter ALTER COLUMN nletterfirstname nvarchar(50) NULL;
ALTER TABLE newsletter ALTER COLUMN nletterlastname nvarchar(50) NULL;
ALTER TABLE newsletter ALTER COLUMN nletterip nvarchar(50) NULL;
ALTER TABLE newsletter ALTER COLUMN nlettergroup nvarchar(255) NULL;
ALTER TABLE newsletter ALTER COLUMN nletterreason nvarchar(255) NULL;

table newsreviews;
ALTER TABLE newsreviews ALTER COLUMN title nvarchar(255) NULL;
ALTER TABLE newsreviews ALTER COLUMN comment nvarchar(4000) NULL;
ALTER TABLE newsreviews ALTER COLUMN location nvarchar(100) NULL;
ALTER TABLE newsreviews ALTER COLUMN name nvarchar(100) NULL;
ALTER TABLE newsreviews ALTER COLUMN email nvarchar(100) NULL;
ALTER TABLE newsreviews ALTER COLUMN other1 nvarchar(100) NULL;
ALTER TABLE newsreviews ALTER COLUMN other2 nvarchar(100) NULL;
ALTER TABLE newsreviews ALTER COLUMN authorized nvarchar(10) NULL;

table oitems;
ALTER TABLE oitems ALTER COLUMN features nvarchar(255) NULL;
ALTER TABLE oitems ALTER COLUMN pinnumber nvarchar(255) NULL;
ALTER TABLE oitems ALTER COLUMN customerimage nvarchar(255) NULL;
ALTER TABLE oitems ALTER COLUMN downloadurl nvarchar(255) NULL;
ALTER TABLE oitems ALTER COLUMN producttype nvarchar(255) NULL;
ALTER TABLE oitems ALTER COLUMN variants nvarchar(255) NULL;
ALTER TABLE oitems ALTER COLUMN itemname nvarchar(4000) NULL;
ALTER TABLE oitems ALTER COLUMN address nvarchar(1000) NULL;

table orders;
ALTER TABLE orders ALTER COLUMN ofirstname nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN olastname nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN oemail nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN oaddress nvarchar(200) NULL;
ALTER TABLE orders ALTER COLUMN ocity nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN opostcode nvarchar(15) NULL;
ALTER TABLE orders ALTER COLUMN ostate nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN ocountry nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN ophone nvarchar(30) NULL;
ALTER TABLE orders ALTER COLUMN ofax nvarchar(30) NULL;
ALTER TABLE orders ALTER COLUMN ocompany nvarchar(255) NULL;
ALTER TABLE orders ALTER COLUMN ocardtype nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN ocardno nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN ocardname nvarchar(200) NULL;
ALTER TABLE orders ALTER COLUMN ocardexpires nvarchar(10) NULL;
ALTER TABLE orders ALTER COLUMN ocardaddress nvarchar(150) NULL;
ALTER TABLE orders ALTER COLUMN ocomment nvarchar(255) NULL;
ALTER TABLE orders ALTER COLUMN oshipname nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN oshipcompany nvarchar(200) NULL;
ALTER TABLE orders ALTER COLUMN oshipemail nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN oshipmethodtype nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN oshipaddress nvarchar(255) NULL;
ALTER TABLE orders ALTER COLUMN oshiptown nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN oshipzip nvarchar(20) NULL;
ALTER TABLE orders ALTER COLUMN oshipstate nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN oshipcountry nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN other1 nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN other2 nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN oauthorization nvarchar(255) NULL;
ALTER TABLE orders ALTER COLUMN oerrors nvarchar(255) NULL;
ALTER TABLE orders ALTER COLUMN ostatus nvarchar(255) NULL;
ALTER TABLE orders ALTER COLUMN coupon nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN giftcertificate nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN ipaddress nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN vatnumber nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN opending nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN shipmessage nvarchar(255) NULL;
ALTER TABLE orders ALTER COLUMN hearaboutus nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN oaddress2 nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN oshipaddress2 nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN deliverydate nvarchar(20) NULL;
ALTER TABLE orders ALTER COLUMN deliverytime nvarchar(20) NULL;
ALTER TABLE orders ALTER COLUMN upstrackno nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN otermsagreed nvarchar(10) NULL;
ALTER TABLE orders ALTER COLUMN ocurrency nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN ocurrencyrate nvarchar(50) NULL;
ALTER TABLE orders ALTER COLUMN storematch nvarchar(100) NULL;
ALTER TABLE orders ALTER COLUMN osurchargetype nvarchar(50) NULL;

table ordertracking;
ALTER TABLE ordertracking ALTER COLUMN trackname nvarchar(100) NULL;
ALTER TABLE ordertracking ALTER COLUMN trackemail nvarchar(100) NULL;
ALTER TABLE ordertracking ALTER COLUMN trackother nvarchar(100) NULL;
ALTER TABLE ordertracking ALTER COLUMN trackcomment nvarchar(2000) NULL;

table pinnumbers;
ALTER TABLE pinnumbers ALTER COLUMN pinnumber nvarchar(255) NULL;
ALTER TABLE pinnumbers ALTER COLUMN pinproductmatch nvarchar(40) NULL;
ALTER TABLE pinnumbers ALTER COLUMN pinother1 nvarchar(255) NULL;

table prodfeatures;
ALTER TABLE prodfeatures ALTER COLUMN featurecaption nvarchar(50) NULL;
ALTER TABLE prodfeatures ALTER COLUMN featurename nvarchar(100) NULL;
ALTER TABLE prodfeatures ALTER COLUMN featureother nvarchar(100) NULL;
ALTER TABLE prodfeatures ALTER COLUMN featuretype nvarchar(10) NULL;
ALTER TABLE prodfeatures ALTER COLUMN featuremulti nvarchar(10) NULL;
ALTER TABLE prodfeatures ALTER COLUMN featureother1 nvarchar(50) NULL;
ALTER TABLE prodfeatures ALTER COLUMN featureimage nvarchar(255) NULL;

table products;
ALTER TABLE products ALTER COLUMN ccode nvarchar(50) NULL;
ALTER TABLE products ALTER COLUMN cname nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN cdescurl nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN features nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN cimageurl nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN weight nvarchar(20) NULL;
ALTER TABLE products ALTER COLUMN mfg nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN pother1 nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN pother2 nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN pother3 nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN specialoffer nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN category nvarchar(50) NULL;
ALTER TABLE products ALTER COLUMN buttonimage nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN allowusertext nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN pother4 nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN pother5 nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN userid nvarchar(50) NULL;
ALTER TABLE products ALTER COLUMN keywords nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN template nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN extendedimage nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN selectlist nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN level3 nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN level4 nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN level5 nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN crossselling nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN productmatch nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN customermatch nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN excustomermatch nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN orderattachment nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN orderdownload nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN groupfordiscount nvarchar(50) NULL;
ALTER TABLE products ALTER COLUMN clanguage nvarchar(50) NULL;
ALTER TABLE products ALTER COLUMN billinstallmenttype nvarchar(50) NULL;
ALTER TABLE products ALTER COLUMN frontpage nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN inventoryproducts nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN spdisplaytype nvarchar(50) NULL;
ALTER TABLE products ALTER COLUMN hassubproduct nvarchar(50) NULL;
ALTER TABLE products ALTER COLUMN templatelisting nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN extraimage1 nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN extraimage2 nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN extraimage3 nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN extraimage4 nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN extraimage5 nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN producttype nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN youtube nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN movie nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN productmetatitle nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN variants nvarchar(100) NULL;
ALTER TABLE products ALTER COLUMN smFrequency nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN smPriority nvarchar(255) NULL;
ALTER TABLE products ALTER COLUMN gsmincluded nvarchar(10) NULL;
ALTER TABLE products ALTER COLUMN ProProCatDisplayCategoryID nvarchar(4000) NULL;
ALTER TABLE products ALTER COLUMN bundleproidqty nvarchar(4000) NULL;
ALTER TABLE products ALTER COLUMN productmetakeyword nvarchar(max) NULL;
ALTER TABLE products ALTER COLUMN productmetakeyword ntext NULL;
ALTER TABLE products ALTER COLUMN productmetadescription nvarchar(max) NULL;
ALTER TABLE products ALTER COLUMN productmetadescription ntext NULL;
ALTER TABLE products ALTER COLUMN cdescription nvarchar(max) NULL;
ALTER TABLE products ALTER COLUMN cdescription ntext NULL;
ALTER TABLE products ALTER COLUMN extendeddesc nvarchar(max) NULL;
ALTER TABLE products ALTER COLUMN extendeddesc ntext NULL;
ALTER TABLE products ALTER COLUMN tapcaption nvarchar(20) NULL;
ALTER TABLE products ALTER COLUMN tapdescription nvarchar(max) NULL;
ALTER TABLE products ALTER COLUMN tapdescription ntext NULL;

table productvariants;
ALTER TABLE productvariants ALTER COLUMN featureid nvarchar(4000) NULL;

table projects;
ALTER TABLE projects ALTER COLUMN [description] nvarchar(255) NULL;
ALTER TABLE projects ALTER COLUMN customer nvarchar(100) NULL;
ALTER TABLE projects ALTER COLUMN customeremail nvarchar(100) NULL;
ALTER TABLE projects ALTER COLUMN paid nvarchar(100) NULL;
ALTER TABLE projects ALTER COLUMN other1 nvarchar(255) NULL;
ALTER TABLE projects ALTER COLUMN other2 nvarchar(255) NULL;
ALTER TABLE projects ALTER COLUMN other3 nvarchar(255) NULL;
ALTER TABLE projects ALTER COLUMN billdescription nvarchar(2000) NULL;
ALTER TABLE projects ALTER COLUMN comments nvarchar(1000) NULL;

table quantitydiscounts;
ALTER TABLE quantitydiscounts ALTER COLUMN other nvarchar(50) NULL;
ALTER TABLE quantitydiscounts ALTER COLUMN groupfordiscount nvarchar(100) NULL;

table registrant;
ALTER TABLE registrant ALTER COLUMN firstname nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN lastname nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN address nvarchar(255) NULL;
ALTER TABLE registrant ALTER COLUMN city nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN [state] nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN postcode nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN country nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN company nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN phone nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN workphone nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN mobilephone nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN fax nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN email nvarchar(255) NULL;
ALTER TABLE registrant ALTER COLUMN comments nvarchar(255) NULL;
ALTER TABLE registrant ALTER COLUMN regpassword nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN publicpassword nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN eventtype nvarchar(255) NULL;
ALTER TABLE registrant ALTER COLUMN cofirstname nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN colastname nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN coaddress nvarchar(255) NULL;
ALTER TABLE registrant ALTER COLUMN cocity nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN costate nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN copostcode nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN cocountry nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN cophone nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN coemail nvarchar(255) NULL;
ALTER TABLE registrant ALTER COLUMN sendfirstname nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN sendlastname nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN sendaddress nvarchar(255) NULL;
ALTER TABLE registrant ALTER COLUMN sendcity nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN sendstate nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN sendpostcode nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN sendcountry nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN sendphone nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN sendemail nvarchar(255) NULL;
ALTER TABLE registrant ALTER COLUMN shippingtype nvarchar(50) NULL;
ALTER TABLE registrant ALTER COLUMN publicallowed nvarchar(10) NULL;
ALTER TABLE registrant ALTER COLUMN regother1 nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN regother2 nvarchar(100) NULL;
ALTER TABLE registrant ALTER COLUMN thankyounote nvarchar(2000) NULL;

table registryitems;
ALTER TABLE registryitems ALTER COLUMN address nvarchar(255) NULL;
ALTER TABLE registryitems ALTER COLUMN itemname nvarchar(4000) NULL;

table reviews;
ALTER TABLE reviews ALTER COLUMN authorized nvarchar(5) NULL;
ALTER TABLE reviews ALTER COLUMN title nvarchar(255) NULL;
ALTER TABLE reviews ALTER COLUMN location nvarchar(100) NULL;
ALTER TABLE reviews ALTER COLUMN [name] nvarchar(100) NULL;
ALTER TABLE reviews ALTER COLUMN email nvarchar(255) NULL;
ALTER TABLE reviews ALTER COLUMN other1 nvarchar(100) NULL;
ALTER TABLE reviews ALTER COLUMN other2 nvarchar(50) NULL;
ALTER TABLE reviews ALTER COLUMN comment nvarchar(2000) NULL;

table savedcarts;
ALTER TABLE savedcarts ALTER COLUMN cartname nvarchar(100) NULL;
ALTER TABLE savedcarts ALTER COLUMN other1 nvarchar(100) NULL;
ALTER TABLE savedcarts ALTER COLUMN cartcookies nvarchar(2000) NULL;

table savedquery;
ALTER TABLE savedquery ALTER COLUMN sqlqueryname nvarchar(255) NULL;
ALTER TABLE savedquery ALTER COLUMN sqlquery nvarchar(4000) NULL;

table searchresults;
ALTER TABLE searchresults ALTER COLUMN categories nvarchar(200) NULL;
ALTER TABLE searchresults ALTER COLUMN subcategories nvarchar(200) NULL;
ALTER TABLE searchresults ALTER COLUMN [words] nvarchar(255) NULL;
ALTER TABLE searchresults ALTER COLUMN lastname nvarchar(50) NULL;
ALTER TABLE searchresults ALTER COLUMN ipaddress nvarchar(50) NULL;
ALTER TABLE searchresults ALTER COLUMN rother1 nvarchar(100) NULL;
ALTER TABLE searchresults ALTER COLUMN rother2 nvarchar(100) NULL;

table shipmethods;
ALTER TABLE shipmethods ALTER COLUMN shipmethod nvarchar(50) NULL;
ALTER TABLE shipmethods ALTER COLUMN shipother1 nvarchar(50) NULL;
ALTER TABLE shipmethods ALTER COLUMN shipother2 nvarchar(50) NULL;
ALTER TABLE shipmethods ALTER COLUMN shiproutine nvarchar(255) NULL;
ALTER TABLE shipmethods ALTER COLUMN shipcountry nvarchar(50) NULL;
ALTER TABLE shipmethods ALTER COLUMN shipstate nvarchar(50) NULL;

table shopcountries;
ALTER TABLE shopcountries ALTER COLUMN country nvarchar(10) NULL;
ALTER TABLE shopcountries ALTER COLUMN countryname nvarchar(100) NULL;
ALTER TABLE shopcountries ALTER COLUMN countrygroup nvarchar(50) NULL;

table shoprma;
ALTER TABLE shoprma ALTER COLUMN rma nvarchar(100) NULL;
ALTER TABLE shoprma ALTER COLUMN rmacustomeraction nvarchar(100) NULL;
ALTER TABLE shoprma ALTER COLUMN rmamerchantaction nvarchar(100) NULL;
ALTER TABLE shoprma ALTER COLUMN rmacustomername nvarchar(155) NULL;
ALTER TABLE shoprma ALTER COLUMN rmacustomeremail nvarchar(255) NULL;
ALTER TABLE shoprma ALTER COLUMN rmamerchantname nvarchar(155) NULL;
ALTER TABLE shoprma ALTER COLUMN rmamerchantemail nvarchar(100) NULL;
ALTER TABLE shoprma ALTER COLUMN rmaother1 nvarchar(255) NULL;
ALTER TABLE shoprma ALTER COLUMN rmaother2 nvarchar(255) NULL;
ALTER TABLE shoprma ALTER COLUMN rmaproductname nvarchar(255) NULL;
ALTER TABLE shoprma ALTER COLUMN rmacustomercomment nvarchar(4000) NULL;
ALTER TABLE shoprma ALTER COLUMN rmamerchantcomment nvarchar(4000) NULL;
ALTER TABLE shoprma ALTER COLUMN rmamerchantnotes nvarchar(4000) NULL;

table shopstates;
ALTER TABLE shopstates ALTER COLUMN stateabbrev nvarchar(20) NULL;
ALTER TABLE shopstates ALTER COLUMN statename nvarchar(100) NULL;
ALTER TABLE shopstates ALTER COLUMN statecountry nvarchar(50) NULL;

table sitesessions;
DROP INDEX ix_sitesessions ON sitesessions;
ALTER TABLE sitesessions ALTER COLUMN sessionkey nvarchar(50) NULL;
ALTER TABLE sitesessions ALTER COLUMN sessionvaluename nvarchar(100) NULL;
ALTER TABLE sitesessions ALTER COLUMN sessionnow nvarchar(50) NULL;
ALTER TABLE sitesessions ALTER COLUMN sessionvalue nvarchar(max) NULL;
ALTER TABLE sitesessions ALTER COLUMN sessionvalue ntext NULL;
create  index [ix_sitesessions] on [dbo].[sitesessions]([sessionkey]) on [primary];

table suppliers;
ALTER TABLE suppliers ALTER COLUMN [name] nvarchar(255) NULL;
ALTER TABLE suppliers ALTER COLUMN supplieruserid nvarchar(100) NULL;
ALTER TABLE suppliers ALTER COLUMN firstname nvarchar(50) NULL;
ALTER TABLE suppliers ALTER COLUMN lastname nvarchar(50) NULL;
ALTER TABLE suppliers ALTER COLUMN address nvarchar(255) NULL;
ALTER TABLE suppliers ALTER COLUMN city nvarchar(100) NULL;
ALTER TABLE suppliers ALTER COLUMN [state] nvarchar(100) NULL;
ALTER TABLE suppliers ALTER COLUMN postcode nvarchar(20) NULL;
ALTER TABLE suppliers ALTER COLUMN country nvarchar(100) NULL;
ALTER TABLE suppliers ALTER COLUMN company nvarchar(255) NULL;
ALTER TABLE suppliers ALTER COLUMN phone nvarchar(50) NULL;
ALTER TABLE suppliers ALTER COLUMN workphone nvarchar(30) NULL;
ALTER TABLE suppliers ALTER COLUMN mobilephone nvarchar(30) NULL;
ALTER TABLE suppliers ALTER COLUMN fax nvarchar(30) NULL;
ALTER TABLE suppliers ALTER COLUMN email nvarchar(50) NULL;
ALTER TABLE suppliers ALTER COLUMN comments nvarchar(255) NULL;
ALTER TABLE suppliers ALTER COLUMN website nvarchar(200) NULL;
ALTER TABLE suppliers ALTER COLUMN supplierpassword nvarchar(100) NULL;
ALTER TABLE suppliers ALTER COLUMN accountno nvarchar(50) NULL;
ALTER TABLE suppliers ALTER COLUMN template nvarchar(100) NULL;
ALTER TABLE suppliers ALTER COLUMN other1 nvarchar(100) NULL;

table tblaccess;
ALTER TABLE tblaccess ALTER COLUMN fldname nvarchar(255) NULL;
ALTER TABLE tblaccess ALTER COLUMN fldurl nvarchar(255) NULL;
ALTER TABLE tblaccess ALTER COLUMN fldcomment nvarchar(255) NULL;
ALTER TABLE tblaccess ALTER COLUMN flddatabase nvarchar(50) NULL;
ALTER TABLE tblaccess ALTER COLUMN fldsection nvarchar(50) NULL;
ALTER TABLE tblaccess ALTER COLUMN fldmenu nvarchar(50) NULL;
ALTER TABLE tblaccess ALTER COLUMN fldimage nvarchar(255) NULL;
ALTER TABLE tblaccess ALTER COLUMN fldorder nvarchar(100) NULL;

table tblaudithist;
ALTER TABLE tblaudithist ALTER COLUMN userid nvarchar(255) NULL;
ALTER TABLE tblaudithist ALTER COLUMN [description] nvarchar(255) NULL;
ALTER TABLE tblaudithist ALTER COLUMN ipaddress nvarchar(50) NULL;

table tbllog;
ALTER TABLE tbllog ALTER COLUMN fldusername nvarchar(50) NULL;
ALTER TABLE tbllog ALTER COLUMN fldinout nvarchar(50) NULL;
ALTER TABLE tbllog ALTER COLUMN fldipaddress nvarchar(40) NULL;

table tblmenuheader;
ALTER TABLE tblmenuheader ALTER COLUMN fldsection nvarchar(50) NULL;
ALTER TABLE tblmenuheader ALTER COLUMN fldlink nvarchar(255) NULL;
ALTER TABLE tblmenuheader ALTER COLUMN fldorder nvarchar(100) NULL;

table tbluser;
ALTER TABLE tbluser ALTER COLUMN fldusername nvarchar(255) NULL;
ALTER TABLE tbluser ALTER COLUMN fldpassword nvarchar(255) NULL;
ALTER TABLE tbluser ALTER COLUMN flddatabase nvarchar(50) NULL;
ALTER TABLE tbluser ALTER COLUMN admintype nvarchar(10) NULL;
ALTER TABLE tbluser ALTER COLUMN uploaddirectory nvarchar(100) NULL;
ALTER TABLE tbluser ALTER COLUMN adminother1 nvarchar(100) NULL;
ALTER TABLE tbluser ALTER COLUMN shortcut nvarchar(1000) NULL;
ALTER TABLE tbluser ALTER COLUMN fldaccess nvarchar(max) NULL;
ALTER TABLE tbluser ALTER COLUMN fldaccess ntext NULL;
ALTER TABLE tbluser ALTER COLUMN tablesallowed nvarchar(max) NULL;
ALTER TABLE tbluser ALTER COLUMN tablesallowed ntext NULL;

table templates;
ALTER TABLE templates ALTER COLUMN templatename nvarchar(100) NULL;
ALTER TABLE templates ALTER COLUMN template nvarchar(4000) NULL;

table translateblogs;
ALTER TABLE translateblogs ALTER COLUMN lang nvarchar(100) NULL;
ALTER TABLE translateblogs ALTER COLUMN headline nvarchar(255) NULL;
ALTER TABLE translateblogs ALTER COLUMN message nvarchar(max) NULL;
ALTER TABLE translateblogs ALTER COLUMN message ntext NULL;
ALTER TABLE translateblogs ALTER COLUMN metatitle nvarchar(255) NULL;
ALTER TABLE translateblogs ALTER COLUMN metadescription nvarchar(max) NULL;
ALTER TABLE translateblogs ALTER COLUMN metadescription ntext NULL;
ALTER TABLE translateblogs ALTER COLUMN metakeywords nvarchar(max) NULL;
ALTER TABLE translateblogs ALTER COLUMN metakeywords ntext NULL;

table translatecategories;
ALTER TABLE translatecategories ALTER COLUMN lang nvarchar(100) NULL;
ALTER TABLE translatecategories ALTER COLUMN catdescription nvarchar(255) NULL;
ALTER TABLE translatecategories ALTER COLUMN categorymetatitle nvarchar(255) NULL;
ALTER TABLE translatecategories ALTER COLUMN categorymetakeyword nvarchar(max) NULL;
ALTER TABLE translatecategories ALTER COLUMN categorymetakeyword ntext NULL;
ALTER TABLE translatecategories ALTER COLUMN categorymetadescription nvarchar(max) NULL;
ALTER TABLE translatecategories ALTER COLUMN categorymetadescription ntext NULL;

table translatecontent;
ALTER TABLE translatecontent ALTER COLUMN lang nvarchar(100) NULL;
ALTER TABLE translatecontent ALTER COLUMN message nvarchar(max) NULL;
ALTER TABLE translatecontent ALTER COLUMN message ntext NULL;
ALTER TABLE translatecontent ALTER COLUMN message2 nvarchar(max) NULL;
ALTER TABLE translatecontent ALTER COLUMN message2 ntext NULL;
ALTER TABLE translatecontent ALTER COLUMN metatitle nvarchar(255) NULL;
ALTER TABLE translatecontent ALTER COLUMN metadescription nvarchar(max) NULL;
ALTER TABLE translatecontent ALTER COLUMN metadescription ntext NULL;
ALTER TABLE translatecontent ALTER COLUMN metakeywords nvarchar(max) NULL;
ALTER TABLE translatecontent ALTER COLUMN metakeywords ntext NULL;

table translatenews;
ALTER TABLE translatenews ALTER COLUMN lang nvarchar(100) NULL;
ALTER TABLE translatenews ALTER COLUMN headline nvarchar(255) NULL;
ALTER TABLE translatenews ALTER COLUMN message nvarchar(max) NULL;
ALTER TABLE translatenews ALTER COLUMN message ntext NULL;
ALTER TABLE translatenews ALTER COLUMN metatitle nvarchar(255) NULL;
ALTER TABLE translatenews ALTER COLUMN metadescription nvarchar(max) NULL;
ALTER TABLE translatenews ALTER COLUMN metadescription ntext NULL;
ALTER TABLE translatenews ALTER COLUMN metakeywords nvarchar(max) NULL;
ALTER TABLE translatenews ALTER COLUMN metakeywords ntext NULL;

table translateprodfeatures;
ALTER TABLE translateprodfeatures ALTER COLUMN lang nvarchar(100) NULL;
ALTER TABLE translateprodfeatures ALTER COLUMN featurecaption nvarchar(100) NULL;
ALTER TABLE translateprodfeatures ALTER COLUMN featurename nvarchar(255) NULL;

table translateproducts;
ALTER TABLE translateproducts ALTER COLUMN lang nvarchar(100) NULL;
ALTER TABLE translateproducts ALTER COLUMN cname nvarchar(255) NULL;
ALTER TABLE translateproducts ALTER COLUMN cdescription nvarchar(max) NULL;
ALTER TABLE translateproducts ALTER COLUMN cdescription ntext NULL;
ALTER TABLE translateproducts ALTER COLUMN extendeddesc nvarchar(max) NULL;
ALTER TABLE translateproducts ALTER COLUMN extendeddesc ntext NULL;
ALTER TABLE translateproducts ALTER COLUMN productmetatitle nvarchar(255) NULL;
ALTER TABLE translateproducts ALTER COLUMN productmetakeyword nvarchar(max) NULL;
ALTER TABLE translateproducts ALTER COLUMN productmetakeyword ntext NULL;
ALTER TABLE translateproducts ALTER COLUMN productmetadescription nvarchar(max) NULL;
ALTER TABLE translateproducts ALTER COLUMN productmetadescription ntext NULL;

table ups_config;
ALTER TABLE ups_config ALTER COLUMN xzeroweighterror nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xautoseparateweight nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xautoseparatepackages nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xsuppliershipfield nvarchar(30) NULL;
ALTER TABLE ups_config ALTER COLUMN xusesupplierzip nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xindividualpackages nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN ups_weightunits nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN ups_residentialind nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN ups_unitofmeasurement nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN packagingtype nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN pickuptype nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xmerchantcountry nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xmerchantstate nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xmerchantcity nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN xmerchantpostcode nvarchar(20) NULL;
ALTER TABLE ups_config ALTER COLUMN accesslicencenum nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN username nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN password nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN developerkey nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN gatewaylocation_license nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN gatewaylocation_register nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN xml nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xcheckindividualproductfield nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xcheckindividualproduct nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xdimensionfield nvarchar(30) NULL;
ALTER TABLE ups_config ALTER COLUMN ups_dimensions nvarchar(20) NULL;
ALTER TABLE ups_config ALTER COLUMN gatewaylocation_paymenttesting nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN gatewaylocation_payment nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN testmode nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xupsacctno nvarchar(20) NULL;
ALTER TABLE ups_config ALTER COLUMN dimensions nvarchar(20) NULL;
ALTER TABLE ups_config ALTER COLUMN xtrace nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN xtracexml nvarchar(10) NULL;
ALTER TABLE ups_config ALTER COLUMN gatewaylocation_trackingtesting nvarchar(50) NULL;
ALTER TABLE ups_config ALTER COLUMN gatewaylocation_tracking nvarchar(50) NULL;

table translatecontentcategories;
ALTER TABLE translatecontentcategories ALTER COLUMN lang nvarchar(100) NULL;
ALTER TABLE translatecontentcategories ALTER COLUMN ncatdescription nvarchar(255) NULL;

table containerbox;
alter table containerbox add storematch nvarchar(100) NULL;

table shopcountries;
alter table shopcountries add countryhacker bit NULL;

table products;
alter table products add largeextendedimage nvarchar (100) null;
alter table products add largeextraimage1 nvarchar (100) null;
alter table products add largeextraimage2 nvarchar (100) null;
alter table products add largeextraimage3 nvarchar (100) null;
alter table products add largeextraimage4 nvarchar (100) null;
alter table products add largeextraimage5 nvarchar (100) null;

table translateproducts;
alter table translateproducts add tapcaption [nvarchar] (255) null;
alter table translateproducts add tapdescription [ntext] null;

table registryitems;
ALTER TABLE registryitems ALTER COLUMN purchaseorderid nvarchar(4000) NULL;

table products;
alter table products add displayproducttab bit NULL;

create table [dbo].[xmlfeed] (
 [xmlID] [int] identity (1, 1) not null ,
 [catalogid] [int] null,
 [xmlname] [nvarchar] (500) null,
 [xmldesc] [nvarchar] (500) null,
 [xmllink] [nvarchar] (500) null,
 [xmlimage] [nvarchar] (500) null,
 [xmlprice] [nvarchar] (500) null,
 [xmlccode] [nvarchar] (500) null,
 [xmlcategory] [nvarchar] (500) null,
 [xmlshipcost] [nvarchar] (500) null,
 [xmlstock] [nvarchar] (500) null
)on [primary];
alter table [dbo].[xmlfeed] with nocheck add constraint [pk_xmlfeed] primary key nonclustered ([xmlID]) on [primary];

create table [dbo].[shoppingcom] (
 [shoppingcomid] [int] identity (1, 1) not null ,
 [category] [nvarchar] (500) null,
 [mpn] [nvarchar] (500) null
)on [primary];
alter table [dbo].[shoppingcom] with nocheck add constraint [pk_shoppingcom] primary key nonclustered ([shoppingcomid]) on [primary];

table blogs;
alter table blogs add productmatch nvarchar(50) Null;
table content;
alter table content add productmatch nvarchar(50) Null;
table news;
alter table news add productmatch nvarchar(50) Null;

table categories;
alter table categories add cdateadded datetime null;
alter table categories add cdateupdated datetime null;