Editing *.db Files

.db files are database files. 

They're usually opened with [https://github.com/sqlitebrowser/sqlitebrowser/releases SqliteBrowser] 

== Usefull .db ==


=== app.db ===
 Contains paths of files used by applications.
* Path: ur0:shell/db/app.db
* Size: 260~390KB

==== Tables ====
===== 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:
  {| 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
* Size: 30KB
* Use [[Tools|ListDirVita]] to read it.

=== pspmtp.db ===
* Path: ux0:mtp/pspmtp.db
* Size: 12KB

==== Tables ====
===== tbl_mtpObject =====
{| class="wikitable"
! style="font-weight: bold;" | UID
! 
|-
| style="font-weight: bold;" | ParentUID
| xxxxxxxxxx<Numeric>
|-
| style="font-weight: bold;" | ObjectFormat
| xxxxx<Numeric>
|-
| style="font-weight: bold;" | ProtectionStatus
| xxxxx<Numeric>
|-
| style="font-weight: bold;" | ObjectSize
| 
|-
| style="font-weight: bold;" | DateCreated
| 
|-
| style="font-weight: bold;" | DateModified
| 
|-
| style="font-weight: bold;" | FullPathName
| 
|-
| style="font-weight: bold;" | Name
| ROOT
|-
| style="font-weight: bold;" | NonConsumable
| 
|-
| style="font-weight: bold;" | PUOID
| <Non-Readable ASCII>
|-
| style="font-weight: bold;" | Artist
| 
|-
| style="font-weight: bold;" | Genre
| 
|-
| style="font-weight: bold;" | Album
| 
|-
| style="font-weight: bold;" | AlbumArtist
| 
|-
| style="font-weight: bold;" | UseCount
| 
|-
| style="font-weight: bold;" | SampleRate
| 
|-
| style="font-weight: bold;" | AudioWaveCodec
| 
|-
| style="font-weight: bold;" | AudioBitRate
| 
|-
| style="font-weight: bold;" | OriginalReleaseDate
| 
|-
| style="font-weight: bold;" | Duration
| 
|-
| style="font-weight: bold;" | NumberOfChannels
| 
|-
| style="font-weight: bold;" | Rating
| 
|-
| style="font-weight: bold;" | BitrateType
| 
|-
| style="font-weight: bold;" | DrmStatus
| 
|-
| style="font-weight: bold;" | Track
| 
|-
| style="font-weight: bold;" | SampleFormat
| 
|-
| style="font-weight: bold;" | Buyflag
| 
|-
| style="font-weight: bold;" | AudioBitDepth
| 
|-
| style="font-weight: bold;" | Width
| 
|-
| style="font-weight: bold;" | Height
| 
|}