diff options
| author | Brian <runningnak3d@gmail.com> | 2010-03-02 20:17:51 -0700 |
|---|---|---|
| committer | Brian <runningnak3d@gmail.com> | 2010-03-02 20:17:51 -0700 |
| commit | c9488f5ebe685eab9ea7a7b0071bf44cf0b1c56c (patch) | |
| tree | 8887fb001f371e80a4d3bf0c02b62ea7d4700a34 | |
| parent | c89ccd614991f099ebff2370f0c8e0bdbc37345d (diff) | |
* Fix blob conversion SQL to allow for proper value for watchedFaction
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/7472_characters_characters.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/updates/7472_characters_characters.sql b/sql/updates/7472_characters_characters.sql index 923798a27c1..4cb83f0355c 100644 --- a/sql/updates/7472_characters_characters.sql +++ b/sql/updates/7472_characters_characters.sql @@ -8,7 +8,7 @@ ALTER TABLE characters ADD COLUMN `yesterdayKills` smallint(5) UNSIGNED NOT NULL default '0' AFTER todayKills, ADD COLUMN `chosenTitle` int(10) UNSIGNED NOT NULL default '0' AFTER yesterdayKills, ADD COLUMN `knownCurrencies` bigint(20) UNSIGNED NOT NULL default '0' AFTER chosenTitle, - ADD COLUMN `watchedFaction` int(10) NOT NULL default '0' AFTER knownCurrencies, + ADD COLUMN `watchedFaction` bigint(10) NOT NULL default '0' AFTER knownCurrencies, ADD COLUMN `drunk` smallint(5) UNSIGNED NOT NULL default '0' AFTER watchedFaction, ADD COLUMN `health` int(10) UNSIGNED NOT NULL default '0' AFTER drunk, ADD COLUMN `power1` int(10) UNSIGNED NOT NULL default '0' AFTER health, @@ -60,4 +60,4 @@ UPDATE characters SET SUBSTRING(data, length(SUBSTRING_INDEX(data, ' ', 30))+2, length(SUBSTRING_INDEX(data, ' ', 30+1))- length(SUBSTRING_INDEX(data, ' ', 30)) - 1); ALTER TABLE characters - DROP COLUMN arena_pending_points;
\ No newline at end of file + DROP COLUMN arena_pending_points; |