1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
#!/bin/sh
#------------------------------------------#
# notification patch for upgrade (2.4 -> 3.0) #
#------------------------------------------#
# Macro
PATH=/bin:/usr/bin:/sbin:/usr/sbin
DB_DIR=/opt/dbspace
DB_NOTIFICATION=$DB_DIR/.notification.db
sqlite3 $DB_NOTIFICATION << EOF
DROP TABLE IF EXISTS noti_list_temp;
CREATE TABLE noti_list_temp (
type INTEGER NOT NULL,
layout INTEGER NOT NULL default 0,
caller_pkgname TEXT NOT NULL,
launch_pkgname TEXT,
image_path TEXT,
group_id INTEGER default 0,
internal_group_id INTEGER default 0,
priv_id INTEGER PRIMARY KEY AUTOINCREMENT,
title_key TEXT,
b_text TEXT,
b_key TEXT,
tag TEXT,
b_format_args TEXT,
num_format_args INTEGER default 0,
text_domain TEXT,
text_dir TEXT,
time INTEGER default 0,
insert_time INTEGER default 0,
args TEXT,
group_args TEXT,
b_execute_option TEXT,
b_service_responding TEXT,
b_service_single_launch TEXT,
b_service_multi_launch TEXT,
b_event_handler_click_on_button_1 TEXT,
b_event_handler_click_on_button_2 TEXT,
b_event_handler_click_on_button_3 TEXT,
b_event_handler_click_on_button_4 TEXT,
b_event_handler_click_on_button_5 TEXT,
b_event_handler_click_on_button_6 TEXT,
b_event_handler_click_on_icon TEXT,
b_event_handler_click_on_thumbnail TEXT,
b_event_handler_click_on_text_input_button TEXT,
sound_type INTEGER default 0,
sound_path TEXT,
vibration_type INTEGER default 0,
vibration_path TEXT,
led_operation INTEGER default 0,
led_argb INTEGER default 0,
led_on_ms INTEGER default -1,
led_off_ms INTEGER default -1,
flags_for_property INTEGER default 0,
flag_simmode INTEGER default 0,
display_applist INTEGER,
progress_size DOUBLE default 0,
progress_percentage DOUBLE default 0,
ongoing_flag INTEGER default 0,
ongoing_value_type INTEGER default 0,
ongoing_current INTEGER default 0,
ongoing_duration INTEGER default 0,
auto_remove INTEGER default 1,
default_button_index INTEGER default 0,
timeout INTEGER default 0,
text_input_max_length INTEGER default 0,
event_flag INTEGER default 0,
uid INTEGER
);
INSERT INTO noti_list_temp (type, layout, caller_pkgname, launch_pkgname, image_path, group_id, internal_group_id, priv_id, title_key, b_text, b_key, tag, b_format_args, num_format_args, text_domain, text_dir, time, insert_time, args, group_args, b_execute_option, b_service_responding, b_service_single_launch, b_service_multi_launch, b_event_handler_click_on_button_1, b_event_handler_click_on_button_2, b_event_handler_click_on_button_3, b_event_handler_click_on_button_4, b_event_handler_click_on_button_5, b_event_handler_click_on_button_6, b_event_handler_click_on_icon, b_event_handler_click_on_thumbnail, sound_type, sound_path, vibration_type, vibration_path, led_operation, led_argb, led_on_ms, led_off_ms, flags_for_property, flag_simmode, display_applist, progress_size, progress_percentage, ongoing_flag, auto_remove) \
SELECT type, layout, caller_pkgname, launch_pkgname, image_path, group_id, internal_group_id, priv_id, title_key, b_text, b_key, tag, b_format_args, num_format_args, text_domain, text_dir, time, insert_time, args, group_args, b_execute_option, b_service_responding, b_service_single_launch, b_service_multi_launch, b_event_handler_click_on_button_1, b_event_handler_click_on_button_2, b_event_handler_click_on_button_3, b_event_handler_click_on_button_4, b_event_handler_click_on_button_5, b_event_handler_click_on_button_6, b_event_handler_click_on_icon, b_event_handler_click_on_thumbnail, sound_type, sound_path, vibration_type, vibration_path, led_operation, led_argb, led_on_ms, led_off_ms, flags_for_property, flag_simmode, display_applist, progress_size, progress_percentage, ongoing_flag, auto_remove FROM noti_list;
UPDATE noti_list_temp SET uid=5001;
DROP TABLE noti_list;
ALTER TABLE noti_list_temp RENAME TO noti_list;
DROP TABLE IF EXISTS notification_setting;
CREATE TABLE notification_setting (
uid INTEGER,
package_name TEXT NOT NULL,
appid TEXT NOT NULL,
allow_to_notify INTEGER DEFAULT 1,
do_not_disturb_except INTEGER DEFAULT 0,
visibility_class INTEGER DEFAULT 0,
pop_up_notification INTEGER DEFAULT 1,
lock_screen_content_level INTEGER DEFAULT 0,
app_disabled INTEGER DEFAULT 0,
UNIQUE (uid, package_name, appid)
);
DROP TABLE IF EXISTS notification_system_setting_temp;
CREATE TABLE notification_system_setting_temp (
uid INTEGER,
do_not_disturb INTEGER DEFAULT 0,
visibility_class INTEGER DEFAULT 0,
dnd_schedule_enabled INTEGER DEFAULT 0,
dnd_schedule_day INTEGER DEFAULT 0,
dnd_start_hour INTEGER DEFAULT 0,
dnd_start_min INTEGER DEFAULT 0,
dnd_end_hour INTEGER DEFAULT 0,
dnd_end_min INTEGER DEFAULT 0,
lock_screen_content_level INTEGER DEFAULT 0,
UNIQUE (uid)
);
INSERT INTO notification_system_setting_temp (do_not_disturb, visibility_class) \
SELECT do_not_disturb, visibility_class FROM notification_system_setting;
UPDATE notification_system_setting_temp SET uid=5001;
DROP TABLE notification_system_setting;
ALTER TABLE notification_system_setting_temp RENAME TO notification_system_setting;
EOF
chown app_fw:app_fw $DB_NOTIFICATION
chown app_fw:app_fw $DB_NOTIFICATION-journal
chsmack -a System $DB_NOTIFICATION
chsmack -a System $DB_NOTIFICATION-journal
|