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