/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