diff options
| author | Neels Hofmeyr <neels@hofmeyr.de> | 2017-10-10 02:25:00 +0200 |
|---|---|---|
| committer | Neels Hofmeyr <neels@hofmeyr.de> | 2017-10-11 22:32:19 +0200 |
| commit | 1332a17a3db46bae7e2ee720baf21c594e1b2331 (patch) | |
| tree | ccac4b3683ba3184f8ee4e06c03823a7782250d0 /src/db.c | |
| parent | e50121ec96c2457c66501d7b6e1fcd539ee3c5e1 (diff) | |
add db_subscr_update_aud_by_id(), complete db_subscr_delete_by_id()
Add ability to add and remove auc_2g and auc_3g table rows with
db_subscr_update_aud_by_id().
In db_subscr_delete_by_id(), make sure that when deleting a subscriber, also
all auth data associated with that user ID is removed as well. A newly created
subscriber must not obtain the same auth tokens just by getting the same id.
Depends: libosmocore Idf75946eb0a84e145adad13fc7c78bb7a267aa0a
Change-Id: Icb11b5e059fb920447a9aa414db1819a0c020529
Diffstat (limited to 'src/db.c')
| -rw-r--r-- | src/db.c | 8 |
1 files changed, 8 insertions, 0 deletions
@@ -61,6 +61,14 @@ static const char *stmt_sql[] = { [DB_STMT_SUBSCR_CREATE] = "INSERT INTO subscriber (imsi) VALUES ($imsi)", [DB_STMT_DEL_BY_ID] = "DELETE FROM subscriber WHERE id = $subscriber_id", [DB_STMT_SET_MSISDN_BY_IMSI] = "UPDATE subscriber SET msisdn = $msisdn WHERE imsi = $imsi", + [DB_STMT_AUC_2G_INSERT] = + "INSERT INTO auc_2g (subscriber_id, algo_id_2g, ki)" + " VALUES($subscriber_id, $algo_id_2g, $ki)", + [DB_STMT_AUC_2G_DELETE] = "DELETE FROM auc_2g WHERE subscriber_id = $subscriber_id", + [DB_STMT_AUC_3G_INSERT] = + "INSERT INTO auc_3g (subscriber_id, algo_id_3g, k, op, opc, ind_bitlen)" + " VALUES($subscriber_id, $algo_id_3g, $k, $op, $opc, $ind_bitlen)", + [DB_STMT_AUC_3G_DELETE] = "DELETE FROM auc_3g WHERE subscriber_id = $subscriber_id", }; static void sql3_error_log_cb(void *arg, int err_code, const char *msg) |