Fix upgrade scriptssubmit/tizen_3.0/20170613.053340accepted/tizen/3.0/wearable/20170614.000330accepted/tizen/3.0/tv/20170614.000325accepted/tizen/3.0/mobile/20170614.000321accepted/tizen/3.0/ivi/20170614.000334accepted/tizen/3.0/common/20170614.124910accepted/tizen_3.0_wearableaccepted/tizen_3.0_tvaccepted/tizen_3.0_mobileaccepted/tizen_3.0_iviaccepted/tizen_3.0_common

Signed-off-by: Seungha Son <seungha.son@samsung.com>
Change-Id: Id84cdc9f9678bb7028560c760746b5078c8f1594

1 files changed, 12 insertions, 58 deletions

diff --git a/scripts/505.notification_upgrade.sh b/scripts/505.notification_upgrade.sh
index f57d2ff..5b9069e 100644
--- a/scripts/505.notification_upgrade.sh
+++ b/scripts/505.notification_upgrade.sh
@@ -46,6 +46,7 @@ CREATE TABLE noti_list_temp (
 	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,
@@ -60,7 +61,14 @@ CREATE TABLE noti_list_temp (
 	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) \
@@ -103,64 +111,10 @@ 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;
-
-DROP TABLE IF EXISTS noti_template;
-CREATE TABLE noti_template (
-	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,
-	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,
-	auto_remove INTEGER default 1,
-	uid INTEGER,
-	template_name TEXT,
-	UNIQUE (caller_pkgname, template_name)
-);
 EOF
 
-chown owner:users $DB_NOTIFICATION
-chown owner:users $DB_NOTIFICATION-journal
+chown app_fw:app_fw $DB_NOTIFICATION
+chown app_fw:app_fw $DB_NOTIFICATION-journal
 
-chsmack -a User::Home $DB_NOTIFICATION
-chsmack -a User::Home $DB_NOTIFICATION-journal
+chsmack -a System $DB_NOTIFICATION
+chsmack -a System $DB_NOTIFICATION-journal