Make an extra index on the log_abuse table

[gnucomo.git] / src / database / create.sql

diff --git a/src/database/create.sql b/src/database/create.sql
index f93ddc7..211da87 100644 (file)
--- 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);
 --
 --