| Creating db in schema version 0 |
| |
| Version 0 db: |
| |
| Table: auc_2g |
| name|type|notnull|dflt_value|pk |
| algo_id_2g|INTEGER|1||0 |
| ki|VARCHAR(32)|1||0 |
| subscriber_id|INTEGER|0||1 |
| |
| Table auc_2g contents: |
| algo_id_2g|ki|subscriber_id |
| 1|BeefedCafeFaceAcedAddedDecadeFee|1 |
| 2|33333333333333333333333333333333|4 |
| 4|55555555555555555555555555555555|6 |
| |
| Table: auc_3g |
| name|type|notnull|dflt_value|pk |
| algo_id_3g|INTEGER|1||0 |
| ind_bitlen|INTEGER|1|5|0 |
| k|VARCHAR(32)|1||0 |
| op|VARCHAR(32)|0||0 |
| opc|VARCHAR(32)|0||0 |
| sqn|INTEGER|1|0|0 |
| subscriber_id|INTEGER|0||1 |
| |
| Table auc_3g contents: |
| algo_id_3g|ind_bitlen|k|op|opc|sqn|subscriber_id |
| 5|5|C01ffedC1cadaeAc1d1f1edAcac1aB0a||CededEffacedAceFacedBadFadedBeef|0|1 |
| 5|5|44444444444444444444444444444444|44444444444444444444444444444444||0|5 |
| 5|5|55555555555555555555555555555555||55555555555555555555555555555555|0|6 |
| |
| Table: subscriber |
| name|type|notnull|dflt_value|pk |
| ggsn_number|VARCHAR(15)|0||0 |
| gmlc_number|VARCHAR(15)|0||0 |
| hlr_number|VARCHAR(15)|0||0 |
| id|INTEGER|0||1 |
| imeisv|VARCHAR|0||0 |
| imsi|VARCHAR(15)|1||0 |
| lmsi|INTEGER|0||0 |
| ms_purged_cs|BOOLEAN|1|0|0 |
| ms_purged_ps|BOOLEAN|1|0|0 |
| msisdn|VARCHAR(15)|0||0 |
| nam_cs|BOOLEAN|1|1|0 |
| nam_ps|BOOLEAN|1|1|0 |
| periodic_lu_tmr|INTEGER|0||0 |
| periodic_rau_tau_tmr|INTEGER|0||0 |
| sgsn_address|VARCHAR|0||0 |
| sgsn_number|VARCHAR(15)|0||0 |
| smsc_number|VARCHAR(15)|0||0 |
| vlr_number|VARCHAR(15)|0||0 |
| |
| Table subscriber contents: |
| ggsn_number|gmlc_number|hlr_number|id|imeisv|imsi|lmsi|ms_purged_cs|ms_purged_ps|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 |
| apn|VARCHAR(256)|1||0 |
| subscriber_id|INTEGER|0||0 |
| |
| Table subscriber_apn contents: |
| |
| Table: subscriber_multi_msisdn |
| name|type|notnull|dflt_value|pk |
| msisdn|VARCHAR(15)|1||0 |
| subscriber_id|INTEGER|0||0 |
| |
| Table subscriber_multi_msisdn contents: |
| |
| Launching osmo-hlr to upgrade db: |
| osmo-hlr --database $db --db-upgrade --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 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 |
| DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 5 |
| DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 6 |
| DMAIN Cmdline option --db-check: Database was opened successfully, quitting. |
| |
| Resulting db: |
| |
| Table: auc_2g |
| name|type|notnull|dflt_value|pk |
| algo_id_2g|INTEGER|1||0 |
| ki|VARCHAR(32)|1||0 |
| subscriber_id|INTEGER|0||1 |
| |
| Table auc_2g contents: |
| algo_id_2g|ki|subscriber_id |
| 1|BeefedCafeFaceAcedAddedDecadeFee|1 |
| 2|33333333333333333333333333333333|4 |
| 4|55555555555555555555555555555555|6 |
| |
| Table: auc_3g |
| name|type|notnull|dflt_value|pk |
| algo_id_3g|INTEGER|1||0 |
| ind_bitlen|INTEGER|1|5|0 |
| k|VARCHAR(32)|1||0 |
| op|VARCHAR(32)|0||0 |
| opc|VARCHAR(32)|0||0 |
| sqn|INTEGER|1|0|0 |
| subscriber_id|INTEGER|0||1 |
| |
| Table auc_3g contents: |
| algo_id_3g|ind_bitlen|k|op|opc|sqn|subscriber_id |
| 5|5|C01ffedC1cadaeAc1d1f1edAcac1aB0a||CededEffacedAceFacedBadFadedBeef|0|1 |
| 5|5|44444444444444444444444444444444|44444444444444444444444444444444||0|5 |
| 5|5|55555555555555555555555555555555||55555555555555555555555555555555|0|6 |
| |
| Table: ind |
| name|type|notnull|dflt_value|pk |
| ind|INTEGER|0||1 |
| vlr|TEXT|1||0 |
| |
| Table ind contents: |
| |
| Table: subscriber |
| name|type|notnull|dflt_value|pk |
| ggsn_number|VARCHAR(15)|0||0 |
| gmlc_number|VARCHAR(15)|0||0 |
| id|INTEGER|0||1 |
| 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 |
| msc_number|VARCHAR(15)|0||0 |
| msisdn|VARCHAR(15)|0||0 |
| nam_cs|BOOLEAN|1|1|0 |
| nam_ps|BOOLEAN|1|1|0 |
| periodic_lu_tmr|INTEGER|0||0 |
| periodic_rau_tau_tmr|INTEGER|0||0 |
| sgsn_address|VARCHAR|0||0 |
| sgsn_number|VARCHAR(15)|0||0 |
| sgsn_via_proxy|VARCHAR|0||0 |
| smsc_number|VARCHAR(15)|0||0 |
| vlr_number|VARCHAR(15)|0||0 |
| vlr_via_proxy|VARCHAR|0||0 |
| |
| Table subscriber contents: |
| 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|sgsn_via_proxy|smsc_number|vlr_number|vlr_via_proxy |
| ||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 |
| apn|VARCHAR(256)|1||0 |
| subscriber_id|INTEGER|0||0 |
| |
| Table subscriber_apn contents: |
| |
| Table: subscriber_multi_msisdn |
| name|type|notnull|dflt_value|pk |
| msisdn|VARCHAR(15)|1||0 |
| subscriber_id|INTEGER|0||0 |
| |
| Table subscriber_multi_msisdn contents: |
| |
| Verify that osmo-hlr can open it: |
| 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 6 |
| DMAIN Cmdline option --db-check: Database was opened successfully, quitting. |