Merge "Add language handling to imageinfo/extmetadata API"

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

diff --git a/maintenance/archives/patch-protected_titles.sql b/maintenance/archives/patch-protected_titles.sql
index da1df17..20b6035 100644 (file)
--- a/maintenance/archives/patch-protected_titles.sql
+++ b/maintenance/archives/patch-protected_titles.sql
@@ -1,13 +1,12 @@
 -- Protected titles - nonexistent pages that have been protected
-CREATE TABLE `/*$wgDBPrefix*/protected_titles` (
-  `pt_namespace` int(11) NOT NULL,
-  `pt_title` varchar(255) NOT NULL,
-  `pt_by` int(10) unsigned NOT NULL,
-  `pt_reason` tinyblob,
-  `pt_timestamp` binary(14) NOT NULL,
-  `pt_expiry` varbinary(14) NOT NULL default '',
-  `pt_create_perm` varbinary(60) NOT NULL,
-  PRIMARY KEY  (`pt_namespace`,`pt_title`),
-  KEY `pt_by` (`pt_by`),
-  KEY `pt_timestamp` (`pt_timestamp`)
-) /*$wgDBTableOptions*/
\ No newline at end of file
+CREATE TABLE /*$wgDBprefix*/protected_titles (
+  pt_namespace int NOT NULL,
+  pt_title varchar(255) binary NOT NULL,
+  pt_user int unsigned NOT NULL,
+  pt_reason tinyblob,
+  pt_timestamp binary(14) NOT NULL,
+  pt_expiry varbinary(14) NOT NULL default '',
+  pt_create_perm varbinary(60) NOT NULL,
+  PRIMARY KEY (pt_namespace,pt_title),
+  KEY pt_timestamp (pt_timestamp)
+) /*$wgDBTableOptions*/;