diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/2020-07-29-reports-last-seen.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/2020-07-29-reports-last-seen.sql b/util/updates/2020-07-29-reports-last-seen.sql new file mode 100644 index 00000000..e38c5f54 --- /dev/null +++ b/util/updates/2020-07-29-reports-last-seen.sql @@ -0,0 +1,5 @@ +ALTER TABLE users ADD COLUMN last_reports timestamptz; +DROP INDEX reports_status; +CREATE INDEX reports_new ON reports (date) WHERE status = 'new'; +CREATE INDEX reports_lastmod ON reports (lastmod); +\i sql/perms.sql |