App.db: Difference between revisions

From Vita Developer wiki
Jump to navigation Jump to search
Line 7: Line 7:


==== Tables ====
==== Tables ====
===== tbl_appinfo =====
===== tbl_appinfo =====
{| class="wikitable"
{| class="wikitable"
! style="font-weight: bold;" | tittleId
! style="font-weight: bold;" | titleId
! style="font-weight: bold;" | key
! style="font-weight: bold;" | key
! style="font-weight: bold;" | val
! style="font-weight: bold;" | val
Line 27: Line 28:
|-
|-
| 1299181514
| 1299181514
| [http://www.psdevwiki.com/ps4/Product_ID Product_ID] (i.e.:IV0001-NPXS10007_00-WELCOMEPARK01234)
| [http://www.psdevwiki.com/ps4/Product_ID Product_ID] (i.e.: IV0001-NPXS10007_00-WELCOMEPARK01234)
|-
|-
| 2414097773
| 2414097773
| [[Title_ID|Application's URI]] (i.e.:mailto:)
| Application's URI (i.e.: mailto:)
|-
|-
| 3168212510
| 3168212510
Line 36: Line 37:
|-
|-
| 278217076
| 278217076
| TittleID (i.e.: NPXS10007)
| TitleID (i.e.: NPXS10007)
|-
|-
| 3794959877
| 3794959877
Line 48: Line 49:
|-
|-
| 904872283
| 904872283
| TittleID (i.e.:NPXS10007)
| TitleID (i.e.: NPXS10007)
|-
|-
| 2275227917
| 2275227917
Line 54: Line 55:
|-
|-
| 3022202214
| 3022202214
| eboot.bin path (i.e.:vs0:app/NPXS10077/eboot.bin)
| eboot.bin path (i.e.: vs0:app/NPXS10077/eboot.bin)
|-
|-
| 2593862978
| 2593862978
| Main directory of an application (i.e.:vs0:app/NPXS10077)
| Main directory of an application (i.e.: vs0:app/NPXS10077)
|-
|-
| 966797424
| 966797424
Line 67: Line 68:
| 1729228973
| 1729228973
| Icon path  
| Icon path  
   (i.e.:vs0:app/NPXS10077/sce_sys/pic0.png)
   (i.e.: vs0:app/NPXS10077/sce_sys/pic0.png)
   (i.e.:ur0:appmeta/PCSI00009/pic0.png)
   (i.e.: ur0:appmeta/PCSI00009/pic0.png)
|-
|-
| 4209668781
| 4209668781
Line 109: Line 110:
! 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
|-
|}
|}


Line 123: Line 123:


===== tbl_newevent =====
===== tbl_newevent =====
{| class="wikitable"
{| class="wikitable"
| style="font-weight: bold;" | rowid
| style="font-weight: bold;" | rowid
|  
|  
|-
|-
| style="font-weight: bold;" | id_tittle_id
| style="font-weight: bold;" | id_title_id
| (i.e.:NPXS10072)
| (i.e.: NPXS10072)
|-
|-
| style="font-weight: bold;" | id_item_id
| style="font-weight: bold;" | id_item_id
| (i.e.:EmailNewEvent)
| (i.e.: EmailNewEvent)
|-
|-
| style="font-weight: bold;" | del_flag
| style="font-weight: bold;" | del_flag
Line 140: Line 141:
|-
|-
| style="font-weight: bold;" | act_type
| style="font-weight: bold;" | act_type
| Length:11 Numerical (i.e.:60129542146)
| Length: 11 Numerical (i.e.: 60129542146)
|-
|-
| style="font-weight: bold;" | time_updated
| style="font-weight: bold;" | time_updated
| (i.e.:2015-09-27 00:02:28.634)
| (i.e.: 2015-09-27 00:02:28.634)
|-
|-
| style="font-weight: bold;" | new_flag
| style="font-weight: bold;" | new_flag
Line 152: Line 153:
|-
|-
| style="font-weight: bold;" | icon_path
| style="font-weight: bold;" | icon_path
| (i.e.:vs0:app/NPXS10072/sce_sys/icon0.png)
| (i.e.: vs0:app/NPXS10072/sce_sys/icon0.png)
|-
|-
| style="font-weight: bold;" | exec_mode
| style="font-weight: bold;" | exec_mode
|  
|  
|-
|-
| style="font-weight: bold;" | exec_tittle_id
| style="font-weight: bold;" | exec_title_id
| (i.e.:NPXS10072)
| (i.e.: NPXS10072)
|-
|-
| style="font-weight: bold;" | exec_arg
| style="font-weight: bold;" | exec_arg
| (i.e.:EmailAppLaunchFromNotificationIndicator)
| (i.e.: EmailAppLaunchFromNotificationIndicator)
|-
|-
| style="font-weight: bold;" | title
| style="font-weight: bold;" | title
| Tittle of notification (i.e.:You have new messages.)
| Title of notification (i.e.: You have new messages.)
|-
|-
| style="font-weight: bold;" | desc
| style="font-weight: bold;" | desc
| Description of notification (i.e.:You have new messages.)
| Description of notification (i.e.: You have new messages.)
|-
|-
| style="font-weight: bold;" | msg_arg0
| style="font-weight: bold;" | msg_arg0
Line 206: Line 207:
|-
|-
| style="font-weight: bold;" | icon_data
| style="font-weight: bold;" | icon_data
|
|}
|}

Revision as of 21:16, 3 April 2018


app.db

Contains paths of files used by applications.
  • Path: ur0:shell/db/app.db
  • Size: 260~390KB

Tables

tbl_appinfo
titleId key val
<Value associated to key>
  • key's purpose:
key Purpose
566916785 Type of application (gd, gda, gdb, gp)
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 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 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_title_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_title_id (i.e.: NPXS10072)
exec_arg (i.e.: EmailAppLaunchFromNotificationIndicator)
title Title 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
Retrieved from "http://www.psdevwiki.com/vita/index.php?title=App.db&oldid=5899"