AQUA makeDB

Create INSERTs to add DIVA PVs and Modules to the AQUA Server by reading game files

Notes

• This was only tested with a 10.7 MariaDB database
• We assume you'll run this with python 3.8 or higher
• You'll need en.toml and en_mods.toml for translations to english
• You'll need mdata_pv_db.txt for the list of PVs
  You may use MZZS' (The Compatibility Patch) for a good list
• You'll need gm_module_id.bin for the list of modules
  You can extract it from a mdata_gm_module_tbl.farc with FarcPack
  As long as IDs don't conflict, you can concatenate multipe gm_module_id.bin to list all modules at once

Running

# Grab dependencies
pip install -r requirements.txt

# Run the script
python make_divadb.py

# Adapt those commands to your setup
# PVs:
mysql -h localhost -u aqua aqua < diva_pv.sql
# Modules:
mysql -h localhost -u aqua aqua < diva_module.sql