From ff2d149795a4df0304e26aa2578826376f0b5455 Mon Sep 17 00:00:00 2001 From: OverlordQ Date: Thu, 10 Dec 2009 05:39:45 +0000 Subject: [PATCH] Followup to r59869, add to MySQL section, and copy patch to SQLite directory --- maintenance/sqlite/archives/patch-tc-timestamp.sql | 4 ++++ maintenance/tables.sql | 2 +- maintenance/updaters.inc | 1 + 3 files changed, 6 insertions(+), 1 deletion(-) create mode 100644 maintenance/sqlite/archives/patch-tc-timestamp.sql diff --git a/maintenance/sqlite/archives/patch-tc-timestamp.sql b/maintenance/sqlite/archives/patch-tc-timestamp.sql new file mode 100644 index 0000000000..45fe13f98f --- /dev/null +++ b/maintenance/sqlite/archives/patch-tc-timestamp.sql @@ -0,0 +1,4 @@ +ALTER TABLE /*_*/transcache MODIFY tc_time varchar(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/tables.sql b/maintenance/tables.sql index e8b0e1a5e7..66d452007f 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1095,7 +1095,7 @@ CREATE INDEX /*i*/exptime ON /*_*/objectcache (exptime); 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/updaters.inc b/maintenance/updaters.inc index bdda7f35a5..98ff908ec0 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -165,6 +165,7 @@ $wgUpdates = array( array( 'add_index', 'log_search', 'ls_field_val', 'patch-log_search-rename-index.sql' ), array( 'add_index', 'change_tag', 'change_tag_rc_tag', 'patch-change_tag-indexes.sql' ), array( 'add_field', 'redirect', 'rd_interwiki', 'patch-rd_interwiki.sql' ), + array( 'do_update_transcache_field' ), // A field changed name mid-release cycle, so fix it for anyone using // trunk array( 'rename_eu_wiki_id' ), -- 2.20.1