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

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

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

IF OBJECT_ID('dnt_admingroups') IS NOT NULL
DROP TABLE [dnt_admingroups]
GO

CREATE TABLE [dnt_admingroups] (
	[admingid] [smallint] NOT NULL ,
	[alloweditpost] [tinyint] NOT NULL ,
	[alloweditpoll] [tinyint] NOT NULL ,
	[allowstickthread] [tinyint] NOT NULL ,
	[allowmodpost] [tinyint] NOT NULL ,
	[allowdelpost] [tinyint] NOT NULL ,
	[allowmassprune] [tinyint] NOT NULL ,
	[allowrefund] [tinyint] NOT NULL ,
	[allowcensorword] [tinyint] NOT NULL ,
	[allowviewip] [tinyint] NOT NULL ,
	[allowbanip] [tinyint] NOT NULL ,
	[allowedituser] [tinyint] NOT NULL ,
	[allowmoduser] [tinyint] NOT NULL ,
	[allowbanuser] [tinyint] NOT NULL ,
	[allowpostannounce] [tinyint] NOT NULL ,
	[allowviewlog] [tinyint] NOT NULL ,
	[disablepostctrl] [tinyint] NOT NULL ,
	[allowviewrealname] [tinyint] NOT NULL 
) ON [PRIMARY]
GO

IF OBJECT_ID('dnt_adminvisitlog') IS NOT NULL
DROP TABLE [dnt_adminvisitlog]
GO

CREATE TABLE [dnt_adminvisitlog] (
	[visitid] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NULL ,
	[username] [nvarchar] (20) NOT NULL ,
	[groupid] [int] NULL ,
	[grouptitle] [nvarchar] (50) NOT NULL ,
	[ip] [varchar] (15) NULL ,
	[postdatetime] [datetime] NULL CONSTRAINT [DF_dnt_adminvisitlog_postdatetime] DEFAULT (getdate()),
	[actions] [nvarchar] (100) NOT NULL ,
	[others] [nvarchar] (200) NOT NULL 
) ON [PRIMARY]
GO

IF OBJECT_ID('dnt_advertisements') IS NOT NULL
DROP TABLE [dnt_advertisements]
GO

CREATE TABLE [dnt_advertisements] (
	[advid] [int] IDENTITY (1, 1) NOT NULL ,
	[available] [int] NOT NULL ,
	[type] [nvarchar] (50) NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[title] [nvarchar] (50)  NOT NULL ,
	[targets] [nvarchar] (255) NOT NULL ,
	[starttime] [datetime] NOT NULL ,
	[endtime] [datetime] NOT NULL ,
	[code] [ntext] NOT NULL CONSTRAINT [DF_dnt_advertisements_code] DEFAULT (''),
	[parameters] [ntext] NOT NULL CONSTRAINT [DF_dnt_advertisements_parameters] DEFAULT ('')
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO