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.
13 -- Field for time-limited protection.
14 pr_expiry
char(14) binary NULL,
16 PRIMARY KEY pr_pagetype (pr_page
,pr_type
),
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
)