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

     1  CREATE TABLE IF NOT EXISTS teammembers (
     2      teamid VARCHAR(26) NOT NULL,
     3      userid VARCHAR(26) NOT NULL,
     4      roles VARCHAR(64),
     5      deleteat bigint,
     6      PRIMARY KEY (teamid, userid)
     7  );
     8  
     9  CREATE INDEX IF NOT EXISTS idx_teammembers_user_id ON TeamMembers (userid);
    10  CREATE INDEX IF NOT EXISTS idx_teammembers_delete_at ON TeamMembers (deleteat);
    11  
    12  ALTER TABLE teammembers ADD COLUMN IF NOT EXISTS schemeuser boolean;
    13  ALTER TABLE teammembers ADD COLUMN IF NOT EXISTS schemeadmin boolean;
    14  ALTER TABLE teammembers ADD COLUMN IF NOT EXISTS schemeguest boolean;
    15  ALTER TABLE teammembers ADD COLUMN IF NOT EXISTS deleteat bigint;