e52fa14119943ade98153acaa84efccb5b10c271
[strongswan.git] / src / libimcv / imv / data.sql
1 /* Products */
2
3 INSERT INTO products ( /* 1 */
4 name
5 ) VALUES (
6 'Debian 7.0'
7 );
8
9 INSERT INTO products ( /* 2 */
10 name
11 ) VALUES (
12 'Debian 7.0 i686'
13 );
14
15 INSERT INTO products ( /* 3 */
16 name
17 ) VALUES (
18 'Debian 7.0 x86_64'
19 );
20
21 INSERT INTO products ( /* 4 */
22 name
23 ) VALUES (
24 'Ubuntu 10.04'
25 );
26
27 INSERT INTO products ( /* 5 */
28 name
29 ) VALUES (
30 'Ubuntu 10.04 i686'
31 );
32
33 INSERT INTO products ( /* 6 */
34 name
35 ) VALUES (
36 'Ubuntu 10.04 x86_64'
37 );
38
39 INSERT INTO products ( /* 7 */
40 name
41 ) VALUES (
42 'Ubuntu 10.10'
43 );
44
45 INSERT INTO products ( /* 8 */
46 name
47 ) VALUES (
48 'Ubuntu 10.10 i686'
49 );
50
51 INSERT INTO products ( /* 9 */
52 name
53 ) VALUES (
54 'Ubuntu 10.10 x86_64'
55 );
56
57 INSERT INTO products ( /* 10 */
58 name
59 ) VALUES (
60 'Ubuntu 11.04'
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'
79 );
80
81 INSERT INTO products ( /* 14 */
82 name
83 ) VALUES (
84 'Ubuntu 11.10 i686'
85 );
86
87 INSERT INTO products ( /* 15 */
88 name
89 ) VALUES (
90 'Ubuntu 11.10 x86_64'
91 );
92
93 INSERT INTO products ( /* 16 */
94 name
95 ) VALUES (
96 'Ubuntu 12.04'
97 );
98
99 INSERT INTO products ( /* 17 */
100 name
101 ) VALUES (
102 'Ubuntu 12.04 i686'
103 );
104
105 INSERT INTO products ( /* 18 */
106 name
107 ) VALUES (
108 'Ubuntu 12.04 x86_64'
109 );
110
111 INSERT INTO products ( /* 19 */
112 name
113 ) VALUES (
114 'Ubuntu 12.10'
115 );
116
117 INSERT INTO products ( /* 20 */
118 name
119 ) VALUES (
120 'Ubuntu 12.10 i686'
121 );
122
123 INSERT INTO products ( /* 21 */
124 name
125 ) VALUES (
126 'Ubuntu 12.10 x86_64'
127 );
128
129 INSERT INTO products ( /* 22 */
130 name
131 ) VALUES (
132 'Ubuntu 13.04'
133 );
134
135 INSERT INTO products ( /* 23 */
136 name
137 ) VALUES (
138 'Ubuntu 13.04 i686'
139 );
140
141 INSERT INTO products ( /* 24 */
142 name
143 ) VALUES (
144 'Ubuntu 13.04 x86_64'
145 );
146
147 INSERT INTO products ( /* 25 */
148 name
149 ) VALUES (
150 'Android 4.1.1'
151 );
152
153 INSERT INTO products ( /* 26 */
154 name
155 ) VALUES (
156 'Android 4.2.1'
157 );
158
159 /* Directories */
160
161 INSERT INTO directories ( /* 1 */
162 path
163 ) VALUES (
164 '/bin'
165 );
166
167 INSERT INTO directories ( /* 2 */
168 path
169 ) VALUES (
170 '/etc'
171 );
172
173 INSERT INTO directories ( /* 3 */
174 path
175 ) VALUES (
176 '/lib'
177 );
178
179 INSERT INTO directories ( /* 4 */
180 path
181 ) VALUES (
182 '/lib/i386-linux-gnu'
183 );
184
185 INSERT INTO directories ( /* 5 */
186 path
187 ) VALUES (
188 '/lib/x86_64-linux-gnu'
189 );
190
191 INSERT INTO directories ( /* 6 */
192 path
193 ) VALUES (
194 '/lib/xtables'
195 );
196
197 INSERT INTO directories ( /* 7 */
198 path
199 ) VALUES (
200 '/sbin'
201 );
202
203 INSERT INTO directories ( /* 8 */
204 path
205 ) VALUES (
206 '/usr/bin'
207 );
208
209 INSERT INTO directories ( /* 9 */
210 path
211 ) VALUES (
212 '/usr/lib'
213 );
214
215 INSERT INTO directories ( /* 10 */
216 path
217 ) VALUES (
218 '/usr/lib/i386-linux-gnu'
219 );
220
221 INSERT INTO directories ( /* 11 */
222 path
223 ) VALUES (
224 '/usr/lib/x86_64-linux-gnu'
225 );
226
227 INSERT INTO directories ( /* 12 */
228 path
229 ) VALUES (
230 '/usr/sbin'
231 );
232
233 /* Files */
234
235 INSERT INTO files ( /* 1 */
236 name, dir
237 ) VALUES (
238 'libcrypto.so.1.0.0', 5
239 );
240
241 INSERT INTO files ( /* 2 */
242 name, dir
243 ) VALUES (
244 'libcrypto.so.1.0.0', 11
245 );
246
247 INSERT INTO files ( /* 3 */
248 name, dir
249 ) VALUES (
250 'libssl.so.1.0.0', 5
251 );
252
253 INSERT INTO files ( /* 4 */
254 name, dir
255 ) VALUES (
256 'libssl.so.1.0.0', 11
257 );
258
259 INSERT INTO files ( /* 5 */
260 name, dir
261 ) VALUES (
262 'openssl', 8
263 );
264
265 INSERT INTO files ( /* 6 */
266 name, dir
267 ) VALUES (
268 'tnc_config', 2
269 );
270
271 /* Algorithms */
272
273 INSERT INTO algorithms (
274 id, name
275 ) VALUES (
276 65536, 'SHA1-IMA'
277 );
278
279 INSERT INTO algorithms (
280 id, name
281 ) VALUES (
282 32768, 'SHA1'
283 );
284
285 INSERT INTO algorithms (
286 id, name
287 ) VALUES (
288 16384, 'SHA256'
289 );
290
291 INSERT INTO algorithms (
292 id, name
293 ) VALUES (
294 8192, 'SHA384'
295 );
296
297 /* File Hashes */
298
299 INSERT INTO file_hashes (
300 product, file, algo, hash
301 ) VALUES (
302 3, 2, 32768, X'6c6f8e12f6cbfba612e780374c4cdcd40f20968a'
303 );
304
305 INSERT INTO file_hashes (
306 product, file, algo, hash
307 ) VALUES (
308 3, 2, 16384, X'dbcecd19d59310183cf5c31ddee29e8d7bec64d3f9583aad074330a1b3024b07'
309 );
310
311 INSERT INTO file_hashes (
312 product, file, algo, hash
313 ) VALUES (
314 3, 2, 8192, X'197c5385e5853003188833d4f991136c1b0875fa416a60b1159f64e57e457b3184762c884a802a2bda194c058e3bd953'
315 );
316
317 INSERT INTO file_hashes (
318 product, file, algo, hash
319 ) VALUES (
320 3, 4, 32768, X'3ad204f99eb7262efab79cfca02628870ea76361'
321 );
322
323 INSERT INTO file_hashes (
324 product, file, algo, hash
325 ) VALUES (
326 3, 4, 16384, X'3a2170aad92fdd58b55e0e199822bc873cf587b2d1eb1ed7ed8dcea97ae86376'
327 );
328
329 INSERT INTO file_hashes (
330 product, file, algo, hash
331 ) VALUES (
332 3, 4, 8192, X'f778076baa876b5e4b502494a3db081fb09dd870dee6991d54104a74b7e009c58fe261db5ffd13c11e08ef0cefcfa59f'
333 );
334
335 INSERT INTO file_hashes (
336 product, file, algo, hash
337 ) VALUES (
338 3, 5, 32768, X'ecd9c7076cc0572724c7a67db7f19c2831e0445f'
339 );
340
341 INSERT INTO file_hashes (
342 product, file, algo, hash
343 ) VALUES (
344 3, 5, 16384, X'28f3ea5afd34444c8232ea75003131e294a0c9b847de300e4b205d38c1a41305'
345 );
346
347 INSERT INTO file_hashes (
348 product, file, algo, hash
349 ) VALUES (
350 3, 5, 8192, X'51921a8b9322f2d3f06d55002ff40a79da67e70cb563b2a50977642d603dfac2ccbb68b3d32a8bb350769b75d6254208'
351 );
352
353 INSERT INTO file_hashes (
354 product, file, algo, hash
355 ) VALUES (
356 21, 1, 32768, X'd9309b9e45928239d7a7b18711e690792632cce4'
357 );
358
359 INSERT INTO file_hashes (
360 product, file, algo, hash
361 ) VALUES (
362 21, 1, 16384, X'dbfa1856d278d8707c4989b30dd065b4bcd309908f0f2e6e66ff2aa83ff93f59'
363 );
364
365 INSERT INTO file_hashes (
366 product, file, algo, hash
367 ) VALUES (
368 21, 1, 8192, X'fb8d027f03bb5ebb47741ed247eb9e174127b714d20229885feb37e0979aeb14a1b74020cded891d680441093625729c'
369 );
370
371 INSERT INTO file_hashes (
372 product, file, algo, hash
373 ) VALUES (
374 21, 3, 32768, X'3715f2f94016a91fab5bbc503f0f1d43c5a9fc2b'
375 );
376
377 INSERT INTO file_hashes (
378 product, file, algo, hash
379 ) VALUES (
380 21, 3, 16384, X'c03a5296b5decb87b01517f9927a8b2349dfb29ff9f5ba084f994c155ca5d4be'
381 );
382
383 INSERT INTO file_hashes (
384 product, file, algo, hash
385 ) VALUES (
386 21, 3, 8192, X'b8bc345f56115235cc6091f61e312ce43ea54a5b99e7295002ae7b415fd35e06ec4c731ab70ad00d784bb53a318a2fa0'
387 );
388
389 INSERT INTO file_hashes (
390 product, file, algo, hash
391 ) VALUES (
392 21, 5, 32768, X'e59602f4edf24c1b36199588886d06665d4adcd7'
393 );
394
395 INSERT INTO file_hashes (
396 product, file, algo, hash
397 ) VALUES (
398 21, 5, 16384, X'090e1b77bda7fe665e498c6b5e09dbb7ddc5cfe57f213de48f4fb6736484f500'
399 );
400
401 INSERT INTO file_hashes (
402 product, file, algo, hash
403 ) VALUES (
404 21, 5, 8192, X'7cbdb4612a13443dba910ecdef5161f2213e52c9b4a2eef14bcee5d287e9df931cd022e9e9715518ad9c9b6e3384a668'
405 );
406
407 /* Packages */
408
409 INSERT INTO packages ( /* 1 */
410 name
411 ) VALUES (
412 'libssl-dev'
413 );
414
415 INSERT INTO packages ( /* 2 */
416 name
417 ) VALUES (
418 'libssl1.0.0'
419 );
420
421 INSERT INTO packages ( /* 3 */
422 name
423 ) VALUES (
424 'libssl1.0.0-dbg'
425 );
426
427 INSERT INTO packages ( /* 4 */
428 name
429 ) VALUES (
430 'openssl'
431 );
432
433 /* Versions */
434
435 INSERT INTO versions (
436 package, product, release, time
437 ) VALUES (
438 1, 1, '1.0.1e-2', 1366531494
439 );
440
441 INSERT INTO versions (
442 package, product, release, time
443 ) VALUES (
444 2, 1, '1.0.1e-2', 1366531494
445 );
446
447 INSERT INTO versions (
448 package, product, release, time
449 ) VALUES (
450 3, 1, '1.0.1e-2', 1366531494
451 );
452
453 INSERT INTO versions (
454 package, product, release, time
455 ) VALUES (
456 4, 1, '1.0.1e-2', 1366531494
457 );
458
459 /* Groups */
460
461 INSERT INTO groups ( /* 1 */
462 name, parent
463 ) VALUES (
464 'Debian i686', 6
465 );
466
467 INSERT INTO groups ( /* 2 */
468 name, parent
469 ) VALUES (
470 'Debian x86_64', 6
471 );
472
473 INSERT INTO groups ( /* 3 */
474 name, parent
475 ) VALUES (
476 'Ubuntu i686', 6
477 );
478
479 INSERT INTO groups ( /* 4 */
480 name, parent
481 ) VALUES (
482 'Ubuntu x86_64', 6
483 );
484
485 INSERT INTO groups ( /* 5 */
486 name, parent
487 ) VALUES (
488 'Android', 7
489 );
490
491 INSERT INTO groups ( /* 6 */
492 name, parent
493 ) VALUES (
494 'Linux', 7
495 );
496
497 INSERT INTO groups ( /* 7 */
498 name
499 ) VALUES (
500 'Default'
501 );
502
503 /* Default Product Groups */
504
505 INSERT INTO groups_product_defaults (
506 group_id, product_id
507 ) VALUES (
508 1, 2
509 );
510
511 INSERT INTO groups_product_defaults (
512 group_id, product_id
513 ) VALUES (
514 2, 3
515 );
516
517 INSERT INTO groups_product_defaults (
518 group_id, product_id
519 ) VALUES (
520 3, 5
521 );
522
523 INSERT INTO groups_product_defaults (
524 group_id, product_id
525 ) VALUES (
526 3, 8
527 );
528
529 INSERT INTO groups_product_defaults (
530 group_id, product_id
531 ) VALUES (
532 3, 11
533 );
534
535 INSERT INTO groups_product_defaults (
536 group_id, product_id
537 ) VALUES (
538 3, 14
539 );
540
541 INSERT INTO groups_product_defaults (
542 group_id, product_id
543 ) VALUES (
544 3, 17
545 );
546
547 INSERT INTO groups_product_defaults (
548 group_id, product_id
549 ) VALUES (
550 3, 20
551 );
552
553 INSERT INTO groups_product_defaults (
554 group_id, product_id
555 ) VALUES (
556 3, 23
557 );
558
559 INSERT INTO groups_product_defaults (
560 group_id, product_id
561 ) VALUES (
562 4, 6
563 );
564
565 INSERT INTO groups_product_defaults (
566 group_id, product_id
567 ) VALUES (
568 4, 9
569 );
570
571 INSERT INTO groups_product_defaults (
572 group_id, product_id
573 ) VALUES (
574 4, 12
575 );
576
577 INSERT INTO groups_product_defaults (
578 group_id, product_id
579 ) VALUES (
580 4, 15
581 );
582
583 INSERT INTO groups_product_defaults (
584 group_id, product_id
585 ) VALUES (
586 4, 18
587 );
588
589 INSERT INTO groups_product_defaults (
590 group_id, product_id
591 ) VALUES (
592 4, 21
593 );
594
595 INSERT INTO groups_product_defaults (
596 group_id, product_id
597 ) VALUES (
598 4, 24
599 );
600
601 INSERT INTO groups_product_defaults (
602 group_id, product_id
603 ) VALUES (
604 5, 25
605 );
606
607 INSERT INTO groups_product_defaults (
608 group_id, product_id
609 ) VALUES (
610 5, 26
611 );
612
613 /* Policies */
614
615 INSERT INTO policies ( /* 1 */
616 type, name, rec_fail, rec_noresult
617 ) VALUES (
618 1, 'Installed Packages', 2, 2
619 );
620
621 INSERT INTO policies ( /* 2 */
622 type, name, rec_fail, rec_noresult
623 ) VALUES (
624 2, 'Unknown Source', 2, 2
625 );
626
627 INSERT INTO policies ( /* 3 */
628 type, name, rec_fail, rec_noresult
629 ) VALUES (
630 3, 'IP Forwarding Enabled', 1, 1
631 );
632
633 INSERT INTO policies ( /* 4 */
634 type, name, rec_fail, rec_noresult
635 ) VALUES (
636 4, 'Default Factory Password Enabled', 1, 1
637 );
638
639 INSERT INTO policies ( /* 5 */
640 type, name, file, rec_fail, rec_noresult
641 ) VALUES (
642 6, 'Measure /lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 1, 2, 2
643 );
644
645 INSERT INTO policies ( /* 6 */
646 type, name, file, rec_fail, rec_noresult
647 ) VALUES (
648 6, 'Measure /lib/x86_64-linux-gnu/libssl.so.1.0.0', 3, 2, 2
649 );
650
651 INSERT INTO policies ( /* 7 */
652 type, name, file, rec_fail, rec_noresult
653 ) VALUES (
654 6, 'Measure /usr/bin/openssl', 5, 2, 2
655 );
656
657 INSERT INTO policies ( /* 8 */
658 type, name, rec_fail, rec_noresult
659 ) VALUES (
660 11, 'No Open TCP Ports', 1, 1
661 );
662
663 INSERT INTO policies ( /* 9 */
664 type, name, rec_fail, rec_noresult
665 ) VALUES (
666 12, 'No Open UDP Ports', 1, 1
667 );
668
669 INSERT INTO policies ( /* 10 */
670 type, name, file, rec_fail, rec_noresult
671 ) VALUES (
672 7, 'Metadata of /etc/tnc_config', 6, 0, 0
673 );
674
675 INSERT INTO policies ( /* 11 */
676 type, name, dir, rec_fail, rec_noresult
677 ) VALUES (
678 8, 'Measure as reference /bin', 1, 0, 0
679 );
680
681 INSERT INTO policies ( /* 12 */
682 type, name, file, rec_fail, rec_noresult
683 ) VALUES (
684 6, 'Measure /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 2, 2, 2
685 );
686
687 INSERT INTO policies ( /* 13 */
688 type, name, file, rec_fail, rec_noresult
689 ) VALUES (
690 6, 'Measure /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0', 4, 2, 2
691 );
692
693
694 /* Enforcements */
695
696 INSERT INTO enforcements (
697 policy, group_id, max_age
698 ) VALUES (
699 1, 7, 86400
700 );
701
702 INSERT INTO enforcements (
703 policy, group_id, max_age
704 ) VALUES (
705 2, 5, 0
706 );
707
708 INSERT INTO enforcements (
709 policy, group_id, max_age
710 ) VALUES (
711 3, 6, 0
712 );
713
714 INSERT INTO enforcements (
715 policy, group_id, max_age
716 ) VALUES (
717 5, 4, 86400
718 );
719
720 INSERT INTO enforcements (
721 policy, group_id, max_age
722 ) VALUES (
723 6, 4, 86400
724 );
725
726 INSERT INTO enforcements (
727 policy, group_id, max_age
728 ) VALUES (
729 7, 6, 86400
730 );
731
732 INSERT INTO enforcements (
733 policy, group_id, max_age
734 ) VALUES (
735 8, 7, 60
736 );
737
738 INSERT INTO enforcements (
739 policy, group_id, max_age
740 ) VALUES (
741 9, 7, 60
742 );
743
744 INSERT INTO enforcements (
745 policy, group_id, max_age
746 ) VALUES (
747 10, 6, 60
748 );
749
750 INSERT INTO enforcements (
751 policy, group_id, max_age
752 ) VALUES (
753 11, 6, 86400
754 );
755
756 INSERT INTO enforcements (
757 policy, group_id, max_age
758 ) VALUES (
759 12, 2, 86400
760 );
761
762 INSERT INTO enforcements (
763 policy, group_id, max_age
764 ) VALUES (
765 13, 2, 86400
766 );
767