Followup to r59869, add to MySQL section, and copy patch to SQLite directory
[lhc/web/wiklou.git] / maintenance / sqlite / archives / patch-tc-timestamp.sql
1 ALTER TABLE /*_*/transcache MODIFY tc_time varchar(14);
2 UPDATE /*_*/transcache SET tc_time = DATE_FORMAT(FROM_UNIXTIME(tc_time), "%Y%c%d%H%i%s");
3
4 INSERT INTO /*_*/updatelog VALUES ('convert transcache field');