create table configuration (
 id int not null auto_increment primary key,
 fieldname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fieldvalue varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fieldgroup varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fieldyesno tinyint null,
 message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 showfield varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table configuration1 (
 id int not null auto_increment primary key,
 fieldname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fieldvalue varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fieldgroup varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fieldyesno tinyint null,
 message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 showfield varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table content (
 contentid int not null auto_increment primary key,
 messagetype varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 message2 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 contentimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 hide tinyint null, 
 template varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 contentlanguage varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other3 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 loggedin tinyint null, 
 impressions real null, 
 cdateadded datetime null, 
 cdateupdated datetime null
);
create table ordertracking (
 trackid int not null auto_increment primary key,
 orderid Int null, 
 trackcomment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 trackdate Date null, 
 tracktime time null, 
 trackname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 trackview tinyint null, 
 trackother varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 trackemail varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table prodcategories (
 id int not null auto_increment primary key,
 intcategoryid Int null, 
 intcatalogid Int null
);
create table projects (
 pid int not null auto_increment primary key,
 pdate Date null, 
 description varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 customer varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 customeremail varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 price double null, 
 dualprice double null, 
 paid varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 datepaid Date null, 
 processed tinyint null, 
 orderid Int null, 
 canceled tinyint null, 
 comments longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other3 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 billid Int null, 
 billdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table registrant (
 registrantid int not null auto_increment primary key,
 firstname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 lastname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 address varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 city varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 state varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 postcode varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 country varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 company varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 phone varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 workphone varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 mobilephone varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fax varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 email varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 comments varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 logincount Int null, 
 lastlogindate Date null, 
 regpassword varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 publicpassword varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 eventdate Date null, 
 eventtype varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 eventdateend Date null, 
 cofirstname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 colastname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 coaddress varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cocity varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 costate varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 copostcode varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cocountry varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cophone varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 coemail varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendfirstname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendlastname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendaddress varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendcity varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendstate varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendpostcode varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendcountry varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendphone varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sendemail varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 regdate Date null, 
 regtime time null, 
 thankyounote longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 shippingtype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 regorderid Int null, 
 publicallowed varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 processed tinyint null
);
create table registryitems (
 regitemid int not null auto_increment primary key,
 registrantid Int null, 
 orderid Int null, 
 regcatalogid Int null, 
 numitems Int null, 
 itemname longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 unitprice double null, 
 dualprice double null, 
 supplierid Int null, 
 address varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 numpurchased Int null, 
 purchaseorderid longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table reviews (
 id int not null auto_increment primary key,
 catalogid Int null, 
 authorized varchar (5) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 reviewdate Date null, 
 reviewtime time null, 
 rating Int null, 
 title varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 comment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 location varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 name varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 email varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table shopcountries (
 countryid int not null auto_increment primary key,
 country varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 countryname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 countrydisplayorder double null,
 countryhide tinyint null,
 countrytaxrate double null,
 countrygroup varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table shoprma (
 rmaid  int not null auto_increment primary key,
 rma varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmacreationdate date null, 
 rmacustomeraction varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmamerchantaction varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmaorderid double null, 
 rmaitemid double null, 
 rmacustomername varchar (155) null, 
 rmacustomeremail varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmacustomerid double null, 
 rmarefundamount double null, 
 rmamerchantdate Date null, 
 rmamerchantname varchar (155) null, 
 rmamerchantemail varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmacustomercomment longtext CHARACTER SET utf8 COLLATE utf8_general_ci  null, 
 rmamerchantcomment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmaother1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmaother2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmamerchantnotes longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmaprocessed tinyint null, 
 rmaproductname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table shopstates (
 stateid int not null auto_increment primary key,
 stateabbrev varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 statename varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 statecountry varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 statehide tinyint null,
 statetaxrate double null,
 statecanadapst double null
);
create table sitesessions (
 id int not null auto_increment primary key, 
 sessionkey varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sessionvaluename varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 sessiondate datetime null,
 sessiontime datetime null,
 sessionnow varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 sessionvalue longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table suppliers (
 supplierid int not null auto_increment primary key,
 name varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 supplieruserid varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 firstname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 lastname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 address varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 city varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 state varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 postcode varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 country varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 company varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 phone varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 workphone varchar (30) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 mobilephone varchar (30) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 fax varchar (30) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 email varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 comments varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 logincount Int null, 
 lastlogindate Date null, 
 website varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 supplierpassword varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 accountno varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 template varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 commissionrate double null, 
 other1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table affiliatelog (
 afflogid int not null auto_increment primary key,
 affid Int null, 
 affdate Date null, 
 afftime time null, 
 affdirecturl varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 affreferrer varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 affcookie tinyint null, 
 affother1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table billing (
 billid int not null auto_increment primary key,
 billamount double null, 
 billnextbilldate Date null, 
 billcustomer varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 billemail varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 billdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 billinstallments Int null, 
 billinstallmenttype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 billinterval Int null, 
 billlastbilldate Date null, 
 billorderid Int null, 
 billlastmaildate Date null, 
 billsentcount Int null, 
 billcanceled tinyint null, 
 billcompleted tinyint null, 
 billcreationdate Date null, 
 billorderitemid Int null, 
 billenddate Date null, 
 billtemplate varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 billother1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 billother2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table pinnumbers (
 serialid int not null auto_increment primary key,
 catalogid Int null, 
 pinnumber varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 orderid Int null, 
 pinproductmatch varchar (40) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 pinother1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table hackers (
 hackerid int not null auto_increment primary key,
 ipaddress varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 email varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 comment varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table languages (
 id int not null auto_increment primary key,
 lang varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 keyword varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 caption longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table savedcarts (
 id int not null auto_increment primary key,
 cartname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 customerid Int null, 
 cartcookies longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 savedate Date null, 
 savetime time null, 
 other1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 catalogid real
);
create table templates (
 id int not null auto_increment primary key,
 templatename varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 template longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table downloads (
 id int not null auto_increment primary key,
 orderid int null, 
 catalogid int null, 
 customerid int null, 
 filename varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 downloadcount int null, 
 downloaddatelimit int null, 
 downloadmaxcount int null, 
 downloadcreatedate date null, 
 downloadother varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 downloadother1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 authorized varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 lastdownloaddate date null
);
create table currencyvalues (
 id int not null auto_increment primary key,
 cid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 fullunitname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 conversionvalue double null ,
 currencysymbol varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 theimage varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 hide tinyint null
);
create table searchresults (
 id int not null auto_increment primary key,
 rdate Date null, 
 rtime time null, 
 categories varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 subcategories varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 words varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 lastname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 customerid Int null, 
 ipaddress varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rother1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rother2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table translatecategories (
 translateid int not null auto_increment primary key,
 lang varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 categoryid Int null, 
 catdescription varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table translateprodfeatures (
 translateid int not null auto_increment primary key,
 lang varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 id Int null, 
 featurecaption varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 featurename varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table translateproducts (
 translateid int not null auto_increment primary key,
 lang varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 catalogid Int null, 
 cdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 extendeddesc longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table translatecontent (
 translateid int not null auto_increment primary key,
 lang varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 contentid Int null, 
 message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 message2 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table menuitem (
 id int not null auto_increment primary key,
 name varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 seq int null, 
 pmenuitemid int null,
 url varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 contentid int null,
 openin varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 productmatch varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
create table ups_config (
 upsid int not null auto_increment primary key,
 xzeroweighterror varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xautoseparateweight varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xautoseparatepackages varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xsuppliershipfield varchar (30) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xusesupplierzip varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xindividualpackages varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 ups_weightunits varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 ups_residentialind varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 ups_unitofmeasurement varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 packagingtype varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 pickuptype varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmerchantcountry varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmerchantstate varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmerchantcity varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmerchantpostcode varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 accesslicencenum varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 username varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 password varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 developerkey varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 gatewaylocation_license varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 gatewaylocation_register varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xml varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xcheckindividualproductfield varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xcheckindividualproduct varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xdimensionfield varchar (30) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 ups_dimensions varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 gatewaylocation_paymenttesting varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 gatewaylocation_payment varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 testmode varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xupsacctno varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 dimensions varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xtrace varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xtracexml varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 gatewaylocation_trackingtesting varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 gatewaylocation_tracking varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null	
);
table catgories;
alter table categories add cathide varchar(10) NULL;
alter table categories add highercategoryid int;
alter table categories add customermatch varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci Null;
alter table categories add productmatch varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci Null;
alter table categories add catmemo longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ;
alter table categories add catlanguage varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add catproducttemplate varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
table prodfeatures;
alter table prodfeatures add featurerequired tinyint NULL;
alter table prodfeatures add featureother1 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table prodfeatures add featureimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table prodfeatures add featureweight real null;
alter table prodfeatures add featurepercent real  null;
alter table prodfeatures add featuredefault tinyint  null;
table oitems;
alter table oitems add address longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table oitems add supplierid real NULL;
alter table oitems add features varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table oitems add pinnumber varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
table orders;
alter table orders add canceled tinyint NULL;
alter table orders add ipaddress varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table orders add hackeryesno tinyint NULL;
alter table orders add customercancel tinyint NULL;
alter table orders add opoints int NULL default 0;
alter table orders add vatnumber varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table orders add commission double NULL Default 0;
alter table orders add opending varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table orders add shipmessage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table orders add hearaboutus varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table orders add affdatepaid date null;
alter table orders add affpaid tinyint null;
table products;
alter table products add crossselling varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add supplierid real NULL;
alter table products add hide tinyint NULL;
alter table products add productmatch varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add customermatch varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add orderattachment varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add orderdownload varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add groupfordiscount varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add clanguage varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add points int NULL default 0;
alter table products add price2 double NULL;
alter table products add price3 double NULL;
alter table products add pointstobuy int NULL default 0;
alter table products add billprice double  null;
alter table products add billinstallments int  null; 
alter table products add billinstallmenttype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add billinterval int  null;
alter table products add maximumquantity int  null;
alter table products add frontpage varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
table projects;
alter table projects add billid int  null;
alter table projects add billdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
table reviews;
alter table reviews add authorized varchar(10) NULL;
table shipmethods;
alter table shipmethods add shipcountry varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
table quantitydiscounts;
alter table quantitydiscounts add groupfordiscount varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
table suppliers;
alter table suppliers add supplieruserid varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table suppliers add supplierpassword varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
table customers;
alter table customers add maillist tinyint NULL;
alter table customers add productgroup varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table customers add cookiequestion tinyint;
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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table customers add userid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table customers add hearaboutus varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table customers add taxexempt varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
table tbllog;
alter table tbllog add fldipaddress varchar(40) NULL ;
table affiliates;
alter table affiliates add template varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci 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 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table orders add oshipaddress2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table orders add deliverydate varchar(20) NULL;
alter table orders add deliverytime varchar(20) NULL;
alter table orders add producttotal real NULL;
table customers;
alter table customers add address2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
table coupons;
alter table coupons add couponcustomers varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table coupons add couponminimum double NULL;
table configuration;
alter table configuration add message longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
table registrant;
alter table registrant add processed tinyint NULL;
table products;
alter table products add inventoryproducts  varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add taxfree tinyint NULL;
alter table products add freeshipping tinyint NULL;
table savedcarts;
alter table savedcarts add catalogid int null;
table configuration1;
alter table configuration1 add message longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

' 6.00
table categories;
alter table categories add impressions int;
table configuration;
alter table configuration add showfield varchar(20) Null;
alter table configuration add fieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ;
table configuration1;
alter table configuration1 add showfield varchar(20) Null;
alter table configuration1 add fieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ;
table content;
alter table content add loggedin tinyint ;
alter table content add impressions int  Null;
alter table content add cdateadded Date  null ;
alter table content add cdateupdated Date null;
table coupons;
alter table coupons add couponaffid int Null;
table products;
alter table products  add highercatalogid int NULL;
alter table products  add spdisplaytype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products  add hassubproduct varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products  add impressions int NULL;
alter table products  add cdateadded date NULL;
alter table products  add cdateupdated date NULL;
alter table products  add templatelisting varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add rmadays int null;
table tblaccess;
alter table tblaccess add fldsection varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table tblaccess add fldmenu varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table tblaccess add fldorder varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
table orders;
ALTER TABLE orders ADD upstrackno varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

'6.50
table categories;
alter table categories add catextra2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add catextra3 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null

table customers;
ALTER TABLE customers ADD authorized varchar(10) NULL;

table menuitem;
alter table menuitem ADD productmatch varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table oitems;
ALTER TABLE oitems ADD customerimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table orders;
alter table orders add opst double null;
alter table orders add odualpst double null;
alter table orders add otermsagreed varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table orders add ocurrency varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table orders add ocurrencyrate varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table orders add affpaid tinyint null;
alter table orders add affdatepaid datetime null;

table products;
alter table products add  extraimage1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  extraimage2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  extraimage3 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  extraimage4 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  extraimage5 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  featuredflag tinyint null;
alter table products add customerimage tinyint null;

table tbluser;
ALTER TABLE tbluser add shortcut longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table content;
ALTER TABLE content add homepage tinyint null;

'7.01
create table blogs (
 blogsid int not null auto_increment primary key,
 messagetype varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 headline varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 blogsimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 hide tinyint null, 
 template varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 blogslanguage varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 other1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other3 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 loggedin tinyint null,
 impressions real null, 
 cdateadded datetime null, 
 cdateupdated datetime null,
 fullname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 contactid varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 contentgroups varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 excontentgroups varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 showonbox tinyint null,
 cBlogsStartDate date null,
 cBlogsEndDate date null,
 showonhomepage tinyint null,
 archive tinyint null,
 metatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 smFrequency varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 smPriority varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 gsmincluded varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 userid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

table configuration;
alter table configuration add newfieldgroup varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ;
alter table configuration add newfieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ;

table configuration1;
alter table configuration1 add newfieldgroup varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ;
alter table configuration1 add newfieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ;

table content;
alter table content add fullname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add contactid varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add contentgroups varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add excontentgroups varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add showonbox tinyint null;
alter table content add nurllink varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add ncategoryid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add cNewsStartDate Date null;
alter table content add cNewsEndDate Date null;
alter table content add metatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add smFrequency varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add smPriority varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add gsmincluded varchar(10) null;
alter table content add metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table content add userid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table registrant;
alter table registrant add regother1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table registrant add regother2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translatecontent;
alter table translatecontent add metatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table translatecontent add metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table translatecontent add metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table catgories;
alter table categories add CatProCatDisplayCategoryID longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add excustomermatch varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci Null;
alter table categories add categorymetatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add categorymetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add categorymetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add smFrequency varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add smPriority varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add gsmincluded varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table categories add loggedin tinyint null;

table oitems;
alter table oitems add downloadurl varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER table oitems add producttype varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER table oitems add bundleparentid int null;
ALTER table oitems add bundleqty int null;
alter table oitems add variants varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table orders;
alter table orders add storematch varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table orders add osurchargefees double null;
alter table orders add odualsurchargefees double null;
alter table orders add osurchargefeespercentage double null;
alter table orders add osurchargefeespercentagefees double null;
alter table orders add osurchargefeesfixed double null;
alter table orders add osurchargetype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table products;
alter table products add producttype varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add youtube varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add movie varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add productmetatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add variants varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add smFrequency varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add smPriority varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add gsmincluded varchar(10) null;
alter table products add loggedin tinyint null;
alter table products add excustomermatch varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table products add featuredflagorder int null;
alter table products add ProProCatDisplayCategoryID longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add productmetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add productmetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add bundleproidqty longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table shipmethods;
alter table shipmethods add shipstate varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

table tblaccess;
alter table tblaccess add fldimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table tblaccess add fldlevel real null;

table tbluser;
ALTER TABLE tbluser add logincnt double null;

create table contentcategories (
 ncategoryid int not null auto_increment primary key,
 ncatdescription varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ncathide varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ncatlanguage varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ncattemplate varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,  
 impressions int null
);

create table concatcategories(
 id int not null auto_increment primary key,
 intcategoryid int null, 
 intcatalogid int null
);

create table newsletter (
 nletterid int not null auto_increment primary key,
 nletteremail varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 nlettercontactid int null, 
 nletterfirstname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 nletterlastname varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 nletterip varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 nlettergroup varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 nletterauthorized tinyint null,
 nletterreason varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table news (
 newsid int not null auto_increment primary key,
 messagetype varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 headline varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 newsimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 hide tinyint null, 
 template varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 newslanguage varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 other1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other3 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 loggedin tinyint null,
 impressions real null, 
 cdateadded datetime null, 
 cdateupdated datetime null,
 fullname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 contactid varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 contentgroups varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 excontentgroups varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 showonbox tinyint null,
 cNewsStartDate date null,
 cNewsEndDate date null,
 showonhomepage tinyint null,
 archive tinyint null,
 smFrequency varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 smPriority varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 gsmincluded varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 userid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table translatenews (
 translateid int not null auto_increment primary key,
 lang varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 newsid Int null, 
 headline varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table newsreviews (
 id int not null auto_increment primary key,
 contentid Int null, 
 authorized varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 reviewdate Date null, 
 reviewtime time null, 
 title varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 comment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 location varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 name varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 email varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table blogsreviews (
 id int not null auto_increment primary key,
 contentid Int null, 
 authorized varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 reviewdate Date null, 
 reviewtime time null, 
 title varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 comment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 location varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 name varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 email varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table translateblogs (
 translateid int not null auto_increment primary key,
 lang varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 blogsid Int null, 
 headline varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table tblmenuheader (
 fldauto int not null auto_increment primary key,
 fldsection varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fldlink varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fldOrder varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null 
); 

create table containerbox (
   id int not null auto_increment primary key,
   ContainerName varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
   containerdivname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
   labelfield varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
   otheroptions1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
   otheroptions2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
   otheroptions3 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
   otheroptions4 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
   otheroptions5 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
   otheroptions6 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
   HowManyItems varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
   IDs longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table groups (
 groupid int not null auto_increment primary key,
 groupname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 grouptype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 groupdiscount varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 grouppropricefield varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 grouppriority int null,
 groupdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 groupsqlquery longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table customergroups (
 id int not null auto_increment primary key,
 groupsid real null,
 contactid real null
);

create table savedquery (
 id int not null auto_increment primary key,
 sqlqueryname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 sqlquery longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table stocknotification (
 id int not null auto_increment primary key,
 contactid real null, 
 catalogid real null
);

create table checkoutsteps (
 id int not null auto_increment primary key,
 stepseqno int null, 
 stepdesc varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 stepfile varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 stepimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table productvariants (
 variantid int not null auto_increment primary key,
 productid real null, 
 stock real null,
 featureid longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table tblaudithist (
 id int not null auto_increment primary key,
 userid varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 createdate date null,
 createtime time null,
 description varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 ipaddress varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

table translatecategories;
alter table translatecategories add categorymetatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table translatecategories add categorymetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table translatecategories add categorymetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translateproducts;
alter table translateproducts add productmetatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table translateproducts add productmetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table translateproducts add productmetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table prodfeatures;
alter table prodfeatures add featureorder real null;

table products;
alter table products add featuredflag2 tinyint null;
alter table products add featuredflagorder2 int null;
alter table products add cdateend Date null;
alter table products add tapcaption varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add tapdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table containerbox;
alter table containerbox add otheroptions7 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions8 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions9 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions10 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions11 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions12 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions13 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions14 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions15 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions16 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions17 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions18 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions19 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions20 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions21 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions22 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions23 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions24 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
alter table containerbox add otheroptions25 longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

create table translatecontentcategories (
 translateid int not null auto_increment primary key,
 lang varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ncategoryid Int null, 
 ncatdescription varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

table affiliatelog;
ALTER TABLE affiliatelog MODIFY affdirecturl varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliatelog MODIFY affreferrer varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null; 
ALTER TABLE affiliatelog MODIFY affother1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table affiliates;
ALTER TABLE affiliates MODIFY firstname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY lastname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY city varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY state varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY postcode varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY country varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY company varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY phone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY website varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY workphone varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY mobilephone varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY fax varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY email varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY comment varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY affother1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY affother2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY affother3 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY typeofpayment varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY bank varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY bankaccount varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY bankbranch varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY bankaddress varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY bankother varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY password varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY directurl varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE affiliates MODIFY template varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table billing;
ALTER TABLE billing MODIFY billcustomer varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE billing MODIFY billemail varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE billing MODIFY billdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE billing MODIFY billinstallmenttype varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE billing MODIFY billtemplate varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE billing MODIFY billother1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE billing MODIFY billother2 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table blogs;
ALTER TABLE blogs MODIFY messagetype varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY headline varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY blogsimage varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY template varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY blogslanguage varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY other1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY other2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY other3 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY fullname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY contactid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY contentgroups varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY excontentgroups varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY metatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY smFrequency varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY smPriority varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY gsmincluded varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogs MODIFY userid varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table blogsreviews;
ALTER TABLE blogsreviews MODIFY title varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogsreviews MODIFY comment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogsreviews MODIFY location varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogsreviews MODIFY name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogsreviews MODIFY email varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogsreviews MODIFY other1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogsreviews MODIFY other2 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE blogsreviews MODIFY authorized varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table categories;
ALTER TABLE categories MODIFY catdescription varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY catimage varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY hassubcategory varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY cathide varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY catextra varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY catextra2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY catextra3 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY productmatch varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY customermatch varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY excustomermatch varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY catlanguage varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY catproducttemplate varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY categorymetatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY smFrequency varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY smPriority varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY gsmincluded varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY categorymetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY categorymetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY catmemo longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE categories MODIFY CatProCatDisplayCategoryID longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table checkoutsteps;
ALTER TABLE checkoutsteps MODIFY stepdesc varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE checkoutsteps MODIFY stepfile varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE checkoutsteps MODIFY stepimage varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table configuration;
ALTER TABLE configuration MODIFY fieldname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration MODIFY fieldvalue varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration MODIFY fieldgroup varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration MODIFY showfield varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration MODIFY fieldgroup2 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration MODIFY newfieldgroup varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration MODIFY newfieldgroup2 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration MODIFY message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table configuration1;
ALTER TABLE configuration1 MODIFY fieldname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration1 MODIFY fieldvalue varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration1 MODIFY fieldgroup varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration1 MODIFY showfield varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration1 MODIFY fieldgroup2 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration1 MODIFY newfieldgroup varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration1 MODIFY newfieldgroup2 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE configuration1 MODIFY message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table containerbox;
ALTER TABLE containerbox MODIFY ContainerName varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY containerdivname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY labelfield varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions3 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions4 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions5 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions6 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions7 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions8 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions9 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions10 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions11 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions12 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions13 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions14 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions15 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions16 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions17 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions18 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions19 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions20 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions21 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions22 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions23 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions24 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY otheroptions25 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY HowManyItems varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE containerbox MODIFY IDs longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table content;
ALTER TABLE content MODIFY messagetype varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY contentimage varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY template varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY contentlanguage varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY other1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY other2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY other3 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY fullname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY contactid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY contentgroups varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY excontentgroups varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY nurllink varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY ncategoryid varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY metatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY smFrequency varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY smPriority varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY gsmincluded varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY message2 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE content MODIFY userid varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table contentcategories;
ALTER TABLE contentcategories MODIFY ncatdescription varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE contentcategories MODIFY ncathide varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE contentcategories MODIFY ncatlanguage varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE contentcategories MODIFY ncattemplate varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table coupons;
ALTER TABLE coupons MODIFY couponname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE coupons MODIFY couponcategories varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE coupons MODIFY couponproducts varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE coupons MODIFY couponcomment varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE coupons MODIFY couponother varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE coupons MODIFY couponcustomers varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table currencyvalues;
ALTER TABLE currencyvalues MODIFY cid varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE currencyvalues MODIFY fullunitname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE currencyvalues MODIFY currencysymbol varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE currencyvalues MODIFY theimage varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table customers;
ALTER TABLE customers MODIFY firstname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY lastname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY address2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY city varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY state varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY postcode varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY country varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY company varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY phone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY workphone varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY mobilephone varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY fax varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY email varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY comments varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY contactreason varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY website varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY password varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY custother1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY accountno varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY cardno varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY cardexpires varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY cardname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY cardaddress varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY cardcvn varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY productgroup varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY vatnumber varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY userid varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY hearaboutus varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY taxexempt varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE customers MODIFY authorized varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table downloads;
ALTER TABLE downloads MODIFY filename varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE downloads MODIFY downloadother varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE downloads MODIFY downloadother1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE downloads MODIFY authorized varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table gifts;
ALTER TABLE gifts MODIFY giftnumber varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE gifts MODIFY giftauthorized varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE gifts MODIFY gifttoname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE gifts MODIFY giftfromname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE gifts MODIFY gifttoemail varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE gifts MODIFY giftmessage varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE gifts MODIFY giftfromemail varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE gifts MODIFY giftother varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE gifts MODIFY giftusedtrace varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table groups;
ALTER TABLE groups MODIFY groupname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE groups MODIFY grouptype varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE groups MODIFY groupdiscount varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE groups MODIFY grouppropricefield varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE groups MODIFY groupdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE groups MODIFY groupsqlquery longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table hackers;
ALTER TABLE hackers MODIFY ipaddress varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE hackers MODIFY email varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE hackers MODIFY comment varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE hackers MODIFY other varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table languages;
ALTER TABLE languages MODIFY lang varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE languages MODIFY keyword varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE languages MODIFY caption longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table menuitem;
ALTER TABLE menuitem MODIFY name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE menuitem MODIFY url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE menuitem MODIFY openin varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE menuitem MODIFY productmatch varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table mycompany;
ALTER TABLE mycompany MODIFY companyname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY city varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY state varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY postalcode varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY country varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY phonenumber varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY faxnumber varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY myemail varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY other1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY other2 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY other3 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE mycompany MODIFY other4 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table news;
ALTER TABLE news MODIFY messagetype varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY headline varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY newsimage varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY template varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY newslanguage varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY other1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY other2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY other3 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY fullname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY contactid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY contentgroups varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY excontentgroups varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY metatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY smFrequency varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY smPriority varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY gsmincluded varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE news MODIFY userid varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table newsletter;
ALTER TABLE newsletter MODIFY nletteremail varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsletter MODIFY nletterfirstname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsletter MODIFY nletterlastname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsletter MODIFY nletterip varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsletter MODIFY nlettergroup varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsletter MODIFY nletterreason varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table newsreviews;
ALTER TABLE newsreviews MODIFY title varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsreviews MODIFY comment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsreviews MODIFY location varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsreviews MODIFY name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsreviews MODIFY email varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsreviews MODIFY other1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsreviews MODIFY other2 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE newsreviews MODIFY authorized varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table oitems;
ALTER TABLE oitems MODIFY features varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE oitems MODIFY pinnumber varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE oitems MODIFY customerimage varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE oitems MODIFY downloadurl varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE oitems MODIFY producttype varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE oitems MODIFY variants varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE oitems MODIFY itemname longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE oitems MODIFY address longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

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

table ordertracking;
ALTER TABLE ordertracking MODIFY trackname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE ordertracking MODIFY trackemail varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE ordertracking MODIFY trackother varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE ordertracking MODIFY trackcomment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table pinnumbers;
ALTER TABLE pinnumbers MODIFY pinnumber varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE pinnumbers MODIFY pinproductmatch varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE pinnumbers MODIFY pinother1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table prodfeatures;
ALTER TABLE prodfeatures MODIFY featurecaption varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE prodfeatures MODIFY featurename varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE prodfeatures MODIFY featureother varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE prodfeatures MODIFY featuretype varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE prodfeatures MODIFY featuremulti varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE prodfeatures MODIFY featureother1 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE prodfeatures MODIFY featureimage varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

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

table productvariants;
ALTER TABLE productvariants MODIFY featureid longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table projects;
ALTER TABLE projects MODIFY description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE projects MODIFY customer varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE projects MODIFY customeremail varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE projects MODIFY paid varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE projects MODIFY other1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE projects MODIFY other2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE projects MODIFY other3 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE projects MODIFY billdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE projects MODIFY comments longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table quantitydiscounts;
ALTER TABLE quantitydiscounts MODIFY other varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE quantitydiscounts MODIFY groupfordiscount varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table registrant;
ALTER TABLE registrant MODIFY firstname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY lastname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY city varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY state varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY postcode varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY country varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY company varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY phone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY workphone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY mobilephone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY fax varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY email varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY comments varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY regpassword varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY publicpassword varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY eventtype varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY cofirstname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY colastname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY coaddress varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY cocity varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY costate varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY copostcode varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY cocountry varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY cophone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY coemail varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendfirstname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendlastname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendaddress varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendcity varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendstate varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendpostcode varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendcountry varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendphone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY sendemail varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY shippingtype varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY publicallowed varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY regother1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY regother2 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registrant MODIFY thankyounote longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table registryitems;
ALTER TABLE registryitems MODIFY address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE registryitems MODIFY itemname longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table reviews;
ALTER TABLE reviews MODIFY authorized varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE reviews MODIFY title varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE reviews MODIFY location varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE reviews MODIFY name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE reviews MODIFY email varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE reviews MODIFY other1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE reviews MODIFY other2 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE reviews MODIFY comment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table savedcarts;
ALTER TABLE savedcarts MODIFY cartname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE savedcarts MODIFY other1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE savedcarts MODIFY cartcookies longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table savedquery;
ALTER TABLE savedquery MODIFY sqlqueryname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE savedquery MODIFY sqlquery longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table searchresults;
ALTER TABLE searchresults MODIFY categories varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE searchresults MODIFY subcategories varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE searchresults MODIFY words varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE searchresults MODIFY lastname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE searchresults MODIFY ipaddress varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE searchresults MODIFY rother1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE searchresults MODIFY rother2 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table shipmethods;
ALTER TABLE shipmethods MODIFY shipmethod varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shipmethods MODIFY shipother1 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shipmethods MODIFY shipother2 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shipmethods MODIFY shiproutine varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shipmethods MODIFY shipcountry varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shipmethods MODIFY shipstate varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table shopcountries;
ALTER TABLE shopcountries MODIFY country varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shopcountries MODIFY countryname varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shopcountries MODIFY countrygroup varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table shoprma;
ALTER TABLE shoprma MODIFY rma varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmacustomeraction varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmamerchantaction varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmacustomername varchar(155) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmacustomeremail varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmamerchantname varchar(155) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmamerchantemail varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmaother1 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmaother2 varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmaproductname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmacustomercomment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmamerchantcomment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shoprma MODIFY rmamerchantnotes longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table shopstates;
ALTER TABLE shopstates MODIFY stateabbrev varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shopstates MODIFY statename varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE shopstates MODIFY statecountry varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table sitesessions;
ALTER TABLE sitesessions MODIFY sessionkey varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE sitesessions MODIFY sessionvaluename varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE sitesessions MODIFY sessionnow varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE sitesessions MODIFY sessionvalue longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table suppliers;
ALTER TABLE suppliers MODIFY name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY supplieruserid varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY firstname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY lastname varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY city varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY state varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY postcode varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY country varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY company varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY phone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY workphone varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY mobilephone varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY fax varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY email varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY comments varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY website varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY supplierpassword varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY accountno varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY template varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE suppliers MODIFY other1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table tblaccess;
ALTER TABLE tblaccess MODIFY fldname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaccess MODIFY fldurl varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaccess MODIFY fldcomment varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaccess MODIFY flddatabase varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaccess MODIFY fldsection varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaccess MODIFY fldmenu varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaccess MODIFY fldimage varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaccess MODIFY fldorder varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table tblaudithist;
ALTER TABLE tblaudithist MODIFY userid varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaudithist MODIFY description varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblaudithist MODIFY ipaddress varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table tbllog;
ALTER TABLE tbllog MODIFY fldusername varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbllog MODIFY fldinout varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbllog MODIFY fldipaddress varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table tblmenuheader;
ALTER TABLE tblmenuheader MODIFY fldsection varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblmenuheader MODIFY fldlink varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tblmenuheader MODIFY fldorder varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table tbluser;
ALTER TABLE tbluser MODIFY fldusername varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbluser MODIFY fldpassword varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbluser MODIFY flddatabase varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbluser MODIFY admintype varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbluser MODIFY uploaddirectory varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbluser MODIFY adminother1 varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbluser MODIFY shortcut longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbluser MODIFY fldaccess longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE tbluser MODIFY tablesallowed longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table templates;
ALTER TABLE templates MODIFY templatename varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE templates MODIFY template longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translateblogs;
ALTER TABLE translateblogs MODIFY lang varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateblogs MODIFY headline varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateblogs MODIFY message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateblogs MODIFY metatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateblogs MODIFY metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateblogs MODIFY metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translatecategories;
ALTER TABLE translatecategories MODIFY lang varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecategories MODIFY catdescription varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecategories MODIFY categorymetatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecategories MODIFY categorymetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecategories MODIFY categorymetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translatecontent;
ALTER TABLE translatecontent MODIFY lang varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecontent MODIFY message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecontent MODIFY message2 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecontent MODIFY metatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecontent MODIFY metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecontent MODIFY metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translatenews;
ALTER TABLE translatenews MODIFY lang varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatenews MODIFY headline varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatenews MODIFY message longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatenews MODIFY metatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatenews MODIFY metadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatenews MODIFY metakeywords longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translateprodfeatures;
ALTER TABLE translateprodfeatures MODIFY lang varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateprodfeatures MODIFY featurecaption varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateprodfeatures MODIFY featurename varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translateproducts;
ALTER TABLE translateproducts MODIFY lang varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateproducts MODIFY cname varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateproducts MODIFY cdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateproducts MODIFY extendeddesc longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateproducts MODIFY productmetatitle varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateproducts MODIFY productmetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translateproducts MODIFY productmetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

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

table translatecontentcategories;
ALTER TABLE translatecontentcategories MODIFY lang varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
ALTER TABLE translatecontentcategories MODIFY ncatdescription varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table tbllog;
ALTER TABLE tbllog MODIFY fldtime time null;
ALTER TABLE tbllog MODIFY flddate date null;

table orders;
ALTER TABLE orders MODIFY otime time null;

table containerbox;
alter table containerbox add storematch varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table shopcountries;
alter table shopcountries add countryhacker tinyint null;

table products;
alter table products add  largeextendedimage varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  largeextraimage1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  largeextraimage2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  largeextraimage3 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  largeextraimage4 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table products add  largeextraimage5 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null;

table translateproducts;
alter table translateproducts add tapcaption varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null;
alter table translateproducts add tapdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table registryitems;
ALTER TABLE registryitems MODIFY purchaseorderid longtext CHARACTER SET utf8 COLLATE utf8_general_ci null;

table products;
alter table products add displayproducttab tinyint NULL;

create table xmlfeed (
 xmlID int not null auto_increment primary key, 
 catalogid real null,
 xmlname varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmldesc varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmllink varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmlimage varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmlprice varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmlccode varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmlcategory varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmlshipcost varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 xmlstock varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table shoppingcom (
 shoppingcomid int not null auto_increment primary key, 
 category varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 mpn varchar (500) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

table blogs;
alter table blogs add productmatch varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci Null;
table content;
alter table content add productmatch varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci Null;
table news;
alter table news add productmatch varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci Null;

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