ACCESS 创建表及索引方式
2012年04月16日
⁄ 综合
⁄ 共 2449字 ⁄ 字号
小 中 大
/**//// <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;
}