patch-page_restrictions.sql 388 B

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