StackRef-HM/database/1003-UPDATE-table-sr.team-member-role.sql at main · StackRef/StackRef-HM · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
-- Database:    sr
-- Table:       team_member_role
-- Description: Update grant names

UPDATE
    sr."team_member_role"
SET
    team_member_role_grants =
    '{
        "play": "true",
        "manage": "true"
    }',
    ts_modified = NOW()
WHERE
    team_member_role_name = 'Leader';

UPDATE
    sr."team_member_role"
SET
    team_member_role_grants =
    '{
        "play": "true",
        "manage": "false"
    }',
    ts_modified = NOW()
WHERE
    team_member_role_name = 'Player';