rezalas / riftshadow

Dedicated to the preservation of the game and modernization of a classic mud codebase.
MIT License
18 stars 14 forks source link

Reorganized SQL Scripts used for database schema installation on first dev setup #213

Closed Psypher9 closed 1 year ago

Psypher9 commented 1 year ago

Objective:

Reorganize SQL schema and data scripts as per #193

Database script updates:

-- rift_core ---- data ---- tables


- Reorganized the `setup.sql` restore and installation script to target schema scaffolding and data import per database
- Added `IF NOT EXISTS` on database creation and default user creation

## Dev Install Updates:
- Added attempts to start MySQL or MariaDB if already installed
- Successful scaffolding message after all databases have been built and their data imported
- Handle calling the `setup.sql` file for each step of the database creation

## Other changes:
- Modified .gitignore to allow `./db/rift/**` to be tracked but still ignore the build artifacts in the `./rift/` directory
- Added database PR labels
Psypher9 commented 1 year ago

@rezalas, absolutely! This one was fun and I learned a lot about the nuances of the MySQL source command.