﻿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 
) ON [PRIMARY]

;

CREATE TABLE [dnt_adminvisitlog] (
	[visitid] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NULL ,
	[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[groupid] [int] NULL ,
	[grouptitle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ip] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[postdatetime] [datetime] NULL ,
	[actions] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[others] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_advertisements] (
	[advid] [int] IDENTITY (1, 1) NOT NULL ,
	[available] [int] NOT NULL ,
	[type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[targets] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[parameters] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[code] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[starttime] [datetime] NOT NULL ,
	[endtime] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;

CREATE TABLE [dnt_announcements] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[poster] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[posterid] [int] NOT NULL ,
	[title] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[starttime] [datetime] NOT NULL ,
	[endtime] [datetime] NOT NULL ,
	[message] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;

CREATE TABLE [dnt_attachments] (
	[aid] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NOT NULL ,
	[tid] [int] NOT NULL ,
	[pid] [int] NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[readperm] [int] NOT NULL ,
	[filename] [nchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[description] [nchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[filetype] [nchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[filesize] [int] NOT NULL ,
	[attachment] [nchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[downloads] [int] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_attachtypes] (
	[id] [smallint] IDENTITY (1, 1) NOT NULL ,
	[extension] [varchar] (256) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[maxsize] [int] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_bbcodes] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[available] [int] NOT NULL ,
	[tag] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[icon] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[replacement] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[example] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[explanation] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[params] [int] NOT NULL ,
	[nest] [int] NOT NULL ,
	[paramsdescript] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[paramsdefvalue] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;



CREATE TABLE [dnt_creditslog] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NOT NULL ,
	[fromto] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sendcredits] [tinyint] NOT NULL ,
	[receivecredits] [tinyint] NOT NULL ,
	[send] [float] NOT NULL ,
	[receive] [float] NOT NULL ,
	[paydate] [datetime] NOT NULL ,
	[operation] [tinyint] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_favorites] (
	[uid] [int] NOT NULL ,
	[tid] [int] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_forumfields] (
	[fid] [smallint] NOT NULL ,
	[description] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[password] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[icon] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[postcredits] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[replycredits] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[redirect] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[attachextensions] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[moderators] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[rules] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[topictypes] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[viewperm] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[postperm] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[replyperm] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[getattachperm] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[postattachperm] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;

CREATE TABLE [dnt_forumlinks] (
	[id] [smallint] IDENTITY (1, 1) NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[url] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[note] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[logo] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_forums] (
	[fid] [int] IDENTITY (1, 1) NOT NULL ,
	[parentid] [smallint] NOT NULL ,
	[layer] [smallint] NOT NULL ,
	[pathlist] [nchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[parentidlist] [char] (300) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[subforumcount] [int] NOT NULL ,
	[name] [nchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[status] [int] NOT NULL ,
	[colcount] [smallint] NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[templateid] [smallint] NOT NULL ,
	[topics] [int] NOT NULL ,
	[curtopics] [int] NOT NULL ,
	[posts] [int] NOT NULL ,
	[todayposts] [int] NOT NULL ,
	[lasttid] [int] NOT NULL ,
	[lasttitle] [nchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lastpost] [datetime] NOT NULL ,
	[lastposterid] [int] NOT NULL ,
	[lastposter] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[allowsmilies] [int] NOT NULL ,
	[allowrss] [int] NOT NULL ,
	[allowhtml] [int] NOT NULL ,
	[allowbbcode] [int] NOT NULL ,
	[allowimgcode] [int] NOT NULL ,
	[allowblog] [int] NOT NULL ,
	[allowtrade] [int] NOT NULL ,
	[alloweditrules] [int] NOT NULL ,
	[recyclebin] [int] NOT NULL ,
	[modnewposts] [int] NOT NULL ,
	[jammer] [int] NOT NULL ,
	[disablewatermark] [int] NOT NULL ,
	[inheritedmod] [int] NOT NULL ,
	[autoclose] [smallint] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_medals] (
	[medalid] [smallint] NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[available] [int] NOT NULL ,
	[image] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_medalslog] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[adminname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[adminid] [int] NULL ,
	[ip] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[postdatetime] [datetime] NULL ,
	[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[uid] [int] NULL ,
	[actions] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[medals] [int] NULL ,
	[reason] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]

;

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]

;

CREATE TABLE [dnt_moderators] (
	[uid] [int] NOT NULL ,
	[fid] [smallint] NOT NULL ,
	[displayorder] [smallint] NOT NULL ,
	[inherited] [smallint] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_onlinelist] (
	[groupid] [smallint] NOT NULL ,
	[displayorder] [int] NULL ,
	[title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[img] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_paymentlog] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NOT NULL ,
	[tid] [int] NOT NULL ,
	[authorid] [int] NOT NULL ,
	[buydate] [datetime] NOT NULL ,
	[amount] [smallint] NOT NULL ,
	[netamount] [smallint] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_pms] (
	[pmid] [int] IDENTITY (1, 1) NOT NULL ,
	[msgfrom] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[msgfromid] [int] NOT NULL ,
	[msgto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[msgtoid] [int] NOT NULL ,
	[folder] [smallint] NOT NULL ,
	[new] [int] NOT NULL ,
	[subject] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[message] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;

CREATE TABLE [dnt_polls] (
	[tid] [int] NOT NULL ,
	[polltype] [tinyint] NOT NULL ,
	[itemcount] [smallint] NOT NULL ,
	[itemnamelist] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[itemvaluelist] [text] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[usernamelist] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[enddatetime] [datetime] NOT NULL ,
	[userid] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;

CREATE TABLE [dnt_postid] (
	[pid] [int] IDENTITY (1, 1) NOT NULL ,
	[postdatetime] [datetime] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_posts1] (
	[pid] [int] NOT NULL ,
	[fid] [int] NOT NULL ,
	[tid] [int] NOT NULL ,
	[parentid] [int] NOT NULL ,
	[layer] [int] NOT NULL ,
	[poster] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[posterid] [int] NOT NULL ,
	[title] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[postdatetime] [smalldatetime] NOT NULL ,
	[message] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ip] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lastedit] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[invisible] [int] NOT NULL ,
	[usesig] [int] NOT NULL ,
	[htmlon] [int] NOT NULL ,
	[smileyoff] [int] NOT NULL ,
	[parseurloff] [int] NOT NULL ,
	[bbcodeoff] [int] NOT NULL ,
	[attachment] [int] NOT NULL ,
	[rate] [int] NOT NULL ,
	[ratetimes] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;

CREATE TABLE [dnt_ratelog] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[pid] [int] NOT NULL ,
	[uid] [int] NOT NULL ,
	[username] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[extcredits] [tinyint] NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[score] [smallint] NOT NULL ,
	[reason] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_searchcaches] (
	[searchid] [int] IDENTITY (1, 1) NOT NULL ,
	[keywords] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[searchstring] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ip] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[uid] [int] NOT NULL ,
	[groupid] [int] NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[expiration] [datetime] NOT NULL ,
	[topics] [int] NOT NULL ,
	[tids] [text] COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;

CREATE TABLE [dnt_smilies] (
	[id] [smallint] NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[type] [smallint] NOT NULL ,
	[code] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[url] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_statistics] (
	[totaltopic] [int] NOT NULL ,
	[totalpost] [int] NOT NULL ,
	[totalusers] [int] NOT NULL ,
	[lastusername] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lastuserid] [int] NOT NULL ,
	[highestonlineusercount] [int] NULL ,
	[highestonlineusertime] [smalldatetime] NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_tablelist] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[createdatetime] [datetime] NOT NULL ,
	[description] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mintid] [int] NOT NULL ,
	[maxtid] [int] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_templates] (
	[templateid] [smallint] IDENTITY (1, 1) NOT NULL ,
	[directory] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[author] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[createdate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ver] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[fordntver] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[copyright] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_topics] (
	[tid] [int] IDENTITY (1, 1) NOT NULL ,
	[fid] [smallint] NOT NULL ,
	[iconid] [tinyint] NOT NULL ,
	[typeid] [tinyint] NOT NULL ,
	[readperm] [int] NOT NULL ,
	[price] [smallint] NOT NULL ,
	[poster] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[posterid] [int] NOT NULL ,
	[title] [nchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[lastpost] [datetime] NOT NULL ,
	[lastpostid] [int] NOT NULL ,
	[lastposter] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lastposterid] [int] NOT NULL ,
	[views] [int] NOT NULL ,
	[replies] [int] NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[highlight] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[digest] [tinyint] NOT NULL ,
	[rate] [tinyint] NOT NULL ,
	[hide] [int] NOT NULL ,
	[poll] [int] NOT NULL ,
	[attachment] [int] NOT NULL ,
	[moderated] [tinyint] NOT NULL ,
	[closed] [int] NOT NULL ,
	[magic] [int] NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_userfields] (
	[uid] [int] NOT NULL ,
	[website] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[icq] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[qq] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yahoo] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[msn] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[skype] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[location] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[customstatus] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[avatar] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[avatarwidth] [int] NOT NULL ,
	[avatarheight] [int] NOT NULL ,
	[medals] [varchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bio] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[signature] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sightml] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[authstr] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[authtime] [smalldatetime] NOT NULL ,
	[authflag] [tinyint] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

;

CREATE TABLE [dnt_usergroups] (
	[groupid] [smallint] IDENTITY (1, 1) NOT NULL ,
	[radminid] [int] NOT NULL ,
	[type] [smallint] NULL ,
	[system] [smallint] NOT NULL ,
	[grouptitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[creditshigher] [int] NOT NULL ,
	[creditslower] [int] NOT NULL ,
	[stars] [int] NOT NULL ,
	[color] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[groupavatar] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[readaccess] [int] NOT NULL ,
	[allowvisit] [int] NOT NULL ,
	[allowpost] [int] NOT NULL ,
	[allowreply] [int] NOT NULL ,
	[allowpostpoll] [int] NOT NULL ,
	[allowdirectpost] [int] NOT NULL ,
	[allowgetattach] [int] NOT NULL ,
	[allowpostattach] [int] NOT NULL ,
	[allowvote] [int] NOT NULL ,
	[allowmultigroups] [int] NOT NULL ,
	[allowsearch] [int] NOT NULL ,
	[allowavatar] [int] NOT NULL ,
	[allowcstatus] [int] NOT NULL ,
	[allowuseblog] [int] NOT NULL ,
	[allowinvisible] [int] NOT NULL ,
	[allowtransfer] [int] NOT NULL ,
	[allowsetreadperm] [int] NOT NULL ,
	[allowsetattachperm] [int] NOT NULL ,
	[allowhidecode] [int] NOT NULL ,
	[allowhtml] [int] NOT NULL ,
	[allowcusbbcode] [int] NOT NULL ,
	[allownickname] [int] NOT NULL ,
	[allowsigbbcode] [int] NOT NULL ,
	[allowsigimgcode] [int] NOT NULL ,
	[allowviewpro] [int] NOT NULL ,
	[allowviewstats] [int] NOT NULL ,
	[disableperiodctrl] [int] NOT NULL ,
	[reasonpm] [int] NOT NULL ,
	[maxprice] [smallint] NOT NULL ,
	[maxpmnum] [smallint] NOT NULL ,
	[maxsigsize] [smallint] NOT NULL ,
	[maxattachsize] [int] NOT NULL ,
	[maxsizeperday] [int] NOT NULL ,
	[attachextensions] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[raterange] [char] (500) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]

;

CREATE TABLE [dnt_users] (
	[uid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[nickname] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[password] [char] (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[secques] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[gender] [int] NOT NULL ,
	[adminid] [int] NOT NULL ,
	[groupid] [smallint] NOT NULL ,
	[groupexpiry] [int] NOT NULL ,
	[extgroupids] [char] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[regip] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[joindate] [smalldatetime] NOT NULL ,
	[lastip] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lastvisit] [datetime] NOT NULL ,
	[lastactivity] [datetime] NOT NULL ,
	[lastpost] [datetime] NOT NULL ,
	[lastpostid] [int] NOT NULL ,
	[lastposttitle] [nchar] (80) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[posts] [int] NOT NULL ,
	[digestposts] [smallint] NOT NULL ,
	[oltime] [int] NOT NULL ,
	[pageviews] [int] NOT NULL ,
	[credits] [decimal](10, 0) NOT NULL ,
	[extcredits1] [decimal](18, 2) NOT NULL ,
	[extcredits2] [decimal](18, 2) NOT NULL ,
	[extcredits3] [decimal](18, 2) NOT NULL ,
	[extcredits4] [decimal](18, 2) NOT NULL ,
	[extcredits5] [decimal](18, 2) NOT NULL ,
	[extcredits6] [decimal](18, 2) NOT NULL ,
	[extcredits7] [decimal](18, 2) NOT NULL ,
	[extcredits8] [decimal](18, 2) NOT NULL ,
	[avatarshowid] [int] NOT NULL ,
	[email] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bday] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sigstatus] [int] NOT NULL ,
	[tpp] [int] NOT NULL ,
	[ppp] [int] NOT NULL ,
	[templateid] [smallint] NOT NULL ,
	[pmsound] [int] NOT NULL ,
	[showemail] [int] NOT NULL ,
	[newsletter] [int] NOT NULL ,
	[invisible] [int] NOT NULL ,
	[newpm] [int] NOT NULL ,
	[newpmcount] [int] NOT NULL ,
	[accessmasks] [int] NOT NULL ,
	[onlinestate] [int] NOT NULL 
) ON [PRIMARY]
;



CREATE TABLE [dnt_words] (
	[id] [smallint] IDENTITY (1, 1) NOT NULL ,
	[admin] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[find] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[replacement] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]

;

ALTER TABLE [dnt_announcements] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_announcements] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_attachments] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_attachments] PRIMARY KEY  CLUSTERED 
	(
		[aid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_bbcodes] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_bbcodes] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_creditslog] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_creditslog] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_forums] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_forums] PRIMARY KEY  CLUSTERED 
	(
		[fid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_paymentlog] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_paymentlog] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_pms] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_pms] PRIMARY KEY  CLUSTERED 
	(
		[pmid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_polls] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_polls] PRIMARY KEY  CLUSTERED 
	(
		[tid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_postid] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_postid] PRIMARY KEY  CLUSTERED 
	(
		[pid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_posts1] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_posts1] PRIMARY KEY  CLUSTERED 
	(
		[pid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_ratelog] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_ratelog] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_searchcaches] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_searchindex] PRIMARY KEY  CLUSTERED 
	(
		[searchid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_tablelist] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_tablelist] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_templates] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_templates] PRIMARY KEY  CLUSTERED 
	(
		[templateid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_userfields] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_userfields] PRIMARY KEY  CLUSTERED 
	(
		[uid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_usergroups] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_usergroups] PRIMARY KEY  CLUSTERED 
	(
		[groupid]
	)  ON [PRIMARY] 

