testing: Added Debian 7.9 to IMV database
[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 /* Directories */
416
417 INSERT INTO directories ( /* 1 */
418 path
419 ) VALUES (
420 '/bin'
421 );
422
423 INSERT INTO directories ( /* 2 */
424 path
425 ) VALUES (
426 '/etc'
427 );
428
429 INSERT INTO directories ( /* 3 */
430 path
431 ) VALUES (
432 '/lib'
433 );
434
435 INSERT INTO directories ( /* 4 */
436 path
437 ) VALUES (
438 '/lib/i386-linux-gnu'
439 );
440
441 INSERT INTO directories ( /* 5 */
442 path
443 ) VALUES (
444 '/lib/x86_64-linux-gnu'
445 );
446
447 INSERT INTO directories ( /* 6 */
448 path
449 ) VALUES (
450 '/lib/xtables'
451 );
452
453 INSERT INTO directories ( /* 7 */
454 path
455 ) VALUES (
456 '/sbin'
457 );
458
459 INSERT INTO directories ( /* 8 */
460 path
461 ) VALUES (
462 '/usr/bin'
463 );
464
465 INSERT INTO directories ( /* 9 */
466 path
467 ) VALUES (
468 '/usr/lib'
469 );
470
471 INSERT INTO directories ( /* 10 */
472 path
473 ) VALUES (
474 '/usr/lib/i386-linux-gnu'
475 );
476
477 INSERT INTO directories ( /* 11 */
478 path
479 ) VALUES (
480 '/usr/lib/x86_64-linux-gnu'
481 );
482
483 INSERT INTO directories ( /* 12 */
484 path
485 ) VALUES (
486 '/usr/sbin'
487 );
488
489 INSERT INTO directories ( /* 13 */
490 path
491 ) VALUES (
492 '/system/bin'
493 );
494
495 INSERT INTO directories ( /* 14 */
496 path
497 ) VALUES (
498 '/system/lib'
499 );
500
501 /* Files */
502
503 INSERT INTO files ( /* 1 */
504 name, dir
505 ) VALUES (
506 'libcrypto.so.1.0.0', 5
507 );
508
509 INSERT INTO files ( /* 2 */
510 name, dir
511 ) VALUES (
512 'libcrypto.so.1.0.0', 11
513 );
514
515 INSERT INTO files ( /* 3 */
516 name, dir
517 ) VALUES (
518 'libssl.so.1.0.0', 5
519 );
520
521 INSERT INTO files ( /* 4 */
522 name, dir
523 ) VALUES (
524 'libssl.so.1.0.0', 11
525 );
526
527 INSERT INTO files ( /* 5 */
528 name, dir
529 ) VALUES (
530 'openssl', 8
531 );
532
533 INSERT INTO files ( /* 6 */
534 name, dir
535 ) VALUES (
536 'tnc_config', 2
537 );
538
539 /* Algorithms */
540
541 INSERT INTO algorithms (
542 id, name
543 ) VALUES (
544 32768, 'SHA1'
545 );
546
547 INSERT INTO algorithms (
548 id, name
549 ) VALUES (
550 16384, 'SHA256'
551 );
552
553 INSERT INTO algorithms (
554 id, name
555 ) VALUES (
556 8192, 'SHA384'
557 );
558
559 /* File Hashes */
560
561 INSERT INTO file_hashes (
562 product, file, algo, hash
563 ) VALUES (
564 28, 2, 32768, X'6c6f8e12f6cbfba612e780374c4cdcd40f20968a'
565 );
566
567 INSERT INTO file_hashes (
568 product, file, algo, hash
569 ) VALUES (
570 28, 2, 16384, X'dbcecd19d59310183cf5c31ddee29e8d7bec64d3f9583aad074330a1b3024b07'
571 );
572
573 INSERT INTO file_hashes (
574 product, file, algo, hash
575 ) VALUES (
576 28, 2, 8192, X'197c5385e5853003188833d4f991136c1b0875fa416a60b1159f64e57e457b3184762c884a802a2bda194c058e3bd953'
577 );
578
579 INSERT INTO file_hashes (
580 product, file, algo, hash
581 ) VALUES (
582 28, 4, 32768, X'3ad204f99eb7262efab79cfca02628870ea76361'
583 );
584
585 INSERT INTO file_hashes (
586 product, file, algo, hash
587 ) VALUES (
588 28, 4, 16384, X'3a2170aad92fdd58b55e0e199822bc873cf587b2d1eb1ed7ed8dcea97ae86376'
589 );
590
591 INSERT INTO file_hashes (
592 product, file, algo, hash
593 ) VALUES (
594 28, 4, 8192, X'f778076baa876b5e4b502494a3db081fb09dd870dee6991d54104a74b7e009c58fe261db5ffd13c11e08ef0cefcfa59f'
595 );
596
597 INSERT INTO file_hashes (
598 product, file, algo, hash
599 ) VALUES (
600 28, 5, 32768, X'ecd9c7076cc0572724c7a67db7f19c2831e0445f'
601 );
602
603 INSERT INTO file_hashes (
604 product, file, algo, hash
605 ) VALUES (
606 28, 5, 16384, X'28f3ea5afd34444c8232ea75003131e294a0c9b847de300e4b205d38c1a41305'
607 );
608
609 INSERT INTO file_hashes (
610 product, file, algo, hash
611 ) VALUES (
612 28, 5, 8192, X'51921a8b9322f2d3f06d55002ff40a79da67e70cb563b2a50977642d603dfac2ccbb68b3d32a8bb350769b75d6254208'
613 );
614
615 INSERT INTO file_hashes (
616 product, file, algo, hash
617 ) VALUES (
618 18, 1, 32768, X'd9309b9e45928239d7a7b18711e690792632cce4'
619 );
620
621 INSERT INTO file_hashes (
622 product, file, algo, hash
623 ) VALUES (
624 18, 1, 16384, X'dbfa1856d278d8707c4989b30dd065b4bcd309908f0f2e6e66ff2aa83ff93f59'
625 );
626
627 INSERT INTO file_hashes (
628 product, file, algo, hash
629 ) VALUES (
630 18, 1, 8192, X'fb8d027f03bb5ebb47741ed247eb9e174127b714d20229885feb37e0979aeb14a1b74020cded891d680441093625729c'
631 );
632
633 INSERT INTO file_hashes (
634 product, file, algo, hash
635 ) VALUES (
636 18, 3, 32768, X'3715f2f94016a91fab5bbc503f0f1d43c5a9fc2b'
637 );
638
639 INSERT INTO file_hashes (
640 product, file, algo, hash
641 ) VALUES (
642 18, 3, 16384, X'c03a5296b5decb87b01517f9927a8b2349dfb29ff9f5ba084f994c155ca5d4be'
643 );
644
645 INSERT INTO file_hashes (
646 product, file, algo, hash
647 ) VALUES (
648 18, 3, 8192, X'b8bc345f56115235cc6091f61e312ce43ea54a5b99e7295002ae7b415fd35e06ec4c731ab70ad00d784bb53a318a2fa0'
649 );
650
651 INSERT INTO file_hashes (
652 product, file, algo, hash
653 ) VALUES (
654 18, 5, 32768, X'e59602f4edf24c1b36199588886d06665d4adcd7'
655 );
656
657 INSERT INTO file_hashes (
658 product, file, algo, hash
659 ) VALUES (
660 18, 5, 16384, X'090e1b77bda7fe665e498c6b5e09dbb7ddc5cfe57f213de48f4fb6736484f500'
661 );
662
663 INSERT INTO file_hashes (
664 product, file, algo, hash
665 ) VALUES (
666 18, 5, 8192, X'7cbdb4612a13443dba910ecdef5161f2213e52c9b4a2eef14bcee5d287e9df931cd022e9e9715518ad9c9b6e3384a668'
667 );
668
669 /* Packages */
670
671 INSERT INTO packages ( /* 1 */
672 name
673 ) VALUES (
674 'libssl-dev'
675 );
676
677 INSERT INTO packages ( /* 2 */
678 name
679 ) VALUES (
680 'libssl1.0.0'
681 );
682
683 INSERT INTO packages ( /* 3 */
684 name
685 ) VALUES (
686 'libssl1.0.0-dbg'
687 );
688
689 INSERT INTO packages ( /* 4 */
690 name
691 ) VALUES (
692 'openssl'
693 );
694
695 /* Versions */
696
697 INSERT INTO versions (
698 package, product, release, time
699 ) VALUES (
700 1, 28, '1.0.1e-2', 1366531494
701 );
702
703 INSERT INTO versions (
704 package, product, release, time
705 ) VALUES (
706 2, 28, '1.0.1e-2', 1366531494
707 );
708
709 INSERT INTO versions (
710 package, product, release, time
711 ) VALUES (
712 3, 28, '1.0.1e-2', 1366531494
713 );
714
715 INSERT INTO versions (
716 package, product, release, time
717 ) VALUES (
718 4, 28, '1.0.1e-2', 1366531494
719 );
720
721 /* Components */
722
723 INSERT INTO components (
724 vendor_id, name, qualifier, label
725 ) VALUES (
726 36906, 1, 33, 'G' /* ITA TGRUB */
727 );
728
729 INSERT INTO components (
730 vendor_id, name, qualifier, label
731 ) VALUES (
732 36906, 2, 33, 'T' /* ITA TBOOT */
733 );
734
735 INSERT INTO components (
736 vendor_id, name, qualifier, label
737 ) VALUES (
738 36906, 3, 33, 'B' /* ITA IMA - Trusted Platform */
739 );
740
741 INSERT INTO components (
742 vendor_id, name, qualifier, label
743 ) VALUES (
744 36906, 3, 34, 'I' /* ITA IMA - Operating System */
745 );
746
747 /* Groups */
748
749 INSERT INTO groups ( /* 1 */
750 name
751 ) VALUES (
752 'Default'
753 );
754
755 INSERT INTO groups ( /* 2 */
756 name, parent
757 ) VALUES (
758 'Linux', 1
759 );
760
761 INSERT INTO groups ( /* 3 */
762 name, parent
763 ) VALUES (
764 'Android', 1
765 );
766
767 INSERT INTO groups ( /* 4 */
768 name, parent
769 ) VALUES (
770 'Debian i686', 2
771 );
772
773 INSERT INTO groups ( /* 5 */
774 name, parent
775 ) VALUES (
776 'Debian x86_64', 2
777 );
778
779 INSERT INTO groups ( /* 6 */
780 name, parent
781 ) VALUES (
782 'Ubuntu i686', 2
783 );
784
785 INSERT INTO groups ( /* 7 */
786 name, parent
787 ) VALUES (
788 'Ubuntu x86_64', 2
789 );
790
791 INSERT INTO groups ( /* 8 */
792 name
793 ) VALUES (
794 'Reference'
795 );
796
797 INSERT INTO groups ( /* 9 */
798 name, parent
799 ) VALUES (
800 'Ref. Android', 8
801 );
802
803 INSERT INTO groups ( /* 10 */
804 name, parent
805 ) VALUES (
806 'Ref. Linux', 8
807 );
808
809 INSERT INTO groups ( /* 11 */
810 name
811 ) VALUES (
812 'TPM BIOS'
813 );
814
815 INSERT INTO groups ( /* 12 */
816 name
817 ) VALUES (
818 'TPM IMA'
819 );
820
821 INSERT INTO groups ( /* 13 */
822 name
823 ) VALUES (
824 'TPM BIOS/IMA'
825 );
826
827 INSERT INTO groups ( /* 14 */
828 name, parent
829 ) VALUES (
830 'Debian armv6l', 2
831 );
832
833 INSERT INTO groups ( /* 15 */
834 name, parent
835 ) VALUES (
836 'Debian armv7l', 2
837 );
838
839 INSERT INTO groups ( /* 16 */
840 name
841 ) VALUES (
842 'TPM TBOOT'
843 );
844
845 /* Default Product Groups */
846
847 INSERT INTO groups_product_defaults (
848 group_id, product_id
849 ) VALUES (
850 4, 1
851 );
852
853 INSERT INTO groups_product_defaults (
854 group_id, product_id
855 ) VALUES (
856 4, 3
857 );
858
859 INSERT INTO groups_product_defaults (
860 group_id, product_id
861 ) VALUES (
862 4, 5
863 );
864
865 INSERT INTO groups_product_defaults (
866 group_id, product_id
867 ) VALUES (
868 4, 25
869 );
870
871 INSERT INTO groups_product_defaults (
872 group_id, product_id
873 ) VALUES (
874 4, 27
875 );
876
877 INSERT INTO groups_product_defaults (
878 group_id, product_id
879 ) VALUES (
880 4, 37
881 );
882
883 INSERT INTO groups_product_defaults (
884 group_id, product_id
885 ) VALUES (
886 4, 39
887 );
888
889 INSERT INTO groups_product_defaults (
890 group_id, product_id
891 ) VALUES (
892 4, 41
893 );
894
895 INSERT INTO groups_product_defaults (
896 group_id, product_id
897 ) VALUES (
898 4, 52
899 );
900
901 INSERT INTO groups_product_defaults (
902 group_id, product_id
903 ) VALUES (
904 4, 55
905 );
906
907 INSERT INTO groups_product_defaults (
908 group_id, product_id
909 ) VALUES (
910 4, 58
911 );
912
913 INSERT INTO groups_product_defaults (
914 group_id, product_id
915 ) VALUES (
916 4, 66
917 );
918
919 INSERT INTO groups_product_defaults (
920 group_id, product_id
921 ) VALUES (
922 5, 2
923 );
924
925 INSERT INTO groups_product_defaults (
926 group_id, product_id
927 ) VALUES (
928 5, 4
929 );
930
931 INSERT INTO groups_product_defaults (
932 group_id, product_id
933 ) VALUES (
934 5, 6
935 );
936
937 INSERT INTO groups_product_defaults (
938 group_id, product_id
939 ) VALUES (
940 5, 26
941 );
942
943 INSERT INTO groups_product_defaults (
944 group_id, product_id
945 ) VALUES (
946 5, 28
947 );
948
949 INSERT INTO groups_product_defaults (
950 group_id, product_id
951 ) VALUES (
952 5, 38
953 );
954
955 INSERT INTO groups_product_defaults (
956 group_id, product_id
957 ) VALUES (
958 5, 40
959 );
960
961 INSERT INTO groups_product_defaults (
962 group_id, product_id
963 ) VALUES (
964 5, 42
965 );
966
967 INSERT INTO groups_product_defaults (
968 group_id, product_id
969 ) VALUES (
970 5, 53
971 );
972
973 INSERT INTO groups_product_defaults (
974 group_id, product_id
975 ) VALUES (
976 5, 56
977 );
978
979 INSERT INTO groups_product_defaults (
980 group_id, product_id
981 ) VALUES (
982 5, 59
983 );
984
985 INSERT INTO groups_product_defaults (
986 group_id, product_id
987 ) VALUES (
988 5, 67
989 );
990
991 INSERT INTO groups_product_defaults (
992 group_id, product_id
993 ) VALUES (
994 6, 9
995 );
996
997 INSERT INTO groups_product_defaults (
998 group_id, product_id
999 ) VALUES (
1000 6, 11
1001 );
1002
1003 INSERT INTO groups_product_defaults (
1004 group_id, product_id
1005 ) VALUES (
1006 6, 13
1007 );
1008
1009 INSERT INTO groups_product_defaults (
1010 group_id, product_id
1011 ) VALUES (
1012 6, 15
1013 );
1014
1015 INSERT INTO groups_product_defaults (
1016 group_id, product_id
1017 ) VALUES (
1018 6, 17
1019 );
1020
1021 INSERT INTO groups_product_defaults (
1022 group_id, product_id
1023 ) VALUES (
1024 6, 19
1025 );
1026
1027 INSERT INTO groups_product_defaults (
1028 group_id, product_id
1029 ) VALUES (
1030 6, 23
1031 );
1032
1033 INSERT INTO groups_product_defaults (
1034 group_id, product_id
1035 ) VALUES (
1036 6, 35
1037 );
1038
1039 INSERT INTO groups_product_defaults (
1040 group_id, product_id
1041 ) VALUES (
1042 6, 61
1043 );
1044
1045 INSERT INTO groups_product_defaults (
1046 group_id, product_id
1047 ) VALUES (
1048 7, 8
1049 );
1050
1051 INSERT INTO groups_product_defaults (
1052 group_id, product_id
1053 ) VALUES (
1054 7, 10
1055 );
1056
1057 INSERT INTO groups_product_defaults (
1058 group_id, product_id
1059 ) VALUES (
1060 7, 12
1061 );
1062
1063 INSERT INTO groups_product_defaults (
1064 group_id, product_id
1065 ) VALUES (
1066 7, 14
1067 );
1068
1069 INSERT INTO groups_product_defaults (
1070 group_id, product_id
1071 ) VALUES (
1072 7, 16
1073 );
1074
1075 INSERT INTO groups_product_defaults (
1076 group_id, product_id
1077 ) VALUES (
1078 7, 18
1079 );
1080
1081 INSERT INTO groups_product_defaults (
1082 group_id, product_id
1083 ) VALUES (
1084 7, 20
1085 );
1086
1087 INSERT INTO groups_product_defaults (
1088 group_id, product_id
1089 ) VALUES (
1090 7, 24
1091 );
1092
1093 INSERT INTO groups_product_defaults (
1094 group_id, product_id
1095 ) VALUES (
1096 7, 36
1097 );
1098
1099 INSERT INTO groups_product_defaults (
1100 group_id, product_id
1101 ) VALUES (
1102 7, 62
1103 );
1104
1105 INSERT INTO groups_product_defaults (
1106 group_id, product_id
1107 ) VALUES (
1108 3, 21
1109 );
1110
1111 INSERT INTO groups_product_defaults (
1112 group_id, product_id
1113 ) VALUES (
1114 3, 22
1115 );
1116
1117 INSERT INTO groups_product_defaults (
1118 group_id, product_id
1119 ) VALUES (
1120 3, 29
1121 );
1122
1123 INSERT INTO groups_product_defaults (
1124 group_id, product_id
1125 ) VALUES (
1126 3, 30
1127 );
1128
1129 INSERT INTO groups_product_defaults (
1130 group_id, product_id
1131 ) VALUES (
1132 3, 31
1133 );
1134
1135 INSERT INTO groups_product_defaults (
1136 group_id, product_id
1137 ) VALUES (
1138 3, 32
1139 );
1140
1141 INSERT INTO groups_product_defaults (
1142 group_id, product_id
1143 ) VALUES (
1144 3, 33
1145 );
1146
1147 INSERT INTO groups_product_defaults (
1148 group_id, product_id
1149 ) VALUES (
1150 3, 34
1151 );
1152
1153 INSERT INTO groups_product_defaults (
1154 group_id, product_id
1155 ) VALUES (
1156 3, 49
1157 );
1158
1159 INSERT INTO groups_product_defaults (
1160 group_id, product_id
1161 ) VALUES (
1162 3, 50
1163 );
1164
1165 INSERT INTO groups_product_defaults (
1166 group_id, product_id
1167 ) VALUES (
1168 3, 63
1169 );
1170
1171 INSERT INTO groups_product_defaults (
1172 group_id, product_id
1173 ) VALUES (
1174 3, 64
1175 );
1176
1177 INSERT INTO groups_product_defaults (
1178 group_id, product_id
1179 ) VALUES (
1180 3, 51
1181 );
1182
1183 INSERT INTO groups_product_defaults (
1184 group_id, product_id
1185 ) VALUES (
1186 14, 43
1187 );
1188
1189 INSERT INTO groups_product_defaults (
1190 group_id, product_id
1191 ) VALUES (
1192 14, 44
1193 );
1194
1195 INSERT INTO groups_product_defaults (
1196 group_id, product_id
1197 ) VALUES (
1198 14, 45
1199 );
1200
1201 INSERT INTO groups_product_defaults (
1202 group_id, product_id
1203 ) VALUES (
1204 14, 46
1205 );
1206
1207 INSERT INTO groups_product_defaults (
1208 group_id, product_id
1209 ) VALUES (
1210 14, 47
1211 );
1212
1213 INSERT INTO groups_product_defaults (
1214 group_id, product_id
1215 ) VALUES (
1216 14, 48
1217 );
1218
1219 INSERT INTO groups_product_defaults (
1220 group_id, product_id
1221 ) VALUES (
1222 14, 54
1223 );
1224
1225 INSERT INTO groups_product_defaults (
1226 group_id, product_id
1227 ) VALUES (
1228 14, 57
1229 );
1230
1231 INSERT INTO groups_product_defaults (
1232 group_id, product_id
1233 ) VALUES (
1234 14, 60
1235 );
1236
1237 INSERT INTO groups_product_defaults (
1238 group_id, product_id
1239 ) VALUES (
1240 14, 68
1241 );
1242
1243 INSERT INTO groups_product_defaults (
1244 group_id, product_id
1245 ) VALUES (
1246 15, 65
1247 );
1248
1249 INSERT INTO groups_product_defaults (
1250 group_id, product_id
1251 ) VALUES (
1252 15, 69
1253 );
1254
1255 /* Policies */
1256
1257 INSERT INTO policies ( /* 1 */
1258 type, name, rec_fail, rec_noresult
1259 ) VALUES (
1260 1, 'Installed Packages', 2, 2
1261 );
1262
1263 INSERT INTO policies ( /* 2 */
1264 type, name, rec_fail, rec_noresult
1265 ) VALUES (
1266 2, 'Unknown Source', 2, 2
1267 );
1268
1269 INSERT INTO policies ( /* 3 */
1270 type, name, rec_fail, rec_noresult
1271 ) VALUES (
1272 3, 'IP Forwarding Enabled', 1, 1
1273 );
1274
1275 INSERT INTO policies ( /* 4 */
1276 type, name, rec_fail, rec_noresult
1277 ) VALUES (
1278 4, 'Default Factory Password Enabled', 1, 1
1279 );
1280
1281 INSERT INTO policies ( /* 5 */
1282 type, name, file, rec_fail, rec_noresult
1283 ) VALUES (
1284 6, 'Measure /lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 1, 2, 2
1285 );
1286
1287 INSERT INTO policies ( /* 6 */
1288 type, name, file, rec_fail, rec_noresult
1289 ) VALUES (
1290 6, 'Measure /lib/x86_64-linux-gnu/libssl.so.1.0.0', 3, 2, 2
1291 );
1292
1293 INSERT INTO policies ( /* 7 */
1294 type, name, file, rec_fail, rec_noresult
1295 ) VALUES (
1296 6, 'Measure /usr/bin/openssl', 5, 2, 2
1297 );
1298
1299 INSERT INTO policies ( /* 8 */
1300 type, name, rec_fail, rec_noresult
1301 ) VALUES (
1302 11, 'No Open TCP Ports', 1, 1
1303 );
1304
1305 INSERT INTO policies ( /* 9 */
1306 type, name, argument, rec_fail, rec_noresult
1307 ) VALUES (
1308 13, 'Open UDP Ports', '500 4500 10000-65000', 1, 1
1309 );
1310
1311 INSERT INTO policies ( /* 10 */
1312 type, name, file, rec_fail, rec_noresult
1313 ) VALUES (
1314 7, 'Metadata of /etc/tnc_config', 6, 0, 0
1315 );
1316
1317 INSERT INTO policies ( /* 11 */
1318 type, name, dir, rec_fail, rec_noresult
1319 ) VALUES (
1320 8, 'Get /bin', 1, 0, 0
1321 );
1322
1323 INSERT INTO policies ( /* 12 */
1324 type, name, file, rec_fail, rec_noresult
1325 ) VALUES (
1326 6, 'Measure /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 2, 2, 2
1327 );
1328
1329 INSERT INTO policies ( /* 13 */
1330 type, name, file, rec_fail, rec_noresult
1331 ) VALUES (
1332 6, 'Measure /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0', 4, 2, 2
1333 );
1334
1335 INSERT INTO policies ( /* 14 */
1336 type, name, dir, rec_fail, rec_noresult
1337 ) VALUES (
1338 8, 'Get /system/bin', 13, 0, 0
1339 );
1340
1341 INSERT INTO policies ( /* 15 */
1342 type, name, dir, rec_fail, rec_noresult
1343 ) VALUES (
1344 8, 'Get /system/lib', 14, 0, 0
1345 );
1346
1347 INSERT INTO policies ( /* 16 */
1348 type, name, dir, rec_fail, rec_noresult
1349 ) VALUES (
1350 9, 'Measure /bin', 1, 2, 2
1351 );
1352
1353 INSERT INTO policies ( /* 17 */
1354 type, name, argument, rec_fail, rec_noresult
1355 ) VALUES (
1356 15, 'SWID Tag IDs', 'R', 2, 2
1357 );
1358
1359 INSERT INTO policies ( /* 18 */
1360 type, name, argument, rec_fail, rec_noresult
1361 ) VALUES (
1362 15, 'SWID Tags', '', 2, 2
1363 );
1364
1365 INSERT INTO policies ( /* 19 */
1366 type, name, argument, rec_fail, rec_noresult
1367 ) VALUES (
1368 16, 'TPM BIOS Measurements', 'B', 2, 2
1369 );
1370
1371 INSERT INTO policies ( /* 20 */
1372 type, name, argument, rec_fail, rec_noresult
1373 ) VALUES (
1374 16, 'TPM IMA Measurements', 'I', 2, 2
1375 );
1376
1377 INSERT INTO policies ( /* 21 */
1378 type, name, argument, rec_fail, rec_noresult
1379 ) VALUES (
1380 16, 'TPM BIOS/IMA Measurements', 'BI', 2, 2
1381 );
1382
1383 INSERT INTO policies ( /* 22 */
1384 type, name, argument, rec_fail, rec_noresult
1385 ) VALUES (
1386 16, 'TPM TBOOT Measurements', 'T', 2, 2
1387 );
1388
1389 /* Enforcements */
1390
1391 INSERT INTO enforcements ( /* 1 */
1392 policy, group_id, max_age
1393 ) VALUES (
1394 1, 1, 86400
1395 );
1396
1397 INSERT INTO enforcements ( /* 2 */
1398 policy, group_id, max_age
1399 ) VALUES (
1400 2, 3, 0
1401 );
1402
1403 INSERT INTO enforcements ( /* 3 */
1404 policy, group_id, max_age
1405 ) VALUES (
1406 3, 2, 0
1407 );
1408
1409 INSERT INTO enforcements ( /* 4 */
1410 policy, group_id, max_age
1411 ) VALUES (
1412 5, 7, 86400
1413 );
1414
1415 INSERT INTO enforcements ( /* 5 */
1416 policy, group_id, max_age
1417 ) VALUES (
1418 6, 7, 86400
1419 );
1420
1421 INSERT INTO enforcements ( /* 6 */
1422 policy, group_id, max_age
1423 ) VALUES (
1424 7, 2, 86400
1425 );
1426
1427 INSERT INTO enforcements ( /* 7 */
1428 policy, group_id, max_age
1429 ) VALUES (
1430 8, 1, 60
1431 );
1432
1433 INSERT INTO enforcements ( /* 8 */
1434 policy, group_id, max_age
1435 ) VALUES (
1436 9, 1, 60
1437 );
1438
1439 INSERT INTO enforcements ( /* 9 */
1440 policy, group_id, max_age
1441 ) VALUES (
1442 10, 2, 60
1443 );
1444
1445 INSERT INTO enforcements ( /* 10 */
1446 policy, group_id, max_age
1447 ) VALUES (
1448 11, 10, 86400
1449 );
1450
1451 INSERT INTO enforcements ( /* 11 */
1452 policy, group_id, max_age
1453 ) VALUES (
1454 12, 5, 86400
1455 );
1456
1457 INSERT INTO enforcements ( /* 12 */
1458 policy, group_id, max_age
1459 ) VALUES (
1460 13, 5, 86400
1461 );
1462
1463 INSERT INTO enforcements ( /* 13 */
1464 policy, group_id, max_age
1465 ) VALUES (
1466 14, 9, 0
1467 );
1468
1469 INSERT INTO enforcements ( /* 14 */
1470 policy, group_id, max_age
1471 ) VALUES (
1472 15, 9, 0
1473 );
1474
1475 INSERT INTO enforcements ( /* 15 */
1476 policy, group_id, max_age
1477 ) VALUES (
1478 19, 11, 60
1479 );
1480
1481 INSERT INTO enforcements ( /* 16 */
1482 policy, group_id, max_age
1483 ) VALUES (
1484 20, 12, 60
1485 );
1486
1487 INSERT INTO enforcements ( /* 17 */
1488 policy, group_id, max_age
1489 ) VALUES (
1490 21, 13, 60
1491 );
1492
1493 INSERT INTO enforcements ( /* 18 */
1494 policy, group_id, max_age
1495 ) VALUES (
1496 22, 16, 60
1497 );
1498
1499 /* swid_entities */
1500
1501 INSERT INTO "swid_entities" ( /* 1 */
1502 "name", "regid"
1503 ) VALUES (
1504 'strongSwan Project', 'regid.2004-03.org.strongswan'
1505 );
1506
1507 INSERT INTO swid_entities ( /* 2 */
1508 "name", "regid"
1509 ) VALUES (
1510 'Adobe Systems Inc.', 'regid.1986-12.com.adobe'
1511 );
1512
1513 INSERT INTO swid_entities ( /* 3 */
1514 "name", "regid"
1515 ) VALUES (
1516 'Microsoft Corporation', 'regid.1991-06.com.microsoft'
1517 );
1518
1519 INSERT INTO swid_entities ( /* 4 */
1520 "name", "regid"
1521 ) VALUES (
1522 'Ubuntu Project', 'regid.2004-05.com.ubuntu'
1523 );
1524
1525 INSERT INTO swid_entities ( /* 5 */
1526 "name", "regid"
1527 ) VALUES (
1528 'Apache Software Foundation', 'regid.1995-04.org.apache'
1529 );
1530
1531 INSERT INTO swid_entities ( /* 6 */
1532 "name", "regid"
1533 ) VALUES (
1534 'Debian Project', 'regid.1999-03.org.debian'
1535 );
1536
1537 INSERT INTO swid_entities ( /* 7 */
1538 "name", "regid"
1539 ) VALUES (
1540 'Internet Systems Consortium', 'regid.1994-04.org.isc'
1541 );
1542
1543 INSERT INTO swid_entities ( /* 8 */
1544 "name", "regid"
1545 ) VALUES (
1546 'OpenSSL Project', 'regid.1998-12.org.openssl'
1547 );
1548
1549 INSERT INTO swid_entities ( /* 9 */
1550 "name", "regid"
1551 ) VALUES (
1552 'Samba Project', 'regid.1998-01.org.samba'
1553 );
1554
1555 INSERT INTO swid_entities ( /* 10 */
1556 "name", "regid"
1557 ) VALUES (
1558 'SQLite Project', 'regid.2002-08.org.sqlite'
1559 );