create table [dbo].[affiliatelog] (
 [afflogid] [int] identity (1,1) not null, 
 [affid] [Int] null, 
 [affdate] [Datetime] null, 
 [afftime] [Datetime] null, 
 [affdirecturl] [nvarchar] (255) null, 
 [affreferrer] [nvarchar] (255) null, 
 [affcookie] [bit] null, 
 [affother1] [nvarchar] (255) null
) on [primary];
alter table [dbo].[affiliatelog] with nocheck add constraint [pk_affiliatelog] primary key nonclustered ([afflogid]) on [primary];

create table [dbo].[affiliates] (
 [affid] [int] identity (1, 1) not null,
 [firstname] [nvarchar] (50) null,
 [lastname] [nvarchar] (50) null,
 [address] [nvarchar] (255) null,
 [city] [nvarchar] (100) null,
 [state] [nvarchar] (100) null,
 [postcode] [nvarchar] (20) null,
 [country] [nvarchar] (100) null,
 [company] [nvarchar] (255) null,
 [phone] [nvarchar] (50) null,
 [website] [nvarchar] (50) null,
 [workphone] [nvarchar] (30) null,
 [mobilephone] [nvarchar] (30) null,
 [fax] [nvarchar] (30) null,
 [email] [nvarchar] (50) null,
 [comment] [nvarchar] (255) null,
 [logincount] [int] null,
 [logindate] [datetime] null,
 [logintime] [datetime] null,
 [affother1] [nvarchar] (100) null,
 [affother2] [nvarchar] (255) null,
 [affother3] [nvarchar] (100) null,
 [commissionrate] [real] null,
 [orders] [int] null,
 [totalcommission] [money] null,
 [typeofpayment] [nvarchar] (50) null,
 [bank] [nvarchar] (100) null,
 [bankaccount] [nvarchar] (50) null,
 [bankbranch] [nvarchar] (100) null,
 [bankaddress] [nvarchar] (255) null,
 [bankother] [nvarchar] (255) null,
 [password] [nvarchar] (50) null,
 [directurl] [nvarchar] (255) null,
 [referralid] [int] null,
 [mastercommissionrate] [real],
 [template] [nvarchar] (200) null
) on [primary];
alter table [dbo].[affiliates] with nocheck add 
 constraint [df_affiliates_logincount] default (0) for [logincount],
 constraint [df_affiliates_commissionrate] default (0) for [commissionrate],
 constraint [df_affiliates_orders] default (0) for [orders],
 constraint [df_affiliates_totalcommission] default (0) for [totalcommission],
 constraint [pk_affiliates] primary key  nonclustered 
 (
 [affid]
 ) on [primary];

create table [dbo].[billing] (
 [billid] [int] identity (1,1) not null, 
 [billamount] [money] Null,
 [billnextbilldate] [datetime] Null,
 [billcustomer] [nvarchar] (255) Null,
 [billemail] [nvarchar] (100) Null,
 [billdescription] [nvarchar] (2000) Null,
 [billinstallments] [int] Null,
 [billinstallmenttype] [nvarchar] (50) Null,
 [billinterval] [int] Null,
 [billlastbilldate] [datetime] Null,
 [billorderid] [int] Null,
 [billlastmaildate] [datetime] Null,
 [billsentcount] [int] Null,
 [billcanceled] [bit] Null,
 [billcompleted] [bit] Null,
 [billcreationdate] [datetime] Null,
 [billorderitemid] [int] Null,
 [billenddate] [datetime] Null,
 [billtemplate] [nvarchar] (100) Null,
 [billother1] [nvarchar] (100) Null,
 [billother2] [nvarchar] (100) Null
) on [primary];
alter table [dbo].[billing] with nocheck add constraint [pk_billing] primary key  nonclustered ([billid]) on [primary];

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

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

create table [dbo].[categories] (
 [categoryid] [int] identity (1, 1) not null, 
 [catdescription] [nvarchar] (255) null, 
 [highercategoryid] [Int] null, 
 [catimage] [nvarchar] (100) null, 
 [hassubcategory] [nvarchar] (5) null, 
 [cathide] [nvarchar] (10) null, 
 [catextra] [nvarchar] (255) null, 
 [catextra2] [nvarchar] (255) null, 
 [catextra3] [nvarchar] (255) null, 
 [productmatch] [nvarchar] (50) null, 
 [customermatch] [nvarchar] (255) null, 
 [excustomermatch] [nvarchar] (255) null, 
 [catlanguage] [nvarchar] (50) null, 
 [catproducttemplate] [nvarchar] (255) null,
 [impressions] [int] null,
 [categorymetatitle] [nvarchar] (255) null,
 [smFrequency] [nvarchar] (255) null,
 [smPriority] [nvarchar] (255) null,
 [gsmincluded] [nvarchar] (10) null,
 [loggedin] [bit] null,
 [cdateadded] [Datetime] null, 
 [cdateupdated] [Datetime] null,
 [categorymetakeyword] [ntext] null,
 [categorymetadescription] [ntext] null,
 [catmemo] [ntext] null,
 [CatProCatDisplayCategoryID] [nvarchar] (4000) null
) on [primary];
alter table [dbo].[categories] with nocheck add constraint [pk_categories] primary key  nonclustered ([categoryid]) on [primary];

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

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

create table [dbo].[configuration] (
 [id] [int] identity (1, 1) not null,
 [fieldname] [nvarchar] (50) null,
 [fieldvalue] [nvarchar] (255) null,
 [fieldgroup] [nvarchar] (50) null,
 [fieldyesno] [bit] null,
 [showfield] [nvarchar] (50) null,
 [fieldgroup2] [nvarchar] (50) null,
 [newfieldgroup] [nvarchar] (50) null,
 [newfieldgroup2] [nvarchar] (50) null,
 [message] [nvarchar] (2000) null
) on [primary];
alter table [dbo].[configuration] with nocheck add constraint [pk_configuration] primary key nonclustered ([id]) on [primary];

create table [dbo].[configuration1] (
 [id] [int] identity (1, 1) not null ,
 [fieldname] [nvarchar] (50) null ,
 [fieldvalue] [nvarchar] (200) null ,
 [fieldgroup] [nvarchar] (20)  null ,
 [fieldyesno] [bit] null,
 [showfield] [nvarchar] (50) null,
 [fieldgroup2] [nvarchar] (50) null,
 [newfieldgroup] [nvarchar] (50) null,
 [newfieldgroup2] [nvarchar] (50) null,
 [message] [nvarchar] (2000)  null
) on [primary] 
;
alter table [dbo].[configuration1] with nocheck add constraint [pk_configuration1] primary key  nonclustered ([id]) on [primary];

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

create table [dbo].[content] (
 [contentid] [int] identity (1, 1) not null, 
 [messagetype] [nvarchar] (100) null, 
 [contentimage] [nvarchar] (255) null, 
 [hide] [bit] null, 
 [template] [nvarchar] (255) null, 
 [contentlanguage] [nvarchar] (50) null, 
 [other1] [nvarchar] (255) null, 
 [other2] [nvarchar] (255) null, 
 [other3] [nvarchar] (255) null,
 [loggedin] [bit] null,
 [impressions] [int] null,
 [cdateadded] [datetime] null,
 [cdateupdated] [datetime] null,
 [homepage] [bit] null,
 [fullname] [nvarchar] (255) null,
 [contactid] [nvarchar] (255) null,
 [contentgroups] [nvarchar] (255) null,
 [excontentgroups] [nvarchar] (255) null,
 [showonbox] [bit] null,
 [nurllink] nvarchar(255) null,
 [ncategoryid] [nvarchar] (50) null,
 [cNewsStartDate] [datetime] null,
 [cNewsEndDate] [datetime] null,
 [metatitle] [nvarchar] (255) null,
 [smFrequency] [nvarchar] (255) null,
 [smPriority] [nvarchar] (255) null,
 [gsmincluded] [nvarchar] (10) null,
 [metakeywords] [ntext] null,
 [metadescription] [ntext] null,
 [message] [ntext] null, 
 [message2] [ntext] null,
 [userid] [nvarchar] (50) null,
 [productmatch] [nvarchar] (50) null
) on [primary];
alter table [dbo].[content] with nocheck add 
 constraint [df_content_impressions] default (0) for [impressions],
 constraint [df_content_cdateadded] default (getdate()) for [cdateadded],
 constraint [pk_content] primary key  nonclustered 
 (
 [contentid]
 ) on [primary];
 
create table [dbo].[contentcategories] (
 [ncategoryid] [int] identity (1, 1) not null ,
 [ncatdescription] [nvarchar] (255) null, 
 [ncathide] [nvarchar] (50) null, 
 [ncatlanguage] [nvarchar] (50) null, 
 [ncattemplate] [nvarchar] (255) null,  
 [impressions] [int] null
) on [primary];
alter table [dbo].[contentcategories] with nocheck add constraint [pk_contentcategories] primary key nonclustered ([ncategoryid]) on [primary];

create table [dbo].[coupons] (
 [couponid] [int] identity (1, 1) not null ,
 [couponname] [nvarchar] (100) null ,
 [couponpercent] [real] null ,
 [couponamount] [money] null ,
 [couponstartdate] [datetime] null ,
 [couponenddate] [datetime] null ,
 [couponlimit] [int] null ,
 [couponcategories] [nvarchar] (255) null ,
 [couponproducts] [nvarchar] (255) null ,
 [couponusedcount] [int] null ,
 [couponlastuseddate] [datetime] null ,
 [couponcomment] [nvarchar] (255) null ,
 [couponother] [nvarchar] (100) null,
 [couponcustomers] [nvarchar] (255) null, 
 [couponminimum] [money] null,
 [couponaffid] [int] null
) on [primary];
alter table [dbo].[coupons] with nocheck add 
 constraint [df_coupons_couponpercent] default (0) for [couponpercent],
 constraint [df_coupons_couponamount] default (0) for [couponamount],
 constraint [df_coupons_couponlimit] default (0) for [couponlimit],
 constraint [df_coupons_couponusedcount] default (0) for [couponusedcount],
 constraint [pk_coupons] primary key  nonclustered 
 (
 [couponid]
 ) on [primary];

create table [dbo].[currencyvalues] (
 [id] [int] identity (1, 1) not null ,
 [cid] [nvarchar] (50) null ,
 [fullunitname] [nvarchar] (50) null ,
 [conversionvalue] [float] null ,
 [currencysymbol] [nvarchar] (100) null ,
 [theimage] [nvarchar] (100) null ,
 [hide] [bit] null
) on [primary];
alter table [dbo].[currencyvalues] with nocheck add constraint [pk_currencyvalues] primary key nonclustered ([id]) on [primary];

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

create table [dbo].[customerprices] (
 [id] [int] identity (1, 1) not null ,
 [customerid] [int] null ,
 [categoryid] [int] null ,
 [catalogid] [int] null ,
 [discountpercent] [float] null ,
 [discountamount] [money] null 
) on [primary];
alter table [dbo].[customerprices] with nocheck add 
 constraint [df_customerprices_catalogid] default (0) for [catalogid],
 constraint [df_customerprices_discountamount] default (0) for [discountamount],
 constraint [pk_customerprices] primary key  nonclustered 
 (
 [id]
 ) on [primary];
ALTER TABLE customerprices ADD	constraint [df_customerprices_catalogid] default (0) for [catalogid];
ALTER TABLE customerprices ADD	constraint [df_customerprices_discountamount] default (0) for [discountamount];

create table [dbo].[customers] (
 [contactid] [int] identity (1, 1) not null ,
 [firstname] [nvarchar] (50) null ,
 [lastname] [nvarchar] (50) null ,
 [address] [nvarchar] (255) null ,
 [address2] [nvarchar] (255) null,
 [city] [nvarchar] (100) null ,
 [state] [nvarchar] (100) null ,
 [postcode] [nvarchar] (20) null ,
 [country] [nvarchar] (100) null ,
 [company] [nvarchar] (255) null ,
 [phone] [nvarchar] (50) null ,
 [workphone] [nvarchar] (30) null ,
 [mobilephone] [nvarchar] (30) null ,
 [fax] [nvarchar] (30) null ,
 [email] [nvarchar] (100) null ,
 [contacttypeid] [int] null ,
 [comments] [nvarchar] (255) null ,
 [contactreason] [nvarchar] (20) null ,
 [logincount] [int] null ,
 [lastlogindate] [datetime] null ,
 [website] [nvarchar] (200) null ,
 [password] [nvarchar] (50) null ,
 [discount] [float] null ,
 [custother1] [nvarchar] (100) null ,
 [accountno] [nvarchar] (50) null ,
 [cardno] [nvarchar] (20) null ,
 [cardexpires] [nvarchar] (10) null ,
 [cardname] [nvarchar] (100) null ,
 [cardaddress] [nvarchar] (200) null ,
 [cardcvn] [nvarchar] (50) null,
 [maillist] [bit] null,
 [productgroup] [nvarchar](100),
 [cookiequestion] [bit],
 [pointstotal] int NULL,
 [pointsremaining] int NULL,
 [vatnumber] nvarchar (50) NULL,
 [userid]  nvarchar(100) NULL,
 [hearaboutus] [nvarchar] (100) null,
 [taxexempt] [nvarchar] (50) null,
 [authorized] [nvarchar] (50) null
) on [primary];
alter table [dbo].[customers] with nocheck add 
 constraint [df_customers_logincount] default (1) for [logincount],
 constraint [df_customers_lastlogindate] default (getdate()) for [lastlogindate],
 constraint [df_customers_discount] default (0) for [discount],
 constraint [pk_customers] primary key  nonclustered 
 (
 [contactid]
 ) on [primary];