;

ALTER TABLE [dnt_users] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_members] PRIMARY KEY  CLUSTERED 
	(
		[uid]
	)  ON [PRIMARY] 

;

CREATE  UNIQUE  CLUSTERED  INDEX [list] ON [dnt_topics]([fid], [displayorder], [lastpostid] DESC ) ON [PRIMARY]

;

ALTER TABLE [dnt_adminvisitlog] ADD 
	CONSTRAINT [DF_dnt_adminvisitlog_postdatetime] DEFAULT (getdate()) FOR [postdatetime]

;

ALTER TABLE [dnt_attachments] ADD 
	CONSTRAINT [DF_dnt_attachments_uid] DEFAULT (0) FOR [uid]

;

 CREATE  INDEX [tid] ON [dnt_attachments]([tid]) ON [PRIMARY]

;

 CREATE  INDEX [pid] ON [dnt_attachments]([pid]) ON [PRIMARY]

;



ALTER TABLE [dnt_forums] ADD 
	CONSTRAINT [DF__dnt_forum__paren__377B294A] DEFAULT ('0') FOR [parentid],
	CONSTRAINT [DF__dnt_forum__layer__386F4D83] DEFAULT ('0') FOR [layer],
	CONSTRAINT [DF__dnt_forum__pathl__396371BC] DEFAULT ('') FOR [pathlist],
	CONSTRAINT [DF__dnt_forum__subfo__3A5795F5] DEFAULT ('') FOR [subforumcount],
	CONSTRAINT [DF__dnt_forum__statu__3B4BBA2E] DEFAULT ('0') FOR [status],
	CONSTRAINT [DF__dnt_forum__displ__3C3FDE67] DEFAULT ('0') FOR [displayorder],
	CONSTRAINT [DF__dnt_forum__style__3D3402A0] DEFAULT ('0') FOR [templateid],
	CONSTRAINT [DF__dnt_forum__topic__3E2826D9] DEFAULT ('0') FOR [topics],
	CONSTRAINT [DF_dnt_forums_curtopics] DEFAULT (0) FOR [curtopics],
	CONSTRAINT [DF__dnt_forum__posts__3F1C4B12] DEFAULT ('0') FOR [posts],
	CONSTRAINT [DF__dnt_forum__today__40106F4B] DEFAULT ('0') FOR [todayposts],
	CONSTRAINT [DF__dnt_forum__lastt__41049384] DEFAULT ('0') FOR [lasttid],
	CONSTRAINT [DF__dnt_forum__lastt__41F8B7BD] DEFAULT ('') FOR [lasttitle],
	CONSTRAINT [DF__dnt_forum__lastp__42ECDBF6] DEFAULT ('') FOR [lastpost],
	CONSTRAINT [DF__dnt_forum__lastp__43E1002F] DEFAULT ('') FOR [lastposterid],
	CONSTRAINT [DF__dnt_forum__lastp__44D52468] DEFAULT ('') FOR [lastposter],
	CONSTRAINT [DF__dnt_forum__allow__45C948A1] DEFAULT ('0') FOR [allowsmilies],
	CONSTRAINT [DF__dnt_forum__allow__46BD6CDA] DEFAULT ('0') FOR [allowrss],
	CONSTRAINT [DF__dnt_forum__allow__47B19113] DEFAULT ('0') FOR [allowhtml],
	CONSTRAINT [DF__dnt_forum__allow__48A5B54C] DEFAULT ('0') FOR [allowbbcode],
	CONSTRAINT [DF__dnt_forum__allow__4999D985] DEFAULT ('0') FOR [allowimgcode],
	CONSTRAINT [DF__dnt_forum__allow__4A8DFDBE] DEFAULT ('0') FOR [allowblog],
	CONSTRAINT [DF__dnt_forum__allow__4B8221F7] DEFAULT ('0') FOR [allowtrade],
	CONSTRAINT [DF__dnt_forum__allow__4C764630] DEFAULT ('0') FOR [alloweditrules],
	CONSTRAINT [DF__dnt_forum__recyc__4D6A6A69] DEFAULT ('0') FOR [recyclebin],
	CONSTRAINT [DF__dnt_forum__modne__4E5E8EA2] DEFAULT ('0') FOR [modnewposts],
	CONSTRAINT [DF__dnt_forum__jamme__4F52B2DB] DEFAULT ('0') FOR [jammer],
	CONSTRAINT [DF__dnt_forum__disab__5046D714] DEFAULT ('0') FOR [disablewatermark],
	CONSTRAINT [DF__dnt_forum__inher__513AFB4D] DEFAULT ('0') FOR [inheritedmod],
	CONSTRAINT [DF__dnt_forum__autoc__522F1F86] DEFAULT ('0') FOR [autoclose],
	CONSTRAINT [DF_dnt_forums_colcount] DEFAULT (1) FOR [colcount]
