diff options
| author | Neels Hofmeyr <nhofmeyr@sysmocom.de> | 2017-02-01 04:40:13 +0100 |
|---|---|---|
| committer | Neels Hofmeyr <nhofmeyr@sysmocom.de> | 2017-02-01 13:58:50 +0100 |
| commit | 862f1dc4fd9256f7cd01a32ac70d1ec6737fa816 (patch) | |
| tree | de1e99bc8a8a9196dfb7c1564066f9e99da77d0c | |
| parent | 24537b95bd4f8bfddeaaa23d75d5ab8a94aa4497 (diff) | |
cosmetic: sql: indicate VARCHAR size of key columns as 32
Notably this has no functional effect (according to
https://sqlite.org/faq.html#q9 ), but it can't hurt to indicate intent.
Change-Id: I2b0f9369318085c1482c6d2d8db56699466bfbf3
| -rw-r--r-- | sql/hlr.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/hlr.sql b/sql/hlr.sql index ab9d173..e05587b 100644 --- a/sql/hlr.sql +++ b/sql/hlr.sql @@ -54,15 +54,15 @@ CREATE TABLE subscriber_multi_msisdn ( CREATE TABLE auc_2g ( subscriber_id INTEGER PRIMARY KEY, -- subscriber.id algo_id_2g INTEGER NOT NULL, - ki VARCHAR NOT NULL + ki VARCHAR(32) NOT NULL ); CREATE TABLE auc_3g ( subscriber_id INTEGER PRIMARY KEY, -- subscriber.id algo_id_3g INTEGER NOT NULL, k VARCHAR(32) NOT NULL, - op VARCHAR, - opc VARCHAR, + op VARCHAR(32), + opc VARCHAR(32), sqn INTEGER ); |