diff options
author | Neels Hofmeyr <nhofmeyr@sysmocom.de> | 2017-01-30 13:47:22 +0100 |
---|---|---|
committer | Neels Hofmeyr <nhofmeyr@sysmocom.de> | 2017-02-01 13:58:50 +0100 |
commit | 24537b95bd4f8bfddeaaa23d75d5ab8a94aa4497 (patch) | |
tree | f51e799d1ee3660e1821146ec25b36166c5ae575 /sql | |
parent | 7685a7875743f6ccc72f814d7c620214703ddeba (diff) |
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
Diffstat (limited to 'sql')
-rw-r--r-- | sql/hlr.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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_2g ( 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 |