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 ,
	[allowviewrealname] [tinyint] NOT NULL 
) ON [PRIMARY]
GO

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

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

CREATE TABLE [dnt_albumcategories] (
	[albumcateid] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nchar] (50)  NOT NULL ,
	[description] [nchar] (300)  NULL ,
	[albumcount] [int] NOT NULL ,
	[displayorder] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_albums] (
	[albumid] [int] IDENTITY (1, 1) NOT NULL ,
	[albumcateid] [int] NOT NULL ,
	[userid] [int] NOT NULL ,
	[username] [nchar] (20)  NOT NULL ,
	[title] [nchar] (50)  NOT NULL ,
	[description] [nchar] (200)  NOT NULL ,
	[logo] [nchar] (255)  NOT NULL ,
	[password] [nchar] (50)  NOT NULL ,
	[imgcount] [int] NOT NULL ,
	[views] [int] NOT NULL ,
	[type] [int] NOT NULL ,
	[createdatetime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

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

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)  NOT NULL ,
	[description] [nchar] (100)  NOT NULL ,
	[filetype] [nchar] (50)  NOT NULL ,
	[filesize] [int] NOT NULL ,
	[attachment] [nchar] (100)  NOT NULL ,
	[downloads] [int] NOT NULL 
) ON [PRIMARY]
GO

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

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

CREATE TABLE [dnt_creditslog] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NOT NULL ,
	[fromto] [int] 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]
GO

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

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

CREATE TABLE [dnt_forumfields] (
	[fid] [smallint] NOT NULL ,
	[password] [nvarchar] (16)  NOT NULL ,
	[icon] [varchar] (255)  NULL ,
	[postcredits] [varchar] (255)  NULL ,
	[replycredits] [varchar] (255)  NULL ,
	[redirect] [varchar] (255)  NULL ,
	[attachextensions] [varchar] (255)  NULL ,
	[rules] [text]  NULL ,
	[topictypes] [text]  NULL ,
	[viewperm] [text]  NULL ,
	[postperm] [text]  NULL ,
	[replyperm] [text]  NULL ,
	[getattachperm] [text]  NULL ,
	[postattachperm] [text]  NULL ,
	[moderators] [ntext]  NULL ,
	[description] [ntext]  NULL ,
	[applytopictype] [tinyint] NOT NULL ,
	[postbytopictype] [tinyint] NOT NULL ,
	[viewbytopictype] [tinyint] NOT NULL ,
	[topictypeprefix] [tinyint] NOT NULL ,
	[permuserlist] [ntext]  NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

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

CREATE TABLE [dnt_forums] (
	[fid] [int] IDENTITY (1, 1) NOT NULL ,
	[parentid] [smallint] NOT NULL ,
	[layer] [smallint] NOT NULL ,
	[pathlist] [nchar] (3000)  NOT NULL ,
	[parentidlist] [char] (300)  NOT NULL ,
	[subforumcount] [int] NOT NULL ,
	[name] [nchar] (50)  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] (60)  NOT NULL ,
	[lastpost] [datetime] NOT NULL ,
	[lastposterid] [int] NOT NULL ,
	[lastposter] [nchar] (20)  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 ,
	[allowthumbnail] [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]
GO

CREATE TABLE [dnt_help] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nvarchar] (100)  NOT NULL ,
	[message] [ntext]  NULL ,
	[pid] [int] NOT NULL ,
	[orderby] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

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

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

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

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

