implemented access to PTS file measurement database
[strongswan.git] / src / libimcv / plugins / imv_attestation / data.sql
1 /* Products */
2
3 INSERT INTO products (
4 name
5 ) VALUES (
6 'Ubuntu 11.4 i686'
7 );
8
9 INSERT INTO products (
10 name
11 ) VALUES (
12 'Ubuntu 11.4 x86_64'
13 );
14
15 INSERT INTO products (
16 name
17 ) VALUES (
18 'CentOS release 5.6 (Final) x86_64'
19 );
20
21 /* Files */
22
23 INSERT INTO files (
24 type, path
25 ) VALUES (
26 0, '/lib/i386-linux-gnu/libdl.so.2'
27 );
28
29 INSERT INTO files (
30 type, path
31 ) VALUES (
32 0, '/lib/x86_64-linux-gnu/libdl.so.2'
33 );
34
35 INSERT INTO files (
36 type, path
37 ) VALUES (
38 0, '/lib/libdl.so.2'
39 );
40
41 INSERT INTO files (
42 type, path
43 ) VALUES (
44 0, '/sbin/iptables'
45 );
46 INSERT INTO files (
47 type, path
48 ) VALUES (
49 0, '/lib/libxtables.so.5'
50 );
51
52 INSERT INTO product_file (
53 product, file
54 ) VALUES (
55 1, 1
56 );
57
58 INSERT INTO product_file (
59 product, file
60 ) VALUES (
61 1, 4
62 );
63
64 INSERT INTO product_file (
65 product, file
66 ) VALUES (
67 1, 5
68 );
69
70 INSERT INTO product_file (
71 product, file
72 ) VALUES (
73 2, 2
74 );
75
76 INSERT INTO product_file (
77 product, file
78 ) VALUES (
79 2, 4
80 );
81
82 INSERT INTO product_file (
83 product, file
84 ) VALUES (
85 2, 5
86 );
87
88 INSERT INTO product_file (
89 product, file
90 ) VALUES (
91 3, 3
92 );
93
94 INSERT INTO product_file (
95 product, file
96 ) VALUES (
97 3, 4
98 );
99
100 /* File Hashes */
101
102 INSERT INTO file_hashes (
103 file, product, algo, hash
104 ) VALUES (
105 1, 1, 32768, X'409bb1a97e26ea1144cdd6801b8159f17f376b8f'
106 );
107
108 INSERT INTO file_hashes (
109 file, product, algo, hash
110 ) VALUES (
111 1, 1, 16384, X'675172775cfd2b73ed1e249e4a730921f06c2f86fffdce4c71674cc654f37ed7'
112 );
113
114 INSERT INTO file_hashes (
115 file, product, algo, hash
116 ) VALUES (
117 1, 1, 8192, X'abc8ce3fc99b6dcec6745ffc2f59e35372b9b126491480d04b0f93076beded06cccb27b61f1170868fada8cddefa7be4'
118 );
119
120 INSERT INTO file_hashes (
121 file, product, algo, hash
122 ) VALUES (
123 2, 2, 32768, X'2a4047437e6fb346e2d854fc415e16b80e75bf6b'
124 );
125
126 INSERT INTO file_hashes (
127 file, product, algo, hash
128 ) VALUES (
129 2, 2, 16384, X'86aa0bf93dade999277d963338402ed437271f3436f594a49ffca85b6c487523'
130 );
131
132 INSERT INTO file_hashes (
133 file, product, algo, hash
134 ) VALUES (
135 2, 2, 8192, X'6090441219c0b478d294ae88e006d85ac0d94464573bcca7d180618a612bd170e3ee47c1545861b0f06fe0db85544c59'
136 );
137
138 INSERT INTO file_hashes (
139 file, product, algo, hash
140 ) VALUES (
141 3, 3, 32768, X'07d8c0218a5b3469b409dc95cf8f77a341a595fb'
142 );
143
144 INSERT INTO file_hashes (
145 file, product, algo, hash
146 ) VALUES (
147 3, 3, 16384, X'b083699fbc4c9f9e0d463361118904a3832670ad2fe3d6b42f811061188d509f'
148 );
149
150 INSERT INTO file_hashes (
151 file, product, algo, hash
152 ) VALUES (
153 3, 3, 8192, X'b14908de476467a11a7a98835d1cf8317c7b80a684692426ddd7b0014e00b70b3d1b4fc1dd02ad440447612ee9dadb52'
154 );
155
156 INSERT INTO file_hashes (
157 file, product, algo, hash
158 ) VALUES (
159 4, 1, 32768, X'ff6deca0eeb7a257205c5f0ab5f5d821ea184098'
160 );
161
162 INSERT INTO file_hashes (
163 file, product, algo, hash
164 ) VALUES (
165 4, 1, 16384, X'5c84fdf7c529d3c65a001587eda641fe489f83961a621fe514e7852a842690d6'
166 );
167
168 INSERT INTO file_hashes (
169 file, product, algo, hash
170 ) VALUES (
171 4, 1, 8192, X'8bd699f85f5b3efb27204b4699c518f871ef245d03b4bf8d1cc00456025017546030c2f493525754cffcd24cdbc03b21'
172 );
173
174 INSERT INTO file_hashes (
175 file, product, algo, hash
176 ) VALUES (
177 4, 163842, 32768, X'1118805b490051637e93e592f4c71e0ee78a2422'
178 );
179
180 INSERT INTO file_hashes (
181 file, product, algo, hash
182 ) VALUES (
183 4, 2, 16384, X'5ea7229ebef5dc8f9fb2118676b773dd62cf89dc21657e3b8fbbcbc70ee24bd3'
184 );
185
186 INSERT INTO file_hashes (
187 file, product, algo, hash
188 ) VALUES (
189 4, 2, 8192, X'3b8da9e704e644eb7b196981624a2f6826c401d689e00ba47e42ff46351d27c6b9e91b1e8351ee01f66e5244b4c2a9b0'
190 );
191
192 INSERT INTO file_hashes (
193 file, product, algo, hash
194 ) VALUES (
195 4, 3, 32768, X'b5cd500ec15d6bfcae15e0af1dc121df7114b97d'
196 );
197
198 INSERT INTO file_hashes (
199 file, product, algo, hash
200 ) VALUES (
201 4, 3, 16384, X'b94f1cba12abb0ec79d207142526388ec0d127c4f2aad4a46a623a1f69bac84f'
202 );
203
204 INSERT INTO file_hashes (
205 file, product, algo, hash
206 ) VALUES (
207 4, 3, 8192, X'6663d66ff0e93b1b8a1edcdbe45d64834e29dc9c2b1d23126fd370a85b2c56da5cadcbc65b6e8afbb1e18bea8e413bd1'
208 );
209
210 INSERT INTO file_hashes (
211 file, product, algo, hash
212 ) VALUES (
213 5, 1, 32768, X'7a3ca72158e60b0c91e48a420848f1b693aea26c'
214 );
215
216 INSERT INTO file_hashes (
217 file, product, algo, hash
218 ) VALUES (
219 5, 1, 16384, X'f9693c7d36c087d51f5012897fa0e8bb94081854d080c84f831f4d693d22f645'
220 );
221
222 INSERT INTO file_hashes (
223 file, product, algo, hash
224 ) VALUES (
225 5, 1, 8192, X'4ec135e54c8840ab575fcdf00c66f996f763863ad30800b0f0a0b02e7899697d6ab9ccfe185ccbc16c19f38d0a27becb'
226 );
227
228 INSERT INTO file_hashes (
229 file, product, algo, hash
230 ) VALUES (
231 5, 2, 32768, X'5d36a26856021d68a42f8bd7ca22365579d43891'
232 );
233
234 INSERT INTO file_hashes (
235 file, product, algo, hash
236 ) VALUES (
237 5, 2, 16384, X'411be0558ad0cef33b437dafeed40104917e2079646524145abf9d05ddc6c1c5'
238 );
239
240 INSERT INTO file_hashes (
241 file, product, algo, hash
242 ) VALUES (
243 5, 2, 8192, X'237f4691f9b780bec7aff217d64a9780ceed2973a41e86c92e0d6dab81cc5d13a9b99ba408302264f5665de1f42ef6e1'
244 );
245