.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
|
| 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)
|
| 4209668781
|
Value for Title_ID NPXS: 0, others: 1
|
tbl_appinfo_icon
| pageId
|
pos
|
iconPath
|
title
|
type
|
command
|
titleId
|
icon0Type
|
parentalLockLv
|
status
|
reserved01
|
reserved02
|
reserved03
|
reserved04
|
reserved05
|
| Page ID on live area for the app
|
Position of the app icon0 on a page
|
icon Path partition for the app
|
TITLE
|
Value: 0 or if folder: number of apps inside it
|
Null
|
TITLE_ID
|
Value: 5, 7 for folder
|
Parental Lock Level
|
0
|
Unknown
|
reserved02
|
reserved03
|
reserved04
|
reserved05
|
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
See main article here.
- 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
|
|