CREATE TABLE [dnt_myposts] (
	[uid] [int] NOT NULL ,
	[tid] [int] NOT NULL ,
	[pid] [int] NOT NULL ,
	[dateline] [smalldatetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_mytopics] (
	[uid] [int] NOT NULL ,
	[tid] [int] NOT NULL ,
	[dateline] [smalldatetime] NOT NULL 
) ON [PRIMARY]
GO

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

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

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

CREATE TABLE [dnt_photocomments] (
	[commentid] [int] IDENTITY (1, 1) NOT NULL ,
	[photoid] [int] NOT NULL ,
	[username] [nvarchar] (20)  NOT NULL ,
	[userid] [int] NOT NULL ,
	[ip] [varchar] (100)  NOT NULL ,
	[postdatetime] [smalldatetime] NOT NULL ,
	[content] [nvarchar] (2000)  NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_photos] (
	[photoid] [int] IDENTITY (1, 1) NOT NULL ,
	[filename] [char] (255)  NOT NULL ,
	[attachment] [nchar] (255)  NOT NULL ,
	[filesize] [int] NOT NULL ,
	[title] [nchar] (20)  NOT NULL ,
	[description] [nchar] (200)  NOT NULL ,
	[postdate] [datetime] NOT NULL ,
	[albumid] [int] NOT NULL ,
	[userid] [int] NOT NULL ,
	[username] [nchar] (20)  NOT NULL ,
	[views] [int] NOT NULL ,
	[commentstatus] [tinyint] NOT NULL ,
	[tagstatus] [tinyint] NOT NULL ,
	[comments] [int] NOT NULL ,
	[isattachment] [int] NOT NULL , 
	[width] [int] NULL ,
	[height] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_phototags] (
	[tagid] [int] NOT NULL ,
	[photoid] [int] NOT NULL 
) ON [PRIMARY]
GO

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

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

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

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)  NOT NULL ,
	[posterid] [int] NOT NULL ,
	[title] [nvarchar] (60)  NOT NULL ,
	[postdatetime] [smalldatetime] NOT NULL ,
	[message] [ntext]  NOT NULL ,
	[ip] [nvarchar] (15)  NOT NULL ,
	[lastedit] [nvarchar] (50)  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]
GO


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

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

CREATE TABLE [dnt_smilies] (
	[id] [int] NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[type] [int] NOT NULL ,
	[code] [nvarchar] (30)  NOT NULL ,
	[url] [varchar] (60)  NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spaceattachments] (
	[aid] [int] IDENTITY (1, 1) NOT NULL ,
	[uid] [int] NOT NULL ,
	[spacepostid] [int] NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[filename] [nchar] (100)  NOT NULL ,
	[filetype] [nchar] (50)  NOT NULL ,
	[filesize] [int] NOT NULL ,
	[attachment] [nchar] (100)  NOT NULL ,
	[downloads] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacecategories] (
	[categoryid] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nvarchar] (50)  NOT NULL ,
	[uid] [int] NOT NULL ,
	[description] [nvarchar] (1000)  NOT NULL ,
	[typeid] [int] NOT NULL ,
	[categorycount] [int] NOT NULL ,
	[displayorder] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacecomments] (
	[commentid] [int] IDENTITY (1, 1) NOT NULL ,
	[postid] [int] NOT NULL ,
	[author] [nvarchar] (50)  NOT NULL ,
	[email] [nvarchar] (100)  NOT NULL ,
	[url] [nvarchar] (255)  NOT NULL ,
	[ip] [varchar] (100)  NOT NULL ,
	[postdatetime] [smalldatetime] NOT NULL ,
	[content] [nvarchar] (2000)  NOT NULL ,
	[parentid] [int] NOT NULL ,
	[uid] [int] NOT NULL ,
	[posttitle] [nvarchar] (60)  NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spaceconfigs] (
	[spaceid] [int] IDENTITY (1, 1) NOT NULL ,
	[userid] [int] NOT NULL ,
	[spacetitle] [nchar] (100)  NOT NULL ,
	[description] [nchar] (200)  NOT NULL ,
	[blogdispmode] [tinyint] NOT NULL ,
	[bpp] [int] NOT NULL ,
	[commentpref] [tinyint] NOT NULL ,
	[messagepref] [tinyint] NOT NULL ,
	[rewritename] [char] (100)  NOT NULL ,
	[themeid] [int] NOT NULL ,
	[themepath] [nchar] (50)  NOT NULL ,
	[postcount] [int] NOT NULL ,
	[commentcount] [int] NOT NULL ,
	[visitedtimes] [int] NOT NULL ,
	[createdatetime] [smalldatetime] NOT NULL ,
	[updatedatetime] [smalldatetime] NOT NULL ,
	[defaulttab] [int] NOT NULL ,
	[status] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacecustomizepanels] (
	[moduleid] [int] NOT NULL ,
	[userid] [int] NOT NULL ,
	[panelcontent] [ntext]  NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dnt_spacelinks] (
	[linkid] [int] IDENTITY (1, 1) NOT NULL ,
	[userid] [int] NOT NULL ,
	[linktitle] [nvarchar] (50)  NOT NULL ,
	[linkurl] [varchar] (255)  NOT NULL ,
	[description] [nvarchar] (200)  NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacemoduledefs] (
	[moduledefid] [int] IDENTITY (1, 1) NOT NULL ,
	[modulename] [nvarchar] (20)  NOT NULL ,
	[cachetime] [int] NOT NULL ,
	[configfile] [varchar] (100)  NOT NULL ,
	[controller] [varchar] (255)  NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacemodules] (
	[moduleid] [int] NOT NULL ,
	[tabid] [int] NOT NULL ,
	[uid] [int] NOT NULL ,
	[moduledefid] [int] NOT NULL ,
	[panename] [varchar] (10)  NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[userpref] [nvarchar] (4000)  NULL ,
	[val] [tinyint] NOT NULL ,
	[moduleurl] [varchar] (255)  NOT NULL ,
	[moduletype] [tinyint] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacepostcategories] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[postid] [int] NOT NULL ,
	[categoryid] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spaceposts] (
	[postid] [int] IDENTITY (1, 1) NOT NULL ,
	[author] [nvarchar] (40)  NOT NULL ,
	[uid] [int] NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[content] [ntext]  NOT NULL ,
	[title] [nvarchar] (120)  NOT NULL ,
	[category] [varchar] (255)  NOT NULL ,
	[poststatus] [tinyint] NOT NULL ,
	[commentstatus] [tinyint] NOT NULL ,
	[postupdatetime] [datetime] NOT NULL ,
	[commentcount] [int] NOT NULL ,
	[views] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dnt_spaceposttags] (
	[tagid] [int] NOT NULL ,
	[spacepostid] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacetabs] (
	[tabid] [int] NOT NULL ,
	[uid] [int] NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[tabname] [nvarchar] (50)  NOT NULL ,
	[iconfile] [varchar] (50)  NULL ,
	[template] [varchar] (50)  NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_spacethemes] (
	[themeid] [int] IDENTITY (1, 1) NOT NULL ,
	[directory] [varchar] (100)  NOT NULL ,
	[name] [nvarchar] (50)  NOT NULL ,
	[type] [int] NOT NULL ,
	[author] [nvarchar] (100)  NOT NULL ,
	[createdate] [nvarchar] (50)  NOT NULL ,
	[copyright] [nvarchar] (100)  NOT NULL 
) ON [PRIMARY]
GO

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

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

