6 lines
141 B
SQL
6 lines
141 B
SQL
CREATE TABLE user_roles(
|
|
role TEXT NOT NULL,
|
|
user_id uuid NOT NULL
|
|
REFERENCES users (id),
|
|
PRIMARY KEY (user_id, role)
|
|
);
|