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

' 5.50
table orders;
alter table orders add column oaddress2  text(100) NULL;
alter table orders add column oshipaddress2  text(100) NULL;
alter table orders add column deliverydate text(20) NULL;
alter table orders add column deliverytime text(20) NULL;
alter table orders add column producttotal currency NULL;
table customers;
alter table customers add column address2 text(100) NULL;
table coupons;
alter table coupons add column couponcustomers text(255) NULL;
alter table coupons add column couponminimum currency NULL;
table configuration;
alter table configuration add column message  Memo NULL;
table registrant;
alter table registrant add column processed YESNO NULL;
table products;
alter table products add column inventoryproducts  text(255) NULL;
alter table products add column taxfree  YESNO NULL;
alter table products add column freeshipping YESNO NULL;
table savedcarts;
alter table savedcarts add column catalogid long null;
table configuration1;
alter table configuration1 add column message  Memo NULL;

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

'6.50
table categories;
alter table categories add column catextra2 text (255) null;
alter table categories add column catextra3 text (255) null;

table customers;
ALTER TABLE customers ADD COLUMN authorized text(10) NULL;

table menuitem;
alter table menuitem add column productmatch text(255) null;

table oitems;
alter table oitems ADD COLUMN customerimage text(255) null;

table orders;
alter table orders add column opst currency null;
alter table orders add column odualpst currency null;
alter table orders add column otermsagreed text (10) null;
alter table orders add column ocurrency varchar(50) null;
alter table orders add column ocurrencyrate double null;
alter table orders add column affdatepaid datetime null;
alter table orders add column affpaid yesno null;

table products;
alter table products add column extraimage1 text (100) null;
alter table products add column extraimage2 text (100) null;
alter table products add column extraimage3 text (100) null;
alter table products add column extraimage4 text (100) null;
alter table products add column extraimage5 text (100) null;
alter table products add column featuredflag yesno null;
alter table products add column customerimage yesno null;

table tbluser;
alter table tbluser add column shortcut memo null;

table content;
alter table content add column homepage yesno null;

'7.01
table affiliatelog;
alter table affiliatelog add constraint affiliatelog_PK PRIMARY KEY (afflogid);

create table blogs (
 blogsid counter primary key,
 messagetype text (100) null, 
 headline text(100) null,
 blogsimage text (255) null,
 hide YesNo null, 
 template text (255) null,
 blogslanguage text (50) null,
 other1 text (255) null, 
 other2 text (255) null, 
 other3 text (255) null,
 loggedin YesNo null,
 impressions Long null, 
 cdateadded DateTime null, 
 cdateupdated DateTime null,
 fullname text(255) null,
 contactid text(255) null,
 contentgroups text(255) null,
 excontentgroups text(255) null,
 showonbox yesno,
 cBlogsStartDate datetime null,
 cBlogsEndDate datetime null,
 showonhomepage yesno,
 archive yesno,
 metatitle text (255) null,
 smFrequency text (255) null,
 smPriority text (255) null,
 gsmincluded text (10) null,
 metakeywords memo null,
 metadescription memo null,
 message Memo null,
 userid text (50) null
);

table configuration;
alter table configuration add constraint configuration_PK PRIMARY KEY (id);
alter table configuration add column newfieldgroup text (50) null;
alter table configuration add column newfieldgroup2 text (50) null;

table configuration1;
alter table configuration1 add constraint configuration1_PK PRIMARY KEY (id);
alter table configuration1 add column newfieldgroup text (50) null;
alter table configuration1 add column newfieldgroup2 text (50) null;

table content;
alter table content add constraint content_PK PRIMARY KEY (contentid);
alter table content add column fullname text(255) null;
alter table content add column contactid text(255) null;
alter table content add column contentgroups text(255) null;
alter table content add column excontentgroups text(255) null;
alter table content add column showonbox yesno;
alter table content add column nurllink text (255) null;
alter table content add column ncategoryid text (50) null;
alter table content add column cNewsStartDate datetime null;
alter table content add column cNewsEndDate datetime null;
alter table content add column metatitle text(255) NULL;
alter table content add column smFrequency text(255) NULL;
alter table content add column smPriority text(255) NULL;
alter table content add column gsmincluded text(10) NULL;
alter table content add column metakeywords memo NULL;
alter table content add column metadescription memo NULL;
alter table content add column userid text(50) NULL;

table searchresults;
alter table searchresults add constraint searchresults_PK PRIMARY KEY (id);

table ordertracking;
alter table ordertracking add constraint ordertracking_PK PRIMARY KEY (trackid);

