TXT Discuz.Web/upgrade/sqlscript/access/upgrade.txt

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

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

ALTER TABLE [dnt_forumfields] ADD [seokeywords] varchar (255) NULL
GO
ALTER TABLE [dnt_forumfields] ADD [seodescription] varchar (255) NULL
GO
ALTER TABLE [dnt_forumfields] ADD [rewritename] varchar (20)  NULL
GO
ALTER TABLE [dnt_online] ADD [newpms] integer NOT NULL   DEFAULT  0
GO
ALTER TABLE [dnt_online] ADD [newnotices] integer NOT NULL   DEFAULT  0
GO
ALTER TABLE [dnt_topics] ADD [attention] integer NOT NULL   DEFAULT  0
GO
ALTER TABLE [dnt_attachments] ADD [attachprice] integer NOT NULL   DEFAULT  0
GO

UPDATE [dnt_topics] SET [attention]=0
GO
	
CREATE TABLE [dnt_attachpaymentlog] (
	[id] integer IDENTITY (1,1) not null,
	[uid] integer Default 0,
	[username] char(50),
	[aid] integer Default 0,
	[authorid] integer Default 0,
	[postdatetime] datetime,
	[amount] integer Default 0,
	[netamount] integer Default 0
	)
GO

CREATE TABLE [dnt_navs] (
	[id] integer IDENTITY (1,1) not null,
	[parentid] integer Default 0,
	[name] char(50),
	[title] char(50),
	[url] char(50),
	[target] integer Default 0,
	[type] integer Default 0,
	[available] integer Default 0,
	[displayorder] integer Default 0,
	[highlight] integer Default 0,
	[level] integer Default 0
	)
GO

CREATE TABLE [dnt_banned] (
	[id] integer IDENTITY (1,1) not null,
	[ip1] integer Default 0,
	[ip2] integer Default 0,
	[ip3] integer Default 0,
	[ip4] integer Default 0,
	[admin] char(50),
	[dateline] datetime,
	[expiration] datetime
	)
GO


CREATE TABLE [dnt_notices] (
	[nid] integer IDENTITY (1,1) not null,