create index [ix_customers] on [dbo].[customers]([lastname]) on [primary];
create index [ix_customers_3] on [dbo].[customers]([email]) on [primary];

create table [dbo].[downloads] (
 [id] [int] identity (1, 1) not null, 
 [orderid] [Int] null, 
 [catalogid] [Int] null, 
 [customerid] [Int] null, 
 [filename] [nvarchar] (255) null, 
 [downloadcount] [Int] null, 
 [downloaddatelimit] [Datetime] null, 
 [downloadmaxcount] [Int] null, 
 [downloadcreatedate] [Datetime] null, 
 [downloadother] [nvarchar] (100) null, 
 [downloadother1] [nvarchar] (100) null, 
 [authorized] [nvarchar] (10) null, 
 [lastdownloaddate] [Datetime] null
) on [primary];
alter table [dbo].[downloads] with nocheck add constraint [pk_downloads] primary key nonclustered ([id]) on [primary];

create table [dbo].[gifts] (
 [giftid] [int] identity (1, 1) not null ,
 [giftnumber] [nvarchar] (100) null ,
 [giftissuedate] [datetime] null ,
 [giftauthorized] [nvarchar] (10) null ,
 [giftamount] [money] null ,
 [giftamountremaining] [money] null ,
 [giftorderid] [int] null ,
 [giftcustomerid] [int] null ,
 [gifttoname] [nvarchar] (255) null ,
 [giftfromname] [nvarchar] (255) null ,
 [gifttoemail] [nvarchar] (255) null ,
 [giftmessage] [nvarchar] (255) null ,
 [giftfromemail] [nvarchar] (255) null ,
 [giftuseddate] [datetime] null ,
 [giftusedcustomerid] [int] null ,
 [giftusedlastamount] [money] null ,
 [giftusedorderid] [int] null ,
 [giftother] [nvarchar] (255) null ,
 [giftexpirydate] [datetime] null ,
 [giftusedcount] [int] null ,
 [giftusedtrace] [nvarchar] (255) null 
) on [primary];
alter table [dbo].[gifts] with nocheck add 
 constraint [df_gifts_giftamount] default (0) for [giftamount],
 constraint [df_gifts_giftamountremaining] default (0) for [giftamountremaining],
 constraint [df_gifts_giftorderid] default (0) for [giftorderid],
 constraint [df_gifts_giftcustomerid] default (0) for [giftcustomerid],
 constraint [df_gifts_giftusedcustomerid] default (0) for [giftusedcustomerid],
 constraint [df_gifts_giftusedlastamount] default (0) for [giftusedlastamount],
 constraint [df_gifts_giftusedorderid] default (0) for [giftusedorderid],
 constraint [df_gifts_giftusedcount] default (0) for [giftusedcount],
 constraint [pk_gifts] primary key  nonclustered 
 (
 [giftid]
 ) on [primary];
 
create table [dbo].[groups] (
 [groupid] [int] identity (1, 1) not null, 
 [groupname] [nvarchar] (100) null, 
 [grouptype] [nvarchar] (50) null, 
 [groupdiscount] [nvarchar] (50) null, 
 [grouppropricefield] [nvarchar] (50) null, 
 [grouppriority] [int] null, 
 [groupdescription] [nvarchar] (4000) null, 
 [groupsqlquery] [nvarchar] (4000) null
) on [primary];
alter table [dbo].[groups] with nocheck add constraint [pk_groups] primary key nonclustered ([groupid]) on [primary];

create table [dbo].[hackers] (
 [hackerid] [int] identity (1, 1) not null, 
 [ipaddress] [nvarchar] (50) null, 
 [email] [nvarchar] (200) null, 
 [comment] [nvarchar] (255) null, 
 [other] [nvarchar] (100) null
) on [primary];
alter table [dbo].[hackers] with nocheck add constraint [pk_hackers] primary key  nonclustered ([hackerid]) on [primary];

create table [dbo].[languages] (
 [id] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (50) null, 
 [keyword] [nvarchar] (50) null, 
 [caption] [nvarchar] (2000) null
) on [primary];
alter table [dbo].[languages] with nocheck add constraint [pk_languages] primary key  nonclustered ([id]) on [primary];

create table [dbo].[menuitem] (
 [id] [int] identity (1, 1) not null ,
 [name] [nvarchar] (50) null ,
 [seq] [int] null ,
 [pmenuitemid] [int] null ,
 [url] [nvarchar] (255) null ,
 [contentid] [int] null ,
 [openin] nvarchar (100) null,
 [productmatch] nvarchar (255) null
) on [primary];
alter table [dbo].[menuitem] with nocheck add constraint [pk_menuitem] primary key  nonclustered ([id]) on [primary];

create table [dbo].[mycompany] (
 [setupid] [int] identity (1, 1) not null ,
 [companyname] [nvarchar] (255) null ,
 [address] [nvarchar] (255) null ,
 [city] [nvarchar] (100) null ,
 [state] [nvarchar] (50) null ,
 [postalcode] [nvarchar] (20) null ,
 [country] [nvarchar] (50) null ,
 [phonenumber] [nvarchar] (50) null ,
 [faxnumber] [nvarchar] (50) null ,
 [myemail] [nvarchar] (255) null ,
 [other1] [nvarchar] (255) null ,
 [other2] [nvarchar] (100) null ,
 [other3] [nvarchar] (100) null ,
 [other4] [nvarchar] (100) null 
) on [primary];
alter table [dbo].[mycompany] with nocheck add constraint [pk_mycompany] primary key  nonclustered ([setupid]) on [primary];

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

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

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

create table [dbo].[oitems] (
 [orderitemid] [int] identity (1, 1) not null ,
 [orderid] [int] null ,
 [catalogid] [int] null ,
 [numitems] [float] null ,
 [unitprice] [money] null ,
 [dualprice] [float] null,
 [supplierid] [int] null,  
 [features] [nvarchar](255) null,
 [pinnumber] nvarchar(255) NULL,
 [customerimage] nvarchar(255) NULL,
 [downloadurl] [nvarchar] (255) NULL,
 [producttype] [nvarchar] (255) null,
 [bundleparentid] [Int] null,
 [bundleqty] [Int] null,
 [variants] [nvarchar] (255) null,
 [itemname] [nvarchar] (4000) null,
 [address] [nvarchar](1000) null
) on [primary];
alter table [dbo].[oitems] with nocheck add 
 constraint [df_oitems_orderid] default (0) for [orderid],
 constraint [df_oitems_catalogid] default (0) for [catalogid],
 constraint [df_oitems_numitems] default (0) for [numitems],
 constraint [df_oitems_unitprice] default (0) for [unitprice],
 constraint [df_oitems_dualprice] default (0) for [dualprice],
 constraint [df_oitems_supplierid] default (0) for [supplierid],
 constraint [pk_oitems] primary key  nonclustered 
 (
 [orderitemid]
 ) on [primary];
create  index [ix_oitems] on [dbo].[oitems]([orderid]) on [primary];

create table [dbo].[orders] (
 [orderid] [int] identity (1, 1) not null ,
 [ocustomerid] [int] null ,
 [odate] [datetime] null ,
 [orderamount] [money] null ,
 [ofirstname] [nvarchar] (100) null ,
 [olastname] [nvarchar] (100) null ,
 [oemail] [nvarchar] (100) null ,
 [oaddress] [nvarchar] (200) null ,
 [ocity] [nvarchar] (100) null ,
 [opostcode] [nvarchar] (15) null ,
 [ostate] [nvarchar] (100) null ,
 [ocountry] [nvarchar] (50) null ,
 [ophone] [nvarchar] (30) null ,
 [ofax] [nvarchar] (30) null ,
 [ocompany] [nvarchar] (255) null ,
 [ocardtype] [nvarchar] (50) null ,
 [ocardno] [nvarchar] (100) null ,
 [ocardname] [nvarchar] (200) null ,
 [ocardexpires] [nvarchar] (10) null ,
 [ocardaddress] [nvarchar] (150) null ,
 [oprocessed] [bit] not null ,
 [ocomment] [nvarchar] (255) null ,
 [otax] [money] null ,
 [opromisedshipdate] [datetime] null ,
 [oshippeddate] [datetime] null ,
 [oshipmethod] [int] null ,
 [oshipcost] [money] null ,
 [oshipname] [nvarchar] (100) null ,
 [oshipcompany] [nvarchar] (200) null ,
 [oshipemail] [nvarchar] (100) null ,
 [oshipmethodtype] [nvarchar] (100) null ,
 [oshipaddress] [nvarchar] (255) null ,
 [oshiptown] [nvarchar] (50) null ,
 [oshipzip] [nvarchar] (20) null ,
 [oshipstate] [nvarchar] (50) null ,
 [oshipcountry] [nvarchar] (50) null ,
 [opaymethod] [int] null ,
 [other1] [nvarchar] (50) null ,
 [other2] [nvarchar] (50) null ,
 [otime] [datetime] null ,
 [oauthorization] [nvarchar] (255) null ,
 [oerrors] [nvarchar] (255) null ,
 [odiscount] [float] null ,
 [ostatus] [nvarchar] (255) null ,
 [oaffid] [int] null ,
 [odualtotal] [real] null ,
 [odualtaxes] [real] null ,
 [odualshipping] [real] null ,
 [odualdiscount] [real] null ,
 [ohandling] [real] null ,
 [odualhandling] [real] null ,
 [coupon] [nvarchar] (100) null ,
 [coupondiscount] [money] null ,
 [coupondiscountdual] [real] null ,
 [giftcertificate] [nvarchar] (100) null ,
 [giftamountused] [money] null ,
 [giftamountuseddual] [real] null,
 [canceled] [bit] null,
 [ipaddress] [nvarchar] (50) null,  
 [hackeryesno] [bit] null,
 [customercancel] [bit] null,
 [opoints] int NULL,
 [vatnumber] [nvarchar] (50) NULL,
 [commission] money NULL,
 [opending] [nvarchar] (100) null, 
 [shipmessage] [nvarchar] (255) null,
 [hearaboutus] [nvarchar] (100) null,
 [oaddress2]  nvarchar(100) NULL,
 [oshipaddress2] nvarchar(100) NULL,
 [deliverydate]  nvarchar(20) NULL,
 [deliverytime]  nvarchar(20) NULL,
 [producttotal]  money NULL,
 [upstrackno] [nvarchar] (50) null,
 [opst] [money] null,
 [odualpst] [money] null,
 [affdatepaid] [datetime] null,
 [affpaid] [bit] null,
 [otermsagreed] [nvarchar] (10) null,
 [ocurrency] [nvarchar] (50) null,
 [ocurrencyrate] [nvarchar] (50) null,
 [storematch] [nvarchar] (100) null,
 [osurchargefees] [real] null,
 [odualsurchargefees] [real] null,
 [osurchargefeespercentage] [real] null,
 [osurchargefeespercentagefees] [real] null,
 [osurchargefeesfixed] [real] null,
 [osurchargetype] [nvarchar] (50) null
) on [primary];
alter table [dbo].[orders] with nocheck add 
 constraint [df_orders_ocustomerid] default (0) for [ocustomerid],
 constraint [df_orders_orderamount] default (0) for [orderamount],
 constraint [df_orders_producttotal] default (0) for [producttotal],
 constraint [df_orders_oprocessed] default (0) for [oprocessed],
 constraint [df_orders_otax] default (0) for [otax],
 constraint [df_orders_oshipmethod] default (0) for [oshipmethod],
 constraint [df_orders_oshipcost] default (0) for [oshipcost],
 constraint [df_orders_opaymethod] default (0) for [opaymethod],
 constraint [df_orders_otime] default (getdate()) for [otime],
 constraint [df_orders_odiscount] default (0) for [odiscount],
 constraint [df_orders_oaffid] default (0) for [oaffid],
 constraint [df_orders_odualtotal] default (0) for [odualtotal],
 constraint [df_orders_odualtaxes] default (0) for [odualtaxes],
 constraint [df_orders_odualshipping] default (0) for [odualshipping],
 constraint [df_orders_odualdiscount] default (0) for [odualdiscount],
 constraint [df_orders_ohandling] default (0) for [ohandling],
 constraint [df_orders_odualhandling] default (0) for [odualhandling],
 constraint [df_orders_coupondiscount] default (0) for [coupondiscount],
 constraint [df_orders_coupondiscountdual] default (0) for [coupondiscountdual],
 constraint [df_orders_giftamountused] default (0) for [giftamountused],
 constraint [df_orders_giftamountuseddual] default (0) for [giftamountuseddual],
 constraint [df_orders_commission] default (0) for [commission],
 constraint [pk_orders] primary key  nonclustered 
 (
 [orderid]
 ) on [primary];

create table [dbo].[ordertracking] (
 [trackid] [int] identity (1, 1) not null ,
 [orderid] [int] null ,
 [trackdate] [datetime] null ,
 [tracktime] [datetime] null ,
 [trackname] [nvarchar] (100) null ,
 [trackview] [bit]  ,
 [trackemail] [nvarchar] (100) null ,
 [trackother] [nvarchar] (100) null ,
 [trackcomment] [nvarchar] (2000) null
) on [primary];
alter table [dbo].[ordertracking] with nocheck add constraint [pk_ordertracking] primary key nonclustered ([trackid]) on [primary];

