﻿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]

;