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