maintenance/archives/patch-page_restrictions.sql

   1 --- Used for storing page restrictions (i.e. protection levels)
   2 CREATE TABLE /*$wgDBprefix*/page_restrictions (
   3         -- Page to apply restrictions to (Foreign Key to page).
   4         pr_page int NOT NULL,
   5         -- The protection type (edit, move, etc)
   6         pr_type varbinary(60) NOT NULL,
   7         -- The protection level (Sysop, autoconfirmed, etc)
   8         pr_level varbinary(60) NOT NULL,
   9         -- Whether or not to cascade the protection down to pages transcluded.
  10         pr_cascade tinyint NOT NULL,
  11         -- Field for future support of per-user restriction.
  12         pr_user int NULL,
  13         -- Field for time-limited protection.
  14         pr_expiry varbinary(14) NULL,
  15
  16         PRIMARY KEY pr_pagetype (pr_page,pr_type),
  17         KEY pr_typelevel (pr_type,pr_level),
  18         KEY pr_level (pr_level),
  19         KEY pr_cascade (pr_cascade)
  20 ) /*$wgDBTableOptions*/;