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