Index: branches/RC/core/install/install_schema.sql =================================================================== diff -u -N -r10856 -r10887 --- branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10856) +++ branches/RC/core/install/install_schema.sql (.../install_schema.sql) (revision 10887) @@ -588,4 +588,27 @@ KEY TimeAvg (TimeAvg), KEY TimeMax (TimeMax), KEY QueryCrc (QueryCrc) +); + +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) ); \ No newline at end of file