aboutsummaryrefslogtreecommitdiffstats
path: root/src/charon/plugins/sql/test.sql
blob: ec5b401c56ece277af38b9a70ee081b40d45ee02 (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
40
41
42
43
44
45
46
47

INSERT INTO ike_configs (
	certreq, force_encap, local, remote
) VALUES (
	0, 0, '0.0.0.0', '152.96.52.150'
);

INSERT INTO child_configs (
	name, lifetime, rekeytime, jitter, updown, hostaccess, mode
) VALUES (
	'sqltest', 500, 400, 50, NULL, 1, 1
);

INSERT INTO peer_config_child_config (
	peer_cfg, child_cfg
) VALUES (
	1, 1
);

INSERT INTO traffic_selectors (
	type, protocol
) values (
	7, 0
);

INSERT INTO child_config_traffic_selector (
	child_cfg, traffic_selector, kind
) VALUES (
	1, 1, 2
);

INSERT INTO child_config_traffic_selector (
	child_cfg, traffic_selector, kind
) VALUES (
	1, 1, 3
);

INSERT INTO peer_configs (
	name, ike_version, ike_cfg, local_id, remote_id, cert_policy, auth_method, 
	eap_type, eap_vendor, keyingtries, rekeytime, reauthtime, jitter, overtime, 
	mobike, dpd_delay, dpd_action, local_vip, remote_vip, 
	mediation, mediated_by, peer_id
) VALUES (
	'sqltest', 2, 1, 'C=CH, O=Linux strongSwan, CN=martin', 'sidv0150.hsr.ch', 0, 0, 
	0, 0, 0, 500, 2000, 20, 20,
	1, 120, 0, NULL, NULL, 0, 0, NULL
);