*.db Files: Difference between revisions

From Vita Developer wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
.db files are database files.  
.db files are database files.  
test for ada.
 
They're usually opened with [https://github.com/sqlitebrowser/sqlitebrowser/releases SqliteBrowser]  
They're usually opened with [https://github.com/sqlitebrowser/sqlitebrowser/releases SqliteBrowser]  


Line 81: Line 81:


===== tbl_appinfo_icon =====
===== tbl_appinfo_icon =====
test


===== tbl_appinfo_page =====
===== tbl_appinfo_page =====

Revision as of 09:17, 11 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)
4209668781 Value for Title_ID NPXS: 0, others: 1
tbl_appinfo_icon

test

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