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