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   );