[MERGED] osmo-hlr[master]: comment: sql: describe auc_2g and auc_3g columns

Neels Hofmeyr gerrit-no-reply at lists.osmocom.org
Wed Feb 1 13:01:17 UTC 2017


Neels Hofmeyr has submitted this change and it was merged.

Change subject: comment: sql: describe auc_2g and auc_3g columns
......................................................................


comment: sql: describe auc_2g and auc_3g columns

Change-Id: Ie4edc69ff11a83a4c0f79097f43a2cb206dfe405
---
M sql/hlr.sql
1 file changed, 7 insertions(+), 7 deletions(-)

Approvals:
  Holger Freyther: Looks good to me, approved



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 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);

-- 
To view, visit https://gerrit.osmocom.org/1709
To unsubscribe, visit https://gerrit.osmocom.org/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: Ie4edc69ff11a83a4c0f79097f43a2cb206dfe405
Gerrit-PatchSet: 4
Gerrit-Project: osmo-hlr
Gerrit-Branch: master
Gerrit-Owner: Neels Hofmeyr <nhofmeyr at sysmocom.de>
Gerrit-Reviewer: Holger Freyther <holger at freyther.de>
Gerrit-Reviewer: Jenkins Builder


More information about the gerrit-log mailing list