From 79a806f328e27269d13f26deb0acee7ad8560f7a Mon Sep 17 00:00:00 2001 From: git-marijus 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