50ac6292e8ecccf62641d1a17c246b015807ff71
[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 /* Directories */
292
293 INSERT INTO directories ( /* 1 */
294 path
295 ) VALUES (
296 '/bin'
297 );
298
299 INSERT INTO directories ( /* 2 */
300 path
301 ) VALUES (
302 '/etc'
303 );
304
305 INSERT INTO directories ( /* 3 */
306 path
307 ) VALUES (
308 '/lib'
309 );
310
311 INSERT INTO directories ( /* 4 */
312 path
313 ) VALUES (
314 '/lib/i386-linux-gnu'
315 );
316
317 INSERT INTO directories ( /* 5 */
318 path
319 ) VALUES (
320 '/lib/x86_64-linux-gnu'
321 );
322
323 INSERT INTO directories ( /* 6 */
324 path
325 ) VALUES (
326 '/lib/xtables'
327 );
328
329 INSERT INTO directories ( /* 7 */
330 path
331 ) VALUES (
332 '/sbin'
333 );
334
335 INSERT INTO directories ( /* 8 */
336 path
337 ) VALUES (
338 '/usr/bin'
339 );
340
341 INSERT INTO directories ( /* 9 */
342 path
343 ) VALUES (
344 '/usr/lib'
345 );
346
347 INSERT INTO directories ( /* 10 */
348 path
349 ) VALUES (
350 '/usr/lib/i386-linux-gnu'
351 );
352
353 INSERT INTO directories ( /* 11 */
354 path
355 ) VALUES (
356 '/usr/lib/x86_64-linux-gnu'
357 );
358
359 INSERT INTO directories ( /* 12 */
360 path
361 ) VALUES (
362 '/usr/sbin'
363 );
364
365 INSERT INTO directories ( /* 13 */
366 path
367 ) VALUES (
368 '/system/bin'
369 );
370
371 INSERT INTO directories ( /* 14 */
372 path
373 ) VALUES (
374 '/system/lib'
375 );
376
377 /* Files */
378
379 INSERT INTO files ( /* 1 */
380 name, dir
381 ) VALUES (
382 'libcrypto.so.1.0.0', 5
383 );
384
385 INSERT INTO files ( /* 2 */
386 name, dir
387 ) VALUES (
388 'libcrypto.so.1.0.0', 11
389 );
390
391 INSERT INTO files ( /* 3 */
392 name, dir
393 ) VALUES (
394 'libssl.so.1.0.0', 5
395 );
396
397 INSERT INTO files ( /* 4 */
398 name, dir
399 ) VALUES (
400 'libssl.so.1.0.0', 11
401 );
402
403 INSERT INTO files ( /* 5 */
404 name, dir
405 ) VALUES (
406 'openssl', 8
407 );
408
409 INSERT INTO files ( /* 6 */
410 name, dir
411 ) VALUES (
412 'tnc_config', 2
413 );
414
415 /* Algorithms */
416
417 INSERT INTO algorithms (
418 id, name
419 ) VALUES (
420 32768, 'SHA1'
421 );
422
423 INSERT INTO algorithms (
424 id, name
425 ) VALUES (
426 16384, 'SHA256'
427 );
428
429 INSERT INTO algorithms (
430 id, name
431 ) VALUES (
432 8192, 'SHA384'
433 );
434
435 /* File Hashes */
436
437 INSERT INTO file_hashes (
438 product, file, algo, hash
439 ) VALUES (
440 28, 2, 32768, X'6c6f8e12f6cbfba612e780374c4cdcd40f20968a'
441 );
442
443 INSERT INTO file_hashes (
444 product, file, algo, hash
445 ) VALUES (
446 28, 2, 16384, X'dbcecd19d59310183cf5c31ddee29e8d7bec64d3f9583aad074330a1b3024b07'
447 );
448
449 INSERT INTO file_hashes (
450 product, file, algo, hash
451 ) VALUES (
452 28, 2, 8192, X'197c5385e5853003188833d4f991136c1b0875fa416a60b1159f64e57e457b3184762c884a802a2bda194c058e3bd953'
453 );
454
455 INSERT INTO file_hashes (
456 product, file, algo, hash
457 ) VALUES (
458 28, 4, 32768, X'3ad204f99eb7262efab79cfca02628870ea76361'
459 );
460
461 INSERT INTO file_hashes (
462 product, file, algo, hash
463 ) VALUES (
464 28, 4, 16384, X'3a2170aad92fdd58b55e0e199822bc873cf587b2d1eb1ed7ed8dcea97ae86376'
465 );
466
467 INSERT INTO file_hashes (
468 product, file, algo, hash
469 ) VALUES (
470 28, 4, 8192, X'f778076baa876b5e4b502494a3db081fb09dd870dee6991d54104a74b7e009c58fe261db5ffd13c11e08ef0cefcfa59f'
471 );
472
473 INSERT INTO file_hashes (
474 product, file, algo, hash
475 ) VALUES (
476 28, 5, 32768, X'ecd9c7076cc0572724c7a67db7f19c2831e0445f'
477 );
478
479 INSERT INTO file_hashes (
480 product, file, algo, hash
481 ) VALUES (
482 28, 5, 16384, X'28f3ea5afd34444c8232ea75003131e294a0c9b847de300e4b205d38c1a41305'
483 );
484
485 INSERT INTO file_hashes (
486 product, file, algo, hash
487 ) VALUES (
488 28, 5, 8192, X'51921a8b9322f2d3f06d55002ff40a79da67e70cb563b2a50977642d603dfac2ccbb68b3d32a8bb350769b75d6254208'
489 );
490
491 INSERT INTO file_hashes (
492 product, file, algo, hash
493 ) VALUES (
494 18, 1, 32768, X'd9309b9e45928239d7a7b18711e690792632cce4'
495 );
496
497 INSERT INTO file_hashes (
498 product, file, algo, hash
499 ) VALUES (
500 18, 1, 16384, X'dbfa1856d278d8707c4989b30dd065b4bcd309908f0f2e6e66ff2aa83ff93f59'
501 );
502
503 INSERT INTO file_hashes (
504 product, file, algo, hash
505 ) VALUES (
506 18, 1, 8192, X'fb8d027f03bb5ebb47741ed247eb9e174127b714d20229885feb37e0979aeb14a1b74020cded891d680441093625729c'
507 );
508
509 INSERT INTO file_hashes (
510 product, file, algo, hash
511 ) VALUES (
512 18, 3, 32768, X'3715f2f94016a91fab5bbc503f0f1d43c5a9fc2b'
513 );
514
515 INSERT INTO file_hashes (
516 product, file, algo, hash
517 ) VALUES (
518 18, 3, 16384, X'c03a5296b5decb87b01517f9927a8b2349dfb29ff9f5ba084f994c155ca5d4be'
519 );
520
521 INSERT INTO file_hashes (
522 product, file, algo, hash
523 ) VALUES (
524 18, 3, 8192, X'b8bc345f56115235cc6091f61e312ce43ea54a5b99e7295002ae7b415fd35e06ec4c731ab70ad00d784bb53a318a2fa0'
525 );
526
527 INSERT INTO file_hashes (
528 product, file, algo, hash
529 ) VALUES (
530 18, 5, 32768, X'e59602f4edf24c1b36199588886d06665d4adcd7'
531 );
532
533 INSERT INTO file_hashes (
534 product, file, algo, hash
535 ) VALUES (
536 18, 5, 16384, X'090e1b77bda7fe665e498c6b5e09dbb7ddc5cfe57f213de48f4fb6736484f500'
537 );
538
539 INSERT INTO file_hashes (
540 product, file, algo, hash
541 ) VALUES (
542 18, 5, 8192, X'7cbdb4612a13443dba910ecdef5161f2213e52c9b4a2eef14bcee5d287e9df931cd022e9e9715518ad9c9b6e3384a668'
543 );
544
545 /* Packages */
546
547 INSERT INTO packages ( /* 1 */
548 name
549 ) VALUES (
550 'libssl-dev'
551 );
552
553 INSERT INTO packages ( /* 2 */
554 name
555 ) VALUES (
556 'libssl1.0.0'
557 );
558
559 INSERT INTO packages ( /* 3 */
560 name
561 ) VALUES (
562 'libssl1.0.0-dbg'
563 );
564
565 INSERT INTO packages ( /* 4 */
566 name
567 ) VALUES (
568 'openssl'
569 );
570
571 /* Versions */
572
573 INSERT INTO versions (
574 package, product, release, time
575 ) VALUES (
576 1, 28, '1.0.1e-2', 1366531494
577 );
578
579 INSERT INTO versions (
580 package, product, release, time
581 ) VALUES (
582 2, 28, '1.0.1e-2', 1366531494
583 );
584
585 INSERT INTO versions (
586 package, product, release, time
587 ) VALUES (
588 3, 28, '1.0.1e-2', 1366531494
589 );
590
591 INSERT INTO versions (
592 package, product, release, time
593 ) VALUES (
594 4, 28, '1.0.1e-2', 1366531494
595 );
596
597 /* Components */
598
599 INSERT INTO components (
600 vendor_id, name, qualifier, label
601 ) VALUES (
602 36906, 1, 33, 'G' /* ITA TGRUB */
603 );
604
605 INSERT INTO components (
606 vendor_id, name, qualifier, label
607 ) VALUES (
608 36906, 2, 33, 'T' /* ITA TBOOT */
609 );
610
611 INSERT INTO components (
612 vendor_id, name, qualifier, label
613 ) VALUES (
614 36906, 3, 33, 'B' /* ITA IMA - Trusted Platform */
615 );
616
617 INSERT INTO components (
618 vendor_id, name, qualifier, label
619 ) VALUES (
620 36906, 3, 34, 'I' /* ITA IMA - Operating System */
621 );
622
623 /* Groups */
624
625 INSERT INTO groups ( /* 1 */
626 name
627 ) VALUES (
628 'Default'
629 );
630
631 INSERT INTO groups ( /* 2 */
632 name, parent
633 ) VALUES (
634 'Linux', 1
635 );
636
637 INSERT INTO groups ( /* 3 */
638 name, parent
639 ) VALUES (
640 'Android', 1
641 );
642
643 INSERT INTO groups ( /* 4 */
644 name, parent
645 ) VALUES (
646 'Debian i686', 2
647 );
648
649 INSERT INTO groups ( /* 5 */
650 name, parent
651 ) VALUES (
652 'Debian x86_64', 2
653 );
654
655 INSERT INTO groups ( /* 6 */
656 name, parent
657 ) VALUES (
658 'Ubuntu i686', 2
659 );
660
661 INSERT INTO groups ( /* 7 */
662 name, parent
663 ) VALUES (
664 'Ubuntu x86_64', 2
665 );
666
667 INSERT INTO groups ( /* 8 */
668 name
669 ) VALUES (
670 'Reference'
671 );
672
673 INSERT INTO groups ( /* 9 */
674 name, parent
675 ) VALUES (
676 'Ref. Android', 8
677 );
678
679 INSERT INTO groups ( /* 10 */
680 name, parent
681 ) VALUES (
682 'Ref. Linux', 8
683 );
684
685 INSERT INTO groups ( /* 11 */
686 name
687 ) VALUES (
688 'TPM BIOS'
689 );
690
691 INSERT INTO groups ( /* 12 */
692 name
693 ) VALUES (
694 'TPM IMA'
695 );
696
697 INSERT INTO groups ( /* 13 */
698 name
699 ) VALUES (
700 'TPM BIOS/IMA'
701 );
702
703 INSERT INTO groups ( /* 14 */
704 name, parent
705 ) VALUES (
706 'Debian armv6l', 2
707 );
708
709 /* Default Product Groups */
710
711 INSERT INTO groups_product_defaults (
712 group_id, product_id
713 ) VALUES (
714 4, 1
715 );
716
717 INSERT INTO groups_product_defaults (
718 group_id, product_id
719 ) VALUES (
720 4, 3
721 );
722
723 INSERT INTO groups_product_defaults (
724 group_id, product_id
725 ) VALUES (
726 4, 5
727 );
728
729 INSERT INTO groups_product_defaults (
730 group_id, product_id
731 ) VALUES (
732 4, 25
733 );
734
735 INSERT INTO groups_product_defaults (
736 group_id, product_id
737 ) VALUES (
738 4, 27
739 );
740
741 INSERT INTO groups_product_defaults (
742 group_id, product_id
743 ) VALUES (
744 4, 37
745 );
746
747 INSERT INTO groups_product_defaults (
748 group_id, product_id
749 ) VALUES (
750 4, 39
751 );
752
753 INSERT INTO groups_product_defaults (
754 group_id, product_id
755 ) VALUES (
756 4, 41
757 );
758
759 INSERT INTO groups_product_defaults (
760 group_id, product_id
761 ) VALUES (
762 5, 2
763 );
764
765 INSERT INTO groups_product_defaults (
766 group_id, product_id
767 ) VALUES (
768 5, 4
769 );
770
771 INSERT INTO groups_product_defaults (
772 group_id, product_id
773 ) VALUES (
774 5, 6
775 );
776
777 INSERT INTO groups_product_defaults (
778 group_id, product_id
779 ) VALUES (
780 5, 26
781 );
782
783 INSERT INTO groups_product_defaults (
784 group_id, product_id
785 ) VALUES (
786 5, 28
787 );
788
789 INSERT INTO groups_product_defaults (
790 group_id, product_id
791 ) VALUES (
792 5, 38
793 );
794
795 INSERT INTO groups_product_defaults (
796 group_id, product_id
797 ) VALUES (
798 5, 40
799 );
800
801 INSERT INTO groups_product_defaults (
802 group_id, product_id
803 ) VALUES (
804 5, 42
805 );
806
807 INSERT INTO groups_product_defaults (
808 group_id, product_id
809 ) VALUES (
810 6, 9
811 );
812
813 INSERT INTO groups_product_defaults (
814 group_id, product_id
815 ) VALUES (
816 6, 11
817 );
818
819 INSERT INTO groups_product_defaults (
820 group_id, product_id
821 ) VALUES (
822 6, 13
823 );
824
825 INSERT INTO groups_product_defaults (
826 group_id, product_id
827 ) VALUES (
828 6, 15
829 );
830
831 INSERT INTO groups_product_defaults (
832 group_id, product_id
833 ) VALUES (
834 6, 17
835 );
836
837 INSERT INTO groups_product_defaults (
838 group_id, product_id
839 ) VALUES (
840 6, 19
841 );
842
843 INSERT INTO groups_product_defaults (
844 group_id, product_id
845 ) VALUES (
846 6, 23
847 );
848
849 INSERT INTO groups_product_defaults (
850 group_id, product_id
851 ) VALUES (
852 6, 35
853 );
854
855 INSERT INTO groups_product_defaults (
856 group_id, product_id
857 ) VALUES (
858 7, 8
859 );
860
861 INSERT INTO groups_product_defaults (
862 group_id, product_id
863 ) VALUES (
864 7, 10
865 );
866
867 INSERT INTO groups_product_defaults (
868 group_id, product_id
869 ) VALUES (
870 7, 12
871 );
872
873 INSERT INTO groups_product_defaults (
874 group_id, product_id
875 ) VALUES (
876 7, 14
877 );
878
879 INSERT INTO groups_product_defaults (
880 group_id, product_id
881 ) VALUES (
882 7, 16
883 );
884
885 INSERT INTO groups_product_defaults (
886 group_id, product_id
887 ) VALUES (
888 7, 18
889 );
890
891 INSERT INTO groups_product_defaults (
892 group_id, product_id
893 ) VALUES (
894 7, 20
895 );
896
897 INSERT INTO groups_product_defaults (
898 group_id, product_id
899 ) VALUES (
900 7, 24
901 );
902
903 INSERT INTO groups_product_defaults (
904 group_id, product_id
905 ) VALUES (
906 7, 36
907 );
908
909 INSERT INTO groups_product_defaults (
910 group_id, product_id
911 ) VALUES (
912 3, 21
913 );
914
915 INSERT INTO groups_product_defaults (
916 group_id, product_id
917 ) VALUES (
918 3, 22
919 );
920
921 INSERT INTO groups_product_defaults (
922 group_id, product_id
923 ) VALUES (
924 3, 29
925 );
926
927 INSERT INTO groups_product_defaults (
928 group_id, product_id
929 ) VALUES (
930 3, 30
931 );
932
933 INSERT INTO groups_product_defaults (
934 group_id, product_id
935 ) VALUES (
936 3, 31
937 );
938
939 INSERT INTO groups_product_defaults (
940 group_id, product_id
941 ) VALUES (
942 3, 32
943 );
944
945 INSERT INTO groups_product_defaults (
946 group_id, product_id
947 ) VALUES (
948 3, 33
949 );
950
951 INSERT INTO groups_product_defaults (
952 group_id, product_id
953 ) VALUES (
954 3, 34
955 );
956
957 INSERT INTO groups_product_defaults (
958 group_id, product_id
959 ) VALUES (
960 14, 43
961 );
962
963 INSERT INTO groups_product_defaults (
964 group_id, product_id
965 ) VALUES (
966 14, 44
967 );
968
969 INSERT INTO groups_product_defaults (
970 group_id, product_id
971 ) VALUES (
972 14, 45
973 );
974
975 INSERT INTO groups_product_defaults (
976 group_id, product_id
977 ) VALUES (
978 14, 46
979 );
980
981 INSERT INTO groups_product_defaults (
982 group_id, product_id
983 ) VALUES (
984 14, 47
985 );
986
987 INSERT INTO groups_product_defaults (
988 group_id, product_id
989 ) VALUES (
990 14, 48
991 );
992
993 /* Policies */
994
995 INSERT INTO policies ( /* 1 */
996 type, name, rec_fail, rec_noresult
997 ) VALUES (
998 1, 'Installed Packages', 2, 2
999 );
1000
1001 INSERT INTO policies ( /* 2 */
1002 type, name, rec_fail, rec_noresult
1003 ) VALUES (
1004 2, 'Unknown Source', 2, 2
1005 );
1006
1007 INSERT INTO policies ( /* 3 */
1008 type, name, rec_fail, rec_noresult
1009 ) VALUES (
1010 3, 'IP Forwarding Enabled', 1, 1
1011 );
1012
1013 INSERT INTO policies ( /* 4 */
1014 type, name, rec_fail, rec_noresult
1015 ) VALUES (
1016 4, 'Default Factory Password Enabled', 1, 1
1017 );
1018
1019 INSERT INTO policies ( /* 5 */
1020 type, name, file, rec_fail, rec_noresult
1021 ) VALUES (
1022 6, 'Measure /lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 1, 2, 2
1023 );
1024
1025 INSERT INTO policies ( /* 6 */
1026 type, name, file, rec_fail, rec_noresult
1027 ) VALUES (
1028 6, 'Measure /lib/x86_64-linux-gnu/libssl.so.1.0.0', 3, 2, 2
1029 );
1030
1031 INSERT INTO policies ( /* 7 */
1032 type, name, file, rec_fail, rec_noresult
1033 ) VALUES (
1034 6, 'Measure /usr/bin/openssl', 5, 2, 2
1035 );
1036
1037 INSERT INTO policies ( /* 8 */
1038 type, name, rec_fail, rec_noresult
1039 ) VALUES (
1040 11, 'No Open TCP Ports', 1, 1
1041 );
1042
1043 INSERT INTO policies ( /* 9 */
1044 type, name, argument, rec_fail, rec_noresult
1045 ) VALUES (
1046 13, 'Open UDP Ports', '500 4500 10000-65000', 1, 1
1047 );
1048
1049 INSERT INTO policies ( /* 10 */
1050 type, name, file, rec_fail, rec_noresult
1051 ) VALUES (
1052 7, 'Metadata of /etc/tnc_config', 6, 0, 0
1053 );
1054
1055 INSERT INTO policies ( /* 11 */
1056 type, name, dir, rec_fail, rec_noresult
1057 ) VALUES (
1058 8, 'Get /bin', 1, 0, 0
1059 );
1060
1061 INSERT INTO policies ( /* 12 */
1062 type, name, file, rec_fail, rec_noresult
1063 ) VALUES (
1064 6, 'Measure /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 2, 2, 2
1065 );
1066
1067 INSERT INTO policies ( /* 13 */
1068 type, name, file, rec_fail, rec_noresult
1069 ) VALUES (
1070 6, 'Measure /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0', 4, 2, 2
1071 );
1072
1073 INSERT INTO policies ( /* 14 */
1074 type, name, dir, rec_fail, rec_noresult
1075 ) VALUES (
1076 8, 'Get /system/bin', 13, 0, 0
1077 );
1078
1079 INSERT INTO policies ( /* 15 */
1080 type, name, dir, rec_fail, rec_noresult
1081 ) VALUES (
1082 8, 'Get /system/lib', 14, 0, 0
1083 );
1084
1085 INSERT INTO policies ( /* 16 */
1086 type, name, dir, rec_fail, rec_noresult
1087 ) VALUES (
1088 9, 'Measure /bin', 1, 2, 2
1089 );
1090
1091 INSERT INTO policies ( /* 17 */
1092 type, name, argument, rec_fail, rec_noresult
1093 ) VALUES (
1094 15, 'SWID Tag IDs', 'R', 2, 2
1095 );
1096
1097 INSERT INTO policies ( /* 18 */
1098 type, name, argument, rec_fail, rec_noresult
1099 ) VALUES (
1100 15, 'SWID Tags', '', 2, 2
1101 );
1102
1103 INSERT INTO policies ( /* 19 */
1104 type, name, argument, rec_fail, rec_noresult
1105 ) VALUES (
1106 16, 'TPM BIOS Measurements', 'B', 2, 2
1107 );
1108
1109 INSERT INTO policies ( /* 20 */
1110 type, name, argument, rec_fail, rec_noresult
1111 ) VALUES (
1112 16, 'TPM IMA Measurements', 'I', 2, 2
1113 );
1114
1115 INSERT INTO policies ( /* 21 */
1116 type, name, argument, rec_fail, rec_noresult
1117 ) VALUES (
1118 16, 'TPM BIOS/IMA Measurements', 'BI', 2, 2
1119 );
1120
1121 /* Enforcements */
1122
1123 INSERT INTO enforcements ( /* 1 */
1124 policy, group_id, max_age
1125 ) VALUES (
1126 1, 1, 86400
1127 );
1128
1129 INSERT INTO enforcements ( /* 2 */
1130 policy, group_id, max_age
1131 ) VALUES (
1132 2, 3, 0
1133 );
1134
1135 INSERT INTO enforcements ( /* 3 */
1136 policy, group_id, max_age
1137 ) VALUES (
1138 3, 2, 0
1139 );
1140
1141 INSERT INTO enforcements ( /* 4 */
1142 policy, group_id, max_age
1143 ) VALUES (
1144 5, 7, 86400
1145 );
1146
1147 INSERT INTO enforcements ( /* 5 */
1148 policy, group_id, max_age
1149 ) VALUES (
1150 6, 7, 86400
1151 );
1152
1153 INSERT INTO enforcements ( /* 6 */
1154 policy, group_id, max_age
1155 ) VALUES (
1156 7, 2, 86400
1157 );
1158
1159 INSERT INTO enforcements ( /* 7 */
1160 policy, group_id, max_age
1161 ) VALUES (
1162 8, 1, 60
1163 );
1164
1165 INSERT INTO enforcements ( /* 8 */
1166 policy, group_id, max_age
1167 ) VALUES (
1168 9, 1, 60
1169 );
1170
1171 INSERT INTO enforcements ( /* 9 */
1172 policy, group_id, max_age
1173 ) VALUES (
1174 10, 2, 60
1175 );
1176
1177 INSERT INTO enforcements ( /* 10 */
1178 policy, group_id, max_age
1179 ) VALUES (
1180 11, 10, 86400
1181 );
1182
1183 INSERT INTO enforcements ( /* 11 */
1184 policy, group_id, max_age
1185 ) VALUES (
1186 12, 5, 86400
1187 );
1188
1189 INSERT INTO enforcements ( /* 12 */
1190 policy, group_id, max_age
1191 ) VALUES (
1192 13, 5, 86400
1193 );
1194
1195 INSERT INTO enforcements ( /* 13 */
1196 policy, group_id, max_age
1197 ) VALUES (
1198 14, 9, 0
1199 );
1200
1201 INSERT INTO enforcements ( /* 14 */
1202 policy, group_id, max_age
1203 ) VALUES (
1204 15, 9, 0
1205 );
1206
1207 INSERT INTO enforcements ( /* 15 */
1208 policy, group_id, max_age
1209 ) VALUES (
1210 19, 11, 60
1211 );
1212
1213 INSERT INTO enforcements ( /* 16 */
1214 policy, group_id, max_age
1215 ) VALUES (
1216 20, 12, 60
1217 );
1218
1219 INSERT INTO enforcements ( /* 17 */
1220 policy, group_id, max_age
1221 ) VALUES (
1222 21, 13, 60
1223 );
1224
1225 /* swid_entities */
1226
1227 INSERT INTO "swid_entities" ( /* 1 */
1228 "name", "regid"
1229 ) VALUES (
1230 'strongSwan Project', 'regid.2004-03.org.strongswan'
1231 );
1232
1233 INSERT INTO swid_entities ( /* 2 */
1234 "name", "regid"
1235 ) VALUES (
1236 'Adobe Systems Inc.', 'regid.1986-12.com.adobe'
1237 );
1238
1239 INSERT INTO swid_entities ( /* 3 */
1240 "name", "regid"
1241 ) VALUES (
1242 'Microsoft Corporation', 'regid.1991-06.com.microsoft'
1243 );
1244
1245 INSERT INTO swid_entities ( /* 4 */
1246 "name", "regid"
1247 ) VALUES (
1248 'Ubuntu Project', 'regid.2004-05.com.ubuntu'
1249 );
1250
1251 INSERT INTO swid_entities ( /* 5 */
1252 "name", "regid"
1253 ) VALUES (
1254 'Apache Software Foundation', 'regid.1995-04.org.apache'
1255 );
1256
1257 INSERT INTO swid_entities ( /* 6 */
1258 "name", "regid"
1259 ) VALUES (
1260 'Debian Project', 'regid.1999-03.org.debian'
1261 );
1262
1263 INSERT INTO swid_entities ( /* 7 */
1264 "name", "regid"
1265 ) VALUES (
1266 'Internet Systems Consortium', 'regid.1994-04.org.isc'
1267 );
1268
1269 INSERT INTO swid_entities ( /* 8 */
1270 "name", "regid"
1271 ) VALUES (
1272 'OpenSSL Project', 'regid.1998-12.org.openssl'
1273 );
1274
1275 INSERT INTO swid_entities ( /* 9 */
1276 "name", "regid"
1277 ) VALUES (
1278 'Samba Project', 'regid.1998-01.org.samba'
1279 );
1280
1281 INSERT INTO swid_entities ( /* 10 */
1282 "name", "regid"
1283 ) VALUES (
1284 'SQLite Project', 'regid.2002-08.org.sqlite'
1285 );