Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r14853 -r14856 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14853) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14856) @@ -2340,4 +2340,41 @@ UPDATE Phrase SET l<%PRIMARY_LANGUAGE%>_ColumnTranslation = l<%PRIMARY_LANGUAGE%>_Translation -WHERE PhraseKey IN ('LA_FLD_CATEGORY', 'LA_FLD_ORDER'); \ No newline at end of file +WHERE PhraseKey IN ('LA_FLD_CATEGORY', 'LA_FLD_ORDER'); + +CREATE TABLE PageRevisions ( + RevisionId int(11) NOT NULL AUTO_INCREMENT, + PageId int(11) NOT NULL, + RevisionNumber int(11) NOT NULL, + IsDraft tinyint(4) NOT NULL, + FromRevisionId int(11) NOT NULL, + CreatedById int(11) DEFAULT NULL, + CreatedOn int(11) DEFAULT NULL, + AutoSavedOn int(11) DEFAULT NULL, + `Status` tinyint(4) NOT NULL DEFAULT '2', + PRIMARY KEY (RevisionId), + KEY PageId (PageId), + KEY RevisionNumber (RevisionNumber), + KEY IsDraft (IsDraft), + KEY `Status` (`Status`) +); + +ALTER TABLE Category + ADD LiveRevisionNumber INT NOT NULL DEFAULT '1' AFTER PageExpiration, + ADD INDEX (LiveRevisionNumber); + +ALTER TABLE PageContent + ADD RevisionId INT NOT NULL AFTER PageId, + ADD INDEX (RevisionId); + +ALTER TABLE PermissionConfig CHANGE PermissionName PermissionName VARCHAR(255) NOT NULL DEFAULT ''; + +INSERT INTO PermissionConfig VALUES (DEFAULT, 'CATEGORY.REVISION.ADD', 'la_PermName_Category.Revision.Add_desc', 'In-Portal', 1); +INSERT INTO PermissionConfig VALUES (DEFAULT, 'CATEGORY.REVISION.ADD.PENDING', 'la_PermName_Category.Revision.Add.Pending_desc', 'In-Portal', 1); +INSERT INTO PermissionConfig VALUES (DEFAULT, 'CATEGORY.REVISION.MODERATE', 'la_PermName_Category.Revision.Moderate_desc', 'In-Portal', 1); +INSERT INTO PermissionConfig VALUES (DEFAULT, 'CATEGORY.REVISION.HISTORY.VIEW', 'la_PermName_Category.Revision.History.View_desc', 'In-Portal', 1); +INSERT INTO PermissionConfig VALUES (DEFAULT, 'CATEGORY.REVISION.HISTORY.RESTORE', 'la_PermName_Category.Revision.History.Restore_desc', 'In-Portal', 1); + +INSERT INTO Permissions VALUES(DEFAULT, 'CATEGORY.REVISION.ADD', 11, 1, 0, 1); +INSERT INTO Permissions VALUES(DEFAULT, 'CATEGORY.REVISION.HISTORY.VIEW', 11, 1, 0, 1); +INSERT INTO Permissions VALUES(DEFAULT, 'CATEGORY.REVISION.HISTORY.RESTORE', 11, 1, 0, 1); \ No newline at end of file