[PATCH] osmo-hlr[master]: sql: fix 3g_auc's column K data type

Neels Hofmeyr gerrit-no-reply at lists.osmocom.org
Mon Jan 30 12:50:35 UTC 2017


Review at  https://gerrit.osmocom.org/1708

sql: fix 3g_auc's column K data type

K is the SIM card's 128bit secret key, so the type should be VARCHAR like the
other key columns. The db code already reads the column as text and parses as
hex, so a VARCHAR column matches that.

Change-Id: Iaa8d33e303760bd15dcb7dc8bb8b9b24bf6c8f14
---
M sql/hlr.sql
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.osmocom.org:29418/osmo-hlr refs/changes/08/1708/1

diff --git a/sql/hlr.sql b/sql/hlr.sql
index 5f0950c..ab9d173 100644
--- a/sql/hlr.sql
+++ b/sql/hlr.sql
@@ -60,7 +60,7 @@
 CREATE TABLE auc_3g (
 	subscriber_id	INTEGER PRIMARY KEY,	-- subscriber.id
 	algo_id_3g	INTEGER NOT NULL,
-	k		INTEGER NOT NULL,
+	k		VARCHAR(32) NOT NULL,
 	op		VARCHAR,
 	opc		VARCHAR,
 	sqn		INTEGER

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iaa8d33e303760bd15dcb7dc8bb8b9b24bf6c8f14
Gerrit-PatchSet: 1
Gerrit-Project: osmo-hlr
Gerrit-Branch: master
Gerrit-Owner: Neels Hofmeyr <nhofmeyr at sysmocom.de>


More information about the gerrit-log mailing list