search

libyal / libesedb

Library and tools to access the Extensible Storage Engine (ESE) Database File (EDB) format.
GNU Lesser General Public License v3.0
341 stars 91 forks source link

Parsing table of tables with Libesedb Python fork? #51

Closed searay12399 closed 4 years ago

searay12399 commented 4 years ago

Hi, I am trying to parse the store.vol file of a Windows phone. I was able to parse the contacts, but the messages table is actually a table of tables and returns an error:

"libesedb_table_get_number_of_records: unable to retrieve number of leaf values from table page tree."

How can I parse out the individual tables in the the messages table of the ESE Database? Is there a function to do this?

joachimmetz commented 4 years ago

Libesedb Python fork?

what version or "Python fork" of libesedb are you using?

the messages table is actually a table of tables

what do you mean with this, can you share a sample or the output of esedbinfo?

searay12399 commented 4 years ago

Version is 20191220.

Also, here is a link that kinda explains the table that I am trying to read: http://cheeky4n6monkey.blogspot.com/2016/04/an-initial-peep-at-windows-10-mobile.html

If you scroll down to SMS/MMS, it talks about how the message table is set up. When I try to view the number of records in that table, it outputs the error that is shown above.

joachimmetz commented 4 years ago

Is the database you are looking at dirty? What does esedbinfo tell you?

searay12399 commented 4 years ago

I dont know much about ese databases so I dont know how to tell if it is dirty. Also, how do I run esedbinfo? I tried finding an esedbinfo statement and found nothing.

joachimmetz commented 4 years ago

A dirty database is a database that is not in a clean state (typically pending writes).

If you don't have built esedbinfo try Windows eseutil/esentutl (make sure to make a copy of the database first)

See here for some notes on eseutil/esentutl https://github.com/libyal/documentation/blob/master/Forensic%20analysis%20of%20the%20Windows%20Search%20database.pdf

searay12399 commented 4 years ago

Sorry for the delay. I ended up uploading the file to my Linux PC and ran esedbinfo on it. Here is the output:

Table 8, "Message," is what I am interested in.

