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
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 @@
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);