aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2017-09-03 17:17:20 -0700
committerzotlabs <mike@macgirvin.com>2017-09-03 17:17:20 -0700
commit4adf2caaa687287cf82b930bb5a0c07d39c7afc0 (patch)
tree670ce1e8c82b813ce86b6c8815e66ea6ea3a5adb /install/schema_postgres.sql
parentdb82d303e217c2ca599a8b740ebb62339d373124 (diff)
parent0fac35686b28825da69c77f9a903e4e24a7036fa (diff)
downloadvolse-hubzilla-4adf2caaa687287cf82b930bb5a0c07d39c7afc0.tar.gz
volse-hubzilla-4adf2caaa687287cf82b930bb5a0c07d39c7afc0.tar.bz2
volse-hubzilla-4adf2caaa687287cf82b930bb5a0c07d39c7afc0.zip
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
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 0bc783692..381c262a7 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -621,6 +621,7 @@ create index "item_edited" on item ("edited");
create index "item_received" on item ("received");
create index "item_uid_commented" on item ("uid","commented");
create index "item_uid_created" on item ("uid","created");
+create index "item_uid_unseen" on item ("uid","item_unseen");
create index "item_changed" on item ("changed");
create index "item_comments_closed" on item ("comments_closed");
create index "item_aid" on item ("aid");