Skip to content

#182 Revise database schema

Marko Vendelin requested to merge feature/182-schema-revision into main

Unfortunately, we have a major issue with database schema updates on SQLite. Essentially, as it is rather limited what you can do with ALTER TABLE in that database, I suggest to start from the scratch. For our local DB, I will make conversion manually (will copy data from older format to the new).

In future, iff we need to work on schema update, we will figure out how to do so. But right now there is no need.

To avoid any confusion, revisions have been altered to prevent this schema to be used mixed with old database.

@jakutt, I suggest to rebase this on MR that you will submit for #181 (closed). As it is a pain to alter schema, we can then drop here is_delete as well.

Fixes: #182 (closed)

Edited by Marko Vendelin

Merge request reports