CREATE TABLE [dnt_tags] (
	[tagid] [int] NOT NULL ,
	[tagname] [nchar] (10)  NOT NULL ,
	[userid] [int] NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[orderid] [int] NOT NULL ,
	[color] [char] (6)  NOT NULL ,
	[count] [int] NOT NULL ,
	[fcount] [int] NOT NULL ,
	[pcount] [int] NOT NULL ,
	[scount] [int] NOT NULL ,
	[vcount] [int] NOT NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dnt_topicidentify] (
	[identifyid] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [nvarchar] (50)  NOT NULL ,
	[filename] [varchar] (50)  NOT NULL 
) ON [PRIMARY]
GO

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)  NOT NULL ,
	[posterid] [int] NOT NULL ,
	[title] [nchar] (60)  NOT NULL ,
	[postdatetime] [datetime] NOT NULL ,
	[lastpost] [datetime] NOT NULL ,
	[lastpostid] [int] NOT NULL ,
	[lastposter] [nchar] (20)  NOT NULL ,
	[lastposterid] [int] NOT NULL ,
	[views] [int] NOT NULL ,
	[replies] [int] NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[highlight] [varchar] (500)  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 ,
	[identify] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_topictagcaches] (
	[tid] [int] NOT NULL ,
	[linktid] [int] NOT NULL ,
	[linktitle] [nchar] (60)  NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_topictags] (
	[tagid] [int] NOT NULL ,
	[tid] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_topictypes] (
	[typeid] [int] IDENTITY (1, 1) NOT NULL ,
	[displayorder] [int] NOT NULL ,
	[name] [nvarchar] (30)  NOT NULL ,
	[description] [nvarchar] (500)  NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_userfields] (
	[uid] [int] NOT NULL ,
	[website] [nvarchar] (80)  NOT NULL ,
	[icq] [varchar] (12)  NOT NULL ,
	[qq] [varchar] (12)  NOT NULL ,
	[yahoo] [varchar] (40)  NOT NULL ,
	[msn] [varchar] (40)  NOT NULL ,
	[skype] [varchar] (40)  NOT NULL ,
	[location] [nvarchar] (50)  NOT NULL ,
	[customstatus] [nvarchar] (50)  NOT NULL ,
	[avatar] [nvarchar] (255)  NOT NULL ,
	[avatarwidth] [int] NOT NULL ,
	[avatarheight] [int] NOT NULL ,
	[medals] [varchar] (300)  NOT NULL ,
	[bio] [nvarchar] (500) NOT NULL ,
	[signature] [nvarchar] (500)  NOT NULL ,
	[sightml] [nvarchar] (1000)  NOT NULL ,
	[authstr] [varchar] (20)  NOT NULL ,
	[authtime] [smalldatetime] NOT NULL ,
	[authflag] [tinyint] NOT NULL ,
	[realname] [nvarchar] (10)  NOT NULL ,
	[idcard] [varchar] (20)  NOT NULL ,
	[mobile] [varchar] (20)  NOT NULL ,
	[phone] [varchar] (20)  NOT NULL 
) ON [PRIMARY]
GO

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)  NOT NULL ,
	[creditshigher] [int] NOT NULL ,
	[creditslower] [int] NOT NULL ,
	[stars] [int] NOT NULL ,
	[color] [char] (7)  NOT NULL ,
	[groupavatar] [nvarchar] (60)  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)  NOT NULL ,
	[raterange] [nchar] (500)  NOT NULL ,
	[allowspace] [smallint] NOT NULL ,
	[maxspaceattachsize] [int] NOT NULL ,
	[maxspacephotosize] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dnt_users] (
	[uid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [nchar] (20)  NOT NULL ,
	[nickname] [nchar] (20)  NOT NULL ,
	[password] [char] (32)  NOT NULL ,
	[secques] [char] (8)  NOT NULL ,
	[spaceid] [int] NOT NULL ,
	[gender] [int] NOT NULL ,
	[adminid] [int] NOT NULL ,
	[groupid] [smallint] NOT NULL ,
	[groupexpiry] [int] NOT NULL ,
	[extgroupids] [char] (60)  NOT NULL ,
	[regip] [char] (15)  NOT NULL ,
	[joindate] [smalldatetime] NOT NULL ,
	[lastip] [char] (15)  NOT NULL ,
	[lastvisit] [datetime] NOT NULL ,
	[lastactivity] [datetime] NOT NULL ,
	[lastpost] [datetime] NOT NULL ,
	[lastpostid] [int] NOT NULL ,
	[lastposttitle] [nchar] (60)  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)  NOT NULL ,
	[bday] [char] (10)  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]
