diff options
| author | Neels Hofmeyr <neels@hofmeyr.de> | 2019-11-20 02:36:35 +0100 |
|---|---|---|
| committer | Neels Hofmeyr <neels@hofmeyr.de> | 2019-11-27 03:19:06 +0100 |
| commit | 07e1602d2dd13d0884ccd623d9f7955b921fa702 (patch) | |
| tree | 02a08050da1f6a69bbae0b1571abc8cc6a7c205e /tests | |
| parent | abdfdb8a4a58d36e8ac8e54736589df753225da7 (diff) | |
db v4: add column last_lu_seen_ps
Location Updating procedures from both CS and PS overwrite the same
last_lu_seen field of a subscriber. For upcoming D-GSM it will be important to
distinguish those, because only CS attaches qualify for MSISDN lookup.
Add column last_lu_seen_ps, and upon PS LU, do not overwrite last_lu_seen, so
that last_lu_seen now only reflects CS LU.
In the VTY, dump both LU dates distinctively.
Change-Id: Id7fc50567211a0870ac0524f6dee94d4513781ba
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/db_upgrade/db_upgrade_test.ok | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/tests/db_upgrade/db_upgrade_test.ok b/tests/db_upgrade/db_upgrade_test.ok index 49e7151..67d0006 100644 --- a/tests/db_upgrade/db_upgrade_test.ok +++ b/tests/db_upgrade/db_upgrade_test.ok @@ -83,6 +83,7 @@ DDB Database <PATH>test.db' has HLR DB schema version 0 DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 1 DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 2 DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 3 +DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 4 DMAIN Cmdline option --db-check: Database was opened successfully, quitting. Resulting db: @@ -124,6 +125,7 @@ imei|VARCHAR(14)|0||0 imeisv|VARCHAR|0||0 imsi|VARCHAR(15)|1||0 last_lu_seen|TIMESTAMP|0|NULL|0 +last_lu_seen_ps|TIMESTAMP|0|NULL|0 lmsi|INTEGER|0||0 ms_purged_cs|BOOLEAN|1|0|0 ms_purged_ps|BOOLEAN|1|0|0 @@ -139,13 +141,13 @@ smsc_number|VARCHAR(15)|0||0 vlr_number|VARCHAR(15)|0||0 Table subscriber contents: -ggsn_number|gmlc_number|id|imei|imeisv|imsi|last_lu_seen|lmsi|ms_purged_cs|ms_purged_ps|msc_number|msisdn|nam_cs|nam_ps|periodic_lu_tmr|periodic_rau_tau_tmr|sgsn_address|sgsn_number|smsc_number|vlr_number -||1|||123456789012345|||0|0||098765432109876|1|1||||||MSC-1 -||2|||111111111|||1|0|||1|1|||||| -||3|||222222222|||0|1||22222|1|1|||||| -||4|||333333|||0|0||3|0|1|||||| -||5|||444444444444444|||0|0||4444|1|0|||||| -||6|||5555555|||0|0||55555555555555|0|0|||||| +ggsn_number|gmlc_number|id|imei|imeisv|imsi|last_lu_seen|last_lu_seen_ps|lmsi|ms_purged_cs|ms_purged_ps|msc_number|msisdn|nam_cs|nam_ps|periodic_lu_tmr|periodic_rau_tau_tmr|sgsn_address|sgsn_number|smsc_number|vlr_number +||1|||123456789012345||||0|0||098765432109876|1|1||||||MSC-1 +||2|||111111111||||1|0|||1|1|||||| +||3|||222222222||||0|1||22222|1|1|||||| +||4|||333333||||0|0||3|0|1|||||| +||5|||444444444444444||||0|0||4444|1|0|||||| +||6|||5555555||||0|0||55555555555555|0|0|||||| Table: subscriber_apn name|type|notnull|dflt_value|pk @@ -166,5 +168,5 @@ osmo-hlr --database $db --db-check --config-file $srcdir/osmo-hlr.cfg rc = 0 DMAIN hlr starting DDB using database: <PATH>test.db -DDB Database <PATH>test.db' has HLR DB schema version 3 +DDB Database <PATH>test.db' has HLR DB schema version 4 DMAIN Cmdline option --db-check: Database was opened successfully, quitting. |