Fixed issue #16698: sys_history: optimize indexes (Thanks to Juergen Deisenroth and...

git-svn-id: https://svn.typo3.org/TYPO3v4/Core/trunk@10068 709f56b5-9817-0410-a4d7-c38de5d9e867

diff --git a/ChangeLog b/ChangeLog
index d32615e..64e6bf3 100755 (executable)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,7 @@
+2011-01-14  Patrick Broens  <patrick@patrickbroens.nl>
+
+       * Fixed issue #16698: sys_history: optimize indexes (Thanks to Juergen Deisenroth and Christian Kuhn)
+

 2011-01-13  Steffen Kamper  <steffen@typo3.org>
 
        * Fixed issue #16919: Catalan flag is replaced by Canadian flag (Thanks to Alexandre Gravel-Raymond)
 2011-01-13  Steffen Kamper  <steffen@typo3.org>
 
        * Fixed issue #16919: Catalan flag is replaced by Canadian flag (Thanks to Alexandre Gravel-Raymond)

diff --git a/t3lib/stddb/tables.sql b/t3lib/stddb/tables.sql
index 78ee0d1..7f6a2d5 100644 (file)
--- a/t3lib/stddb/tables.sql
+++ b/t3lib/stddb/tables.sql
@@ -345,9 +345,10 @@ CREATE TABLE sys_history (
   history_files mediumtext,
   snapshot tinyint(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (uid),
   history_files mediumtext,
   snapshot tinyint(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (uid),

-  KEY recordident (tablename,recuid,tstamp),
+  KEY recordident_1 (tablename,recuid),
+  KEY recordident_2 (tablename,tstamp),

   KEY sys_log_uid (sys_log_uid)
   KEY sys_log_uid (sys_log_uid)

-);
+) ENGINE=InnoDB;

 
 #
 # Table structure for table 'sys_lockedrecords'
 
 #
 # Table structure for table 'sys_lockedrecords'