*.db Files: Difference between revisions

From Vita Developer wiki
Jump to navigation Jump to search
m (app.db detailed)
mNo edit summary
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[[Category:Software]]<noinclude>[[Category:Main]]</noinclude>
.db files are database files.  
.db files are database files.  


Line 7: Line 9:


=== app.db ===
=== app.db ===
Contains paths of files used by applications.
 
See main article [[app.db|here]].
 
Contains paths of files used by applications.
* Path: ur0:shell/db/app.db
* Path: ur0:shell/db/app.db
* Size: 260~390KB
* Size: 260~390KB


==== Tables ====
=== Files.db ===
===== tbl_appinfo =====
{| class="wikitable"
! style="font-weight: bold;" | tittleId
! style="font-weight: bold;" | key
! style="font-weight: bold;" | val
|-
|
|
| <Value associated to key>
|}


* key purpose:
See main article [[Files.db|here]].
  {| class="wikitable"
! style="font-weight: bold;" | key
! style="font-weight: bold;" | 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
|-
|
|
|-
|
|
|-
|
|
|-
|
|
|-
|
|
|}


=== Files.db ===
* Path: pd0:app/NPXS10007/sce_pfs/files.db
* Path: pd0:app/NPXS10007/sce_pfs/files.db
* Size: 30KB
* Size: 30KB
Line 62: Line 25:


=== pspmtp.db ===
=== pspmtp.db ===
See main article [[pspmtp.db|here]].
* Path: ux0:mtp/pspmtp.db
* Path: ux0:mtp/pspmtp.db
* Size: 12KB
* Size: 12KB
Line 68: Line 34:
===== tbl_mtpObject =====
===== tbl_mtpObject =====
{| class="wikitable"
{| class="wikitable"
! style="font-weight: bold;" | UID
| style="font-weight: bold;" | UID
!
|
|-
|-
| style="font-weight: bold;" | ParentUID
| style="font-weight: bold;" | ParentUID

Latest revision as of 00:03, 13 August 2016


.db files are database files.

They're usually opened with SqliteBrowser

Usefull .db[edit | edit source]

app.db[edit | edit source]

See main article here.

Contains paths of files used by applications.

  • Path: ur0:shell/db/app.db
  • Size: 260~390KB

Files.db[edit | edit source]

See main article here.

  • Path: pd0:app/NPXS10007/sce_pfs/files.db
  • Size: 30KB
  • Use ListDirVita to read it.

pspmtp.db[edit | edit source]

See main article here.

  • Path: ux0:mtp/pspmtp.db
  • Size: 12KB

Tables[edit | edit source]

tbl_mtpObject[edit | edit source]
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