推荐订阅源

/// <summary>
        /// 清理之前的在线表记录(本方法在应用程序初始化时被调用)
        /// </summary>
        /// <returns></returns>
        public static int InitOnlineList()
        {

                int result=1;

                try
                {
                    Database.ExecuteNonQuery(CommandType.Text,"DROP TABLE ["+BaseConfigFactory.GetTablePrefix+"online]");
                }
                catch
                {
                    result=-1;
                }
                finally
                {
                
                    try
                    {
                        Database.ExecuteNonQuery(CommandType.Text,"CREATE TABLE ["+BaseConfigFactory.GetTablePrefix+"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 \"\")");
                        Database.ExecuteNonQuery(CommandType.Text,"CREATE INDEX [forum] ON [dnt_online]([userid], [forumid], [invisible])");
                        Database.ExecuteNonQuery(CommandType.Text,"CREATE INDEX [invisible] ON [dnt_online]([userid], [invisible])");
                        Database.ExecuteNonQuery(CommandType.Text,"CREATE INDEX [forumid] ON [dnt_online]([forumid])");
                        Database.ExecuteNonQuery(CommandType.Text,"CREATE INDEX [password] ON [dnt_online]([userid], [password])");
                        Database.ExecuteNonQuery(CommandType.Text,"CREATE INDEX [ip] ON [dnt_online]([userid], [ip])");
                    }
                    catch
                    {
                        result=-1;
                    }
                }

                return result;
            
        }