diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_31_07_world.sql | 257 |
1 files changed, 257 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_31_07_world.sql b/sql/updates/world/master/2021_12_31_07_world.sql new file mode 100644 index 00000000000..733ffd2a10c --- /dev/null +++ b/sql/updates/world/master/2021_12_31_07_world.sql @@ -0,0 +1,257 @@ +-- SELECT +-- CONCAT('ALTER TABLE `', c.TABLE_NAME, '` MODIFY `', c.COLUMN_NAME, '` int(10) unsigned', IF(c.IS_NULLABLE, '', ' NOT NULL'), IF(c.COLUMN_DEFAULT IS NOT NULL, CONCAT(' DEFAULT ', QUOTE(c.COLUMN_DEFAULT)), ''), IF(LENGTH(c.COLUMN_COMMENT) > 0, CONCAT(' COMMENT ', QUOTE(c.COLUMN_COMMENT)), ''), ';') alter_expression +-- FROM +-- `information_schema`.`columns` c +-- WHERE +-- c.TABLE_SCHEMA = 'trinity_world' +-- AND c.DATA_TYPE = 'mediumint' +-- AND c.COLUMN_TYPE LIKE '%unsigned%' + +-- unsigned mediumints +ALTER TABLE `access_requirement` MODIFY `mapId` int(10) unsigned NOT NULL; +ALTER TABLE `access_requirement` MODIFY `item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `access_requirement` MODIFY `item2` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `access_requirement` MODIFY `quest_done_A` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `access_requirement` MODIFY `quest_done_H` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `access_requirement` MODIFY `completed_achievement` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `areatrigger_involvedrelation` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier'; +ALTER TABLE `areatrigger_involvedrelation` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier'; +ALTER TABLE `areatrigger_tavern` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier'; +ALTER TABLE `areatrigger_teleport` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `areatrigger_teleport` MODIFY `PortLocID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `battleground_template` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `battleground_template` MODIFY `AllianceStartLoc` int(10) unsigned NOT NULL; +ALTER TABLE `battleground_template` MODIFY `HordeStartLoc` int(10) unsigned NOT NULL; +ALTER TABLE `battlemaster_entry` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of a creature'; +ALTER TABLE `battlemaster_entry` MODIFY `bg_template` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Battleground template id'; +ALTER TABLE `blackmarket_template` MODIFY `itemEntry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` MODIFY `SourceGroup` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` MODIFY `ElseGroup` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` MODIFY `ErrorType` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` MODIFY `ErrorTextId` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier'; +ALTER TABLE `creature` MODIFY `modelid` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature` MODIFY `currentwaypoint` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_addon` MODIFY `mount` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_classlevelstats` MODIFY `basemana` int(10) unsigned NOT NULL DEFAULT '1'; +ALTER TABLE `creature_equip_template` MODIFY `CreatureID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_equip_template` MODIFY `ItemID1` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_equip_template` MODIFY `ItemID2` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_equip_template` MODIFY `ItemID3` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_model_info` MODIFY `DisplayID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_model_info` MODIFY `DisplayID_Other_Gender` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_onkill_reputation` MODIFY `creature_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier'; +ALTER TABLE `creature_questender` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier'; +ALTER TABLE `creature_questender` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier'; +ALTER TABLE `creature_queststarter` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier'; +ALTER TABLE `creature_queststarter` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier'; +ALTER TABLE `creature_summon_groups` MODIFY `summonerId` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_summon_groups` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `difficulty_entry_1` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `difficulty_entry_2` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `difficulty_entry_3` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `gossip_menu_id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `lootid` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `pickpocketloot` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `skinloot` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `VehicleId` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `mingold` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `maxgold` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template_addon` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template_addon` MODIFY `mount` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template_addon` MODIFY `emote` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template_locale` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template_scaling` MODIFY `Entry` int(10) unsigned NOT NULL; +ALTER TABLE `creature_text` MODIFY `CreatureID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_text` MODIFY `Emote` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_text` MODIFY `Duration` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_text` MODIFY `Sound` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_text_locale` MODIFY `CreatureID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `criteria_data` MODIFY `value1` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `criteria_data` MODIFY `value2` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `disenchant_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `disenchant_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `disenchant_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `event_scripts` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `event_scripts` MODIFY `command` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `event_scripts` MODIFY `datalong` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `fishing_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `fishing_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `fishing_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event` MODIFY `holiday` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id'; +ALTER TABLE `game_event_condition` MODIFY `condition_id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_creature_quest` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_creature_quest` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_gameobject_quest` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_gameobject_quest` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_model_equip` MODIFY `modelid` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_npc_vendor` MODIFY `item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_npc_vendor` MODIFY `maxcount` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_npc_vendor` MODIFY `incrtime` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_npc_vendor` MODIFY `ExtendedCost` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_pool` MODIFY `pool_entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the pool'; +ALTER TABLE `game_event_prerequisite` MODIFY `prerequisite_event` int(10) unsigned NOT NULL; +ALTER TABLE `game_event_quest_condition` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_quest_condition` MODIFY `condition_id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_seasonal_questrelation` MODIFY `eventEntry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of the game event'; +ALTER TABLE `game_tele` MODIFY `id` int(10) unsigned NOT NULL; +ALTER TABLE `game_weather` MODIFY `zone` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier'; +ALTER TABLE `gameobject_addon` MODIFY `WorldEffectID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_questender` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_questender` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier'; +ALTER TABLE `gameobject_queststarter` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_queststarter` MODIFY `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier'; +ALTER TABLE `gameobject_template` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_template` MODIFY `displayId` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_template_addon` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_template_addon` MODIFY `mingold` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_template_addon` MODIFY `maxgold` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_template_addon` MODIFY `WorldEffectID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gameobject_template_locale` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `graveyard_zone` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `graveyard_zone` MODIFY `GhostZone` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `guild_rewards` MODIFY `ItemID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `guild_rewards_req_achievements` MODIFY `ItemID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `guild_rewards_req_achievements` MODIFY `AchievementRequired` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `item_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `item_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `item_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail_level_reward` MODIFY `mailTemplateId` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail_level_reward` MODIFY `senderEntry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `mail_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `milling_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `milling_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `milling_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `BroadcastTextID0` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `BroadcastTextID1` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `BroadcastTextID2` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `BroadcastTextID3` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `BroadcastTextID4` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `BroadcastTextID5` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `BroadcastTextID6` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_text` MODIFY `BroadcastTextID7` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_vendor` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_vendor` MODIFY `maxcount` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `npc_vendor` MODIFY `ExtendedCost` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `page_text` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `page_text` MODIFY `NextPageID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `page_text_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `pet_levelstats` MODIFY `creature_entry` int(10) unsigned NOT NULL; +ALTER TABLE `pet_name_generation` MODIFY `id` int(10) unsigned NOT NULL; +ALTER TABLE `pet_name_generation` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `pickpocketing_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `pickpocketing_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `pickpocketing_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `playercreateinfo_cast_spell` MODIFY `spell` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `playercreateinfo_item` MODIFY `itemid` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `playercreateinfo_spell_custom` MODIFY `Spell` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `points_of_interest` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `points_of_interest` MODIFY `Icon` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `points_of_interest` MODIFY `Flags` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `points_of_interest` MODIFY `Importance` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `points_of_interest_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `pool_template` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry'; +ALTER TABLE `prospecting_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `prospecting_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `prospecting_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_details` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_greeting` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_objectives` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_objectives` MODIFY `QuestID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_objectives_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_objectives_locale` MODIFY `QuestId` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_offer_reward` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_pool_template` MODIFY `poolId` int(10) unsigned NOT NULL; +ALTER TABLE `quest_request_items` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_addon` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_addon` MODIFY `SourceSpellID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_addon` MODIFY `NextQuestID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_addon` MODIFY `RewardMailTemplateID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_locale` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `quest_visual_effect` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `reference_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `reference_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `reference_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `reputation_reward_rate` MODIFY `faction` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `script_waypoint` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry'; +ALTER TABLE `script_waypoint` MODIFY `pointid` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `skill_discovery_template` MODIFY `spellId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the discoverable spell'; +ALTER TABLE `skill_discovery_template` MODIFY `reqSpell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'spell requirement'; +ALTER TABLE `skill_extra_item_template` MODIFY `spellId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell'; +ALTER TABLE `skill_extra_item_template` MODIFY `requiredSpecialization` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id'; +ALTER TABLE `skill_fishing_base_level` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Area identifier'; +ALTER TABLE `skill_perfect_item_template` MODIFY `spellId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell'; +ALTER TABLE `skill_perfect_item_template` MODIFY `requiredSpecialization` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id'; +ALTER TABLE `skill_perfect_item_template` MODIFY `perfectItemType` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'perfect item type to create instead'; +ALTER TABLE `skinning_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `skinning_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `skinning_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_area` MODIFY `spell` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_area` MODIFY `area` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_area` MODIFY `quest_start` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_area` MODIFY `quest_end` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_loot_template` MODIFY `Entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_loot_template` MODIFY `Item` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_loot_template` MODIFY `Reference` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_pet_auras` MODIFY `spell` int(10) unsigned NOT NULL COMMENT 'dummy spell id'; +ALTER TABLE `spell_pet_auras` MODIFY `pet` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pet id; 0 = all'; +ALTER TABLE `spell_pet_auras` MODIFY `aura` int(10) unsigned NOT NULL COMMENT 'pet aura id'; +ALTER TABLE `spell_scripts` MODIFY `id` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_scripts` MODIFY `command` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_scripts` MODIFY `datalong` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_target_position` MODIFY `ID` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `spell_threat` MODIFY `entry` int(10) unsigned NOT NULL; +ALTER TABLE `transports` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `trinity_string` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `vehicle_accessory` MODIFY `accessory_entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `vehicle_template_accessory` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `vehicle_template_accessory` MODIFY `accessory_entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `waypoint_data` MODIFY `point` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `waypoints` MODIFY `entry` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `waypoints` MODIFY `pointid` int(10) unsigned NOT NULL DEFAULT '0'; + +-- SELECT +-- CONCAT('ALTER TABLE `', c.TABLE_NAME, '` MODIFY `', c.COLUMN_NAME, '` int(11)', IF(c.IS_NULLABLE, '', ' NOT NULL'), IF(c.COLUMN_DEFAULT IS NOT NULL, CONCAT(' DEFAULT ', QUOTE(c.COLUMN_DEFAULT)), ''), IF(LENGTH(c.COLUMN_COMMENT) > 0, CONCAT(' COMMENT ', QUOTE(c.COLUMN_COMMENT)), ''), ';') alter_expression +-- FROM +-- `information_schema`.`columns` c +-- WHERE +-- c.TABLE_SCHEMA = 'trinity_world' +-- AND c.DATA_TYPE = 'mediumint' +-- AND c.COLUMN_TYPE NOT LIKE '%unsigned%' + +-- signed mediumints +ALTER TABLE `areatrigger_scripts` MODIFY `entry` int(11) NOT NULL; +ALTER TABLE `blackmarket_template` MODIFY `sellerNpc` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` MODIFY `SourceTypeOrReferenceId` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` MODIFY `SourceEntry` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `conditions` MODIFY `ConditionTypeOrReference` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `creature_onkill_reputation` MODIFY `RewOnKillRepValue1` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `creature_onkill_reputation` MODIFY `RewOnKillRepValue2` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `HealthScalingExpansion` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `RequiredExpansion` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` MODIFY `VignetteID` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `creature_text` MODIFY `BroadcastTextId` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `criteria_data` MODIFY `criteria_id` int(11) NOT NULL; +ALTER TABLE `exploration_basexp` MODIFY `basexp` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `npc_vendor` MODIFY `item` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_addon` MODIFY `PrevQuestID` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_addon` MODIFY `ExclusiveGroup` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_addon` MODIFY `RequiredMinRepValue` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_template_addon` MODIFY `RequiredMaxRepValue` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `quest_visual_effect` MODIFY `VisualEffect` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `spell_area` MODIFY `aura_spell` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `spell_linked_spell` MODIFY `spell_trigger` int(11) NOT NULL; +ALTER TABLE `spell_linked_spell` MODIFY `spell_effect` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `spell_required` MODIFY `spell_id` int(11) NOT NULL DEFAULT '0'; +ALTER TABLE `spell_required` MODIFY `req_spell` int(11) NOT NULL DEFAULT '0'; |