﻿ALTER TABLE dnt_users DROP CONSTRAINT [DF__dnt_users__oltim__14F1071C]
;

ALTER TABLE dnt_users ALTER column oltime int not null
;

ALTER TABLE dnt_users ADD CONSTRAINT [DF__dnt_users__oltim__14F1071C] DEFAULT (0) FOR [oltime]
;



if exists (select * from sysobjects where id = object_id(N'[dnt_moderatormanagelog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_moderatormanagelog]

;

CREATE TABLE [dnt_moderatormanagelog] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[moderatoruid] [int] NULL ,
	[moderatorname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[groupid] [int] NULL ,
	[grouptitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ip] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[postdatetime] [datetime] NULL ,
	[fid] [int] NULL ,
	[fname] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[tid] [int] NULL ,
	[title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[actions] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[reason] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]

;

ALTER TABLE [dnt_moderatormanagelog] ADD 
	CONSTRAINT [DF_dnt_moderatormanagelog_postdatetime] DEFAULT (getdate()) FOR [postdatetime]

;




if exists (select * from sysobjects where id = object_id(N'[dnt_online]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dnt_online]
;

CREATE TABLE [dnt_online] (
	[olid] [int] IDENTITY (1, 1) NOT NULL ,
	[userid] [int] NOT NULL ,
	[ip] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[username] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[tickcount] [int] NOT NULL ,
	[nickname] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[password] [char] (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[groupid] [smallint] NOT NULL ,
	[olimg] [varchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[adminid] [smallint] NOT NULL ,
	[invisible] [smallint] NOT NULL ,
	[action] [smallint] NOT NULL ,
	[lastactivity] [smallint] NOT NULL ,
	[lastposttime] [datetime] NOT NULL ,
	[lastsearchtime] [datetime] NOT NULL ,
	[lastupdatetime] [datetime] NOT NULL ,
	[forumid] [int] NOT NULL ,
	[forumname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[titleid] [int] NOT NULL ,
	[title] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[verifycode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

ALTER TABLE [dnt_online] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_online] PRIMARY KEY  CLUSTERED 
	(
		[olid]
	)  ON [PRIMARY] 
;

ALTER TABLE [dnt_online] ADD 
	CONSTRAINT [DF_dnt_online_userid] DEFAULT ((-1)) FOR [userid],
	CONSTRAINT [DF_dnt_online_ip] DEFAULT ('0.0.0.0') FOR [ip],
	CONSTRAINT [DF_dnt_online_username] DEFAULT ('') FOR [username],
	CONSTRAINT [DF_dnt_online_tickcount] DEFAULT (0) FOR [tickcount],
	CONSTRAINT [DF_dnt_online_nickname] DEFAULT ('') FOR [nickname],
	CONSTRAINT [DF_dnt_online_password] DEFAULT ('') FOR [password],
	CONSTRAINT [DF_dnt_online_groupid] DEFAULT (0) FOR [groupid],
	CONSTRAINT [DF_dnt_online_olimg] DEFAULT ('') FOR [olimg],
	CONSTRAINT [DF_dnt_online_adminid] DEFAULT (0) FOR [adminid],
	CONSTRAINT [DF_dnt_online_invisible] DEFAULT (0) FOR [invisible],
	CONSTRAINT [DF_dnt_online_action] DEFAULT (0) FOR [action],
	CONSTRAINT [DF_dnt_online_lastactivity] DEFAULT (0) FOR [lastactivity],
	CONSTRAINT [DF_dnt_online_lastposttime] DEFAULT ('1900-1-1 00:00:00') FOR [lastposttime],
	CONSTRAINT [DF_dnt_online_lastsearchtime] DEFAULT ('1900-1-1 00:00:00') FOR [lastsearchtime],
	CONSTRAINT [DF_dnt_online_lastupdatetime] DEFAULT (getdate()) FOR [lastupdatetime],
	CONSTRAINT [DF_dnt_online_forumid] DEFAULT (0) FOR [forumid],
	CONSTRAINT [DF_dnt_online_forumname] DEFAULT ('') FOR [forumname],
	CONSTRAINT [DF_dnt_online_titleid] DEFAULT (0) FOR [titleid],
	CONSTRAINT [DF_dnt_online_title] DEFAULT ('') FOR [title],
	CONSTRAINT [DF_dnt_online_verifycode] DEFAULT ('') FOR [verifycode]
;



if (not exists (select * from sysindexes where name='PK_dnt_topics'))
    ALTER TABLE [dnt_topics] ADD 
	CONSTRAINT [PK_dnt_topics] PRIMARY KEY  NONCLUSTERED 
	(
		[tid]
	)  ON [PRIMARY] 
;


INSERT INTO [dnt_bbcodes] (available,tag,icon,replacement,example,explanation,params,nest,paramsdescript,paramsdefvalue) VALUES  (1,'wma','wma.gif','<object classid="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6" width="260" height="64"><param name="autostart" value="0" /><param name="url" value="{1}" /><embed src="{1}" autostart="0" type="video/x-ms-wmv" width="260" height="42"></embed></object>','[wma]http://localhost/123.mp3[/wma]','在帖子中加入 Windows Media Player 格式的音频内容',1,1,'请输入 Windows Media Player 音频的地址','http://')
;

INSERT INTO [dnt_bbcodes] (available,tag,icon,replacement,example,explanation,params,nest,paramsdescript,paramsdefvalue) VALUES  (1,'rm','rm.gif','<object classid="clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA" width="{2}" height="{3}"><param name="src" value="{1}" /><param name="controls" value="imagewindow" /><param name="console" value="{1}" /><embed src="{1}" type="audio/x-pn-realaudio-plugin" controls="IMAGEWINDOW" console="{1}" width="{2}" height="360"></embed></object><br style="height:0" /><object classid="CLSID:CFCDAA03-8BE4-11CF-B84B-0020AFBBCCFA" width="{2}" height="32"><param name="src" value="{1}" /><param name="controls" value="controlpanel" /><param name="console" value="{1}" /><embed src="{1}" type="audio/x-pn-realaudio-plugin" controls="ControlPanel" console="{1}" width="{2}" height="32"></embed></object>','[rm=200,200]http://localhost/123.rm[/rm]','在帖子中插入RealPlayer视频',3,1,'请输入RealPlayer视频的地址,请输入RealPlayer视频的宽度,请输入RealPlayer视频的高度','http://,200,200')
;

INSERT INTO [dnt_bbcodes] (available,tag,icon,replacement,example,explanation,params,nest,paramsdescript,paramsdefvalue) VALUES  (1,'ra','ra.gif','<object classid="clsid:CFCDAA03-8BE4-11CF-B84B-0020AFBBCCFA" width="400" height="30"><param name="src" value="{1}" /><param name="controls" value="controlpanel" /><param name="console" value="{1}" /><embed src="{1}" type="audio/x-pn-realaudio-plugin" console="{1}" controls="ControlPanel" width="400" height="30"></embed></object>','[ra]http://localhost/123.ra[/ra]','在帖子中插入RealPlayer音频',1,1,'请输入RealPlayer音频地址','http://')
;

INSERT INTO [dnt_bbcodes] (available,tag,icon,replacement,example,explanation,params,nest,paramsdescript,paramsdefvalue) VALUES  (1,'fly','fly.gif','<marquee width="90%" behavior="alternate" scrollamount="3">{1}</marquee>','[fly]示例文字[/fly]','在帖子中插入滚动文字',1,1,'请输入滚动文字','滚动文字')
;




