Removed trailing whitespaces and CRLFs

[getmangos.git] / sql / updates / 0.6 / 2787_item_instance.sql

UPDATE `item_instance`
  SET `data` = CONCAT(`data`,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ')
  WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',3),' ',-1) = 7 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',91),' ',-1) = '';