diff options
Diffstat (limited to 'migrations/2018-05-01-141548_add-users/down.sql')
-rw-r--r-- | migrations/2018-05-01-141548_add-users/down.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/migrations/2018-05-01-141548_add-users/down.sql b/migrations/2018-05-01-141548_add-users/down.sql index a29ee47dd641..2f903171d4ba 100644 --- a/migrations/2018-05-01-141548_add-users/down.sql +++ b/migrations/2018-05-01-141548_add-users/down.sql @@ -55,6 +55,8 @@ CREATE MATERIALIZED VIEW search_index AS JOIN threads t ON t.id = p.thread_id; +CREATE INDEX idx_fts_search ON search_index USING gin(document); + -- and drop the users table and columns: ALTER TABLE posts DROP COLUMN author; ALTER TABLE threads DROP COLUMN author; |