Type SQLite Sample
Jump to navigation
Jump to search
| Defined Constant | Type_SQLite_Sample
|
| File Type Value | 450 |
| Parent Type | ASCII Text |
| Carve | Yes |
| Format Details | No |
| MIME Type | text/plain
|
| Filename Extension | txt
|
SQLite Sample
Description
A sample of the data in a SQLite database
Details
This is a text file with information about the tables, rows and data in a SQLite file. The first section will contain information about the file itself, MD5 hash, size, deleted records, etc. The remaining sections contain the first 100 rows of data from a table in the database. These sections are sorted by table name.
Sample
SQLite Sample for AddressBookImages.sqlitedb
Hash: da082818ee3109d4e4d5154502961136
Truxton Schema ID: 0f2d3f8a-19fd-bd5e-ea1b-f2e890100d83
Number of Tables: 3
Contains Deleted Records: No
Created: 1601-01-01T00:00:00Z
Modified: 2021-10-14T11:53:42Z
Size: 262,144 (256.00KB)
1. Table: ABFullSizeImage, 6 columns, 2 rows
"ROWID","record_id","crop_x","crop_y","crop_width","data"
"1","2","0","0","333",
"2","3","0","0","333",
2. Table: ABThumbnailImage, 5 columns, 6 rows
"ROWID","record_id","format","derived_from_format","data"
"1","2","0","2",
"2","3","0","2",
"3","3","4","2",
"4","2","4","2",
"5","2","5","2",
"6","3","5","2",
3. Table: _SqliteDatabaseProperties, 2 columns, 3 rows
"key","value"
"_ClientVersion","8"
"_UniqueIdentifier","AEC2D90B-93ED-4058-9FFB-812253D05E7B"
"__CPRecordSequenceNumber","62"
