aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2011-03-22 01:08:36 +0000
committerNay <dnpd.dd@gmail.com>2011-03-22 01:08:36 +0000
commit3d7232b98ec9e3d3a7d392bb93a08ad3137dfa41 (patch)
tree4d9edf45ed3b6a03018e3abf7b862e90d4df27b2
parent63508fd628468c7a09f3e0cf370c81bc7dd3c64c (diff)
SQL: Correct a typo and kill a DB startup error
-rw-r--r--sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql6
-rw-r--r--sql/updates/world/2011_03_21_8_world_spell_required.sql1
2 files changed, 4 insertions, 3 deletions
diff --git a/sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql b/sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql
index 942207d6d9d..2a95cb57206 100644
--- a/sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql
+++ b/sql/updates/world/2011_03_21_3_world_achievement_criteria_data.sql
@@ -11,19 +11,19 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value
(11685,12,0,0, ''),
(11686,12,0,0, ''),
(11687,12,0,0, ''),
-(11688,12,0,0, '');
+(11688,12,0,0, ''),
-- Call of the Crusade (25 player)
(11679,12,1,0, ''),
(11680,12,1,0, ''),
(11681,12,1,0, ''),
(11682,12,1,0, ''),
-(11683,12,1,0, '');
+(11683,12,1,0, ''),
-- Call of the Grand Crusade (10 player)
(11689,12,2,0, ''),
(11690,12,2,0, ''),
(11691,12,2,0, ''),
(11692,12,2,0, ''),
-(11693,12,2,0, '');
+(11693,12,2,0, ''),
-- Call of the Grand Crusade (25 player)
(11542,12,3,0, ''),
(11546,12,3,0, ''),
diff --git a/sql/updates/world/2011_03_21_8_world_spell_required.sql b/sql/updates/world/2011_03_21_8_world_spell_required.sql
new file mode 100644
index 00000000000..1c6e207127b
--- /dev/null
+++ b/sql/updates/world/2011_03_21_8_world_spell_required.sql
@@ -0,0 +1 @@
+DELETE FROM `spell_required` WHERE `spell_id`=40120;