sharedferret/Sparkle-Turntable-Bot — comment on commit 45c4cb712957ebbf3535d21a4dea3c8cc3af0bfd
File:  line 0
By sharedferret:

If you've already been using the bot and have a database established, this sequence of SQL queries should update your tables to have the new table structures.

ALTER TABLE SONGLIST CHANGE COLUMN started temporary INT(11);
ALTER TABLE SONGLIST ADD COLUMN started DATETIME;
UPDATE SONGLIST SET started = FROM_UNIXTIME(temporary);
ALTER TABLE SONGLIST DROP COLUMN temporary;
ALTER TABLE CHATLOG ADD COLUMN time DATETIME;