Index: branches/5.1.x/core/install/install_schema.sql =================================================================== diff -u -N -r13151 -r13168 --- branches/5.1.x/core/install/install_schema.sql (.../install_schema.sql) (revision 13151) +++ branches/5.1.x/core/install/install_schema.sql (.../install_schema.sql) (revision 13168) @@ -448,6 +448,10 @@ FormSubmittedTemplate varchar(255) DEFAULT NULL, FriendlyURL varchar(255) NOT NULL DEFAULT '', ThemeId int(10) unsigned NOT NULL DEFAULT '0', + EnablePageCache tinyint(4) NOT NULL DEFAULT '0', + OverridePageCacheKey tinyint(4) NOT NULL DEFAULT '0', + PageCacheKey varchar(255) NOT NULL DEFAULT '', + PageExpiration int(11) DEFAULT NULL, PRIMARY KEY (CategoryId), UNIQUE KEY ResourceId (ResourceId), KEY ParentId (ParentId), @@ -471,7 +475,10 @@ KEY `Status` (`Status`), KEY CreatedOn (CreatedOn), KEY EditorsPick (EditorsPick), - KEY ThemeId (ThemeId) + KEY ThemeId (ThemeId), + KEY EnablePageCache (EnablePageCache), + KEY OverridePageCacheKey (OverridePageCacheKey), + KEY PageExpiration (PageExpiration) ); CREATE TABLE CategoryCustomData ( @@ -1095,4 +1102,20 @@ KEY SessionKey (SessionKey), KEY `Timestamp` (`Timestamp`), KEY MainPrefix (MainPrefix) +); + +CREATE TABLE CachedUrls ( + UrlId int(11) NOT NULL AUTO_INCREMENT, + Url varchar(255) NOT NULL DEFAULT '', + `Hash` int(11) NOT NULL DEFAULT '0', + Prefixes varchar(255) NOT NULL DEFAULT '', + ParsedVars text NOT NULL, + Cached int(10) unsigned DEFAULT NULL, + LifeTime int(11) NOT NULL DEFAULT '-1', + PRIMARY KEY (UrlId), + KEY Url (Url), + KEY `Hash` (`Hash`), + KEY Prefixes (Prefixes), + KEY Cached (Cached), + KEY LifeTime (LifeTime) ); \ No newline at end of file