github.com/masterhung0112/hk_server/v5@v5.0.0-20220302090640-ec71aef15e1c/db/migrations/postgres/000002_create_team_members.down.sql (about)

     1  ALTER TABLE teammembers DROP COLUMN IF EXISTS schemeuser;
     2  ALTER TABLE teammembers DROP COLUMN IF EXISTS schemeadmin;
     3  ALTER TABLE teammembers DROP COLUMN IF EXISTS schemeguest;
     4  ALTER TABLE teammembers DROP COLUMN IF EXISTS deleteat;
     5  
     6  DROP INDEX IF EXISTS idx_teammembers_user_id;
     7  DROP INDEX IF EXISTS idx_teammembers_delete_at;
     8  
     9  DROP TABLE IF EXISTS TeamMembers;