diff options
author | Neels Hofmeyr <neels@hofmeyr.de> | 2019-11-25 03:59:50 +0100 |
---|---|---|
committer | Neels Hofmeyr <neels@hofmeyr.de> | 2019-12-16 16:21:53 +0100 |
commit | f0c02ad9c74cb7a548d23988a97d5760e77c6f1c (patch) | |
tree | ae17e0ecd3f47b40c0424cc8e1a8379eda1db97f /sql/hlr.sql | |
parent | 43c36f99ddd87151bc2ea56828402f46b9e0a1b2 (diff) |
db v5: prep for D-GSM: add vlr_via_proxy and sgsn_via_proxy
D-GSM will store in the HLR DB whether a locally connected MSC has attached the
subscriber (last_lu_seen[_ps]), or whether the attach happened via a GSUP proxy
from a different site.
Add columns for this separately in this patch.
Change-Id: I98c7b3870559ede84adf56e4bf111f53c7487745
Diffstat (limited to 'sql/hlr.sql')
-rw-r--r-- | sql/hlr.sql | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/sql/hlr.sql b/sql/hlr.sql index ad57661..98e586d 100644 --- a/sql/hlr.sql +++ b/sql/hlr.sql @@ -43,7 +43,12 @@ CREATE TABLE subscriber ( -- Timestamp of last location update seen from subscriber -- The value is a string which encodes a UTC timestamp in granularity of seconds. last_lu_seen TIMESTAMP default NULL, - last_lu_seen_ps TIMESTAMP default NULL + last_lu_seen_ps TIMESTAMP default NULL, + + -- When a LU was received via a proxy, that proxy's hlr_number is stored here, + -- while vlr_number reflects the MSC on the far side of that proxy. + vlr_via_proxy VARCHAR, + sgsn_via_proxy VARCHAR ); CREATE TABLE subscriber_apn ( @@ -78,4 +83,4 @@ CREATE UNIQUE INDEX idx_subscr_imsi ON subscriber (imsi); -- Set HLR database schema version number -- Note: This constant is currently duplicated in src/db.c and must be kept in sync! -PRAGMA user_version = 4; +PRAGMA user_version = 5; |