GO

CREATE TABLE [dnt_words] (
	[id] [smallint] IDENTITY (1, 1) NOT NULL ,
	[admin] [nvarchar] (20)  NOT NULL ,
	[find] [nvarchar] (255)  NOT NULL ,
	[replacement] [nvarchar] (255)  NOT NULL 
) ON [PRIMARY]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ALTER TABLE [dnt_spaceattachments] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spaceattachments] PRIMARY KEY  CLUSTERED 
	(
		[aid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spacecategories] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacecategory] PRIMARY KEY  CLUSTERED 
	(
		[categoryid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spacecomments] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacecomments] PRIMARY KEY  CLUSTERED 
	(
		[commentid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spaceconfigs] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spaceconfig] PRIMARY KEY  CLUSTERED 
	(
		[spaceid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spacecustomizepanels] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacecustomizepanels] PRIMARY KEY  CLUSTERED 
	(
		[moduleid],
		[userid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spacelinks] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacelink] PRIMARY KEY  CLUSTERED 
	(
		[linkid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spacemoduledefs] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacemoduledefs] PRIMARY KEY  CLUSTERED 
	(
		[moduledefid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spacepostcategories] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacepostcategorys] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spaceposts] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spaceposts] PRIMARY KEY  CLUSTERED 
	(
		[postid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_spacethemes] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacethemes] PRIMARY KEY  CLUSTERED 
	(
		[themeid]
	)  ON [PRIMARY] 
