*.db Files: Difference between revisions

From Vita Developer wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(2 intermediate revisions by the same user 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 ====
===== tbl_appinfo =====
{| class="wikitable"
! style="font-weight: bold;" | tittleId
! style="font-weight: bold;" | key
! style="font-weight: bold;" | val
|-
|
|
| <Value associated to key>
|}
* key's purpose:
  {| class="wikitable sortable"
! style="font-weight: bold;" | key
! style="font-weight: bold;" | Purpose
|-
| 566916785
| [[System_File_Object_(SFO)_(PSF)#CATEGORY|Type of application]] (gd,gda,gdb)
|-
| 1299181514
| [http://www.psdevwiki.com/ps4/Product_ID Product_ID] (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234)
|-
| 2414097773
| [[Title_ID|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
| [[LiveArea:Parental_Controls|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
| [[Title_ID|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)
|-
| 4209668781
| Value for [[Title_ID]] NPXS: 0, others: 1
|-
|}
===== tbl_appinfo_icon =====
{| class="wikitable"
! style="background-color:#ffffd0; color:#123AAA;" | pageId
! style="background-color:#ffffd0; color:#123AAA;" | pos
! style="background-color:#ffffd0; color:#123AAA;" | iconPath
! style="background-color:#ffffd0; color:#123AAA;" | title
! style="background-color:#ffffd0; color:#123AAA;" | type
! style="background-color:#ffffd0; color:#123AAA;" | command
! style="background-color:#ffffd0; color:#123AAA;" | titleId
! style="background-color:#ffffd0; color:#123AAA;" | icon0Type
! style="background-color:#ffffd0; color:#123AAA;" | parentalLockLv
! style="background-color:#ffffd0; color:#123AAA;" | status
! style="background-color:#ffffd0; color:#123AAA;" | reserved01
! style="background-color:#ffffd0; color:#123AAA;" | reserved02
! style="background-color:#ffffd0; color:#123AAA;" | reserved03
! style="background-color:#ffffd0; color:#123AAA;" | reserved04
! style="background-color:#ffffd0; color:#123AAA;" | reserved05
|-
! style="background-color:#ffffff; color:#123AAA;" | Page Id on live area for the app
! style="background-color:#ffffff; color:#123AAA;" | Position of the app icon0
! style="background-color:#ffffff; color:#123AAA;" | icon Path partition for the app
! style="background-color:#ffffff; color:#123AAA;" | title
! style="background-color:#ffffff; color:#123AAA;" | Value: 0 or if folder: number of apps inside it
! style="background-color:#ffffff; color:#123AAA;" | Null
! style="background-color:#ffffff; color:#123AAA;" | title Id
! style="background-color:#ffffff; color:#123AAA;" | Value: 5, 7 for folder
! style="background-color:#ffffff; color:#123AAA;" | Parental Lock Level
! style="background-color:#ffffff; color:#123AAA;" | 0
! style="background-color:#ffffff; color:#123AAA;" | Unknown
! style="background-color:#ffffff; color:#123AAA;" | reserved02
! style="background-color:#ffffff; color:#123AAA;" | reserved03
! style="background-color:#ffffff; color:#123AAA;" | reserved04
! style="background-color:#ffffff; color:#123AAA;" | reserved05
|-
|}
===== 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 ===
=== Files.db ===
Line 223: 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

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