diff options
Diffstat (limited to 'www/wiki/maintenance/archives/patch-page_restrictions.sql')
-rw-r--r-- | www/wiki/maintenance/archives/patch-page_restrictions.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-page_restrictions.sql b/www/wiki/maintenance/archives/patch-page_restrictions.sql new file mode 100644 index 00000000..6813c1e7 --- /dev/null +++ b/www/wiki/maintenance/archives/patch-page_restrictions.sql @@ -0,0 +1,20 @@ +--- 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 NOT NULL, + -- The protection type (edit, move, etc) + pr_type varbinary(60) NOT NULL, + -- The protection level (Sysop, autoconfirmed, etc) + pr_level varbinary(60) NOT NULL, + -- Whether or not to cascade the protection down to pages transcluded. + pr_cascade tinyint NOT NULL, + -- Field for future support of per-user restriction. + pr_user int NULL, + -- Field for time-limited protection. + pr_expiry varbinary(14) NULL, + + PRIMARY KEY pr_pagetype (pr_page,pr_type), + KEY pr_typelevel (pr_type,pr_level), + KEY pr_level (pr_level), + KEY pr_cascade (pr_cascade) +) /*$wgDBTableOptions*/; |