aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormegamage <none@none>2009-03-28 17:54:44 -0600
committermegamage <none@none>2009-03-28 17:54:44 -0600
commitbf1cb43b3aebb217b9d0a957348b0ea6b306e33e (patch)
tree912cd24157c9f5161700da59aa3374d041ef60f5
parentb1c5d4c59352d6030e0869775f2b439d58cd436d (diff)
parent34c0777ff2b28b2423904719791a13ae76127e6f (diff)
*Merge.
--HG-- branch : trunk
-rw-r--r--sql/updates/2274_mangos_7558_01_world_trinity_string.sql (renamed from sql/updates/7558_01_mangos_mangos_string.sql)8
-rw-r--r--sql/updates/2274_mangos_7558_02_world_command.sql (renamed from sql/updates/7558_02_mangos_command.sql)5
-rw-r--r--sql/updates/2276_mangos_7560_01_world_gameobject_template.sql4
-rw-r--r--sql/updates/7560_01_mangos_gameobject_template.sql4
4 files changed, 10 insertions, 11 deletions
diff --git a/sql/updates/7558_01_mangos_mangos_string.sql b/sql/updates/2274_mangos_7558_01_world_trinity_string.sql
index c0b856a9814..a7776d74e35 100644
--- a/sql/updates/7558_01_mangos_mangos_string.sql
+++ b/sql/updates/2274_mangos_7558_01_world_trinity_string.sql
@@ -1,9 +1,9 @@
-ALTER TABLE db_version CHANGE COLUMN required_7544_01_mangos_uptime required_7558_01_mangos_mangos_string bit;
+/*ALTER TABLE db_version CHANGE COLUMN required_7544_01_mangos_uptime required_7558_01_mangos_mangos_string bit;*/
-DELETE FROM mangos_string WHERE entry IN (1123,1124,1125,1126,1127);
-INSERT INTO mangos_string VALUES
+DELETE FROM `trinity_string` WHERE `entry` IN (1123,1124,1125,1126,1127);
+INSERT INTO `trinity_string` VALUES
(1123,'Not pet found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1124,'Wrong pet type',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1125,'Your pet learned all talents',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1126,'Your pet talents have been reset.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(1127,'Talents of %s\'s pet reset.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+(1127,'Talents of %s\'s pet reset.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); \ No newline at end of file
diff --git a/sql/updates/7558_02_mangos_command.sql b/sql/updates/2274_mangos_7558_02_world_command.sql
index cd5b2ff89bf..b5e4558cada 100644
--- a/sql/updates/7558_02_mangos_command.sql
+++ b/sql/updates/2274_mangos_7558_02_world_command.sql
@@ -1,6 +1,5 @@
-ALTER TABLE db_version CHANGE COLUMN required_7558_01_mangos_mangos_string required_7558_02_mangos_command bit;
+/*ALTER TABLE db_version CHANGE COLUMN required_7558_01_mangos_mangos_string required_7558_02_mangos_command bit;*/
DELETE FROM `command` WHERE `name` IN ('learn all_mypettalents');
-
INSERT INTO `command` VALUES
-('learn all_mypettalents',3,'Syntax: .learn all_mypettalents\r\n\r\nLearn all talents for your pet available for his creature type (only for hunter pets).');
+('learn all_mypettalents',3,'Syntax: .learn all_mypettalents\r\n\r\nLearn all talents for your pet available for his creature type (only for hunter pets).'); \ No newline at end of file
diff --git a/sql/updates/2276_mangos_7560_01_world_gameobject_template.sql b/sql/updates/2276_mangos_7560_01_world_gameobject_template.sql
new file mode 100644
index 00000000000..dd99f3820e4
--- /dev/null
+++ b/sql/updates/2276_mangos_7560_01_world_gameobject_template.sql
@@ -0,0 +1,4 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7558_02_mangos_command required_7560_01_mangos_gameobject_template bit;*/
+
+ALTER TABLE gameobject_template
+ ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name; \ No newline at end of file
diff --git a/sql/updates/7560_01_mangos_gameobject_template.sql b/sql/updates/7560_01_mangos_gameobject_template.sql
deleted file mode 100644
index f980687c777..00000000000
--- a/sql/updates/7560_01_mangos_gameobject_template.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_7558_02_mangos_command required_7560_01_mangos_gameobject_template bit;
-
-ALTER TABLE gameobject_template
- ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name;