mattermost/server/channels/db/migrations/postgres/000043_thread_memberships.down.sql

7 lines
280 B
SQL

DROP INDEX IF EXISTS idx_thread_memberships_user_id;
DROP INDEX IF EXISTS idx_thread_memberships_last_view_at;
DROP INDEX IF EXISTS idx_thread_memberships_last_update_at;
ALTER TABLE threadmemberships DROP COLUMN IF EXISTS unreadmentions;
DROP TABLE IF EXISTS theadmemberships;