2049b900331696972fd6beee1fd383307b6144bd
[strongswan.git] / testing / tests / tnc / tnccs-20-pt-tls / hosts / alice / etc / pts / data.sql
1 /* Products */
2
3 INSERT INTO products ( /* 1 */
4 name
5 ) VALUES (
6 'Debian 6.0 i686'
7 );
8
9 INSERT INTO products ( /* 2 */
10 name
11 ) VALUES (
12 'Debian 6.0 x86_64'
13 );
14
15 INSERT INTO products ( /* 3 */
16 name
17 ) VALUES (
18 'Debian 7.0 i686'
19 );
20
21 INSERT INTO products ( /* 4 */
22 name
23 ) VALUES (
24 'Debian 7.0 x86_64'
25 );
26
27 INSERT INTO products ( /* 5 */
28 name
29 ) VALUES (
30 'Debian 8.0 i686'
31 );
32
33 INSERT INTO products ( /* 6 */
34 name
35 ) VALUES (
36 'Debian 8.0 x86_64'
37 );
38
39 INSERT INTO products ( /* 7 */
40 name
41 ) VALUES (
42 'Ubuntu 10.04 i686'
43 );
44
45 INSERT INTO products ( /* 8 */
46 name
47 ) VALUES (
48 'Ubuntu 10.04 x86_64'
49 );
50
51 INSERT INTO products ( /* 9 */
52 name
53 ) VALUES (
54 'Ubuntu 10.10 i686'
55 );
56
57 INSERT INTO products ( /* 10 */
58 name
59 ) VALUES (
60 'Ubuntu 10.10 x86_64'
61 );
62
63 INSERT INTO products ( /* 11 */
64 name
65 ) VALUES (
66 'Ubuntu 11.04 i686'
67 );
68
69 INSERT INTO products ( /* 12 */
70 name
71 ) VALUES (
72 'Ubuntu 11.04 x86_64'
73 );
74
75 INSERT INTO products ( /* 13 */
76 name
77 ) VALUES (
78 'Ubuntu 11.10 i686'
79 );
80
81 INSERT INTO products ( /* 14 */
82 name
83 ) VALUES (
84 'Ubuntu 11.10 x86_64'
85 );
86
87 INSERT INTO products ( /* 15 */
88 name
89 ) VALUES (
90 'Ubuntu 12.04 i686'
91 );
92
93 INSERT INTO products ( /* 16 */
94 name
95 ) VALUES (
96 'Ubuntu 12.04 x86_64'
97 );
98
99 INSERT INTO products ( /* 17 */
100 name
101 ) VALUES (
102 'Ubuntu 12.10 i686'
103 );
104
105 INSERT INTO products ( /* 18 */
106 name
107 ) VALUES (
108 'Ubuntu 12.10 x86_64'
109 );
110
111 INSERT INTO products ( /* 19 */
112 name
113 ) VALUES (
114 'Ubuntu 13.04 i686'
115 );
116
117 INSERT INTO products ( /* 20 */
118 name
119 ) VALUES (
120 'Ubuntu 13.04 x86_64'
121 );
122
123 INSERT INTO products ( /* 21 */
124 name
125 ) VALUES (
126 'Android 4.1.1'
127 );
128
129 INSERT INTO products ( /* 22 */
130 name
131 ) VALUES (
132 'Android 4.2.1'
133 );
134
135 /* Directories */
136
137 INSERT INTO directories ( /* 1 */
138 path
139 ) VALUES (
140 '/bin'
141 );
142
143 INSERT INTO directories ( /* 2 */
144 path
145 ) VALUES (
146 '/etc'
147 );
148
149 INSERT INTO directories ( /* 3 */
150 path
151 ) VALUES (
152 '/lib'
153 );
154
155 INSERT INTO directories ( /* 4 */
156 path
157 ) VALUES (
158 '/lib/i386-linux-gnu'
159 );
160
161 INSERT INTO directories ( /* 5 */
162 path
163 ) VALUES (
164 '/lib/x86_64-linux-gnu'
165 );
166
167 INSERT INTO directories ( /* 6 */
168 path
169 ) VALUES (
170 '/lib/xtables'
171 );
172
173 INSERT INTO directories ( /* 7 */
174 path
175 ) VALUES (
176 '/sbin'
177 );
178
179 INSERT INTO directories ( /* 8 */
180 path
181 ) VALUES (
182 '/usr/bin'
183 );
184
185 INSERT INTO directories ( /* 9 */
186 path
187 ) VALUES (
188 '/usr/lib'
189 );
190
191 INSERT INTO directories ( /* 10 */
192 path
193 ) VALUES (
194 '/usr/lib/i386-linux-gnu'
195 );
196
197 INSERT INTO directories ( /* 11 */
198 path
199 ) VALUES (
200 '/usr/lib/x86_64-linux-gnu'
201 );
202
203 INSERT INTO directories ( /* 12 */
204 path
205 ) VALUES (
206 '/usr/sbin'
207 );
208
209 INSERT INTO directories ( /* 13 */
210 path
211 ) VALUES (
212 '/system/bin'
213 );
214
215 INSERT INTO directories ( /* 14 */
216 path
217 ) VALUES (
218 '/system/lib'
219 );
220
221 /* Files */
222
223 INSERT INTO files ( /* 1 */
224 name, dir
225 ) VALUES (
226 'libcrypto.so.1.0.0', 5
227 );
228
229 INSERT INTO files ( /* 2 */
230 name, dir
231 ) VALUES (
232 'libcrypto.so.1.0.0', 11
233 );
234
235 INSERT INTO files ( /* 3 */
236 name, dir
237 ) VALUES (
238 'libssl.so.1.0.0', 5
239 );
240
241 INSERT INTO files ( /* 4 */
242 name, dir
243 ) VALUES (
244 'libssl.so.1.0.0', 11
245 );
246
247 INSERT INTO files ( /* 5 */
248 name, dir
249 ) VALUES (
250 'openssl', 8
251 );
252
253 INSERT INTO files ( /* 6 */
254 name, dir
255 ) VALUES (
256 'tnc_config', 2
257 );
258
259 /* Algorithms */
260
261 INSERT INTO algorithms (
262 id, name
263 ) VALUES (
264 65536, 'SHA1-IMA'
265 );
266
267 INSERT INTO algorithms (
268 id, name
269 ) VALUES (
270 32768, 'SHA1'
271 );
272
273 INSERT INTO algorithms (
274 id, name
275 ) VALUES (
276 16384, 'SHA256'
277 );
278
279 INSERT INTO algorithms (
280 id, name
281 ) VALUES (
282 8192, 'SHA384'
283 );
284
285 /* File Hashes */
286
287 INSERT INTO file_hashes (
288 product, file, algo, hash
289 ) VALUES (
290 4, 2, 32768, X'6c6f8e12f6cbfba612e780374c4cdcd40f20968a'
291 );
292
293 INSERT INTO file_hashes (
294 product, file, algo, hash
295 ) VALUES (
296 4, 2, 16384, X'dbcecd19d59310183cf5c31ddee29e8d7bec64d3f9583aad074330a1b3024b07'
297 );
298
299 INSERT INTO file_hashes (
300 product, file, algo, hash
301 ) VALUES (
302 4, 2, 8192, X'197c5385e5853003188833d4f991136c1b0875fa416a60b1159f64e57e457b3184762c884a802a2bda194c058e3bd953'
303 );
304
305 INSERT INTO file_hashes (
306 product, file, algo, hash
307 ) VALUES (
308 4, 4, 32768, X'3ad204f99eb7262efab79cfca02628870ea76361'
309 );
310
311 INSERT INTO file_hashes (
312 product, file, algo, hash
313 ) VALUES (
314 4, 4, 16384, X'3a2170aad92fdd58b55e0e199822bc873cf587b2d1eb1ed7ed8dcea97ae86376'
315 );
316
317 INSERT INTO file_hashes (
318 product, file, algo, hash
319 ) VALUES (
320 4, 4, 8192, X'f778076baa876b5e4b502494a3db081fb09dd870dee6991d54104a74b7e009c58fe261db5ffd13c11e08ef0cefcfa59f'
321 );
322
323 INSERT INTO file_hashes (
324 product, file, algo, hash
325 ) VALUES (
326 4, 5, 32768, X'ecd9c7076cc0572724c7a67db7f19c2831e0445f'
327 );
328
329 INSERT INTO file_hashes (
330 product, file, algo, hash
331 ) VALUES (
332 4, 5, 16384, X'28f3ea5afd34444c8232ea75003131e294a0c9b847de300e4b205d38c1a41305'
333 );
334
335 INSERT INTO file_hashes (
336 product, file, algo, hash
337 ) VALUES (
338 4, 5, 8192, X'51921a8b9322f2d3f06d55002ff40a79da67e70cb563b2a50977642d603dfac2ccbb68b3d32a8bb350769b75d6254208'
339 );
340
341 INSERT INTO file_hashes (
342 product, file, algo, hash
343 ) VALUES (
344 18, 1, 32768, X'd9309b9e45928239d7a7b18711e690792632cce4'
345 );
346
347 INSERT INTO file_hashes (
348 product, file, algo, hash
349 ) VALUES (
350 18, 1, 16384, X'dbfa1856d278d8707c4989b30dd065b4bcd309908f0f2e6e66ff2aa83ff93f59'
351 );
352
353 INSERT INTO file_hashes (
354 product, file, algo, hash
355 ) VALUES (
356 18, 1, 8192, X'fb8d027f03bb5ebb47741ed247eb9e174127b714d20229885feb37e0979aeb14a1b74020cded891d680441093625729c'
357 );
358
359 INSERT INTO file_hashes (
360 product, file, algo, hash
361 ) VALUES (
362 18, 3, 32768, X'3715f2f94016a91fab5bbc503f0f1d43c5a9fc2b'
363 );
364
365 INSERT INTO file_hashes (
366 product, file, algo, hash
367 ) VALUES (
368 18, 3, 16384, X'c03a5296b5decb87b01517f9927a8b2349dfb29ff9f5ba084f994c155ca5d4be'
369 );
370
371 INSERT INTO file_hashes (
372 product, file, algo, hash
373 ) VALUES (
374 18, 3, 8192, X'b8bc345f56115235cc6091f61e312ce43ea54a5b99e7295002ae7b415fd35e06ec4c731ab70ad00d784bb53a318a2fa0'
375 );
376
377 INSERT INTO file_hashes (
378 product, file, algo, hash
379 ) VALUES (
380 18, 5, 32768, X'e59602f4edf24c1b36199588886d06665d4adcd7'
381 );
382
383 INSERT INTO file_hashes (
384 product, file, algo, hash
385 ) VALUES (
386 18, 5, 16384, X'090e1b77bda7fe665e498c6b5e09dbb7ddc5cfe57f213de48f4fb6736484f500'
387 );
388
389 INSERT INTO file_hashes (
390 product, file, algo, hash
391 ) VALUES (
392 18, 5, 8192, X'7cbdb4612a13443dba910ecdef5161f2213e52c9b4a2eef14bcee5d287e9df931cd022e9e9715518ad9c9b6e3384a668'
393 );
394
395 /* Packages */
396
397 INSERT INTO packages ( /* 1 */
398 name
399 ) VALUES (
400 'libssl-dev'
401 );
402
403 INSERT INTO packages ( /* 2 */
404 name
405 ) VALUES (
406 'libssl1.0.0'
407 );
408
409 INSERT INTO packages ( /* 3 */
410 name
411 ) VALUES (
412 'libssl1.0.0-dbg'
413 );
414
415 INSERT INTO packages ( /* 4 */
416 name
417 ) VALUES (
418 'openssl'
419 );
420
421 /* Versions */
422
423 INSERT INTO versions (
424 package, product, release, time
425 ) VALUES (
426 1, 4, '1.0.1e-2', 1366531494
427 );
428
429 INSERT INTO versions (
430 package, product, release, time
431 ) VALUES (
432 2, 4, '1.0.1e-2', 1366531494
433 );
434
435 INSERT INTO versions (
436 package, product, release, time
437 ) VALUES (
438 3, 4, '1.0.1e-2', 1366531494
439 );
440
441 INSERT INTO versions (
442 package, product, release, time
443 ) VALUES (
444 4, 4, '1.0.1e-2', 1366531494
445 );
446
447 /* Components */
448
449 INSERT INTO components (
450 vendor_id, name, qualifier
451 ) VALUES (
452 36906, 1, 33 /* ITA TGRUB */
453 );
454
455 INSERT INTO components (
456 vendor_id, name, qualifier
457 ) VALUES (
458 36906, 2, 33 /* ITA TBOOT */
459 );
460
461 INSERT INTO components (
462 vendor_id, name, qualifier
463 ) VALUES (
464 36906, 3, 33 /* ITA IMA - Trusted Platform */
465 );
466
467 INSERT INTO components (
468 vendor_id, name, qualifier
469 ) VALUES (
470 36906, 3, 34 /* ITA IMA - Operating System */
471 );
472
473 /* Groups */
474
475 INSERT INTO groups ( /* 1 */
476 name
477 ) VALUES (
478 'Default'
479 );
480
481 INSERT INTO groups ( /* 2 */
482 name, parent
483 ) VALUES (
484 'Linux', 1
485 );
486
487 INSERT INTO groups ( /* 3 */
488 name, parent
489 ) VALUES (
490 'Android', 1
491 );
492
493 INSERT INTO groups ( /* 4 */
494 name, parent
495 ) VALUES (
496 'Debian i686', 2
497 );
498
499 INSERT INTO groups ( /* 5 */
500 name, parent
501 ) VALUES (
502 'Debian x86_64', 2
503 );
504
505 INSERT INTO groups ( /* 6 */
506 name, parent
507 ) VALUES (
508 'Ubuntu i686', 2
509 );
510
511 INSERT INTO groups ( /* 7 */
512 name, parent
513 ) VALUES (
514 'Ubuntu x86_64', 2
515 );
516
517 INSERT INTO groups ( /* 8 */
518 name
519 ) VALUES (
520 'Reference'
521 );
522
523 INSERT INTO groups ( /* 9 */
524 name, parent
525 ) VALUES (
526 'Ref. Android', 8
527 );
528
529 INSERT INTO groups ( /* 10 */
530 name, parent
531 ) VALUES (
532 'Ref. Linux', 8
533 );
534
535 /* Default Product Groups */
536
537 INSERT INTO groups_product_defaults (
538 group_id, product_id
539 ) VALUES (
540 4, 1
541 );
542
543 INSERT INTO groups_product_defaults (
544 group_id, product_id
545 ) VALUES (
546 4, 3
547 );
548
549 INSERT INTO groups_product_defaults (
550 group_id, product_id
551 ) VALUES (
552 4, 5
553 );
554
555 INSERT INTO groups_product_defaults (
556 group_id, product_id
557 ) VALUES (
558 5, 2
559 );
560
561 INSERT INTO groups_product_defaults (
562 group_id, product_id
563 ) VALUES (
564 5, 4
565 );
566
567 INSERT INTO groups_product_defaults (
568 group_id, product_id
569 ) VALUES (
570 5, 6
571 );
572
573 INSERT INTO groups_product_defaults (
574 group_id, product_id
575 ) VALUES (
576 6, 7
577 );
578
579 INSERT INTO groups_product_defaults (
580 group_id, product_id
581 ) VALUES (
582 6, 9
583 );
584
585 INSERT INTO groups_product_defaults (
586 group_id, product_id
587 ) VALUES (
588 6, 11
589 );
590
591 INSERT INTO groups_product_defaults (
592 group_id, product_id
593 ) VALUES (
594 6, 13
595 );
596
597 INSERT INTO groups_product_defaults (
598 group_id, product_id
599 ) VALUES (
600 6, 15
601 );
602
603 INSERT INTO groups_product_defaults (
604 group_id, product_id
605 ) VALUES (
606 6, 17
607 );
608
609 INSERT INTO groups_product_defaults (
610 group_id, product_id
611 ) VALUES (
612 6, 19
613 );
614
615 INSERT INTO groups_product_defaults (
616 group_id, product_id
617 ) VALUES (
618 7, 8
619 );
620
621 INSERT INTO groups_product_defaults (
622 group_id, product_id
623 ) VALUES (
624 7, 10
625 );
626
627 INSERT INTO groups_product_defaults (
628 group_id, product_id
629 ) VALUES (
630 7, 12
631 );
632
633 INSERT INTO groups_product_defaults (
634 group_id, product_id
635 ) VALUES (
636 7, 14
637 );
638
639 INSERT INTO groups_product_defaults (
640 group_id, product_id
641 ) VALUES (
642 7, 16
643 );
644
645 INSERT INTO groups_product_defaults (
646 group_id, product_id
647 ) VALUES (
648 7, 18
649 );
650
651 INSERT INTO groups_product_defaults (
652 group_id, product_id
653 ) VALUES (
654 7, 20
655 );
656
657 INSERT INTO groups_product_defaults (
658 group_id, product_id
659 ) VALUES (
660 3, 21
661 );
662
663 INSERT INTO groups_product_defaults (
664 group_id, product_id
665 ) VALUES (
666 3, 22
667 );
668
669 /* Devices */
670
671 INSERT INTO devices ( /* 1 */
672 value, product, created
673 ) VALUES (
674 'aabbccddeeff11223344556677889900', 4, 1372330615
675 );
676
677 /* Groups Members */
678
679 INSERT INTO groups_members (
680 group_id, device_id
681 ) VALUES (
682 10, 1
683 );
684
685 /* Identities */
686
687 INSERT INTO identities (
688 type, value
689 ) VALUES ( /* dave@strongswan.org */
690 4, X'64617665407374726f6e677377616e2e6f7267'
691 );
692
693 /* Sessions */
694
695 INSERT INTO sessions (
696 time, connection, identity, device, product, rec
697 ) VALUES (
698 NOW, 1, 1, 1, 4, 0
699 );
700
701 /* Results */
702
703 INSERT INTO results (
704 session, policy, rec, result
705 ) VALUES (
706 1, 1, 0, 'processed 355 packages: 0 not updated, 0 blacklisted, 4 ok, 351 not found'
707 );
708
709 /* Policies */
710
711 INSERT INTO policies ( /* 1 */
712 type, name, rec_fail, rec_noresult
713 ) VALUES (
714 1, 'Installed Packages', 2, 2
715 );
716
717 INSERT INTO policies ( /* 2 */
718 type, name, rec_fail, rec_noresult
719 ) VALUES (
720 2, 'Unknown Source', 2, 2
721 );
722
723 INSERT INTO policies ( /* 3 */
724 type, name, rec_fail, rec_noresult
725 ) VALUES (
726 3, 'IP Forwarding Enabled', 1, 1
727 );
728
729 INSERT INTO policies ( /* 4 */
730 type, name, rec_fail, rec_noresult
731 ) VALUES (
732 4, 'Default Factory Password Enabled', 1, 1
733 );
734
735 INSERT INTO policies ( /* 5 */
736 type, name, file, rec_fail, rec_noresult
737 ) VALUES (
738 6, 'Measure /lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 1, 2, 2
739 );
740
741 INSERT INTO policies ( /* 6 */
742 type, name, file, rec_fail, rec_noresult
743 ) VALUES (
744 6, 'Measure /lib/x86_64-linux-gnu/libssl.so.1.0.0', 3, 2, 2
745 );
746
747 INSERT INTO policies ( /* 7 */
748 type, name, file, rec_fail, rec_noresult
749 ) VALUES (
750 6, 'Measure /usr/bin/openssl', 5, 2, 2
751 );
752
753 INSERT INTO policies ( /* 8 */
754 type, name, rec_fail, rec_noresult
755 ) VALUES (
756 11, 'No Open TCP Ports', 1, 1
757 );
758
759 INSERT INTO policies ( /* 9 */
760 type, name, argument, rec_fail, rec_noresult
761 ) VALUES (
762 13, 'Open UDP Ports', '500 4500 10000-65000', 1, 1
763 );
764
765 INSERT INTO policies ( /* 10 */
766 type, name, file, rec_fail, rec_noresult
767 ) VALUES (
768 7, 'Metadata of /etc/tnc_config', 6, 0, 0
769 );
770
771 INSERT INTO policies ( /* 11 */
772 type, name, dir, rec_fail, rec_noresult
773 ) VALUES (
774 8, 'Get /bin', 1, 0, 0
775 );
776
777 INSERT INTO policies ( /* 12 */
778 type, name, file, rec_fail, rec_noresult
779 ) VALUES (
780 6, 'Measure /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 2, 2, 2
781 );
782
783 INSERT INTO policies ( /* 13 */
784 type, name, file, rec_fail, rec_noresult
785 ) VALUES (
786 6, 'Measure /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0', 4, 2, 2
787 );
788
789 INSERT INTO policies ( /* 14 */
790 type, name, dir, rec_fail, rec_noresult
791 ) VALUES (
792 8, 'Get /system/bin', 13, 0, 0
793 );
794
795 INSERT INTO policies ( /* 15 */
796 type, name, dir, rec_fail, rec_noresult
797 ) VALUES (
798 8, 'Get /system/lib', 14, 0, 0
799 );
800
801 INSERT INTO policies ( /* 16 */
802 type, name, dir, rec_fail, rec_noresult
803 ) VALUES (
804 9, 'Measure /bin', 1, 2, 2
805 );
806
807 INSERT INTO policies ( /* 17 */
808 type, name, argument, rec_fail, rec_noresult
809 ) VALUES (
810 15, 'SWID Tag IDs', 'R', 2, 2
811 );
812
813 INSERT INTO policies ( /* 18 */
814 type, name, argument, rec_fail, rec_noresult
815 ) VALUES (
816 15, 'SWID Tags', '', 2, 2
817 );
818
819 /* Enforcements */
820
821 INSERT INTO enforcements (
822 policy, group_id, max_age
823 ) VALUES (
824 2, 3, 0
825 );
826
827 INSERT INTO enforcements (
828 policy, group_id, max_age, rec_fail, rec_noresult
829 ) VALUES (
830 3, 2, 0, 2, 2
831 );
832
833 INSERT INTO enforcements (
834 policy, group_id, max_age, rec_fail, rec_noresult
835 ) VALUES (
836 3, 10, 0, 2, 2
837 );
838
839 INSERT INTO enforcements (
840 policy, group_id, max_age
841 ) VALUES (
842 5, 7, 86400
843 );
844
845 INSERT INTO enforcements (
846 policy, group_id, max_age
847 ) VALUES (
848 6, 7, 86400
849 );
850
851 INSERT INTO enforcements (
852 policy, group_id, max_age
853 ) VALUES (
854 7, 2, 86400
855 );
856
857 INSERT INTO enforcements (
858 policy, group_id, max_age
859 ) VALUES (
860 8, 1, 60
861 );
862
863 INSERT INTO enforcements (
864 policy, group_id, max_age
865 ) VALUES (
866 9, 1, 60
867 );
868
869 INSERT INTO enforcements (
870 policy, group_id, max_age
871 ) VALUES (
872 10, 2, 60
873 );
874
875 INSERT INTO enforcements (
876 policy, group_id, max_age
877 ) VALUES (
878 11, 10, 86400
879 );
880
881 INSERT INTO enforcements (
882 policy, group_id, max_age
883 ) VALUES (
884 12, 5, 86400
885 );
886
887 INSERT INTO enforcements (
888 policy, group_id, max_age
889 ) VALUES (
890 13, 5, 86400
891 );
892
893 INSERT INTO enforcements (
894 policy, group_id, max_age
895 ) VALUES (
896 14, 9, 0
897 );
898
899 INSERT INTO enforcements (
900 policy, group_id, max_age
901 ) VALUES (
902 15, 9, 0
903 );
904
905 INSERT INTO enforcements (
906 policy, group_id, max_age
907 ) VALUES (
908 17, 2, 86400
909 );
910
911 INSERT INTO enforcements (
912 policy, group_id, max_age
913 ) VALUES (
914 18, 10, 86400
915 );
916
917 /* regids */
918
919 INSERT INTO regids ( /* 1 */
920 name
921 ) VALUES (
922 'regid.1986-12.com.adobe'
923 );
924
925 INSERT INTO regids ( /* 2 */
926 name
927 ) VALUES (
928 'regid.1991-06.com.microsoft'
929 );
930
931 INSERT INTO regids ( /* 3 */
932 name
933 ) VALUES (
934 'regid.2004-05.com.ubuntu'
935 );
936
937 INSERT INTO regids ( /* 4 */
938 name
939 ) VALUES (
940 'regid.1995-04.org.apache'
941 );
942
943 INSERT INTO regids ( /* 5 */
944 name
945 ) VALUES (
946 'regid.1999-03.org.debian'
947 );
948
949 INSERT INTO regids ( /* 6 */
950 name
951 ) VALUES (
952 'regid.1994-04.org.isc'
953 );
954
955 INSERT INTO regids ( /* 7 */
956 name
957 ) VALUES (
958 'regid.2002-08.org.sqlite'
959 );
960
961 INSERT INTO regids ( /* 8 */
962 name
963 ) VALUES (
964 'regid.2004-03.org.strongswan'
965 );