summaryrefslogtreecommitdiff
path: root/testing/tests/tnc/tnccs-20-ev-pt-tls/hosts/carol/etc/pts/collector.sql
blob: 548c101e48a19e5f1f06caf75ee43f43ba8b7683 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
/* SW Identifiers */

INSERT INTO sw_identifiers (
  name, package, version, source, installed
) VALUES (
	'strongswan.org__Debian_DEBIAN_VERSION-x86_64-libutempter0-1.1.5', 'libutempter0', '1.1.5', 1, 0
);

INSERT INTO sw_identifiers (
  name, package, version, source, installed
) VALUES (
  'strongswan.org__Debian_DEBIAN_VERSION-x86_64-libevent-2.0-5-2.0.20', 'libevent-2.0-5', '2.0.20', 1, 0
);

INSERT INTO sw_identifiers (
  name, package, version, source, installed
) VALUES (
  'strongswan.org__Debian_DEBIAN_VERSION-x86_64-tmux-2.2', 'tmux', '2.2', 1, 0
);

/* SW Events */

INSERT INTO sw_events (
  eid, sw_id, action
) VALUES (
  2, 1, 2
);

INSERT INTO sw_events (
  eid, sw_id, action
) VALUES (
  2, 2, 2
);

INSERT INTO sw_events (
  eid, sw_id, action
) VALUES (
  2, 3, 2
);