26cce31253e9caa99d25ee83bd237940b935df3b
[strongswan.git] / testing / tests / tnc / tnccs-20-os / hosts / moon / etc / pts / data1.sql
1 /* Devices */
2
3 INSERT INTO devices ( /* 1 */
4 value, product, created
5 ) VALUES (
6 'aabbccddeeff11223344556677889900', 40, 1372330615
7 );
8
9 /* Groups Members */
10
11 INSERT INTO groups_members (
12 group_id, device_id
13 ) VALUES (
14 5, 1
15 );
16
17 /* Identities */
18
19 INSERT INTO identities (
20 type, value
21 ) VALUES ( /* dave@strongswan.org */
22 4, X'64617665407374726f6e677377616e2e6f7267'
23 );
24
25 /* Sessions */
26
27 INSERT INTO sessions (
28 time, connection, identity, device, product, rec
29 ) VALUES (
30 NOW, 1, 1, 1, 40, 0
31 );
32
33 /* Results */
34
35 INSERT INTO results (
36 session, policy, rec, result
37 ) VALUES (
38 1, 1, 0, 'processed 355 packages: 0 not updated, 0 blacklisted, 4 ok, 351 not found'
39 );
40
41 /* Enforcements */
42
43 UPDATE enforcements SET
44 rec_fail = 2, rec_noresult = 2
45 WHERE id = 3;