diff options
| author | megamage <none@none> | 2008-12-26 21:45:02 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2008-12-26 21:45:02 -0600 |
| commit | 566ed175e46809c92070682ac0c478401debb76c (patch) | |
| tree | e42969de0589f531e54ef240d6ce4904ab7c78d0 /sql/updates | |
| parent | ce5d6610616a9b5f5ce625332ed26cd7b4f455e5 (diff) | |
*Some fix. Finally usable.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/TBC-WLK_world.sql | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/sql/updates/TBC-WLK_world.sql b/sql/updates/TBC-WLK_world.sql index 7ab1d9bf556..8c3cf1ffed3 100644 --- a/sql/updates/TBC-WLK_world.sql +++ b/sql/updates/TBC-WLK_world.sql @@ -9,19 +9,20 @@ alter table `creature_equip_template` change `equipmodel1` `equipentry1` mediumint(8) UNSIGNED default '0' NOT NULL, change `equipmodel2` `equipentry2` mediumint(8) UNSIGNED default '0' NOT NULL, change `equipmodel3` `equipentry3` mediumint(8) UNSIGNED default '0' NOT NULL; +update `creature_template` set equipment_id = 0; 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`, - change `Duration` `Duration` int(11) NOT NULL default '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time' after ArmorDamageModifier; - add column `StatsCount` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `ContainerSlots`; - CHANGE COLUMN `TotemCategory` `TotemCategory` mediumint(9) NOT NULL default '0'; + change `Duration` `Duration` int(11) NOT NULL default '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time' after ArmorDamageModifier, + add column `StatsCount` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `ContainerSlots`, + CHANGE COLUMN `TotemCategory` `TotemCategory` mediumint(9) NOT NULL default '0'; 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`; + add column `BonusTalents` tinyint(3) UNSIGNED DEFAULT '0' NOT NULL after `PlayersSlain`, CHANGE `RewHonorableKills` `RewHonorableKills` int unsigned NOT NULL default '0'; DROP TABLE IF EXISTS `milling_loot_template`; |