diff options
| author | Max <msuraev@sysmocom.de> | 2017-02-20 11:18:04 +0100 |
|---|---|---|
| committer | Max <msuraev@sysmocom.de> | 2017-02-21 11:45:08 +0100 |
| commit | 3ce368676849b54f40fc426bf3eb136e17091416 (patch) | |
| tree | 4cc9745881d6ba2798fd2fbaa463e31db1b02aa3 /src/db.c | |
| parent | 58d4a84a3198bc6c30f5fc9f2182ec2de5deb446 (diff) | |
Add routines to update nam_ps
Add SQL queries to change nam_ps value and function which uses them.
Change-Id: I24fb79e084b2dfa6a81b52f448b94a86e47014ef
Diffstat (limited to 'src/db.c')
| -rw-r--r-- | src/db.c | 2 |
1 files changed, 2 insertions, 0 deletions
@@ -33,6 +33,8 @@ static const char *stmt_sql[] = { [AUC_UPD_SQN] = "UPDATE auc_3g SET sqn = ? WHERE subscriber_id = ?", [UPD_PURGE_CS_BY_IMSI] = "UPDATE subscriber SET ms_purged_cs=1 WHERE imsi = ?", [UPD_PURGE_PS_BY_IMSI] = "UPDATE subscriber SET ms_purged_ps=1 WHERE imsi = ?", + [SET_NAM_PS_BY_IMSI] = "UPDATE subscriber SET nam_ps=1 WHERE imsi = ?", + [UNSET_NAM_PS_BY_IMSI] = "UPDATE subscriber SET nam_ps=0 WHERE imsi = ?", }; static void sql3_error_log_cb(void *arg, int err_code, const char *msg) |