diff options
author | Neels Hofmeyr <neels@hofmeyr.de> | 2017-10-25 00:26:29 +0200 |
---|---|---|
committer | Neels Hofmeyr <neels@hofmeyr.de> | 2017-10-25 01:15:46 +0200 |
commit | 8f063796e9862d9ff1e93015562c401db49d0f9a (patch) | |
tree | e68385a74d6c13e1143ef902c1757f020b42467a | |
parent | 10df27f168e08f0790fa6e3a01096f82c83c0c60 (diff) |
cosmetic: sql/hlr.sql: move comments
By moving the comments inside the table row definitions, they are dumped back
during 'sqlite3 hlr.db .dump'. When they are between SQL statements, the
comments are lost.
Tweak wording.
Change-Id: I280c2e2d3e9b7f1dc632722724d9e1c54d041820
-rw-r--r-- | sql/hlr.sql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/sql/hlr.sql b/sql/hlr.sql index 696cf1c..80eb3e5 100644 --- a/sql/hlr.sql +++ b/sql/hlr.sql @@ -1,6 +1,5 @@ ---modelled roughly after TS 23.008 version 13.3.0 - CREATE TABLE IF NOT EXISTS subscriber ( +-- OsmoHLR's DB scheme is modelled roughly after TS 23.008 version 13.3.0 id INTEGER PRIMARY KEY, -- Chapter 2.1.1.1 imsi VARCHAR(15) UNIQUE NOT NULL, @@ -45,8 +44,8 @@ CREATE TABLE IF NOT EXISTS subscriber_apn ( apn VARCHAR(256) NOT NULL ); --- Chapter 2.1.3 CREATE TABLE IF NOT EXISTS subscriber_multi_msisdn ( +-- Chapter 2.1.3 subscriber_id INTEGER, -- subscriber.id msisdn VARCHAR(15) NOT NULL ); |