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 affiliates (
 affid int not null auto_increment primary key,
 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, 
 website 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, 
 comment varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 logincount Int null, 
 logindate Date null, 
 logintime time null, 
 affother1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 affother2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 affother3 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 commissionrate real null, 
 orders Int null, 
 totalcommission real null, 
 typeofpayment varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 bank varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 bankaccount varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 bankbranch varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 bankaddress varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 bankother varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 password varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 directurl varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 referralid Int null, 
 mastercommissionrate real null, 
 template varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table affiliates 
 alter column logincount set default 0,
 alter column commissionrate set default 0,
 alter column orders set default 0,
 alter column totalcommission set default 0;

create table billing (
 billid int not null auto_increment primary key,
 billamount real 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, 
 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,
 billdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);

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,
 productmatch varchar (50) 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 categories (
 categoryid int not null auto_increment primary key,
 catdescription varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 highercategoryid Int null, 
 catimage varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 hassubcategory varchar (5) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cathide varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 catextra varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 catextra2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 catextra3 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 productmatch varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 customermatch varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 excustomermatch varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 catlanguage varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 catproducttemplate varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 impressions int null,
 categorymetatitle 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,
 loggedin tinyint null,
 cdateadded datetime null, 
 cdateupdated datetime null,
 categorymetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 categorymetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 catmemo longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 CatProCatDisplayCategoryID longtext CHARACTER SET utf8 COLLATE utf8_general_ci 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 concatcategories(
 id int not null auto_increment primary key,
 intcategoryid int null, 
 intcatalogid int null
);

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,
 showfield varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 newfieldgroup varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 newfieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 message longtext 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,
 showfield varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 newfieldgroup varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 newfieldgroup2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 message longtext 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,
 otheroptions7 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions8 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions9 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions10 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions11 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions12 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions13 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions14 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions15 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions16 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions17 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions18 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions19 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions20 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions21 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions22 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions23 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions24 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 otheroptions25 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,
 storematch varchar (100) 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,
 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 int null,
 cdateadded Date null,
 cdateupdated Date null,
 homepage tinyint 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,
 nurllink varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 ncategoryid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 cNewsStartDate Date null,
 cNewsEndDate Date 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, 
 message2 longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 userid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 productmatch varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci 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 coupons (
 couponid int not null auto_increment primary key,
 couponname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 couponamount real null, 
 couponpercent real null, 
 couponstartdate Date null, 
 couponenddate Date null, 
 couponlimit Int null, 
 couponcategories varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 couponproducts varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 couponusedcount Int null, 
 couponlastuseddate Date null, 
 couponcomment varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 couponother varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 couponcustomers varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 couponminimum real null,
 couponaffid int null
);
alter table coupons 
 alter column couponpercent set default 0,
 alter column couponamount set default 0,
 alter column couponlimit set default 0,
 alter column couponusedcount set default 0;

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 real 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 customergroups (
 id int not null auto_increment primary key,
 groupsid real null,
 contactid real null
);

create table customerprices (
 id int not null auto_increment primary key,
 customerid Int null, 
 categoryid Int null, 
 catalogid Int null, 
 discountpercent real null, 
 discountamount real null
);
alter table customerprices 
 alter column catalogid set default 0,
 alter column discountamount set default 0;

create table customers (
 contactid int not null auto_increment primary key,
 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, 
 address2  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 (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 contacttypeid Int null, 
 comments varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 contactreason varchar (20) 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, 
 password varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 discount real null, 
 custother1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 accountno varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cardno varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cardexpires varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cardname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cardaddress varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cardcvn varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 maillist tinyint null, 
 productgroup varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cookiequestion tinyint null, 
 pointstotal Int null, 
 pointsremaining Int null, 
 vatnumber varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 userid varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 hearaboutus  varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
 taxexempt varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 authorized varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table customers 
 alter column logincount set default 1,
 alter column discount set default 0,
 alter column maillist set default 0;

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 date 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 gifts (
 giftid int not null auto_increment primary key,
 giftnumber varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 giftissuedate Date null, 
 giftauthorized varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 giftamount real null, 
 giftamountremaining real null, 
 giftorderid Int null, 
 giftcustomerid Int null, 
 gifttoname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 giftfromname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 gifttoemail varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 giftmessage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 giftfromemail varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 giftuseddate Date null, 
 giftusedcustomerid Int null, 
 giftusedlastamount real null, 
 giftusedorderid Int null, 
 giftother varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 giftexpirydate Date null, 
 giftusedcount Int null, 
 giftusedtrace varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table gifts 
 alter column giftamount set default 0 ,
 alter column giftamountremaining set default 0 ,
 alter column giftorderid set default 0 ,
 alter column giftcustomerid set default 0 ,
 alter column giftusedcustomerid set default 0 ,
 alter column giftusedlastamount set default 0 ,
 alter column giftusedorderid set default 0 ,
 alter column giftusedcount set default 0;

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 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 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 (255) CHARACTER SET utf8 COLLATE utf8_general_ci null
);

create table mycompany (
 setupid int not null auto_increment primary key,
 companyname varchar (255) 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 (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 postalcode varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 country varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 phonenumber varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 faxnumber varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 myemail varchar (255) 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 (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other4 varchar (100) 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,
 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,
 productmatch varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci 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 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 oitems (
 orderitemid int not null auto_increment primary key,
 orderid Int null, 
 catalogid Int null, 
 numitems double null, 
 unitprice double null, 
 dualprice double null, 
 supplierid Int null, 
 features varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 pinnumber varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 customerimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 downloadurl varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 producttype varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 bundleparentid Int null,
 bundleqty Int null,
 variants varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 itemname longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 address longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table oitems 
 alter column orderid set default 0,
 alter column catalogid set default 0 ,
 alter column numitems set default 0 ,
 alter column unitprice set default 0 ,
 alter column dualprice set default 0 ,
 alter column supplierid set default 0; 

create table orders (
 orderid int not null auto_increment primary key,
 ocustomerid Int null, 
 odate Date null, 
 orderamount double null, 
 ofirstname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 olastname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oemail varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oaddress varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ocity varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 opostcode varchar (15) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ostate varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ocountry varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ophone varchar (30) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ofax varchar (30) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ocompany varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ocardtype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ocardno varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ocardname varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ocardexpires varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 ocardaddress varchar (150) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oprocessed tinyint null, 
 ocomment varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 otax double null, 
 opromisedshipdate Date null, 
 oshippeddate Date null, 
 oshipmethod Int null, 
 oshipcost double null, 
 oshipname varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oshipcompany varchar (200) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oshipemail varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oshipmethodtype varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oshipaddress varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oshiptown varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oshipzip varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oshipstate varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oshipcountry varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 opaymethod Int null, 
 other1 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 other2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 otime time null, 
 oauthorization varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oerrors varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 odiscount double null, 
 ostatus varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 oaffid Int null, 
 odualtotal double null, 
 odualtaxes double null, 
 odualshipping double null, 
 odualdiscount double null, 
 ohandling double null, 
 odualhandling double null, 
 coupon varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 coupondiscount double null, 
 coupondiscountdual double null, 
 giftcertificate varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 giftamountused double null, 
 giftamountuseddual double null, 
 canceled tinyint null, 
 ipaddress varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 hackeryesno tinyint null, 
 customercancel tinyint null, 
 opoints Int null, 
 vatnumber varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 commission double null, 
 opending varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 shipmessage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 hearaboutus  varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 oaddress2  varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 oshipaddress2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 deliverydate  varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 deliverytime varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 producttotal real null,
 upstrackno varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 opst double null,
 odualpst double null,
 affdatepaid date null,
 affpaid tinyint null,
 otermsagreed varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 ocurrency varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 ocurrencyrate varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 storematch varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 osurchargefees double null,
 odualsurchargefees double null,
 osurchargefeespercentage double null,
 osurchargefeespercentagefees double null,
 osurchargefeesfixed double null,
 osurchargetype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table orders 
 alter column ocustomerid set default 0,
 alter column orderamount set default 0,
 alter column oprocessed set default 0,
 alter column otax set default 0,
 alter column oshipmethod set default 0,
 alter column oshipcost set default 0,
 alter column opaymethod set default 0 ,
 alter column odiscount set default 0,
 alter column oaffid set default 0 ,
 alter column odualtotal set default 0,
 alter column odualtaxes set default 0 ,
 alter column odualshipping set default 0,
 alter column odualdiscount set default 0,
 alter column ohandling set default 0,
 alter column odualhandling set default 0,
 alter column coupondiscount set default 0,
 alter column coupondiscountdual set default 0,
 alter column giftamountused set default 0,
 alter column giftamountuseddual set default 0,
 alter column producttotal set default 0,
 alter column otime set default 0,
 alter column commission set default 0,
 alter column canceled set default 0;

create table ordertracking (
 trackid int not null auto_increment primary key,
 orderid Int 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,
 trackcomment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table ordertracking
 alter column trackid set default 0,
 alter column orderid set default 0; 

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 prodcategories (
 id int not null auto_increment primary key,
 intcategoryid Int null, 
 intcatalogid Int null
);
alter table prodcategories 
 alter column id set default 0,
 alter column intcategoryid set default 0,
 alter column intcatalogid set default 0;

create table prodfeatures (
 id int not null auto_increment primary key,
 featurenum Int null, 
 featurecaption varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 featurename varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 featureprice double null, 
 featureother varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 featuretype varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 featuremulti varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 featurerequired tinyint null, 
 featureother1 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 featureimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 featureweight real null, 
 featurepercent real null,
 featuredefault tinyint null,
 featureorder real null
);
alter table prodfeatures 
 alter column featurenum set default 0,
 alter column featurerequired set default 0,
 alter column featureprice set default 0,
 alter column featuredefault set default 0;

create table products (
 catalogid int not null auto_increment primary key,
 ccode varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cprice double null, 
 ccategory Int null, 
 cdescurl varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 features varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 cimageurl varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cstock Int null, 
 weight varchar (20) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 mfg varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 pother1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 pother2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 pother3 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 subcategoryid Int null, 
 retailprice double null, 
 specialoffer varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 category varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 buttonimage varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cdateavailable Date null, 
 allowusertext varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 pother4 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 pother5 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 userid varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 keywords varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 template varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 extendedimage varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 selectlist varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 level3 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 level4 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 level5 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 minimumquantity Int null, 
 supplierid Int null, 
 crossselling varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 hide tinyint null, 
 productmatch varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 customermatch varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 excustomermatch varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 orderattachment varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 orderdownload varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 groupfordiscount varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 clanguage varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 points Int null, 
 pointstobuy Int null, 
 price2 double null, 
 price3 double null, 
 billprice double null, 
 billinstallments Int null, 
 billinstallmenttype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 billinterval Int null, 
 maximumquantity Int null, 
 frontpage varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 inventoryproducts  varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 taxfree  tinyint null,
 freeshipping tinyint null,
 highercatalogid int null,
 spdisplaytype varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 hassubproduct varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 impressions int null,
 cdateadded date null,
 cdateupdated date null,
 templatelisting varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 extraimage1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 extraimage2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 extraimage3 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 extraimage4 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 extraimage5 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 featuredflag tinyint null,
 featuredflagorder int null,
 customerimage tinyint null,
 rmadays int null,
 producttype varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 youtube varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 movie varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 productmetatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 variants varchar (100) 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,
 loggedin tinyint null,
 ProProCatDisplayCategoryID longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 bundleproidqty longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 productmetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 productmetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 cdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 extendeddesc longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 featuredflag2 tinyint null,
 featuredflagorder2 int null,
 cdateend Date null,
 largeextendedimage varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 largeextraimage1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 largeextraimage2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 largeextraimage3 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 largeextraimage4 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 largeextraimage5 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 displayproducttab tinyint null,
 tapcaption varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 tapdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);

alter table products 
 alter column cprice set default 0,
 alter column ccategory set default 0,
 alter column cstock set default 0,
 alter column subcategoryid set default 0,
 alter column minimumquantity set default 0,
 alter column hide set default 0,
 alter column supplierid set default 0;

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 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, 
 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, 
 billid Int null, 
 billdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 comments longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table projects 
 alter column orderid set default 0,
 alter column price set default 0,
 alter column dualprice set default 0,
 alter column processed set default 0;

create table quantitydiscounts (
 id int not null auto_increment primary key,
 categoryid Int null, 
 catalogId Int null, 
 minquantity Int null, 
 quantity1 Int null, 
 discount1 double null, 
 quantity2 Int null, 
 discount2 double null, 
 quantity3 Int null, 
 discount3 double null, 
 quantity4 Int null, 
 discount4 double null, 
 quantity5 Int null, 
 discount5 double null, 
 other varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 groupfordiscount varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table quantitydiscounts 
 alter column catalogid set default 0,
 alter column minquantity set default 0,
 alter column quantity1 set default 0,
 alter column discount1 set default 0,
 alter column quantity2 set default 0,
 alter column discount2 set default 0,
 alter column quantity3 set default 0,
 alter column discount3 set default 0,
 alter column quantity4 set default 0,
 alter column discount4 set default 0,
 alter column quantity5 set default 0,
 alter column discount5 set default 0;

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, 
 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, 
 regother1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 regother2 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 processed tinyint null,
 thankyounote longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);


create table registryitems (
 regitemid int not null auto_increment primary key,
 registrantid Int null, 
 orderid Int null, 
 regcatalogid Int null, 
 numitems Int 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,
 itemname 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, 
 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,
 comment longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table reviews
 alter column rating set default 0,
 alter column catalogid set default 0;

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, 
 savedate Date null, 
 savetime time null, 
 other1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 catalogid Int,
 cartcookies longtext CHARACTER SET utf8 COLLATE utf8_general_ci 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 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
);
alter table searchresults 
 alter column customerid set default 0;

create table shipmethods (
 shipmethodid int not null auto_increment primary key,
 shipmethod varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 smprice double null, 
 shipbasecost double null, 
 shipextracost double null, 
 shipother1 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 shipother2 varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 shipcost1 double null, 
 shipcost2 double null, 
 shiproutine varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 shipcountry varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 shipstate varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null
);
alter table shipmethods 
alter column smprice set default 0; 

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,
 countryhacker tinyint 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, 
 rmaother1 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmaother2 varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 rmaprocessed tinyint null, 
 rmaproductname varchar (255) 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,
 rmamerchantnotes longtext 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 stocknotification (
 id int not null auto_increment primary key,
 contactid real null, 
 catalogid real 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 (100) 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 tblaccess (
 fldauto int not null auto_increment primary key,
 fldname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 fldurl varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 fldcomment varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 flddatabase varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 fldsection varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fldMenu varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fldimage varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fldOrder varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fldlevel real 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
);

create table tbllog (
 fldauto int not null auto_increment primary key,
 fldusername varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 fldtime time null ,
 flddate date null ,
 fldinout varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 fldipaddress varchar(40) 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 tbluser (
 fldauto int not null auto_increment primary key,
 fldusername varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 fldpassword varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 flddatabase varchar (50) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 admintype varchar (10) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 uploaddirectory varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 adminother1 varchar (100) CHARACTER SET utf8 COLLATE utf8_general_ci null ,
 logincnt double null ,
 shortcut longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 fldaccess longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 tablesallowed longtext CHARACTER SET utf8 COLLATE utf8_general_ci null
); 

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 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 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,
 categorymetatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 categorymetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 categorymetadescription 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,
 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 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 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, 
 cname varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null, 
 cdescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 extendeddesc longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 productmetatitle varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 productmetakeyword longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 productmetadescription longtext CHARACTER SET utf8 COLLATE utf8_general_ci null,
 tapcaption varchar (255) CHARACTER SET utf8 COLLATE utf8_general_ci null,
 tapdescription longtext 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	
);

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

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