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

 1
 2ALTER TABLE `be_PostComment` ADD `IsSpam` tinyint(1) NOT NULL DEFAULT '0';
 3ALTER TABLE `be_PostComment` ADD `IsDeleted` tinyint(1) NOT NULL DEFAULT '0';
 4ALTER TABLE `be_Posts` ADD `IsDeleted` tinyint(1) NOT NULL DEFAULT '0';
 5ALTER TABLE `be_Pages` ADD `IsDeleted` tinyint(1) NOT NULL DEFAULT '0';
 6
 7CREATE TABLE IF NOT EXISTS `be_Rights` (
 8  `RightName` varchar(100) NOT NULL,
 9  PRIMARY KEY  (`RightName`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1;
11
12CREATE TABLE IF NOT EXISTS `be_RightRoles` (
13  `RightName` varchar(100) NOT NULL,
14  `Role` varchar(100) NOT NULL,
15  PRIMARY KEY (`RightName`, `Role`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17