Stendhal Database Structure

• Play
  • Manual
  • Beginner's Guide
  • FAQ
  • Ask for Help
  • Events
  • Videos
  • Rules
  • Groups
• World
  • Atlas
  • Dungeons
  • NPCs
  • Levels
  • Creatures
  • Items
  • Quests
  • Games
  • History
  • Achievements
  • Houses
• GMs
  • Administration
  • How to be a GM
  • Scripts
  • Guide for admin
• Contribute
  • Chat
  • Bugs
  • Testing
  • Graphics
  • Sound
  • Item Ideas
  • Atlas
  • Creature Ideas
  • Quest Ideas
  • NPC Ideas
  • Events Ideas
  • Achievement Ideas
  • Open Tasks
• |
• Extend
  • How to add items
  • How to add Creatures
  • How to add quests
  • How to add NPCs
  • How to create maps
• Develop
  • CVS (Source Code)
  • Bugs
  • Meetings
  • Testing
  • Code Design
  • Jenkins
  • Ideas
  • Open Tasks
  • Patches
  • API Reference

• Build & Host
  • Building
  • IDEs
  • Hosting
• |
• Misc.
  • Third Party Projects

Database

Marauroa

• High Level Database Access
• Low Level Database Access
• Marauroa Database Structure

Stendhal

• Stendhal Database Structure

Stendhal adds a number of table to the Marauroa Database Structure as you can see below.

The table character_stats, halloffame, npcs and kills are read by the website.

The table words is used by Stendhal's grammar package.

And finally itemlog keeps track of each items and how it is moved around in world. This is very similar to the general gameEvents table. The table itemid is used to assign each newly created item a unique id. There is a proposal to have an item table with one row per item instead of this counter table.