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

     1  CREATE TABLE IF NOT EXISTS teams (
     2      id VARCHAR(26) PRIMARY KEY,
     3      createat bigint,
     4      updateat bigint,
     5      deleteat bigint,
     6      displayname VARCHAR(64),
     7      name VARCHAR(64),
     8      description VARCHAR(255),
     9      email VARCHAR(128),
    10      type VARCHAR(255),
    11      companyname VARCHAR(64),
    12      alloweddomains VARCHAR(1000),
    13      inviteid VARCHAR(32),
    14      schemeid VARCHAR(26),
    15      UNIQUE(name)
    16  );
    17  
    18  CREATE INDEX IF NOT EXISTS idx_teams_invite_id ON teams (inviteid);
    19  CREATE INDEX IF NOT EXISTS idx_teams_update_at ON teams (updateat);
    20  CREATE INDEX IF NOT EXISTS idx_teams_create_at ON teams (createat);
    21  CREATE INDEX IF NOT EXISTS idx_teams_delete_at ON teams (deleteat);
    22  CREATE INDEX IF NOT EXISTS idx_teams_scheme_id ON teams (schemeid);
    23  
    24  ALTER TABLE teams ADD COLUMN IF NOT EXISTS allowopeninvite boolean;
    25  ALTER TABLE teams ADD COLUMN IF NOT EXISTS lastteamiconupdate bigint;
    26  ALTER TABLE teams ADD COLUMN IF NOT EXISTS description VARCHAR(255);
    27  ALTER TABLE teams ADD COLUMN IF NOT EXISTS groupconstrained boolean;