diff options
| author | Muhaha <none@none> | 2009-02-06 10:55:23 +0100 |
|---|---|---|
| committer | Muhaha <none@none> | 2009-02-06 10:55:23 +0100 |
| commit | e0b3d67c1e32fd1aca6d39fa99dc952ff04fbc90 (patch) | |
| tree | 980c6643b4220956e22ded665d19fd00dbe77821 | |
| parent | bb190b285984e6a507c6a94d2a3664e3828c81af (diff) | |
* Update sql to proper table structure
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/875_(mangos_7047)_01_characters_character_spell.sql | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/sql/updates/875_(mangos_7047)_01_characters_character_spell.sql b/sql/updates/875_(mangos_7047)_01_characters_character_spell.sql index 71c7ee79e3b..acced8e0b6e 100644 --- a/sql/updates/875_(mangos_7047)_01_characters_character_spell.sql +++ b/sql/updates/875_(mangos_7047)_01_characters_character_spell.sql @@ -1,5 +1,6 @@ /*ALTER TABLE character_db_version CHANGE COLUMN required_6976_02_characters_character_db_version required_7047_01_characters_character_spell bit;*/ +/* ERROR 1136 (21S01) at line 4: Column count doesn't match value count at row 1 DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); INSERT INTO character_spell SELECT characters.guid as guid, 28880, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1; INSERT INTO character_spell SELECT characters.guid as guid, 59542, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2; @@ -7,4 +8,15 @@ INSERT INTO character_spell SELECT characters.guid as guid, 59543, 4294967295, 1 INSERT INTO character_spell SELECT characters.guid as guid, 59544, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5; INSERT INTO character_spell SELECT characters.guid as guid, 59545, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6; INSERT INTO character_spell SELECT characters.guid as guid, 59547, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7; -INSERT INTO character_spell SELECT characters.guid as guid, 59548, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8;
\ No newline at end of file +INSERT INTO character_spell SELECT characters.guid as guid, 59548, 4294967295, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8; +*/ + +/* same query , without character_spell.slot*/ +DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548); +INSERT INTO character_spell SELECT characters.guid as guid, 28880, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1; +INSERT INTO character_spell SELECT characters.guid as guid, 59542, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2; +INSERT INTO character_spell SELECT characters.guid as guid, 59543, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 3; +INSERT INTO character_spell SELECT characters.guid as guid, 59544, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5; +INSERT INTO character_spell SELECT characters.guid as guid, 59545, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6; +INSERT INTO character_spell SELECT characters.guid as guid, 59547, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7; +INSERT INTO character_spell SELECT characters.guid as guid, 59548, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8; |