discuz！nt .net论坛开源代码

if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goods]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goods] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goodsattachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goodsattachments] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goodscategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goodscategories] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goodscreditrules]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goodscreditrules] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goodsleavewords]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goodsleavewords] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goodsrates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goodsrates] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goodstags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goodstags] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goodstradelogs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goodstradelogs] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_goodsusercredits]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_goodsusercredits] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_shopcategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_shopcategories] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_shoplinks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_shoplinks] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_shops]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_shops] ; if exists (select * from dbo.sysobjects where id = object_id(N'[dnt_shopthemes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dnt_shopthemes] ; CREATE TABLE [dnt_goods] ( [goodsid] [int] IDENTITY (1, 1) NOT NULL , [shopid] [int] NOT NULL , [categoryid] [int] NOT NULL , [parentcategorylist] [char] (300) NOT NULL , [shopcategorylist] [char] (300) NOT NULL , [recommend] [tinyint] NOT NULL , [discount] [tinyint] NOT NULL , [selleruid] [int] NOT NULL , [seller] [nchar] (20) NOT NULL , [account] [nchar] (50) NOT NULL , [title] [nchar] (60) NOT NULL , [magic] [int] NOT NULL , [price] [decimal](18, 2) NOT NULL , [amount] [smallint] NOT NULL , [quality] [tinyint] NOT NULL , [lid] [int] NOT NULL , [locus] [nchar] (20) NOT NULL , [transport] [tinyint] NOT NULL , [ordinaryfee] [decimal](18, 2) NOT NULL , [expressfee] [decimal](18, 2) NOT NULL , [emsfee] [decimal](18, 2) NOT NULL , [itemtype] [tinyint] NOT NULL , [dateline] [datetime] NOT NULL , [expiration] [datetime] NOT NULL , [lastbuyer] [nchar] (10) NOT NULL , [lasttrade] [datetime] NOT NULL , [lastupdate] [datetime] NOT NULL , [totalitems] [smallint] NOT NULL , [tradesum] [decimal](18, 2) NOT NULL , [closed] [tinyint] NOT NULL , [aid] [int] NOT NULL , [goodspic] [nchar] (100) NOT NULL , [displayorder] [int] NOT NULL , [costprice] [decimal](18, 2) NOT NULL , [invoice] [tinyint] NOT NULL , [repair] [smallint] NOT NULL , [message] [ntext] NOT NULL , [otherlink] [nchar] (250) NOT NULL , [readperm] [int] NOT NULL , [tradetype] [tinyint] NOT NULL , [viewcount] [int] NOT NULL , [invisible] [int] NOT NULL , [smileyoff] [int] NOT NULL , [bbcodeoff] [int] NOT NULL , [parseurloff] [int] NOT NULL , [highlight] [varchar] (500) NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ; CREATE TABLE [dnt_goodsattachments] ( [aid] [int] IDENTITY (1, 1) NOT NULL , [uid] [int] NOT NULL , [goodsid] [int] NOT NULL , [categoryid] [int] NOT NULL , [postdatetime] [datetime] NOT NULL , [readperm] [int] NOT NULL , [filename] [nchar] (100) NOT NULL , [description] [nchar] (100) NOT NULL , [filetype] [nchar] (50) NOT NULL , [filesize] [int] NOT NULL , [attachment] [nchar] (100) NOT NULL ) ON [PRIMARY] ; CREATE TABLE [dnt_goodscategories] ( [categoryid] [int] IDENTITY (1, 1) NOT NULL , [parentid] [int] NOT NULL , [layer] [smallint] NOT NULL , [parentidlist] [char] (300) NOT NULL , [displayorder] [int] NOT NULL , [categoryname] [nchar] (50) NOT NULL , [haschild] [bit] NOT NULL , [fid] [int] NOT NULL , [pathlist] [nchar] (3000) NOT NULL , [goodscount] [int] NOT NULL ) ON [PRIMARY] ; CREATE TABLE [dnt_goodscreditrules] ( [id] [int] NOT NULL , [lowerlimit] [int] NOT NULL , [upperlimit] [int] NOT NULL , [sellericon] [varchar] (20) NULL , [buyericon] [varchar] (20) NULL ) ON [PRIMARY] ; CREATE TABLE [dnt_goodsleavewords] ( [id] [int] IDENTITY (1, 1) NOT NULL , [goodsid] [int] NOT NULL , [tradelogid] [int] NOT NULL , [isbuyer] [tinyint] NOT NULL , [uid] [int] NOT NULL , [username] [nchar] (20) NOT NULL , [message] [nchar] (200) NOT NULL , [invisible] [int] NOT NULL , [ip] [nvarchar] (15) NOT NULL , [usesig] [int] NOT NULL , [htmlon] [int] NOT NULL , [smileyoff] [int] NOT NULL , [parseurloff] [int] NOT NULL , [bbcodeoff] [int] NOT NULL , [postdatetime] [datetime] NOT NULL ) ON [PRIMARY] ; CREATE TABLE [dnt_goodsrates] ( [id] [int] IDENTITY (1, 1) NOT NULL , [goodstradelogid] [int] NOT NULL , [message] [nchar] (200) NOT NULL , [explain] [nchar] (200) NOT NULL , [ip] [nvarchar] (15) NOT NULL , [uid] [int] NOT NULL , [uidtype] [tinyint] NOT NULL , [username] [nchar] (20) NOT NULL , [ratetouid] [int] NOT NULL , [ratetousername] [nchar] (20) NOT NULL , [postdatetime] [datetime] NOT NULL , [goodsid] [int] NOT NULL , [goodstitle] [nchar] (60) NOT NULL , [price] [decimal](18, 2) NOT NULL , [ratetype] [tinyint] NOT NULL ) ON [PRIMARY] ; CREATE TABLE [dnt_goodstags] ( [tagid] [int] NOT NULL , [goodsid] [int] NOT NULL ) ON [PRIMARY] ; CREATE TABLE [dnt_goodstradelogs] ( [id] [int] IDENTITY (1, 1) NOT NULL , [goodsid] [int] NOT NULL , [orderid] [varchar] (50) NOT NULL , [tradeno] [varchar] (50) NOT NULL , [subject] [nchar] (60) NOT NULL , [price] [decimal](18, 2) NOT NULL , [quality] [tinyint] NOT NULL , [categoryid] [int] NOT NULL , [number] [smallint] NOT NULL , [tax] [decimal](18, 2) NOT NULL , [locus] [varchar] (50) NOT NULL , [sellerid] [int] NOT NULL , [seller] [nchar] (20) NOT NULL , [selleraccount] [varchar] (50) NOT NULL , [buyerid] [int] NOT NULL , [buyer] [nchar] (20) NOT NULL , [buyercontact] [nchar] (100) NOT NULL , [buyercredit] [smallint] NOT NULL , [buyermsg] [nchar] (100) NOT NULL , [status] [tinyint] NOT NULL , [lastupdate] [datetime] NOT NULL , [offline] [tinyint] NOT NULL , [buyername] [nchar] (20) NOT NULL , [buyerzip] [varchar] (50) NOT NULL , [buyerphone] [varchar] (50) NOT NULL , [buyermobile] [varchar] (50) NOT NULL , [transport] [tinyint] NOT NULL , [transportfee] [decimal](18, 2) NOT NULL , [transportpay] [tinyint] NOT NULL , [tradesum] [decimal](18, 2) NOT NULL , [baseprice] [decimal](18, 2) NOT NULL , [discount] [tinyint] NOT NULL , [ratestatus] [tinyint] NOT NULL , [message] [ntext] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ; CREATE TABLE [dnt_goodsusercredits] ( [id] [int] IDENTITY (1, 1) NOT NULL , [uid] [int] NOT NULL , [oneweek] [int] NOT NULL , [onemonth] [int] NOT NULL , [sixmonth] [int] NOT NULL , [sixmonthago] [int] NOT NULL , [ratefrom] [tinyint] NOT NULL , [ratetype] [tinyint] NOT NULL ) ON [PRIMARY] ; CREATE TABLE [dnt_shopcategories] ( [categoryid] [int] IDENTITY (1, 1) NOT NULL , [parentid] [int] NOT NULL , [parentidlist] [char] (300) NOT NULL , [layer] [int] NOT NULL , [childcount] [int] NOT NULL