Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r15373 -r15390 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15373) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15390) @@ -482,13 +482,15 @@ TreeLeft bigint(20) NOT NULL DEFAULT '0', TreeRight bigint(20) NOT NULL DEFAULT '0', NamedParentPath text, + NamedParentPathHash int(10) unsigned NOT NULL DEFAULT '0', MetaDescription text, HotItem int(11) NOT NULL DEFAULT '2', NewItem int(11) NOT NULL DEFAULT '2', PopItem int(11) NOT NULL DEFAULT '2', Modified int(11) DEFAULT NULL, ModifiedById int(11) DEFAULT NULL, CachedTemplate varchar(255) NOT NULL DEFAULT '', + CachedTemplateHash int(10) unsigned NOT NULL DEFAULT '0', Template varchar(255) NOT NULL DEFAULT '#inherit#', UseExternalUrl tinyint(3) unsigned NOT NULL DEFAULT '0', ExternalUrl varchar(255) NOT NULL DEFAULT '', @@ -551,7 +553,9 @@ KEY PageExpiration (PageExpiration), KEY Protected (Protected), KEY LiveRevisionNumber (LiveRevisionNumber), - KEY PromoBlockGroupId (PromoBlockGroupId) + KEY PromoBlockGroupId (PromoBlockGroupId), + KEY NamedParentPathHash (NamedParentPathHash), + KEY CachedTemplateHash (CachedTemplateHash) ); CREATE TABLE CategoryCustomData (