diff options
Diffstat (limited to 'src/libpts/plugins/imv_attestation/data.sql')
| -rw-r--r-- | src/libpts/plugins/imv_attestation/data.sql | 1305 |
1 files changed, 1305 insertions, 0 deletions
diff --git a/src/libpts/plugins/imv_attestation/data.sql b/src/libpts/plugins/imv_attestation/data.sql new file mode 100644 index 000000000..e6e03627a --- /dev/null +++ b/src/libpts/plugins/imv_attestation/data.sql @@ -0,0 +1,1305 @@ +/* Products */ + +INSERT INTO products ( + name +) VALUES ( + 'Ubuntu 11.04 i686' +); + +INSERT INTO products ( + name +) VALUES ( + 'Ubuntu 11.04 x86_64' +); + +INSERT INTO products ( + name +) VALUES ( + 'CentOS release 5.6 (Final) x86_64' +); + +INSERT INTO products ( + name +) VALUES ( + 'Ubuntu 10.10 x86_64' +); + +INSERT INTO products ( + name +) VALUES ( + 'Ubuntu 10.10 i686' +); + +INSERT INTO products ( + name +) VALUES ( + 'Gentoo Base System release 1.12.11.1 i686' +); + +INSERT INTO products ( + name +) VALUES ( + 'Ubuntu 11.10 i686' +); + +/* Files */ + +INSERT INTO files ( /* 1 */ + type, path +) VALUES ( + 0, '/lib/i386-linux-gnu/libdl.so.2' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, '/lib/x86_64-linux-gnu/libdl.so.2' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, '/lib/libdl.so.2' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, '/sbin/iptables' +); + +INSERT INTO files ( /* 5 */ + type, path +) VALUES ( + 0, '/lib/libxtables.so.5' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, '/lib/libxtables.so.2' +); + +INSERT INTO files ( + type, path +) VALUES ( + 1, '/lib/xtables/' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libxt_udp.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libxt_tcp.so' +); + +INSERT INTO files ( /* 10 */ + type, path +) VALUES ( + 0, 'libxt_esp.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libxt_policy.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libxt_conntrack.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libipt_SNAT.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libipt_DNAT.so' +); + +INSERT INTO files ( /* 15 */ + type, path +) VALUES ( + 0, 'libipt_MASQUERADE.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libipt_LOG.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, '/sbin/ip6tables' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libip6t_LOG.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, 'libxt_mark.so' +); + +INSERT INTO files ( /* 20 */ + type, path +) VALUES ( + 0, 'libxt_MARK.so' +); + +INSERT INTO files ( + type, path +) VALUES ( + 1, '/lib/iptables' +); + +INSERT INTO files ( + type, path +) VALUES ( + 0, '/etc/tnc_config' +); + +/* Product-File */ + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 1, 1, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 1, 4, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 1, 5, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 1, 7, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 1, 17, 1 +); + +INSERT INTO product_file ( + product, file, metadata +) VALUES ( + 1, 22, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 2, 2, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 2, 4, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 2, 5, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 2, 7, 1 +); + +INSERT INTO product_file ( + product, file, metadata +) VALUES ( + 2, 22, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 3, 3, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 3, 4, 1 +); + +INSERT INTO product_file ( + product, file, metadata +) VALUES ( + 3, 22, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 4, 3, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 4, 4, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 4, 6, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 4, 7, 1 +); + +INSERT INTO product_file ( + product, file, metadata +) VALUES ( + 4, 22, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 5, 3, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 5, 4, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 5, 6, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 5, 7, 1 +); + +INSERT INTO product_file ( + product, file, metadata +) VALUES ( + 5, 22, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 6, 3, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 6, 4, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 6, 17, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 6, 21, 1 +); + +INSERT INTO product_file ( + product, file, metadata +) VALUES ( + 6, 22, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 7, 1, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 7, 4, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 7, 5, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 7, 7, 1 +); + +INSERT INTO product_file ( + product, file, measurement +) VALUES ( + 7, 17, 1 +); + +INSERT INTO product_file ( + product, file, metadata +) VALUES ( + 7, 22, 1 +); + +/* File Hashes */ + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 1, 1, 32768, X'409bb1a97e26ea1144cdd6801b8159f17f376b8f' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 1, 1, 16384, X'675172775cfd2b73ed1e249e4a730921f06c2f86fffdce4c71674cc654f37ed7' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 1, 1, 8192, X'abc8ce3fc99b6dcec6745ffc2f59e35372b9b126491480d04b0f93076beded06cccb27b61f1170868fada8cddefa7be4' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 1, 7, 32768, X'40763935cdea25119002c42f984b994d8d2a6d75' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 1, 7, 16384, X'27c4f867d3f994a361e0b25d7846b3698d29f82b38662f233a97cafc60c44189' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 1, 7, 8192, X'301dad8829308f5a68c603a87bf961b91365f0346ac2f322de3ddcbb4645f56c0e6d2dc503ec2abff8fe8e895ce9304d' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 2, 2, 32768, X'2a4047437e6fb346e2d854fc415e16b80e75bf6b' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 2, 2, 16384, X'86aa0bf93dade999277d963338402ed437271f3436f594a49ffca85b6c487523' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 2, 2, 8192, X'6090441219c0b478d294ae88e006d85ac0d94464573bcca7d180618a612bd170e3ee47c1545861b0f06fe0db85544c59' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 3, 32768, X'07d8c0218a5b3469b409dc95cf8f77a341a595fb' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 3, 16384, X'b083699fbc4c9f9e0d463361118904a3832670ad2fe3d6b42f811061188d509f' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 3, 8192, X'b14908de476467a11a7a98835d1cf8317c7b80a684692426ddd7b0014e00b70b3d1b4fc1dd02ad440447612ee9dadb52' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 4, 32768, X'4350f082511c742cc05050d18a23d1da9fb09340' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 4, 16384, X'f9e12408828b5842c45503342dc2af78bc74d701a19c5fd5483df0e203315e0a' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 4, 8192, X'1a5ea36e4ab0cda550c0da2af6a62d9310981d2f170c9e75bff1770be2efb9ddccc451743ff4c3d76876364f19fdf8c1' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 6, 32768, X'91f4bb52404ca26b3a797152076ca5d233b93c1d' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 6, 16384, X'59bced619eabbde5dd3ef74b92ba660349e105d36be9756c8d1598abd4bc066c' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 3, 6, 8192, X'fc6b1350067d23fca711b8a674e0367ad255bae0ddb2efe10dca1b18b18985bd09a7459937fda729d349874bb2701df3' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 1, 32768, X'ff6deca0eeb7a257205c5f0ab5f5d821ea184098' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 1, 16384, X'5c84fdf7c529d3c65a001587eda641fe489f83961a621fe514e7852a842690d6' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 1, 8192, X'8bd699f85f5b3efb27204b4699c518f871ef245d03b4bf8d1cc00456025017546030c2f493525754cffcd24cdbc03b21' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 2, 32768, X'1118805b490051637e93e592f4c71e0ee78a2422' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 2, 16384, X'5ea7229ebef5dc8f9fb2118676b773dd62cf89dc21657e3b8fbbcbc70ee24bd3' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 2, 8192, X'3b8da9e704e644eb7b196981624a2f6826c401d689e00ba47e42ff46351d27c6b9e91b1e8351ee01f66e5244b4c2a9b0' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 3, 32768, X'b5cd500ec15d6bfcae15e0af1dc121df7114b97d' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 3, 16384, X'b94f1cba12abb0ec79d207142526388ec0d127c4f2aad4a46a623a1f69bac84f' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 3, 8192, X'6663d66ff0e93b1b8a1edcdbe45d64834e29dc9c2b1d23126fd370a85b2c56da5cadcbc65b6e8afbb1e18bea8e413bd1' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 4, 32768, X'86c4463293859874243d8374f7f3ef60f44f9309' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 4, 16384, X'348b711f16ee9810738857c8ffbc54f8e16a393df8635cb29b02fc62daeefc14' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 4, 8192, X'0cb6b7d91148b1bb1b9333bc71de01509cb6d12c646a6756e6942647046286fbbca92b25dc1999e8f81be1264061ee4d' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 6, 32768, X'e3cf3ef2ee5df0117972808bfa93b7795f5da873' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 6, 16384, X'fde81f544e49c44aabe0e312a00a7f8af01a0e3123dc5c54c65e3e78ba475b22' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 6, 8192, X'e0cc89d1f229f9f35109bef3b163badc0941ca0a957d09e397a8d06e2b32e737f1f1135ebf0c0546d3d4c5354aaca40f' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 7, 32768, X'ff6deca0eeb7a257205c5f0ab5f5d821ea184098' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 7, 16384, X'5c84fdf7c529d3c65a001587eda641fe489f83961a621fe514e7852a842690d6' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 4, 7, 8192, X'8bd699f85f5b3efb27204b4699c518f871ef245d03b4bf8d1cc00456025017546030c2f493525754cffcd24cdbc03b21' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 1, 32768, X'7a3ca72158e60b0c91e48a420848f1b693aea26c' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 1, 16384, X'f9693c7d36c087d51f5012897fa0e8bb94081854d080c84f831f4d693d22f645' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 1, 8192, X'4ec135e54c8840ab575fcdf00c66f996f763863ad30800b0f0a0b02e7899697d6ab9ccfe185ccbc16c19f38d0a27becb' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 2, 32768, X'5d36a26856021d68a42f8bd7ca22365579d43891' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 2, 16384, X'411be0558ad0cef33b437dafeed40104917e2079646524145abf9d05ddc6c1c5' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 2, 8192, X'237f4691f9b780bec7aff217d64a9780ceed2973a41e86c92e0d6dab81cc5d13a9b99ba408302264f5665de1f42ef6e1' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 7, 32768, X'7a3ca72158e60b0c91e48a420848f1b693aea26c' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 7, 16384, X'f9693c7d36c087d51f5012897fa0e8bb94081854d080c84f831f4d693d22f645' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 5, 7, 8192, X'4ec135e54c8840ab575fcdf00c66f996f763863ad30800b0f0a0b02e7899697d6ab9ccfe185ccbc16c19f38d0a27becb' +); + + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 6, 4, 32768, X'92e66ae282947f66544682039a33fd1dbd402244' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 6, 4, 16384, X'dc6bad544f72c4538fb92f777646fd734b49ce95f41b2c96b74a21addbc86ed8' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 6, 4, 8192, X'08fd91f9017763212d1491f178e4d7e41d34a21b0117ee3321d832f5b8e02d4c7152a6cdc53bb4ca7e8aad5b1f279d1f' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 1, 32768, X'11ce3b45feb3e66a75490d42ba95071ac6f40a7f' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 1, 16384, X'468ef70f19372bc4a2b1805ffa3621515061fc19fa361374788bd362d638ac02' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 1, 8192, X'63076ae505ce52c37878c9b6891ac516320046403aec25bf347c7011c2d28d5db7e2946d1fae3006ab4ef43716ff4558' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 4, 32768, X'200eab67377bf3d5a25372838c38841658a718e4' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 4, 16384, X'31045af9a12efdc58155a177e9391dd28b93fa38af58ce00f49259cc26e97687' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 4, 8192, X'e8c64b508171d947069382da58dc7e39a97ce878a07f494a6fb370efb09116d32f1d4cdddeef85f22e14d1c5d5a37625' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 7, 32768, X'11ce3b45feb3e66a75490d42ba95071ac6f40a7f' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 7, 16384, X'468ef70f19372bc4a2b1805ffa3621515061fc19fa361374788bd362d638ac02' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 7, 7, 8192, X'63076ae505ce52c37878c9b6891ac516320046403aec25bf347c7011c2d28d5db7e2946d1fae3006ab4ef43716ff4558' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 21, 6, 32768, X'010873de0d682a26e1c6795dd4992248cc47cdd1' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 21, 6, 16384, X'bfb45524d81a3645bf216a6cf52cd5624aadf6717012bf722afce2db3e31f712' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 8, 21, 6, 8192, X'f69b3f60b904f2deb39ea1fb9b0132638f0aea27357e365297f6b2ec895d42b260143b5e912d00df1a4a1d75a1b508fa' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 1, 32768, X'1d740abd38f9f4bc81ca434a0e25b6e21704248b' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 1, 16384, X'e26bb7175956dc8747a81431e810f830413b6c63756bf5156ab51367fe4f48a0' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 1, 8192, X'5d3637413b9e318d0e0be6a9da86121062b99d1bdb084dfda4222baa71b250de644b4024281760b4eae926e03fac4fdb' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 4, 32768, X'd2bf3556a0b38cfba2962d058fa8ea777397e82d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 4, 16384, X'4ec845e828af69dcbde3ecb981096ac1e25c9e3e607e9a24b27da7e44527edf9' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 4, 8192, X'3204a34ca409730298f60361865dace24900827ee9f3bc87884d50827911b4b17beb4c09bad77e43f28938f10bc5138a' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 7, 32768, X'1d740abd38f9f4bc81ca434a0e25b6e21704248b' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 7, 16384, X'e26bb7175956dc8747a81431e810f830413b6c63756bf5156ab51367fe4f48a0' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 7, 7, 8192, X'5d3637413b9e318d0e0be6a9da86121062b99d1bdb084dfda4222baa71b250de644b4024281760b4eae926e03fac4fdb' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 21, 6, 32768, X'e1df4f3949b09c25e15b9c9b7088a60d683903a8' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 21, 6, 16384, X'46f0ec6b0a2c3a24157019ed60f03de2ec9160d07f12b7e0b3d3f02b609a151d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 9, 21, 6, 8192, X'4f73eae305e01e9ad57b5b1271a16bb8518fb82135aeb27311aa390d0d3a564b596adb723137f15bbf1db38b8dcbbdae' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 7, 1, 32768, X'339a58a1b313830c3cc74cb3fb52a5b8152f44e6' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 7, 1, 16384, X'789f2c6a9382bb342964a12947ddf84735d3e3ed3aefbae407098738cdf7c686' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 7, 1, 8192, X'858310a6e4b6311c491c4370990bfd6b9f03a49bb5ddf45b0d788f7043f130016e11be6bd95db66e49e2906a87adf8cb' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 7, 7, 32768, X'339a58a1b313830c3cc74cb3fb52a5b8152f44e6' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 7, 7, 16384, X'789f2c6a9382bb342964a12947ddf84735d3e3ed3aefbae407098738cdf7c686' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 7, 7, 8192, X'858310a6e4b6311c491c4370990bfd6b9f03a49bb5ddf45b0d788f7043f130016e11be6bd95db66e49e2906a87adf8cb' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 21, 6, 32768, X'87df2d01b85d8354819b431bae0a0a65bfc5d2db' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 21, 6, 16384, X'a25fef11c899d826ea61996f0bc05330bc88428eafb792be0182ad97b6283aae' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 10, 21, 6, 8192, X'357e5756dbfa22c21d3666521e644eefdf532b7d371cca62fc099579f3c98b97cb51d005dcbaf805f8a7def26dfde142' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 11, 7, 1, 32768, X'2d32ef93126abf8c660d57c67e5076c6394cabe8' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 11, 7, 1, 16384, X'ced29aca7fc2dd0b01d5d544dfb2e1640a6a79c657f589e7dd6636cfd63eda3b' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 11, 7, 1, 8192, X'a2d33fa2d0ee7bffa5e628f88ccb83cd61bb4c5fe6d2edb8b853b83d8c43f498fa6e8da70510f0a1a3ddb36060bbd4d8' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 11, 7, 7, 32768, X'2d32ef93126abf8c660d57c67e5076c6394cabe8' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 11, 7, 7, 16384, X'ced29aca7fc2dd0b01d5d544dfb2e1640a6a79c657f589e7dd6636cfd63eda3b' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 11, 7, 7, 8192, X'a2d33fa2d0ee7bffa5e628f88ccb83cd61bb4c5fe6d2edb8b853b83d8c43f498fa6e8da70510f0a1a3ddb36060bbd4d8' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 12, 7, 1, 32768, X'6c0b2df4fc4c9122b5762ae140d53fdd1cf9e89b' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 12, 7, 1, 16384, X'53c3f2bd5aaf8ef4c40f9af92a67621f5e67840b5ff2db67d1bccbcb56f7eef1' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 12, 7, 1, 8192, X'1a4a6d91bda3ce59e6c444ccc1e758c9c6f0e223fd8c5aac369260cdfa83081c0e8f3753f100490910ec161902f10ba7' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 12, 7, 7, 32768, X'6c0b2df4fc4c9122b5762ae140d53fdd1cf9e89b' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 12, 7, 7, 16384, X'53c3f2bd5aaf8ef4c40f9af92a67621f5e67840b5ff2db67d1bccbcb56f7eef1' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 12, 7, 7, 8192, X'1a4a6d91bda3ce59e6c444ccc1e758c9c6f0e223fd8c5aac369260cdfa83081c0e8f3753f100490910ec161902f10ba7' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 13, 7, 1, 32768, X'e2f7b92abda769f82796f57a29801870585dcea3' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 13, 7, 1, 16384, X'6d3fe67a040dbb469ef498b26cece45806cb7ca04787bba53b7ba1c18e2abd0a' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 13, 7, 1, 8192, X'014852b73cd3eabfa955b7bd56b269d5a0590a2770cf3d656b3d68dbad30884327fc81ff96c6f661c9c4189c3aefa346' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 13, 7, 7, 32768, X'e2f7b92abda769f82796f57a29801870585dcea3' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 13, 7, 7, 16384, X'6d3fe67a040dbb469ef498b26cece45806cb7ca04787bba53b7ba1c18e2abd0a' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 13, 7, 7, 8192, X'014852b73cd3eabfa955b7bd56b269d5a0590a2770cf3d656b3d68dbad30884327fc81ff96c6f661c9c4189c3aefa346' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 14, 7, 1, 32768, X'160d2b04d11eb225fb148615b699081869e15b6c' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 14, 7, 1, 16384, X'1f5a2ceae1418f9c1fbf51eb7d84f74d488908cde5931a5461746d1e24682a25' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 14, 7, 1, 8192, X'f701cb25b0e9a9f32d3bba9b274ca0e8838363d13b7283b842d6c9673442890e538127c3b64ca4b177de1d243b44cf0d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 14, 7, 7, 32768, X'160d2b04d11eb225fb148615b699081869e15b6c' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 14, 7, 7, 16384, X'1f5a2ceae1418f9c1fbf51eb7d84f74d488908cde5931a5461746d1e24682a25' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 14, 7, 7, 8192, X'f701cb25b0e9a9f32d3bba9b274ca0e8838363d13b7283b842d6c9673442890e538127c3b64ca4b177de1d243b44cf0d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 15, 7, 1, 32768, X'5a0d07ab036603a76759e5f61f7d04f2d3c056cc' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 15, 7, 1, 16384, X'85491714e860062c441ff50d93ad79350449596b89b2e409b513c2d883321c9d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 15, 7, 1, 8192, X'8038830a994c779bc200e844d8768280feca9dd5d58de6cd359b87cc68846799edfd16e36e83002da4bb309cfd3b353d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 15, 7, 7, 32768, X'5a0d07ab036603a76759e5f61f7d04f2d3c056cc' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 15, 7, 7, 16384, X'85491714e860062c441ff50d93ad79350449596b89b2e409b513c2d883321c9d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 15, 7, 7, 8192, X'8038830a994c779bc200e844d8768280feca9dd5d58de6cd359b87cc68846799edfd16e36e83002da4bb309cfd3b353d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 16, 7, 1, 32768, X'd6c8dfbaae7ab28b5cef2626a2af3f99a6ea4365' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 16, 7, 1, 16384, X'd0d6f784e937227cce99e3be860be078d0397a6fb5a5bc9d95a19ef855609dbc' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 16, 7, 1, 8192, X'4be6e7978a6e4fb8a792815f2bbe28c2e66276401fb98ca90e49a5c2f2c94a1c7aac635d501d35d1db0fd53a0cb9d0fa' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 16, 7, 7, 32768, X'd6c8dfbaae7ab28b5cef2626a2af3f99a6ea4365' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 16, 7, 7, 16384, X'd0d6f784e937227cce99e3be860be078d0397a6fb5a5bc9d95a19ef855609dbc' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 16, 7, 7, 8192, X'4be6e7978a6e4fb8a792815f2bbe28c2e66276401fb98ca90e49a5c2f2c94a1c7aac635d501d35d1db0fd53a0cb9d0fa' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 1, 32768, X'8a7c41167bc0fcc1dec8329a868ba265c23857f5' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 1, 16384, X'f8eb857d7bb850f44c15363ba699442c2810663ac5a83a5f49e06e0fd8144b0e' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 1, 8192, X'f40cb6e557ab18d70080e7995e3f96cc272842e822bf52bc1c59075313c2cd832f96cf03a8524905f3d3f7a61441c651' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 6, 32768, X'8178f18dcb836e7f7432c4ad568bfd66b7ef4a96' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 6, 16384, X'2d6aaed577bfac626ff4958ee1076bc343f8db46538aa6c381521bac94c5ca9e' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 6, 8192, X'747bbaee322f9bf1849308f8907e2a43868eae8559a7be718113abb4ce535f6d509d005e51788cf3e83e148487fe7bf3' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 7, 32768, X'8a7c41167bc0fcc1dec8329a868ba265c23857f5' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 7, 16384, X'f8eb857d7bb850f44c15363ba699442c2810663ac5a83a5f49e06e0fd8144b0e' +); + +INSERT INTO file_hashes ( + file, product, algo, hash +) VALUES ( + 17, 7, 8192, X'f40cb6e557ab18d70080e7995e3f96cc272842e822bf52bc1c59075313c2cd832f96cf03a8524905f3d3f7a61441c651' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 18, 7, 1, 32768, X'23296f48276e160b6d99b1b42a9114df720bb1ab' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 18, 7, 1, 16384, X'78cd0a598080e31453f477e8d8a12ec794e859f4076ed92e53d2053d6d16762c' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 18, 7, 1, 8192, X'4da3955f1fd968ecf95cff825d42715b544e577f28f411a020a270834235125bc0c8872bac8dd3466349ac8ab0aa2d74' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 18, 7, 7, 32768, X'23296f48276e160b6d99b1b42a9114df720bb1ab' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 18, 7, 7, 16384, X'78cd0a598080e31453f477e8d8a12ec794e859f4076ed92e53d2053d6d16762c' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 18, 7, 7, 8192, X'4da3955f1fd968ecf95cff825d42715b544e577f28f411a020a270834235125bc0c8872bac8dd3466349ac8ab0aa2d74' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 19, 7, 1, 32768, X'd537d437f058136eb3d7be517dbe7647b623c619' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 19, 7, 1, 16384, X'6a837037ad3fc4d06270d99cee2714dcf96b91aeb54d3483009219337961f834' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 19, 7, 1, 8192, X'7b5b16840da590a995fab23533f41982c5b136bff8e9b9a90b3c919a12cee20d312091455057a8bba9d9fbe314e6203d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 19, 7, 7, 32768, X'd537d437f058136eb3d7be517dbe7647b623c619' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 19, 7, 7, 16384, X'6a837037ad3fc4d06270d99cee2714dcf96b91aeb54d3483009219337961f834' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 19, 7, 7, 8192, X'7b5b16840da590a995fab23533f41982c5b136bff8e9b9a90b3c919a12cee20d312091455057a8bba9d9fbe314e6203d' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 20, 7, 1, 32768, X'f9e3531abb67a020cf667d46ca823675dd0a0dd4' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 20, 7, 1, 16384, X'569bafa2dabbcfa0ba9c7c411eacfeb8930f9d856a1a43cf8aa3662a67c13e35' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 20, 7, 1, 8192, X'84200bd318bb022915150842ddf4002e061ef593604ad0d07021dc662cc40bfa749cce084ddf25d0e5137f6380f613d8' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 20, 7, 7, 32768, X'f9e3531abb67a020cf667d46ca823675dd0a0dd4' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 20, 7, 7, 16384, X'569bafa2dabbcfa0ba9c7c411eacfeb8930f9d856a1a43cf8aa3662a67c13e35' +); + +INSERT INTO file_hashes ( + file, directory, product, algo, hash +) VALUES ( + 20, 7, 7, 8192, X'84200bd318bb022915150842ddf4002e061ef593604ad0d07021dc662cc40bfa749cce084ddf25d0e5137f6380f613d8' +); + +/* AIKs */ + +INSERT INTO keys ( + keyid, owner +) VALUES ( + X'b772a6730776b9f028e5adfccd40b55c320a13b6', 'Andreas, merthyr (Fujitsu Siemens Lifebook S6420)' +); + +/* Components */ + +INSERT INTO components ( + vendor_id, name, qualifier +) VALUES ( + 36906, 1, 33 /* ITA TGRUB */ +); + +INSERT INTO components ( + vendor_id, name, qualifier +) VALUES ( + 36906, 2, 33 /* ITA TBOOT */ +); + +INSERT INTO components ( + vendor_id, name, qualifier +) VALUES ( + 36906, 3, 33 /* ITA IMA */ +); + +/* AIK Component */ + +INSERT INTO key_component ( + key, component, depth, seq_no +) VALUES ( + 2, 2, 0, 1 +); + +INSERT INTO key_component ( + key, component, depth, seq_no +) VALUES ( + 1, 3, 0, 1 +); + +INSERT INTO key_component ( + key, component, depth, seq_no +) VALUES ( + 1, 2, 0, 2 +); + |