*.db Files

From Vita Developer wiki
Jump to navigation Jump to search

.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)
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