search

wowdev / WoWDBDefs

Client database definitions for World of Warcraft
Other
246 stars 95 forks source link

WIP: add dbd_to_mysql.py script for MySQL schema generation #100

Closed alinsavix closed 2 years ago

alinsavix commented 2 years ago

Generates a seemingly sane MySQL schema for a given build based on WoWDBDDefs definitions. Unfortunately a bit slowly, because the existing dbd parser takes a bit to grind the 1000 or so table definitions.

Once the resulting schema is loaded into MySQL, it can then be used by tools like schemaspy to generate useful ways to browse the db structure (see e.g. https://www.lupine.org/~alinsa/wowdbd/)

alinsavix commented 2 years ago

Realized this isn't handling signed vs. unsigned correctly. Stand by.