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
|
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
|
5 for an App or 7 for a folder
|
Parental Lock Level
|
0
|
Used for folders to save the pageId of there content
|
reserved02
|
reserved03
|
reserved04
|
reserved05
|
tbl_appinfo_page
| pageId
|
pageNo
|
themeFile
|
bgColor
|
texWidth
|
texHeight
|
imageWidth
|
imageHeight
|
reserved01
|
reserved02
|
reserved03
|
reserved04
|
reserved05
|
| Page ID used to identify pages with apps
|
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.
|
-
|
Color of the Background. Value between 0-30
|
-
|
-
|
-
|
-
|
-
|
NULL
|
NULL
|
NULL
|
NULL
|
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
|
|