diff options
author | Neels Hofmeyr <nhofmeyr@sysmocom.de> | 2017-01-30 13:49:49 +0100 |
---|---|---|
committer | Neels Hofmeyr <nhofmeyr@sysmocom.de> | 2017-02-01 13:58:50 +0100 |
commit | 8089d51f7483926cc253b19550e5fed4171d9b9f (patch) | |
tree | 11b448ff62bbbdfa659a1714b988c1f48eafd1b5 | |
parent | d71dbec7b6df3535ee05471fa1986a8eb26463c2 (diff) |
comment: sql: describe auc_2g and auc_3g columns
Change-Id: Ie4edc69ff11a83a4c0f79097f43a2cb206dfe405
-rw-r--r-- | sql/hlr.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/sql/hlr.sql b/sql/hlr.sql index 354043c..5a02be3 100644 --- a/sql/hlr.sql +++ b/sql/hlr.sql @@ -53,17 +53,17 @@ CREATE TABLE subscriber_multi_msisdn ( CREATE TABLE auc_2g ( subscriber_id INTEGER PRIMARY KEY, -- subscriber.id - algo_id_2g INTEGER NOT NULL, - ki VARCHAR(32) NOT NULL + algo_id_2g INTEGER NOT NULL, -- enum osmo_auth_algo value + ki VARCHAR(32) NOT NULL -- hex string: subscriber's secret key (128bit) ); CREATE TABLE auc_3g ( subscriber_id INTEGER PRIMARY KEY, -- subscriber.id - algo_id_3g INTEGER NOT NULL, - k VARCHAR(32) NOT NULL, - op VARCHAR(32), - opc VARCHAR(32), - sqn INTEGER NOT NULL DEFAULT 0 + algo_id_3g INTEGER NOT NULL, -- enum osmo_auth_algo value + k VARCHAR(32) NOT NULL, -- hex string: subscriber's secret key (128bit) + op VARCHAR(32), -- hex string: operator's secret key (128bit) + opc VARCHAR(32), -- hex string: derived from OP and K (128bit) + sqn INTEGER NOT NULL DEFAULT 0 -- sequence number of key usage ); CREATE UNIQUE INDEX IF NOT EXISTS idx_subscr_imsi ON subscriber (imsi); |