internal void creatTable(SqlLiteHelper sqlLiteHelper)
{
string sql = @"CREATE TABLE `t_userLogin` (
`Uid` TEXT NOT NULL,
`Sign` TEXT,
`ExtTime` TEXT
);";
sqlLiteHelper.RunSQL(sql);
}
internal void creatTable(SqlLiteHelper sqlLiteHelper)
{
//Id,Name,Describe,Status,Author,DefaultController,DefaultAction,PVersion,MenuShow,Icon
string sql = @"CREATE TABLE `t_roles` (
`Id` INTEGER NOT NULL,
`Name` TEXT NOT NULL,
`RightIds` TEXT NOT NULL DEFAULT ',',
`IsSuper` INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY(Id)
);";
sqlLiteHelper.RunSQL(sql);
}
internal void creatTable(SqlLiteHelper sqlLiteHelper)
{
//Id,Name,Describe,Status,Author,DefaultController,DefaultAction,PVersion,MenuShow,Icon
string sql = @"CREATE TABLE `t_users` (
`Uid` TEXT NOT NULL,
`Name` TEXT NOT NULL,
`Photo` TEXT,
`RolesIds` TEXT NOT NULL DEFAULT (','),
`Status` INTEGER NOT NULL DEFAULT 0,
`PassWord` TEXT NOT NULL DEFAULT ('000000'),
PRIMARY KEY(Uid)
);";
sqlLiteHelper.RunSQL(sql);
}
internal void creatTable(SqlLiteHelper sqlLiteHelper)
{
//Id,Name,Describe,Status,Author,DefaultController,DefaultAction,PVersion,MenuShow,Icon
string sql = @"CREATE TABLE `t_rights` (
`Id` INTEGER NOT NULL,
`Name` TEXT NOT NULL,
`Url` TEXT NOT NULL UNIQUE,
`Level` INTEGER NOT NULL,
`ParentId` INTEGER NOT NULL,
`Describe` TEXT NOT NULL,
`IsMenu` INTEGER NOT NULL DEFAULT 0,
`Deleted` INTEGER NOT NULL DEFAULT 0,
`Category` INTEGER NOT NULL,
PRIMARY KEY(Id)
);";
sqlLiteHelper.RunSQL(sql);
}
internal void creatTable(SqlLiteHelper sqlLiteHelper)
{
//Id,Name,Describe,Status,Author,DefaultController,DefaultAction,PVersion,MenuShow,Icon
string sql = @"CREATE TABLE `t_plugin` (
`Id` INTEGER NOT NULL,
`Name` TEXT NOT NULL,
`Status` INTEGER NOT NULL DEFAULT 0,
`Describe` TEXT NOT NULL,
`Author` TEXT NOT NULL,
`DefaultController` TEXT NOT NULL,
`DefaultAction` TEXT NOT NULL,
`PVersion` INTEGER,
`MenuShow` INTEGER,
`Icon` TEXT,
PRIMARY KEY(Id)
);";
sqlLiteHelper.RunSQL(sql);
}
