testing: Add test config to create and remove a directory for DBs stored in ramfs
[strongswan.git] / testing / tests / tnc / tnccs-20-hcd-eap / hosts / alice / etc / pts / data1.sql
1 /* Devices */
2
3 INSERT INTO devices ( /* 1 */
4 value, product, created
5 )
6 SELECT 'aabbccddeeff11223344556677889900', id, 1372330615
7 FROM products WHERE name = 'Debian DEBIAN_VERSION x86_64';
8
9 /* Groups Members */
10
11 INSERT INTO groups_members (
12 group_id, device_id
13 ) VALUES (
14 10, 1
15 );
16
17 /* Identities */
18
19 INSERT INTO identities (
20 type, value
21 ) VALUES ( /* dave@strongswan.org */
22 5, X'64617665'
23 );
24
25 /* Sessions */
26
27 INSERT INTO sessions (
28 time, connection, identity, device, product, rec
29 )
30 SELECT NOW, 1, 1, 1, id, 0
31 FROM products WHERE name = 'Debian DEBIAN_VERSION x86_64';
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 INSERT INTO enforcements (
44 policy, group_id, max_age, rec_fail, rec_noresult
45 ) VALUES (
46 3, 10, 0, 2, 2
47 );
48
49 INSERT INTO enforcements (
50 policy, group_id, max_age
51 ) VALUES (
52 17, 2, 86400
53 );
54
55 INSERT INTO enforcements (
56 policy, group_id, max_age
57 ) VALUES (
58 18, 10, 86400
59 );
60
61 DELETE FROM enforcements WHERE id = 1;