[Summary view] [Print] [Text view]

   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*/;