diff options
-rw-r--r-- | sql/hlr.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/hlr.sql b/sql/hlr.sql index 5a02be3..9238871 100644 --- a/sql/hlr.sql +++ b/sql/hlr.sql @@ -3,9 +3,9 @@ CREATE TABLE subscriber ( id INTEGER PRIMARY KEY, -- Chapter 2.1.1.1 - imsi VARCHAR(15) NOT NULL, + imsi VARCHAR(15) UNIQUE NOT NULL, -- Chapter 2.1.2 - msisdn VARCHAR(15), + msisdn VARCHAR(15) UNIQUE, -- Chapter 2.2.3: Most recent / current IMEI imeisv VARCHAR, -- Chapter 2.4.5 |