diff options
| -rw-r--r-- | sql/updates/6805_characters_characters.sql | 16 |
1 files changed, 0 insertions, 16 deletions
diff --git a/sql/updates/6805_characters_characters.sql b/sql/updates/6805_characters_characters.sql deleted file mode 100644 index 6004625a69e..00000000000 --- a/sql/updates/6805_characters_characters.sql +++ /dev/null @@ -1,16 +0,0 @@ -UPDATE characters SET data = REPLACE(data,' ',' '); -UPDATE characters SET data = CONCAT(TRIM(data),' '); - -UPDATE `characters` SET `data` = CONCAT( - SUBSTRING_INDEX(`data`, ' ', 1167 + 1), ' ', - '0 0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1246 + 1), ' ', -1246 + 1168 - 1), ' ', - '0 0 0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1294 + 1), ' ', -1294 + 1247 - 1), ' ', - '0 ' - ) -WHERE length(SUBSTRING_INDEX(data, ' ', 1294)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 1294+1)) >= length(data); - -UPDATE characters SET data = REPLACE(data,' ',' '); -UPDATE characters SET data = CONCAT(TRIM(data),' '); - |