![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to data.sql CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / strongswan / src / libimcv / imv|
Return to data.sql CVS log | Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / strongswan / src / libimcv / imv |
1.1 misho 1: /* Products */
2:
3: INSERT INTO products ( /* 1 */
4: name
5: ) VALUES (
6: 'Debian 6.0 i686'
7: );
8:
9: INSERT INTO products ( /* 2 */
10: name
11: ) VALUES (
12: 'Debian 6.0 x86_64'
13: );
14:
15: INSERT INTO products ( /* 3 */
16: name
17: ) VALUES (
18: 'Debian 7.0 i686'
19: );
20:
21: INSERT INTO products ( /* 4 */
22: name
23: ) VALUES (
24: 'Debian 7.0 x86_64'
25: );
26:
27: INSERT INTO products ( /* 5 */
28: name
29: ) VALUES (
30: 'Debian 8.0 i686'
31: );
32:
33: INSERT INTO products ( /* 6 */
34: name
35: ) VALUES (
36: 'Debian 8.0 x86_64'
37: );
38:
39: INSERT INTO products ( /* 7 */
40: name
41: ) VALUES (
42: 'Ubuntu 10.04 i686'
43: );
44:
45: INSERT INTO products ( /* 8 */
46: name
47: ) VALUES (
48: 'Ubuntu 10.04 x86_64'
49: );
50:
51: INSERT INTO products ( /* 9 */
52: name
53: ) VALUES (
54: 'Ubuntu 10.10 i686'
55: );
56:
57: INSERT INTO products ( /* 10 */
58: name
59: ) VALUES (
60: 'Ubuntu 10.10 x86_64'
61: );
62:
63: INSERT INTO products ( /* 11 */
64: name
65: ) VALUES (
66: 'Ubuntu 11.04 i686'
67: );
68:
69: INSERT INTO products ( /* 12 */
70: name
71: ) VALUES (
72: 'Ubuntu 11.04 x86_64'
73: );
74:
75: INSERT INTO products ( /* 13 */
76: name
77: ) VALUES (
78: 'Ubuntu 11.10 i686'
79: );
80:
81: INSERT INTO products ( /* 14 */
82: name
83: ) VALUES (
84: 'Ubuntu 11.10 x86_64'
85: );
86:
87: INSERT INTO products ( /* 15 */
88: name
89: ) VALUES (
90: 'Ubuntu 12.04 i686'
91: );
92:
93: INSERT INTO products ( /* 16 */
94: name
95: ) VALUES (
96: 'Ubuntu 12.04 x86_64'
97: );
98:
99: INSERT INTO products ( /* 17 */
100: name
101: ) VALUES (
102: 'Ubuntu 12.10 i686'
103: );
104:
105: INSERT INTO products ( /* 18 */
106: name
107: ) VALUES (
108: 'Ubuntu 12.10 x86_64'
109: );
110:
111: INSERT INTO products ( /* 19 */
112: name
113: ) VALUES (
114: 'Ubuntu 13.04 i686'
115: );
116:
117: INSERT INTO products ( /* 20 */
118: name
119: ) VALUES (
120: 'Ubuntu 13.04 x86_64'
121: );
122:
123: INSERT INTO products ( /* 21 */
124: name
125: ) VALUES (
126: 'Android 4.1.1'
127: );
128:
129: INSERT INTO products ( /* 22 */
130: name
131: ) VALUES (
132: 'Android 4.2.1'
133: );
134:
135: INSERT INTO products ( /* 23 */
136: name
137: ) VALUES (
138: 'Ubuntu 13.10 i686'
139: );
140:
141: INSERT INTO products ( /* 24 */
142: name
143: ) VALUES (
144: 'Ubuntu 13.10 x86_64'
145: );
146:
147: INSERT INTO products ( /* 25 */
148: name
149: ) VALUES (
150: 'Debian 7.1 i686'
151: );
152:
153: INSERT INTO products ( /* 26 */
154: name
155: ) VALUES (
156: 'Debian 7.1 x86_64'
157: );
158:
159: INSERT INTO products ( /* 27 */
160: name
161: ) VALUES (
162: 'Debian 7.2 i686'
163: );
164:
165: INSERT INTO products ( /* 28 */
166: name
167: ) VALUES (
168: 'Debian 7.2 x86_64'
169: );
170:
171: INSERT INTO products ( /* 29 */
172: name
173: ) VALUES (
174: 'Android 4.1.2'
175: );
176:
177: INSERT INTO products ( /* 30 */
178: name
179: ) VALUES (
180: 'Android 4.2.2'
181: );
182:
183: INSERT INTO products ( /* 31 */
184: name
185: ) VALUES (
186: 'Android 4.3.1'
187: );
188:
189: INSERT INTO products ( /* 32 */
190: name
191: ) VALUES (
192: 'Android 4.4'
193: );
194:
195: INSERT INTO products ( /* 33 */
196: name
197: ) VALUES (
198: 'Android 4.4.1'
199: );
200:
201: INSERT INTO products ( /* 34 */
202: name
203: ) VALUES (
204: 'Android 4.4.2'
205: );
206:
207: INSERT INTO products ( /* 35 */
208: name
209: ) VALUES (
210: 'Ubuntu 14.04 i686'
211: );
212:
213: INSERT INTO products ( /* 36 */
214: name
215: ) VALUES (
216: 'Ubuntu 14.04 x86_64'
217: );
218:
219: INSERT INTO products ( /* 37 */
220: name
221: ) VALUES (
222: 'Debian 7.3 i686'
223: );
224:
225: INSERT INTO products ( /* 38 */
226: name
227: ) VALUES (
228: 'Debian 7.3 x86_64'
229: );
230:
231: INSERT INTO products ( /* 39 */
232: name
233: ) VALUES (
234: 'Debian 7.4 i686'
235: );
236:
237: INSERT INTO products ( /* 40 */
238: name
239: ) VALUES (
240: 'Debian 7.4 x86_64'
241: );
242:
243: INSERT INTO products ( /* 41 */
244: name
245: ) VALUES (
246: 'Debian 7.5 i686'
247: );
248:
249: INSERT INTO products ( /* 42 */
250: name
251: ) VALUES (
252: 'Debian 7.5 x86_64'
253: );
254:
255: INSERT INTO products ( /* 43 */
256: name
257: ) VALUES (
258: 'Debian 7.0 armv6l'
259: );
260:
261: INSERT INTO products ( /* 44 */
262: name
263: ) VALUES (
264: 'Debian 7.1 armv6l'
265: );
266:
267: INSERT INTO products ( /* 45 */
268: name
269: ) VALUES (
270: 'Debian 7.2 armv6l'
271: );
272:
273: INSERT INTO products ( /* 46 */
274: name
275: ) VALUES (
276: 'Debian 7.3 armv6l'
277: );
278:
279: INSERT INTO products ( /* 47 */
280: name
281: ) VALUES (
282: 'Debian 7.4 armv6l'
283: );
284:
285: INSERT INTO products ( /* 48 */
286: name
287: ) VALUES (
288: 'Debian 7.5 armv6l'
289: );
290:
291: INSERT INTO products ( /* 49 */
292: name
293: ) VALUES (
294: 'Android 4.3'
295: );
296:
297: INSERT INTO products ( /* 50 */
298: name
299: ) VALUES (
300: 'Android 4.4.3'
301: );
302:
303: INSERT INTO products ( /* 51 */
304: name
305: ) VALUES (
306: 'Android 4.4.4'
307: );
308:
309: INSERT INTO products ( /* 52 */
310: name
311: ) VALUES (
312: 'Debian 7.6 i686'
313: );
314:
315: INSERT INTO products ( /* 53 */
316: name
317: ) VALUES (
318: 'Debian 7.6 x86_64'
319: );
320: INSERT INTO products ( /* 54 */
321: name
322: ) VALUES (
323: 'Debian 7.6 armv6l'
324: );
325:
326: INSERT INTO products ( /* 55 */
327: name
328: ) VALUES (
329: 'Debian 7.7 i686'
330: );
331:
332: INSERT INTO products ( /* 56 */
333: name
334: ) VALUES (
335: 'Debian 7.7 x86_64'
336: );
337: INSERT INTO products ( /* 57 */
338: name
339: ) VALUES (
340: 'Debian 7.7 armv6l'
341: );
342:
343: INSERT INTO products ( /* 58 */
344: name
345: ) VALUES (
346: 'Debian 7.8 i686'
347: );
348:
349: INSERT INTO products ( /* 59 */
350: name
351: ) VALUES (
352: 'Debian 7.8 x86_64'
353: );
354:
355: INSERT INTO products ( /* 60 */
356: name
357: ) VALUES (
358: 'Debian 7.8 armv6l'
359: );
360:
361: INSERT INTO products ( /* 61 */
362: name
363: ) VALUES (
364: 'Ubuntu 14.10 i686'
365: );
366:
367: INSERT INTO products ( /* 62 */
368: name
369: ) VALUES (
370: 'Ubuntu 14.10 x86_64'
371: );
372:
373: INSERT INTO products ( /* 63 */
374: name
375: ) VALUES (
376: 'Android 5.0'
377: );
378:
379: INSERT INTO products ( /* 64 */
380: name
381: ) VALUES (
382: 'Android 5.0.1'
383: );
384:
385: INSERT INTO products ( /* 65 */
386: name
387: ) VALUES (
388: 'Debian 7.8 armv7l'
389: );
390:
391: INSERT INTO products ( /* 66 */
392: name
393: ) VALUES (
394: 'Debian 7.9 i686'
395: );
396:
397: INSERT INTO products ( /* 67 */
398: name
399: ) VALUES (
400: 'Debian 7.9 x86_64'
401: );
402:
403: INSERT INTO products ( /* 68 */
404: name
405: ) VALUES (
406: 'Debian 7.9 armv6l'
407: );
408:
409: INSERT INTO products ( /* 69 */
410: name
411: ) VALUES (
412: 'Debian 7.9 armv7l'
413: );
414:
415: INSERT INTO products ( /* 70 */
416: name
417: ) VALUES (
418: 'Ubuntu 15.04 i686'
419: );
420:
421: INSERT INTO products ( /* 71 */
422: name
423: ) VALUES (
424: 'Ubuntu 15.04 x86_64'
425: );
426:
427: INSERT INTO products ( /* 72 */
428: name
429: ) VALUES (
430: 'Ubuntu 15.10 i686'
431: );
432:
433: INSERT INTO products ( /* 73 */
434: name
435: ) VALUES (
436: 'Ubuntu 15.10 x86_64'
437: );
438:
439: INSERT INTO products ( /* 74 */
440: name
441: ) VALUES (
442: 'Ubuntu 16.04 i686'
443: );
444:
445: INSERT INTO products ( /* 75 */
446: name
447: ) VALUES (
448: 'Ubuntu 16.04 x86_64'
449: );
450:
451: INSERT INTO products ( /* 76 */
452: name
453: ) VALUES (
454: 'Debian 7.10 i686'
455: );
456:
457: INSERT INTO products ( /* 77 */
458: name
459: ) VALUES (
460: 'Debian 7.10 x86_64'
461: );
462:
463: INSERT INTO products ( /* 78 */
464: name
465: ) VALUES (
466: 'Debian 7.10 armv6l'
467: );
468:
469: INSERT INTO products ( /* 79 */
470: name
471: ) VALUES (
472: 'Debian 7.10 armv7l'
473: );
474:
475: INSERT INTO products ( /* 80 */
476: name
477: ) VALUES (
478: 'Android 6.0'
479: );
480:
481: INSERT INTO products ( /* 81 */
482: name
483: ) VALUES (
484: 'Android 6.0.1'
485: );
486:
487: INSERT INTO products ( /* 82 */
488: name
489: ) VALUES (
490: 'Debian 8.5 i686'
491: );
492:
493: INSERT INTO products ( /* 83 */
494: name
495: ) VALUES (
496: 'Debian 8.5 x86_64'
497: );
498:
499: INSERT INTO products ( /* 84 */
500: name
501: ) VALUES (
502: 'Debian 8.6 i686'
503: );
504:
505: INSERT INTO products ( /* 85 */
506: name
507: ) VALUES (
508: 'Debian 8.6 x86_64'
509: );
510:
511: INSERT INTO products ( /* 86 */
512: name
513: ) VALUES (
514: 'Debian 8.7 i686'
515: );
516:
517: INSERT INTO products ( /* 87 */
518: name
519: ) VALUES (
520: 'Debian 8.7 x86_64'
521: );
522:
523: INSERT INTO products ( /* 88 */
524: name
525: ) VALUES (
526: 'Debian 8.8 i686'
527: );
528:
529: INSERT INTO products ( /* 89 */
530: name
531: ) VALUES (
532: 'Debian 8.8 x86_64'
533: );
534:
535: INSERT INTO products ( /* 90 */
536: name
537: ) VALUES (
538: 'Debian 8.9 i686'
539: );
540:
541: INSERT INTO products ( /* 91 */
542: name
543: ) VALUES (
544: 'Debian 8.9 x86_64'
545: );
546:
547: INSERT INTO products ( /* 92 */
548: name
549: ) VALUES (
550: 'Debian 8.10 i686'
551: );
552:
553: INSERT INTO products ( /* 93 */
554: name
555: ) VALUES (
556: 'Debian 8.10 x86_64'
557: );
558:
559: INSERT INTO products ( /* 94 */
560: name
561: ) VALUES (
562: 'Debian 8.11 i686'
563: );
564:
565: INSERT INTO products ( /* 95 */
566: name
567: ) VALUES (
568: 'Debian 8.11 x86_64'
569: );
570:
571: INSERT INTO products ( /* 96 */
572: name
573: ) VALUES (
574: 'Ubuntu 18.04 x86_64'
575: );
576:
577: INSERT INTO products ( /* 97 */
578: name
579: ) VALUES (
580: 'Debian 9.5 i686'
581: );
582:
583: INSERT INTO products ( /* 98 */
584: name
585: ) VALUES (
586: 'Debian 9.5 x86_64'
587: );
588:
589: INSERT INTO products ( /* 99 */
590: name
591: ) VALUES (
592: 'Debian 9.6 x86_64'
593: );
594:
595: INSERT INTO products ( /* 100 */
596: name
597: ) VALUES (
598: 'Debian 9.7 x86_64'
599: );
600:
1.1.1.2 ! misho 601: INSERT INTO products ( /* 101 */
! 602: name
! 603: ) VALUES (
! 604: 'Debian 9.13 x86_64'
! 605: );
! 606:
! 607: INSERT INTO products ( /* 102 */
! 608: name
! 609: ) VALUES (
! 610: 'Debian 10 x86_64'
! 611: );
! 612:
1.1 misho 613: /* Directories */
614:
615: INSERT INTO directories ( /* 1 */
616: path
617: ) VALUES (
618: '/bin'
619: );
620:
621: INSERT INTO directories ( /* 2 */
622: path
623: ) VALUES (
624: '/etc'
625: );
626:
627: INSERT INTO directories ( /* 3 */
628: path
629: ) VALUES (
630: '/lib'
631: );
632:
633: INSERT INTO directories ( /* 4 */
634: path
635: ) VALUES (
636: '/lib/i386-linux-gnu'
637: );
638:
639: INSERT INTO directories ( /* 5 */
640: path
641: ) VALUES (
642: '/lib/x86_64-linux-gnu'
643: );
644:
645: INSERT INTO directories ( /* 6 */
646: path
647: ) VALUES (
648: '/lib/xtables'
649: );
650:
651: INSERT INTO directories ( /* 7 */
652: path
653: ) VALUES (
654: '/sbin'
655: );
656:
657: INSERT INTO directories ( /* 8 */
658: path
659: ) VALUES (
660: '/usr/bin'
661: );
662:
663: INSERT INTO directories ( /* 9 */
664: path
665: ) VALUES (
666: '/usr/lib'
667: );
668:
669: INSERT INTO directories ( /* 10 */
670: path
671: ) VALUES (
672: '/usr/lib/i386-linux-gnu'
673: );
674:
675: INSERT INTO directories ( /* 11 */
676: path
677: ) VALUES (
678: '/usr/lib/x86_64-linux-gnu'
679: );
680:
681: INSERT INTO directories ( /* 12 */
682: path
683: ) VALUES (
684: '/usr/sbin'
685: );
686:
687: INSERT INTO directories ( /* 13 */
688: path
689: ) VALUES (
690: '/system/bin'
691: );
692:
693: INSERT INTO directories ( /* 14 */
694: path
695: ) VALUES (
696: '/system/lib'
697: );
698:
699: /* Files */
700:
701: INSERT INTO files ( /* 1 */
702: name, dir
703: ) VALUES (
704: 'libcrypto.so.1.0.0', 5
705: );
706:
707: INSERT INTO files ( /* 2 */
708: name, dir
709: ) VALUES (
710: 'libcrypto.so.1.1', 11
711: );
712:
713: INSERT INTO files ( /* 3 */
714: name, dir
715: ) VALUES (
716: 'libssl.so.1.0.0', 5
717: );
718:
719: INSERT INTO files ( /* 4 */
720: name, dir
721: ) VALUES (
722: 'libssl.so.1.1', 11
723: );
724:
725: INSERT INTO files ( /* 5 */
726: name, dir
727: ) VALUES (
728: 'openssl', 8
729: );
730:
731: INSERT INTO files ( /* 6 */
732: name, dir
733: ) VALUES (
734: 'tnc_config', 2
735: );
736:
737: /* Algorithms */
738:
739: INSERT INTO algorithms (
740: id, name
741: ) VALUES (
742: 32768, 'SHA1'
743: );
744:
745: INSERT INTO algorithms (
746: id, name
747: ) VALUES (
748: 16384, 'SHA256'
749: );
750:
751: INSERT INTO algorithms (
752: id, name
753: ) VALUES (
754: 8192, 'SHA384'
755: );
756:
757: INSERT INTO algorithms (
758: id, name
759: ) VALUES (
760: 4096, 'SHA512'
761: );
762:
763: /* File Hashes */
764:
765: INSERT INTO file_hashes (
766: version, file, algo, hash
767: ) VALUES (
768: 2, 2, 32768, '6c6f8e12f6cbfba612e780374c4cdcd40f20968a'
769: );
770:
771: INSERT INTO file_hashes (
772: version, file, algo, hash
773: ) VALUES (
774: 2, 2, 16384, 'dbcecd19d59310183cf5c31ddee29e8d7bec64d3f9583aad074330a1b3024b07'
775: );
776:
777: INSERT INTO file_hashes (
778: version, file, algo, hash
779: ) VALUES (
780: 2, 2, 8192, '197c5385e5853003188833d4f991136c1b0875fa416a60b1159f64e57e457b3184762c884a802a2bda194c058e3bd953'
781: );
782:
783: INSERT INTO file_hashes (
784: version, file, algo, hash
785: ) VALUES (
786: 2, 4, 32768, '3ad204f99eb7262efab79cfca02628870ea76361'
787: );
788:
789: INSERT INTO file_hashes (
790: version, file, algo, hash
791: ) VALUES (
792: 2, 4, 16384, '3a2170aad92fdd58b55e0e199822bc873cf587b2d1eb1ed7ed8dcea97ae86376'
793: );
794:
795: INSERT INTO file_hashes (
796: version, file, algo, hash
797: ) VALUES (
798: 2, 4, 8192, 'f778076baa876b5e4b502494a3db081fb09dd870dee6991d54104a74b7e009c58fe261db5ffd13c11e08ef0cefcfa59f'
799: );
800:
801: INSERT INTO file_hashes (
802: version, file, algo, hash
803: ) VALUES (
804: 4, 5, 32768, 'ecd9c7076cc0572724c7a67db7f19c2831e0445f'
805: );
806:
807: INSERT INTO file_hashes (
808: version, file, algo, hash
809: ) VALUES (
810: 4, 5, 16384, '28f3ea5afd34444c8232ea75003131e294a0c9b847de300e4b205d38c1a41305'
811: );
812:
813: INSERT INTO file_hashes (
814: version, file, algo, hash
815: ) VALUES (
816: 4, 5, 8192, '51921a8b9322f2d3f06d55002ff40a79da67e70cb563b2a50977642d603dfac2ccbb68b3d32a8bb350769b75d6254208'
817: );
818:
819: INSERT INTO file_hashes (
820: version, file, algo, hash
821: ) VALUES (
822: 5, 1, 32768, 'd9309b9e45928239d7a7b18711e690792632cce4'
823: );
824:
825: INSERT INTO file_hashes (
826: version, file, algo, hash
827: ) VALUES (
828: 5, 1, 16384, 'dbfa1856d278d8707c4989b30dd065b4bcd309908f0f2e6e66ff2aa83ff93f59'
829: );
830:
831: INSERT INTO file_hashes (
832: version, file, algo, hash
833: ) VALUES (
834: 5, 1, 8192, 'fb8d027f03bb5ebb47741ed247eb9e174127b714d20229885feb37e0979aeb14a1b74020cded891d680441093625729c'
835: );
836:
837: INSERT INTO file_hashes (
838: version, file, algo, hash
839: ) VALUES (
840: 5, 3, 32768, '3715f2f94016a91fab5bbc503f0f1d43c5a9fc2b'
841: );
842:
843: INSERT INTO file_hashes (
844: version, file, algo, hash
845: ) VALUES (
846: 5, 3, 16384, 'c03a5296b5decb87b01517f9927a8b2349dfb29ff9f5ba084f994c155ca5d4be'
847: );
848:
849: INSERT INTO file_hashes (
850: version, file, algo, hash
851: ) VALUES (
852: 5, 3, 8192, 'b8bc345f56115235cc6091f61e312ce43ea54a5b99e7295002ae7b415fd35e06ec4c731ab70ad00d784bb53a318a2fa0'
853: );
854:
855: INSERT INTO file_hashes (
856: version, file, algo, hash
857: ) VALUES (
858: 6, 5, 32768, 'e59602f4edf24c1b36199588886d06665d4adcd7'
859: );
860:
861: INSERT INTO file_hashes (
862: version, file, algo, hash
863: ) VALUES (
864: 6, 5, 16384, '090e1b77bda7fe665e498c6b5e09dbb7ddc5cfe57f213de48f4fb6736484f500'
865: );
866:
867: INSERT INTO file_hashes (
868: version, file, algo, hash
869: ) VALUES (
870: 6, 5, 8192, '7cbdb4612a13443dba910ecdef5161f2213e52c9b4a2eef14bcee5d287e9df931cd022e9e9715518ad9c9b6e3384a668'
871: );
872:
873: /* Packages */
874:
875: INSERT INTO packages ( /* 1 */
876: name
877: ) VALUES (
878: 'libssl-dev'
879: );
880:
881: INSERT INTO packages ( /* 2 */
882: name
883: ) VALUES (
884: 'libssl1.0.0'
885: );
886:
887: INSERT INTO packages ( /* 3 */
888: name
889: ) VALUES (
890: 'libssl1.0.0-dbg'
891: );
892:
893: INSERT INTO packages ( /* 4 */
894: name
895: ) VALUES (
896: 'openssl'
897: );
898:
899: /* Versions */
900:
901: INSERT INTO versions ( /* 1 */
902: package, product, release, time
903: ) VALUES (
904: 1, 28, '1.0.1e-2', 1366531494
905: );
906:
907: INSERT INTO versions ( /* 2 */
908: package, product, release, time
909: ) VALUES (
910: 2, 28, '1.0.1e-2', 1366531494
911: );
912:
913: INSERT INTO versions ( /* 3 */
914: package, product, release, time
915: ) VALUES (
916: 3, 28, '1.0.1e-2', 1366531494
917: );
918:
919: INSERT INTO versions ( /* 4 */
920: package, product, release, time
921: ) VALUES (
922: 4, 28, '1.0.1e-2', 1366531494
923: );
924:
925: INSERT INTO versions ( /* 5 */
926: package, product, time
927: ) VALUES (
928: 2, 18, 1350544774
929: );
930:
931: INSERT INTO versions ( /* 6 */
932: package, product, time
933: ) VALUES (
934: 4, 18, 1350544774
935: );
936:
937: /* Components */
938:
939: INSERT INTO components (
940: vendor_id, name, qualifier, label
941: ) VALUES (
942: 36906, 1, 33, 'G' /* ITA TGRUB */
943: );
944:
945: INSERT INTO components (
946: vendor_id, name, qualifier, label
947: ) VALUES (
948: 36906, 2, 33, 'T' /* ITA TBOOT */
949: );
950:
951: INSERT INTO components (
952: vendor_id, name, qualifier, label
953: ) VALUES (
954: 36906, 3, 33, 'B' /* ITA IMA - Trusted Platform */
955: );
956:
957: INSERT INTO components (
958: vendor_id, name, qualifier, label
959: ) VALUES (
960: 36906, 3, 34, 'I' /* ITA IMA - Operating System */
961: );
962:
963: /* Groups */
964:
965: INSERT INTO groups ( /* 1 */
966: name
967: ) VALUES (
968: 'Default'
969: );
970:
971: INSERT INTO groups ( /* 2 */
972: name, parent
973: ) VALUES (
974: 'Linux', 1
975: );
976:
977: INSERT INTO groups ( /* 3 */
978: name, parent
979: ) VALUES (
980: 'Android', 1
981: );
982:
983: INSERT INTO groups ( /* 4 */
984: name, parent
985: ) VALUES (
986: 'Debian i686', 2
987: );
988:
989: INSERT INTO groups ( /* 5 */
990: name, parent
991: ) VALUES (
992: 'Debian x86_64', 2
993: );
994:
995: INSERT INTO groups ( /* 6 */
996: name, parent
997: ) VALUES (
998: 'Ubuntu i686', 2
999: );
1000:
1001: INSERT INTO groups ( /* 7 */
1002: name, parent
1003: ) VALUES (
1004: 'Ubuntu x86_64', 2
1005: );
1006:
1007: INSERT INTO groups ( /* 8 */
1008: name
1009: ) VALUES (
1010: 'Reference'
1011: );
1012:
1013: INSERT INTO groups ( /* 9 */
1014: name, parent
1015: ) VALUES (
1016: 'Ref. Android', 8
1017: );
1018:
1019: INSERT INTO groups ( /* 10 */
1020: name, parent
1021: ) VALUES (
1022: 'Ref. Linux', 8
1023: );
1024:
1025: INSERT INTO groups ( /* 11 */
1026: name
1027: ) VALUES (
1028: 'TPM BIOS'
1029: );
1030:
1031: INSERT INTO groups ( /* 12 */
1032: name
1033: ) VALUES (
1034: 'TPM IMA'
1035: );
1036:
1037: INSERT INTO groups ( /* 13 */
1038: name
1039: ) VALUES (
1040: 'TPM BIOS/IMA'
1041: );
1042:
1043: INSERT INTO groups ( /* 14 */
1044: name, parent
1045: ) VALUES (
1046: 'Debian armv6l', 2
1047: );
1048:
1049: INSERT INTO groups ( /* 15 */
1050: name, parent
1051: ) VALUES (
1052: 'Debian armv7l', 2
1053: );
1054:
1055: INSERT INTO groups ( /* 16 */
1056: name
1057: ) VALUES (
1058: 'TPM TBOOT'
1059: );
1060:
1061: /* Default Product Groups */
1062:
1063: INSERT INTO groups_product_defaults (
1064: group_id, product_id
1065: ) VALUES (
1066: 4, 1
1067: );
1068:
1069: INSERT INTO groups_product_defaults (
1070: group_id, product_id
1071: ) VALUES (
1072: 4, 3
1073: );
1074:
1075: INSERT INTO groups_product_defaults (
1076: group_id, product_id
1077: ) VALUES (
1078: 4, 5
1079: );
1080:
1081: INSERT INTO groups_product_defaults (
1082: group_id, product_id
1083: ) VALUES (
1084: 4, 25
1085: );
1086:
1087: INSERT INTO groups_product_defaults (
1088: group_id, product_id
1089: ) VALUES (
1090: 4, 27
1091: );
1092:
1093: INSERT INTO groups_product_defaults (
1094: group_id, product_id
1095: ) VALUES (
1096: 4, 37
1097: );
1098:
1099: INSERT INTO groups_product_defaults (
1100: group_id, product_id
1101: ) VALUES (
1102: 4, 39
1103: );
1104:
1105: INSERT INTO groups_product_defaults (
1106: group_id, product_id
1107: ) VALUES (
1108: 4, 41
1109: );
1110:
1111: INSERT INTO groups_product_defaults (
1112: group_id, product_id
1113: ) VALUES (
1114: 4, 52
1115: );
1116:
1117: INSERT INTO groups_product_defaults (
1118: group_id, product_id
1119: ) VALUES (
1120: 4, 55
1121: );
1122:
1123: INSERT INTO groups_product_defaults (
1124: group_id, product_id
1125: ) VALUES (
1126: 4, 58
1127: );
1128:
1129: INSERT INTO groups_product_defaults (
1130: group_id, product_id
1131: ) VALUES (
1132: 4, 66
1133: );
1134:
1135: INSERT INTO groups_product_defaults (
1136: group_id, product_id
1137: ) VALUES (
1138: 4, 76
1139: );
1140:
1141: INSERT INTO groups_product_defaults (
1142: group_id, product_id
1143: ) VALUES (
1144: 4, 82
1145: );
1146:
1147: INSERT INTO groups_product_defaults (
1148: group_id, product_id
1149: ) VALUES (
1150: 4, 84
1151: );
1152:
1153: INSERT INTO groups_product_defaults (
1154: group_id, product_id
1155: ) VALUES (
1156: 4, 86
1157: );
1158:
1159: INSERT INTO groups_product_defaults (
1160: group_id, product_id
1161: ) VALUES (
1162: 4, 88
1163: );
1164:
1165: INSERT INTO groups_product_defaults (
1166: group_id, product_id
1167: ) VALUES (
1168: 4, 90
1169: );
1170:
1171: INSERT INTO groups_product_defaults (
1172: group_id, product_id
1173: ) VALUES (
1174: 4, 92
1175: );
1176:
1177: INSERT INTO groups_product_defaults (
1178: group_id, product_id
1179: ) VALUES (
1180: 4, 94
1181: );
1182:
1183: INSERT INTO groups_product_defaults (
1184: group_id, product_id
1185: ) VALUES (
1186: 4, 97
1187: );
1188:
1189: INSERT INTO groups_product_defaults (
1190: group_id, product_id
1191: ) VALUES (
1192: 5, 2
1193: );
1194:
1195: INSERT INTO groups_product_defaults (
1196: group_id, product_id
1197: ) VALUES (
1198: 5, 4
1199: );
1200:
1201: INSERT INTO groups_product_defaults (
1202: group_id, product_id
1203: ) VALUES (
1204: 5, 6
1205: );
1206:
1207: INSERT INTO groups_product_defaults (
1208: group_id, product_id
1209: ) VALUES (
1210: 5, 26
1211: );
1212:
1213: INSERT INTO groups_product_defaults (
1214: group_id, product_id
1215: ) VALUES (
1216: 5, 28
1217: );
1218:
1219: INSERT INTO groups_product_defaults (
1220: group_id, product_id
1221: ) VALUES (
1222: 5, 38
1223: );
1224:
1225: INSERT INTO groups_product_defaults (
1226: group_id, product_id
1227: ) VALUES (
1228: 5, 40
1229: );
1230:
1231: INSERT INTO groups_product_defaults (
1232: group_id, product_id
1233: ) VALUES (
1234: 5, 42
1235: );
1236:
1237: INSERT INTO groups_product_defaults (
1238: group_id, product_id
1239: ) VALUES (
1240: 5, 53
1241: );
1242:
1243: INSERT INTO groups_product_defaults (
1244: group_id, product_id
1245: ) VALUES (
1246: 5, 56
1247: );
1248:
1249: INSERT INTO groups_product_defaults (
1250: group_id, product_id
1251: ) VALUES (
1252: 5, 59
1253: );
1254:
1255: INSERT INTO groups_product_defaults (
1256: group_id, product_id
1257: ) VALUES (
1258: 5, 67
1259: );
1260:
1261: INSERT INTO groups_product_defaults (
1262: group_id, product_id
1263: ) VALUES (
1264: 5, 77
1265: );
1266:
1267: INSERT INTO groups_product_defaults (
1268: group_id, product_id
1269: ) VALUES (
1270: 5, 83
1271: );
1272:
1273: INSERT INTO groups_product_defaults (
1274: group_id, product_id
1275: ) VALUES (
1276: 5, 85
1277: );
1278:
1279: INSERT INTO groups_product_defaults (
1280: group_id, product_id
1281: ) VALUES (
1282: 5, 87
1283: );
1284:
1285: INSERT INTO groups_product_defaults (
1286: group_id, product_id
1287: ) VALUES (
1288: 5, 89
1289: );
1290:
1291: INSERT INTO groups_product_defaults (
1292: group_id, product_id
1293: ) VALUES (
1294: 5, 91
1295: );
1296:
1297: INSERT INTO groups_product_defaults (
1298: group_id, product_id
1299: ) VALUES (
1300: 5, 93
1301: );
1302:
1303: INSERT INTO groups_product_defaults (
1304: group_id, product_id
1305: ) VALUES (
1306: 5, 95
1307: );
1308:
1309: INSERT INTO groups_product_defaults (
1310: group_id, product_id
1311: ) VALUES (
1312: 5, 98
1313: );
1314:
1315: INSERT INTO groups_product_defaults (
1316: group_id, product_id
1317: ) VALUES (
1318: 5, 99
1319: );
1320:
1321: INSERT INTO groups_product_defaults (
1322: group_id, product_id
1323: ) VALUES (
1324: 5, 100
1325: );
1326:
1327: INSERT INTO groups_product_defaults (
1328: group_id, product_id
1329: ) VALUES (
1.1.1.2 ! misho 1330: 5, 101
! 1331: );
! 1332:
! 1333: INSERT INTO groups_product_defaults (
! 1334: group_id, product_id
! 1335: ) VALUES (
! 1336: 5, 102
! 1337: );
! 1338:
! 1339: INSERT INTO groups_product_defaults (
! 1340: group_id, product_id
! 1341: ) VALUES (
1.1 misho 1342: 6, 9
1343: );
1344:
1345: INSERT INTO groups_product_defaults (
1346: group_id, product_id
1347: ) VALUES (
1348: 6, 11
1349: );
1350:
1351: INSERT INTO groups_product_defaults (
1352: group_id, product_id
1353: ) VALUES (
1354: 6, 13
1355: );
1356:
1357: INSERT INTO groups_product_defaults (
1358: group_id, product_id
1359: ) VALUES (
1360: 6, 15
1361: );
1362:
1363: INSERT INTO groups_product_defaults (
1364: group_id, product_id
1365: ) VALUES (
1366: 6, 17
1367: );
1368:
1369: INSERT INTO groups_product_defaults (
1370: group_id, product_id
1371: ) VALUES (
1372: 6, 19
1373: );
1374:
1375: INSERT INTO groups_product_defaults (
1376: group_id, product_id
1377: ) VALUES (
1378: 6, 23
1379: );
1380:
1381: INSERT INTO groups_product_defaults (
1382: group_id, product_id
1383: ) VALUES (
1384: 6, 35
1385: );
1386:
1387: INSERT INTO groups_product_defaults (
1388: group_id, product_id
1389: ) VALUES (
1390: 6, 61
1391: );
1392:
1393: INSERT INTO groups_product_defaults (
1394: group_id, product_id
1395: ) VALUES (
1396: 6, 70
1397: );
1398:
1399: INSERT INTO groups_product_defaults (
1400: group_id, product_id
1401: ) VALUES (
1402: 6, 72
1403: );
1404:
1405: INSERT INTO groups_product_defaults (
1406: group_id, product_id
1407: ) VALUES (
1408: 6, 74
1409: );
1410:
1411: INSERT INTO groups_product_defaults (
1412: group_id, product_id
1413: ) VALUES (
1414: 7, 8
1415: );
1416:
1417: INSERT INTO groups_product_defaults (
1418: group_id, product_id
1419: ) VALUES (
1420: 7, 10
1421: );
1422:
1423: INSERT INTO groups_product_defaults (
1424: group_id, product_id
1425: ) VALUES (
1426: 7, 12
1427: );
1428:
1429: INSERT INTO groups_product_defaults (
1430: group_id, product_id
1431: ) VALUES (
1432: 7, 14
1433: );
1434:
1435: INSERT INTO groups_product_defaults (
1436: group_id, product_id
1437: ) VALUES (
1438: 7, 16
1439: );
1440:
1441: INSERT INTO groups_product_defaults (
1442: group_id, product_id
1443: ) VALUES (
1444: 7, 18
1445: );
1446:
1447: INSERT INTO groups_product_defaults (
1448: group_id, product_id
1449: ) VALUES (
1450: 7, 20
1451: );
1452:
1453: INSERT INTO groups_product_defaults (
1454: group_id, product_id
1455: ) VALUES (
1456: 7, 24
1457: );
1458:
1459: INSERT INTO groups_product_defaults (
1460: group_id, product_id
1461: ) VALUES (
1462: 7, 36
1463: );
1464:
1465: INSERT INTO groups_product_defaults (
1466: group_id, product_id
1467: ) VALUES (
1468: 7, 62
1469: );
1470:
1471: INSERT INTO groups_product_defaults (
1472: group_id, product_id
1473: ) VALUES (
1474: 7, 71
1475: );
1476:
1477: INSERT INTO groups_product_defaults (
1478: group_id, product_id
1479: ) VALUES (
1480: 7, 73
1481: );
1482:
1483: INSERT INTO groups_product_defaults (
1484: group_id, product_id
1485: ) VALUES (
1486: 7, 75
1487: );
1488:
1489: INSERT INTO groups_product_defaults (
1490: group_id, product_id
1491: ) VALUES (
1492: 7, 96
1493: );
1494:
1495: INSERT INTO groups_product_defaults (
1496: group_id, product_id
1497: ) VALUES (
1498: 3, 21
1499: );
1500:
1501: INSERT INTO groups_product_defaults (
1502: group_id, product_id
1503: ) VALUES (
1504: 3, 22
1505: );
1506:
1507: INSERT INTO groups_product_defaults (
1508: group_id, product_id
1509: ) VALUES (
1510: 3, 29
1511: );
1512:
1513: INSERT INTO groups_product_defaults (
1514: group_id, product_id
1515: ) VALUES (
1516: 3, 30
1517: );
1518:
1519: INSERT INTO groups_product_defaults (
1520: group_id, product_id
1521: ) VALUES (
1522: 3, 31
1523: );
1524:
1525: INSERT INTO groups_product_defaults (
1526: group_id, product_id
1527: ) VALUES (
1528: 3, 32
1529: );
1530:
1531: INSERT INTO groups_product_defaults (
1532: group_id, product_id
1533: ) VALUES (
1534: 3, 33
1535: );
1536:
1537: INSERT INTO groups_product_defaults (
1538: group_id, product_id
1539: ) VALUES (
1540: 3, 34
1541: );
1542:
1543: INSERT INTO groups_product_defaults (
1544: group_id, product_id
1545: ) VALUES (
1546: 3, 49
1547: );
1548:
1549: INSERT INTO groups_product_defaults (
1550: group_id, product_id
1551: ) VALUES (
1552: 3, 50
1553: );
1554:
1555: INSERT INTO groups_product_defaults (
1556: group_id, product_id
1557: ) VALUES (
1558: 3, 51
1559: );
1560:
1561: INSERT INTO groups_product_defaults (
1562: group_id, product_id
1563: ) VALUES (
1564: 3, 63
1565: );
1566:
1567: INSERT INTO groups_product_defaults (
1568: group_id, product_id
1569: ) VALUES (
1570: 3, 64
1571: );
1572:
1573: INSERT INTO groups_product_defaults (
1574: group_id, product_id
1575: ) VALUES (
1576: 3, 80
1577: );
1578:
1579: INSERT INTO groups_product_defaults (
1580: group_id, product_id
1581: ) VALUES (
1582: 3, 81
1583: );
1584:
1585: INSERT INTO groups_product_defaults (
1586: group_id, product_id
1587: ) VALUES (
1588: 14, 43
1589: );
1590:
1591: INSERT INTO groups_product_defaults (
1592: group_id, product_id
1593: ) VALUES (
1594: 14, 44
1595: );
1596:
1597: INSERT INTO groups_product_defaults (
1598: group_id, product_id
1599: ) VALUES (
1600: 14, 45
1601: );
1602:
1603: INSERT INTO groups_product_defaults (
1604: group_id, product_id
1605: ) VALUES (
1606: 14, 46
1607: );
1608:
1609: INSERT INTO groups_product_defaults (
1610: group_id, product_id
1611: ) VALUES (
1612: 14, 47
1613: );
1614:
1615: INSERT INTO groups_product_defaults (
1616: group_id, product_id
1617: ) VALUES (
1618: 14, 48
1619: );
1620:
1621: INSERT INTO groups_product_defaults (
1622: group_id, product_id
1623: ) VALUES (
1624: 14, 54
1625: );
1626:
1627: INSERT INTO groups_product_defaults (
1628: group_id, product_id
1629: ) VALUES (
1630: 14, 57
1631: );
1632:
1633: INSERT INTO groups_product_defaults (
1634: group_id, product_id
1635: ) VALUES (
1636: 14, 60
1637: );
1638:
1639: INSERT INTO groups_product_defaults (
1640: group_id, product_id
1641: ) VALUES (
1642: 14, 68
1643: );
1644:
1645: INSERT INTO groups_product_defaults (
1646: group_id, product_id
1647: ) VALUES (
1648: 14, 78
1649: );
1650:
1651: INSERT INTO groups_product_defaults (
1652: group_id, product_id
1653: ) VALUES (
1654: 15, 65
1655: );
1656:
1657: INSERT INTO groups_product_defaults (
1658: group_id, product_id
1659: ) VALUES (
1660: 15, 69
1661: );
1662:
1663: INSERT INTO groups_product_defaults (
1664: group_id, product_id
1665: ) VALUES (
1666: 15, 79
1667: );
1668:
1669: /* Policies */
1670:
1671: INSERT INTO policies ( /* 1 */
1672: type, name, rec_fail, rec_noresult
1673: ) VALUES (
1674: 1, 'Installed Packages', 2, 2
1675: );
1676:
1677: INSERT INTO policies ( /* 2 */
1678: type, name, rec_fail, rec_noresult
1679: ) VALUES (
1680: 2, 'Unknown Source', 2, 2
1681: );
1682:
1683: INSERT INTO policies ( /* 3 */
1684: type, name, rec_fail, rec_noresult
1685: ) VALUES (
1686: 3, 'IP Forwarding Enabled', 1, 1
1687: );
1688:
1689: INSERT INTO policies ( /* 4 */
1690: type, name, rec_fail, rec_noresult
1691: ) VALUES (
1692: 4, 'Default Factory Password Enabled', 1, 1
1693: );
1694:
1695: INSERT INTO policies ( /* 5 */
1696: type, name, file, rec_fail, rec_noresult
1697: ) VALUES (
1698: 6, 'Measure /lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 1, 2, 2
1699: );
1700:
1701: INSERT INTO policies ( /* 6 */
1702: type, name, file, rec_fail, rec_noresult
1703: ) VALUES (
1704: 6, 'Measure /lib/x86_64-linux-gnu/libssl.so.1.0.0', 3, 2, 2
1705: );
1706:
1707: INSERT INTO policies ( /* 7 */
1708: type, name, file, rec_fail, rec_noresult
1709: ) VALUES (
1710: 6, 'Measure /usr/bin/openssl', 5, 2, 2
1711: );
1712:
1713: INSERT INTO policies ( /* 8 */
1714: type, name, rec_fail, rec_noresult
1715: ) VALUES (
1716: 11, 'No Open TCP Ports', 1, 1
1717: );
1718:
1719: INSERT INTO policies ( /* 9 */
1720: type, name, argument, rec_fail, rec_noresult
1721: ) VALUES (
1722: 13, 'Open UDP Ports', '500 4500 10000-65000', 1, 1
1723: );
1724:
1725: INSERT INTO policies ( /* 10 */
1726: type, name, file, rec_fail, rec_noresult
1727: ) VALUES (
1728: 7, 'Metadata of /etc/tnc_config', 6, 0, 0
1729: );
1730:
1731: INSERT INTO policies ( /* 11 */
1732: type, name, dir, rec_fail, rec_noresult
1733: ) VALUES (
1734: 8, 'Get /bin', 1, 0, 0
1735: );
1736:
1737: INSERT INTO policies ( /* 12 */
1738: type, name, file, rec_fail, rec_noresult
1739: ) VALUES (
1740: 6, 'Measure /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1', 2, 2, 2
1741: );
1742:
1743: INSERT INTO policies ( /* 13 */
1744: type, name, file, rec_fail, rec_noresult
1745: ) VALUES (
1746: 6, 'Measure /usr/lib/x86_64-linux-gnu/libssl.so.1.1', 4, 2, 2
1747: );
1748:
1749: INSERT INTO policies ( /* 14 */
1750: type, name, dir, rec_fail, rec_noresult
1751: ) VALUES (
1752: 8, 'Get /system/bin', 13, 0, 0
1753: );
1754:
1755: INSERT INTO policies ( /* 15 */
1756: type, name, dir, rec_fail, rec_noresult
1757: ) VALUES (
1758: 8, 'Get /system/lib', 14, 0, 0
1759: );
1760:
1761: INSERT INTO policies ( /* 16 */
1762: type, name, dir, rec_fail, rec_noresult
1763: ) VALUES (
1764: 9, 'Measure /bin', 1, 2, 2
1765: );
1766:
1767: INSERT INTO policies ( /* 17 */
1768: type, name, argument, rec_fail, rec_noresult
1769: ) VALUES (
1770: 15, 'SWID Tag IDs', 'R', 2, 2
1771: );
1772:
1773: INSERT INTO policies ( /* 18 */
1774: type, name, argument, rec_fail, rec_noresult
1775: ) VALUES (
1776: 15, 'SWID Tags', '', 2, 2
1777: );
1778:
1779: INSERT INTO policies ( /* 19 */
1780: type, name, argument, rec_fail, rec_noresult
1781: ) VALUES (
1782: 16, 'TPM BIOS Measurements', 'B', 2, 2
1783: );
1784:
1785: INSERT INTO policies ( /* 20 */
1786: type, name, argument, rec_fail, rec_noresult
1787: ) VALUES (
1788: 16, 'TPM IMA Measurements', 'I', 2, 2
1789: );
1790:
1791: INSERT INTO policies ( /* 21 */
1792: type, name, argument, rec_fail, rec_noresult
1793: ) VALUES (
1794: 16, 'TPM BIOS/IMA Measurements', 'BI', 2, 2
1795: );
1796:
1797: INSERT INTO policies ( /* 22 */
1798: type, name, argument, rec_fail, rec_noresult
1799: ) VALUES (
1800: 16, 'TPM TBOOT Measurements', 'T', 2, 2
1801: );
1802:
1803: /* Enforcements */
1804:
1805: INSERT INTO enforcements ( /* 1 */
1806: policy, group_id, max_age
1807: ) VALUES (
1808: 1, 1, 86400
1809: );
1810:
1811: INSERT INTO enforcements ( /* 2 */
1812: policy, group_id, max_age
1813: ) VALUES (
1814: 2, 3, 0
1815: );
1816:
1817: INSERT INTO enforcements ( /* 3 */
1818: policy, group_id, max_age
1819: ) VALUES (
1820: 3, 2, 0
1821: );
1822:
1823: INSERT INTO enforcements ( /* 4 */
1824: policy, group_id, max_age
1825: ) VALUES (
1826: 5, 7, 86400
1827: );
1828:
1829: INSERT INTO enforcements ( /* 5 */
1830: policy, group_id, max_age
1831: ) VALUES (
1832: 6, 7, 86400
1833: );
1834:
1835: INSERT INTO enforcements ( /* 6 */
1836: policy, group_id, max_age
1837: ) VALUES (
1838: 7, 2, 86400
1839: );
1840:
1841: INSERT INTO enforcements ( /* 7 */
1842: policy, group_id, max_age
1843: ) VALUES (
1844: 8, 1, 60
1845: );
1846:
1847: INSERT INTO enforcements ( /* 8 */
1848: policy, group_id, max_age
1849: ) VALUES (
1850: 9, 1, 60
1851: );
1852:
1853: INSERT INTO enforcements ( /* 9 */
1854: policy, group_id, max_age
1855: ) VALUES (
1856: 10, 2, 60
1857: );
1858:
1859: INSERT INTO enforcements ( /* 10 */
1860: policy, group_id, max_age
1861: ) VALUES (
1862: 11, 10, 86400
1863: );
1864:
1865: INSERT INTO enforcements ( /* 11 */
1866: policy, group_id, max_age
1867: ) VALUES (
1868: 12, 5, 86400
1869: );
1870:
1871: INSERT INTO enforcements ( /* 12 */
1872: policy, group_id, max_age
1873: ) VALUES (
1874: 13, 5, 86400
1875: );
1876:
1877: INSERT INTO enforcements ( /* 13 */
1878: policy, group_id, max_age
1879: ) VALUES (
1880: 14, 9, 0
1881: );
1882:
1883: INSERT INTO enforcements ( /* 14 */
1884: policy, group_id, max_age
1885: ) VALUES (
1886: 15, 9, 0
1887: );
1888:
1889: INSERT INTO enforcements ( /* 15 */
1890: policy, group_id, max_age
1891: ) VALUES (
1892: 19, 11, 60
1893: );
1894:
1895: INSERT INTO enforcements ( /* 16 */
1896: policy, group_id, max_age
1897: ) VALUES (
1898: 20, 12, 60
1899: );
1900:
1901: INSERT INTO enforcements ( /* 17 */
1902: policy, group_id, max_age
1903: ) VALUES (
1904: 21, 13, 60
1905: );
1906:
1907: INSERT INTO enforcements ( /* 18 */
1908: policy, group_id, max_age
1909: ) VALUES (
1910: 22, 16, 60
1911: );
1912:
1913: /* swid_entities */
1914:
1915: INSERT INTO "swid_entities" ( /* 1 */
1916: "name", "regid"
1917: ) VALUES (
1918: 'strongSwan Project', 'strongswan.org'
1919: );
1920:
1921: INSERT INTO swid_entities ( /* 2 */
1922: "name", "regid"
1923: ) VALUES (
1924: 'Adobe Systems Inc.', 'adobe.com'
1925: );
1926:
1927: INSERT INTO swid_entities ( /* 3 */
1928: "name", "regid"
1929: ) VALUES (
1930: 'Microsoft Corporation', 'microsoft.com'
1931: );
1932:
1933: INSERT INTO swid_entities ( /* 4 */
1934: "name", "regid"
1935: ) VALUES (
1936: 'Ubuntu Project', 'ubuntu.com'
1937: );
1938:
1939: INSERT INTO swid_entities ( /* 5 */
1940: "name", "regid"
1941: ) VALUES (
1942: 'Apache Software Foundation', 'apache.org'
1943: );
1944:
1945: INSERT INTO swid_entities ( /* 6 */
1946: "name", "regid"
1947: ) VALUES (
1948: 'Debian Project', 'debian.org'
1949: );
1950:
1951: INSERT INTO swid_entities ( /* 7 */
1952: "name", "regid"
1953: ) VALUES (
1954: 'Internet Systems Consortium', 'isc.org'
1955: );
1956:
1957: INSERT INTO swid_entities ( /* 8 */
1958: "name", "regid"
1959: ) VALUES (
1960: 'OpenSSL Project', 'openssl.org'
1961: );
1962:
1963: INSERT INTO swid_entities ( /* 9 */
1964: "name", "regid"
1965: ) VALUES (
1966: 'Samba Project', 'samba.org'
1967: );
1968:
1969: INSERT INTO swid_entities ( /* 10 */
1970: "name", "regid"
1971: ) VALUES (
1972: 'SQLite Project', 'sqlite.org'
1973: );