table prodcategories;
alter table prodcategories add constraint prodcategories_PK PRIMARY KEY (id);

table projects;
alter table projects add constraint projects_PK PRIMARY KEY (pid);

table registrant;
alter table registrant add column regother1 text (100) null;
alter table registrant add column regother2 text (100) null;

table reviews;
alter table reviews add constraint reviews_PK PRIMARY KEY (id);

table shopcountries;
alter table shopcountries add constraint shopcountries_PK PRIMARY KEY (countryid);

table shoprma;
alter table shoprma add constraint shoprma_PK PRIMARY KEY (rmaid);

table shopstates;
alter table shopstates add constraint shopstates_PK PRIMARY KEY (stateid);

table sitesessions;
alter table sitesessions add constraint sitesessions_PK PRIMARY KEY (id);

table suppliers;
alter table suppliers add constraint suppliers_PK PRIMARY KEY (supplierid);

table billing;
alter table billing add constraint billing_PK PRIMARY KEY (billid);

table pinnumbers;
alter table pinnumbers add constraint pinnumbers_PK PRIMARY KEY (serialid);

table hackers;
alter table hackers add constraint hackers_PK PRIMARY KEY (hackerid);

table languages;
alter table languages add constraint languages_PK PRIMARY KEY (id);

table savedcarts;
alter table savedcarts add constraint savedcarts_PK PRIMARY KEY (id);

table templates;
alter table templates add constraint templates_PK PRIMARY KEY (id);

table downloads;
alter table downloads add constraint downloads_PK PRIMARY KEY (id);

table currencyvalues;
alter table currencyvalues add constraint currencyvalues_PK PRIMARY KEY (id);

table translatecategories;
alter table translatecategories add constraint translatecategories_PK PRIMARY KEY (translateid);
alter table translatecategories add column categorymetatitle text(255) NULL;
alter table translatecategories add column categorymetakeyword memo NULL;
alter table translatecategories add column categorymetadescription memo NULL;

table translateprodfeatures;
alter table translateprodfeatures add constraint translateprodfeatures_PK PRIMARY KEY (translateid);

table translateproducts;
alter table translateproducts add constraint translateproducts_PK PRIMARY KEY (translateid);
alter table translateproducts add column productmetatitle text(255) NULL;
alter table translateproducts add column productmetakeyword memo NULL;
alter table translateproducts add column productmetadescription memo NULL;

table translatecontent;
alter table translatecontent add constraint translatecontent_PK PRIMARY KEY (translateid);
alter table translatecontent add column metatitle text(255) null;
alter table translatecontent add column metadescription memo null;
alter table translatecontent add column metakeywords memo null;

table menuitem;
alter table menuitem add constraint menuitem_PK PRIMARY KEY (id);

table ups_config;
alter table ups_config add constraint ups_config_PK PRIMARY KEY (upsid);

table categories;
alter table categories add constraint categories_PK PRIMARY KEY (categoryid);
alter table categories add column CatProCatDisplayCategoryID memo null;
alter table categories add column excustomermatch text(255) NULL;
alter table categories add column categorymetatitle text(255) NULL;
alter table categories add column categorymetakeyword memo NULL;
alter table categories add column categorymetadescription memo NULL;
alter table categories add column smFrequency text(255) NULL;
alter table categories add column smPriority text(255) NULL;
alter table categories add column gsmincluded text(10) NULL;
alter table categories add column loggedin YesNo null;

table prodfeatures;
alter table prodfeatures add constraint prodfeatures_PK PRIMARY KEY (id);
alter table prodfeatures add column featureorder Double null;

table oitems;
alter table oitems add constraint oitems_PK PRIMARY KEY (orderitemid);
alter table oitems add column downloadurl text(255) null;
alter table oitems add column producttype text(255) NULL;
alter table oitems add column bundleparentid long NULL;
alter table oitems add column bundleqty long NULL;
alter table oitems add column variants text(255) NULL;

table orders;
alter table orders add constraint orders_PK PRIMARY KEY (orderid);
alter table orders add column storematch text(100) null;
alter table orders add column osurchargefees currency NULL;
alter table orders add column odualsurchargefees currency NULL;
alter table orders add column osurchargefeespercentage double NULL;
alter table orders add column osurchargefeespercentagefees double NULL;
alter table orders add column osurchargefeesfixed double NULL;
alter table orders add column osurchargetype text (50) NULL;