GO

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

ALTER TABLE [dnt_tags] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_tags] PRIMARY KEY  CLUSTERED 
	(
		[tagid]
	)  ON [PRIMARY] 
GO

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

ALTER TABLE [dnt_topicidentify] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_topicidentify] PRIMARY KEY  CLUSTERED 
	(
		[identifyid]
	)  ON [PRIMARY] 
GO

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

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

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

ALTER TABLE [dnt_photos] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacephoto] PRIMARY KEY  CLUSTERED 
	(
		[photoid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_albumcategories] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_albumcategories] PRIMARY KEY  CLUSTERED 
	(
		[albumcateid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_albums] WITH NOCHECK ADD 
	CONSTRAINT [PK_dnt_spacealbums] PRIMARY KEY  CLUSTERED 
	(
		[albumid]
	)  ON [PRIMARY] 
GO

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

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

ALTER TABLE [dnt_advertisements] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_advertisements_code] DEFAULT ('') FOR [code],
	CONSTRAINT [DF_dnt_advertisements_parameters] DEFAULT ('') FOR [parameters]
GO

ALTER TABLE [dnt_albumcategories] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_albumcategories_albumcount] DEFAULT (0) FOR [albumcount],
	CONSTRAINT [DF_dnt_albumcategories_displayorder] DEFAULT (0) FOR [displayorder]
GO

ALTER TABLE [dnt_albums] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spacealbums_userid] DEFAULT ((-1)) FOR [userid],
	CONSTRAINT [DF_dnt_albums_username] DEFAULT ('') FOR [username],
	CONSTRAINT [DF_dnt_spacealbums_title] DEFAULT ('') FOR [title],
	CONSTRAINT [DF_dnt_spacealbums_description] DEFAULT ('') FOR [description],
	CONSTRAINT [DF_dnt_spacealbums_logo] DEFAULT ('') FOR [logo],
	CONSTRAINT [DF_dnt_spacealbums_password] DEFAULT ('') FOR [password],
	CONSTRAINT [DF_dnt_spacealbums_imgcount] DEFAULT (0) FOR [imgcount],
	CONSTRAINT [DF_dnt_spacealbums_views] DEFAULT (0) FOR [views],
	CONSTRAINT [DF_dnt_spacealbums_type] DEFAULT (0) FOR [type],
	CONSTRAINT [DF_dnt_spacealbums_createdatetime] DEFAULT (getdate()) FOR [createdatetime]
GO

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

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

ALTER TABLE [dnt_favorites] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_favorites_typeid] DEFAULT (0) FOR [typeid]
GO

ALTER TABLE [dnt_forumfields] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_forumfields_applytopictype] DEFAULT (0) FOR [applytopictype],
	CONSTRAINT [DF_dnt_forumfields_postbytopictype] DEFAULT (0) FOR [postbytopictype],
	CONSTRAINT [DF_dnt_forumfields_viewbytopictype] DEFAULT (0) FOR [viewbytopictype],
	CONSTRAINT [DF_dnt_forumfields_topictypeprefix] DEFAULT (0) FOR [topictypeprefix]
GO

ALTER TABLE [dnt_forums] WITH NOCHECK 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_forums_colcount] DEFAULT ('1') FOR [colcount],
	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_allowthumbnail] DEFAULT ('0') FOR [allowthumbnail],
	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]
GO

ALTER TABLE [dnt_help] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_help_orderby] DEFAULT (0) FOR [orderby]
GO

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

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

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

ALTER TABLE [dnt_online] WITH NOCHECK 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_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_lastpostpmtime] DEFAULT ('1900-1-1 00:00:00') FOR [lastpostpmtime],
	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]
GO

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

ALTER TABLE [dnt_photocomments] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_photocomments_ip] DEFAULT ('') FOR [ip]
GO

