.db files are database files.
test for ada
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
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
|
|