From 79a806f328e27269d13f26deb0acee7ad8560f7a Mon Sep 17 00:00:00 2001
From: git-marijus <mario@mariovavti.com>
Date: Mon, 31 Jul 2017 16:49:56 +0200
Subject: db update to add index for item.obj_type

---
 install/schema_postgres.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'install/schema_postgres.sql')

diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index f3cead9b7..0bc783692 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -631,6 +631,7 @@ create index "item_restrict" on item ("item_restrict");
 create index "item_flags" on item ("item_flags");
 create index "item_commented" on item ("commented");
 create index "item_verb" on item ("verb");
+create index "item_obj_type" on item ("obj_type");
 create index "item_private" on item ("item_private");
 create index "item_llink" on item ("llink");
 create index "item_expires" on item ("expires");
-- 
cgit v1.2.3

