Discuz.Web/install/sqlscript/sqlserver/mall/setup2.1.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

CREATE TABLE [dnt_goods] (
	[goodsid] [int] IDENTITY (1, 1) NOT NULL ,
	[shopid] [int] NOT NULL CONSTRAINT [DF_dnt_goods_shopid] DEFAULT (0),
	[categoryid] [int] NOT NULL CONSTRAINT [DF_dnt_goods_usergoodstypeid] DEFAULT (0),
	[parentcategorylist] [char] (300)  NOT NULL CONSTRAINT [DF_dnt_goods_parentidlist] DEFAULT (''),
	[shopcategorylist] [char] (300)  NOT NULL CONSTRAINT [DF_dnt_goods_shopcategorylist] DEFAULT (','),
	[recommend] [tinyint] NOT NULL CONSTRAINT [DF_dnt_goods_recommend] DEFAULT (0),
	[discount] [tinyint] NOT NULL CONSTRAINT [DF_dnt_goods_discount] DEFAULT (0),
	[selleruid] [int] NOT NULL CONSTRAINT [DF_dnt_goods_selleruid] DEFAULT (0),
	[seller] [nchar] (20)  NOT NULL CONSTRAINT [DF_dnt_goods_seller] DEFAULT (''),
	[account] [nchar] (50)  NOT NULL ,
	[title] [nchar] (60)  NOT NULL ,
	[magic] [int] NOT NULL CONSTRAINT [DF_dnt_goods_magic] DEFAULT (0),
	[price] [decimal](18, 2) NOT NULL CONSTRAINT [DF_dnt_goods_price] DEFAULT (0),
	[amount] [smallint] NOT NULL CONSTRAINT [DF_dnt_goods_amount] DEFAULT (0),
	[quality] [tinyint] NOT NULL CONSTRAINT [DF_dnt_goods_quality] DEFAULT (1),
	[lid] [int] NOT NULL ,
	[locus] [nchar] (20)  NOT NULL ,
	[transport] [tinyint] NOT NULL CONSTRAINT [DF_dnt_goods_transport] DEFAULT (0),
	[ordinaryfee] [decimal](18, 2) NOT NULL CONSTRAINT [DF_dnt_goods_ordinaryfee] DEFAULT (0),
	[expressfee] [decimal](18, 2) NOT NULL CONSTRAINT [DF_dnt_goods_expressfee] DEFAULT (0),
	[emsfee] [decimal](18, 2) NOT NULL ,
	[itemtype] [tinyint] NOT NULL CONSTRAINT [DF_dnt_goods_itemtype] DEFAULT (0),
	[dateline] [datetime] NOT NULL CONSTRAINT [DF_dnt_goods_dateline] DEFAULT (getdate()),
	[expiration] [datetime] NOT NULL ,
	[lastbuyer] [nchar] (10)  NOT NULL CONSTRAINT [DF_dnt_goods_lastbuyer] DEFAULT (''),
	[lasttrade] [datetime] NOT NULL ,
	[lastupdate] [datetime] NOT NULL CONSTRAINT [DF_dnt_goods_lastupdate] DEFAULT (getdate()),
	[totalitems] [smallint] NOT NULL ,
	[tradesum] [decimal](18, 2) NOT NULL CONSTRAINT [DF_dnt_goods_tradesum] DEFAULT (0),
	[closed] [tinyint] NOT NULL CONSTRAINT [DF_dnt_goods_closed] DEFAULT (0),
	[aid] [int] NOT NULL ,
	[goodspic] [nchar] (100)  NOT NULL CONSTRAINT [DF_dnt_goods_goodspic] DEFAULT (''),
	[displayorder] [int] NOT NULL CONSTRAINT [DF_dnt_goods_displayorder] DEFAULT (0),
	[costprice] [decimal](18, 2) NOT NULL CONSTRAINT [DF_dnt_goods_costprice] DEFAULT (0),
	[invoice] [tinyint] NOT NULL CONSTRAINT [DF_dnt_goods_invoice] DEFAULT (0),
	[repair] [smallint] NOT NULL CONSTRAINT [DF_dnt_goods_repair] DEFAULT (0),
	[message] [ntext]  NOT NULL ,
	[otherlink] [nchar] (250)  NOT NULL ,
	[readperm] [int] NOT NULL ,
	[tradetype] [tinyint] NOT NULL ,
	[viewcount] [int] NOT NULL CONSTRAINT [DF_dnt_goods_viewcount] DEFAULT (0),
	[invisible] [int] NOT NULL CONSTRAINT [DF_dnt_goods_invisible] DEFAULT (0),
	[smileyoff] [int] NOT NULL ,
	[bbcodeoff] [int] NOT NULL CONSTRAINT [DF_dnt_goods_bbcodeoff] DEFAULT (0),
	[parseurloff] [int] NOT NULL ,
	[highlight] [varchar] (500)  NOT NULL CONSTRAINT [DF_dnt_goods_highlight] DEFAULT ('')
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dnt_goodsattachments] (
	[aid] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NOT NULL CONSTRAINT [DF_dnt_goodsattachments_uid] DEFAULT (0),
	[goodsid] [int] NOT NULL CONSTRAINT [DF_dnt_goodsattachments_goodsid] DEFAULT (0),
	[categoryid] [int] NOT NULL CONSTRAINT [DF_dnt_goodsattachments_categoryid] DEFAULT (0),
	[postdatetime] [datetime] NOT NULL CONSTRAINT [DF_dnt_goodsattachments_postdatetime] DEFAULT (getdate()),
	[readperm] [int] NOT NULL CONSTRAINT [DF_dnt_goodsattachments_readperm] DEFAULT (0),
	[filename] [nchar] (100) NOT NULL CONSTRAINT [DF_dnt_goodsattachments_filename] DEFAULT (''),
	[description] [nchar] (100) NOT NULL CONSTRAINT [DF_dnt_goodsattachments_description] DEFAULT (''),
	[filetype] [nchar] (50) NOT NULL CONSTRAINT [DF_dnt_goodsattachments_filetype] DEFAULT (''),