PageRenderTime 7ms CodeModel.GetById 1ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 1ms

/BlogEngine/BlogEngine.NET/setup/SQLite/SQLiteUpgradeFrom1.6To2.0.txt

#
Plain Text | 33 lines | 23 code | 10 blank | 0 comment | 0 complexity | 0038168fcb32e0e238d680eb6172735b MD5 | raw file
 1ALTER TABLE be_PostComment
 2ADD IsSpam BOOLEAN NOT NULL DEFAULT 0;
 3
 4ALTER TABLE be_PostComment
 5ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;
 6
 7ALTER TABLE be_Posts
 8ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;
 9
10ALTER TABLE be_Pages
11ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;
12
13CREATE TABLE [be_Rights] (
14[RightName] VARCHAR(100)  UNIQUE NOT NULL
15);
16
17CREATE TABLE [be_RightRoles] (
18[RightName] VARCHAR(100) NOT NULL,
19[Role] VARCHAR(100) NOT NULL
20);
21
22UPDATE be_PostComment
23SET IsSpam = 0;
24
25UPDATE be_PostComment
26SET IsDeleted = 0;
27
28UPDATE be_Posts
29SET IsDeleted = 0;
30
31UPDATE be_Pages
32SET IsDeleted = 0;
33