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