Addendum to r59925, fix remaining straggling files that set rc_time to int

diff --git a/maintenance/archives/patch-tc-timestamp.sql b/maintenance/archives/patch-tc-timestamp.sql
index 45fe13f..4d90cf3 100644 (file)
--- 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 d073169..70870ef 100644 (file)
--- 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 25f9097..9c038a1 100644 (file)
--- 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 45fe13f..4d90cf3 100644 (file)
--- 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 98ff908..4d926c2 100644 (file)
--- 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" );
        }