diff options
| author | Neels Hofmeyr <neels@hofmeyr.de> | 2019-10-31 19:43:36 +0100 |
|---|---|---|
| committer | Neels Hofmeyr <neels@hofmeyr.de> | 2019-10-31 19:50:28 +0100 |
| commit | f8ad67e7fc8a38774dfb991489670672520fce55 (patch) | |
| tree | 3af477acb50298a081957e42e145bebb32e3f9a2 | |
| parent | c3d40326ec5c78e41f2bf0bf2ed2c413113e0e84 (diff) | |
hlr.sql: move comment
Move a comment for ind_bitlen column to a separate line, so that it doesn't
show in PRAGMA_TABLE_INFO('subscriber').
An upcoming patch introduces db_upgrade_test, which dumps a sorted db schema.
In newer sqlite3 versions, a comment following a 'DEFAULT' keyword actually
shows up in the PRAGMA_TABLE_INFO() results (on my machine), but older versions
(on the build slaves) drop that comment. The ind_bitlen column is the only one
producing this odd side effect, because it is the last column and has no comma
between 'DEFAULT' and the comment.
The easiest way to get matching results across sqlite3 client versions is to
move the comment to above ind_bitlen instead of having it on the same line.
(Adding a comma doesn't work.)
Change-Id: Id66ad68dd3f22d533fc3a428223ea6ad0282bde0
| -rw-r--r-- | sql/hlr.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/hlr.sql b/sql/hlr.sql index 10838f2..c1b0f1a 100644 --- a/sql/hlr.sql +++ b/sql/hlr.sql @@ -69,7 +69,8 @@ CREATE TABLE auc_3g ( 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 - ind_bitlen INTEGER NOT NULL DEFAULT 5 -- nr of index bits at lower SQN end + -- nr of index bits at lower SQN end + ind_bitlen INTEGER NOT NULL DEFAULT 5 ); CREATE UNIQUE INDEX idx_subscr_imsi ON subscriber (imsi); |