Make an extra index on the log_abuse table

[gnucomo.git] / src / gcm_daemon / classes / gnucomo_db_version.php

diff --git a/src/gcm_daemon/classes/gnucomo_db_version.php b/src/gcm_daemon/classes/gnucomo_db_version.php
index 2864044..d84a3e5 100644 (file)
--- 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: