 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] long  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" , [lastpostpmtime] 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 

~
UPDATE [dnt_onlinelist] SET [img]=''  WHERE [groupid]=6 AND [img]='guest.gif'

~
UPDATE [dnt_onlinelist] SET [img]='guest.gif'  WHERE [groupid]=7

~

DROP TABLE [dnt_moderatormanagelog]

~

DROP TABLE [dnt_cachelog]
~


CREATE TABLE [dnt_moderatormanagelog] ([id] Counter primary key ,[moderatoruid] integer NULL ,	[moderatorname] varchar(50) NULL ,	[groupid] integer NULL ,	[grouptitle] varchar(50) NULL ,	[ip] varchar(15) NULL ,	[postdatetime] datetime default now(),	[fid] integer NULL ,	[fname] varchar(100) NULL ,	[tid] integer NULL ,	[title] varchar(200) NULL ,	[actions] varchar(50) NULL ,	[reason] varchar(200) NULL ) 

~

update [dnt_advertisements] set [type]='0' where [type]='头部横幅广告'
~
update [dnt_advertisements] set [type]='1' where [type]='尾部横幅广告'
~
update [dnt_advertisements] set [type]='2' where [type]='页内文字广告'
~
update [dnt_advertisements] set [type]='3' where [type]='贴内广告'
~
update [dnt_advertisements] set [type]='4' where [type]='浮动广告'
~
update [dnt_advertisements] set [type]='5' where [type]='对联广告'
~
CREATE INDEX [uid] ON [dnt_attachments] ([uid])
~
ALTER TABLE [dnt_forums] ADD [allowthumbnail] int NOT NULL default 0
~
ALTER TABLE [dnt_online] ADD [lastpostpmtime] datetime NOT NULL DEFAULT '1900-1-1 00:00:00'

~
ALTER TABLE [dnt_onlinelist] Alter Column [title] varchar(50) NULL 

~

update [dnt_forums] set allowthumbnail = 0 where allowthumbnail is null