diff options
| author | Brian <runningnak3d@gmail.com> | 2010-03-24 18:36:46 -0600 |
|---|---|---|
| committer | Brian <runningnak3d@gmail.com> | 2010-03-24 18:36:46 -0600 |
| commit | 808254af5056f17e695876e4d3d11b02b756079c (patch) | |
| tree | 2ff0506ea121a0d666cf4da99aff05769f24b37b | |
| parent | 66a890ca0f6329e53829181894ee9a59f2a1ab08 (diff) | |
* Missed SQL from previous commit
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/7694_world_npc_trainer.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7694_world_npc_vendor.sql | 2 | ||||
| -rw-r--r-- | sql/world.sql | 4 |
3 files changed, 6 insertions, 2 deletions
diff --git a/sql/updates/7694_world_npc_trainer.sql b/sql/updates/7694_world_npc_trainer.sql new file mode 100644 index 00000000000..0e79b01c931 --- /dev/null +++ b/sql/updates/7694_world_npc_trainer.sql @@ -0,0 +1,2 @@ +ALTER TABLE `npc_trainer` MODIFY COLUMN `spell` MEDIUMINT(8) NOT NULL DEFAULT 0; + diff --git a/sql/updates/7694_world_npc_vendor.sql b/sql/updates/7694_world_npc_vendor.sql new file mode 100644 index 00000000000..e2fcff7deb1 --- /dev/null +++ b/sql/updates/7694_world_npc_vendor.sql @@ -0,0 +1,2 @@ +ALTER TABLE `npc_vendor` MODIFY COLUMN `item` MEDIUMINT(8) NOT NULL DEFAULT 0; + diff --git a/sql/world.sql b/sql/world.sql index 903c3a593cc..646a4c6bacb 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -2093,7 +2093,7 @@ DROP TABLE IF EXISTS `game_event_npc_vendor`; CREATE TABLE `game_event_npc_vendor` ( `event` mediumint(8) unsigned NOT NULL DEFAULT '0', `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', - `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) NOT NULL DEFAULT '0', `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0', `incrtime` mediumint(8) unsigned NOT NULL DEFAULT '0', `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0', @@ -3660,7 +3660,7 @@ DROP TABLE IF EXISTS `npc_trainer`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `npc_trainer` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell` mediumint(8) NOT NULL DEFAULT '0', `spellcost` int(10) unsigned NOT NULL DEFAULT '0', `reqskill` smallint(5) unsigned NOT NULL DEFAULT '0', `reqskillvalue` smallint(5) unsigned NOT NULL DEFAULT '0', |