blob: 1faa14a92e204d3cf86f696c2afd8c2fbcd6ddca (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE page_restrictions (
pr_page INTEGER NULL REFERENCES page (page_id) ON DELETE CASCADE,
pr_type TEXT NOT NULL,
pr_level TEXT NOT NULL,
pr_cascade SMALLINT NOT NULL,
pr_user INTEGER NULL,
pr_expiry TIMESTAMPTZ NULL
);
ALTER TABLE page_restrictions ADD CONSTRAINT page_restrictions_pk PRIMARY KEY (pr_page,pr_type);
|