Single change for 1.6.3:
- Fix for newly created MySQL database tables missing the 'online' column; thanks to AxxiD for pointing it out. MySQL tables which are missing that column will retroactively have it added.
IMPORTANT: BREAKING CHANGE for MySQL users: the time_total column type is changed from TIME to INT. The new INT values refer to the number of seconds the user has been online. This was necessary due to TIME columns being limited to roughly 839 hours before being truncated.
Any SQL queries you've written which reference the time_total column will likely need to be updated as a result. For a quick way to get a TIME value like before, you can use something like the SQL "SEC_TO_TIME(`time_total`)" or similar, but again you should note that SQL TIME values are limited to 839 hours before they stop working correctly.
- For MySQL data storage, time_total column type is changed from TIME to INT
As above, existing MySQL users will likely need to update any queries referencing that column.