diff options
| -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', |