Setup something for management and tracking of database
I dumped the DB (provided by bitshift on the forums) here: https://github.com/twostars/OpenKO-db
This is mostly just a placeholder repo for now until something's really done about the DB, but as the README says:
This is generated by SQL Server Management Studio and currently manually tidied up to reduce file size.
Ideally we need our own export process to tidy it up consistently (and further than what's already been done), as well as an import, with version tracking to detect new changes.
For now it's just a basic dump to serve as a better, easier to find reference than the binary database that needs tracking down in the forums.
Essentially, to make things easier to access and make changes, we need to manage this database independently, have an import and export process; the import process should be automatable, such that it will either rebuild the database from scratch, or add on new changes as per its version tracking.
The existing repo is just somewhat of a placeholder; I don't even like the existing dumps. They should be reproducible minified export, rather than MSSQL's seemingly not-very-configurable dumps which were manually touched up to reduce filesizes to reduce, for example, the ITEM table's size from ~110MB to ~30MB.
With a proper export process, we should then filter out the data from user tables.