Files
team/server/channels/db/migrations/postgres/000002_create_team_members.down.sql

12 lines
439 B
SQL

CREATE INDEX IF NOT EXISTS idx_teammembers_team_id ON teammembers (teamid);
ALTER TABLE teammembers DROP COLUMN IF EXISTS schemeuser;
ALTER TABLE teammembers DROP COLUMN IF EXISTS schemeadmin;
ALTER TABLE teammembers DROP COLUMN IF EXISTS schemeguest;
ALTER TABLE teammembers DROP COLUMN IF EXISTS deleteat;
DROP INDEX IF EXISTS idx_teammembers_user_id;
DROP INDEX IF EXISTS idx_teammembers_delete_at;
DROP TABLE IF EXISTS teammembers;