patch-protected_titles.sql 454 B

1234567891011
  1. CREATE TABLE protected_titles (
  2. pt_namespace SMALLINT NOT NULL,
  3. pt_title TEXT NOT NULL,
  4. pt_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL,
  5. pt_reason TEXT NULL,
  6. pt_timestamp TIMESTAMPTZ NOT NULL,
  7. pt_expiry TIMESTAMPTZ NULL,
  8. pt_create_perm TEXT NOT NULL DEFAULT ''
  9. );
  10. CREATE UNIQUE INDEX protected_titles_unique ON protected_titles(pt_namespace, pt_title);