;

ALTER TABLE [dnt_medals] ADD 
	CONSTRAINT [DF_dnt_medals_available] DEFAULT (0) FOR [available],
	CONSTRAINT [DF_dnt_medals_image] DEFAULT ('') FOR [image]

;

ALTER TABLE [dnt_medalslog] ADD 
	CONSTRAINT [DF_dnt_medalslog_postdatetime] DEFAULT (getdate()) FOR [postdatetime]

;

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

;

ALTER TABLE [dnt_paymentlog] ADD 
	CONSTRAINT [DF_dnt_paymentlog_buydate] DEFAULT (getdate()) FOR [buydate]

;

ALTER TABLE [dnt_posts1] ADD 
	CONSTRAINT [DF_dnt_posts1_pid] DEFAULT (0) FOR [pid],
	CONSTRAINT [DF_dnt_posts1_parentid] DEFAULT (0) FOR [parentid],
	CONSTRAINT [DF_dnt_posts1_layer] DEFAULT (0) FOR [layer],
	CONSTRAINT [DF_dnt_posts1_poster] DEFAULT ('') FOR [poster],
	CONSTRAINT [DF_dnt_posts1_posterid] DEFAULT (0) FOR [posterid],
	CONSTRAINT [DF_dnt_posts1_postdatetime] DEFAULT (getdate()) FOR [postdatetime],
	CONSTRAINT [DF_dnt_posts1_message] DEFAULT ('') FOR [message],
	CONSTRAINT [DF_dnt_posts1_ip] DEFAULT ('') FOR [ip],
	CONSTRAINT [DF_dnt_posts1_lastedit] DEFAULT ('') FOR [lastedit],
	CONSTRAINT [DF_dnt_posts1_invisible] DEFAULT (0) FOR [invisible],
	CONSTRAINT [DF_dnt_posts1_usesig] DEFAULT (0) FOR [usesig],
	CONSTRAINT [DF_dnt_posts1_htmlon] DEFAULT (0) FOR [htmlon],
	CONSTRAINT [DF_dnt_posts1_smileyoff] DEFAULT (0) FOR [smileyoff],
	CONSTRAINT [DF_dnt_posts1_parseurloff] DEFAULT (0) FOR [parseurloff],
	CONSTRAINT [DF_dnt_posts1_bbcodeoff] DEFAULT (0) FOR [bbcodeoff],
	CONSTRAINT [DF_dnt_posts1_attachment] DEFAULT (0) FOR [attachment],
	CONSTRAINT [DF_dnt_posts1_rate] DEFAULT (0) FOR [rate],
	CONSTRAINT [DF_dnt_posts1_ratetimes] DEFAULT (0) FOR [ratetimes]

