From 7f5332a3b7c3fcfd92a06257589f3afbfb0b5236 Mon Sep 17 00:00:00 2001 From: OverlordQ Date: Thu, 10 Dec 2009 10:10:56 +0000 Subject: [PATCH] Addendum to r59925, fix remaining straggling files that set rc_time to int --- maintenance/archives/patch-tc-timestamp.sql | 2 +- maintenance/archives/patch-transcache.sql | 2 +- maintenance/sqlite/archives/initial-indexes.sql | 2 +- maintenance/sqlite/archives/patch-tc-timestamp.sql | 2 +- maintenance/updaters.inc | 2 +- 5 files changed, 5 insertions(+), 5 deletions(-) diff --git a/maintenance/archives/patch-tc-timestamp.sql b/maintenance/archives/patch-tc-timestamp.sql index 45fe13f98f..4d90cf34cf 100644 --- a/maintenance/archives/patch-tc-timestamp.sql +++ b/maintenance/archives/patch-tc-timestamp.sql @@ -1,4 +1,4 @@ -ALTER TABLE /*_*/transcache MODIFY tc_time varchar(14); +ALTER TABLE /*_*/transcache MODIFY tc_time binary(14); UPDATE /*_*/transcache SET tc_time = DATE_FORMAT(FROM_UNIXTIME(tc_time), "%Y%c%d%H%i%s"); INSERT INTO /*_*/updatelog VALUES ('convert transcache field'); diff --git a/maintenance/archives/patch-transcache.sql b/maintenance/archives/patch-transcache.sql index d07316972c..70870efa7a 100644 --- a/maintenance/archives/patch-transcache.sql +++ b/maintenance/archives/patch-transcache.sql @@ -1,7 +1,7 @@ CREATE TABLE /*$wgDBprefix*/transcache ( tc_url varbinary(255) NOT NULL, tc_contents TEXT, - tc_time INT NOT NULL, + tc_time binary(14) NOT NULL, UNIQUE INDEX tc_url_idx(tc_url) ) /*$wgDBTableOptions*/; diff --git a/maintenance/sqlite/archives/initial-indexes.sql b/maintenance/sqlite/archives/initial-indexes.sql index 25f90977e6..9c038a1a53 100644 --- a/maintenance/sqlite/archives/initial-indexes.sql +++ b/maintenance/sqlite/archives/initial-indexes.sql @@ -352,7 +352,7 @@ DROP TABLE IF EXISTS /*_*/transcache; CREATE TABLE /*_*/transcache ( tc_url varbinary(255) NOT NULL, tc_contents text, - tc_time int NOT NULL + tc_time binary(14) NOT NULL ) /*$wgDBTableOptions*/; CREATE UNIQUE INDEX /*i*/tc_url_idx ON /*_*/transcache (tc_url); diff --git a/maintenance/sqlite/archives/patch-tc-timestamp.sql b/maintenance/sqlite/archives/patch-tc-timestamp.sql index 45fe13f98f..4d90cf34cf 100644 --- a/maintenance/sqlite/archives/patch-tc-timestamp.sql +++ b/maintenance/sqlite/archives/patch-tc-timestamp.sql @@ -1,4 +1,4 @@ -ALTER TABLE /*_*/transcache MODIFY tc_time varchar(14); +ALTER TABLE /*_*/transcache MODIFY tc_time binary(14); UPDATE /*_*/transcache SET tc_time = DATE_FORMAT(FROM_UNIXTIME(tc_time), "%Y%c%d%H%i%s"); INSERT INTO /*_*/updatelog VALUES ('convert transcache field'); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 98ff908ec0..4d926c215c 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1350,7 +1350,7 @@ function do_update_transcache_field() { wfOut( "...transcache tc_time already converted.\n" ); return; } else { - wfOut( "Converting tc_time from int(11) to varchar(13)... " ); + wfOut( "Converting tc_time from int(11) to binary(14)... " ); $wgDatabase->sourceFile( archive( 'patch-tc-timestamp.sql' ) ); wfOut( "ok\n" ); } -- 2.20.1