Discuz.Web/upgrade/sqlscript/sqlserver/upgradetable20.sql

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

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

--并添加allowpostspecial,allowspecialonly，两字段均为整型
ALTER TABLE [dnt_forums] ADD [allowpostspecial] [int] NOT NULL DEFAULT ('0')
GO

ALTER TABLE [dnt_forums] ADD [allowspecialonly] [int] NOT NULL DEFAULT ('0')
GO

ALTER TABLE [dnt_forums] ADD [allowtag] [int] NOT NULL DEFAULT ('0')
GO

EXEC sp_rename '[dnt_forums].[colcount]',  'colcount2',  'COLUMN'
GO

ALTER TABLE [dnt_forums] DROP CONSTRAINT [DF_dnt_forums_colcount]
GO

ALTER TABLE [dnt_forums] ADD [colcount] [smallint]  NULL
GO

ALTER TABLE [dnt_forums] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_forums_colcount]  DEFAULT (1) FOR [colcount]
GO

UPDATE [dnt_forums] SET [colcount]=[colcount2]
GO

ALTER TABLE [dnt_forums] ALTER COLUMN [colcount] [smallint]  NOT NULL
GO

ALTER TABLE [dnt_forums] DROP COLUMN [colcount2]
GO

ALTER TABLE [dnt_forums] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_forums_colcount] DEFAULT (1) FOR [colcount]
GO

UPDATE  [dnt_forums] SET [allowpostspecial]=0,[allowspecialonly]=0,[allowtag]=0
GO

ALTER TABLE [dnt_usergroups] ADD [allowdebate] [int] NOT NULL DEFAULT (0)
GO

ALTER TABLE [dnt_usergroups] ADD [allowbonus] [int] NOT NULL DEFAULT (0)
GO

ALTER TABLE [dnt_usergroups] ADD [minbonusprice] [smallint] NOT NULL DEFAULT (0)
GO

ALTER TABLE [dnt_usergroups] ADD [maxbonusprice] [smallint] NOT NULL DEFAULT (0)
GO

ALTER TABLE [dnt_usergroups] ADD [allowtrade] [int] NOT NULL DEFAULT (0)
GO

ALTER TABLE [dnt_usergroups] ADD [allowdiggs] [int] NOT NULL DEFAULT (0)
GO

UPDATE  [dnt_usergroups] SET [allowdebate]=1,[allowbonus]=1,[minbonusprice]=1,[maxbonusprice]=100,[allowtrade]=1,[allowdiggs]=1 where groupid=1
GO