aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r--install/schema_postgres.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 381c262a7..65acb644b 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -627,6 +627,7 @@ create index "item_comments_closed" on item ("comments_closed");
create index "item_aid" on item ("aid");
create index "item_owner_xchan" on item ("owner_xchan");
create index "item_author_xchan" on item ("author_xchan");
+create index "item_resource_id" on item ("resource_id");
create index "item_resource_type" on item ("resource_type");
create index "item_restrict" on item ("item_restrict");
create index "item_flags" on item ("item_flags");