From a882348d84acadc5966a89cfe06a1f3eaa7c2c1d Mon Sep 17 00:00:00 2001
From: Aryeh Gregor <simetrical@users.mediawiki.org>
Date: Sun, 16 Dec 2007 21:27:57 +0000
Subject: [PATCH] (bug 12314) r28417 kind of left out tables.sql . . . changed
 pt_by to pt_user and removed pt_user index from tables.sql.  This fixes
 MySQL, PostgreSQL still needs to be fixed.

---
 maintenance/tables.sql | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 2febaaffae..6282f52287 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -1172,13 +1172,12 @@ CREATE TABLE /*$wgDBprefix*/page_restrictions (
 CREATE TABLE /*$wgDBprefix*/protected_titles (
   pt_namespace int NOT NULL,
   pt_title varchar(255) NOT NULL,
-  pt_by int unsigned 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_by (pt_by),
   KEY pt_timestamp (pt_timestamp)
 ) /*$wgDBTableOptions*/;
 
-- 
2.20.1