mercury icon indicating copy to clipboard operation
mercury copied to clipboard

Published 20 hours ago • verified publisher icon Delni

Operation State Storage Wrong

Open MeikelLP opened this issue 6 years ago • 0 comments

Currently, the operations' state is stored via its font-awesome 4 icon name. This has to be changed to a generic state name like open.

Also, it's required to create a migration to change all existing data from an old database to the new format.

Because it's not possible to determine the version of a database file we need to create a table like version_history with column version (varchar) and insert every version of mercury when migrating to a new version. No version implies that an existing database is version 1.1 of Mercury.

To determine the latest applied version one needs to SELECT TOP 1 version FROM version_history (pseudo).

MeikelLP avatar Sep 07 '18 18:09 MeikelLP