Editing App.db

[[Category:Software]]<noinclude>[[Category:Main]]</noinclude>

=== 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;" | titleId
! style="font-weight: bold;" | key
! style="font-weight: bold;" | val
|-
| 
| 
| <Value associated to key>
|}

* key's purpose:
'key' is a `fnv1a32` hash of the SFO parameter's name, here are some examples:   
  {| 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, gp)
|-
| 1299181514
| [http://www.psdevwiki.com/ps4/Product_ID Product_ID] (i.e.: IV0001-NPXS10007_00-WELCOMEPARK01234)
|-
| 2414097773
| Application's URI (i.e.: mailto:)
|-
| 3168212510
| Application's version (i.e.:03.010)
|-
| 278217076
| TitleID (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
| TitleID (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;" | 5 for an App or 7 for a 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;" | Used for folders to save the pageId of there content
! 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;" | Used by folders to store the icon of the folder in a dds format. ~16.6kbyte big
|}

===== tbl_appinfo_page =====

{| class="wikitable"
! style="background-color:#123AAA; color:#ffffd0;" | pageId
! style="background-color:#123AAA; color:#ffffd0;" | pageNo
! style="background-color:#123AAA; color:#ffffd0;" | themeFile
! style="background-color:#123AAA; color:#ffffd0;" | bgColor
! style="background-color:#123AAA; color:#ffffd0;" | texWidth
! style="background-color:#123AAA; color:#ffffd0;" | texHeight
! style="background-color:#123AAA; color:#ffffd0;" | imageWidth
! style="background-color:#123AAA; color:#ffffd0;" | imageHeight
! 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 used to identify pages with apps
! style="background-color:#ffffd0; color:#123AAA;" | Position of the Page from 0-9 (max number of Pages is 10). For Folders it is a negative value with a leading "-1" followed by 7 digits.
! style="background-color:#ffffd0; color:#123AAA;" | -
! style="background-color:#ffffd0; color:#123AAA;" | Color of the Background. Value between 0-30
! style="background-color:#ffffd0; color:#123AAA;" | -
! style="background-color:#ffffd0; color:#123AAA;" | -
! style="background-color:#ffffd0; color:#123AAA;" | -
! style="background-color:#ffffd0; color:#123AAA;" | -
! style="background-color:#ffffd0; color:#123AAA;" | -
! style="background-color:#ffffd0; color:#123AAA;" | NULL
! style="background-color:#ffffd0; color:#123AAA;" | NULL
! style="background-color:#ffffd0; color:#123AAA;" | NULL
! style="background-color:#ffffd0; color:#123AAA;" | NULL
|}

===== tbl_config =====

===== tbl_livearea =====

===== tbl_livearea_file =====

===== tbl_livearea_frame =====

===== tbl_newevent =====

{| class="wikitable"
| style="font-weight: bold;" | rowid
| 
|-
| style="font-weight: bold;" | id_title_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_title_id
| (i.e.: NPXS10072)
|-
| style="font-weight: bold;" | exec_arg
| (i.e.: EmailAppLaunchFromNotificationIndicator)
|-
| style="font-weight: bold;" | title
| Title 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
|
|}