diff options
| author | Max Semenik <maxsem@users.mediawiki.org> | 2009-12-10 17:42:12 +0000 |
|---|---|---|
| committer | Max Semenik <maxsem@users.mediawiki.org> | 2009-12-10 17:42:12 +0000 |
| commit | 5445d274c10c12068333297b365fd25de2a9104d (patch) | |
| tree | 56816e88dc53ad01f4b7b0665852938e9f2be8b0 /maintenance/sqlite/archives/patch-tc-timestamp.sql | |
| parent | 7f5332a3b7c3fcfd92a06257589f3afbfb0b5236 (diff) | |
| download | mediawikicore-5445d274c10c12068333297b365fd25de2a9104d.tar.gz mediawikicore-5445d274c10c12068333297b365fd25de2a9104d.zip | |
Fixed updater borkage on SQLite from r59925 and r59926, tweaked explanation for this change in updaters.inc for portability. See my comments for these revisions in CodeReview for motivation.
Notes
Notes:
http://mediawiki.org/wiki/Special:Code/MediaWiki/59932
Diffstat (limited to 'maintenance/sqlite/archives/patch-tc-timestamp.sql')
| -rw-r--r-- | maintenance/sqlite/archives/patch-tc-timestamp.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/maintenance/sqlite/archives/patch-tc-timestamp.sql b/maintenance/sqlite/archives/patch-tc-timestamp.sql index 4d90cf34cf79..8e54da2e5a2a 100644 --- a/maintenance/sqlite/archives/patch-tc-timestamp.sql +++ b/maintenance/sqlite/archives/patch-tc-timestamp.sql @@ -1,4 +1,3 @@ -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"); +UPDATE /*_*/transcache SET tc_time = strftime('%Y%m%d%H%M%S', datetime(1260465428, 'unixepoch')); INSERT INTO /*_*/updatelog VALUES ('convert transcache field'); |