- Patch #324110 by killes: added an index on uid to make deleting watchdog entries faster.

1 files changed, 10 insertions, 0 deletions

diff --git a/modules/dblog/dblog.install b/modules/dblog/dblog.install
index ca9107c8f..e7310275d 100644
--- a/modules/dblog/dblog.install
+++ b/modules/dblog/dblog.install
@@ -98,6 +98,7 @@ function dblog_schema() {
     'primary key' => array('wid'),
     'indexes' => array(
       'type' => array('type'),
+      'uid' => array('uid'),
     ),
   );
 
@@ -113,3 +114,12 @@ function dblog_update_7001() {
   db_change_field($ret, 'watchdog', 'referer', 'referer', array('type' => 'varchar', 'length' => 255, 'not null' => FALSE, 'default' => ''));
   return $ret;
 }
+
+/**
+ * Add index on uid.
+ */
+function dblog_update_7002() {
+  $ret = array();
+  db_add_index($ret, 'watchdog', 'uid', array('uid'));
+  return $ret;
+}