aboutsummaryrefslogtreecommitdiffstats
path: root/maintenance/sqlite/archives/patch-tc-timestamp.sql
diff options
context:
space:
mode:
authorOverlordQ <overlordq@users.mediawiki.org>2009-12-10 05:39:45 +0000
committerOverlordQ <overlordq@users.mediawiki.org>2009-12-10 05:39:45 +0000
commitff2d149795a4df0304e26aa2578826376f0b5455 (patch)
treed5d644a0b52f2b72a4169c367489ab5e97cac5aa /maintenance/sqlite/archives/patch-tc-timestamp.sql
parent984be432fc9696c3c65008be07061974b70c70e2 (diff)
downloadmediawikicore-ff2d149795a4df0304e26aa2578826376f0b5455.tar.gz
mediawikicore-ff2d149795a4df0304e26aa2578826376f0b5455.zip
Followup to r59869, add to MySQL section, and copy patch to SQLite directory
Notes
Notes: http://mediawiki.org/wiki/Special:Code/MediaWiki/59925
Diffstat (limited to 'maintenance/sqlite/archives/patch-tc-timestamp.sql')
-rw-r--r--maintenance/sqlite/archives/patch-tc-timestamp.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/maintenance/sqlite/archives/patch-tc-timestamp.sql b/maintenance/sqlite/archives/patch-tc-timestamp.sql
new file mode 100644
index 000000000000..45fe13f98f47
--- /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');