diff options
| author | Brian <runningnak3d@gmail.com> | 2009-12-26 23:27:10 -0700 |
|---|---|---|
| committer | Brian <runningnak3d@gmail.com> | 2009-12-26 23:27:10 -0700 |
| commit | fb45a6a8eca86682220ce825b09ac0a63dcc9628 (patch) | |
| tree | 4c9ddd88990776a1c8c0d3a6bf15cc8e62a75b82 | |
| parent | 8107c2e2ae45cb95dc32b795197c8bc1253913ff (diff) | |
* Remove char conversion SQL from 6805
* Only intended to update original conversion SQL
--HG--
branch : trunk
| -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),' '); - |