aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDrahy <none@none>2009-02-04 08:31:30 +0100
committerDrahy <none@none>2009-02-04 08:31:30 +0100
commit8c9bd5e0bd09e592e970e69a793199294ec6e6e1 (patch)
tree819fb8ee37bbb3832273d293cd7df0e7217127a4
parent1c51b382dc6e961edeb4c081748f3ddba96be61b (diff)
Clean up sql files from converter for all sql server versions
--HG-- branch : trunk
-rw-r--r--sql/TBC-WLK converter/TBC-WLK_world.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/sql/TBC-WLK converter/TBC-WLK_world.sql b/sql/TBC-WLK converter/TBC-WLK_world.sql
index c3792ef99f6..ff0b1207f6f 100644
--- a/sql/TBC-WLK converter/TBC-WLK_world.sql
+++ b/sql/TBC-WLK converter/TBC-WLK_world.sql
@@ -34,13 +34,13 @@ CREATE TABLE `locales_achievement_reward` (
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-DELETE FROM battleground_template WHERE id IN (9,10,11);
-INSERT INTO battleground_template VALUES
+DELETE FROM `battleground_template` WHERE id IN (9,10,11);
+INSERT INTO `battleground_template` VALUES
(9,0,0,0,0,1367,0,1368,0),
(10,5,5,10,80,1362,0,1363,0),
(11,5,5,10,80,1364,0,1365,0);
-TRUNCATE creature_equip_template;
+TRUNCATE `creature_equip_template`;
alter table `creature_equip_template`
drop column `equipinfo1`,
drop column `equipinfo2`,
@@ -53,7 +53,7 @@ alter table `creature_equip_template`
change `equipmodel3` `equipentry3` mediumint(8) UNSIGNED default '0' NOT NULL;
update `creature_template` set equipment_id = 0;
-alter table `item_template`
+ALTER TABLE `item_template`
add column `ScalingStatDistribution` smallint(6) DEFAULT '0' NOT NULL after `stat_value10`,
add column `ScalingStatValue` smallint(6) DEFAULT '0' NOT NULL after `ScalingStatDistribution`,
add column `ItemLimitCategory` smallint(6) DEFAULT '0' NOT NULL after `ArmorDamageModifier`,
@@ -71,7 +71,7 @@ ALTER TABLE item_template
UPDATE item_template
SET stackable = -1 WHERE stackable = 0;
-alter table `quest_template`
+ALTER TABLE `quest_template`
add column `PlayersSlain` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `CharTitleId`,
add column `BonusTalents` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `PlayersSlain`,
CHANGE `RewHonorableKills` `RewHonorableKills` int unsigned NOT NULL default '0';