Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 1 | Creating db in schema version 0 |
| 2 | |
| 3 | Version 0 db: |
| 4 | |
| 5 | Table: auc_2g |
| 6 | name|type|notnull|dflt_value|pk |
| 7 | algo_id_2g|INTEGER|1||0 |
| 8 | ki|VARCHAR(32)|1||0 |
| 9 | subscriber_id|INTEGER|0||1 |
| 10 | |
| 11 | Table auc_2g contents: |
| 12 | algo_id_2g|ki|subscriber_id |
| 13 | 1|BeefedCafeFaceAcedAddedDecadeFee|1 |
| 14 | 2|33333333333333333333333333333333|4 |
| 15 | 4|55555555555555555555555555555555|6 |
| 16 | |
| 17 | Table: auc_3g |
| 18 | name|type|notnull|dflt_value|pk |
| 19 | algo_id_3g|INTEGER|1||0 |
| 20 | ind_bitlen|INTEGER|1|5|0 |
| 21 | k|VARCHAR(32)|1||0 |
| 22 | op|VARCHAR(32)|0||0 |
| 23 | opc|VARCHAR(32)|0||0 |
| 24 | sqn|INTEGER|1|0|0 |
| 25 | subscriber_id|INTEGER|0||1 |
| 26 | |
| 27 | Table auc_3g contents: |
| 28 | algo_id_3g|ind_bitlen|k|op|opc|sqn|subscriber_id |
| 29 | 5|5|C01ffedC1cadaeAc1d1f1edAcac1aB0a||CededEffacedAceFacedBadFadedBeef|0|1 |
| 30 | 5|5|44444444444444444444444444444444|44444444444444444444444444444444||0|5 |
| 31 | 5|5|55555555555555555555555555555555||55555555555555555555555555555555|0|6 |
| 32 | |
| 33 | Table: subscriber |
| 34 | name|type|notnull|dflt_value|pk |
| 35 | ggsn_number|VARCHAR(15)|0||0 |
| 36 | gmlc_number|VARCHAR(15)|0||0 |
| 37 | hlr_number|VARCHAR(15)|0||0 |
| 38 | id|INTEGER|0||1 |
| 39 | imeisv|VARCHAR|0||0 |
| 40 | imsi|VARCHAR(15)|1||0 |
| 41 | lmsi|INTEGER|0||0 |
| 42 | ms_purged_cs|BOOLEAN|1|0|0 |
| 43 | ms_purged_ps|BOOLEAN|1|0|0 |
| 44 | msisdn|VARCHAR(15)|0||0 |
| 45 | nam_cs|BOOLEAN|1|1|0 |
| 46 | nam_ps|BOOLEAN|1|1|0 |
| 47 | periodic_lu_tmr|INTEGER|0||0 |
| 48 | periodic_rau_tau_tmr|INTEGER|0||0 |
| 49 | sgsn_address|VARCHAR|0||0 |
| 50 | sgsn_number|VARCHAR(15)|0||0 |
| 51 | smsc_number|VARCHAR(15)|0||0 |
| 52 | vlr_number|VARCHAR(15)|0||0 |
| 53 | |
| 54 | Table subscriber contents: |
| 55 | 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 |
| 56 | |||1||123456789012345||0|0|098765432109876|1|1||||||MSC-1 |
| 57 | |||2||111111111||1|0||1|1|||||| |
| 58 | |||3||222222222||0|1|22222|1|1|||||| |
| 59 | |||4||333333||0|0|3|0|1|||||| |
| 60 | |||5||444444444444444||0|0|4444|1|0|||||| |
| 61 | |||6||5555555||0|0|55555555555555|0|0|||||| |
| 62 | |
| 63 | Table: subscriber_apn |
| 64 | name|type|notnull|dflt_value|pk |
| 65 | apn|VARCHAR(256)|1||0 |
| 66 | subscriber_id|INTEGER|0||0 |
| 67 | |
| 68 | Table subscriber_apn contents: |
| 69 | |
| 70 | Table: subscriber_multi_msisdn |
| 71 | name|type|notnull|dflt_value|pk |
| 72 | msisdn|VARCHAR(15)|1||0 |
| 73 | subscriber_id|INTEGER|0||0 |
| 74 | |
| 75 | Table subscriber_multi_msisdn contents: |
| 76 | |
| 77 | Launching osmo-hlr to upgrade db: |
| 78 | osmo-hlr --database $db --db-upgrade --db-check --config-file $srcdir/osmo-hlr.cfg |
| 79 | rc = 0 |
| 80 | DMAIN hlr starting |
| 81 | DDB using database: <PATH>test.db |
| 82 | DDB Database <PATH>test.db' has HLR DB schema version 0 |
Neels Hofmeyr | 981e126 | 2019-11-05 02:00:19 +0100 | [diff] [blame] | 83 | DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 1 |
| 84 | DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 2 |
Neels Hofmeyr | a8045da | 2019-10-31 01:19:44 +0100 | [diff] [blame] | 85 | DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 3 |
Neels Hofmeyr | 07e1602 | 2019-11-20 02:36:35 +0100 | [diff] [blame] | 86 | DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 4 |
Neels Hofmeyr | f6c8f04 | 2019-11-25 03:59:50 +0100 | [diff] [blame] | 87 | DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 5 |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 88 | DMAIN Cmdline option --db-check: Database was opened successfully, quitting. |
| 89 | |
| 90 | Resulting db: |
| 91 | |
| 92 | Table: auc_2g |
| 93 | name|type|notnull|dflt_value|pk |
| 94 | algo_id_2g|INTEGER|1||0 |
| 95 | ki|VARCHAR(32)|1||0 |
| 96 | subscriber_id|INTEGER|0||1 |
| 97 | |
| 98 | Table auc_2g contents: |
| 99 | algo_id_2g|ki|subscriber_id |
| 100 | 1|BeefedCafeFaceAcedAddedDecadeFee|1 |
| 101 | 2|33333333333333333333333333333333|4 |
| 102 | 4|55555555555555555555555555555555|6 |
| 103 | |
| 104 | Table: auc_3g |
| 105 | name|type|notnull|dflt_value|pk |
| 106 | algo_id_3g|INTEGER|1||0 |
| 107 | ind_bitlen|INTEGER|1|5|0 |
| 108 | k|VARCHAR(32)|1||0 |
| 109 | op|VARCHAR(32)|0||0 |
| 110 | opc|VARCHAR(32)|0||0 |
| 111 | sqn|INTEGER|1|0|0 |
| 112 | subscriber_id|INTEGER|0||1 |
| 113 | |
| 114 | Table auc_3g contents: |
| 115 | algo_id_3g|ind_bitlen|k|op|opc|sqn|subscriber_id |
| 116 | 5|5|C01ffedC1cadaeAc1d1f1edAcac1aB0a||CededEffacedAceFacedBadFadedBeef|0|1 |
| 117 | 5|5|44444444444444444444444444444444|44444444444444444444444444444444||0|5 |
| 118 | 5|5|55555555555555555555555555555555||55555555555555555555555555555555|0|6 |
| 119 | |
| 120 | Table: subscriber |
| 121 | name|type|notnull|dflt_value|pk |
| 122 | ggsn_number|VARCHAR(15)|0||0 |
| 123 | gmlc_number|VARCHAR(15)|0||0 |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 124 | id|INTEGER|0||1 |
| 125 | imei|VARCHAR(14)|0||0 |
| 126 | imeisv|VARCHAR|0||0 |
| 127 | imsi|VARCHAR(15)|1||0 |
| 128 | last_lu_seen|TIMESTAMP|0|NULL|0 |
Neels Hofmeyr | 07e1602 | 2019-11-20 02:36:35 +0100 | [diff] [blame] | 129 | last_lu_seen_ps|TIMESTAMP|0|NULL|0 |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 130 | lmsi|INTEGER|0||0 |
| 131 | ms_purged_cs|BOOLEAN|1|0|0 |
| 132 | ms_purged_ps|BOOLEAN|1|0|0 |
Neels Hofmeyr | a8045da | 2019-10-31 01:19:44 +0100 | [diff] [blame] | 133 | msc_number|VARCHAR(15)|0||0 |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 134 | msisdn|VARCHAR(15)|0||0 |
| 135 | nam_cs|BOOLEAN|1|1|0 |
| 136 | nam_ps|BOOLEAN|1|1|0 |
| 137 | periodic_lu_tmr|INTEGER|0||0 |
| 138 | periodic_rau_tau_tmr|INTEGER|0||0 |
| 139 | sgsn_address|VARCHAR|0||0 |
| 140 | sgsn_number|VARCHAR(15)|0||0 |
Neels Hofmeyr | f6c8f04 | 2019-11-25 03:59:50 +0100 | [diff] [blame] | 141 | sgsn_via_proxy|VARCHAR|0||0 |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 142 | smsc_number|VARCHAR(15)|0||0 |
| 143 | vlr_number|VARCHAR(15)|0||0 |
Neels Hofmeyr | f6c8f04 | 2019-11-25 03:59:50 +0100 | [diff] [blame] | 144 | vlr_via_proxy|VARCHAR|0||0 |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 145 | |
| 146 | Table subscriber contents: |
Neels Hofmeyr | f6c8f04 | 2019-11-25 03:59:50 +0100 | [diff] [blame] | 147 | 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 |
| 148 | ||1|||123456789012345||||0|0||098765432109876|1|1|||||||MSC-1| |
| 149 | ||2|||111111111||||1|0|||1|1|||||||| |
| 150 | ||3|||222222222||||0|1||22222|1|1|||||||| |
| 151 | ||4|||333333||||0|0||3|0|1|||||||| |
| 152 | ||5|||444444444444444||||0|0||4444|1|0|||||||| |
| 153 | ||6|||5555555||||0|0||55555555555555|0|0|||||||| |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 154 | |
| 155 | Table: subscriber_apn |
| 156 | name|type|notnull|dflt_value|pk |
| 157 | apn|VARCHAR(256)|1||0 |
| 158 | subscriber_id|INTEGER|0||0 |
| 159 | |
| 160 | Table subscriber_apn contents: |
| 161 | |
| 162 | Table: subscriber_multi_msisdn |
| 163 | name|type|notnull|dflt_value|pk |
| 164 | msisdn|VARCHAR(15)|1||0 |
| 165 | subscriber_id|INTEGER|0||0 |
| 166 | |
| 167 | Table subscriber_multi_msisdn contents: |
| 168 | |
| 169 | Verify that osmo-hlr can open it: |
| 170 | osmo-hlr --database $db --db-check --config-file $srcdir/osmo-hlr.cfg |
| 171 | rc = 0 |
| 172 | DMAIN hlr starting |
| 173 | DDB using database: <PATH>test.db |
Neels Hofmeyr | f6c8f04 | 2019-11-25 03:59:50 +0100 | [diff] [blame] | 174 | DDB Database <PATH>test.db' has HLR DB schema version 5 |
Neels Hofmeyr | 5b65461 | 2019-10-31 02:03:48 +0100 | [diff] [blame] | 175 | DMAIN Cmdline option --db-check: Database was opened successfully, quitting. |