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

# · SQL · 17 lines · 13 code · 4 blank · 0 comment · 0 complexity · 2ef0344ee7867ebd7c5eb97d27d6dc39 MD5 · raw file 

    

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

    2. 

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

    3. 

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

    4. 

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

    5. 

  5. 

    6. 

  6. CREATE TABLE IF NOT EXISTS `be_Rights` (

    7. 

  7.   `RightName` varchar(100) NOT NULL,

    8. 

  8.   PRIMARY KEY  (`RightName`)

    9. 

  9. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    10. 

  10. 

    11. 

  11. CREATE TABLE IF NOT EXISTS `be_RightRoles` (

    12. 

  12.   `RightName` varchar(100) NOT NULL,

    13. 

  13.   `Role` varchar(100) NOT NULL,

    14. 

  14.   PRIMARY KEY (`RightName`, `Role`)

    15. 

  15. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    16.