The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
app.db
Application Database used by SceShell for storing themes, notifications, and application metadata.
- Path: ur0:shell/db/app.db
- Size: 260~390KB
Tables
tbl_appinfo
| titleId
|
key
|
val
|
|
|
|
<Value associated to key>
|
'key' is a `fnv1a32` hash in decimal of the SFO parameter's name, here are some examples:
| key
|
Purpose
|
| 566916785
|
CATEGORY (gd, gda, gdb, gp)
|
| 1299181514
|
CONTENT_ID (i.e.: IV0001-NPXS10007_00-WELCOMEPARK01234)
|
| 2414097773
|
SUPPORT_URI (i.e.: mailto:)
|
| 3168212510
|
PSP2_SYSTEM_VER (i.e.:03.010)
|
| 278217076
|
TITLE_ID(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 6
|
pos 9
|
iconPath vs0:app/NPXS10021/sce_sys/pic0.png
|
title Ağ Operatörü
|
type 0
|
command
|
titleId NPXS10021
|
icon0Type 5
|
parentalLockLv 1
|
status 0
|
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
|
Used by folders to store the icon of the folder in a dds format. ~16.6kbyte big
|
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
|
|