tree 1ed68714d106cc75fd414a5f8508d6ec5ea9959b
parent a820ea1f67bab68136fbaae0108bb90c94b77b22
author Stefan Sperling <ssperling@sysmocom.de> 1543317045 +0100
committer Neels Hofmeyr <neels@hofmeyr.de> 1543929208 +0100

add database schema versioning to the HLR database

Make use of pragma user_version to store our database schema version.
The present schema is now identitifed as 'version 0', which is also
the default value for databases on which we never ran the statement
'pragma user_version' before.

Only bootstrap the database if it hasn't been bootstrapped yet.
Previously, bootstrap SQL statements ran every time osmo-hlr
opened the database, and any errors were being ignored in SQL.
Instead, we now first run a query which checks whether tables
already exist, and only create them if necessary.
This change will allow future schema updates to work properly.

Prepare for future schema upgrades by adding a new command-line
option which enables upgrades. This option defaults to 'false'
in order to avoid accidental upgrades.

Change-Id: I8aeaa9a404b622657cbc7138106f38aa6ad8d01b
Related: OS#2838