SQLiteUpgradeFrom1.6To2.0.txt

/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
Possible License(s): LGPL-2.1, Apache-2.0, BSD-3-Clause


ALTER TABLE be_PostComment

ADD IsSpam BOOLEAN NOT NULL DEFAULT 0;



ALTER TABLE be_PostComment

ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;



ALTER TABLE be_Posts

ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;



ALTER TABLE be_Pages

ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;



CREATE TABLE [be_Rights] (

[RightName] VARCHAR(100)  UNIQUE NOT NULL

);



CREATE TABLE [be_RightRoles] (

[RightName] VARCHAR(100) NOT NULL,

[Role] VARCHAR(100) NOT NULL

);



UPDATE be_PostComment

SET IsSpam = 0;



UPDATE be_PostComment

SET IsDeleted = 0;



UPDATE be_Posts

SET IsDeleted = 0;



UPDATE be_Pages

SET IsDeleted = 0;