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).
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_historywith columnversion (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).