Files
team/server/channels/db/migrations/postgres/000056_upgrade_channels_v6.0.up.sql

5 lines
219 B
SQL

CREATE INDEX IF NOT EXISTS idx_channels_team_id_display_name ON channels(teamid, displayname);
CREATE INDEX IF NOT EXISTS idx_channels_team_id_type ON channels(teamid, type);
DROP INDEX IF EXISTS idx_channels_team_id;