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

     1  ALTER TABLE teams DROP COLUMN IF EXISTS allowopeninvite;
     2  ALTER TABLE teams DROP COLUMN IF EXISTS lastteamiconupdate;
     3  ALTER TABLE teams DROP COLUMN IF EXISTS description;
     4  ALTER TABLE teams DROP COLUMN IF EXISTS groupconstrained;
     5  
     6  DROP INDEX IF EXISTS idx_teams_invite_id;
     7  DROP INDEX IF EXISTS idx_teams_update_at;
     8  DROP INDEX IF EXISTS idx_teams_create_at;
     9  DROP INDEX IF EXISTS idx_teams_delete_at;
    10  DROP INDEX IF EXISTS idx_teams_scheme_id;
    11  
    12  DROP TABLE IF EXISTS teams;