table products;
alter table products add constraint products_PK PRIMARY KEY (catalogid);
alter table products add column producttype text (255) null;
alter table products add column youtube text(255);
alter table products add column movie text(255);
alter table products add column productmetatitle text(255) NULL;
alter table products add column variants text(100) NULL;
alter table products add column smFrequency text(255) NULL;
alter table products add column smPriority text(255) NULL;
alter table products add column gsmincluded text(10) NULL;
alter table products add column loggedin YesNo null;
alter table products add column excustomermatch text(255) NULL;
alter table products add column productmetakeyword memo NULL;
alter table products add column productmetadescription memo NULL;
alter table products add column ProProCatDisplayCategoryID text (255) null;
alter table products add column bundleproidqty memo NULL;
alter table products add column featuredflagorder long NULL;

table shipmethods;
alter table shipmethods add constraint shipmethods_PK PRIMARY KEY (shipmethodid);
alter table shipmethods add column shipstate text(50) NULL;

table quantitydiscounts;
alter table quantitydiscounts add constraint quantitydiscounts_PK PRIMARY KEY (id);

table customers;
alter table customers add constraint customers_PK PRIMARY KEY (contactid);

table tbllog;
alter table tbllog add constraint tbllog_PK PRIMARY KEY (fldauto);

table coupons;
alter table coupons add constraint coupons_PK PRIMARY KEY (couponId);

table tblaccess;
alter table tblaccess add constraint tblaccess_PK PRIMARY KEY (fldauto);
alter table tblaccess add column fldimage text (255) null;
alter table tblaccess add column fldlevel long NULL;

table tbluser;
alter table tbluser add constraint tbluser_PK PRIMARY KEY (fldauto);
alter table tbluser add column logincnt long null;
alter table tbluser alter column fldaccess memo null;
alter table tbluser alter column tablesallowed memo null;

create table contentcategories (
 ncategoryid counter primary key,
 ncatdescription text (255) null, 
 ncathide text (50) null, 
 ncatlanguage text (50) null, 
 ncattemplate text (255) null,  
 impressions Long  null
);

create table concatcategories (
 id counter primary key,
 intcategoryid Long null, 
 intcatalogid Long null
);

create table newsletter (
 nletterid counter,
 nletteremail text (100) null, 
 nlettercontactid long null,
 nletterfirstname text (50) null, 
 nletterlastname text (50) null, 
 nletterip text (50) null, 
 nlettergroup text (255) null, 
 nletterauthorized YesNo  null, 
 nletterreason text (255) null,
 Constraint newsletter_PK Primary Key (nletterid)
);

create table news (
 newsid counter primary key,
 messagetype text (100) null, 
 headline text(100) null,
 newsimage text (255) null,
 hide YesNo null, 
 template text (255) null,
 newslanguage text (50) null,
 other1 text (255) null, 
 other2 text (255) null, 
 other3 text (255) null,
 loggedin YesNo null,
 impressions Long null, 
 cdateadded DateTime null, 
 cdateupdated DateTime null,
 fullname text(255) null,
 contactid text(255) null,
 contentgroups text(255) null,
 excontentgroups text(255) null,
 showonbox yesno,
 cNewsStartDate datetime null,
 cNewsEndDate datetime null,
 showonhomepage yesno,
 archive yesno,
 smFrequency text (255) null,
 smPriority text (255) null,
 gsmincluded text (10) null,
 metatitle text (255) null,
 metakeywords memo null,
 metadescription memo null,
 message Memo null,
 userid text (50) null
);

create table translatenews (
 translateid counter primary key,
 lang text (100) null, 
 newsid Long  null, 
 headline text (255)  null, 
 message Memo null,
 metatitle Memo null,
 metadescription Memo null,
 metakeywords Memo null
);

create table newsreviews (
 id counter primary key,
 contentid long null,
 authorized text (5) null,
 reviewdate datetime null,
 reviewtime datetime null,
 title text (255) null,
 comment memo null,
 location text(100) null,
 name text(100) null,
 email text (100) null,
 other1 text (100) null,
 other2 text (100) null
);

create table blogsreviews (
 id counter primary key,
 contentid long null,
 authorized text (5) null,
 reviewdate datetime null,
 reviewtime datetime null,
 title text (255) null,
 comment memo null,
 location text(100) null,
 name text(100) null,
 email text (100) null,
 other1 text (100) null,
 other2 text (100) null
);

create table translateblogs (
 translateid counter primary key,
 lang text (100) null, 
 blogsid Long  null, 
 headline text (255)  null, 
 message Memo null,
 metatitle Memo null,
 metadescription Memo null,
 metakeywords Memo null
);