create table [dbo].[pinnumbers] (
 [serialid] [int] identity (1, 1) not null,
 [catalogid] [int] null,
 [pinnumber] [nvarchar] (255) null,
 [orderid] [int] null,
 [pinproductmatch] [nvarchar] (40) null,
 [pinother1] [nvarchar] (255) null
)on [primary];
alter table [dbo].[pinnumbers] with nocheck add constraint [pk_pinnumbers] primary key nonclustered ([serialid]) on [primary];

create table [dbo].[prodcategories] (
 [id] [int] identity (1, 1) not null ,
 [intcategoryid] [int] null ,
 [intcatalogid] [int]  null
) on [primary];
alter table [dbo].[prodcategories] with nocheck add 
 constraint [df_prodcategories_intcategoryid] default (0) for [intcategoryid],
 constraint [df_prodcategories_intcatalogid] default (0) for [intcatalogid],
 constraint [pk_prodcategories] primary key nonclustered 
 (
 [id]
 ) on [primary];
create index [ix_pccategories] on [dbo].[prodcategories]([intcategoryid]) on [primary];
create index [ix_pcproducts] on [dbo].[prodcategories]([intcatalogid]) on [primary];

create table [dbo].[prodfeatures] (
 [id] [int] identity (1, 1) not null ,
 [featurenum] [int] null ,
 [featurecaption] [nvarchar] (50) null ,
 [featurename] [nvarchar] (100) null ,
 [featureprice] [money] null ,
 [featureother] [nvarchar] (100) null ,
 [featuretype] [nvarchar] (10) null ,
 [featuremulti] [nvarchar] (10) null, 
 [featurerequired] [bit]  null,
 [featureother1] [nvarchar] (50) null,  
 [featureimage] [nvarchar] (255) null, 
 [featureweight] [real] null,
 [featurepercent] [real] null,
 [featuredefault] [bit] null,
 [featureorder] [real] null
) on [primary];
alter table [dbo].[prodfeatures] with nocheck add 
 constraint [df_prodfeatures_featurenum] default (0) for [featurenum],
 constraint [df_prodfeatures_featureprice] default (0) for [featureprice],
 constraint [pk_prodfeatures] primary key  nonclustered 
 (
 [id]
 ) on [primary];
create index [ix_prodfeatures] on [dbo].[prodfeatures]([featurenum]) on [primary];

create table [dbo].[products] (
 [catalogid] [int] identity (1, 1) not null ,
 [ccode] [nvarchar] (50) null ,
 [cname] [nvarchar] (255) null ,
 [cprice] [money] null ,
 [ccategory] [int] null ,
 [cdescurl] [nvarchar] (100) null ,
 [features] [nvarchar] (100) null ,
 [cimageurl] [nvarchar] (100) null ,
 [cstock] [int] null ,
 [weight] [nvarchar] (20) null ,
 [mfg] [nvarchar] (255) null ,
 [pother1] [nvarchar] (255) null ,
 [pother2] [nvarchar] (255) null ,
 [pother3] [nvarchar] (255) null ,
 [subcategoryid] [int] null ,
 [retailprice] [money] null ,
 [specialoffer] [nvarchar] (100) null ,
 [category] [nvarchar] (50) null ,
 [buttonimage] [nvarchar] (100) null ,
 [cdateavailable] [datetime] null ,
 [allowusertext] [nvarchar] (100) null ,
 [pother4] [nvarchar] (255) null ,
 [pother5] [nvarchar] (255) null ,
 [userid] [nvarchar] (50) null ,
 [keywords] [nvarchar] (255) null ,
 [template] [nvarchar] (100) null ,
 [extendedimage] [nvarchar] (100) null ,
 [selectlist] [nvarchar] (255) null ,
 [level3] [nvarchar] (255) null ,
 [level4] [nvarchar] (255) null ,
 [level5] [nvarchar] (255) null ,
 [minimumquantity] [int] null,
 [supplierid] [int] null,
 [crossselling] [nvarchar] (255) null,
 [hide] [bit] null,
 [productmatch] [nvarchar] (100) null,
 [customermatch] [nvarchar] (255) null,
 [excustomermatch] [nvarchar] (255) null,
 [orderattachment] [nvarchar] (255) null,
 [orderdownload] [nvarchar] (255) null,
 [groupfordiscount] [nvarchar] (50) null,
 [clanguage] [nvarchar] (50) null,
 [points] int NULL,
 [pointstobuy] int NULL,
 [price2] money NULL,
 [price3] money NULL,
 [billprice] Money Null,
 [billinstallments] int Null,
 [billinstallmenttype] nvarchar(50) Null,
 [billinterval] int Null,
 [maximumquantity] [Int] null, 
 [frontpage] [nvarchar] (100) null,
 [inventoryproducts] [nvarchar] (255) null,
 [taxfree]  [bit] null,
 [freeshipping] [bit] null,
 [highercatalogid] [int] null,
 [spdisplaytype] [nvarchar] (50) null,
 [hassubproduct] [nvarchar] (50) null,
 [impressions] [real] null,
 [cdateadded] [datetime] null,
 [cdateupdated] [datetime] null,
 [templatelisting] [nvarchar] (100) null,
 [extraimage1] [nvarchar] (100) null,
 [extraimage2] [nvarchar] (100) null,
 [extraimage3] [nvarchar] (100) null,
 [extraimage4] [nvarchar] (100) null,
 [extraimage5] [nvarchar] (100) null,
 [featuredflag] [bit] null,
 [featuredflagorder] [int] null,
 [customerimage] [bit] null,
 [rmadays] [int] null,
 [producttype] [nvarchar] (255) null,
 [youtube] [nvarchar] (255) null,
 [movie] [nvarchar] (255) null,
 [productmetatitle] [nvarchar] (255) null,
 [variants] [nvarchar] (100) null,
 [smFrequency] [nvarchar] (255) null,
 [smPriority] [nvarchar] (255) null,
 [gsmincluded] [nvarchar] (10) null,
 [loggedin] [bit] null,
 [ProProCatDisplayCategoryID] [nvarchar] (4000) null,
 [bundleproidqty] nvarchar (4000) null,
 [productmetakeyword] [ntext] null,
 [productmetadescription] [ntext] null,
 [cdescription] [ntext] null,
 [extendeddesc] [ntext] null,
 [featuredflag2] [bit] null,
 [featuredflagorder2] [real] null,
 [cdateend] [datetime] null,
 [largeextendedimage] [nvarchar] (100) null,
 [largeextraimage1] [nvarchar] (100) null,
 [largeextraimage2] [nvarchar] (100) null,
 [largeextraimage3] [nvarchar] (100) null,
 [largeextraimage4] [nvarchar] (100) null,
 [largeextraimage5] [nvarchar] (100) null,
 [displayproducttab] [bit] null,
 [tapcaption] [nvarchar] (255) null,
 [tapdescription] [ntext] null
) on [primary];
alter table [dbo].[products] with nocheck add 
 constraint [df_products_cprice] default (0) for [cprice],
 constraint [df_products_ccategory] default (0) for [ccategory],
 constraint [df_products_cstock] default (0) for [cstock],
 constraint [df_products_subcategoryid] default (0) for [subcategoryid],
 constraint [df_products_minimumquantity] default (0) for [minimumquantity],
 constraint [df_products_supplierid] default (0) for [supplierid],
 constraint [df_products_cdateavailable] default (getdate()) for [cdateavailable],
 constraint [df_products_cdateadded] default (getdate()) for [cdateadded],
 constraint [pk_products] primary key  nonclustered 
 (
 [catalogid]
 ) on [primary];
