﻿ CREATE  INDEX [tid] ON [dnt_attachments]([tid]) 
~

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

 CREATE  INDEX [parentid] ON [dnt_posts1]([parentid]) 
~
 CREATE  UNIQUE  INDEX [showtopic] ON [dnt_posts1]([tid], [pid])
~
 CREATE  INDEX [treelist] ON [dnt_posts1]([tid], [invisible], [parentid]) 
~
 DROP  INDEX [list] ON [dnt_topics] 
~
 CREATE  INDEX [list] ON [dnt_topics]([fid], [displayorder], [lastpostid] DESC ) 
~
 CREATE  INDEX [displayorder] ON [dnt_topics]([displayorder]) 
~

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

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

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

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

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

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

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

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

 ALTER TABLE [dnt_users] ALTER COLUMN [oltime] integer

~

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

~

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

~

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

~

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

~

ALTER TABLE [dnt_forums] ADD [colcount] smallint NOT NULL default 1

~
UPDATE [dnt_forums] SET [colcount]=1

~
Update [dnt_forums] SET [status]=1 WHERE [status]>0

~

CREATE TABLE [dnt_failedlogins] ([ip] varchar(20) primary key , [errcount] integer  not null default 0,[lastupdate] datetime default now())

~
CREATE TABLE [dnt_online] ([olid] Counter  primary key , [userid] integer  not null default -1,[ip] varchar(20)  not null default "0.0.0.0" ,[username] varchar(20)  not null  default "",[tickcount] long not null  default 0,[nickname] varchar(20) not null  default "",[password] varchar(80) not null  default "", [groupid] integer not null  default 0,[olimg] varchar(80) not null ,[adminid] integer not null  default 0, [invisible] integer not null  default 0,[action] integer not null  default 0,[lastactivity] integer not null  default 0 , [lastposttime] datetime default "1900-1-1 00:00:00" ,[lastsearchtime] datetime default "1900-1-1 00:00:00", [lastupdatetime] datetime default now(),[forumid] integer not null  default 0,[forumname] varchar(50) not null  default "",[titleid] long not null  default 0, [title] varchar(80) not null  default "",[verifycode] varchar(10) not null  default "")

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

~
CREATE INDEX [invisible] ON [dnt_online]([userid], [invisible])

~
CREATE INDEX [forumid] ON [dnt_online]([forumid])

~
CREATE INDEX [password] ON [dnt_online]([userid], [password])

~
CREATE INDEX [ip] ON [dnt_online]([userid], [ip])

~

ALTER TABLE [dnt_forums] ADD [curtopics] long NOT NULL default 0

~
UPDATE [dnt_forums] SET [curtopics]=0 
