MySQLUpgradeFrom1.6To2.0.sql

/BlogEngine/BlogEngine.NET/setup/MySQL/MySQLUpgradeFrom1.6To2.0.sql

#
SQL | 17 lines | 13 code | 4 blank | 0 comment | 0 complexity | 2ef0344ee7867ebd7c5eb97d27d6dc39 MD5 | raw file
Possible License(s): LGPL-2.1, Apache-2.0, BSD-3-Clause




ALTER TABLE `be_PostComment` ADD `IsSpam` tinyint(1) NOT NULL DEFAULT '0';

ALTER TABLE `be_PostComment` ADD `IsDeleted` tinyint(1) NOT NULL DEFAULT '0';

ALTER TABLE `be_Posts` ADD `IsDeleted` tinyint(1) NOT NULL DEFAULT '0';

ALTER TABLE `be_Pages` ADD `IsDeleted` tinyint(1) NOT NULL DEFAULT '0';



CREATE TABLE IF NOT EXISTS `be_Rights` (

  `RightName` varchar(100) NOT NULL,

  PRIMARY KEY  (`RightName`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE IF NOT EXISTS `be_RightRoles` (

  `RightName` varchar(100) NOT NULL,

  `Role` varchar(100) NOT NULL,

  PRIMARY KEY (`RightName`, `Role`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;