*.db Files: Difference between revisions

From Vita Developer wiki
Jump to navigation Jump to search
No edit summary
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
| Complete tittleId (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234)
| [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 requiered. Where:
| Minimum firmware version required (decimal to hexadecimal). Where:
   -22020096 = <Unknown>
   -22020096 = 1.500
   -50397184 = 3.010
   -50397184 = 3.010
   -51707904 = 3.15
   -51707904 = 3.15
|-
|-
| 1203824812
| 1203824812
| Displayed minimum firmware version requiered
| 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 20: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