From 9feb4b819b2254ff385c8ddb14022c653d21ef37 Mon Sep 17 00:00:00 2001
From: Arjen Baart <arjen@andromeda.nl>
Date: Sat, 14 Mar 2015 10:40:11 +0100
Subject: [PATCH] Make an extra index on the log_abuse table

---
 src/database/create.sql                       | 1 +
 src/gcm_daemon/classes/gnucomo_db_version.php | 1 +
 2 files changed, 2 insertions(+)

diff --git a/src/database/create.sql b/src/database/create.sql
index f93ddc7..211da87 100644
--- a/src/database/create.sql
+++ b/src/database/create.sql
@@ -246,6 +246,7 @@ CREATE TABLE log_abuse
         source     inet
 );
 
+CREATE INDEX log_ab_src ON log_abuse (source, objectid);
 --
 --
 
diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index 2864044..d84a3e5 100644
--- a/src/gcm_daemon/classes/gnucomo_db_version.php
+++ b/src/gcm_daemon/classes/gnucomo_db_version.php
@@ -669,6 +669,7 @@ case 43:
 
      $dbms->query("GRANT INSERT ON property TO GROUP admin");
      $dbms->query("GRANT UPDATE ON property TO GROUP admin");
+     $dbms->query("CREATE INDEX log_ab_src ON log_abuse (source, objectid)");
 
 /*
 TODO:
-- 
2.11.0