Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r14881 -r14882 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14881) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14882) @@ -665,31 +665,31 @@ ); CREATE TABLE ScheduledTasks ( - ScheduledTaskId int(11) NOT NULL auto_increment, - `Name` varchar(255) NOT NULL default '', - `Type` 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', - Timeout int(10) UNSIGNED NULL, - LastTimeoutOn int(10) unsigned default NULL, + ScheduledTaskId int(11) NOT NULL AUTO_INCREMENT, + `Name` varchar(255) NOT NULL DEFAULT '', + `Type` 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', + Timeout int(10) unsigned DEFAULT NULL, + LastTimeoutOn int(10) unsigned DEFAULT NULL, SiteDomainLimitation varchar(255) NOT NULL, - PRIMARY KEY (ScheduledTaskId), - KEY Status (Status), + PRIMARY KEY (ScheduledTaskId), + KEY `Status` (`Status`), KEY RunInterval (RunInterval), KEY RunMode (RunMode), - KEY `Type` (`Type`), KEY LastRunOn (LastRunOn), KEY LastRunStatus (LastRunStatus), KEY RunTime (RunTime), KEY NextRunOn (NextRunOn), + KEY SiteDomainLimitation (SiteDomainLimitation), KEY Timeout (Timeout), - KEY SiteDomainLimitation (SiteDomainLimitation) + KEY `Type` (`Type`) ); CREATE TABLE SpellingDictionary (