comment: sql: describe auc_2g and auc_3g columns
Change-Id: Ie4edc69ff11a83a4c0f79097f43a2cb206dfe405
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);