From 6f2558cb5a4c1e4b7c2d3137cc6d1e67d587f153 Mon Sep 17 00:00:00 2001
From: "hyunuk.tak" <hyunuk.tak@samsung.com>
Date: Mon, 12 Aug 2019 10:48:52 +0900
Subject: [PATCH] Add os upgrade file for database

Change-Id: Ia679c169d26d8e9163d385362c08875776abc2ce
Signed-off-by: hyunuk.tak <hyunuk.tak@samsung.com>
---
 packaging/stc-manager.spec         |  8 ++++++
 scripts/500.stc-manager_upgrade.sh | 52 ++++++++++++++++++++++++++++++++++++++
 2 files changed, 60 insertions(+)
 create mode 100644 scripts/500.stc-manager_upgrade.sh

diff --git a/packaging/stc-manager.spec b/packaging/stc-manager.spec
index 30d4919..2ed5dc0 100644
--- a/packaging/stc-manager.spec
+++ b/packaging/stc-manager.spec
@@ -10,6 +10,8 @@ Source0:    %{name}-%{version}.tar.gz
 %define enable_statistics YES
 %define enable_restriction YES
 %define database_full_path /opt/usr/dbspace/.stc-manager-datausage.db
+%define upgrade_script_filename 500.stc-manager_upgrade.sh
+%define upgrade_script_path /usr/share/upgrade/scripts
 
 BuildRequires:  cmake
 BuildRequires:  pkgconfig(glib-2.0)
@@ -143,6 +145,10 @@ cp resources/dbus/stc-manager.conf %{buildroot}%{_sysconfdir}/dbus-1/system.d/st
 mkdir -p %{buildroot}%{_datadir}/dbus-1/system-services/
 cp resources/dbus/net.stc-manager.service %{buildroot}%{_datadir}/dbus-1/system-services/net.stc-manager.service
 
+#OS Upgrade
+mkdir -p %{buildroot}%{upgrade_script_path}
+cp -f scripts/%{upgrade_script_filename} %{buildroot}%{upgrade_script_path}
+
 %files
 %manifest %{name}.manifest
 %license LICENSE
@@ -168,6 +174,8 @@ cp resources/dbus/net.stc-manager.service %{buildroot}%{_datadir}/dbus-1/system-
 %{_bindir}/gtest*
 %endif
 
+%{upgrade_script_path}/%{upgrade_script_filename}
+
 %files plugin-appstatus
 %manifest %{name}.manifest
 %attr(644, -,-) %{_datadir}/icons/*.png
diff --git a/scripts/500.stc-manager_upgrade.sh b/scripts/500.stc-manager_upgrade.sh
new file mode 100644
index 0000000..ad0c84b
--- /dev/null
+++ b/scripts/500.stc-manager_upgrade.sh
@@ -0,0 +1,52 @@
+#!/bin/sh
+PATH=/bin:/usr/bin:/sbin:/usr/sbin
+
+#----------------------------------------------------------------#
+# stc-manager patch script for upgrade (4.0 -> the latest tizen) #
+#----------------------------------------------------------------#
+
+if [ "$OLD_VER" = "4.0.0.0" ]; then
+	sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "alter table restrictions rename column rst_state to rstn_type;"
+
+	sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_lock (
+	  name TEXT PRIMARY KEY,
+	  state INT
+	);"
+
+	sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_chains (
+	  chain TEXT PRIMARY KEY,
+	  target INT,
+	  priority INT
+	);"
+
+	sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_rules (
+	  key BIGINT PRIMARY KEY,
+	  chain TEXT NOT NULL,
+	  direction INT,
+	  s_ip_type INT,
+	  d_ip_type INT,
+	  s_port_type INT,
+	  d_port_type INT,
+	  protocol INT,
+	  family INT,
+	  s_ip1 TEXT NOT NULL,
+	  s_ip2 TEXT NOT NULL,
+	  d_ip1 TEXT NOT NULL,
+	  d_ip2 TEXT NOT NULL,
+	  s_port1 INT,
+	  s_port2 INT,
+	  d_port1 INT,
+	  d_port2 INT,
+	  ifname TEXT NOT NULL,
+	  target INT,
+	  log_level INT,
+	  log_prefix TEXT NOT NULL,
+	  nflog_group INT,
+	  nflog_prefix TEXT NOT NULL,
+	  nflog_range INT,
+	  nflog_threshold INT,
+	  identifier TEXT NOT NULL
+	);"
+
+	sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE INDEX IF NOT EXISTS rules_index ON fw_rules (chain, target);"
+fi
-- 
2.7.4