14 KiB
14 KiB
🗃️ EQ2Emu WorldDB Schema Documentation
This document describes the MySQL schema for the World Server (eq2emu).
📚 Table of Contents
- achievements
- achievements_requirements
- achievements_rewards
- appearances
- bot_appearance
- bot_equipment
- bots
- broker_item_map
- bugs
- channels
- char_colors
- character_aa
- character_aa_defaults
- character_achievements
- character_achievements_items
- character_buyback
- character_claim_items
- character_collection_items
- character_collections
- character_details
- character_factions
- character_history
- character_house_deposits
- character_house_history
- character_houses
- character_instances
- character_items
- character_items_group_members
- character_languages
- character_lua_history
- character_macros
- character_mail
- character_pictures
- character_properties
- character_quest_progress
- character_quest_rewards
- character_quest_temporary_rewards
- character_quests
- character_recipe_books
- character_recipes
- character_skillbar
- character_skills
- character_social
- character_spell_effect_targets
- character_spell_effects
- character_spells
- character_spirit_shards
- character_titles
- characters
- charactersproperties
- chest_traps
- claim_items
- collection_details
- collection_rewards
- collections
- commands
- dbeditor_log
- dialog_flavors
- dialog_npcs
- dialog_play_flavors
- dialog_play_voices
- dialog_responses
- dialog_text
- dialog_voiceovers
- dialogs
- emotes
- entity_commands
- eq2classes
- eq2expansions
- eq2gm
- eq2models
- eq2races
- exp_per_level
- faction_alliances
- factions
- failed_jobs
- flight_paths
- flight_paths_locations
- groundspawn_items
- groundspawns
- guild_colors
- guild_event_defaults
- guild_event_filters
- guild_events
- guild_members
- guild_points_history
- guild_ranks
- guild_ranks_defaults
- guild_recruiting
- guilds
- heroic_ops
- ho_starter_chains
- ho_wheel
- houses
- instance_spawns_removed
- instances
- item_appearances
- item_classifications
- item_details_achievement_profile
- item_details_adornments
- item_details_armor
- item_details_armorset
- item_details_bag
- item_details_bauble
- item_details_book
- item_details_book_pages
- item_details_decorations
- item_details_food
- item_details_house
- item_details_house_container
- item_details_itemset
- item_details_marketplace
- item_details_pattern
- item_details_range
- item_details_recipe
- item_details_recipe_items
- item_details_reward_crate
- item_details_reward_crate_item
- item_details_reward_voucher
- item_details_shield
- item_details_skill
- item_details_skills
- item_details_thrown
- item_details_weapon
- item_effects
- item_itemset_bonus
- item_itemset_bonus_effects
- item_itemset_bonus_stats
- item_itemset_items
- item_itemsets
- item_levels_override
- item_mod_stats
- item_mod_strings
- item_pvp_link
- item_stat_subtypes
- item_stat_types
- item_stats
- items
- itemstats
- languages
- location_details
- locations
- log_messages
- loot_global
- lootdrop
- loottable
- map_data
- merchant_inventory
- merchant_multipliers
- merchants
- name_filter
- npc_appearance
- npc_appearance_equip
- opcodes
- password_resets
- persisted_respawns
- quest_details
- quest_reward_reqs
- quests
- race_types
- raw_sell_prices
- recipe
- recipe_comp_list
- recipe_comp_list_item
- recipe_components
- recipe_products
- recipe_secondary_comp
- recipes
- reference_spell_effects
- revive_points
- ruleset_details
- rulesets
- skills
- spawn
- spawn_ground
- spawn_instance_data
- spawn_location_entry
- spawn_location_group
- spawn_location_group_associations
- spawn_location_group_chances
- spawn_location_name
- spawn_location_placement
- spawn_loot
- spawn_npc_equipment
- spawn_npc_skills
- spawn_npc_spell_lists
- spawn_npc_spells
- spawn_npcs
- spawn_objects
- spawn_pet_names
- spawn_scripts
- spawn_signs
- spawn_templates
- spawn_widgets
- spell_aa_class_list
- spell_aa_list
- spell_aa_nodelist
- spell_aa_tablist
- spell_classes
- spell_data
- spell_display_effects
- spell_error_versions
- spell_tiers
- spell_traits
- spell_ts_ability_index
- spell_visuals
- spells
- starting_details
- starting_factions
- starting_items
- starting_languages
- starting_skillbar
- starting_skills
- starting_spells
- starting_titles
- starting_zones
- statistics
- table_versions
- titles
- tradeskillevents
- transmuting
- transport_maps
- transporters
- variables
- versioned_spell_errors
- visual_states
- voiceovers
- web_routes
- web_users
- zones
✨ Introduction
The world database manages all in-game content data, including NPCs, spawns, items, spells, and quests.
📌 Notes
- Schema extracted from
eq2emu_worlddb_schema.sql. - Full table documentation will be added here.