Discuz!NT For Access v1.0 源码

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