diff options
| author | OverlordQ <overlordq@users.mediawiki.org> | 2009-12-10 10:10:56 +0000 |
|---|---|---|
| committer | OverlordQ <overlordq@users.mediawiki.org> | 2009-12-10 10:10:56 +0000 |
| commit | 7f5332a3b7c3fcfd92a06257589f3afbfb0b5236 (patch) | |
| tree | 6eae2910626662d82018833cc5d1d131ef90d51e | |
| parent | ff2d149795a4df0304e26aa2578826376f0b5455 (diff) | |
| download | mediawikicore-7f5332a3b7c3fcfd92a06257589f3afbfb0b5236.tar.gz mediawikicore-7f5332a3b7c3fcfd92a06257589f3afbfb0b5236.zip | |
Addendum to r59925, fix remaining straggling files that set rc_time to int
Notes
Notes:
http://mediawiki.org/wiki/Special:Code/MediaWiki/59926
| -rw-r--r-- | maintenance/archives/patch-tc-timestamp.sql | 2 | ||||
| -rw-r--r-- | maintenance/archives/patch-transcache.sql | 2 | ||||
| -rw-r--r-- | maintenance/sqlite/archives/initial-indexes.sql | 2 | ||||
| -rw-r--r-- | maintenance/sqlite/archives/patch-tc-timestamp.sql | 2 | ||||
| -rw-r--r-- | 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 45fe13f98f47..4d90cf34cf79 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 d07316972c61..70870efa7a52 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 25f90977e6ac..9c038a1a53b0 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 45fe13f98f47..4d90cf34cf79 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 98ff908ec03d..4d926c215c1c 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" ); } |