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); }