summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-page_restrictions.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/archives/patch-page_restrictions.sql')
-rw-r--r--maintenance/archives/patch-page_restrictions.sql14
1 files changed, 7 insertions, 7 deletions
diff --git a/maintenance/archives/patch-page_restrictions.sql b/maintenance/archives/patch-page_restrictions.sql
index c0eafab9..c18a054e 100644
--- a/maintenance/archives/patch-page_restrictions.sql
+++ b/maintenance/archives/patch-page_restrictions.sql
@@ -1,17 +1,17 @@
--- 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,
+ pr_page int NOT NULL,
-- The protection type (edit, move, etc)
- pr_type varchar(255) NOT NULL,
+ pr_type varbinary(60) NOT NULL,
-- The protection level (Sysop, autoconfirmed, etc)
- pr_level varchar(255) NOT NULL,
+ pr_level varbinary(60) NOT NULL,
-- Whether or not to cascade the protection down to pages transcluded.
- pr_cascade tinyint(4) NOT NULL,
+ pr_cascade tinyint NOT NULL,
-- Field for future support of per-user restriction.
- pr_user int(8) NULL,
+ pr_user int NULL,
-- Field for time-limited protection.
- pr_expiry char(14) binary NULL,
+ pr_expiry varbinary(14) NULL,
PRIMARY KEY pr_pagetype (pr_page,pr_type),
@@ -19,4 +19,4 @@ CREATE TABLE /*$wgDBprefix*/page_restrictions (
KEY pr_typelevel (pr_type,pr_level),
KEY pr_level (pr_level),
KEY pr_cascade (pr_cascade)
-) /*$wgDBTableOptions*/; \ No newline at end of file
+) /*$wgDBTableOptions*/;