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