;

 CREATE  INDEX [parentid] ON [dnt_posts1]([parentid]) ON [PRIMARY]

;

 CREATE  UNIQUE  INDEX [showtopic] ON [dnt_posts1]([tid], [invisible], [pid]) ON [PRIMARY]

;

 CREATE  INDEX [treelist] ON [dnt_posts1]([tid], [invisible], [parentid]) ON [PRIMARY]

;

ALTER TABLE [dnt_ratelog] ADD 
	CONSTRAINT [DF_dnt_ratelog_postdatetime] DEFAULT (getdate()) FOR [postdatetime]

;

 CREATE  INDEX [getsearchid] ON [dnt_searchcaches]([searchstring], [groupid]) ON [PRIMARY]

;

ALTER TABLE [dnt_tablelist] ADD 
	CONSTRAINT [DF_dnt_tablelist_createdatetime] DEFAULT (getdate()) FOR [createdatetime],
	CONSTRAINT [DF_dnt_tablelist_description] DEFAULT ('') FOR [description],
	CONSTRAINT [DF_dnt_tablelist_mintid] DEFAULT ((-1)) FOR [mintid],
	CONSTRAINT [DF_dnt_tablelist_maxtid] DEFAULT ((-1)) FOR [maxtid]

;

ALTER TABLE [dnt_topics] ADD 
	CONSTRAINT [DF_dnt_topics_iconid] DEFAULT (0) FOR [iconid],
	CONSTRAINT [DF_dnt_topics_typeid] DEFAULT (0) FOR [typeid],
	CONSTRAINT [DF_dnt_topics_readperm] DEFAULT (0) FOR [readperm],
	CONSTRAINT [DF_dnt_topics_price] DEFAULT (0) FOR [price],
	CONSTRAINT [DF_dnt_topics_poster] DEFAULT ('') FOR [poster],
	CONSTRAINT [DF_dnt_topics_posterid] DEFAULT (0) FOR [posterid],
	CONSTRAINT [DF_dnt_topics_postdatetime] DEFAULT (getdate()) FOR [postdatetime],
	CONSTRAINT [DF_dnt_topics_lastpost] DEFAULT (getdate()) FOR [lastpost],
	CONSTRAINT [DF__dnt_topic__lastp__6FBF826D] DEFAULT (0) FOR [lastpostid],
	CONSTRAINT [DF_dnt_topics_lastposter] DEFAULT ('') FOR [lastposter],
	CONSTRAINT [DF__dnt_topic__lastp__70B3A6A6] DEFAULT (0) FOR [lastposterid],
	CONSTRAINT [DF_dnt_topics_views] DEFAULT (0) FOR [views],
	CONSTRAINT [DF_dnt_topics_replies] DEFAULT (0) FOR [replies],
	CONSTRAINT [DF_dnt_topics_displayorder] DEFAULT (0) FOR [displayorder],
	CONSTRAINT [DF_dnt_topics_highlight] DEFAULT ('') FOR [highlight],
	CONSTRAINT [DF_dnt_topics_digest] DEFAULT (0) FOR [digest],
	CONSTRAINT [DF_dnt_topics_rate] DEFAULT (0) FOR [rate],
	CONSTRAINT [DF_dnt_topics_blog] DEFAULT (0) FOR [hide],
	CONSTRAINT [DF_dnt_topics_poll] DEFAULT (0) FOR [poll],
	CONSTRAINT [DF_dnt_topics_attachment] DEFAULT (0) FOR [attachment],
	CONSTRAINT [DF_dnt_topics_moderated] DEFAULT (0) FOR [moderated],
	CONSTRAINT [DF_dnt_topics_closed] DEFAULT (0) FOR [closed],
	CONSTRAINT [DF_dnt_topics_magic] DEFAULT (0) FOR [magic],
	CONSTRAINT [PK_dnt_topics] PRIMARY KEY  NONCLUSTERED 
	(
		[tid]
	)  ON [PRIMARY] 

