diff options
Diffstat (limited to 'maintenance/sqlite/archives/patch-tc-timestamp.sql')
| -rw-r--r-- | maintenance/sqlite/archives/patch-tc-timestamp.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/maintenance/sqlite/archives/patch-tc-timestamp.sql b/maintenance/sqlite/archives/patch-tc-timestamp.sql index 45fe13f98f47..4d90cf34cf79 100644 --- a/maintenance/sqlite/archives/patch-tc-timestamp.sql +++ b/maintenance/sqlite/archives/patch-tc-timestamp.sql @@ -1,4 +1,4 @@ -ALTER TABLE /*_*/transcache MODIFY tc_time varchar(14); +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'); |