DatabaseDesign

Character Tables

• accounts
• character_advantages
• character_events
• character_limitations
• character_quests
• character_relationships
• character_skills
• character_traits
• characters
• player_spells
• race_info

Guild Tables

• alliances
• guild_wars
• guildlevels
• guilds

NPC Movement Tables

• sc_location_type
• sc_locations
• sc_npc_definitions
• sc_path_points
• sc_tribe_memories
• sc_tribe_resources
• sc_waypoint_links
• sc_waypoints
• npc_spawn_ranges
• npc_spawn_rules
• tribes

NPC Dialog Tables

• npc_bad_text
• npc_disallowed_words
• npc_knowledge_areas
• npc_responses
• npc_synonyms
• npc_trigger_groups
• npc_triggers

Crafting Tables

• trade_autocontainers
• trade_combinations
• trade_patterns
• trade_processes
• trade_transformations

Spells Tables

• spell_glyphs
• spells
• ways

Items Tables

• item_animations
• item_categories
• item_instances
• item_stats

Mini-game Tables

• gameboards
• action_locations

Hunt Locations and Natural Resources

• hunt_locations
• natural_resources