;

 CREATE  INDEX [displayorder] ON [dnt_topics]([displayorder]) ON [PRIMARY]

;

 CREATE  INDEX [fid] ON [dnt_topics]([fid]) ON [PRIMARY]

;

 CREATE  INDEX [list_date] ON [dnt_topics]([fid], [displayorder], [postdatetime], [lastpostid] DESC ) ON [PRIMARY]

;

 CREATE  INDEX [list_tid] ON [dnt_topics]([fid], [displayorder], [tid]) ON [PRIMARY]

;

 CREATE  INDEX [list_replies] ON [dnt_topics]([fid], [displayorder], [postdatetime], [replies]) ON [PRIMARY]

;

 CREATE  INDEX [list_views] ON [dnt_topics]([fid], [displayorder], [postdatetime], [views]) ON [PRIMARY]

;

 CREATE  INDEX [displayorder_fid] ON [dnt_topics]([displayorder], [fid]) ON [PRIMARY]

;

 CREATE  INDEX [fid_displayorder] ON [dnt_topics]([fid], [displayorder]) ON [PRIMARY]

;

 CREATE  INDEX [tid] ON [dnt_topics]([tid] DESC ) ON [PRIMARY]

;

ALTER TABLE [dnt_userfields] ADD 
	CONSTRAINT [DF__dnt_userf__websi__729BEF18] DEFAULT ('') FOR [website],
	CONSTRAINT [DF__dnt_userfie__icq__73901351] DEFAULT ('') FOR [icq],
	CONSTRAINT [DF__dnt_userfiel__qq__7484378A] DEFAULT ('') FOR [qq],
	CONSTRAINT [DF__dnt_userf__yahoo__75785BC3] DEFAULT ('') FOR [yahoo],
	CONSTRAINT [DF__dnt_userfie__msn__766C7FFC] DEFAULT ('') FOR [msn],
	CONSTRAINT [DF__dnt_userf__skype__7760A435] DEFAULT ('') FOR [skype],
	CONSTRAINT [DF__dnt_userf__locat__7854C86E] DEFAULT ('') FOR [location],
	CONSTRAINT [DF__dnt_userf__custo__7948ECA7] DEFAULT ('') FOR [customstatus],
	CONSTRAINT [DF__dnt_userf__avata__7A3D10E0] DEFAULT ('avatars\common\0.gif') FOR [avatar],
	CONSTRAINT [DF__dnt_userf__avata__7B313519] DEFAULT (60) FOR [avatarwidth],
	CONSTRAINT [DF__dnt_userf__avata__7C255952] DEFAULT (60) FOR [avatarheight],
	CONSTRAINT [DF_dnt_userfields_medals] DEFAULT ('') FOR [medals],
	CONSTRAINT [DF__dnt_userfie__bio__7D197D8B] DEFAULT ('') FOR [bio],
	CONSTRAINT [DF__dnt_userf__signa__7E0DA1C4] DEFAULT ('') FOR [signature],
	CONSTRAINT [DF_dnt_userfields_signahtml] DEFAULT ('') FOR [sightml],
	CONSTRAINT [DF__dnt_userf__auths__7F01C5FD] DEFAULT ('') FOR [authstr],
	CONSTRAINT [DF_dnt_userfields_authtime] DEFAULT (getdate()) FOR [authtime],
	CONSTRAINT [DF_dnt_userfields_authflag] DEFAULT (0) FOR [authflag]