Output
esedbinfo 20170121 Extensible Storage Engine Database information: File type: Database Created in format: 0x620,20 Current format: 0x620,20 Page size: 4096 bytes Catalog content: Number of tables: 54 Table: 1 MSysObjects (2) Number of columns: 27 Column Identifier Name Type 1 1 ObjidTable Integer 32-bit signed 2 2 Type Integer 16-bit signed 3 3 Id Integer 32-bit signed 4 4 ColtypOrPgnoFDP Integer 32-bit signed 5 5 SpaceUsage Integer 32-bit signed 6 6 Flags Integer 32-bit signed 7 7 PagesOrLocale Integer 32-bit signed 8 8 RootFlag Boolean 9 9 RecordOffset Integer 16-bit signed 10 10 LCMapFlags Integer 32-bit signed 11 11 KeyMost Integer 16-bit unsigned 12 128 Name Text 13 129 Stats Binary data 14 130 TemplateTable Text 15 131 DefaultValue Binary data 16 132 KeyFldIDs Binary data 17 133 VarSegMac Binary data 18 134 ConditionalColumns Binary data 19 135 TupleLimits Binary data 20 136 Version Binary data 21 137 SortID Binary data 22 256 CallbackData Large binary data 23 257 CallbackDependencies Large binary data 24 258 SeparateLV Large binary data 25 259 SpaceHints Large binary data 26 260 SpaceDeferredLVHints Large binary data 27 261 LocaleName Large binary data Number of indexes: 3 Index: 1 Id (2) Index: 2 Name (4) Index: 3 RootObjects (5) Index: 1 Id (2) Index: 2 Name (4) Index: 3 RootObjects (5) Table: 2 MSysObjectsShadow (3) Number of columns: 27 Column Identifier Name Type 1 1 ObjidTable Integer 32-bit signed 2 2 Type Integer 16-bit signed 3 3 Id Integer 32-bit signed 4 4 ColtypOrPgnoFDP Integer 32-bit signed 5 5 SpaceUsage Integer 32-bit signed 6 6 Flags Integer 32-bit signed 7 7 PagesOrLocale Integer 32-bit signed 8 8 RootFlag Boolean 9 9 RecordOffset Integer 16-bit signed 10 10 LCMapFlags Integer 32-bit signed 11 11 KeyMost Integer 16-bit unsigned 12 128 Name Text 13 129 Stats Binary data 14 130 TemplateTable Text 15 131 DefaultValue Binary data 16 132 KeyFldIDs Binary data 17 133 VarSegMac Binary data 18 134 ConditionalColumns Binary data 19 135 TupleLimits Binary data 20 136 Version Binary data 21 137 SortID Binary data 22 256 CallbackData Large binary data 23 257 CallbackDependencies Large binary data 24 258 SeparateLV Large binary data 25 259 SpaceHints Large binary data 26 260 SpaceDeferredLVHints Large binary data 27 261 LocaleName Large binary data Number of indexes: 1 Index: 1 Id (3) Index: 1 Id (3) Table: 3 MSysObjids (6) Number of columns: 3 Column Identifier Name Type 1 256 objid Integer 32-bit signed 2 257 objidTable Integer 32-bit signed 3 258 type Integer 16-bit signed Number of indexes: 1 Index: 1 primary (6) Index: 1 primary (6) Table: 4 MSysLocales (7) Number of columns: 3 Column Identifier Name Type 1 1 Type Integer 8-bit unsigned 2 2 iValue Integer 32-bit signed 3 128 Key Binary data Number of indexes: 1 Index: 1 KeyPrimary (7) Index: 1 KeyPrimary (7) Table: 5 Store (8) Number of columns: 160 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 01060003 Integer 32-bit signed 3 3 826c0013 Integer 32-bit unsigned 4 4 20190013 Integer 32-bit unsigned 5 5 0007000b Boolean 6 6 0114000b Boolean 7 7 20150013 Integer 32-bit unsigned 8 8 01b70013 Integer 32-bit unsigned 9 9 01b80013 Integer 32-bit unsigned 10 10 01aa0013 Integer 32-bit unsigned 11 11 01af0013 Integer 32-bit unsigned 12 12 01ae0013 Integer 32-bit unsigned 13 13 01b10013 Integer 32-bit unsigned 14 14 00050012 Integer 16-bit unsigned 15 15 3714000b Boolean 16 16 82a90040 Integer 64-bit signed 17 17 82b00013 Integer 32-bit unsigned 18 18 82a80013 Integer 32-bit unsigned 19 19 341a000b Boolean 20 20 01ab0013 Integer 32-bit unsigned 21 21 37150013 Integer 32-bit unsigned 22 22 37160013 Integer 32-bit unsigned 23 23 811a0012 Integer 16-bit unsigned 24 24 811b0012 Integer 16-bit unsigned 25 25 01c3000b Boolean 26 26 1106000b Boolean 27 27 01cc000b Boolean 28 28 00100012 Integer 16-bit unsigned 29 29 01cf0013 Integer 32-bit unsigned 30 30 10a70013 Integer 32-bit unsigned 31 31 3743000b Boolean 32 32 37400003 Integer 32-bit signed 33 33 3746000b Boolean 34 34 37480013 Integer 32-bit unsigned 35 35 3742000b Boolean 36 36 380e0040 Integer 64-bit signed 37 37 3760000b Boolean 38 38 3763000b Boolean 39 39 4007000b Boolean 40 40 813f0012 Integer 16-bit unsigned 41 41 81400012 Integer 16-bit unsigned 42 42 81410013 Integer 32-bit unsigned 43 43 81420013 Integer 32-bit unsigned 44 44 7020000b Boolean 45 45 b0700013 Integer 32-bit unsigned 46 46 341b0013 Integer 32-bit unsigned 47 47 34200013 Integer 32-bit unsigned 48 48 82d20040 Integer 64-bit signed 49 49 82b90012 Integer 16-bit unsigned 50 256 8260001f Large text 51 257 825d001f Large text 52 258 201a0041 Large binary data 53 259 3001001f Large text 54 260 3003001f Large text 55 261 80060041 Large binary data 56 262 3419001f Large text 57 263 0003001f Large text 58 264 34160041 Large binary data 59 265 34170041 Large binary data 60 266 8205001f Large text 61 267 8117001f Large text 62 268 82d00041 Large binary data 63 269 82d1001f Large text 64 270 11080041 Large binary data 65 271 10a80041 Large binary data 66 272 10af0041 Large binary data 67 273 3418001f Large text 68 274 37410041 Large binary data 69 275 3754001f Large text 70 276 37530064 Large binary data 71 277 37550064 Large binary data 72 278 38120041 Large binary data 73 279 813b001f Large text 74 280 813c001f Large text 75 281 813d001f Large text 76 282 813e001f Large text 77 283 72aa0041 Large binary data 78 284 72ab0041 Large binary data 79 285 72ac0041 Large binary data 80 286 b0690064 Large binary data 81 287 b06a0064 Large binary data 82 288 7021001f Large text 83 289 7022001f Large text 84 290 7023001f Large text 85 291 7024001f Large text 86 292 c5020041 Large binary data 87 293 c5030041 Large binary data 88 294 83200041 Large binary data 89 295 3009000b Boolean 90 296 8119000b Boolean 91 297 c51b001f Large text 92 298 812e0013 Integer 32-bit unsigned 93 299 c51c001f Large text 94 300 c51d000b Boolean 95 301 c51e0012 Integer 16-bit unsigned 96 302 c5050012 Integer 16-bit unsigned 97 303 c51f000b Boolean 98 304 c5200013 Integer 32-bit unsigned 99 305 c521000b Boolean 100 306 c522000b Boolean 101 307 85070041 Large binary data 102 308 c5230041 Large binary data 103 309 c5240041 Large binary data 104 310 c5040013 Integer 32-bit unsigned 105 311 85260040 Integer 64-bit signed 106 312 852f0012 Integer 16-bit unsigned 107 313 85300012 Integer 16-bit unsigned 108 314 85310012 Integer 16-bit unsigned 109 315 85320012 Integer 16-bit unsigned 110 316 85330012 Integer 16-bit unsigned 111 317 85340012 Integer 16-bit unsigned 112 318 85350012 Integer 16-bit unsigned 113 319 85360012 Integer 16-bit unsigned 114 320 85370012 Integer 16-bit unsigned 115 321 85380012 Integer 16-bit unsigned 116 322 85390012 Integer 16-bit unsigned 117 323 853a0012 Integer 16-bit unsigned 118 324 853b0012 Integer 16-bit unsigned 119 325 853c0012 Integer 16-bit unsigned 120 326 c53d0013 Integer 32-bit unsigned 121 327 85270040 Integer 64-bit signed 122 328 10ab0013 Integer 32-bit unsigned 123 329 8579000b Boolean 124 330 857b0041 Large binary data 125 331 857c0041 Large binary data 126 332 857d0041 Large binary data 127 333 857e0041 Large binary data 128 334 857f0041 Large binary data 129 335 10ae0013 Integer 32-bit unsigned 130 336 85800041 Large binary data 131 337 0ffb0041 Large binary data 132 338 82610013 Integer 32-bit unsigned 133 339 81200013 Integer 32-bit unsigned 134 340 81240012 Integer 16-bit unsigned 135 341 81280012 Integer 16-bit unsigned 136 342 81230013 Integer 32-bit unsigned 137 343 8126001f Large text 138 344 812b0012 Integer 16-bit unsigned 139 345 812c0012 Integer 16-bit unsigned 140 346 8275001f Large text 141 347 81220013 Integer 32-bit unsigned 142 348 81210013 Integer 32-bit unsigned 143 349 82760013 Integer 32-bit unsigned 144 350 81430013 Integer 32-bit unsigned 145 351 8125001f Large text 146 352 3a00001f Large text 147 353 82080013 Integer 32-bit unsigned 148 354 82090013 Integer 32-bit unsigned 149 355 83190013 Integer 32-bit unsigned 150 356 82660012 Integer 16-bit unsigned 151 357 858d0040 Integer 64-bit signed 152 358 820f0040 Integer 64-bit signed 153 359 858f0041 Large binary data 154 360 85900041 Large binary data 155 361 820b0013 Integer 32-bit unsigned 156 362 820a0013 Integer 32-bit unsigned 157 363 831a0013 Integer 32-bit unsigned 158 364 82460041 Large binary data 159 365 82740041 Large binary data 160 366 827f0040 Integer 64-bit signed Number of indexes: 4 Index: 1 00000000 (8) Index: 2 00000001 (9) Index: 3 00000002 (10) Index: 4 00000003 (11) Index: 1 00000000 (8) Index: 2 00000001 (9) Index: 3 00000002 (10) Index: 4 00000003 (11) Table: 6 Folders (12) Number of columns: 34 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 36030013 Integer 32-bit unsigned 5 5 1105000b Boolean 6 6 1104000b Boolean 7 7 80050013 Integer 32-bit unsigned 8 8 36010013 Integer 32-bit unsigned 9 9 80500013 Integer 32-bit unsigned 10 10 36040013 Integer 32-bit unsigned 11 11 20090013 Integer 32-bit unsigned 12 12 360a0012 Integer 16-bit unsigned 13 13 00050012 Integer 16-bit unsigned 14 14 820f0040 Integer 64-bit signed 15 15 82a60013 Integer 32-bit unsigned 16 16 11090013 Integer 32-bit unsigned 17 17 82ae0012 Integer 16-bit unsigned 18 18 10ad000b Boolean 19 19 37440013 Integer 32-bit unsigned 20 20 82b80040 Integer 64-bit signed 21 21 826d000b Boolean 22 256 3001001f Large text 23 257 3618001f Large text 24 258 826e0041 Large binary data 25 259 85010013 Integer 32-bit unsigned 26 260 82a40012 Integer 16-bit unsigned 27 261 85850041 Large binary data 28 262 858c0013 Integer 32-bit unsigned 29 263 850b0013 Integer 32-bit unsigned 30 264 827c0013 Integer 32-bit unsigned 31 265 82640013 Integer 32-bit unsigned 32 266 8265001f Large text 33 267 826d0012 Integer 16-bit unsigned 34 268 82a70040 Integer 64-bit signed Number of indexes: 10 Index: 1 00000000 (12) Index: 2 00000001 (13) Index: 3 00000002 (14) Index: 4 00000003 (15) Index: 5 00000004 (16) Index: 6 00000005 (17) Index: 7 00000006 (18) Index: 8 00000007 (19) Index: 9 00000008 (20) Index: 10 00000009 (21) Index: 1 00000000 (12) Index: 2 00000001 (13) Index: 3 00000002 (14) Index: 4 00000003 (15) Index: 5 00000004 (16) Index: 6 00000005 (17) Index: 7 00000006 (18) Index: 8 00000007 (19) Index: 9 00000008 (20) Index: 10 00000009 (21) Table: 7 Contact (22) Number of columns: 151 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 30140013 Integer 32-bit unsigned 5 5 00f10040 Integer 64-bit signed 6 6 01f00013 Integer 32-bit unsigned 7 7 00f00040 Integer 64-bit signed 8 8 01080040 Integer 64-bit signed 9 9 01090040 Integer 64-bit signed 10 10 10920013 Integer 32-bit unsigned 11 11 37170013 Integer 32-bit unsigned 12 12 01020013 Integer 32-bit unsigned 13 13 0110000b Boolean 14 14 0111000b Boolean 15 15 10100013 Integer 32-bit unsigned 16 16 01e70013 Integer 32-bit unsigned 17 17 01e80040 Integer 64-bit signed 18 18 01e90040 Integer 64-bit signed 19 19 01e0000b Boolean 20 20 01e2000b Boolean 21 21 01e4000b Boolean 22 22 01c40013 Integer 32-bit unsigned 23 23 01c7000b Boolean 24 24 01c80040 Integer 64-bit signed 25 25 010f000b Boolean 26 26 01bc000b Boolean 27 27 01be000b Boolean 28 28 01bf000b Boolean 29 29 01bd000b Boolean 30 30 00fe000b Boolean 31 31 01d1000b Boolean 32 32 3743000b Boolean 33 33 0105000b Boolean 34 34 01a8000b Boolean 35 35 000f0012 Integer 16-bit unsigned 36 36 01ba0040 Integer 64-bit signed 37 37 01b3000b Boolean 38 38 010b0013 Integer 32-bit unsigned 39 39 01ae0013 Integer 32-bit unsigned 40 40 010e000b Boolean 41 41 01a40040 Integer 64-bit signed 42 42 010d000b Boolean 43 43 01a70040 Integer 64-bit signed 44 44 01a60040 Integer 64-bit signed 45 45 010c000b Boolean 46 46 01b5000b Boolean 47 47 00f80013 Integer 32-bit unsigned 48 48 01cb0013 Integer 32-bit unsigned 49 49 001b0013 Integer 32-bit unsigned 50 50 00050012 Integer 16-bit unsigned 51 51 37400003 Integer 32-bit signed 52 52 37620003 Integer 32-bit signed 53 53 01d3000b Boolean 54 54 01db000b Boolean 55 55 01ed000b Boolean 56 256 3418001f Large text 57 257 008f001f Large text 58 258 00a1001f Large text 59 259 01d0001f Large text 60 260 00c6001f Large text 61 261 00c7001f Large text 62 262 00c2001f Large text 63 263 00c5001f Large text 64 264 00c4001f Large text 65 265 00c3001f Large text 66 266 00c1001f Large text 67 267 009b001f Large text 68 268 0097001f Large text 69 269 0098001f Large text 70 270 00a6001f Large text 71 271 008a001f Large text 72 272 00a0001f Large text 73 273 0107001f Large text 74 274 00a9001f Large text 75 275 008b001f Large text 76 276 007e001f Large text 77 277 0112001f Large text 78 278 0113001f Large text 79 279 0090001f Large text 80 280 0091001f Large text 81 281 0092001f Large text 82 282 01df001f Large text 83 283 01e6001f Large text 84 284 01ea001f Large text 85 285 01eb001f Large text 86 286 01ec001f Large text 87 287 0080001f Large text 88 288 0082001f Large text 89 289 01c6001f Large text 90 290 00aa001f Large text 91 291 00d6001f Large text 92 292 00d7001f Large text 93 293 00d2001f Large text 94 294 00d5001f Large text 95 295 00d4001f Large text 96 296 00d3001f Large text 97 297 00d1001f Large text 98 298 009c001f Large text 99 299 0099001f Large text 100 300 009a001f Large text 101 301 0093001f Large text 102 302 0094001f Large text 103 303 0095001f Large text 104 304 008c001f Large text 105 305 0084001f Large text 106 306 008d001f Large text 107 307 0083001f Large text 108 308 10a3001f Large text 109 309 0096001f Large text 110 310 009e001f Large text 111 311 3419001f Large text 112 312 0086001f Large text 113 313 008e001f Large text 114 314 00e6001f Large text 115 315 00e7001f Large text 116 316 00e2001f Large text 117 317 00e5001f Large text 118 318 00e4001f Large text 119 319 00e3001f Large text 120 320 00e1001f Large text 121 321 009d001f Large text 122 322 01a50041 Large binary data 123 323 009f001f Large text 124 324 010a0041 Large binary data 125 325 00a8001f Large text 126 326 00f9001f Large text 127 327 0103001f Large text 128 328 0104001f Large text 129 329 00a5001f Large text 130 330 0085001f Large text 131 331 0081001f Large text 132 332 01ac001f Large text 133 333 01ad001f Large text 134 334 00a7001f Large text 135 335 0089001f Large text 136 336 0101001f Large text 137 337 0087001f Large text 138 338 0088001f Large text 139 339 37410041 Large binary data 140 340 84140041 Large binary data 141 341 00470041 Large binary data 142 342 01d70041 Large binary data 143 343 01d8001f Large text 144 344 01dc001f Large text 145 345 01de001f Large text 146 346 01a30013 Integer 32-bit unsigned 147 347 10b0000b Boolean 148 348 00ff000b Boolean 149 349 37480013 Integer 32-bit unsigned 150 350 37490013 Integer 32-bit unsigned 151 351 001e000b Boolean Number of indexes: 23 Index: 1 00000000 (22) Index: 2 00000001 (23) Index: 3 00000002 (24) Index: 4 00000003 (25) Index: 5 00000004 (26) Index: 6 00000005 (27) Index: 7 00000006 (28) Index: 8 00000007 (29) Index: 9 00000008 (30) Index: 10 00000009 (31) Index: 11 0000000a (32) Index: 12 0000000b (33) Index: 13 0000000c (34) Index: 14 0000000d (35) Index: 15 0000000e (36) Index: 16 0000000f (37) Index: 17 00000010 (38) Index: 18 00000011 (39) Index: 19 00000012 (40) Index: 20 00000013 (41) Index: 21 00000014 (42) Index: 22 00000015 (43) Index: 23 00000016 (44) Index: 1 00000000 (22) Index: 2 00000001 (23) Index: 3 00000002 (24) Index: 4 00000003 (25) Index: 5 00000004 (26) Index: 6 00000005 (27) Index: 7 00000006 (28) Index: 8 00000007 (29) Index: 9 00000008 (30) Index: 10 00000009 (31) Index: 11 0000000a (32) Index: 12 0000000b (33) Index: 13 0000000c (34) Index: 14 0000000d (35) Index: 15 0000000e (36) Index: 16 0000000f (37) Index: 17 00000010 (38) Index: 18 00000011 (39) Index: 19 00000012 (40) Index: 20 00000013 (41) Index: 21 00000014 (42) Index: 22 00000015 (43) Index: 23 00000016 (44) Table: 8 Message (45) Number of columns: 176 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 826a0013 Integer 32-bit unsigned 4 4 82270012 Integer 16-bit unsigned 5 5 82310012 Integer 16-bit unsigned 6 6 82300013 Integer 32-bit unsigned 7 7 82290040 Integer 64-bit signed 8 8 82280040 Integer 64-bit signed 9 9 381a0013 Integer 32-bit unsigned 10 10 80120013 Integer 32-bit unsigned 11 11 82560012 Integer 16-bit unsigned 12 12 82400013 Integer 32-bit unsigned 13 13 82430013 Integer 32-bit unsigned 14 14 825a0013 Integer 32-bit unsigned 15 15 00390040 Integer 64-bit signed 16 16 36020013 Integer 32-bit unsigned 17 17 00090013 Integer 32-bit unsigned 18 18 81080013 Integer 32-bit unsigned 19 19 36030013 Integer 32-bit unsigned 20 20 81180013 Integer 32-bit unsigned 21 21 30150013 Integer 32-bit unsigned 22 22 30070040 Integer 64-bit signed 23 23 827e0013 Integer 32-bit unsigned 24 24 825e0012 Integer 16-bit unsigned 25 25 00150040 Integer 64-bit signed 26 26 81330013 Integer 32-bit unsigned 27 27 10910040 Integer 64-bit signed 28 28 10900013 Integer 32-bit unsigned 29 29 30160013 Integer 32-bit unsigned 30 30 36010013 Integer 32-bit unsigned 31 31 0e1b0012 Integer 16-bit unsigned 32 32 81150012 Integer 16-bit unsigned 33 33 81000013 Integer 32-bit unsigned 34 34 00170013 Integer 32-bit unsigned 35 35 82190013 Integer 32-bit unsigned 36 36 80510013 Integer 32-bit unsigned 37 37 810c0013 Integer 32-bit unsigned 38 38 82080013 Integer 32-bit unsigned 39 39 820a0013 Integer 32-bit unsigned 40 40 8224000b Boolean 41 41 8226000b Boolean 42 42 30080040 Integer 64-bit signed 43 43 820f0040 Integer 64-bit signed 44 44 00610040 Integer 64-bit signed 45 45 00600040 Integer 64-bit signed 46 46 82220040 Integer 64-bit signed 47 47 0e130013 Integer 32-bit unsigned 48 48 0e060040 Integer 64-bit signed 49 49 0e070013 Integer 32-bit unsigned 50 50 0e120013 Integer 32-bit unsigned 51 51 0e080013 Integer 32-bit unsigned 52 52 81110013 Integer 32-bit unsigned 53 53 821e0013 Integer 32-bit unsigned 54 54 83180012 Integer 16-bit unsigned 55 55 83190040 Integer 64-bit signed 56 56 83080040 Integer 64-bit signed 57 57 83110013 Integer 32-bit unsigned 58 58 83120013 Integer 32-bit unsigned 59 59 83170012 Integer 16-bit unsigned 60 60 83090013 Integer 32-bit unsigned 61 61 0e170013 Integer 32-bit unsigned 62 62 82820013 Integer 32-bit unsigned 63 63 820e0013 Integer 32-bit unsigned 64 64 82d30013 Integer 32-bit unsigned 65 65 81300013 Integer 32-bit unsigned 66 66 81120012 Integer 16-bit unsigned 67 67 827b0012 Integer 16-bit unsigned 68 68 825f0013 Integer 32-bit unsigned 69 69 82550013 Integer 32-bit unsigned 70 70 00620013 Integer 32-bit unsigned 71 71 0e090013 Integer 32-bit unsigned 72 72 812f0013 Integer 32-bit unsigned 73 73 826b0013 Integer 32-bit unsigned 74 74 812e0013 Integer 32-bit unsigned 75 75 00260013 Integer 32-bit unsigned 76 76 0c120012 Integer 16-bit unsigned 77 77 82620013 Integer 32-bit unsigned 78 78 370b0013 Integer 32-bit unsigned 79 79 81280012 Integer 16-bit unsigned 80 80 00630012 Integer 16-bit unsigned 81 81 37400003 Integer 32-bit signed 82 82 82000012 Integer 16-bit unsigned 83 83 827a0012 Integer 16-bit unsigned 84 84 00210013 Integer 32-bit unsigned 85 85 82610013 Integer 32-bit unsigned 86 86 825c0013 Integer 32-bit unsigned 87 87 820d0013 Integer 32-bit unsigned 88 88 812c0012 Integer 16-bit unsigned 89 89 360a0012 Integer 16-bit unsigned 90 90 81360013 Integer 32-bit unsigned 91 91 82030012 Integer 16-bit unsigned 92 92 821f0013 Integer 32-bit unsigned 93 93 81350012 Integer 16-bit unsigned 94 94 20090013 Integer 32-bit unsigned 95 95 82590012 Integer 16-bit unsigned 96 96 82580013 Integer 32-bit unsigned 97 97 810b0013 Integer 32-bit unsigned 98 98 81020013 Integer 32-bit unsigned 99 99 82960013 Integer 32-bit unsigned 100 100 82a50040 Integer 64-bit signed 101 256 825d001f Large text 102 257 8252001f Large text 103 258 82810041 Large binary data 104 259 3001001f Large text 105 260 3003001f Large text 106 261 81140041 Large binary data 107 262 81340041 Large binary data 108 263 8280001f Large text 109 264 83020064 Large binary data 110 265 80ff0041 Large binary data 111 266 821c0041 Large binary data 112 267 821d0041 Large binary data 113 268 800c001f Large text 114 269 80050041 Large binary data 115 270 3a0b001f Large text 116 271 82230041 Large binary data 117 272 82250041 Large binary data 118 273 82020041 Large binary data 119 274 82210041 Large binary data 120 275 001a001f Large text 121 276 83060041 Large binary data 122 277 83070041 Large binary data 123 278 8313001f Large text 124 279 831c0041 Large binary data 125 280 8315001f Large text 126 281 004b001f Large text 127 282 82110041 Large binary data 128 283 3fda001f Large text 129 284 0078001f Large text 130 285 0044001f Large text 131 286 8244001f Large text 132 287 10090041 Large binary data 133 288 82450041 Large binary data 134 289 82460041 Large binary data 135 290 0c1f001f Large text 136 291 0c1a001f Large text 137 292 8279001f Large text 138 293 0065001f Large text 139 294 0042001f Large text 140 295 3d09001f Large text 141 296 812d001f Large text 142 297 81320041 Large binary data 143 298 81310041 Large binary data 144 299 0037001f Large text 145 300 003d001f Large text 146 301 007f0041 Large binary data 147 302 8117001f Large text 148 303 81130041 Large binary data 149 304 8110001f Large text 150 305 1030001f Large text 151 306 1031001f Large text 152 307 1032001f Large text 153 308 82940013 Integer 32-bit unsigned 154 309 850f0013 Integer 32-bit unsigned 155 310 00550040 Integer 64-bit signed 156 311 8322001f Large text 157 312 85840013 Integer 32-bit unsigned 158 313 85830041 Large binary data 159 314 3002001f Large text 160 315 8103000b Boolean 161 316 0bfd000b Boolean 162 317 858e0013 Integer 32-bit unsigned 163 318 0070001f Large text 164 319 1000000b Boolean 165 320 1013000b Boolean 166 321 855a0041 Large binary data 167 322 831b001f Large text 168 323 82a30040 Integer 64-bit signed 169 324 0bfc000b Boolean 170 325 855b0041 Large binary data 171 326 855c0041 Large binary data 172 327 855d0041 Large binary data 173 328 85590013 Integer 32-bit unsigned 174 329 10810013 Integer 32-bit unsigned 175 330 10820040 Integer 64-bit signed 176 331 82a20041 Large binary data Number of indexes: 24 Index: 1 00000000 (45) Index: 2 00000001 (46) Index: 3 00000002 (47) Index: 4 00000003 (48) Index: 5 00000004 (49) Index: 6 00000005 (50) Index: 7 00000006 (51) Index: 8 00000007 (52) Index: 9 00000008 (53) Index: 10 00000009 (54) Index: 11 0000000a (55) Index: 12 0000000b (56) Index: 13 0000000c (57) Index: 14 0000000d (58) Index: 15 0000000e (59) Index: 16 0000000f (60) Index: 17 00000010 (61) Index: 18 00000011 (62) Index: 19 00000012 (63) Index: 20 00000013 (64) Index: 21 00000014 (65) Index: 22 00000015 (66) Index: 23 00000016 (67) Index: 24 00000017 (68) Index: 1 00000000 (45) Index: 2 00000001 (46) Index: 3 00000002 (47) Index: 4 00000003 (48) Index: 5 00000004 (49) Index: 6 00000005 (50) Index: 7 00000006 (51) Index: 8 00000007 (52) Index: 9 00000008 (53) Index: 10 00000009 (54) Index: 11 0000000a (55) Index: 12 0000000b (56) Index: 13 0000000c (57) Index: 14 0000000d (58) Index: 15 0000000e (59) Index: 16 0000000f (60) Index: 17 00000010 (61) Index: 18 00000011 (62) Index: 19 00000012 (63) Index: 20 00000013 (64) Index: 21 00000014 (65) Index: 22 00000015 (66) Index: 23 00000016 (67) Index: 24 00000017 (68) Table: 9 Task (69) Number of columns: 23 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 000f0012 Integer 16-bit unsigned 4 4 00600013 Integer 32-bit unsigned 5 5 00210013 Integer 32-bit unsigned 6 6 0022000b Boolean 7 7 0028000b Boolean 8 8 002a0013 Integer 32-bit unsigned 9 9 00620040 Integer 64-bit signed 10 10 0061000b Boolean 11 11 00630040 Integer 64-bit signed 12 12 00640040 Integer 64-bit signed 13 13 0e090013 Integer 32-bit unsigned 14 14 10100013 Integer 32-bit unsigned 15 15 1065000b Boolean 16 16 10680040 Integer 64-bit signed 17 17 10690040 Integer 64-bit signed 18 18 001b0013 Integer 32-bit unsigned 19 256 000c0041 Large binary data 20 257 101d001f Large text 21 258 0020001f Large text 22 259 0029001f Large text 23 260 003f0064 Large binary data Number of indexes: 9 Index: 1 00000000 (69) Index: 2 00000001 (70) Index: 3 00000002 (71) Index: 4 00000003 (72) Index: 5 00000004 (73) Index: 6 00000005 (74) Index: 7 00000006 (75) Index: 8 00000007 (76) Index: 9 00000008 (77) Index: 1 00000000 (69) Index: 2 00000001 (70) Index: 3 00000002 (71) Index: 4 00000003 (72) Index: 5 00000004 (73) Index: 6 00000005 (74) Index: 7 00000006 (75) Index: 8 00000007 (76) Index: 9 00000008 (77) Table: 10 Appointment (78) Number of columns: 48 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 000f0012 Integer 16-bit unsigned 4 4 381a0013 Integer 32-bit unsigned 5 5 001b0013 Integer 32-bit unsigned 6 6 00210013 Integer 32-bit unsigned 7 7 0022000b Boolean 8 8 0028000b Boolean 9 9 002a0013 Integer 32-bit unsigned 10 10 0044000b Boolean 11 11 00450013 Integer 32-bit unsigned 12 12 00460013 Integer 32-bit unsigned 13 13 00500013 Integer 32-bit unsigned 14 14 00520040 Integer 64-bit signed 15 15 00530040 Integer 64-bit signed 16 16 0054000b Boolean 17 17 0056000b Boolean 18 18 0057000b Boolean 19 19 01ae0013 Integer 32-bit unsigned 20 20 0e090013 Integer 32-bit unsigned 21 21 10100013 Integer 32-bit unsigned 22 22 10400013 Integer 32-bit unsigned 23 23 1041000b Boolean 24 24 10420040 Integer 64-bit signed 25 25 10440040 Integer 64-bit signed 26 26 10450013 Integer 32-bit unsigned 27 27 1046000b Boolean 28 28 37400003 Integer 32-bit signed 29 29 110a0013 Integer 32-bit unsigned 30 256 000c0041 Large binary data 31 257 0020001f Large text 32 258 0029001f Large text 33 259 003f0064 Large binary data 34 260 0041001f Large text 35 261 00470041 Large binary data 36 262 00480041 Large binary data 37 263 004a001f Large text 38 264 0051001f Large text 39 265 0055001f Large text 40 266 010a0041 Large binary data 41 267 01c20064 Large binary data 42 268 01c90041 Large binary data 43 269 1047001f Large text 44 270 11070041 Large binary data 45 271 37620003 Integer 32-bit signed 46 272 001e000b Boolean 47 273 8555001f Large text 48 274 8541001f Large text Number of indexes: 15 Index: 1 00000000 (78) Index: 2 00000001 (79) Index: 3 00000002 (80) Index: 4 00000003 (81) Index: 5 00000004 (82) Index: 6 00000005 (83) Index: 7 00000006 (84) Index: 8 00000007 (85) Index: 9 00000008 (86) Index: 10 00000009 (87) Index: 11 0000000a (88) Index: 12 0000000b (89) Index: 13 0000000c (90) Index: 14 0000000d (91) Index: 15 0000000e (92) Index: 1 00000000 (78) Index: 2 00000001 (79) Index: 3 00000002 (80) Index: 4 00000003 (81) Index: 5 00000004 (82) Index: 6 00000005 (83) Index: 7 00000006 (84) Index: 8 00000007 (85) Index: 9 00000008 (86) Index: 10 00000009 (87) Index: 11 0000000a (88) Index: 12 0000000b (89) Index: 13 0000000c (90) Index: 14 0000000d (91) Index: 15 0000000e (92) Table: 11 NamedProps (93) Number of columns: 4 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 200a0013 Integer 32-bit unsigned 3 3 20140013 Integer 32-bit unsigned 4 256 3001001f Large text Number of indexes: 2 Index: 1 00000000 (93) Index: 2 00000001 (94) Index: 1 00000000 (93) Index: 2 00000001 (94) Table: 12 Attachment (95) Number of columns: 23 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 20030013 Integer 32-bit unsigned 4 4 20040013 Integer 32-bit unsigned 5 5 82570012 Integer 16-bit unsigned 6 6 37050013 Integer 32-bit unsigned 7 7 82d40013 Integer 32-bit unsigned 8 8 0e200013 Integer 32-bit unsigned 9 9 0e070013 Integer 32-bit unsigned 10 10 0e170013 Integer 32-bit unsigned 11 256 3712001f Large text 12 257 3713001f Large text 13 258 3703001f Large text 14 259 3704001f Large text 15 260 370e001f Large text 16 261 37090041 Large binary data 17 262 82d5001f Large text 18 263 370c001f Large text 19 264 85870041 Large binary data 20 265 858b0041 Large binary data 21 266 3701000b Boolean 22 267 82560012 Integer 16-bit unsigned 23 268 82730013 Integer 32-bit unsigned Number of indexes: 2 Index: 1 00000000 (95) Index: 2 00000001 (96) Index: 1 00000000 (95) Index: 2 00000001 (96) Table: 13 Recipient (97) Number of columns: 13 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 20030013 Integer 32-bit unsigned 4 4 20040013 Integer 32-bit unsigned 5 5 0c150013 Integer 32-bit unsigned 6 6 0e060040 Integer 64-bit signed 7 7 81380013 Integer 32-bit unsigned 8 8 81390013 Integer 32-bit unsigned 9 9 813a0013 Integer 32-bit unsigned 10 256 3002001f Large text 11 257 3001001f Large text 12 258 3003001f Large text 13 259 3a0b001f Large text Number of indexes: 4 Index: 1 00000000 (97) Index: 2 00000001 (98) Index: 3 00000002 (99) Index: 4 00000003 (100) Index: 1 00000000 (97) Index: 2 00000001 (98) Index: 3 00000002 (99) Index: 4 00000003 (100) Table: 14 Category (101) Number of columns: 4 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0006000b Boolean 4 256 3001001f Large text Number of indexes: 2 Index: 1 00000000 (101) Index: 2 00000001 (102) Index: 1 00000000 (101) Index: 2 00000001 (102) Table: 15 CategoryMap (103) Number of columns: 4 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 20050013 Integer 32-bit unsigned 3 3 20030013 Integer 32-bit unsigned 4 4 20040013 Integer 32-bit unsigned Number of indexes: 5 Index: 1 00000000 (103) Index: 2 00000001 (104) Index: 3 00000002 (105) Index: 4 00000003 (106) Index: 5 00000004 (107) Index: 1 00000000 (103) Index: 2 00000001 (104) Index: 3 00000002 (105) Index: 4 00000003 (106) Index: 5 00000004 (107) Table: 16 SyncPartner (108) Number of columns: 18 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 840a0013 Integer 32-bit unsigned 4 4 841d0040 Integer 64-bit signed 5 5 84200040 Integer 64-bit signed 6 6 3761000b Boolean 7 256 84080041 Large binary data 8 257 3001001f Large text 9 258 840d0041 Large binary data 10 259 84070041 Large binary data 11 260 840e0064 Large binary data 12 261 8419001f Large text 13 262 841a001f Large text 14 263 841b001f Large text 15 264 841c001f Large text 16 265 841e001f Large text 17 266 841f001f Large text 18 267 37350041 Large binary data Number of indexes: 4 Index: 1 00000000 (108) Index: 2 00000001 (109) Index: 3 00000002 (110) Index: 4 00000003 (111) Index: 1 00000000 (108) Index: 2 00000001 (109) Index: 3 00000002 (110) Index: 4 00000003 (111) Table: 17 FolderMetadata (112) Number of columns: 7 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 84000013 Integer 32-bit unsigned 4 4 84060013 Integer 32-bit unsigned 5 256 84030041 Large binary data 6 257 84050064 Large binary data 7 258 84070041 Large binary data Number of indexes: 4 Index: 1 00000000 (112) Index: 2 00000001 (113) Index: 3 00000002 (114) Index: 4 00000003 (115) Index: 1 00000000 (112) Index: 2 00000001 (113) Index: 3 00000002 (114) Index: 4 00000003 (115) Table: 18 ItemMetadata (116) Number of columns: 9 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 84000013 Integer 32-bit unsigned 4 4 84060013 Integer 32-bit unsigned 5 5 84020013 Integer 32-bit unsigned 6 6 84010013 Integer 32-bit unsigned 7 256 84030041 Large binary data 8 257 84050064 Large binary data 9 258 84070041 Large binary data Number of indexes: 6 Index: 1 00000000 (116) Index: 2 00000001 (117) Index: 3 00000002 (118) Index: 4 00000003 (119) Index: 5 00000004 (120) Index: 6 00000005 (121) Index: 1 00000000 (116) Index: 2 00000001 (117) Index: 3 00000002 (118) Index: 4 00000003 (119) Index: 5 00000004 (120) Index: 6 00000005 (121) Table: 19 PartnerFolder (122) Number of columns: 17 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 84090013 Integer 32-bit unsigned 4 4 84110013 Integer 32-bit unsigned 5 5 84000013 Integer 32-bit unsigned 6 6 84120013 Integer 32-bit unsigned 7 7 84130013 Integer 32-bit unsigned 8 8 84210013 Integer 32-bit unsigned 9 9 84230013 Integer 32-bit unsigned 10 256 840f001f Large text 11 257 8410001f Large text 12 258 84140041 Large binary data 13 259 8424001f Large text 14 260 84250064 Large binary data 15 261 853f0003 Integer 32-bit signed 16 262 853e000b Boolean 17 263 85450013 Integer 32-bit unsigned Number of indexes: 7 Index: 1 00000000 (122) Index: 2 00000001 (123) Index: 3 00000002 (124) Index: 4 00000003 (125) Index: 5 00000004 (126) Index: 6 00000005 (127) Index: 7 00000006 (128) Index: 1 00000000 (122) Index: 2 00000001 (123) Index: 3 00000002 (124) Index: 4 00000003 (125) Index: 5 00000004 (126) Index: 6 00000005 (127) Index: 7 00000006 (128) Table: 20 PartnerItem (129) Number of columns: 18 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 84090013 Integer 32-bit unsigned 4 4 84110013 Integer 32-bit unsigned 5 5 84010013 Integer 32-bit unsigned 6 6 84000013 Integer 32-bit unsigned 7 7 84130013 Integer 32-bit unsigned 8 256 840f001f Large text 9 257 84140041 Large binary data 10 258 8422001f Large text 11 259 810b0013 Integer 32-bit unsigned 12 260 821e0013 Integer 32-bit unsigned 13 261 85560013 Integer 32-bit unsigned 14 262 85570013 Integer 32-bit unsigned 15 263 85580041 Large binary data 16 264 85400041 Large binary data 17 265 81020013 Integer 32-bit unsigned 18 266 85970013 Integer 32-bit unsigned Number of indexes: 6 Index: 1 00000000 (129) Index: 2 00000001 (130) Index: 3 00000002 (131) Index: 4 00000003 (132) Index: 5 00000004 (133) Index: 6 00000005 (134) Index: 1 00000000 (129) Index: 2 00000001 (130) Index: 3 00000002 (131) Index: 4 00000003 (132) Index: 5 00000004 (133) Index: 6 00000005 (134) Table: 21 TrackedFolder (135) Number of columns: 6 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 84090013 Integer 32-bit unsigned 4 4 20020013 Integer 32-bit unsigned 5 5 8426000b Boolean 6 256 840d0041 Large binary data Number of indexes: 3 Index: 1 00000000 (135) Index: 2 00000001 (136) Index: 3 00000002 (137) Index: 1 00000000 (135) Index: 2 00000001 (136) Index: 3 00000002 (137) Table: 22 FindContact (138) Number of columns: 10 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 20030013 Integer 32-bit unsigned 4 4 20040013 Integer 32-bit unsigned 5 5 000a0013 Integer 32-bit unsigned 6 6 000e000b Boolean 7 7 01020013 Integer 32-bit unsigned 8 8 20020013 Integer 32-bit unsigned 9 256 000b001f Large text 10 257 000d001f Large text Number of indexes: 3 Index: 1 00000000 (138) Index: 2 00000001 (139) Index: 3 00000002 (140) Index: 1 00000000 (138) Index: 2 00000001 (139) Index: 3 00000002 (140) Table: 23 Note (141) Number of columns: 8 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 20130040 Integer 64-bit signed 5 256 004b001f Large text 6 257 101f001f Large text 7 258 2011001f Large text 8 259 0020001f Large text Number of indexes: 8 Index: 1 00000000 (141) Index: 2 00000001 (142) Index: 3 00000002 (143) Index: 4 00000003 (144) Index: 5 00000004 (145) Index: 6 00000005 (146) Index: 7 00000006 (147) Index: 8 00000007 (148) Index: 1 00000000 (141) Index: 2 00000001 (142) Index: 3 00000002 (143) Index: 4 00000003 (144) Index: 5 00000004 (145) Index: 6 00000005 (146) Index: 7 00000006 (147) Index: 8 00000007 (148) Table: 24 Conversation (149) Number of columns: 26 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 36020013 Integer 32-bit unsigned 5 5 36030013 Integer 32-bit unsigned 6 6 82830013 Integer 32-bit unsigned 7 7 82840013 Integer 32-bit unsigned 8 8 82850013 Integer 32-bit unsigned 9 9 82860013 Integer 32-bit unsigned 10 10 82870040 Integer 64-bit signed 11 11 82880013 Integer 32-bit unsigned 12 12 82d60012 Integer 16-bit unsigned 13 256 30130041 Large binary data 14 257 82930041 Large binary data 15 258 8291001f Large text 16 259 8292001f Large text 17 260 8298001f Large text 18 261 82890013 Integer 32-bit unsigned 19 262 82950013 Integer 32-bit unsigned 20 263 82990013 Integer 32-bit unsigned 21 264 82970013 Integer 32-bit unsigned 22 265 83010013 Integer 32-bit unsigned 23 266 83030012 Integer 16-bit unsigned 24 267 82d70012 Integer 16-bit unsigned 25 268 829a0040 Integer 64-bit signed 26 269 83160012 Integer 16-bit unsigned Number of indexes: 8 Index: 1 00000000 (149) Index: 2 00000001 (150) Index: 3 00000002 (151) Index: 4 00000003 (152) Index: 5 00000004 (153) Index: 6 00000005 (154) Index: 7 00000006 (155) Index: 8 00000007 (156) Index: 1 00000000 (149) Index: 2 00000001 (150) Index: 3 00000002 (151) Index: 4 00000003 (152) Index: 5 00000004 (153) Index: 6 00000005 (154) Index: 7 00000006 (155) Index: 8 00000007 (156) Table: 25 AggregateContact (157) Number of columns: 40 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 01020013 Integer 32-bit unsigned 4 4 01d1000b Boolean 5 5 0105000b Boolean 6 6 01bc000b Boolean 7 7 01be000b Boolean 8 8 01bd000b Boolean 9 9 01c40013 Integer 32-bit unsigned 10 10 01d2000b Boolean 11 11 10a60013 Integer 32-bit unsigned 12 12 37380013 Integer 32-bit unsigned 13 13 3743000b Boolean 14 14 37450013 Integer 32-bit unsigned 15 15 37520003 Integer 32-bit signed 16 16 01ba0040 Integer 64-bit signed 17 17 01db000b Boolean 18 18 01dd0013 Integer 32-bit unsigned 19 256 01b90041 Large binary data 20 257 0082001f Large text 21 258 0087001f Large text 22 259 0084001f Large text 23 260 0088001f Large text 24 261 0083001f Large text 25 262 0086001f Large text 26 263 00a8001f Large text 27 264 0103001f Large text 28 265 0104001f Large text 29 266 0112001f Large text 30 267 0113001f Large text 31 268 0085001f Large text 32 269 0081001f Large text 33 270 01c00041 Large binary data 34 271 01c50041 Large binary data 35 272 01d0001f Large text 36 273 008a001f Large text 37 274 3728001f Large text 38 275 01d90041 Large binary data 39 276 01d8001f Large text 40 277 01da0041 Large binary data Number of indexes: 10 Index: 1 00000000 (157) Index: 2 00000001 (158) Index: 3 00000002 (159) Index: 4 00000003 (160) Index: 5 00000004 (161) Index: 6 00000005 (162) Index: 7 00000006 (163) Index: 8 00000007 (164) Index: 9 00000008 (165) Index: 10 00000009 (166) Index: 1 00000000 (157) Index: 2 00000001 (158) Index: 3 00000002 (159) Index: 4 00000003 (160) Index: 5 00000004 (161) Index: 6 00000005 (162) Index: 7 00000006 (163) Index: 8 00000007 (164) Index: 9 00000008 (165) Index: 10 00000009 (166) Table: 26 Feed (167) Number of columns: 21 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 701c0013 Integer 32-bit unsigned 5 5 701b0013 Integer 32-bit unsigned 6 6 70110013 Integer 32-bit unsigned 7 7 72a00013 Integer 32-bit unsigned 8 8 72a10013 Integer 32-bit unsigned 9 9 72a30040 Integer 64-bit signed 10 10 70020040 Integer 64-bit signed 11 11 70040040 Integer 64-bit signed 12 12 72a40012 Integer 16-bit unsigned 13 13 7a04000b Boolean 14 14 70010013 Integer 32-bit unsigned 15 15 72a50040 Integer 64-bit signed 16 16 72a80040 Integer 64-bit signed 17 17 72a90040 Integer 64-bit signed 18 18 72ad0040 Integer 64-bit signed 19 256 72a20041 Large binary data 20 257 7a240041 Large binary data 21 258 72ae0040 Integer 64-bit signed Number of indexes: 5 Index: 1 00000000 (167) Index: 2 00000001 (168) Index: 3 00000002 (169) Index: 4 00000003 (170) Index: 5 00000004 (171) Index: 1 00000000 (167) Index: 2 00000001 (168) Index: 3 00000002 (169) Index: 4 00000003 (170) Index: 5 00000004 (171) Table: 27 Activity (172) Number of columns: 74 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 70110013 Integer 32-bit unsigned 5 5 701c0013 Integer 32-bit unsigned 6 6 701b0013 Integer 32-bit unsigned 7 7 20040013 Integer 32-bit unsigned 8 8 00040012 Integer 16-bit unsigned 9 9 72a00013 Integer 32-bit unsigned 10 10 72a10013 Integer 32-bit unsigned 11 11 72000013 Integer 32-bit unsigned 12 12 70050040 Integer 64-bit signed 13 13 70060040 Integer 64-bit signed 14 14 70010013 Integer 32-bit unsigned 15 15 70090013 Integer 32-bit unsigned 16 16 721f0013 Integer 32-bit unsigned 17 17 70160012 Integer 16-bit unsigned 18 18 701d0012 Integer 16-bit unsigned 19 19 70100040 Integer 64-bit signed 20 20 72130013 Integer 32-bit unsigned 21 21 72140013 Integer 32-bit unsigned 22 22 720d0013 Integer 32-bit unsigned 23 23 720e0040 Integer 64-bit signed 24 24 720f0012 Integer 16-bit unsigned 25 25 722d0013 Integer 32-bit unsigned 26 26 70190013 Integer 32-bit unsigned 27 27 7a150013 Integer 32-bit unsigned 28 28 7a18000b Boolean 29 29 7a1b0013 Integer 32-bit unsigned 30 30 7a1c0013 Integer 32-bit unsigned 31 31 7a1e0013 Integer 32-bit unsigned 32 32 7a200013 Integer 32-bit unsigned 33 33 7a230013 Integer 32-bit unsigned 34 34 7a260013 Integer 32-bit unsigned 35 35 7a360013 Integer 32-bit unsigned 36 36 7a370003 Integer 32-bit signed 37 37 7a380013 Integer 32-bit unsigned 38 38 7a3a0013 Integer 32-bit unsigned 39 256 7a030041 Large binary data 40 257 7007001f Large text 41 258 7202001f Large text 42 259 7203001f Large text 43 260 7204001f Large text 44 261 7212001f Large text 45 262 7205001f Large text 46 263 7210001f Large text 47 264 7206001f Large text 48 265 7211001f Large text 49 266 7207001f Large text 50 267 721c001f Large text 51 268 7215001f Large text 52 269 7216001f Large text 53 270 7217001f Large text 54 271 7218001f Large text 55 272 7219001f Large text 56 273 721a001f Large text 57 274 721b001f Large text 58 275 7208001f Large text 59 276 7209001f Large text 60 277 720a001f Large text 61 278 720b001f Large text 62 279 720c0041 Large binary data 63 280 701a0064 Large binary data 64 281 7a14001f Large text 65 282 7a16001f Large text 66 283 7a19001f Large text 67 284 7a1a001f Large text 68 285 7a25001f Large text 69 286 7a270041 Large binary data 70 287 7a32001f Large text 71 288 7a33001f Large text 72 289 7a34001f Large text 73 290 7a390041 Large binary data 74 291 70150041 Large binary data Number of indexes: 9 Index: 1 00000000 (172) Index: 2 00000001 (173) Index: 3 00000002 (174) Index: 4 00000003 (175) Index: 5 00000004 (176) Index: 6 00000005 (177) Index: 7 00000006 (178) Index: 8 00000007 (179) Index: 9 00000008 (180) Index: 1 00000000 (172) Index: 2 00000001 (173) Index: 3 00000002 (174) Index: 4 00000003 (175) Index: 5 00000004 (176) Index: 6 00000005 (177) Index: 7 00000006 (178) Index: 8 00000007 (179) Index: 9 00000008 (180) Table: 28 ActivityRelatedObject (181) Number of columns: 19 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 20030013 Integer 32-bit unsigned 3 3 20040013 Integer 32-bit unsigned 4 4 72220012 Integer 16-bit unsigned 5 5 00020003 Integer 32-bit signed 6 6 722b0012 Integer 16-bit unsigned 7 7 72210013 Integer 32-bit unsigned 8 8 72660013 Integer 32-bit unsigned 9 9 72670013 Integer 32-bit unsigned 10 10 72240013 Integer 32-bit unsigned 11 11 72260013 Integer 32-bit unsigned 12 12 722d0013 Integer 32-bit unsigned 13 13 70010013 Integer 32-bit unsigned 14 14 700a000b Boolean 15 256 722a0041 Large binary data 16 257 7223001f Large text 17 258 7228001f Large text 18 259 7229001f Large text 19 260 722f001f Large text Number of indexes: 3 Index: 1 00000000 (181) Index: 2 00000001 (182) Index: 3 00000002 (183) Index: 1 00000000 (181) Index: 2 00000001 (182) Index: 3 00000002 (183) Table: 29 Photo (184) Number of columns: 38 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 0e090013 Integer 32-bit unsigned 3 3 00020003 Integer 32-bit signed 4 4 20030013 Integer 32-bit unsigned 5 5 20040013 Integer 32-bit unsigned 6 6 00040012 Integer 16-bit unsigned 7 7 72640013 Integer 32-bit unsigned 8 8 70010013 Integer 32-bit unsigned 9 9 70110013 Integer 32-bit unsigned 10 10 701e0013 Integer 32-bit unsigned 11 11 72620040 Integer 64-bit signed 12 12 700e0040 Integer 64-bit signed 13 13 70090013 Integer 32-bit unsigned 14 14 70160012 Integer 16-bit unsigned 15 15 70100040 Integer 64-bit signed 16 16 700a000b Boolean 17 17 700b000b Boolean 18 18 7014000b Boolean 19 19 72660013 Integer 32-bit unsigned 20 20 72670013 Integer 32-bit unsigned 21 21 72680013 Integer 32-bit unsigned 22 22 72690013 Integer 32-bit unsigned 23 23 72700013 Integer 32-bit unsigned 24 24 72710013 Integer 32-bit unsigned 25 25 72650012 Integer 16-bit unsigned 26 26 72460040 Integer 64-bit signed 27 27 72720013 Integer 32-bit unsigned 28 28 72750003 Integer 32-bit signed 29 256 7a030041 Large binary data 30 257 72820041 Large binary data 31 258 7008001f Large text 32 259 700d001f Large text 33 260 700f001f Large text 34 261 700a001f Large text 35 262 700b001f Large text 36 263 7014001f Large text 37 264 70180041 Large binary data 38 265 7274001f Large text Number of indexes: 6 Index: 1 00000000 (184) Index: 2 00000001 (185) Index: 3 00000002 (186) Index: 4 00000003 (187) Index: 5 00000004 (188) Index: 6 00000005 (189) Index: 1 00000000 (184) Index: 2 00000001 (185) Index: 3 00000002 (186) Index: 4 00000003 (187) Index: 5 00000004 (188) Index: 6 00000005 (189) Table: 30 Album (190) Number of columns: 38 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 20090013 Integer 32-bit unsigned 5 5 20030013 Integer 32-bit unsigned 6 6 20040013 Integer 32-bit unsigned 7 7 70110013 Integer 32-bit unsigned 8 8 72640013 Integer 32-bit unsigned 9 9 70010013 Integer 32-bit unsigned 10 10 700e0040 Integer 64-bit signed 11 11 72800003 Integer 32-bit signed 12 12 70090013 Integer 32-bit unsigned 13 13 70160012 Integer 16-bit unsigned 14 14 70100040 Integer 64-bit signed 15 15 70020040 Integer 64-bit signed 16 16 70040040 Integer 64-bit signed 17 17 00040012 Integer 16-bit unsigned 18 18 72830012 Integer 16-bit unsigned 19 19 72840012 Integer 16-bit unsigned 20 20 72850013 Integer 32-bit unsigned 21 21 70060040 Integer 64-bit signed 22 22 70170040 Integer 64-bit signed 23 23 72870012 Integer 16-bit unsigned 24 24 728c0013 Integer 32-bit unsigned 25 25 72890013 Integer 32-bit unsigned 26 26 728a0013 Integer 32-bit unsigned 27 27 728b0040 Integer 64-bit signed 28 256 7a030041 Large binary data 29 257 72820041 Large binary data 30 258 7007001f Large text 31 259 7008001f Large text 32 260 700d001f Large text 33 261 700f001f Large text 34 262 7281001f Large text 35 263 70180041 Large binary data 36 264 728d0041 Large binary data 37 265 728e0041 Large binary data 38 266 728f001f Large text Number of indexes: 9 Index: 1 00000000 (190) Index: 2 00000001 (191) Index: 3 00000002 (192) Index: 4 00000003 (193) Index: 5 00000004 (194) Index: 6 00000005 (195) Index: 7 00000006 (196) Index: 8 00000007 (197) Index: 9 00000008 (198) Index: 1 00000000 (190) Index: 2 00000001 (191) Index: 3 00000002 (192) Index: 4 00000003 (193) Index: 5 00000004 (194) Index: 6 00000005 (195) Index: 7 00000006 (196) Index: 8 00000007 (197) Index: 9 00000008 (198) Table: 31 Comment (199) Number of columns: 15 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 20030013 Integer 32-bit unsigned 4 4 20040013 Integer 32-bit unsigned 5 5 00040012 Integer 16-bit unsigned 6 6 7a2d0013 Integer 32-bit unsigned 7 7 70050040 Integer 64-bit signed 8 8 72130013 Integer 32-bit unsigned 9 9 70190013 Integer 32-bit unsigned 10 256 7a030041 Large binary data 11 257 7202001f Large text 12 258 7008001f Large text 13 259 701a0064 Large binary data 14 260 7a30001f Large text 15 261 7a31001f Large text Number of indexes: 3 Index: 1 00000000 (199) Index: 2 00000001 (200) Index: 3 00000002 (201) Index: 1 00000000 (199) Index: 2 00000001 (200) Index: 3 00000002 (201) Table: 32 Tag (202) Number of columns: 12 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 20030013 Integer 32-bit unsigned 4 4 20040013 Integer 32-bit unsigned 5 5 30160013 Integer 32-bit unsigned 6 6 72420005 Floating point double precision (64-bit) 7 7 72430005 Floating point double precision (64-bit) 8 8 72440005 Floating point double precision (64-bit) 9 9 72450005 Floating point double precision (64-bit) 10 10 00040012 Integer 16-bit unsigned 11 256 7a030041 Large binary data 12 257 7241001f Large text Number of indexes: 4 Index: 1 00000000 (202) Index: 2 00000001 (203) Index: 3 00000002 (204) Index: 4 00000003 (205) Index: 1 00000000 (202) Index: 2 00000001 (203) Index: 3 00000002 (204) Index: 4 00000003 (205) Table: 33 AggregateGroup (206) Number of columns: 33 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 0105000b Boolean 5 5 371a0013 Integer 32-bit unsigned 6 6 01cd0040 Integer 64-bit signed 7 7 3743000b Boolean 8 8 3747000b Boolean 9 9 38010013 Integer 32-bit unsigned 10 10 38020040 Integer 64-bit signed 11 11 38190040 Integer 64-bit signed 12 12 38050013 Integer 32-bit unsigned 13 13 3807000b Boolean 14 14 380b0040 Integer 64-bit signed 15 15 380c0040 Integer 64-bit signed 16 16 380f0013 Integer 32-bit unsigned 17 17 380a0040 Integer 64-bit signed 18 18 38180040 Integer 64-bit signed 19 19 01ba0040 Integer 64-bit signed 20 256 371b0041 Large binary data 21 257 3718001f Large text 22 258 3719001f Large text 23 259 3803001f Large text 24 260 38040041 Large binary data 25 261 381b001f Large text 26 262 3808001f Large text 27 263 3809001f Large text 28 264 3810001f Large text 29 265 3811001f Large text 30 266 38130041 Large binary data 31 267 38140041 Large binary data 32 268 38170041 Large binary data 33 269 01d90041 Large binary data Number of indexes: 10 Index: 1 00000000 (206) Index: 2 00000001 (207) Index: 3 00000002 (208) Index: 4 00000003 (209) Index: 5 00000004 (210) Index: 6 00000005 (211) Index: 7 00000006 (212) Index: 8 00000007 (213) Index: 9 00000008 (214) Index: 10 00000009 (215) Index: 1 00000000 (206) Index: 2 00000001 (207) Index: 3 00000002 (208) Index: 4 00000003 (209) Index: 5 00000004 (210) Index: 6 00000005 (211) Index: 7 00000006 (212) Index: 8 00000007 (213) Index: 9 00000008 (214) Index: 10 00000009 (215) Table: 34 GroupMember (216) Number of columns: 22 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 20050013 Integer 32-bit unsigned 4 4 20030013 Integer 32-bit unsigned 5 5 20040013 Integer 32-bit unsigned 6 6 371d0013 Integer 32-bit unsigned 7 7 371e0013 Integer 32-bit unsigned 8 8 371f0013 Integer 32-bit unsigned 9 9 3723000b Boolean 10 10 37200013 Integer 32-bit unsigned 11 11 37210013 Integer 32-bit unsigned 12 12 37220013 Integer 32-bit unsigned 13 13 3724000b Boolean 14 14 3750000b Boolean 15 15 3749000b Boolean 16 16 01020013 Integer 32-bit unsigned 17 17 37510003 Integer 32-bit signed 18 18 380f0013 Integer 32-bit unsigned 19 256 3418001f Large text 20 257 3419001f Large text 21 258 010a0041 Large binary data 22 259 371b0041 Large binary data Number of indexes: 11 Index: 1 00000000 (216) Index: 2 00000001 (217) Index: 3 00000002 (218) Index: 4 00000003 (219) Index: 5 00000004 (220) Index: 6 00000005 (221) Index: 7 00000006 (222) Index: 8 00000007 (223) Index: 9 00000008 (224) Index: 10 00000009 (225) Index: 11 0000000a (226) Index: 1 00000000 (216) Index: 2 00000001 (217) Index: 3 00000002 (218) Index: 4 00000003 (219) Index: 5 00000004 (220) Index: 6 00000005 (221) Index: 7 00000006 (222) Index: 8 00000007 (223) Index: 9 00000008 (224) Index: 10 00000009 (225) Index: 11 0000000a (226) Table: 35 FolderConversation (227) Number of columns: 17 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 36020013 Integer 32-bit unsigned 5 5 36030013 Integer 32-bit unsigned 6 6 82830013 Integer 32-bit unsigned 7 7 82840013 Integer 32-bit unsigned 8 8 82850013 Integer 32-bit unsigned 9 9 82860013 Integer 32-bit unsigned 10 10 82870040 Integer 64-bit signed 11 11 82880013 Integer 32-bit unsigned 12 12 82d60012 Integer 16-bit unsigned 13 256 30130041 Large binary data 14 257 8291001f Large text 15 258 8292001f Large text 16 259 8298001f Large text 17 260 82890013 Integer 32-bit unsigned Number of indexes: 7 Index: 1 00000000 (227) Index: 2 00000001 (228) Index: 3 00000002 (229) Index: 4 00000003 (230) Index: 5 00000004 (231) Index: 6 00000005 (232) Index: 7 00000006 (233) Index: 1 00000000 (227) Index: 2 00000001 (228) Index: 3 00000002 (229) Index: 4 00000003 (230) Index: 5 00000004 (231) Index: 6 00000005 (232) Index: 7 00000006 (233) Table: 36 EmailRecipientInfo (234) Number of columns: 7 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 37250013 Integer 32-bit unsigned 5 5 37260040 Integer 64-bit signed 6 256 3001001f Large text 7 257 3003001f Large text Number of indexes: 5 Index: 1 00000000 (234) Index: 2 00000001 (235) Index: 3 00000002 (236) Index: 4 00000003 (237) Index: 5 00000004 (238) Index: 1 00000000 (234) Index: 2 00000001 (235) Index: 3 00000002 (236) Index: 4 00000003 (237) Index: 5 00000004 (238) Table: 37 PartnerMeetingResponse (239) Number of columns: 8 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 84090013 Integer 32-bit unsigned 4 4 84110013 Integer 32-bit unsigned 5 5 84150013 Integer 32-bit unsigned 6 6 84170013 Integer 32-bit unsigned 7 256 8418001f Large text 8 257 84160041 Large binary data Number of indexes: 3 Index: 1 00000000 (239) Index: 2 00000001 (240) Index: 3 00000002 (241) Index: 1 00000000 (239) Index: 2 00000001 (240) Index: 3 00000002 (241) Table: 38 SyncSchema (242) Number of columns: 4 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 84090013 Integer 32-bit unsigned 4 256 840b0064 Large binary data Number of indexes: 2 Index: 1 00000000 (242) Index: 2 00000001 (243) Index: 1 00000000 (242) Index: 2 00000001 (243) Table: 39 EmailMetadata (244) Number of columns: 9 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 84000013 Integer 32-bit unsigned 4 4 84060013 Integer 32-bit unsigned 5 5 84020013 Integer 32-bit unsigned 6 6 84010013 Integer 32-bit unsigned 7 256 84030041 Large binary data 8 257 84050064 Large binary data 9 258 84070041 Large binary data Number of indexes: 6 Index: 1 00000000 (244) Index: 2 00000001 (245) Index: 3 00000002 (246) Index: 4 00000003 (247) Index: 5 00000004 (248) Index: 6 00000005 (249) Index: 1 00000000 (244) Index: 2 00000001 (245) Index: 3 00000002 (246) Index: 4 00000003 (247) Index: 5 00000004 (248) Index: 6 00000005 (249) Table: 40 ServerPerson (250) Number of columns: 14 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 37300013 Integer 32-bit unsigned 4 4 37310013 Integer 32-bit unsigned 5 5 37320013 Integer 32-bit unsigned 6 6 37330013 Integer 32-bit unsigned 7 7 373d000b Boolean 8 256 3727001f Large text 9 257 3728001f Large text 10 258 3729001f Large text 11 259 37340041 Large binary data 12 260 37350041 Large binary data 13 261 373b0041 Large binary data 14 262 373c0041 Large binary data Number of indexes: 6 Index: 1 00000000 (250) Index: 2 00000001 (251) Index: 3 00000002 (252) Index: 4 00000003 (253) Index: 5 00000004 (254) Index: 6 00000005 (255) Index: 1 00000000 (250) Index: 2 00000001 (251) Index: 3 00000002 (252) Index: 4 00000003 (253) Index: 5 00000004 (254) Index: 6 00000005 (255) Table: 41 ServerContactLink (256) Number of columns: 10 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 37380013 Integer 32-bit unsigned 5 5 37390013 Integer 32-bit unsigned 6 6 373a000b Boolean 7 256 3418001f Large text 8 257 3419001f Large text 9 258 010a0041 Large binary data 10 259 84140041 Large binary data Number of indexes: 5 Index: 1 00000000 (256) Index: 2 00000001 (257) Index: 3 00000002 (258) Index: 4 00000003 (259) Index: 5 00000004 (260) Index: 1 00000000 (256) Index: 2 00000001 (257) Index: 3 00000002 (258) Index: 4 00000003 (259) Index: 5 00000004 (260) Table: 42 MediaAlbum (261) Number of columns: 17 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 b0050003 Integer 32-bit signed 5 5 b0010013 Integer 32-bit unsigned 6 6 b00f0040 Integer 64-bit signed 7 7 b0460012 Integer 16-bit unsigned 8 8 b0200013 Integer 32-bit unsigned 9 9 b05c0003 Integer 32-bit signed 10 256 b00a001f Large text 11 257 b01f001f Large text 12 258 b00b001f Large text 13 259 b00e0041 Large binary data 14 260 b07d001f Large text 15 261 b0830012 Integer 16-bit unsigned 16 262 b055001f Large text 17 263 857a0041 Large binary data Number of indexes: 8 Index: 1 00000000 (261) Index: 2 00000001 (262) Index: 3 00000002 (263) Index: 4 00000003 (264) Index: 5 00000004 (265) Index: 6 00000005 (266) Index: 7 00000006 (267) Index: 8 00000007 (268) Index: 1 00000000 (261) Index: 2 00000001 (262) Index: 3 00000002 (263) Index: 4 00000003 (264) Index: 5 00000004 (265) Index: 6 00000005 (266) Index: 7 00000006 (267) Index: 8 00000007 (268) Table: 43 MediaArtist (269) Number of columns: 19 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 b0050003 Integer 32-bit signed 5 5 b0200013 Integer 32-bit unsigned 6 6 b0460012 Integer 16-bit unsigned 7 7 b0520013 Integer 32-bit unsigned 8 8 b056000b Boolean 9 9 b05c0003 Integer 32-bit signed 10 10 b05d0003 Integer 32-bit signed 11 11 b03e0003 Integer 32-bit signed 12 256 b00a001f Large text 13 257 b01f001f Large text 14 258 b00b001f Large text 15 259 b00e0041 Large binary data 16 260 b07d001f Large text 17 261 b0830012 Integer 16-bit unsigned 18 262 b0840012 Integer 16-bit unsigned 19 263 b055001f Large text Number of indexes: 9 Index: 1 00000000 (269) Index: 2 00000001 (270) Index: 3 00000002 (271) Index: 4 00000003 (272) Index: 5 00000004 (273) Index: 6 00000005 (274) Index: 7 00000006 (275) Index: 8 00000007 (276) Index: 9 00000008 (277) Index: 1 00000000 (269) Index: 2 00000001 (270) Index: 3 00000002 (271) Index: 4 00000003 (272) Index: 5 00000004 (273) Index: 6 00000005 (274) Index: 7 00000006 (275) Index: 8 00000007 (276) Index: 9 00000008 (277) Table: 44 MediaAudio (278) Number of columns: 68 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 37400003 Integer 32-bit signed 5 5 b0050003 Integer 32-bit signed 6 6 b0440003 Integer 32-bit signed 7 7 b092000b Boolean 8 8 b00f0040 Integer 64-bit signed 9 9 b00d0003 Integer 32-bit signed 10 10 b0130003 Integer 32-bit signed 11 11 b0240040 Integer 64-bit signed 12 12 b0250003 Integer 32-bit signed 13 13 b0100003 Integer 32-bit signed 14 14 b01a0003 Integer 32-bit signed 15 15 b0320003 Integer 32-bit signed 16 16 b05c0003 Integer 32-bit signed 17 17 b06f0003 Integer 32-bit signed 18 18 b0000013 Integer 32-bit unsigned 19 19 b0010013 Integer 32-bit unsigned 20 20 b0030013 Integer 32-bit unsigned 21 21 b0260003 Integer 32-bit signed 22 22 b0280003 Integer 32-bit signed 23 23 b0290003 Integer 32-bit signed 24 24 b02a0003 Integer 32-bit signed 25 25 b02d0003 Integer 32-bit signed 26 26 b02e0003 Integer 32-bit signed 27 27 b0270003 Integer 32-bit signed 28 28 b02f0003 Integer 32-bit signed 29 29 b0300003 Integer 32-bit signed 30 30 b0310003 Integer 32-bit signed 31 31 b0140040 Integer 64-bit signed 32 32 b0460012 Integer 16-bit unsigned 33 33 b065000b Boolean 34 34 b0660013 Integer 32-bit unsigned 35 35 b0670040 Integer 64-bit signed 36 36 b0680040 Integer 64-bit signed 37 37 b0760003 Integer 32-bit signed 38 38 b07b0013 Integer 32-bit unsigned 39 39 b07c0040 Integer 64-bit signed 40 40 b0040013 Integer 32-bit unsigned 41 41 b03d0003 Integer 32-bit signed 42 42 b03e0003 Integer 32-bit signed 43 43 b03f0003 Integer 32-bit signed 44 44 b0400003 Integer 32-bit signed 45 45 b0410003 Integer 32-bit signed 46 46 b0420003 Integer 32-bit signed 47 47 b0430040 Integer 64-bit signed 48 256 b00c001f Large text 49 257 b07f0041 Large binary data 50 258 b00a001f Large text 51 259 b00e0041 Large binary data 52 260 b01e0041 Large binary data 53 261 b0830012 Integer 16-bit unsigned 54 262 b01f001f Large text 55 263 b0110041 Large binary data 56 264 b0330041 Large binary data 57 265 b034001f Large text 58 266 b035001f Large text 59 267 b036001f Large text 60 268 b037001f Large text 61 269 b0770041 Large binary data 62 270 b07d001f Large text 63 271 b03b001f Large text 64 272 b03c001f Large text 65 273 b012001f Large text 66 274 b04e001f Large text 67 275 010a0041 Large binary data 68 276 37620003 Integer 32-bit signed Number of indexes: 24 Index: 1 00000000 (278) Index: 2 00000001 (279) Index: 3 00000002 (280) Index: 4 00000003 (281) Index: 5 00000004 (282) Index: 6 00000005 (283) Index: 7 00000006 (284) Index: 8 00000007 (285) Index: 9 00000008 (286) Index: 10 00000009 (287) Index: 11 0000000a (288) Index: 12 0000000b (289) Index: 13 0000000c (290) Index: 14 0000000d (291) Index: 15 0000000e (292) Index: 16 0000000f (293) Index: 17 00000010 (294) Index: 18 00000011 (295) Index: 19 00000012 (296) Index: 20 00000013 (297) Index: 21 00000014 (298) Index: 22 00000015 (299) Index: 23 00000016 (300) Index: 24 00000017 (301) Index: 1 00000000 (278) Index: 2 00000001 (279) Index: 3 00000002 (280) Index: 4 00000003 (281) Index: 5 00000004 (282) Index: 6 00000005 (283) Index: 7 00000006 (284) Index: 8 00000007 (285) Index: 9 00000008 (286) Index: 10 00000009 (287) Index: 11 0000000a (288) Index: 12 0000000b (289) Index: 13 0000000c (290) Index: 14 0000000d (291) Index: 15 0000000e (292) Index: 16 0000000f (293) Index: 17 00000010 (294) Index: 18 00000011 (295) Index: 19 00000012 (296) Index: 20 00000013 (297) Index: 21 00000014 (298) Index: 22 00000015 (299) Index: 23 00000016 (300) Index: 24 00000017 (301) Table: 45 MediaPictureVideo (302) Number of columns: 65 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 37400003 Integer 32-bit signed 5 5 b0050003 Integer 32-bit signed 6 6 b0210003 Integer 32-bit signed 7 7 b0220003 Integer 32-bit signed 8 8 b0020013 Integer 32-bit unsigned 9 9 b092000b Boolean 10 10 b00f0040 Integer 64-bit signed 11 11 b0100003 Integer 32-bit signed 12 12 b0140040 Integer 64-bit signed 13 13 b045000b Boolean 14 14 b0200013 Integer 32-bit unsigned 15 15 b05c0003 Integer 32-bit signed 16 16 b06f0003 Integer 32-bit signed 17 17 b0150003 Integer 32-bit signed 18 18 b0160003 Integer 32-bit signed 19 19 b0170003 Integer 32-bit signed 20 20 b0180003 Integer 32-bit signed 21 21 b0190003 Integer 32-bit signed 22 22 b01a0003 Integer 32-bit signed 23 23 b01b0003 Integer 32-bit signed 24 24 b01c0040 Integer 64-bit signed 25 25 b058000b Boolean 26 26 b0230003 Integer 32-bit signed 27 27 b0130003 Integer 32-bit signed 28 28 b0040013 Integer 32-bit unsigned 29 29 b0270003 Integer 32-bit signed 30 30 b02f0003 Integer 32-bit signed 31 31 b0300003 Integer 32-bit signed 32 32 b0310003 Integer 32-bit signed 33 33 b0710003 Integer 32-bit signed 34 34 b0720003 Integer 32-bit signed 35 35 b0730003 Integer 32-bit signed 36 36 b0740003 Integer 32-bit signed 37 37 b0420003 Integer 32-bit signed 38 38 b0250003 Integer 32-bit signed 39 39 b03d0003 Integer 32-bit signed 40 40 b03e0003 Integer 32-bit signed 41 41 b00d0003 Integer 32-bit signed 42 42 b06b0003 Integer 32-bit signed 43 256 b00a001f Large text 44 257 b00c001f Large text 45 258 b07f0041 Large binary data 46 259 b0110041 Large binary data 47 260 b012001f Large text 48 261 b0640013 Integer 32-bit unsigned 49 262 b0330041 Large binary data 50 263 b0830012 Integer 16-bit unsigned 51 264 b01e0041 Large binary data 52 265 b075001f Large text 53 266 b04e001f Large text 54 267 b061001f Large text 55 268 b03b001f Large text 56 269 b03c001f Large text 57 270 b060001f Large text 58 271 b00e0041 Large binary data 59 272 37620003 Integer 32-bit signed 60 273 857a0041 Large binary data 61 274 85920040 Integer 64-bit signed 62 275 8593001f Large text 63 276 85940003 Integer 32-bit signed 64 277 8595001f Large text 65 278 8596001f Large text Number of indexes: 17 Index: 1 00000000 (302) Index: 2 00000001 (303) Index: 3 00000002 (304) Index: 4 00000003 (305) Index: 5 00000004 (306) Index: 6 00000005 (307) Index: 7 00000006 (308) Index: 8 00000007 (309) Index: 9 00000008 (310) Index: 10 00000009 (311) Index: 11 0000000a (312) Index: 12 0000000b (313) Index: 13 0000000c (314) Index: 14 0000000d (315) Index: 15 0000000e (316) Index: 16 0000000f (317) Index: 17 00000010 (318) Index: 1 00000000 (302) Index: 2 00000001 (303) Index: 3 00000002 (304) Index: 4 00000003 (305) Index: 5 00000004 (306) Index: 6 00000005 (307) Index: 7 00000006 (308) Index: 8 00000007 (309) Index: 9 00000008 (310) Index: 10 00000009 (311) Index: 11 0000000a (312) Index: 12 0000000b (313) Index: 13 0000000c (314) Index: 14 0000000d (315) Index: 15 0000000e (316) Index: 16 0000000f (317) Index: 17 00000010 (318) Table: 46 MediaPictureAlbum (319) Number of columns: 20 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 b0050003 Integer 32-bit signed 5 5 b0020013 Integer 32-bit unsigned 6 6 b01d0013 Integer 32-bit unsigned 7 7 b0540003 Integer 32-bit signed 8 8 b05c0003 Integer 32-bit signed 9 9 b062000b Boolean 10 10 b00f0040 Integer 64-bit signed 11 11 b0140040 Integer 64-bit signed 12 12 b07a0040 Integer 64-bit signed 13 256 b00a001f Large text 14 257 b055001f Large text 15 258 b0890041 Large binary data 16 259 b061001f Large text 17 260 b03c001f Large text 18 261 b079001f Large text 19 262 b0830012 Integer 16-bit unsigned 20 263 b0200013 Integer 32-bit unsigned Number of indexes: 8 Index: 1 00000000 (319) Index: 2 00000001 (320) Index: 3 00000002 (321) Index: 4 00000003 (322) Index: 5 00000004 (323) Index: 6 00000005 (324) Index: 7 00000006 (325) Index: 8 00000007 (326) Index: 1 00000000 (319) Index: 2 00000001 (320) Index: 3 00000002 (321) Index: 4 00000003 (322) Index: 5 00000004 (323) Index: 6 00000005 (324) Index: 7 00000006 (325) Index: 8 00000007 (326) Table: 47 AppEntityBinding (327) Number of columns: 12 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 20030013 Integer 32-bit unsigned 4 4 20040013 Integer 32-bit unsigned 5 5 4008000b Boolean 6 6 40000002 Integer 16-bit signed 7 7 40010002 Integer 16-bit signed 8 8 40040002 Integer 16-bit signed 9 9 40050002 Integer 16-bit signed 10 256 40030041 Large binary data 11 257 40020041 Large binary data 12 258 40060041 Large binary data Number of indexes: 5 Index: 1 00000000 (327) Index: 2 00000001 (328) Index: 3 00000002 (329) Index: 4 00000003 (330) Index: 5 00000004 (331) Index: 1 00000000 (327) Index: 2 00000001 (328) Index: 3 00000002 (329) Index: 4 00000003 (330) Index: 5 00000004 (331) Table: 48 MediaGenre (332) Number of columns: 9 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 b0050003 Integer 32-bit signed 5 5 b0200013 Integer 32-bit unsigned 6 6 b0590003 Integer 32-bit signed 7 7 b05c0003 Integer 32-bit signed 8 256 b00a001f Large text 9 257 b0830012 Integer 16-bit unsigned Number of indexes: 4 Index: 1 00000000 (332) Index: 2 00000001 (333) Index: 3 00000002 (334) Index: 4 00000003 (335) Index: 1 00000000 (332) Index: 2 00000001 (333) Index: 3 00000002 (334) Index: 4 00000003 (335) Table: 49 MediaEvent (336) Number of columns: 10 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 b0020013 Integer 32-bit unsigned 5 5 b0050003 Integer 32-bit signed 6 6 b0380040 Integer 64-bit signed 7 7 b039000b Boolean 8 8 b03a000b Boolean 9 256 b00a001f Large text 10 257 b07e0041 Large binary data Number of indexes: 3 Index: 1 00000000 (336) Index: 2 00000001 (337) Index: 3 00000002 (338) Index: 1 00000000 (336) Index: 2 00000001 (337) Index: 3 00000002 (338) Table: 50 MediaSeries (339) Number of columns: 36 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 b0050003 Integer 32-bit signed 5 5 b0500003 Integer 32-bit signed 6 6 b0200013 Integer 32-bit unsigned 7 7 b05c0003 Integer 32-bit signed 8 8 b0490003 Integer 32-bit signed 9 9 b047000b Boolean 10 10 b0480003 Integer 32-bit signed 11 11 b04a0003 Integer 32-bit signed 12 12 b04b0003 Integer 32-bit signed 13 13 b04c0003 Integer 32-bit signed 14 14 b0430040 Integer 64-bit signed 15 15 b04d0003 Integer 32-bit signed 16 16 b0590003 Integer 32-bit signed 17 17 b057000b Boolean 18 18 b05e0003 Integer 32-bit signed 19 19 b05f0003 Integer 32-bit signed 20 20 b03e0003 Integer 32-bit signed 21 21 b0140040 Integer 64-bit signed 22 22 b0240040 Integer 64-bit signed 23 23 b08b0003 Integer 32-bit signed 24 256 b00a001f Large text 25 257 b04e001f Large text 26 258 b04f001f Large text 27 259 b012001f Large text 28 260 b03b001f Large text 29 261 b00b001f Large text 30 262 b08a001f Large text 31 263 b03c001f Large text 32 264 b08c001f Large text 33 265 b0830012 Integer 16-bit unsigned 34 266 b0850012 Integer 16-bit unsigned 35 267 b0860012 Integer 16-bit unsigned 36 268 b055001f Large text Number of indexes: 5 Index: 1 00000000 (339) Index: 2 00000001 (340) Index: 3 00000002 (341) Index: 4 00000003 (342) Index: 5 00000004 (343) Index: 1 00000000 (339) Index: 2 00000001 (340) Index: 3 00000002 (341) Index: 4 00000003 (342) Index: 5 00000004 (343) Table: 51 MediaPlaylist (344) Number of columns: 16 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 37400003 Integer 32-bit signed 5 5 b0050003 Integer 32-bit signed 6 6 b078000b Boolean 7 7 b05c0003 Integer 32-bit signed 8 8 b0910013 Integer 32-bit unsigned 9 256 b00a001f Large text 10 257 b05a0041 Large binary data 11 258 b05b0041 Large binary data 12 259 010a0041 Large binary data 13 260 b0110041 Large binary data 14 261 b00b001f Large text 15 262 b08d0012 Integer 16-bit unsigned 16 263 b055001f Large text Number of indexes: 4 Index: 1 00000000 (344) Index: 2 00000001 (345) Index: 3 00000002 (346) Index: 4 00000003 (347) Index: 1 00000000 (344) Index: 2 00000001 (345) Index: 3 00000002 (346) Index: 4 00000003 (347) Table: 52 MediaCartEntry (348) Number of columns: 15 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 4 37400003 Integer 32-bit signed 5 5 b06d0003 Integer 32-bit signed 6 6 b06e0003 Integer 32-bit signed 7 7 b0050003 Integer 32-bit signed 8 8 b0870003 Integer 32-bit signed 9 9 b0880003 Integer 32-bit signed 10 256 b00a001f Large text 11 257 b00e0041 Large binary data 12 258 b034001f Large text 13 259 b035001f Large text 14 260 b036001f Large text 15 261 b06c001f Large text Number of indexes: 4 Index: 1 00000000 (348) Index: 2 00000001 (349) Index: 3 00000002 (350) Index: 4 00000003 (351) Index: 1 00000000 (348) Index: 2 00000001 (349) Index: 3 00000002 (350) Index: 4 00000003 (351) Table: 53 MediaNotification (352) Number of columns: 7 Column Identifier Name Type 1 1 00010003 Integer 32-bit signed 2 2 00020003 Integer 32-bit signed 3 3 0e090013 Integer 32-bit unsigned 4 256 b0800013 Integer 32-bit unsigned 5 257 b0810013 Integer 32-bit unsigned 6 258 b0820041 Large binary data 7 259 b08e0013 Integer 32-bit unsigned Number of indexes: 2 Index: 1 00000000 (352) Index: 2 00000001 (353) Index: 1 00000000 (352) Index: 2 00000001 (353) Table: 54 IdTable (354) Number of columns: 2 Column Identifier Name Type 1 1 01060003 Integer 32-bit signed 2 2 10a90003 Integer 32-bit signed Number of indexes: 1 Index: 1 00000000 (354) Index: 1 00000000 (354)
joachimmetz commented 4 years ago

@searay12399 thanks for that detail, unfortunately I do not see an indication if the database is dirty or not. I'll double check esedbinfo and add it if not there.

Seeing the error hint to a format related issue could you provide me with the file or format debug (see: https://github.com/libyal/libesedb/wiki/Troubleshooting#format-or-behavioral-errors) so I can take a closer look what might be causing the issue.

joachimmetz commented 4 years ago

Reminder to add information about dirty state to esedbinfo tracked in https://github.com/libyal/libesedb/issues/52.

No additional information from original reporter closing issue.