create index [ix_products_ccode] on [dbo].[products]([ccode]) on [primary];
create index [ix_products_cname] on [dbo].[products]([cname]) on [primary];

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

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

create table [dbo].[quantitydiscounts] (
 [id] [int] identity (1, 1) not null ,
 [categoryid] [int] null ,
 [catalogid] [int] null ,
 [minquantity] [int] null ,
 [quantity1] [int] null ,
 [discount1] [real] null ,
 [quantity2] [int] null ,
 [discount2] [real] null ,
 [quantity3] [int] null ,
 [discount3] [real] null ,
 [quantity4] [int] null ,
 [discount4] [real] null ,
 [quantity5] [int] null ,
 [discount5] [real] null,
 [other] [nvarchar] (50) null ,
 [groupfordiscount] [nvarchar] (100) null
) on [primary];
alter table [dbo].[quantitydiscounts] with nocheck add 
 constraint [df_quantitydiscounts_catalogid] default (0) for [catalogid],
 constraint [df_quantitydiscounts_minquantity] default (0) for [minquantity],
 constraint [df_quantitydiscounts_quantity1] default (0) for [quantity1],
 constraint [df_quantitydiscounts_discount1] default (0) for [discount1],
 constraint [df_quantitydiscounts_quantity2] default (0) for [quantity2],
 constraint [df_quantitydiscounts_discount2] default (0) for [discount2],
 constraint [df_quantitydiscounts_quantity3] default (0) for [quantity3],
 constraint [df_quantitydiscounts_discount3] default (0) for [discount3],
 constraint [df_quantitydiscounts_quantity4] default (0) for [quantity4],
 constraint [df_quantitydiscounts_discount4] default (0) for [discount4],
 constraint [df_quantitydiscounts_quantity5] default (0) for [quantity5],
 constraint [df_quantitydiscounts_discount5] default (0) for [discount5],
 constraint [pk_quantitydiscounts] primary key  nonclustered 
 (
 [id]
 ) on [primary];

create table [dbo].[registrant] (
 [registrantid] [int] identity (1, 1) not null ,
 [firstname] [nvarchar] (100) null ,
 [lastname] [nvarchar] (100) null,
 [address] [nvarchar] (255) null ,
 [city] [nvarchar] (100) null ,
 [state] [nvarchar] (100) null ,
 [postcode] [nvarchar] (50) null ,
 [country] [nvarchar] (100) null ,
 [company] [nvarchar] (100) null ,
 [phone] [nvarchar] (50) null ,
 [workphone] [nvarchar] (50) null ,
 [mobilephone] [nvarchar] (50) null ,
 [fax] [nvarchar] (50) null ,
 [email] [nvarchar] (255)  null ,
 [comments] [nvarchar] (255) null ,
 [logincount] [int] null ,
 [lastlogindate] [datetime] null,
 [regpassword] [nvarchar] (50) null ,
 [publicpassword] [nvarchar] (50) null ,
 [eventdate] [datetime] null ,
 [eventtype] [nvarchar] (255) null ,
 [eventdateend] [datetime] null ,
 [cofirstname] [nvarchar] (100) null ,
 [colastname] [nvarchar] (100)  null,
 [coaddress] [nvarchar] (255) null ,
 [cocity] [nvarchar] (100) null ,
 [costate] [nvarchar] (100) null ,
 [copostcode] [nvarchar] (50) null ,
 [cocountry] [nvarchar] (100) null ,
 [cophone] [nvarchar] (50) null ,
 [coemail] [nvarchar] (255) null ,
 [sendfirstname] [nvarchar] (50) null ,
 [sendlastname] [nvarchar] (50)  null,
 [sendaddress] [nvarchar] (255) null ,
 [sendcity] [nvarchar] (100) null ,
 [sendstate] [nvarchar] (100) null ,
 [sendpostcode] [nvarchar] (50) null ,
 [sendcountry] [nvarchar] (100) null ,
 [sendphone] [nvarchar] (50) null ,
 [sendemail] [nvarchar] (255) null ,
 [regdate] [datetime] null,
 [regtime] [datetime] null,
 [shippingtype] [nvarchar] (50) null,
 [regorderid] [int] null,
 [publicallowed] [nvarchar] (10) null,
 [regother1] [nvarchar] (100) null,
 [regother2] [nvarchar] (100) null,
 [processed] [bit] null,
 [thankyounote] [nvarchar] (2000) null
) on [primary];
alter table [dbo].[registrant] with nocheck add 
 constraint [df_registrant_logincount] default (0) for [logincount],
 constraint [df_registrant_lastlogindate] default (getdate()) for [lastlogindate],
 constraint [pk_registrant] primary key nonclustered 
 (
 [registrantid]
 ) on [primary];

create table [dbo].[registryitems] (
 [regitemid] [int] identity (1, 1) not null ,
 [registrantid] [int] null ,
 [orderid] [int] null,
 [regcatalogid] [int] null,
 [numitems] [int] null,
 [unitprice] [money] null,
 [dualprice] [real] null,
 [supplierid] [int] null,
 [address] [nvarchar] (255) null,
 [numpurchased] [int] null,
 [purchaseorderid] [nvarchar] (4000) null,
 [itemname] [nvarchar] (4000) null
) on [primary];
alter table [dbo].[registryitems] with nocheck add 
 constraint [df_registryitems_orderid] default (0) for [orderid],
 constraint [df_registryitems_regcatalogid] default (0) for [regcatalogid],
 constraint [df_registryitems_numitems] default (0) for [numitems],
 constraint [df_registryitems_unitprice] default (0) for [unitprice],
 constraint [df_registryitems_dualprice] default (0) for [dualprice],
 constraint [df_registryitems_supplierid] default (0) for [supplierid],
 constraint [pk_registryitems] primary key  nonclustered 
 (
 [regitemid]
 ) on [primary];

