Skip to content

Database Schema

X maderp requested to merge feature-5 into master

Adds SQL scripts (setup.sql, erase.sql) to initialize the database for use or, respectively, remove all the database artifacts related to the system.

Details still to be sorted out:

  • What is the exact location the scripts should reside at? Currently, being resource files needed at system startup, they are in src/main/resources/db. Instead, src/main/resources/tech/bugger/db could be preferable.
  • The setup script inserts rows with default values into the singleton tables version and system_settings. What is the default list of allowed file extensions? What is the default theme?
  • How will the first admin be created? The setup script should most probably not be responsible for inserting the first admin since the password hash, salt and hashing algorithm are highly dependent on the internals of Hasher.

Closes #5 (closed).

Edited by X maderp

Merge request reports