ALTER TABLE [dnt_photos] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spacephoto_description] DEFAULT ('') FOR [description],
	CONSTRAINT [DF_dnt_spacephoto_postdate] DEFAULT (getdate()) FOR [postdate],
	CONSTRAINT [DF_dnt_photos_username] DEFAULT ('') FOR [username],
	CONSTRAINT [DF_dnt_photos_viewcount] DEFAULT (0) FOR [views],
	CONSTRAINT [DF_dnt_photos_commentstatus] DEFAULT (0) FOR [commentstatus],
	CONSTRAINT [DF_dnt_photos_tagstatus] DEFAULT (0) FOR [tagstatus],
	CONSTRAINT [DF_dnt_photos_comments] DEFAULT (0) FOR [comments],
	CONSTRAINT [DF_dnt_photos_isattachment] DEFAULT (0) FOR [isattachment]
GO

ALTER TABLE [dnt_phototags] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_phototags_tagid] DEFAULT (0) FOR [tagid],
	CONSTRAINT [DF_dnt_phototags_pid] DEFAULT (0) FOR [photoid]
GO

ALTER TABLE [dnt_posts1] WITH NOCHECK 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]
GO

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

ALTER TABLE [dnt_spaceattachments] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spaceattachments_uid] DEFAULT (0) FOR [uid],
	CONSTRAINT [DF_dnt_spaceattachments_spacepostid] DEFAULT (0) FOR [spacepostid],
	CONSTRAINT [DF_dnt_spaceattachments_postdatetime] DEFAULT (getdate()) FOR [postdatetime],
	CONSTRAINT [DF_dnt_spaceattachments_filename] DEFAULT ('') FOR [filename],
	CONSTRAINT [DF_dnt_spaceattachments_filetype] DEFAULT ('') FOR [filetype],
	CONSTRAINT [DF_dnt_spaceattachments_filesize] DEFAULT (0) FOR [filesize],
	CONSTRAINT [DF_dnt_spaceattachments_attachment] DEFAULT ('') FOR [attachment],
	CONSTRAINT [DF_dnt_spaceattachments_downloads] DEFAULT (0) FOR [downloads]
GO

ALTER TABLE [dnt_spacecategories] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spacecategory_title] DEFAULT ('') FOR [title],
	CONSTRAINT [DF_dnt_spacecategory_uid] DEFAULT (0) FOR [uid],
	CONSTRAINT [DF_dnt_spacecategorys_description] DEFAULT ('') FOR [description],
	CONSTRAINT [DF_dnt_spacecategory_typeid] DEFAULT (0) FOR [typeid],
	CONSTRAINT [DF_dnt_spacecategory_categorycount] DEFAULT (0) FOR [categorycount],
	CONSTRAINT [DF_dnt_spacecategory_displayorder] DEFAULT (0) FOR [displayorder]
GO

ALTER TABLE [dnt_spacecomments] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spacecomments_postid] DEFAULT (0) FOR [postid],
	CONSTRAINT [DF_dnt_spacecomments_author] DEFAULT ('') FOR [author],
	CONSTRAINT [DF_dnt_spacecomments_email] DEFAULT ('') FOR [email],
	CONSTRAINT [DF_dnt_spacecomments_url] DEFAULT ('') FOR [url],
	CONSTRAINT [DF_dnt_spacecomments_ip] DEFAULT ('') FOR [ip],
	CONSTRAINT [DF_dnt_spacecomments_postdatetime] DEFAULT (getdate()) FOR [postdatetime],
	CONSTRAINT [DF_dnt_spacecomments_content] DEFAULT ('') FOR [content]
GO

