[BUGFIX] Add index to table pages 54/27154/4
authorIngo Schmitt <is@marketing-factory.de>
Thu, 30 Jan 2014 14:47:12 +0000 (15:47 +0100)
committerBenjamin Mack <benni@typo3.org>
Fri, 31 Jan 2014 17:12:24 +0000 (18:12 +0100)
To detects the siteroot by querying the pages table with the
columns deleted, hidden, is_siteroot. This patch introduces
a combined index on those colums

Resolves: #55180
Releases: 6.2
Change-Id: Icae63670419cf9bc0029e2aa570cdf0108b9d62a
Reviewed-on: https://review.typo3.org/27154
Reviewed-by: Anja Leichsenring
Tested-by: Anja Leichsenring
Reviewed-by: Marcin SÄ…gol
Reviewed-by: Benjamin Mack
Tested-by: Benjamin Mack
typo3/sysext/core/ext_tables.sql

index 0938105..7f7fd6c 100644 (file)
@@ -180,7 +180,8 @@ CREATE TABLE pages (
   PRIMARY KEY (uid),
   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
   KEY parent (pid,deleted,sorting),
-  KEY alias (alias)
+  KEY alias (alias),
+  KEY determainSiteRoot (deleted,hidden,is_siteroot),
 );
 
 #