*.db Files: Difference between revisions
Jump to navigation
Jump to search
(Creation of the page.) |
m (app.db detailed) |
||
| Line 9: | Line 9: | ||
Contains paths of files used by applications. | Contains paths of files used by applications. | ||
* Path: ur0:shell/db/app.db | * Path: ur0:shell/db/app.db | ||
* Size: | * Size: 260~390KB | ||
==== Tables ==== | ==== Tables ==== | ||
| Line 55: | Line 55: | ||
| | | | ||
|} | |} | ||
=== Files.db === | === Files.db === | ||
Revision as of 16:40, 28 September 2015
.db files are database files.
They're usually opened with SqliteBrowser
Usefull .db
app.db
Contains paths of files used by applications.
- Path: ur0:shell/db/app.db
- Size: 260~390KB
Tables
tbl_appinfo
| tittleId | key | val |
|---|---|---|
| <Value associated to key> |
- key purpose:
| key | Purpose |
|---|---|
| 566916785 | Type of application (gd,gda,gdb) |
| 1299181514 | Complete tittleId (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234) |
| 2414097773 | Application's URI (i.e.:mailto:) |
| 3168212510 | Application's version |
Files.db
- Path: pd0:app/NPXS10007/sce_pfs/files.db
- Size: 30KB
- Use ListDirVita to read it.
pspmtp.db
- Path: ux0:mtp/pspmtp.db
- Size: 12KB
Tables
tbl_mtpObject
| UID | |
|---|---|
| ParentUID | xxxxxxxxxx<Numeric> |
| ObjectFormat | xxxxx<Numeric> |
| ProtectionStatus | xxxxx<Numeric> |
| ObjectSize | |
| DateCreated | |
| DateModified | |
| FullPathName | |
| Name | ROOT |
| NonConsumable | |
| PUOID | <Non-Readable ASCII> |
| Artist | |
| Genre | |
| Album | |
| AlbumArtist | |
| UseCount | |
| SampleRate | |
| AudioWaveCodec | |
| AudioBitRate | |
| OriginalReleaseDate | |
| Duration | |
| NumberOfChannels | |
| Rating | |
| BitrateType | |
| DrmStatus | |
| Track | |
| SampleFormat | |
| Buyflag | |
| AudioBitDepth | |
| Width | |
| Height |