create table tblmenuheader (
 fldauto counter primary key,
 fldSection text (50) null,
 fldlink text (255) null, 
 fldOrder text (100) null
);

create table containerbox (
 id counter primary key,
 ContainerName text (100) null,
 containerdivname text (255) null,
 labelfield text (100) null,
 otheroptions1 text (255) null,
 otheroptions2 text (255) null,
 otheroptions3 memo null,
 otheroptions4 memo null,
 otheroptions5 memo null,
 otheroptions6 memo null,
 HowManyItems text (50) null,
 IDs  Memo  null
);

create table groups (
 groupid counter primary key,
 groupname text (100) null,
 grouptype text (50) null,
 groupdiscount text (50) null,
 grouppropricefield text (50) null,
 grouppriority long null,
 groupdescription Memo  null,
 groupsqlquery Memo  null 
);

create table customergroups (
 id counter primary key,
 groupsid Long null,
 contactid Long null
);

create table savedquery (
 id counter primary key,
 sqlqueryname text(255) null,
 sqlquery Memo null 
);

create table stocknotification (
 id counter primary key,
 contactid Long null,
 catalogid Long null
);

create table checkoutsteps (
 id counter primary key,
 stepseqno int null,
 stepdesc text(255) null,
 stepfile text(255) null,
 stepimage text(255) null
);

create table productvariants (
 variantid counter primary key,
 productid long null,
 stock long null,
 featureid memo null
);

create table tblaudithist (
 id counter primary key,
 userid text(50) null,
 createdate DateTime null,
 createtime DateTime null,
 description text(255) null,
 ipaddress text(50) null
);

ALTER TABLE mycompany alter column faxnumber text (50) null;

table tbluser;
alter table tbluser alter column fldusername text (255) null;
alter table tbluser alter column fldpassword text (255) null;

table products;
alter table products add column featuredflag2 yesno null;
alter table products add column featuredflagorder2 long NULL;
alter table products add column cdateend DateTime NULL;
alter table products add column tapcaption text (255) NULL;
alter table products add column tapdescription memo NULL;

table containerbox;
alter table containerbox add column otheroptions7 memo NULL;
alter table containerbox add column otheroptions8 memo NULL;
alter table containerbox add column otheroptions9 memo NULL;
alter table containerbox add column otheroptions10 memo NULL;
alter table containerbox add column otheroptions11 memo NULL;
alter table containerbox add column otheroptions12 memo NULL;
alter table containerbox add column otheroptions13 memo NULL;
alter table containerbox add column otheroptions14 memo NULL;
alter table containerbox add column otheroptions15 memo NULL;
alter table containerbox add column otheroptions16 memo NULL;
alter table containerbox add column otheroptions17 memo NULL;
alter table containerbox add column otheroptions18 memo NULL;
alter table containerbox add column otheroptions19 memo NULL;
alter table containerbox add column otheroptions20 memo NULL;
alter table containerbox add column otheroptions21 memo NULL;
alter table containerbox add column otheroptions22 memo NULL;
alter table containerbox add column otheroptions23 memo NULL;
alter table containerbox add column otheroptions24 memo NULL;
alter table containerbox add column otheroptions25 memo NULL;

table languages;
alter table languages alter column caption memo null;

create table translatecontentcategories (
 translateid counter primary key,
 lang text (100) null, 
 ncategoryid long null, 
 ncatdescription text (255) null
);

table containerbox;
alter table containerbox add column storematch text (100) NULL;

table shopcountries;
alter table shopcountries add column countryhacker yesno NULL;

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

table translateproducts;
alter table translateproducts add column tapcaption text (255) NULL;
alter table translateproducts add column tapdescription memo NULL;

table registryitems;
alter table registryitems alter column purchaseorderid memo null;

table products;
alter table products add column displayproducttab YESNO NULL;

create table xmlfeed (
 [xmlID] counter primary key, 
 [catalogid] long null,
 [xmlname] text (255) null,
 [xmldesc] memo null,
 [xmllink] text (255) null,
 [xmlimage] text (255) null,
 [xmlprice] text (255) null,
 [xmlccode] text (255) null,
 [xmlcategory] text (255) null,
 [xmlshipcost] text (255) null,
 [xmlstock] text (255) null
);

create table shoppingcom (
 [shoppingcomid] counter primary key, 
 [category] text (255) null,
 [mpn] text (255) null
);

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

table categories;
alter table categories add column cdateadded DateTime NULL;
alter table categories add column cdateupdated DateTime NULL;