Files
team/server/channels/db/migrations/postgres/000063_upgrade_threads_v6.0.up.sql

4 lines
229 B
SQL

ALTER TABLE threads ALTER COLUMN participants TYPE jsonb USING participants::jsonb;
CREATE INDEX IF NOT EXISTS idx_threads_channel_id_last_reply_at ON threads(channelid, lastreplyat);
DROP INDEX IF EXISTS idx_threads_channel_id;