*.db Files: Difference between revisions

From Vita Developer wiki
Jump to navigation Jump to search
mNo edit summary
Line 83: Line 83:


{| class="wikitable"
{| class="wikitable"
! style="background-color:#ffffd0; color:#123AAA;" | pageId
! style="background-color:#123AAA; color:#ffffd0;" | pageId
! style="background-color:#ffffd0; color:#123AAA;" | pos
! style="background-color:#123AAA; color:#ffffd0;" | pos
! style="background-color:#ffffd0; color:#123AAA;" | iconPath
! style="background-color:#123AAA; color:#ffffd0;" | iconPath
! style="background-color:#ffffd0; color:#123AAA;" | title
! style="background-color:#123AAA; color:#ffffd0;" | title
! style="background-color:#ffffd0; color:#123AAA;" | type
! style="background-color:#123AAA; color:#ffffd0;" | type
! style="background-color:#ffffd0; color:#123AAA;" | command
! style="background-color:#123AAA; color:#ffffd0;" | command
! style="background-color:#ffffd0; color:#123AAA;" | titleId
! style="background-color:#123AAA; color:#ffffd0;" | titleId
! style="background-color:#ffffd0; color:#123AAA;" | icon0Type
! style="background-color:#123AAA; color:#ffffd0;" | icon0Type
! style="background-color:#ffffd0; color:#123AAA;" | parentalLockLv
! style="background-color:#123AAA; color:#ffffd0;" | parentalLockLv
! style="background-color:#ffffd0; color:#123AAA;" | status
! style="background-color:#123AAA; color:#ffffd0;" | status
! style="background-color:#ffffd0; color:#123AAA;" | reserved01
! style="background-color:#123AAA; color:#ffffd0;" | reserved01
! style="background-color:#123AAA; color:#ffffd0;" | reserved02
! style="background-color:#123AAA; color:#ffffd0;" | reserved03
! style="background-color:#123AAA; color:#ffffd0;" | reserved04
! style="background-color:#123AAA; color:#ffffd0;" | reserved05
|-
! style="background-color:#ffffd0; color:#123AAA;" | Page ID on live area for the app
! style="background-color:#ffffd0; color:#123AAA;" | Position of the app icon0 on a page
! style="background-color:#ffffd0; color:#123AAA;" | icon Path partition for the app
! style="background-color:#ffffd0; color:#123AAA;" | [[System_File_Object_(SFO)_(PSF)#TITLE|TITLE]]
! style="background-color:#ffffd0; color:#123AAA;" | Value: 0 or if folder: number of apps inside it
! style="background-color:#ffffd0; color:#123AAA;" | Null
! style="background-color:#ffffd0; color:#123AAA;" | [[System_File_Object_(SFO)_(PSF)#TITLE_ID|TITLE_ID]]
! style="background-color:#ffffd0; color:#123AAA;" | Value: 5, 7 for folder
! style="background-color:#ffffd0; color:#123AAA;" | [[LiveArea:Parental_Controls|Parental Lock Level]]
! style="background-color:#ffffd0; color:#123AAA;" | 0
! style="background-color:#ffffd0; color:#123AAA;" | Unknown
! style="background-color:#ffffd0; color:#123AAA;" | reserved02
! style="background-color:#ffffd0; color:#123AAA;" | reserved02
! style="background-color:#ffffd0; color:#123AAA;" | reserved03
! style="background-color:#ffffd0; color:#123AAA;" | reserved03
! style="background-color:#ffffd0; color:#123AAA;" | reserved04
! style="background-color:#ffffd0; color:#123AAA;" | reserved04
! style="background-color:#ffffd0; color:#123AAA;" | reserved05
! 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
|-
|-
|}
|}

Revision as of 02:35, 12 December 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's purpose:
key Purpose
566916785 Type of application (gd,gda,gdb)
1299181514 Product_ID (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 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 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)
4209668781 Value for Title_ID NPXS: 0, others: 1
tbl_appinfo_icon
pageId pos iconPath title type command titleId icon0Type parentalLockLv status reserved01 reserved02 reserved03 reserved04 reserved05
Page ID on live area for the app Position of the app icon0 on a page icon Path partition for the app TITLE Value: 0 or if folder: number of apps inside it Null TITLE_ID Value: 5, 7 for folder Parental Lock Level 0 Unknown reserved02 reserved03 reserved04 reserved05
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

See main article here.

  • 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=4475"