diff options
| author | Drahy <none@none> | 2009-03-04 09:19:13 +0100 |
|---|---|---|
| committer | Drahy <none@none> | 2009-03-04 09:19:13 +0100 |
| commit | 19ce0bb39ff3d4d5568410e29fa5372623735fbb (patch) | |
| tree | 7b6fa2ec26e07ff769451425e1a319f2f6ce0f15 | |
| parent | 7a44a9fb93da026a8e639084c76c7ca0696a6a07 (diff) | |
* Fixed sql updates, renamed and cleaned up
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/1618_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/1657_world.sql | 4 | ||||
| -rw-r--r-- | sql/updates/1661_world.sql (renamed from sql/updates/1671_world.sql) | 2 | ||||
| -rw-r--r-- | sql/updates/1663_mangos_7376_01_world_spell_area.sql | 4 | ||||
| -rw-r--r-- | sql/updates/7376_01_mangos_spell_area.sql | 4 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 2 |
6 files changed, 10 insertions, 8 deletions
diff --git a/sql/updates/1618_world.sql b/sql/updates/1618_world.sql index 0f08c98b6ae..a07dd31f630 100644 --- a/sql/updates/1618_world.sql +++ b/sql/updates/1618_world.sql @@ -3,4 +3,4 @@ INSERT INTO `spell_proc_event` VALUES (55672, 0x00, 6, 0x00000001, 0x00000000, 0 -- Bloodsurge DELETE FROM `spell_proc_event` WHERE `entry` IN (46915); -INSERT INTO `spell_proc_event` VALUES (46915, 0x00, 4, 0x00000040, 0x00000404, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0); +INSERT INTO `spell_proc_event` VALUES (46915, 0x00, 4, 0x00000040, 0x00000404, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/1657_world.sql b/sql/updates/1657_world.sql index ca31075612f..009a4079ddb 100644 --- a/sql/updates/1657_world.sql +++ b/sql/updates/1657_world.sql @@ -1,2 +1,2 @@ -DELETE FROM trinity_string where entry=1010; -INSERT INTO trinity_string (entry, content_default) VALUES(1010, "| Account | Character | IP | GM | EXP |"); +DELETE FROM `trinity_string` WHERE `entry`=1010; +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES(1010, "| Account | Character | IP | GM | EXP |");
\ No newline at end of file diff --git a/sql/updates/1671_world.sql b/sql/updates/1661_world.sql index 55a7ef6aae4..fc7d072ac39 100644 --- a/sql/updates/1671_world.sql +++ b/sql/updates/1661_world.sql @@ -1,2 +1,2 @@ --Death Strike -INSERT INTO `spell_proc_event` VALUES (45469, 0x00, 15, 0x00000010, 0x00000000, 0x00000000, 0x00000010, 0x00000000, 0.000000, 0.000000, 0); +INSERT INTO `spell_proc_event` VALUES (45469, 0x00, 15, 0x00000010, 0x00000000, 0x00000000, 0x00000010, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/1663_mangos_7376_01_world_spell_area.sql b/sql/updates/1663_mangos_7376_01_world_spell_area.sql new file mode 100644 index 00000000000..943d79d4b72 --- /dev/null +++ b/sql/updates/1663_mangos_7376_01_world_spell_area.sql @@ -0,0 +1,4 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7369_01_mangos_quest_template required_7376_01_mangos_spell_area bit;*/ + +ALTER TABLE spell_area + CHANGE COLUMN `aura_spell` `aura_spell` mediumint(8) NOT NULL default '0';
\ No newline at end of file diff --git a/sql/updates/7376_01_mangos_spell_area.sql b/sql/updates/7376_01_mangos_spell_area.sql deleted file mode 100644 index 5a3aadd682d..00000000000 --- a/sql/updates/7376_01_mangos_spell_area.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE db_version CHANGE COLUMN required_7369_01_mangos_quest_template required_7376_01_mangos_spell_area bit; - -ALTER TABLE spell_area - CHANGE COLUMN `aura_spell` `aura_spell` mediumint(8) NOT NULL default '0'; diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index d2652bb6f72..47ddcbf145f 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -57,4 +57,6 @@ INSTALL(FILES 1646_mangos_7369_01_world_quest_template.sql 1654_world.sql 1657_world.sql +1661_world.sql +1663_mangos_7376_01_world_spell_area.sql DESTINATION share/trinity/sql/updates) |