create table [dbo].[reviews] (
 [id] [int] identity (1, 1) not null ,
 [catalogid] [int] null ,
 [authorized] [nvarchar] (5) null,
 [reviewdate] [datetime] null ,
 [reviewtime] [datetime] null ,
 [rating] [int] null ,
 [title] [nvarchar] (255) null ,
 [location] [nvarchar] (100) null ,
 [name] [nvarchar] (100) null ,
 [email] [nvarchar] (255) null ,
 [other1] [nvarchar] (100) null ,
 [other2] [nvarchar] (50) null,
 [comment] [nvarchar] (2000) null
) on [primary];
alter table [dbo].[reviews] with nocheck add 
 constraint [df_reviews_catalogid] default (0) for [catalogid],
 constraint [pk_reviews] primary key  nonclustered 
 (
 [id]
 ) on [primary];

create table [dbo].[savedcarts] (
 [id] [int] identity (1, 1) not null, 
 [cartname] [nvarchar] (100) null, 
 [customerid] [Int] null, 
 [savedate] [Datetime] null, 
 [savetime] [Datetime] null, 
 [other1] [nvarchar] (100) null,
 [catalogid] int null,
 [cartcookies] [nvarchar] (2000) null
) on [primary];
alter table [dbo].[savedcarts] with nocheck add constraint [pk_savedcarts] primary key nonclustered ([id]) on [primary];

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

create table [dbo].[searchresults] (
 [id] [int] identity (1, 1) not null ,
 [rdate] [datetime] null ,
 [rtime] [datetime] null ,
 [categories] [nvarchar] (200) null ,
 [subcategories] [nvarchar] (200) null ,
 [words] [nvarchar] (255) null ,
 [lastname] [nvarchar] (50) null ,
 [customerid] [int] null ,
 [ipaddress] [nvarchar] (50) null ,
 [rother1] [nvarchar] (100) null ,
 [rother2] [nvarchar] (100) null 
) on [primary];
alter table [dbo].[searchresults] with nocheck add 
 constraint [df_searchresults_rdate] default (getdate()) for [rdate],
 constraint [df_searchresults_rtime] default (getdate()) for [rtime],
 constraint [df_searchresults_customerid] default (0) for [customerid],
 constraint [pk_searchresults] primary key  nonclustered 
 (
 [id]
 ) on [primary];

create table [dbo].[shipmethods] (
 [shipmethodid] [int] identity (1, 1) not null ,
 [shipmethod] [nvarchar] (50) null ,
 [smprice] [money] null ,
 [shipbasecost] [money] null ,
 [shipextracost] [money] null ,
 [shipother1] [nvarchar] (50) null ,
 [shipother2] [nvarchar] (50) null ,
 [shipcost1] [money] null ,
 [shipcost2] [money] null,
 [shiproutine] [nvarchar] (255),
 [shipcountry] [nvarchar] (50) null,
 [shipstate] [nvarchar] (50) null  
) on [primary];
alter table [dbo].[shipmethods] with nocheck add 
 constraint [df_shipmethods_smprice] default (0) for [smprice],
 constraint [pk_shipmethods] primary key  nonclustered 
 (
 [shipmethodid]
 ) on [primary];

create table [dbo].[shopcountries] (
 [countryid] [int] identity (1, 1) not null,
 [country] [nvarchar] (10) null,
 [countryname] [nvarchar] (100) null,
 [countrydisplayorder] [float] null,
 [countryhide] [bit] null,
 [countrytaxrate] [real] null,
 [countrygroup] [nvarchar] (50) null,
 [countryhacker] [bit] null
) on [primary];
alter table [dbo].[shopcountries] with nocheck add constraint [pk_shopcountries] primary key nonclustered ([countryid]) on [primary];

create table [dbo].[shoprma] (
 [rmaid] [int] identity (1, 1) not null ,
 [rma] [nvarchar] (100) null, 
 [rmacreationdate] [DateTime]  null, 
 [rmacustomeraction] [nvarchar] (100) null, 
 [rmamerchantaction] [nvarchar] (100) null, 
 [rmaorderid] [float] null, 
 [rmaitemid] [float] null, 
 [rmacustomername] [nvarchar] (155) null, 
 [rmacustomeremail] [nvarchar] (255) null, 
 [rmacustomerid] [float]  null, 
 [rmarefundamount] [money] null, 
 [rmamerchantdate] [DateTime]  null, 
 [rmamerchantname] [nvarchar] (155) null, 
 [rmamerchantemail] [nvarchar] (100) null, 
 [rmaother1] [nvarchar] (255) null, 
 [rmaother2] [nvarchar] (255) null, 
 [rmaprocessed] [bit] null, 
 [rmaproductname] [nvarchar] (255) null,
 [rmacustomercomment] [nvarchar] (4000) null, 
 [rmamerchantcomment] [nvarchar] (4000) null, 
 [rmamerchantnotes] [nvarchar] (4000) null
) on [primary];
alter table [dbo].[shoprma] with nocheck add constraint [pk_shoprma] primary key nonclustered ([rmaid]) on [primary];

create table [dbo].[shopstates] (
 [stateid] [int] identity (1, 1) not null,
 [stateabbrev] [nvarchar] (20) null,
 [statename] [nvarchar] (100) null,
 [statecountry] [nvarchar] (50) null,
 [statehide] [bit] null,
 [statetaxrate] [real] null,
 [statecanadapst] [real] null
) on [primary];
alter table [dbo].[shopstates] with nocheck add constraint [pk_shopstates] primary key nonclustered ([stateid]) on [primary];

create table [dbo].[sitesessions] (
 [id] [int] identity (1, 1) not null, 
 [sessionkey] [nvarchar] (50) null, 
 [sessionvaluename] [nvarchar] (100) null, 
 [sessiondate] [datetime] null,
 [sessiontime] [datetime] null,
 [sessionnow] [nvarchar] (50) null,
 [sessionvalue] [ntext] null
) on [primary];
alter table [dbo].[sitesessions] with nocheck add constraint [pk_sitesessions] primary key nonclustered ([id]) on [primary];
create  index [ix_sitesessions] on [dbo].[sitesessions]([sessionkey]) on [primary];

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

create table [dbo].[suppliers] (
 [supplierid] [int] identity (1, 1) not null, 
 [name] [nvarchar] (255) null, 
 [supplieruserid] [nvarchar] (100) null, 
 [firstname] [nvarchar] (50) null, 
 [lastname] [nvarchar] (50) null, 
 [address] [nvarchar] (255) null, 
 [city] [nvarchar] (100) null, 
 [state] [nvarchar] (100) null, 
 [postcode] [nvarchar] (20) null, 
 [country] [nvarchar] (100) null, 
 [company] [nvarchar] (255) null, 
 [phone] [nvarchar] (50) null, 
 [workphone] [nvarchar] (30) null, 
 [mobilephone] [nvarchar] (30) null, 
 [fax] [nvarchar] (30) null, 
 [email] [nvarchar] (50) null, 
 [comments] [nvarchar] (255) null, 
 [logincount] [Int] null, 
 [lastlogindate] [datetime] null, 
 [website] [nvarchar] (200) null, 
 [supplierpassword] [nvarchar] (100) null, 
 [accountno] [nvarchar] (50) null, 
 [template] [nvarchar] (100) null, 
 [commissionrate] [real] null, 
 [other1] [nvarchar] (100) null
) on [primary];
alter table [dbo].[suppliers] with nocheck add 
 constraint [df_suppliers_logincount] default (0) for [logincount],
 constraint [df_suppliers_commissionrate] default (0) for [commissionrate],
 constraint [pk_suppliers] primary key  nonclustered 
 (
 [supplierid]
 ) on [primary];

