From: hyunuk.tak <hyunuk.tak@samsung.com>
Date: Tue, 17 Sep 2019 08:12:33 +0000 (+0900)
Subject: Remove to check old version from upgrade script
X-Git-Tag: accepted/tizen/unified/20190918.010348^0
X-Git-Url: http://review.tizen.org/git/?p=platform%2Fcore%2Fconnectivity%2Fstc-manager.git;a=commitdiff_plain;h=40194410f8b1589c1a3a0a6036a2976ab1a564f6

Remove to check old version from upgrade script

Change-Id: Ic6e537737db32b00d5ca625d390035e53092423d
Signed-off-by: hyunuk.tak <hyunuk.tak@samsung.com>
---

diff --git a/packaging/stc-manager.spec b/packaging/stc-manager.spec
index 2dc6918..69cbe48 100644
--- a/packaging/stc-manager.spec
+++ b/packaging/stc-manager.spec
@@ -1,6 +1,6 @@
 Name:       stc-manager
 Summary:    STC(Smart Traffic Control) manager
-Version:    0.0.95
+Version:    0.0.96
 Release:    0
 Group:      Network & Connectivity/Other
 License:    Apache-2.0
diff --git a/scripts/500.stc-manager_upgrade.sh b/scripts/500.stc-manager_upgrade.sh
index ad0c84b..7c1945e 100644
--- a/scripts/500.stc-manager_upgrade.sh
+++ b/scripts/500.stc-manager_upgrade.sh
@@ -5,48 +5,46 @@ 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 "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_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_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 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
+sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE INDEX IF NOT EXISTS rules_index ON fw_rules (chain, target);"