charon-systemd: Don't use atexit() to deinitialize the daemon
[strongswan.git] / src / libimcv / imv / 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 INSERT INTO products ( /* 23 */
136 name
137 ) VALUES (
138 'Ubuntu 13.10 i686'
139 );
140
141 INSERT INTO products ( /* 24 */
142 name
143 ) VALUES (
144 'Ubuntu 13.10 x86_64'
145 );
146
147 INSERT INTO products ( /* 25 */
148 name
149 ) VALUES (
150 'Debian 7.1 i686'
151 );
152
153 INSERT INTO products ( /* 26 */
154 name
155 ) VALUES (
156 'Debian 7.1 x86_64'
157 );
158
159 INSERT INTO products ( /* 27 */
160 name
161 ) VALUES (
162 'Debian 7.2 i686'
163 );
164
165 INSERT INTO products ( /* 28 */
166 name
167 ) VALUES (
168 'Debian 7.2 x86_64'
169 );
170
171 INSERT INTO products ( /* 29 */
172 name
173 ) VALUES (
174 'Android 4.1.2'
175 );
176
177 INSERT INTO products ( /* 30 */
178 name
179 ) VALUES (
180 'Android 4.2.2'
181 );
182
183 INSERT INTO products ( /* 31 */
184 name
185 ) VALUES (
186 'Android 4.3.1'
187 );
188
189 INSERT INTO products ( /* 32 */
190 name
191 ) VALUES (
192 'Android 4.4'
193 );
194
195 INSERT INTO products ( /* 33 */
196 name
197 ) VALUES (
198 'Android 4.4.1'
199 );
200
201 INSERT INTO products ( /* 34 */
202 name
203 ) VALUES (
204 'Android 4.4.2'
205 );
206
207 INSERT INTO products ( /* 35 */
208 name
209 ) VALUES (
210 'Ubuntu 14.04 i686'
211 );
212
213 INSERT INTO products ( /* 36 */
214 name
215 ) VALUES (
216 'Ubuntu 14.04 x86_64'
217 );
218
219 INSERT INTO products ( /* 37 */
220 name
221 ) VALUES (
222 'Debian 7.3 i686'
223 );
224
225 INSERT INTO products ( /* 38 */
226 name
227 ) VALUES (
228 'Debian 7.3 x86_64'
229 );
230
231 INSERT INTO products ( /* 39 */
232 name
233 ) VALUES (
234 'Debian 7.4 i686'
235 );
236
237 INSERT INTO products ( /* 40 */
238 name
239 ) VALUES (
240 'Debian 7.4 x86_64'
241 );
242
243 INSERT INTO products ( /* 41 */
244 name
245 ) VALUES (
246 'Debian 7.5 i686'
247 );
248
249 INSERT INTO products ( /* 42 */
250 name
251 ) VALUES (
252 'Debian 7.5 x86_64'
253 );
254
255 INSERT INTO products ( /* 43 */
256 name
257 ) VALUES (
258 'Debian 7.0 armv6l'
259 );
260
261 INSERT INTO products ( /* 44 */
262 name
263 ) VALUES (
264 'Debian 7.1 armv6l'
265 );
266
267 INSERT INTO products ( /* 45 */
268 name
269 ) VALUES (
270 'Debian 7.2 armv6l'
271 );
272
273 INSERT INTO products ( /* 46 */
274 name
275 ) VALUES (
276 'Debian 7.3 armv6l'
277 );
278
279 INSERT INTO products ( /* 47 */
280 name
281 ) VALUES (
282 'Debian 7.4 armv6l'
283 );
284
285 INSERT INTO products ( /* 48 */
286 name
287 ) VALUES (
288 'Debian 7.5 armv6l'
289 );
290
291 INSERT INTO products ( /* 49 */
292 name
293 ) VALUES (
294 'Android 4.3'
295 );
296
297 INSERT INTO products ( /* 50 */
298 name
299 ) VALUES (
300 'Android 4.4.3'
301 );
302
303 INSERT INTO products ( /* 51 */
304 name
305 ) VALUES (
306 'Android 4.4.4'
307 );
308
309 INSERT INTO products ( /* 52 */
310 name
311 ) VALUES (
312 'Debian 7.6 i686'
313 );
314
315 INSERT INTO products ( /* 53 */
316 name
317 ) VALUES (
318 'Debian 7.6 x86_64'
319 );
320 INSERT INTO products ( /* 54 */
321 name
322 ) VALUES (
323 'Debian 7.6 armv6l'
324 );
325
326 INSERT INTO products ( /* 55 */
327 name
328 ) VALUES (
329 'Debian 7.7 i686'
330 );
331
332 INSERT INTO products ( /* 56 */
333 name
334 ) VALUES (
335 'Debian 7.7 x86_64'
336 );
337 INSERT INTO products ( /* 57 */
338 name
339 ) VALUES (
340 'Debian 7.7 armv6l'
341 );
342
343 INSERT INTO products ( /* 58 */
344 name
345 ) VALUES (
346 'Debian 7.8 i686'
347 );
348
349 INSERT INTO products ( /* 59 */
350 name
351 ) VALUES (
352 'Debian 7.8 x86_64'
353 );
354
355 INSERT INTO products ( /* 60 */
356 name
357 ) VALUES (
358 'Debian 7.8 armv6l'
359 );
360
361 INSERT INTO products ( /* 61 */
362 name
363 ) VALUES (
364 'Ubuntu 14.10 i686'
365 );
366
367 INSERT INTO products ( /* 62 */
368 name
369 ) VALUES (
370 'Ubuntu 14.10 x86_64'
371 );
372
373 INSERT INTO products ( /* 63 */
374 name
375 ) VALUES (
376 'Android 5.0'
377 );
378
379 INSERT INTO products ( /* 64 */
380 name
381 ) VALUES (
382 'Android 5.0.1'
383 );
384
385 INSERT INTO products ( /* 65 */
386 name
387 ) VALUES (
388 'Debian 7.8 armv7l'
389 );
390
391 INSERT INTO products ( /* 66 */
392 name
393 ) VALUES (
394 'Debian 7.9 i686'
395 );
396
397 INSERT INTO products ( /* 67 */
398 name
399 ) VALUES (
400 'Debian 7.9 x86_64'
401 );
402
403 INSERT INTO products ( /* 68 */
404 name
405 ) VALUES (
406 'Debian 7.9 armv6l'
407 );
408
409 INSERT INTO products ( /* 69 */
410 name
411 ) VALUES (
412 'Debian 7.9 armv7l'
413 );
414
415 INSERT INTO products ( /* 70 */
416 name
417 ) VALUES (
418 'Ubuntu 15.04 i686'
419 );
420
421 INSERT INTO products ( /* 71 */
422 name
423 ) VALUES (
424 'Ubuntu 15.04 x86_64'
425 );
426
427 INSERT INTO products ( /* 72 */
428 name
429 ) VALUES (
430 'Ubuntu 15.10 i686'
431 );
432
433 INSERT INTO products ( /* 73 */
434 name
435 ) VALUES (
436 'Ubuntu 15.10 x86_64'
437 );
438
439 INSERT INTO products ( /* 74 */
440 name
441 ) VALUES (
442 'Ubuntu 16.04 i686'
443 );
444
445 INSERT INTO products ( /* 75 */
446 name
447 ) VALUES (
448 'Ubuntu 16.04 x86_64'
449 );
450
451 INSERT INTO products ( /* 76 */
452 name
453 ) VALUES (
454 'Debian 7.10 i686'
455 );
456
457 INSERT INTO products ( /* 77 */
458 name
459 ) VALUES (
460 'Debian 7.10 x86_64'
461 );
462
463 INSERT INTO products ( /* 78 */
464 name
465 ) VALUES (
466 'Debian 7.10 armv6l'
467 );
468
469 INSERT INTO products ( /* 79 */
470 name
471 ) VALUES (
472 'Debian 7.10 armv7l'
473 );
474
475 INSERT INTO products ( /* 80 */
476 name
477 ) VALUES (
478 'Android 6.0'
479 );
480
481 INSERT INTO products ( /* 81 */
482 name
483 ) VALUES (
484 'Android 6.0.1'
485 );
486
487 INSERT INTO products ( /* 82 */
488 name
489 ) VALUES (
490 'Debian 8.5 i686'
491 );
492
493 INSERT INTO products ( /* 83 */
494 name
495 ) VALUES (
496 'Debian 8.5 x86_64'
497 );
498
499 INSERT INTO products ( /* 84 */
500 name
501 ) VALUES (
502 'Debian 8.6 i686'
503 );
504
505 INSERT INTO products ( /* 85 */
506 name
507 ) VALUES (
508 'Debian 8.6 x86_64'
509 );
510
511 INSERT INTO products ( /* 86 */
512 name
513 ) VALUES (
514 'Debian 8.7 i686'
515 );
516
517 INSERT INTO products ( /* 87 */
518 name
519 ) VALUES (
520 'Debian 8.7 x86_64'
521 );
522
523 INSERT INTO products ( /* 88 */
524 name
525 ) VALUES (
526 'Debian 8.8 i686'
527 );
528
529 INSERT INTO products ( /* 89 */
530 name
531 ) VALUES (
532 'Debian 8.8 x86_64'
533 );
534
535 INSERT INTO products ( /* 90 */
536 name
537 ) VALUES (
538 'Debian 8.9 i686'
539 );
540
541 INSERT INTO products ( /* 91 */
542 name
543 ) VALUES (
544 'Debian 8.9 x86_64'
545 );
546
547 INSERT INTO products ( /* 92 */
548 name
549 ) VALUES (
550 'Debian 8.10 i686'
551 );
552
553 INSERT INTO products ( /* 93 */
554 name
555 ) VALUES (
556 'Debian 8.10 x86_64'
557 );
558
559 INSERT INTO products ( /* 94 */
560 name
561 ) VALUES (
562 'Debian 8.11 i686'
563 );
564
565 INSERT INTO products ( /* 95 */
566 name
567 ) VALUES (
568 'Debian 8.11 x86_64'
569 );
570
571 INSERT INTO products ( /* 96 */
572 name
573 ) VALUES (
574 'Ubuntu 18.04 x86_64'
575 );
576
577 /* Directories */
578
579 INSERT INTO directories ( /* 1 */
580 path
581 ) VALUES (
582 '/bin'
583 );
584
585 INSERT INTO directories ( /* 2 */
586 path
587 ) VALUES (
588 '/etc'
589 );
590
591 INSERT INTO directories ( /* 3 */
592 path
593 ) VALUES (
594 '/lib'
595 );
596
597 INSERT INTO directories ( /* 4 */
598 path
599 ) VALUES (
600 '/lib/i386-linux-gnu'
601 );
602
603 INSERT INTO directories ( /* 5 */
604 path
605 ) VALUES (
606 '/lib/x86_64-linux-gnu'
607 );
608
609 INSERT INTO directories ( /* 6 */
610 path
611 ) VALUES (
612 '/lib/xtables'
613 );
614
615 INSERT INTO directories ( /* 7 */
616 path
617 ) VALUES (
618 '/sbin'
619 );
620
621 INSERT INTO directories ( /* 8 */
622 path
623 ) VALUES (
624 '/usr/bin'
625 );
626
627 INSERT INTO directories ( /* 9 */
628 path
629 ) VALUES (
630 '/usr/lib'
631 );
632
633 INSERT INTO directories ( /* 10 */
634 path
635 ) VALUES (
636 '/usr/lib/i386-linux-gnu'
637 );
638
639 INSERT INTO directories ( /* 11 */
640 path
641 ) VALUES (
642 '/usr/lib/x86_64-linux-gnu'
643 );
644
645 INSERT INTO directories ( /* 12 */
646 path
647 ) VALUES (
648 '/usr/sbin'
649 );
650
651 INSERT INTO directories ( /* 13 */
652 path
653 ) VALUES (
654 '/system/bin'
655 );
656
657 INSERT INTO directories ( /* 14 */
658 path
659 ) VALUES (
660 '/system/lib'
661 );
662
663 /* Files */
664
665 INSERT INTO files ( /* 1 */
666 name, dir
667 ) VALUES (
668 'libcrypto.so.1.0.0', 5
669 );
670
671 INSERT INTO files ( /* 2 */
672 name, dir
673 ) VALUES (
674 'libcrypto.so.1.0.0', 11
675 );
676
677 INSERT INTO files ( /* 3 */
678 name, dir
679 ) VALUES (
680 'libssl.so.1.0.0', 5
681 );
682
683 INSERT INTO files ( /* 4 */
684 name, dir
685 ) VALUES (
686 'libssl.so.1.0.0', 11
687 );
688
689 INSERT INTO files ( /* 5 */
690 name, dir
691 ) VALUES (
692 'openssl', 8
693 );
694
695 INSERT INTO files ( /* 6 */
696 name, dir
697 ) VALUES (
698 'tnc_config', 2
699 );
700
701 /* Algorithms */
702
703 INSERT INTO algorithms (
704 id, name
705 ) VALUES (
706 32768, 'SHA1'
707 );
708
709 INSERT INTO algorithms (
710 id, name
711 ) VALUES (
712 16384, 'SHA256'
713 );
714
715 INSERT INTO algorithms (
716 id, name
717 ) VALUES (
718 8192, 'SHA384'
719 );
720
721 INSERT INTO algorithms (
722 id, name
723 ) VALUES (
724 4096, 'SHA512'
725 );
726
727 /* File Hashes */
728
729 INSERT INTO file_hashes (
730 version, file, algo, hash
731 ) VALUES (
732 2, 2, 32768, '6c6f8e12f6cbfba612e780374c4cdcd40f20968a'
733 );
734
735 INSERT INTO file_hashes (
736 version, file, algo, hash
737 ) VALUES (
738 2, 2, 16384, 'dbcecd19d59310183cf5c31ddee29e8d7bec64d3f9583aad074330a1b3024b07'
739 );
740
741 INSERT INTO file_hashes (
742 version, file, algo, hash
743 ) VALUES (
744 2, 2, 8192, '197c5385e5853003188833d4f991136c1b0875fa416a60b1159f64e57e457b3184762c884a802a2bda194c058e3bd953'
745 );
746
747 INSERT INTO file_hashes (
748 version, file, algo, hash
749 ) VALUES (
750 2, 4, 32768, '3ad204f99eb7262efab79cfca02628870ea76361'
751 );
752
753 INSERT INTO file_hashes (
754 version, file, algo, hash
755 ) VALUES (
756 2, 4, 16384, '3a2170aad92fdd58b55e0e199822bc873cf587b2d1eb1ed7ed8dcea97ae86376'
757 );
758
759 INSERT INTO file_hashes (
760 version, file, algo, hash
761 ) VALUES (
762 2, 4, 8192, 'f778076baa876b5e4b502494a3db081fb09dd870dee6991d54104a74b7e009c58fe261db5ffd13c11e08ef0cefcfa59f'
763 );
764
765 INSERT INTO file_hashes (
766 version, file, algo, hash
767 ) VALUES (
768 4, 5, 32768, 'ecd9c7076cc0572724c7a67db7f19c2831e0445f'
769 );
770
771 INSERT INTO file_hashes (
772 version, file, algo, hash
773 ) VALUES (
774 4, 5, 16384, '28f3ea5afd34444c8232ea75003131e294a0c9b847de300e4b205d38c1a41305'
775 );
776
777 INSERT INTO file_hashes (
778 version, file, algo, hash
779 ) VALUES (
780 4, 5, 8192, '51921a8b9322f2d3f06d55002ff40a79da67e70cb563b2a50977642d603dfac2ccbb68b3d32a8bb350769b75d6254208'
781 );
782
783 INSERT INTO file_hashes (
784 version, file, algo, hash
785 ) VALUES (
786 5, 1, 32768, 'd9309b9e45928239d7a7b18711e690792632cce4'
787 );
788
789 INSERT INTO file_hashes (
790 version, file, algo, hash
791 ) VALUES (
792 5, 1, 16384, 'dbfa1856d278d8707c4989b30dd065b4bcd309908f0f2e6e66ff2aa83ff93f59'
793 );
794
795 INSERT INTO file_hashes (
796 version, file, algo, hash
797 ) VALUES (
798 5, 1, 8192, 'fb8d027f03bb5ebb47741ed247eb9e174127b714d20229885feb37e0979aeb14a1b74020cded891d680441093625729c'
799 );
800
801 INSERT INTO file_hashes (
802 version, file, algo, hash
803 ) VALUES (
804 5, 3, 32768, '3715f2f94016a91fab5bbc503f0f1d43c5a9fc2b'
805 );
806
807 INSERT INTO file_hashes (
808 version, file, algo, hash
809 ) VALUES (
810 5, 3, 16384, 'c03a5296b5decb87b01517f9927a8b2349dfb29ff9f5ba084f994c155ca5d4be'
811 );
812
813 INSERT INTO file_hashes (
814 version, file, algo, hash
815 ) VALUES (
816 5, 3, 8192, 'b8bc345f56115235cc6091f61e312ce43ea54a5b99e7295002ae7b415fd35e06ec4c731ab70ad00d784bb53a318a2fa0'
817 );
818
819 INSERT INTO file_hashes (
820 version, file, algo, hash
821 ) VALUES (
822 6, 5, 32768, 'e59602f4edf24c1b36199588886d06665d4adcd7'
823 );
824
825 INSERT INTO file_hashes (
826 version, file, algo, hash
827 ) VALUES (
828 6, 5, 16384, '090e1b77bda7fe665e498c6b5e09dbb7ddc5cfe57f213de48f4fb6736484f500'
829 );
830
831 INSERT INTO file_hashes (
832 version, file, algo, hash
833 ) VALUES (
834 6, 5, 8192, '7cbdb4612a13443dba910ecdef5161f2213e52c9b4a2eef14bcee5d287e9df931cd022e9e9715518ad9c9b6e3384a668'
835 );
836
837 /* Packages */
838
839 INSERT INTO packages ( /* 1 */
840 name
841 ) VALUES (
842 'libssl-dev'
843 );
844
845 INSERT INTO packages ( /* 2 */
846 name
847 ) VALUES (
848 'libssl1.0.0'
849 );
850
851 INSERT INTO packages ( /* 3 */
852 name
853 ) VALUES (
854 'libssl1.0.0-dbg'
855 );
856
857 INSERT INTO packages ( /* 4 */
858 name
859 ) VALUES (
860 'openssl'
861 );
862
863 /* Versions */
864
865 INSERT INTO versions ( /* 1 */
866 package, product, release, time
867 ) VALUES (
868 1, 28, '1.0.1e-2', 1366531494
869 );
870
871 INSERT INTO versions ( /* 2 */
872 package, product, release, time
873 ) VALUES (
874 2, 28, '1.0.1e-2', 1366531494
875 );
876
877 INSERT INTO versions ( /* 3 */
878 package, product, release, time
879 ) VALUES (
880 3, 28, '1.0.1e-2', 1366531494
881 );
882
883 INSERT INTO versions ( /* 4 */
884 package, product, release, time
885 ) VALUES (
886 4, 28, '1.0.1e-2', 1366531494
887 );
888
889 INSERT INTO versions ( /* 5 */
890 package, product, time
891 ) VALUES (
892 2, 18, 1350544774
893 );
894
895 INSERT INTO versions ( /* 6 */
896 package, product, time
897 ) VALUES (
898 4, 18, 1350544774
899 );
900
901 /* Components */
902
903 INSERT INTO components (
904 vendor_id, name, qualifier, label
905 ) VALUES (
906 36906, 1, 33, 'G' /* ITA TGRUB */
907 );
908
909 INSERT INTO components (
910 vendor_id, name, qualifier, label
911 ) VALUES (
912 36906, 2, 33, 'T' /* ITA TBOOT */
913 );
914
915 INSERT INTO components (
916 vendor_id, name, qualifier, label
917 ) VALUES (
918 36906, 3, 33, 'B' /* ITA IMA - Trusted Platform */
919 );
920
921 INSERT INTO components (
922 vendor_id, name, qualifier, label
923 ) VALUES (
924 36906, 3, 34, 'I' /* ITA IMA - Operating System */
925 );
926
927 /* Groups */
928
929 INSERT INTO groups ( /* 1 */
930 name
931 ) VALUES (
932 'Default'
933 );
934
935 INSERT INTO groups ( /* 2 */
936 name, parent
937 ) VALUES (
938 'Linux', 1
939 );
940
941 INSERT INTO groups ( /* 3 */
942 name, parent
943 ) VALUES (
944 'Android', 1
945 );
946
947 INSERT INTO groups ( /* 4 */
948 name, parent
949 ) VALUES (
950 'Debian i686', 2
951 );
952
953 INSERT INTO groups ( /* 5 */
954 name, parent
955 ) VALUES (
956 'Debian x86_64', 2
957 );
958
959 INSERT INTO groups ( /* 6 */
960 name, parent
961 ) VALUES (
962 'Ubuntu i686', 2
963 );
964
965 INSERT INTO groups ( /* 7 */
966 name, parent
967 ) VALUES (
968 'Ubuntu x86_64', 2
969 );
970
971 INSERT INTO groups ( /* 8 */
972 name
973 ) VALUES (
974 'Reference'
975 );
976
977 INSERT INTO groups ( /* 9 */
978 name, parent
979 ) VALUES (
980 'Ref. Android', 8
981 );
982
983 INSERT INTO groups ( /* 10 */
984 name, parent
985 ) VALUES (
986 'Ref. Linux', 8
987 );
988
989 INSERT INTO groups ( /* 11 */
990 name
991 ) VALUES (
992 'TPM BIOS'
993 );
994
995 INSERT INTO groups ( /* 12 */
996 name
997 ) VALUES (
998 'TPM IMA'
999 );
1000
1001 INSERT INTO groups ( /* 13 */
1002 name
1003 ) VALUES (
1004 'TPM BIOS/IMA'
1005 );
1006
1007 INSERT INTO groups ( /* 14 */
1008 name, parent
1009 ) VALUES (
1010 'Debian armv6l', 2
1011 );
1012
1013 INSERT INTO groups ( /* 15 */
1014 name, parent
1015 ) VALUES (
1016 'Debian armv7l', 2
1017 );
1018
1019 INSERT INTO groups ( /* 16 */
1020 name
1021 ) VALUES (
1022 'TPM TBOOT'
1023 );
1024
1025 /* Default Product Groups */
1026
1027 INSERT INTO groups_product_defaults (
1028 group_id, product_id
1029 ) VALUES (
1030 4, 1
1031 );
1032
1033 INSERT INTO groups_product_defaults (
1034 group_id, product_id
1035 ) VALUES (
1036 4, 3
1037 );
1038
1039 INSERT INTO groups_product_defaults (
1040 group_id, product_id
1041 ) VALUES (
1042 4, 5
1043 );
1044
1045 INSERT INTO groups_product_defaults (
1046 group_id, product_id
1047 ) VALUES (
1048 4, 25
1049 );
1050
1051 INSERT INTO groups_product_defaults (
1052 group_id, product_id
1053 ) VALUES (
1054 4, 27
1055 );
1056
1057 INSERT INTO groups_product_defaults (
1058 group_id, product_id
1059 ) VALUES (
1060 4, 37
1061 );
1062
1063 INSERT INTO groups_product_defaults (
1064 group_id, product_id
1065 ) VALUES (
1066 4, 39
1067 );
1068
1069 INSERT INTO groups_product_defaults (
1070 group_id, product_id
1071 ) VALUES (
1072 4, 41
1073 );
1074
1075 INSERT INTO groups_product_defaults (
1076 group_id, product_id
1077 ) VALUES (
1078 4, 52
1079 );
1080
1081 INSERT INTO groups_product_defaults (
1082 group_id, product_id
1083 ) VALUES (
1084 4, 55
1085 );
1086
1087 INSERT INTO groups_product_defaults (
1088 group_id, product_id
1089 ) VALUES (
1090 4, 58
1091 );
1092
1093 INSERT INTO groups_product_defaults (
1094 group_id, product_id
1095 ) VALUES (
1096 4, 66
1097 );
1098
1099 INSERT INTO groups_product_defaults (
1100 group_id, product_id
1101 ) VALUES (
1102 4, 76
1103 );
1104
1105 INSERT INTO groups_product_defaults (
1106 group_id, product_id
1107 ) VALUES (
1108 4, 82
1109 );
1110
1111 INSERT INTO groups_product_defaults (
1112 group_id, product_id
1113 ) VALUES (
1114 4, 84
1115 );
1116
1117 INSERT INTO groups_product_defaults (
1118 group_id, product_id
1119 ) VALUES (
1120 4, 86
1121 );
1122
1123 INSERT INTO groups_product_defaults (
1124 group_id, product_id
1125 ) VALUES (
1126 4, 88
1127 );
1128
1129 INSERT INTO groups_product_defaults (
1130 group_id, product_id
1131 ) VALUES (
1132 4, 90
1133 );
1134
1135 INSERT INTO groups_product_defaults (
1136 group_id, product_id
1137 ) VALUES (
1138 4, 92
1139 );
1140
1141 INSERT INTO groups_product_defaults (
1142 group_id, product_id
1143 ) VALUES (
1144 4, 94
1145 );
1146
1147 INSERT INTO groups_product_defaults (
1148 group_id, product_id
1149 ) VALUES (
1150 5, 2
1151 );
1152
1153 INSERT INTO groups_product_defaults (
1154 group_id, product_id
1155 ) VALUES (
1156 5, 4
1157 );
1158
1159 INSERT INTO groups_product_defaults (
1160 group_id, product_id
1161 ) VALUES (
1162 5, 6
1163 );
1164
1165 INSERT INTO groups_product_defaults (
1166 group_id, product_id
1167 ) VALUES (
1168 5, 26
1169 );
1170
1171 INSERT INTO groups_product_defaults (
1172 group_id, product_id
1173 ) VALUES (
1174 5, 28
1175 );
1176
1177 INSERT INTO groups_product_defaults (
1178 group_id, product_id
1179 ) VALUES (
1180 5, 38
1181 );
1182
1183 INSERT INTO groups_product_defaults (
1184 group_id, product_id
1185 ) VALUES (
1186 5, 40
1187 );
1188
1189 INSERT INTO groups_product_defaults (
1190 group_id, product_id
1191 ) VALUES (
1192 5, 42
1193 );
1194
1195 INSERT INTO groups_product_defaults (
1196 group_id, product_id
1197 ) VALUES (
1198 5, 53
1199 );
1200
1201 INSERT INTO groups_product_defaults (
1202 group_id, product_id
1203 ) VALUES (
1204 5, 56
1205 );
1206
1207 INSERT INTO groups_product_defaults (
1208 group_id, product_id
1209 ) VALUES (
1210 5, 59
1211 );
1212
1213 INSERT INTO groups_product_defaults (
1214 group_id, product_id
1215 ) VALUES (
1216 5, 67
1217 );
1218
1219 INSERT INTO groups_product_defaults (
1220 group_id, product_id
1221 ) VALUES (
1222 5, 77
1223 );
1224
1225 INSERT INTO groups_product_defaults (
1226 group_id, product_id
1227 ) VALUES (
1228 5, 83
1229 );
1230
1231 INSERT INTO groups_product_defaults (
1232 group_id, product_id
1233 ) VALUES (
1234 5, 85
1235 );
1236
1237 INSERT INTO groups_product_defaults (
1238 group_id, product_id
1239 ) VALUES (
1240 5, 87
1241 );
1242
1243 INSERT INTO groups_product_defaults (
1244 group_id, product_id
1245 ) VALUES (
1246 5, 89
1247 );
1248
1249 INSERT INTO groups_product_defaults (
1250 group_id, product_id
1251 ) VALUES (
1252 5, 91
1253 );
1254
1255 INSERT INTO groups_product_defaults (
1256 group_id, product_id
1257 ) VALUES (
1258 5, 93
1259 );
1260
1261 INSERT INTO groups_product_defaults (
1262 group_id, product_id
1263 ) VALUES (
1264 5, 95
1265 );
1266
1267 INSERT INTO groups_product_defaults (
1268 group_id, product_id
1269 ) VALUES (
1270 6, 9
1271 );
1272
1273 INSERT INTO groups_product_defaults (
1274 group_id, product_id
1275 ) VALUES (
1276 6, 11
1277 );
1278
1279 INSERT INTO groups_product_defaults (
1280 group_id, product_id
1281 ) VALUES (
1282 6, 13
1283 );
1284
1285 INSERT INTO groups_product_defaults (
1286 group_id, product_id
1287 ) VALUES (
1288 6, 15
1289 );
1290
1291 INSERT INTO groups_product_defaults (
1292 group_id, product_id
1293 ) VALUES (
1294 6, 17
1295 );
1296
1297 INSERT INTO groups_product_defaults (
1298 group_id, product_id
1299 ) VALUES (
1300 6, 19
1301 );
1302
1303 INSERT INTO groups_product_defaults (
1304 group_id, product_id
1305 ) VALUES (
1306 6, 23
1307 );
1308
1309 INSERT INTO groups_product_defaults (
1310 group_id, product_id
1311 ) VALUES (
1312 6, 35
1313 );
1314
1315 INSERT INTO groups_product_defaults (
1316 group_id, product_id
1317 ) VALUES (
1318 6, 61
1319 );
1320
1321 INSERT INTO groups_product_defaults (
1322 group_id, product_id
1323 ) VALUES (
1324 6, 70
1325 );
1326
1327 INSERT INTO groups_product_defaults (
1328 group_id, product_id
1329 ) VALUES (
1330 6, 72
1331 );
1332
1333 INSERT INTO groups_product_defaults (
1334 group_id, product_id
1335 ) VALUES (
1336 6, 74
1337 );
1338
1339 INSERT INTO groups_product_defaults (
1340 group_id, product_id
1341 ) VALUES (
1342 7, 8
1343 );
1344
1345 INSERT INTO groups_product_defaults (
1346 group_id, product_id
1347 ) VALUES (
1348 7, 10
1349 );
1350
1351 INSERT INTO groups_product_defaults (
1352 group_id, product_id
1353 ) VALUES (
1354 7, 12
1355 );
1356
1357 INSERT INTO groups_product_defaults (
1358 group_id, product_id
1359 ) VALUES (
1360 7, 14
1361 );
1362
1363 INSERT INTO groups_product_defaults (
1364 group_id, product_id
1365 ) VALUES (
1366 7, 16
1367 );
1368
1369 INSERT INTO groups_product_defaults (
1370 group_id, product_id
1371 ) VALUES (
1372 7, 18
1373 );
1374
1375 INSERT INTO groups_product_defaults (
1376 group_id, product_id
1377 ) VALUES (
1378 7, 20
1379 );
1380
1381 INSERT INTO groups_product_defaults (
1382 group_id, product_id
1383 ) VALUES (
1384 7, 24
1385 );
1386
1387 INSERT INTO groups_product_defaults (
1388 group_id, product_id
1389 ) VALUES (
1390 7, 36
1391 );
1392
1393 INSERT INTO groups_product_defaults (
1394 group_id, product_id
1395 ) VALUES (
1396 7, 62
1397 );
1398
1399 INSERT INTO groups_product_defaults (
1400 group_id, product_id
1401 ) VALUES (
1402 7, 71
1403 );
1404
1405 INSERT INTO groups_product_defaults (
1406 group_id, product_id
1407 ) VALUES (
1408 7, 73
1409 );
1410
1411 INSERT INTO groups_product_defaults (
1412 group_id, product_id
1413 ) VALUES (
1414 7, 75
1415 );
1416
1417 INSERT INTO groups_product_defaults (
1418 group_id, product_id
1419 ) VALUES (
1420 7, 96
1421 );
1422
1423 INSERT INTO groups_product_defaults (
1424 group_id, product_id
1425 ) VALUES (
1426 3, 21
1427 );
1428
1429 INSERT INTO groups_product_defaults (
1430 group_id, product_id
1431 ) VALUES (
1432 3, 22
1433 );
1434
1435 INSERT INTO groups_product_defaults (
1436 group_id, product_id
1437 ) VALUES (
1438 3, 29
1439 );
1440
1441 INSERT INTO groups_product_defaults (
1442 group_id, product_id
1443 ) VALUES (
1444 3, 30
1445 );
1446
1447 INSERT INTO groups_product_defaults (
1448 group_id, product_id
1449 ) VALUES (
1450 3, 31
1451 );
1452
1453 INSERT INTO groups_product_defaults (
1454 group_id, product_id
1455 ) VALUES (
1456 3, 32
1457 );
1458
1459 INSERT INTO groups_product_defaults (
1460 group_id, product_id
1461 ) VALUES (
1462 3, 33
1463 );
1464
1465 INSERT INTO groups_product_defaults (
1466 group_id, product_id
1467 ) VALUES (
1468 3, 34
1469 );
1470
1471 INSERT INTO groups_product_defaults (
1472 group_id, product_id
1473 ) VALUES (
1474 3, 49
1475 );
1476
1477 INSERT INTO groups_product_defaults (
1478 group_id, product_id
1479 ) VALUES (
1480 3, 50
1481 );
1482
1483 INSERT INTO groups_product_defaults (
1484 group_id, product_id
1485 ) VALUES (
1486 3, 51
1487 );
1488
1489 INSERT INTO groups_product_defaults (
1490 group_id, product_id
1491 ) VALUES (
1492 3, 63
1493 );
1494
1495 INSERT INTO groups_product_defaults (
1496 group_id, product_id
1497 ) VALUES (
1498 3, 64
1499 );
1500
1501 INSERT INTO groups_product_defaults (
1502 group_id, product_id
1503 ) VALUES (
1504 3, 80
1505 );
1506
1507 INSERT INTO groups_product_defaults (
1508 group_id, product_id
1509 ) VALUES (
1510 3, 81
1511 );
1512
1513 INSERT INTO groups_product_defaults (
1514 group_id, product_id
1515 ) VALUES (
1516 14, 43
1517 );
1518
1519 INSERT INTO groups_product_defaults (
1520 group_id, product_id
1521 ) VALUES (
1522 14, 44
1523 );
1524
1525 INSERT INTO groups_product_defaults (
1526 group_id, product_id
1527 ) VALUES (
1528 14, 45
1529 );
1530
1531 INSERT INTO groups_product_defaults (
1532 group_id, product_id
1533 ) VALUES (
1534 14, 46
1535 );
1536
1537 INSERT INTO groups_product_defaults (
1538 group_id, product_id
1539 ) VALUES (
1540 14, 47
1541 );
1542
1543 INSERT INTO groups_product_defaults (
1544 group_id, product_id
1545 ) VALUES (
1546 14, 48
1547 );
1548
1549 INSERT INTO groups_product_defaults (
1550 group_id, product_id
1551 ) VALUES (
1552 14, 54
1553 );
1554
1555 INSERT INTO groups_product_defaults (
1556 group_id, product_id
1557 ) VALUES (
1558 14, 57
1559 );
1560
1561 INSERT INTO groups_product_defaults (
1562 group_id, product_id
1563 ) VALUES (
1564 14, 60
1565 );
1566
1567 INSERT INTO groups_product_defaults (
1568 group_id, product_id
1569 ) VALUES (
1570 14, 68
1571 );
1572
1573 INSERT INTO groups_product_defaults (
1574 group_id, product_id
1575 ) VALUES (
1576 14, 78
1577 );
1578
1579 INSERT INTO groups_product_defaults (
1580 group_id, product_id
1581 ) VALUES (
1582 15, 65
1583 );
1584
1585 INSERT INTO groups_product_defaults (
1586 group_id, product_id
1587 ) VALUES (
1588 15, 69
1589 );
1590
1591 INSERT INTO groups_product_defaults (
1592 group_id, product_id
1593 ) VALUES (
1594 15, 79
1595 );
1596
1597 /* Policies */
1598
1599 INSERT INTO policies ( /* 1 */
1600 type, name, rec_fail, rec_noresult
1601 ) VALUES (
1602 1, 'Installed Packages', 2, 2
1603 );
1604
1605 INSERT INTO policies ( /* 2 */
1606 type, name, rec_fail, rec_noresult
1607 ) VALUES (
1608 2, 'Unknown Source', 2, 2
1609 );
1610
1611 INSERT INTO policies ( /* 3 */
1612 type, name, rec_fail, rec_noresult
1613 ) VALUES (
1614 3, 'IP Forwarding Enabled', 1, 1
1615 );
1616
1617 INSERT INTO policies ( /* 4 */
1618 type, name, rec_fail, rec_noresult
1619 ) VALUES (
1620 4, 'Default Factory Password Enabled', 1, 1
1621 );
1622
1623 INSERT INTO policies ( /* 5 */
1624 type, name, file, rec_fail, rec_noresult
1625 ) VALUES (
1626 6, 'Measure /lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 1, 2, 2
1627 );
1628
1629 INSERT INTO policies ( /* 6 */
1630 type, name, file, rec_fail, rec_noresult
1631 ) VALUES (
1632 6, 'Measure /lib/x86_64-linux-gnu/libssl.so.1.0.0', 3, 2, 2
1633 );
1634
1635 INSERT INTO policies ( /* 7 */
1636 type, name, file, rec_fail, rec_noresult
1637 ) VALUES (
1638 6, 'Measure /usr/bin/openssl', 5, 2, 2
1639 );
1640
1641 INSERT INTO policies ( /* 8 */
1642 type, name, rec_fail, rec_noresult
1643 ) VALUES (
1644 11, 'No Open TCP Ports', 1, 1
1645 );
1646
1647 INSERT INTO policies ( /* 9 */
1648 type, name, argument, rec_fail, rec_noresult
1649 ) VALUES (
1650 13, 'Open UDP Ports', '500 4500 10000-65000', 1, 1
1651 );
1652
1653 INSERT INTO policies ( /* 10 */
1654 type, name, file, rec_fail, rec_noresult
1655 ) VALUES (
1656 7, 'Metadata of /etc/tnc_config', 6, 0, 0
1657 );
1658
1659 INSERT INTO policies ( /* 11 */
1660 type, name, dir, rec_fail, rec_noresult
1661 ) VALUES (
1662 8, 'Get /bin', 1, 0, 0
1663 );
1664
1665 INSERT INTO policies ( /* 12 */
1666 type, name, file, rec_fail, rec_noresult
1667 ) VALUES (
1668 6, 'Measure /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 2, 2, 2
1669 );
1670
1671 INSERT INTO policies ( /* 13 */
1672 type, name, file, rec_fail, rec_noresult
1673 ) VALUES (
1674 6, 'Measure /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0', 4, 2, 2
1675 );
1676
1677 INSERT INTO policies ( /* 14 */
1678 type, name, dir, rec_fail, rec_noresult
1679 ) VALUES (
1680 8, 'Get /system/bin', 13, 0, 0
1681 );
1682
1683 INSERT INTO policies ( /* 15 */
1684 type, name, dir, rec_fail, rec_noresult
1685 ) VALUES (
1686 8, 'Get /system/lib', 14, 0, 0
1687 );
1688
1689 INSERT INTO policies ( /* 16 */
1690 type, name, dir, rec_fail, rec_noresult
1691 ) VALUES (
1692 9, 'Measure /bin', 1, 2, 2
1693 );
1694
1695 INSERT INTO policies ( /* 17 */
1696 type, name, argument, rec_fail, rec_noresult
1697 ) VALUES (
1698 15, 'SWID Tag IDs', 'R', 2, 2
1699 );
1700
1701 INSERT INTO policies ( /* 18 */
1702 type, name, argument, rec_fail, rec_noresult
1703 ) VALUES (
1704 15, 'SWID Tags', '', 2, 2
1705 );
1706
1707 INSERT INTO policies ( /* 19 */
1708 type, name, argument, rec_fail, rec_noresult
1709 ) VALUES (
1710 16, 'TPM BIOS Measurements', 'B', 2, 2
1711 );
1712
1713 INSERT INTO policies ( /* 20 */
1714 type, name, argument, rec_fail, rec_noresult
1715 ) VALUES (
1716 16, 'TPM IMA Measurements', 'I', 2, 2
1717 );
1718
1719 INSERT INTO policies ( /* 21 */
1720 type, name, argument, rec_fail, rec_noresult
1721 ) VALUES (
1722 16, 'TPM BIOS/IMA Measurements', 'BI', 2, 2
1723 );
1724
1725 INSERT INTO policies ( /* 22 */
1726 type, name, argument, rec_fail, rec_noresult
1727 ) VALUES (
1728 16, 'TPM TBOOT Measurements', 'T', 2, 2
1729 );
1730
1731 /* Enforcements */
1732
1733 INSERT INTO enforcements ( /* 1 */
1734 policy, group_id, max_age
1735 ) VALUES (
1736 1, 1, 86400
1737 );
1738
1739 INSERT INTO enforcements ( /* 2 */
1740 policy, group_id, max_age
1741 ) VALUES (
1742 2, 3, 0
1743 );
1744
1745 INSERT INTO enforcements ( /* 3 */
1746 policy, group_id, max_age
1747 ) VALUES (
1748 3, 2, 0
1749 );
1750
1751 INSERT INTO enforcements ( /* 4 */
1752 policy, group_id, max_age
1753 ) VALUES (
1754 5, 7, 86400
1755 );
1756
1757 INSERT INTO enforcements ( /* 5 */
1758 policy, group_id, max_age
1759 ) VALUES (
1760 6, 7, 86400
1761 );
1762
1763 INSERT INTO enforcements ( /* 6 */
1764 policy, group_id, max_age
1765 ) VALUES (
1766 7, 2, 86400
1767 );
1768
1769 INSERT INTO enforcements ( /* 7 */
1770 policy, group_id, max_age
1771 ) VALUES (
1772 8, 1, 60
1773 );
1774
1775 INSERT INTO enforcements ( /* 8 */
1776 policy, group_id, max_age
1777 ) VALUES (
1778 9, 1, 60
1779 );
1780
1781 INSERT INTO enforcements ( /* 9 */
1782 policy, group_id, max_age
1783 ) VALUES (
1784 10, 2, 60
1785 );
1786
1787 INSERT INTO enforcements ( /* 10 */
1788 policy, group_id, max_age
1789 ) VALUES (
1790 11, 10, 86400
1791 );
1792
1793 INSERT INTO enforcements ( /* 11 */
1794 policy, group_id, max_age
1795 ) VALUES (
1796 12, 5, 86400
1797 );
1798
1799 INSERT INTO enforcements ( /* 12 */
1800 policy, group_id, max_age
1801 ) VALUES (
1802 13, 5, 86400
1803 );
1804
1805 INSERT INTO enforcements ( /* 13 */
1806 policy, group_id, max_age
1807 ) VALUES (
1808 14, 9, 0
1809 );
1810
1811 INSERT INTO enforcements ( /* 14 */
1812 policy, group_id, max_age
1813 ) VALUES (
1814 15, 9, 0
1815 );
1816
1817 INSERT INTO enforcements ( /* 15 */
1818 policy, group_id, max_age
1819 ) VALUES (
1820 19, 11, 60
1821 );
1822
1823 INSERT INTO enforcements ( /* 16 */
1824 policy, group_id, max_age
1825 ) VALUES (
1826 20, 12, 60
1827 );
1828
1829 INSERT INTO enforcements ( /* 17 */
1830 policy, group_id, max_age
1831 ) VALUES (
1832 21, 13, 60
1833 );
1834
1835 INSERT INTO enforcements ( /* 18 */
1836 policy, group_id, max_age
1837 ) VALUES (
1838 22, 16, 60
1839 );
1840
1841 /* swid_entities */
1842
1843 INSERT INTO "swid_entities" ( /* 1 */
1844 "name", "regid"
1845 ) VALUES (
1846 'strongSwan Project', 'strongswan.org'
1847 );
1848
1849 INSERT INTO swid_entities ( /* 2 */
1850 "name", "regid"
1851 ) VALUES (
1852 'Adobe Systems Inc.', 'adobe.com'
1853 );
1854
1855 INSERT INTO swid_entities ( /* 3 */
1856 "name", "regid"
1857 ) VALUES (
1858 'Microsoft Corporation', 'microsoft.com'
1859 );
1860
1861 INSERT INTO swid_entities ( /* 4 */
1862 "name", "regid"
1863 ) VALUES (
1864 'Ubuntu Project', 'ubuntu.com'
1865 );
1866
1867 INSERT INTO swid_entities ( /* 5 */
1868 "name", "regid"
1869 ) VALUES (
1870 'Apache Software Foundation', 'apache.org'
1871 );
1872
1873 INSERT INTO swid_entities ( /* 6 */
1874 "name", "regid"
1875 ) VALUES (
1876 'Debian Project', 'debian.org'
1877 );
1878
1879 INSERT INTO swid_entities ( /* 7 */
1880 "name", "regid"
1881 ) VALUES (
1882 'Internet Systems Consortium', 'isc.org'
1883 );
1884
1885 INSERT INTO swid_entities ( /* 8 */
1886 "name", "regid"
1887 ) VALUES (
1888 'OpenSSL Project', 'openssl.org'
1889 );
1890
1891 INSERT INTO swid_entities ( /* 9 */
1892 "name", "regid"
1893 ) VALUES (
1894 'Samba Project', 'samba.org'
1895 );
1896
1897 INSERT INTO swid_entities ( /* 10 */
1898 "name", "regid"
1899 ) VALUES (
1900 'SQLite Project', 'sqlite.org'
1901 );