Neels Hofmeyr | f88c914 | 2017-09-25 23:23:57 +0200 | [diff] [blame] | 1 | |
| 2 | -- 2G only subscriber |
Neels Hofmeyr | 446eb0f | 2017-10-17 01:58:24 +0200 | [diff] [blame] | 3 | INSERT INTO subscriber (id, imsi, msisdn) VALUES (1, '901990000000001', '1'); |
Neels Hofmeyr | f88c914 | 2017-09-25 23:23:57 +0200 | [diff] [blame] | 4 | INSERT INTO auc_2g (subscriber_id, algo_id_2g, ki) VALUES (1, 1, '000102030405060708090a0b0c0d0e0f'); |
| 5 | |
| 6 | -- 3G only subscriber |
| 7 | INSERT INTO subscriber (id, imsi) VALUES (2, '901990000000002'); |
Neels Hofmeyr | 446eb0f | 2017-10-17 01:58:24 +0200 | [diff] [blame] | 8 | INSERT INTO auc_3g (subscriber_id, algo_id_3g, k, opc, sqn) VALUES (2, 5, '000102030405060708090a0b0c0d0e0f', '101112131415161718191a1b1c1d1e1f', 4223); |
Neels Hofmeyr | f88c914 | 2017-09-25 23:23:57 +0200 | [diff] [blame] | 9 | |
| 10 | -- 2G + 3G subscriber |
Neels Hofmeyr | 446eb0f | 2017-10-17 01:58:24 +0200 | [diff] [blame] | 11 | INSERT INTO subscriber (id, imsi, msisdn) VALUES (3, '901990000000003', '103'); |
Neels Hofmeyr | f88c914 | 2017-09-25 23:23:57 +0200 | [diff] [blame] | 12 | INSERT INTO auc_2g (subscriber_id, algo_id_2g, ki) VALUES (3, 1, '000102030405060708090a0b0c0d0e0f'); |
Neels Hofmeyr | 446eb0f | 2017-10-17 01:58:24 +0200 | [diff] [blame] | 13 | INSERT INTO auc_3g (subscriber_id, algo_id_3g, k, opc, sqn) VALUES (3, 5, '000102030405060708090a0b0c0d0e0f', '101112131415161718191a1b1c1d1e1f', 2342); |
Neels Hofmeyr | 3f697cd | 2017-10-17 22:26:00 +0200 | [diff] [blame] | 14 | |
| 15 | -- A subscriber id > 7 and > 15 to check against octal and hex notations |
| 16 | INSERT INTO subscriber (id, imsi, msisdn) VALUES (123, '123123', '123'); |
| 17 | INSERT INTO auc_2g (subscriber_id, algo_id_2g, ki) VALUES (123, 3, 'BeefedCafeFaceAcedAddedDecadeFee'); |