blob: 0767d486453330a6791636031643642d88f61fe0 [file] [log] [blame]
Harald Weltee72cf552016-04-28 07:18:49 +02001
2-- 2G only subscriber
3INSERT INTO subscriber (id, imsi) VALUES (1, '901990000000001');
4INSERT INTO auc_2g (subscriber_id, algo_id_2g, ki) VALUES (1, 1, '000102030405060708090a0b0c0d0e0f');
5
6-- 3G only subscriber
7INSERT INTO subscriber (id, imsi) VALUES (2, '901990000000002');
Daniel Willmann69f38602017-05-16 14:17:08 +02008INSERT INTO auc_3g (subscriber_id, algo_id_3g, k, opc, sqn) VALUES (2, 5, '000102030405060708090a0b0c0d0e0f', '101112131415161718191a1b1c1d1e1f', 0);
Harald Weltee72cf552016-04-28 07:18:49 +02009
10-- 2G + 3G subscriber
11INSERT INTO subscriber (id, imsi) VALUES (3, '901990000000003');
12INSERT INTO auc_2g (subscriber_id, algo_id_2g, ki) VALUES (3, 1, '000102030405060708090a0b0c0d0e0f');
Daniel Willmann69f38602017-05-16 14:17:08 +020013INSERT INTO auc_3g (subscriber_id, algo_id_3g, k, opc, sqn) VALUES (3, 5, '000102030405060708090a0b0c0d0e0f', '101112131415161718191a1b1c1d1e1f', 0);