/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 

    

  1. ALTER TABLE be_PostComment

    2. 

  2. ADD IsSpam BOOLEAN NOT NULL DEFAULT 0;

    3. 

  3. 

    4. 

  4. ALTER TABLE be_PostComment

    5. 

  5. ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;

    6. 

  6. 

    7. 

  7. ALTER TABLE be_Posts

    8. 

  8. ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;

    9. 

  9. 

    10. 

  10. ALTER TABLE be_Pages

    11. 

  11. ADD IsDeleted BOOLEAN NOT NULL DEFAULT 0;

    12. 

  12. 

    13. 

  13. CREATE TABLE [be_Rights] (

    14. 

  14. [RightName] VARCHAR(100)  UNIQUE NOT NULL

    15. 

  15. );

    16. 

  16. 

    17. 

  17. CREATE TABLE [be_RightRoles] (

    18. 

  18. [RightName] VARCHAR(100) NOT NULL,

    19. 

  19. [Role] VARCHAR(100) NOT NULL

    20. 

  20. );

    21. 

  21. 

    22. 

  22. UPDATE be_PostComment

    23. 

  23. SET IsSpam = 0;

    24. 

  24. 

    25. 

  25. UPDATE be_PostComment

    26. 

  26. SET IsDeleted = 0;

    27. 

  27. 

    28. 

  28. UPDATE be_Posts

    29. 

  29. SET IsDeleted = 0;

    30. 

  30. 

    31. 

  31. UPDATE be_Pages

    32. 

  32. SET IsDeleted = 0;
    33.