From 9fa6709264c0ed0c920c7f13dd2eded70f5f1fd7 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Thu, 13 Dec 2007 18:16:43 +0000 Subject: [PATCH] Fix wgDBprefix name, remove backslashes, remove zerofill column stuff, fix spacing. --- maintenance/tables.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 32f5d6d513..2febaaffae 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1169,16 +1169,16 @@ CREATE TABLE /*$wgDBprefix*/page_restrictions ( ) /*$wgDBTableOptions*/; -- Protected titles - nonexistent pages that have been protected -CREATE TABLE /*$wgDBPrefix*/protected_titles ( - pt_namespace int(11) NOT NULL, +CREATE TABLE /*$wgDBprefix*/protected_titles ( + pt_namespace int NOT NULL, pt_title varchar(255) NOT NULL, - pt_by int(10) unsigned NOT NULL, + pt_by 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), + PRIMARY KEY (pt_namespace,pt_title), + KEY pt_by (pt_by), KEY pt_timestamp (pt_timestamp) ) /*$wgDBTableOptions*/; -- 2.20.1