diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-05-12 00:08:00 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-05-18 15:51:42 +0100 |
| commit | e6e3174d9a869fac2df7c6bbd6ebcdbabfdd1509 (patch) | |
| tree | d3cdc0aafb61ecc85496af4ee9f2911c43cd561a /sql/old/3.3.3a | |
| parent | e0bdefb54f21143ad406b833ee509b1030c4fd87 (diff) | |
DB/SQL: No tabs nor CR line feeds
Diffstat (limited to 'sql/old/3.3.3a')
| -rw-r--r-- | sql/old/3.3.3a/07893_characters_item_instance.sql | 4 | ||||
| -rw-r--r-- | sql/old/3.3.3a/07923_characters_characters.sql | 3 |
2 files changed, 3 insertions, 4 deletions
diff --git a/sql/old/3.3.3a/07893_characters_item_instance.sql b/sql/old/3.3.3a/07893_characters_item_instance.sql index 3dea7f98e27..9eeef845f40 100644 --- a/sql/old/3.3.3a/07893_characters_item_instance.sql +++ b/sql/old/3.3.3a/07893_characters_item_instance.sql @@ -2,8 +2,8 @@ UPDATE item_instance SET data = REPLACE(data,' ',' '); UPDATE item_instance SET data = CONCAT(TRIM(data),' '); UPDATE `item_instance` SET `data` = CONCAT( - SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ', - SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ') + SUBSTRING_INDEX(`data`, ' ', 59 + 1), ' ', + SUBSTRING_INDEX(`data`, ' ', -3 -1), '0 ') WHERE length(SUBSTRING_INDEX(data, ' ', 64)) < length(data) and length(SUBSTRING_INDEX(data, ' ', 64+1)) >= length(data); UPDATE item_instance SET data = REPLACE(data,' ',' '); diff --git a/sql/old/3.3.3a/07923_characters_characters.sql b/sql/old/3.3.3a/07923_characters_characters.sql index a9fe4880731..b871727a490 100644 --- a/sql/old/3.3.3a/07923_characters_characters.sql +++ b/sql/old/3.3.3a/07923_characters_characters.sql @@ -1,2 +1 @@ -ALTER TABLE characters - ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER knownTitles; +ALTER TABLE `characters` ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER `knownTitles`; |