PageRenderTime 60ms CodeModel.GetById 36ms RepoModel.GetById 0ms app.codeStats 0ms

/BlogEngine/BlogEngine.NET/setup/MySQL/MySQLUpgradeFrom2.0To2.5.sql

#
SQL | 114 lines | 89 code | 25 blank | 0 comment | 0 complexity | 9dd40252343e3874deb836d12ecc942f MD5 | raw file
Possible License(s): LGPL-2.1, Apache-2.0, BSD-3-Clause
  1. ALTER TABLE be_Users ADD BlogID varchar(36) NOT NULL DEFAULT '';
  2. UPDATE be_Users SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  3. ALTER TABLE be_UserRoles ADD BlogID varchar(36) NOT NULL DEFAULT '';
  4. UPDATE be_UserRoles SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  5. ALTER TABLE be_UserRoles ADD UserName nvarchar(100) NOT NULL DEFAULT '';
  6. ALTER TABLE be_UserRoles ADD Role nvarchar(100) NOT NULL DEFAULT '';
  7. UPDATE be_UserRoles
  8. SET UserName =
  9. (
  10. SELECT UserName
  11. FROM be_Users
  12. WHERE be_Users.UserID = be_UserRoles.UserID
  13. ),
  14. Role =
  15. (
  16. SELECT Role
  17. FROM be_Roles
  18. WHERE be_Roles.RoleID = be_UserRoles.RoleID
  19. );
  20. ALTER TABLE be_UserRoles DROP COLUMN UserID;
  21. ALTER TABLE be_UserRoles DROP COLUMN RoleID;
  22. ALTER TABLE be_StopWords DROP PRIMARY KEY;
  23. ALTER TABLE be_StopWords ADD StopWordRowId int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (StopWordRowId);
  24. ALTER TABLE be_StopWords ADD BlogId varchar(36) NOT NULL DEFAULT '';
  25. UPDATE be_StopWords SET BlogId = '27604F05-86AD-47EF-9E05-950BB762570C';
  26. ALTER TABLE be_Settings DROP PRIMARY KEY;
  27. ALTER TABLE be_Settings ADD SettingRowId int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (SettingRowId);
  28. ALTER TABLE be_Settings ADD BlogId varchar(36) NOT NULL DEFAULT '';
  29. UPDATE be_Settings SET BlogId = '27604F05-86AD-47EF-9E05-950BB762570C';
  30. ALTER TABLE be_Roles ADD BlogID varchar(36) NOT NULL DEFAULT '';
  31. UPDATE be_Roles SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  32. ALTER TABLE be_Rights DROP PRIMARY KEY;
  33. ALTER TABLE be_Rights ADD RightRowId int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (RightRowId);
  34. ALTER TABLE be_Rights ADD BlogId varchar(36) NOT NULL DEFAULT '';
  35. UPDATE be_Rights SET BlogId = '27604F05-86AD-47EF-9E05-950BB762570C';
  36. ALTER TABLE be_RightRoles DROP PRIMARY KEY;
  37. ALTER TABLE be_RightRoles ADD RightRoleRowId int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (RightRoleRowId);
  38. ALTER TABLE be_RightRoles ADD BlogId varchar(36) NOT NULL DEFAULT '';
  39. UPDATE be_RightRoles SET BlogId = '27604F05-86AD-47EF-9E05-950BB762570C';
  40. ALTER TABLE be_Referrers DROP PRIMARY KEY;
  41. ALTER TABLE be_Referrers ADD ReferrerRowId int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (ReferrerRowId);
  42. ALTER TABLE be_Referrers ADD BlogId varchar(36) NOT NULL DEFAULT '';
  43. UPDATE be_Referrers SET BlogId = '27604F05-86AD-47EF-9E05-950BB762570C';
  44. ALTER TABLE be_Profiles ADD BlogID varchar(36) NOT NULL DEFAULT '';
  45. UPDATE be_Profiles SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  46. ALTER TABLE be_Posts DROP PRIMARY KEY;
  47. ALTER TABLE be_Posts ADD PostRowID int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (PostRowID);
  48. ALTER TABLE be_Posts ADD BlogID varchar(36) NOT NULL DEFAULT '';
  49. UPDATE be_Posts SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  50. ALTER TABLE be_PostTag ADD BlogID varchar(36) NOT NULL DEFAULT '';
  51. UPDATE be_PostTag SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  52. ALTER TABLE be_PostNotify ADD BlogID varchar(36) NOT NULL DEFAULT '';
  53. UPDATE be_PostNotify SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  54. ALTER TABLE be_PostComment DROP PRIMARY KEY;
  55. ALTER TABLE be_PostComment ADD PostCommentRowID int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (PostCommentRowID);
  56. ALTER TABLE be_PostComment ADD BlogID varchar(36) NOT NULL DEFAULT '';
  57. UPDATE be_PostComment SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  58. ALTER TABLE be_PingService ADD BlogID varchar(36) NOT NULL DEFAULT '';
  59. UPDATE be_PingService SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  60. ALTER TABLE be_Pages DROP PRIMARY KEY;
  61. ALTER TABLE be_Pages ADD PageRowID int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (PageRowID);
  62. ALTER TABLE be_Pages ADD BlogID varchar(36) NOT NULL DEFAULT '';
  63. UPDATE be_Pages SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  64. ALTER TABLE be_DataStoreSettings ADD DataStoreSettingRowId int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (DataStoreSettingRowId);
  65. ALTER TABLE be_DataStoreSettings ADD BlogId varchar(36) NOT NULL DEFAULT '';
  66. UPDATE be_DataStoreSettings SET BlogId = '27604F05-86AD-47EF-9E05-950BB762570C';
  67. ALTER TABLE be_Categories DROP PRIMARY KEY;
  68. ALTER TABLE be_Categories ADD CategoryRowID int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (CategoryRowID);
  69. ALTER TABLE be_Categories ADD BlogID varchar(36) NOT NULL DEFAULT '';
  70. UPDATE be_Categories SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  71. ALTER TABLE be_PostCategory ADD BlogID varchar(36) NOT NULL DEFAULT '';
  72. UPDATE be_PostCategory SET BlogID = '27604F05-86AD-47EF-9E05-950BB762570C';
  73. CREATE TABLE `be_Blogs` (
  74. `BlogRowId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  75. `BlogId` varchar(36) NOT NULL DEFAULT '',
  76. `BlogName` varchar(255) NOT NULL DEFAULT '',
  77. `Hostname` varchar(255) NOT NULL DEFAULT '',
  78. `IsAnyTextBeforeHostnameAccepted` tinyint(1) NOT NULL DEFAULT 1,
  79. `StorageContainerName` varchar(255) NOT NULL DEFAULT '',
  80. `VirtualPath` varchar(255) NOT NULL DEFAULT '',
  81. `IsPrimary` tinyint(1) NOT NULL DEFAULT 0,
  82. `IsActive` tinyint(1) NOT NULL DEFAULT 1,
  83. PRIMARY KEY (`BlogRowId`)
  84. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  85. INSERT INTO be_Blogs (BlogId, BlogName, Hostname, IsAnyTextBeforeHostnameAccepted, StorageContainerName, VirtualPath, IsPrimary, IsActive) VALUES ('27604f05-86ad-47ef-9e05-950bb762570c', 'Primary', '', 0, '', '~/', 1, 1);
  86. ALTER TABLE be_BlogRollItems DROP PRIMARY KEY;
  87. ALTER TABLE be_BlogRollItems ADD BlogRollRowId int(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (BlogRollRowId);
  88. ALTER TABLE be_BlogRollItems ADD BlogId varchar(36) NOT NULL DEFAULT '';
  89. UPDATE be_BlogRollItems SET BlogId = '27604F05-86AD-47EF-9E05-950BB762570C';