;

ALTER TABLE [dnt_usergroups] ADD 
	CONSTRAINT [DF_dnt_usergroups_type] DEFAULT (0) FOR [type],
	CONSTRAINT [DF_dnt_usergroups_system] DEFAULT ('0') FOR [system]

;

ALTER TABLE [dnt_users] ADD 
	CONSTRAINT [DF__dnt_users__usern__03C67B1A] DEFAULT ('') FOR [username],
	CONSTRAINT [DF_dnt_users_nickname] DEFAULT ('') FOR [nickname],
	CONSTRAINT [DF__dnt_users__passw__04BA9F53] DEFAULT ('') FOR [password],
	CONSTRAINT [DF__dnt_users__secqu__05AEC38C] DEFAULT ('') FOR [secques],
	CONSTRAINT [DF__dnt_users__gende__06A2E7C5] DEFAULT (0) FOR [gender],
	CONSTRAINT [DF__dnt_users__admin__07970BFE] DEFAULT (0) FOR [adminid],
	CONSTRAINT [DF__dnt_users__group__088B3037] DEFAULT (0) FOR [groupid],
	CONSTRAINT [DF__dnt_users__group__097F5470] DEFAULT (0) FOR [groupexpiry],
	CONSTRAINT [DF__dnt_users__extgr__0A7378A9] DEFAULT ('') FOR [extgroupids],
	CONSTRAINT [DF__dnt_users__regip__0B679CE2] DEFAULT ('') FOR [regip],
	CONSTRAINT [DF__dnt_users__joind__0C5BC11B] DEFAULT (getdate()) FOR [joindate],
	CONSTRAINT [DF__dnt_users__lasti__0D4FE554] DEFAULT ('') FOR [lastip],
	CONSTRAINT [DF__dnt_users__lastv__0E44098D] DEFAULT (getdate()) FOR [lastvisit],
	CONSTRAINT [DF__dnt_users__lasta__0F382DC6] DEFAULT (getdate()) FOR [lastactivity],
	CONSTRAINT [DF__dnt_users__lastp__102C51FF] DEFAULT (getdate()) FOR [lastpost],
	CONSTRAINT [DF__dnt_users__lastp__11207638] DEFAULT (0) FOR [lastpostid],
	CONSTRAINT [DF__dnt_users__lastp__12149A71] DEFAULT ('') FOR [lastposttitle],
	CONSTRAINT [DF__dnt_users__posts__1308BEAA] DEFAULT ('0') FOR [posts],
	CONSTRAINT [DF__dnt_users__diges__13FCE2E3] DEFAULT ('0') FOR [digestposts],
	CONSTRAINT [DF__dnt_users__oltim__14F1071C] DEFAULT ('0') FOR [oltime],
	CONSTRAINT [DF__dnt_users__pagev__15E52B55] DEFAULT ('0') FOR [pageviews],
	CONSTRAINT [DF__dnt_users__credi__16D94F8E] DEFAULT ('0') FOR [credits],
	CONSTRAINT [DF__dnt_users__extcr__17CD73C7] DEFAULT ('0') FOR [extcredits1],
	CONSTRAINT [DF__dnt_users__extcr__18C19800] DEFAULT ('0') FOR [extcredits2],
	CONSTRAINT [DF__dnt_users__extcr__19B5BC39] DEFAULT ('0') FOR [extcredits3],
	CONSTRAINT [DF__dnt_users__extcr__1AA9E072] DEFAULT ('0') FOR [extcredits4],
	CONSTRAINT [DF__dnt_users__extcr__1B9E04AB] DEFAULT ('0') FOR [extcredits5],
	CONSTRAINT [DF__dnt_users__extcr__1C9228E4] DEFAULT ('0') FOR [extcredits6],
	CONSTRAINT [DF__dnt_users__extcr__1D864D1D] DEFAULT ('0') FOR [extcredits7],
	CONSTRAINT [DF__dnt_users__extcr__1E7A7156] DEFAULT ('0') FOR [extcredits8],
	CONSTRAINT [DF__dnt_users__avata__1F6E958F] DEFAULT ('0') FOR [avatarshowid],
	CONSTRAINT [DF__dnt_users__email__2062B9C8] DEFAULT ('') FOR [email],
	CONSTRAINT [DF__dnt_users__bday__2156DE01] DEFAULT ('') FOR [bday],
	CONSTRAINT [DF__dnt_users__sigst__224B023A] DEFAULT ('0') FOR [sigstatus],
	CONSTRAINT [DF__dnt_users__tpp__233F2673] DEFAULT ('0') FOR [tpp],
	CONSTRAINT [DF__dnt_users__ppp__24334AAC] DEFAULT ('0') FOR [ppp],
	CONSTRAINT [DF__dnt_users__style__25276EE5] DEFAULT ('0') FOR [templateid],
	CONSTRAINT [DF__dnt_users__pmsou__261B931E] DEFAULT ('0') FOR [pmsound],
	CONSTRAINT [DF__dnt_users__showe__270FB757] DEFAULT ('0') FOR [showemail],
	CONSTRAINT [DF__dnt_users__newsl__2803DB90] DEFAULT ('0') FOR [newsletter],
	CONSTRAINT [DF__dnt_users__invis__28F7FFC9] DEFAULT ('0') FOR [invisible],
	CONSTRAINT [DF__dnt_users__newpm__29EC2402] DEFAULT ('0') FOR [newpm],
	CONSTRAINT [DF_dnt_users_newpmcount] DEFAULT (0) FOR [newpmcount],
	CONSTRAINT [DF__dnt_users__acces__2AE0483B] DEFAULT ('0') FOR [accessmasks],
	CONSTRAINT [DF__dnt_users__onlin__2BD46C74] DEFAULT (0) FOR [onlinestate]

