Index: branches/RC/core/install/upgrades.sql =================================================================== diff -u -N -r10863 -r10887 --- branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 10863) +++ branches/RC/core/install/upgrades.sql (.../upgrades.sql) (revision 10887) @@ -314,4 +314,32 @@ ADD DefaultValue VARCHAR(255) NOT NULL AFTER ValueList, ADD INDEX (DefaultValue); -UPDATE CustomField SET ValueList = REPLACE(ValueList, ',', '||'); \ No newline at end of file +UPDATE CustomField SET ValueList = REPLACE(ValueList, ',', '||'); + +CREATE TABLE Agents ( + AgentId int(11) NOT NULL auto_increment, + AgentName varchar(255) NOT NULL default '', + AgentType tinyint(3) unsigned NOT NULL default '1', + Status tinyint(3) unsigned NOT NULL default '1', + Event varchar(255) NOT NULL default '', + RunInterval int(10) unsigned NOT NULL default '0', + RunMode tinyint(3) unsigned NOT NULL default '2', + LastRunOn int(10) unsigned default NULL, + LastRunStatus tinyint(3) unsigned NOT NULL default '1', + NextRunOn int(11) default NULL, + RunTime int(10) unsigned NOT NULL default '0', + PRIMARY KEY (AgentId), + KEY Status (Status), + KEY RunInterval (RunInterval), + KEY RunMode (RunMode), + KEY AgentType (AgentType), + KEY LastRunOn (LastRunOn), + KEY LastRunStatus (LastRunStatus), + KEY RunTime (RunTime), + KEY NextRunOn (NextRunOn) +); + +INSERT INTO Permissions VALUES(DEFAULT, 'in-portal:agents.delete', 11, 1, 1, 0); +INSERT INTO Permissions VALUES(DEFAULT, 'in-portal:agents.edit', 11, 1, 1, 0); +INSERT INTO Permissions VALUES(DEFAULT, 'in-portal:agents.add', 11, 1, 1, 0); +INSERT INTO Permissions VALUES(DEFAULT, 'in-portal:agents.view', 11, 1, 1, 0);