Annotation of embedaddon/strongswan/testing/tests/tnc/tnccs-20-pdp-eap/hosts/alice/etc/pts/data1.sql, revision 1.1.1.1
1.1 misho 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;
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>