4 if [ ! -d @DATADIR@/dbspace ]
6 mkdir @DATADIR@/dbspace
9 if [ ! -f @DATADIR@/dbspace/.notification.db ]
11 sqlite3 @DATADIR@/dbspace/.notification.db 'PRAGMA journal_mode = PERSIST;
12 create table if not exists noti_list (
13 type INTEGER NOT NULL,
14 caller_pkgname TEXT NOT NULL,
17 group_id INTEGER default 0,
18 internal_group_id INTEGER default 0,
19 priv_id INTERGER NOT NULL,
24 num_format_args INTEGER default 0,
27 time INTEGER default 0,
28 insert_time INTEGER default 0,
31 b_execute_option TEXT,
32 b_service_responding TEXT,
33 b_service_single_launch TEXT,
34 b_service_multi_launch TEXT,
35 sound_type INTEGER default 0,
37 vibration_type INTEGER default 0,
39 flags_for_property INTEGER default 0,
40 flag_simmode INTEGER default 0,
41 display_applist INTEGER,
42 progress_size DOUBLE default 0,
43 progress_percentage DOUBLE default 0,
44 rowid INTEGER PRIMARY KEY AUTOINCREMENT,
45 UNIQUE (caller_pkgname, priv_id)
47 create table if not exists noti_group_data (
48 caller_pkgname TEXT NOT NULL,
49 group_id INTEGER default 0,
50 badge INTEGER default 0,
55 count_display_title INTEGER,
56 count_display_content INTEGER,
57 rowid INTEGER PRIMARY KEY AUTOINCREMENT,
58 UNIQUE (caller_pkgname, group_id)
60 create table if not exists ongoing_list (
61 caller_pkgname TEXT NOT NULL,
64 group_id INTEGER default 0,
65 internal_group_id INTEGER default 0,
66 priv_id INTERGER NOT NULL,
72 loc_default_content TEXT,
77 flag INTEGER default 0,
78 progress_size DOUBLE default 0,
79 progress_percentage DOUBLE default 0,
80 rowid INTEGER PRIMARY KEY AUTOINCREMENT,
81 UNIQUE (caller_pkgname, priv_id)
86 if [ ${USER} = "root" ]
88 chown root:5000 @DATADIR@/dbspace/.notification.db
89 chown root:5000 @DATADIR@/dbspace/.notification.db-journal
91 chmod 660 @DATADIR@/dbspace/.notification.db
92 chmod 660 @DATADIR@/dbspace/.notification.db-journal