ALTER TABLE [dnt_spaceconfigs] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spaceconfig_spacetitle] DEFAULT ('') FOR [spacetitle],
	CONSTRAINT [DF_dnt_spaceconfig_description] DEFAULT ('') FOR [description],
	CONSTRAINT [DF_dnt_spaceconfig_blogdispmode] DEFAULT (0) FOR [blogdispmode],
	CONSTRAINT [DF_dnt_spaceconfig_bpp] DEFAULT (16) FOR [bpp],
	CONSTRAINT [DF_dnt_spaceconfig_commentpref] DEFAULT (0) FOR [commentpref],
	CONSTRAINT [DF_dnt_spaceconfig_messagepref] DEFAULT (0) FOR [messagepref],
	CONSTRAINT [DF_dnt_spaceconfig_rewritename] DEFAULT ('') FOR [rewritename],
	CONSTRAINT [DF_dnt_spaceconfig_theme] DEFAULT (0) FOR [themeid],
	CONSTRAINT [DF_dnt_spaceconfig_template] DEFAULT ('') FOR [themepath],
	CONSTRAINT [DF_dnt_spaceconfigs_postcount] DEFAULT (0) FOR [postcount],
	CONSTRAINT [DF_dnt_spaceconfigs_commentcount] DEFAULT (0) FOR [commentcount],
	CONSTRAINT [DF_dnt_spaceconfigs_visitedtimes] DEFAULT (0) FOR [visitedtimes],
	CONSTRAINT [DF_dnt_spaceconfigs_createdatetime] DEFAULT (getdate()) FOR [createdatetime],
	CONSTRAINT [DF_dnt_spaceconfigs_updatedatetime] DEFAULT (getdate()) FOR [updatedatetime],
	CONSTRAINT [DF_dnt_spaceconfigs_defaulttab] DEFAULT (0) FOR [defaulttab],
	CONSTRAINT [DF_dnt_spaceconfigs_status] DEFAULT (0) FOR [status]
GO

ALTER TABLE [dnt_spacecustomizepanels] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spacecustomizepanels_panelcontent] DEFAULT ('') FOR [panelcontent]
GO

ALTER TABLE [dnt_spacemodules] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spacemodules_uid] DEFAULT (0) FOR [uid]
GO

ALTER TABLE [dnt_spacepostcategories] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spacepostcategorys_postid] DEFAULT (0) FOR [postid],
	CONSTRAINT [DF_dnt_spacepostcategorys_categoryid] DEFAULT (0) FOR [categoryid]
GO

ALTER TABLE [dnt_spaceposts] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spaceposts_views] DEFAULT (0) FOR [views]
GO

ALTER TABLE [dnt_spaceposttags] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spaceposttags_tagid] DEFAULT (0) FOR [tagid],
	CONSTRAINT [DF_dnt_spaceposttags_spacepostid] DEFAULT (0) FOR [spacepostid]
GO

ALTER TABLE [dnt_spacethemes] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_spacetheme_directory] DEFAULT ('') FOR [directory],
	CONSTRAINT [DF_dnt_spacetheme_name] DEFAULT ('') FOR [name],
	CONSTRAINT [DF_dnt_spacetheme_type] DEFAULT (0) FOR [type],
	CONSTRAINT [DF_dnt_spacetheme_author] DEFAULT ('') FOR [author],
	CONSTRAINT [DF_dnt_spacetheme_createdate] DEFAULT ('') FOR [createdate],
	CONSTRAINT [DF_dnt_spacetheme_copyright] DEFAULT ('') FOR [copyright]
GO

ALTER TABLE [dnt_tablelist] WITH NOCHECK 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]
GO

ALTER TABLE [dnt_tags] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_tags_userid] DEFAULT (0) FOR [userid],
	CONSTRAINT [DF_dnt_tags_orderid] DEFAULT (0) FOR [orderid],
	CONSTRAINT [DF_dnt_tags_count] DEFAULT (0) FOR [count],
	CONSTRAINT [DF_dnt_tags_fcount] DEFAULT (0) FOR [fcount],
	CONSTRAINT [DF_dnt_tags_pcount] DEFAULT (0) FOR [pcount],
	CONSTRAINT [DF_dnt_tags_scount] DEFAULT (0) FOR [scount],
	CONSTRAINT [DF_dnt_tags_vcount] DEFAULT (0) FOR [vcount]
GO

ALTER TABLE [dnt_topics] WITH NOCHECK 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 [DF_dnt_topics_identify] DEFAULT (0) FOR [identify],
	CONSTRAINT [PK_dnt_topics] PRIMARY KEY  NONCLUSTERED 
	(
		[tid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dnt_topictagcaches] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_topictagcaches_tid] DEFAULT (0) FOR [tid],
	CONSTRAINT [DF_dnt_topictagcaches_linktid] DEFAULT (0) FOR [linktid]
GO

ALTER TABLE [dnt_topictags] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_topictags_tagid] DEFAULT (0) FOR [tagid],
	CONSTRAINT [DF_dnt_topictags_tid] DEFAULT (0) FOR [tid]
