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 (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 =====
{| class="wikitable"
| style="font-weight: bold;" | rowid
| 
|-
| style="font-weight: bold;" | id_tittle_id
| (i.e.:NPXS10072)
|-
| style="font-weight: bold;" | id_item_id
| (i.e.:EmailNewEvent)
|-
| style="font-weight: bold;" | del_flag
| 
|-
| style="font-weight: bold;" | msg_type
| (i.e.:256)
|-
| style="font-weight: bold;" | act_type
| Length:11 Numerical (i.e.:60129542146)
|-
| style="font-weight: bold;" | time_updated
| (i.e.:2015-09-27 00:02:28.634)
|-
| style="font-weight: bold;" | new_flag
| 
|-
| style="font-weight: bold;" | popup_no
| 
|-
| style="font-weight: bold;" | icon_path
| (i.e.:vs0:app/NPXS10072/sce_sys/icon0.png)
|-
| style="font-weight: bold;" | exec_mode
| 
|-
| style="font-weight: bold;" | exec_tittle_id
| (i.e.:NPXS10072)
|-
| style="font-weight: bold;" | exec_arg
| (i.e.:EmailAppLaunchFromNotificationIndicator)
|-
| style="font-weight: bold;" | title
| Tittle of notification (i.e.:You have new messages.)
|-
| style="font-weight: bold;" | desc
| Description of notification (i.e.:You have new messages.)
|-
| style="font-weight: bold;" | msg_arg0
| 
|-
| style="font-weight: bold;" | msg_arg0
| 
|-
| style="font-weight: bold;" | msg_arg2
| 
|-
| style="font-weight: bold;" | msg_arg3
| 
|-
| style="font-weight: bold;" | msg_arg4
| 
|-
| style="font-weight: bold;" | msg_arg5
| 
|-
| style="font-weight: bold;" | msg_arg6
| 
|-
| style="font-weight: bold;" | msg_arg7
| 
|-
| style="font-weight: bold;" | msg_arg8
| 
|-
| style="font-weight: bold;" | se_id
| 
|-
| style="font-weight: bold;" | se_volume
| 
|-
| style="font-weight: bold;" | hash
| Length:10 Numerical
|-
| style="font-weight: bold;" | icon_data
| 
|}

=== 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
| 
|}