sql/updates/0.16/09646_01_characters_characters.sql

   1 ALTER TABLE character_db_version CHANGE COLUMN required_9635_01_characters_characters required_9646_01_characters_characters bit;
   2
   3 UPDATE characters, data_backup
   4 SET characters.knownTitles = SUBSTRING(data_backup.data,
   5 length(SUBSTRING_INDEX(data_backup.data, ' ', 626))+2,
   6 length(SUBSTRING_INDEX(data_backup.data, ' ', 631+1))- length(SUBSTRING_INDEX(data_backup.data, ' ', 626)) - 1)
   7 WHERE characters.guid=data_backup.guid;