Create Settings-Table - Githubissues

derfelix42 / Taskmanager

Manage your ToDos and much more!

3 stars 0 forks source link

Open derfelix42 opened 6 months ago

derfelix42 commented 6 months ago

Add a Key-Value Table for system settings in the DB.

Information like home location can be stored there for sunrise/sunset or weather data (currently hard-coded or configured via env-file).

Schema should probably look like this:

Key (String)
Value (String)
access (String) // used for access control, if plugin concept will be introduced later (current default: system)
~~created (datetime) - default: NOW()~~
updated (datetime) - default: NOW()

derfelix42 commented 3 months ago

storing a creation date and tracking changes is probably overkill; will switch to a "updated" field to see the last update

derfelix42 commented 3 months ago

Setting "key" to VARCHAR(128) and "access" to VARCHAR(64). These should hopefully suffice for any usecase 👍 :)