diff options
Diffstat (limited to 'www/wiki/maintenance/archives/patch-tc-timestamp.sql')
-rw-r--r-- | www/wiki/maintenance/archives/patch-tc-timestamp.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-tc-timestamp.sql b/www/wiki/maintenance/archives/patch-tc-timestamp.sql new file mode 100644 index 00000000..3f7dde41 --- /dev/null +++ b/www/wiki/maintenance/archives/patch-tc-timestamp.sql @@ -0,0 +1,4 @@ +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(ul_key) VALUES ('convert transcache field'); |