99b4a263552a963bd0bfca4706e77d74f0038068
[strongswan.git] / src / libcharon / plugins / eap_simaka_sql / test.sql
1 DELETE FROM triplets;
2 DELETE FROM quintuplets;
3
4 INSERT INTO triplets
5 (id, used, rand, sres, kc) VALUES
6 ('moon@strongswan.org', 0,
7 X'00112233445566778899AABBCCDDEEFF', X'01234567', X'0123456789ABCDEF'
8 );
9 INSERT INTO triplets
10 (id, used, rand, sres, kc) VALUES
11 ('moon@strongswan.org', 0,
12 X'112233445566778899AABBCCDDEEFF00', X'12345678', X'123456789ABCDEF0'
13 );
14 INSERT INTO triplets
15 (id, used, rand, sres, kc) VALUES
16 ('moon@strongswan.org', 0,
17 X'2233445566778899AABBCCDDEEFF0011', X'23456789', X'23456789ABCDEF01'
18 );
19
20 INSERT INTO quintuplets
21 (id, used, rand, autn, ck, ik, res) VALUES
22 ('moon@strongswan.org', 0,
23 X'00112233445566778899AABBCCDDEEFF',
24 X'112233445566778899AABBCCDDEEFF00',
25 X'2233445566778899AABBCCDDEEFF0011',
26 X'33445566778899AABBCCDDEEFF001122',
27 X'00112233445566778899'
28 );