Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r15230 -r15246 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15230) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15246) @@ -675,16 +675,16 @@ ); CREATE TABLE SlowSqlCapture ( - CaptureId int(10) unsigned NOT NULL auto_increment, + CaptureId int(10) unsigned NOT NULL AUTO_INCREMENT, TemplateNames text, - Hits int(10) unsigned NOT NULL default '0', - LastHit int(11) NOT NULL default '0', + Hits int(10) unsigned NOT NULL DEFAULT '0', + LastHit int(11) NOT NULL DEFAULT '0', SqlQuery text, - TimeMin decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', - TimeAvg decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', - TimeMax decimal(40,20) unsigned NOT NULL default '0.00000000000000000000', - QueryCrc int(11) NOT NULL default '0', - PRIMARY KEY (CaptureId), + TimeMin decimal(40,20) unsigned NOT NULL DEFAULT '0.00000000000000000000', + TimeAvg decimal(40,20) unsigned NOT NULL DEFAULT '0.00000000000000000000', + TimeMax decimal(40,20) unsigned NOT NULL DEFAULT '0.00000000000000000000', + QueryCrc bigint(11) NOT NULL DEFAULT '0', + PRIMARY KEY (CaptureId), KEY Hits (Hits), KEY LastHit (LastHit), KEY TimeMin (TimeMin), @@ -1015,7 +1015,7 @@ CREATE TABLE ImportCache ( CacheId int(11) NOT NULL AUTO_INCREMENT, CacheName varchar(255) NOT NULL DEFAULT '', - VarName int(11) NOT NULL DEFAULT '0', + VarName bigint(11) NOT NULL DEFAULT '0', VarValue text, PRIMARY KEY (CacheId), KEY CacheName (CacheName), @@ -1065,7 +1065,7 @@ CREATE TABLE PageContent ( PageContentId int(11) NOT NULL AUTO_INCREMENT, - ContentNum int(11) NOT NULL DEFAULT '0', + ContentNum bigint(11) NOT NULL DEFAULT '0', PageId int(11) NOT NULL DEFAULT '0', RevisionId int(11) NOT NULL, l1_Content text, @@ -1231,7 +1231,7 @@ UrlId int(11) NOT NULL AUTO_INCREMENT, Url varchar(255) NOT NULL DEFAULT '', DomainId int(11) NOT NULL DEFAULT '0', - `Hash` int(11) NOT NULL DEFAULT '0', + `Hash` bigint(11) NOT NULL DEFAULT '0', Prefixes varchar(255) NOT NULL DEFAULT '', ParsedVars text, Cached int(10) unsigned DEFAULT NULL,