18 lines
454 B
SQL
18 lines
454 B
SQL
CREATE TABLE IF NOT EXISTS permissions (
|
|
id bigserial PRIMARY KEY,
|
|
code text NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS users_permissions (
|
|
user_id bigint NOT NULL REFERENCES users ON DELETE CASCADE,
|
|
permission_id bigint NOT NULL REFERENCES permissions ON DELETE CASCADE,
|
|
PRIMARY KEY (user_id, permission_id)
|
|
);
|
|
|
|
-- Add the two permissions to the table.
|
|
INSERT INTO permissions (code)
|
|
VALUES
|
|
('movies:read'),
|
|
('movies:write');
|
|
|