Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r14861 -r14879 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14861) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14879) @@ -2379,4 +2379,37 @@ 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); -ALTER TABLE EmailQueue ADD `LogData` TEXT; \ No newline at end of file +ALTER TABLE EmailQueue ADD `LogData` TEXT; + +UPDATE Permissions +SET Permission = REPLACE(Permission, 'agents', 'scheduled_tasks') +WHERE Permission LIKE 'in-portal:agents%'; + +DELETE FROM Phrase +WHERE PhraseKey IN ( + 'LA_TITLE_ADDINGAGENT', 'LA_TITLE_EDITINGAGENT', 'LA_TITLE_NEWAGENT', 'LA_TITLE_AGENTS', 'LA_TOOLTIP_NEWAGENT' +); + +UPDATE Phrase +SET l<%PRIMARY_LANGUAGE%>_Translation = REPLACE(l<%PRIMARY_LANGUAGE%>_Translation, 'Agents', 'Scheduled Tasks') +WHERE PhraseKey IN ( + 'LA_USECRONFORREGULAREVENT', 'LA_HINT_SYSTEMTOOLSRESETPARSEDCACHEDDATA', 'LA_HINT_SYSTEMTOOLSRESETCONFIGSANDPARSEDDATA' +); + +DELETE FROM PersistantSessionData +WHERE VariableName LIKE 'agent%'; + +RENAME TABLE Agents TO ScheduledTasks; + +ALTER TABLE ScheduledTasks + CHANGE AgentId ScheduledTaskId INT(11) NOT NULL AUTO_INCREMENT, + CHANGE AgentName Name VARCHAR(255) NOT NULL DEFAULT '', + CHANGE AgentType `Type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1'; + +ALTER TABLE ScheduledTasks + DROP INDEX AgentType, + ADD INDEX `Type` (`Type`); + +UPDATE ConfigurationValues +SET VariableName = 'RunScheduledTasksFromCron' +WHERE VariableName = 'UseCronForRegularEvent'; \ No newline at end of file