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

This is merely a historical archive of years 2008-2021, before the migration to mailman3.

A maintained and still updated list archive can be found at https://lists.osmocom.org/hyperkitty/list/gerrit-log@lists.osmocom.org/.

Neels Hofmeyr gerrit-no-reply at lists.osmocom.org
Mon Jan 30 22:32:18 UTC 2017


Hello Jenkins Builder,

I'd like you to reexamine a change.  Please visit

    https://gerrit.osmocom.org/1708

to look at the new patch set (#2).

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/2

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: newpatchset
Gerrit-Change-Id: Iaa8d33e303760bd15dcb7dc8bb8b9b24bf6c8f14
Gerrit-PatchSet: 2
Gerrit-Project: osmo-hlr
Gerrit-Branch: master
Gerrit-Owner: Neels Hofmeyr <nhofmeyr at sysmocom.de>
Gerrit-Reviewer: Jenkins Builder



More information about the gerrit-log mailing list