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(8) NOT NULL,
   5         -- The protection type (edit, move, etc)
   6         pr_type varchar(255) NOT NULL,
   7         -- The protection level (Sysop, autoconfirmed, etc)
   8         pr_level varchar(255) NOT NULL,
   9         -- Whether or not to cascade the protection down to pages transcluded.
  10         pr_cascade tinyint(4) NOT NULL,
  11         -- Field for future support of per-user restriction.
  12         pr_user int(8) NULL,
  13         -- Field for future support of time-limited protection.
  14         pr_expiry char(14) binary NULL,
  15
  16         PRIMARY KEY  (pr_page,pr_type),
  17
  18         KEY pr_page (pr_page),
  19         KEY pr_typelevel (pr_type,pr_level),
  20         KEY pr_level (pr_level),
  21         KEY pr_cascade (pr_cascade)
  22 ) TYPE=InnoDB;