From fb45a6a8eca86682220ce825b09ac0a63dcc9628 Mon Sep 17 00:00:00 2001 From: Brian Date: Sat, 26 Dec 2009 23:27:10 -0700 Subject: * Remove char conversion SQL from 6805 * Only intended to update original conversion SQL --HG-- branch : trunk --- sql/updates/6805_characters_characters.sql | 16 ---------------- 1 file changed, 16 deletions(-) delete mode 100644 sql/updates/6805_characters_characters.sql (limited to 'sql') 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),' '); - -- cgit v1.2.3