# 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);"