GO

ALTER TABLE [dnt_topictypes] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_topictypes_displayorder] DEFAULT (0) FOR [displayorder],
	CONSTRAINT [DF_dnt_topictypes_name] DEFAULT ('') FOR [name],
	CONSTRAINT [DF_dnt_topictypes_description] DEFAULT ('') FOR [description]
GO

ALTER TABLE [dnt_userfields] WITH NOCHECK 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],
	CONSTRAINT [DF_dnt_userfields_realname] DEFAULT ('') FOR [realname],
	CONSTRAINT [DF_dnt_userfields_idcard] DEFAULT ('') FOR [idcard],
	CONSTRAINT [DF_dnt_userfields_mobile] DEFAULT ('') FOR [mobile],
	CONSTRAINT [DF_dnt_userfields_phone] DEFAULT ('') FOR [phone]
GO

ALTER TABLE [dnt_usergroups] WITH NOCHECK ADD 
	CONSTRAINT [DF_dnt_usergroups_type] DEFAULT (0) FOR [type],
	CONSTRAINT [DF_dnt_usergroups_system] DEFAULT ('0') FOR [system],
	CONSTRAINT [DF_dnt_usergroups_allowspace] DEFAULT (0) FOR [allowspace],
	CONSTRAINT [DF_dnt_usergroups_maxspaceattachsize] DEFAULT (0) FOR [maxspaceattachsize],
	CONSTRAINT [DF_dnt_usergroups_maxspacephotosize] DEFAULT (0) FOR [maxspacephotosize]
GO

ALTER TABLE [dnt_users] WITH NOCHECK 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_spaceid] DEFAULT (0) FOR [spaceid],
	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 ('7') 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]
GO

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

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

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

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

 CREATE  INDEX [ip] ON [dnt_online]([userid], [ip]) ON [PRIMARY]
GO

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

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

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

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

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

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

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

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

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

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

 CREATE  INDEX [uid] ON [dnt_attachments]([uid]) ON [PRIMARY]
GO

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

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

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

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

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

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

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

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

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

 CREATE  INDEX [albumid] ON [dnt_photos]([albumid]) ON [PRIMARY]
GO

 CREATE  INDEX [photoiduserid] ON [dnt_photos]([photoid], [userid]) ON [PRIMARY]
GO

 CREATE  INDEX [userid] ON [dnt_photos]([userid]) ON [PRIMARY]
GO

 CREATE  INDEX [tid] ON [dnt_spaceattachments]([spacepostid]) ON [PRIMARY]
GO

 CREATE  INDEX [uid] ON [dnt_spaceattachments]([uid]) ON [PRIMARY]
GO

 CREATE  INDEX [spacepostiduserid] ON [dnt_spaceattachments]([spacepostid], [uid]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [userid] ON [dnt_spacecategories]([uid], [displayorder], [categoryid]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [userid] ON [dnt_spaceconfigs]([userid]) ON [PRIMARY]
GO

 CREATE  INDEX [linkiduserid] ON [dnt_spacelinks]([linkid], [userid]) ON [PRIMARY]
GO

 CREATE  INDEX [configfile] ON [dnt_spacemoduledefs]([configfile]) ON [PRIMARY]
GO

 CREATE  INDEX [postiduid] ON [dnt_spaceposts]([postid], [uid]) ON [PRIMARY]
GO

 CREATE  INDEX [postidcommentcount] ON [dnt_spaceposts]([postid], [commentcount]) ON [PRIMARY]
GO

 CREATE  INDEX [uid] ON [dnt_spacetabs]([uid]) ON [PRIMARY]
GO

 CREATE  INDEX [type] ON [dnt_spacethemes]([type]) ON [PRIMARY]
GO

 CREATE INDEX [msgtoid] ON [dnt_pms] ([msgtoid]) ON [PRIMARY]
GO

 CREATE INDEX [list_albumcateid] ON [dnt_albums]([imgcount], [albumcateid], [albumid]) ON [PRIMARY]
GO

 CREATE INDEX [list_userid] ON [dnt_albums]([type], [imgcount], [userid], [albumid]) ON [PRIMARY]