diff options
Diffstat (limited to 'maintenance/archives/patch-page_restrictions.sql')
-rw-r--r-- | maintenance/archives/patch-page_restrictions.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/maintenance/archives/patch-page_restrictions.sql b/maintenance/archives/patch-page_restrictions.sql new file mode 100644 index 00000000..c0eafab9 --- /dev/null +++ b/maintenance/archives/patch-page_restrictions.sql @@ -0,0 +1,22 @@ +--- Used for storing page restrictions (i.e. protection levels) +CREATE TABLE /*$wgDBprefix*/page_restrictions ( + -- Page to apply restrictions to (Foreign Key to page). + pr_page int(8) NOT NULL, + -- The protection type (edit, move, etc) + pr_type varchar(255) NOT NULL, + -- The protection level (Sysop, autoconfirmed, etc) + pr_level varchar(255) NOT NULL, + -- Whether or not to cascade the protection down to pages transcluded. + pr_cascade tinyint(4) NOT NULL, + -- Field for future support of per-user restriction. + pr_user int(8) NULL, + -- Field for time-limited protection. + pr_expiry char(14) binary NULL, + + PRIMARY KEY pr_pagetype (pr_page,pr_type), + + KEY pr_page (pr_page), + KEY pr_typelevel (pr_type,pr_level), + KEY pr_level (pr_level), + KEY pr_cascade (pr_cascade) +) /*$wgDBTableOptions*/;
\ No newline at end of file |