*.db Files: Difference between revisions

From Vita Developer wiki
Jump to navigation Jump to search
No edit summary
Line 24: Line 24:


* key purpose:
* key purpose:
   {| class="wikitable sortable"
   {| class="wikitable"
! style="font-weight: bold;" | key
! style="font-weight: bold;" | key
! style="font-weight: bold;" | Purpose
! style="font-weight: bold;" | Purpose
Line 38: Line 38:
|-
|-
| 3168212510
| 3168212510
| Application's version
| Application's version (i.e.:03.010)
|-
|-
| 278217076
| 278217076
Line 46: Line 46:
| Minimum firmware version requiered. Where:
| Minimum firmware version requiered. Where:
   -22020096 = <Unknown>
   -22020096 = <Unknown>
   -50397184 = 3.01
   -50397184 = 3.010
   -51707904 = 3.15
   -51707904 = 3.15
|-
|-
Line 57: Line 57:
| 2275227917
| 2275227917
| Parental Control Level
| 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)
|}
|}


Revision as of 10:06, 1 October 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 purpose:
key Purpose
566916785 Type of application (gd,gda,gdb)
1299181514 Complete tittleId (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 requiered. Where: 
 -22020096 = <Unknown>
 -50397184 = 3.010
 -51707904 = 3.15
1203824812 Displayed minimum firmware version requiered
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
Retrieved from "http://www.psdevwiki.com/vita/index.php?title=*.db_Files&oldid=4412"