Editing *.db Files

Jump to navigation Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 9: Line 9:


=== app.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'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:#123AAA; color:#ffffd0;" | pageId
! style="background-color:#123AAA; color:#ffffd0;" | pos
! style="background-color:#123AAA; color:#ffffd0;" | iconPath
! style="background-color:#123AAA; color:#ffffd0;" | title
! style="background-color:#123AAA; color:#ffffd0;" | type
! style="background-color:#123AAA; color:#ffffd0;" | command
! style="background-color:#123AAA; color:#ffffd0;" | titleId
! style="background-color:#123AAA; color:#ffffd0;" | icon0Type
! style="background-color:#123AAA; color:#ffffd0;" | parentalLockLv
! style="background-color:#123AAA; color:#ffffd0;" | status
! 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;" | reserved03
! style="background-color:#ffffd0; color:#123AAA;" | reserved04
! style="background-color:#ffffd0; color:#123AAA;" | reserved05
|-
|}
===== tbl_appinfo_page =====
===== tbl_config =====
===== tbl_livearea =====
===== tbl_livearea_file =====


See main article [[app.db|here]].
===== tbl_livearea_frame =====


Contains paths of files used by applications.
===== tbl_newevent =====
* Path: ur0:shell/db/app.db
{| class="wikitable"
* Size: 260~390KB
| 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 25: Line 225:


=== pspmtp.db ===
=== pspmtp.db ===
See main article [[pspmtp.db|here]].
* Path: ux0:mtp/pspmtp.db
* Path: ux0:mtp/pspmtp.db
* Size: 12KB
* Size: 12KB
Please note that all contributions to Vita Developer wiki are considered to be released under the GNU Free Documentation License 1.2 (see Vita Developer wiki:Copyrights for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following hCaptcha:

Cancel Editing help (opens in new window)
Retrieved from "http://www.psdevwiki.com/vita/*.db_Files"