diff options
author | Neels Hofmeyr <neels@hofmeyr.de> | 2019-10-31 01:19:44 +0100 |
---|---|---|
committer | laforge <laforge@osmocom.org> | 2019-11-12 16:23:48 +0000 |
commit | a8045daeef048ee1181f2a3c9bc15e7cd6c1dfca (patch) | |
tree | cb34a937ae2fddd83b7036875434bce9f19a0eb3 /sql/hlr.sql | |
parent | 4359b885d4521fb4b9e6a9b4eae579d0ae857260 (diff) |
hlr db schema 3: hlr_number -> msc_number
The osmo-hlr DB schema indicates a hlr_number column and references it as 3GPP
TS 23.008 chapter 2.4.6. However, chapter 2.4.6 refers to the "MSC number",
while the "HLR number" is chapter 2.4.7.
Taking a closer look, 2.4.6 says "The MSC number is [...] stored in the HLR",
while 2.4.7 says "The HLR number may be stored in the VLR". As quite obvious,
the HLR does not store the HLR number. This was a typo from the start.
The osmo-hlr code base so far does not use the hlr_number column at all, so we
get away with renaming the column without any effects on the code base.
However, let's rather make this a new schema version to be safe.
Change-Id: I527e8627b24b79f3e9eec32675c7f5a3a6d25440
Diffstat (limited to 'sql/hlr.sql')
-rw-r--r-- | sql/hlr.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/hlr.sql b/sql/hlr.sql index c1b0f1a..f8fdc0b 100644 --- a/sql/hlr.sql +++ b/sql/hlr.sql @@ -12,7 +12,7 @@ CREATE TABLE subscriber ( -- Chapter 2.4.5 vlr_number VARCHAR(15), -- Chapter 2.4.6 - hlr_number VARCHAR(15), + msc_number VARCHAR(15), -- Chapter 2.4.8.1 sgsn_number VARCHAR(15), -- Chapter 2.13.10 @@ -77,4 +77,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 = 2; +PRAGMA user_version = 3; |