;


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

 CREATE  INDEX [forum] ON [dnt_online]([userid], [forumid], [invisible]) ON [PRIMARY]
;

 CREATE  INDEX [invisible] ON [dnt_online]([userid], [invisible]) ON [PRIMARY]
;

 CREATE  INDEX [forumid] ON [dnt_online]([forumid]) ON [PRIMARY]
;

 CREATE  INDEX [password] ON [dnt_online]([userid], [password]) ON [PRIMARY]
;

CREATE  INDEX [pwsecques] ON [dnt_users]([username], [password], [secques]) ON [PRIMARY]

;

CREATE  INDEX [emailsecques] ON [dnt_users]([username], [email], [secques]) ON [PRIMARY]

;

CREATE  INDEX [password] ON [dnt_users]([username], [password]) ON [PRIMARY]

;

CREATE  INDEX [username] ON [dnt_users]([username]) ON [PRIMARY]


;

CREATE TABLE [dnt_failedlogins] (
	[ip] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[errcount] [smallint] NOT NULL ,
	[lastupdate] [smalldatetime] NOT NULL 
) ON [PRIMARY]
;

ALTER TABLE [dnt_failedlogins] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_failedlogins] PRIMARY KEY  CLUSTERED 
	(
		[ip]
	)  ON [PRIMARY] 
;

ALTER TABLE [dnt_failedlogins] ADD 
	CONSTRAINT [DF_dnt_failedlogins_errcount] DEFAULT (0) FOR [errcount],
	CONSTRAINT [DF_dnt_failedlogins_lastupdate] DEFAULT (getdate()) FOR [lastupdate]

;