*.db Files: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
m (→tbl_appinfo) |
||
| Line 29: | Line 29: | ||
|- | |- | ||
| 566916785 | | 566916785 | ||
| Type of application (gd,gda,gdb) | | [[System_File_Object_(SFO)_(PSF)#CATEGORY|Type of application]] (gd,gda,gdb) | ||
|- | |- | ||
| 1299181514 | | 1299181514 | ||
| | | [http://www.psdevwiki.com/ps4/Product_ID Product_ID] (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234) | ||
|- | |- | ||
| 2414097773 | | 2414097773 | ||
| Application's URI (i.e.:mailto:) | | [[Title_ID|Application's URI]] (i.e.:mailto:) | ||
|- | |- | ||
| 3168212510 | | 3168212510 | ||
| Line 44: | Line 44: | ||
|- | |- | ||
| 3794959877 | | 3794959877 | ||
| Minimum firmware version | | Minimum firmware version required (decimal to hexadecimal). Where: | ||
-22020096 = | -22020096 = 1.500 | ||
-50397184 = 3.010 | -50397184 = 3.010 | ||
-51707904 = 3.15 | -51707904 = 3.15 | ||
|- | |- | ||
| 1203824812 | | 1203824812 | ||
| Displayed minimum firmware version | | Displayed minimum firmware version required | ||
|- | |- | ||
| 904872283 | | 904872283 | ||
| Line 56: | Line 56: | ||
|- | |- | ||
| 2275227917 | | 2275227917 | ||
| Parental Control Level | | [[LiveArea:Parental_Controls|Parental Control Level]] | ||
|- | |- | ||
| 3022202214 | | 3022202214 | ||
| Line 65: | Line 65: | ||
|- | |- | ||
| 966797424 | | 966797424 | ||
| URI for near's manual (sceman:near) | | [[Title_ID|URI]] for near's manual (sceman:near) | ||
|- | |- | ||
| 2630610402 | | 2630610402 | ||
Revision as of 19:43, 10 December 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's purpose:
| key | Purpose |
|---|---|
| 566916785 | Type of application (gd,gda,gdb) |
| 1299181514 | Product_ID (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234) |
| 2414097773 | Application's URI (i.e.:mailto:) |
| 3168212510 | Application's version (i.e.:03.010) |
| 278217076 | TittleID (i.e.: NPXS10007) |
| 3794959877 | Minimum firmware version required (decimal to hexadecimal). Where:
-22020096 = 1.500 -50397184 = 3.010 -51707904 = 3.15 |
| 1203824812 | Displayed minimum firmware version required |
| 904872283 | TittleID (i.e.:NPXS10007) |
| 2275227917 | Parental Control Level |
| 3022202214 | eboot.bin path (i.e.:vs0:app/NPXS10077/eboot.bin) |
| 2593862978 | Main directory of an application (i.e.:vs0:app/NPXS10077) |
| 966797424 | URI for near's manual (sceman:near) |
| 2630610402 | Livearea stuff path (i.e.:vs0:app/NPXS10077/sce_sys/livearea) |
| 1729228973 | Icon path
(i.e.:vs0:app/NPXS10077/sce_sys/pic0.png) (i.e.:ur0:appmeta/PCSI00009/pic0.png) |
tbl_appinfo_icon
tbl_appinfo_page
tbl_config
tbl_livearea
tbl_livearea_file
tbl_livearea_frame
tbl_newevent
| rowid | |
| id_tittle_id | (i.e.:NPXS10072) |
| id_item_id | (i.e.:EmailNewEvent) |
| del_flag | |
| msg_type | (i.e.:256) |
| act_type | Length:11 Numerical (i.e.:60129542146) |
| time_updated | (i.e.:2015-09-27 00:02:28.634) |
| new_flag | |
| popup_no | |
| icon_path | (i.e.:vs0:app/NPXS10072/sce_sys/icon0.png) |
| exec_mode | |
| exec_tittle_id | (i.e.:NPXS10072) |
| exec_arg | (i.e.:EmailAppLaunchFromNotificationIndicator) |
| title | Tittle of notification (i.e.:You have new messages.) |
| desc | Description of notification (i.e.:You have new messages.) |
| msg_arg0 | |
| msg_arg0 | |
| msg_arg2 | |
| msg_arg3 | |
| msg_arg4 | |
| msg_arg5 | |
| msg_arg6 | |
| msg_arg7 | |
| msg_arg8 | |
| se_id | |
| se_volume | |
| hash | Length:10 Numerical |
| icon_data |
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 |