[BUGFIX] EM using bad indexes 80/31080/2
authorStefan Froemken <froemken@gmail.com>
Mon, 23 Jun 2014 15:16:34 +0000 (17:16 +0200)
committerMarkus Klein <klein.t3@reelworx.at>
Sat, 23 Aug 2014 16:15:00 +0000 (18:15 +0200)
The extensionmanager uses bad indexes. It is better
to move col repository to the the end of the indexes.

Resolves: #59809
Releases: 6.3,6.2
Change-Id: I0bb8d5cdfc8591bb35485b204ad5e8dafd1b4d16
Reviewed-on: http://review.typo3.org/31080
Reviewed-by: Oliver Klee <typo3-coding@oliverklee.de>
Reviewed-by: Marcin SÄ…gol <marcin@soee.pl>
Reviewed-by: Tymoteusz Motylewski <t.motylewski@gmail.com>
Tested-by: Tymoteusz Motylewski <t.motylewski@gmail.com>
Reviewed-by: Markus Klein <klein.t3@reelworx.at>
Tested-by: Markus Klein <klein.t3@reelworx.at>
typo3/sysext/extensionmanager/ext_tables.sql

index 18b73df..085a0b3 100644 (file)
@@ -41,8 +41,8 @@ CREATE TABLE tx_extensionmanager_domain_model_extension (
   current_version int(3) NOT NULL default '0',
   lastreviewedversion int(3) NOT NULL default '0',
   PRIMARY KEY (uid),
-  KEY index_extrepo (repository,extension_key),
-  KEY index_versionrepo (repository,integer_version),
-  KEY index_currentversions (review_state,current_version),
+  KEY index_extrepo (extension_key,repository),
+  KEY index_versionrepo (integer_version,repository),
+  KEY index_currentversions (current_version,review_state),
   UNIQUE versionextrepo (extension_key,version,repository)
 );