From 19ce0bb39ff3d4d5568410e29fa5372623735fbb Mon Sep 17 00:00:00 2001
From: Drahy <none@none>
Date: Wed, 4 Mar 2009 09:19:13 +0100
Subject: * Fixed sql updates, renamed and cleaned up

--HG--
branch : trunk
---
 sql/updates/1618_world.sql                           | 2 +-
 sql/updates/1657_world.sql                           | 4 ++--
 sql/updates/1661_world.sql                           | 2 ++
 sql/updates/1663_mangos_7376_01_world_spell_area.sql | 4 ++++
 sql/updates/1671_world.sql                           | 2 --
 sql/updates/7376_01_mangos_spell_area.sql            | 4 ----
 sql/updates/CMakeLists.txt                           | 2 ++
 7 files changed, 11 insertions(+), 9 deletions(-)
 create mode 100644 sql/updates/1661_world.sql
 create mode 100644 sql/updates/1663_mangos_7376_01_world_spell_area.sql
 delete mode 100644 sql/updates/1671_world.sql
 delete mode 100644 sql/updates/7376_01_mangos_spell_area.sql

(limited to 'sql')

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/1661_world.sql b/sql/updates/1661_world.sql
new file mode 100644
index 00000000000..fc7d072ac39
--- /dev/null
+++ b/sql/updates/1661_world.sql
@@ -0,0 +1,2 @@
+--Death Strike
+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/1671_world.sql b/sql/updates/1671_world.sql
deleted file mode 100644
index 55a7ef6aae4..00000000000
--- a/sql/updates/1671_world.sql
+++ /dev/null
@@ -1,2 +0,0 @@
---Death Strike
-INSERT INTO `spell_proc_event` VALUES (45469, 0x00, 15, 0x00000010, 0x00000000, 0x00000000, 0x00000010, 0x00000000, 0.000000, 0.000000, 0);
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)
-- 
cgit v1.2.3