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

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

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

CREATE TABLE [dnt_spaceattachments] (
	[aid] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NOT NULL CONSTRAINT [DF_dnt_spaceattachments_uid] DEFAULT (0),
	[spacepostid] [int] NOT NULL CONSTRAINT [DF_dnt_spaceattachments_spacepostid] DEFAULT (0),
	[postdatetime] [datetime] NOT NULL CONSTRAINT [DF_dnt_spaceattachments_postdatetime] DEFAULT (getdate()),
	[filename] [nchar] (100)  NOT NULL CONSTRAINT [DF_dnt_spaceattachments_filename] DEFAULT (''),
	[filetype] [nchar] (50)  NOT NULL CONSTRAINT [DF_dnt_spaceattachments_filetype] DEFAULT (''),
	[filesize] [int] NOT NULL CONSTRAINT [DF_dnt_spaceattachments_filesize] DEFAULT (0),
	[attachment] [nchar] (100)  NOT NULL CONSTRAINT [DF_dnt_spaceattachments_attachment] DEFAULT (''),
	[downloads] [int] NOT NULL CONSTRAINT [DF_dnt_spaceattachments_downloads] DEFAULT (0),
	CONSTRAINT [PK_dnt_spaceattachments] PRIMARY KEY  CLUSTERED 
	(
		[aid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacecategories] (
	[categoryid] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nvarchar] (50)  NOT NULL CONSTRAINT [DF_dnt_spacecategory_title] DEFAULT (''),
	[uid] [int] NOT NULL CONSTRAINT [DF_dnt_spacecategory_uid] DEFAULT (0),
	[description] [nvarchar] (1000)  NOT NULL CONSTRAINT [DF_dnt_spacecategorys_description] DEFAULT (''),
	[typeid] [int] NOT NULL CONSTRAINT [DF_dnt_spacecategory_typeid] DEFAULT (0),
	[categorycount] [int] NOT NULL CONSTRAINT [DF_dnt_spacecategory_categorycount] DEFAULT (0),
	[displayorder] [int] NOT NULL CONSTRAINT [DF_dnt_spacecategory_displayorder] DEFAULT (0),
	CONSTRAINT [PK_dnt_spacecategory] PRIMARY KEY  CLUSTERED 
	(
		[categoryid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacecomments] (
	[commentid] [int] IDENTITY (1, 1) NOT NULL ,
	[postid] [int] NOT NULL CONSTRAINT [DF_dnt_spacecomments_postid] DEFAULT (0),
	[author] [nvarchar] (50)  NOT NULL CONSTRAINT [DF_dnt_spacecomments_author] DEFAULT (''),
	[email] [nvarchar] (100)  NOT NULL CONSTRAINT [DF_dnt_spacecomments_email] DEFAULT (''),
	[url] [nvarchar] (255)  NOT NULL CONSTRAINT [DF_dnt_spacecomments_url] DEFAULT (''),
	[ip] [varchar] (100)  NOT NULL CONSTRAINT [DF_dnt_spacecomments_ip] DEFAULT (''),
	[postdatetime] [smalldatetime] NOT NULL CONSTRAINT [DF_dnt_spacecomments_postdatetime] DEFAULT (getdate()),
	[content] [nvarchar] (2000)  NOT NULL CONSTRAINT [DF_dnt_spacecomments_content] DEFAULT (''),
	[parentid] [int] NOT NULL ,
	[uid] [int] NOT NULL ,
	[posttitle] [nvarchar] (60)  NOT NULL ,
	CONSTRAINT [PK_dnt_spacecomments] PRIMARY KEY  CLUSTERED 
	(
		[commentid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spaceconfigs] (
	[spaceid] [int] IDENTITY (1, 1) NOT NULL ,
	[userid] [int] NOT NULL ,
	[spacetitle] [nchar] (100)  NOT NULL CONSTRAINT [DF_dnt_spaceconfig_spacetitle] DEFAULT (''),
	[description] [nchar] (200)  NOT NULL CONSTRAINT [DF_dnt_spaceconfig_description] DEFAULT (''),
	[blogdispmode] [tinyint] NOT NULL CONSTRAINT [DF_dnt_spaceconfig_blogdispmode] DEFAULT (0),
	[bpp] [int] NOT NULL CONSTRAINT [DF_dnt_spaceconfig_bpp] DEFAULT (16),
	[commentpref] [tinyint] NOT NULL CONSTRAINT [DF_dnt_spaceconfig_commentpref] DEFAULT (0),
	[messagepref] [tinyint] NOT NULL CONSTRAINT [DF_dnt_spaceconfig_messagepref] DEFAULT (0),