Pass column as string to IDatabase::selectField

[lhc/web/wiklou.git] / maintenance / archives / patch-page_restrictions.sql

diff --git a/maintenance/archives/patch-page_restrictions.sql b/maintenance/archives/patch-page_restrictions.sql
index eb80527..6813c1e 100644 (file)
--- a/maintenance/archives/patch-page_restrictions.sql
+++ b/maintenance/archives/patch-page_restrictions.sql
@@ -1,22 +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(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_page,pr_type),
-
-       KEY pr_page (pr_page),
+       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)
-) TYPE=InnoDB;
\ No newline at end of file
+) /*$wgDBTableOptions*/;