create table [dbo].[tblaccess] (
 [fldauto] [int] identity (1, 1) not null ,
 [fldname] [nvarchar] (255) null ,
 [fldurl] [nvarchar] (255) null ,
 [fldcomment] [nvarchar] (255) null ,
 [flddatabase] [nvarchar] (50) null,
 [fldsection] [nvarchar] (50) null,
 [fldmenu] [nvarchar] (50) null,
 [fldimage] [nvarchar] (255) null,
 [fldorder] [nvarchar] (100) null,
 [fldlevel] [real] null
) on [primary];
alter table [dbo].[tblaccess] with nocheck add constraint [pk_tblaccess] primary key nonclustered ([fldauto]) on [primary];

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

create table [dbo].[tbllog] (
 [fldauto] [int] identity (1, 1) not null ,
 [fldusername] [nvarchar] (50) null ,
 [fldtime] [datetime] null ,
 [flddate] [datetime] null ,
 [fldinout] [nvarchar] (50) null,
 [fldipaddress] nvarchar(40) NULL   
) on [primary];
alter table [dbo].[tbllog] with nocheck add constraint [pk_tbllog] primary key nonclustered ([fldauto]) on [primary];

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

create table [dbo].[tbluser] (
 [fldauto] [int] identity (1, 1) not null ,
 [fldusername] [nvarchar] (255) null ,
 [fldpassword] [nvarchar] (255) null ,
 [flddatabase] [nvarchar] (50) null ,
 [admintype] [nvarchar] (10) null ,
 [uploaddirectory] [nvarchar] (100) null ,
 [adminother1] [nvarchar] (100) null,
 [logincnt] [real] null,
 [shortcut] [nvarchar] (1000) null,
 [fldaccess] [ntext] null,
 [tablesallowed] [ntext] null
) on [primary];
alter table [dbo].[tbluser] with nocheck add constraint [pk_tbluser] primary key nonclustered ([fldauto]) on [primary];

create table [dbo].[templates] (
 [id] [int] identity (1, 1) not null, 
 [templatename] [nvarchar] (100) null, 
 [template] [nvarchar] (4000) null
) on [primary];
alter table [dbo].[templates] with nocheck add constraint [pk_templates] primary key nonclustered ([id]) on [primary];

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

create table [dbo].[translatecategories] (
 [translateid] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (100) null, 
 [categoryid] [Int] null, 
 [catdescription] [nvarchar] (255) null,
 [categorymetatitle] [nvarchar] (255) null,
 [categorymetakeyword] [ntext] null,
 [categorymetadescription] [ntext] null
) on [primary];
alter table [dbo].[translatecategories] with nocheck add constraint [pk_translatecategories] primary key nonclustered ([translateid])  on [primary];

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

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

create table [dbo].[translateprodfeatures] (
 [translateid] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (100) null, 
 [id] [Int] null, 
 [featurecaption] [nvarchar] (100) null, 
 [featurename] [nvarchar] (255) null
) on [primary];
alter table [dbo].[translateprodfeatures] with nocheck add constraint [pk_translateprodfeatures] primary key nonclustered ([translateid]) on [primary];

create table [dbo].[translateproducts] (
 [translateid] [int] identity (1, 1) not null, 
 [lang] [nvarchar] (100) null, 
 [catalogid] [Int] null, 
 [cname] [nvarchar] (255) null, 
 [cdescription] [ntext] null, 
 [extendeddesc] [ntext] null,
 [productmetatitle] [nvarchar] (255) null,
 [productmetakeyword] [ntext] null,
 [productmetadescription] [ntext] null,
 [tapcaption] [nvarchar] (255) null,
 [tapdescription] [ntext] null
) on [primary];	
alter table [dbo].[translateproducts] with nocheck add constraint [pk_translateproducts] primary key nonclustered ([translateid]) on [primary];

create table [dbo].[ups_config] (
 [upsid] [int] identity (1, 1) not null, 
 [xzeroweighterror] [nvarchar] (10) null,
 [xautoseparateweight] [nvarchar] (10) null,
 [xautoseparatepackages] [nvarchar] (10) null,
 [xsuppliershipfield] [nvarchar] (30) null,
 [xusesupplierzip] [nvarchar] (10) null,
 [xindividualpackages] [nvarchar] (10) null,
 [ups_weightunits] [nvarchar] (10) null,
 [ups_residentialind] [nvarchar] (10) null,
 [ups_unitofmeasurement] [nvarchar] (10) null,
 [packagingtype] [nvarchar] (10) null,
 [pickuptype] [nvarchar] (10) null,
 [xmerchantcountry] [nvarchar] (10) null,
 [xmerchantstate] [nvarchar] (10) null,
 [xmerchantcity] [nvarchar] (50) null,
 [xmerchantpostcode] [nvarchar] (20) null,
 [accesslicencenum] [nvarchar] (50) null,
 [username] [nvarchar] (50) null,
 [password] [nvarchar] (50) null,
 [developerkey] [nvarchar] (50) null,
 [gatewaylocation_license] [nvarchar] (50) null,
 [gatewaylocation_register] [nvarchar] (50) null,
 [xml] [nvarchar] (10) null,
 [xcheckindividualproductfield] [nvarchar] (10) null,
 [xcheckindividualproduct] [nvarchar] (10) null,
 [xdimensionfield] [nvarchar] (30) null,
 [ups_dimensions] [nvarchar] (20) null,
 [gatewaylocation_paymenttesting] [nvarchar] (50) null,
 [gatewaylocation_payment] [nvarchar] (50) null,
 [testmode] [nvarchar] (10) null,
 [xupsacctno] [nvarchar] (20) null,
 [dimensions] [nvarchar] (20) null,
 [xtrace] [nvarchar] (10) null,
 [xtracexml] [nvarchar] (10) null,
 [gatewaylocation_trackingtesting] [nvarchar] (50) null,
 [gatewaylocation_tracking] [nvarchar] (50) null	
) on [primary];
alter table [dbo].[ups_config] with nocheck add constraint [pk_ups_config] primary key nonclustered ([upsid]) on [primary];

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

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

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