2 PATH=/bin:/usr/bin:/sbin:/usr/sbin
4 #----------------------------------------------------------------#
5 # stc-manager patch script for upgrade (4.0 -> the latest tizen) #
6 #----------------------------------------------------------------#
8 sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "ALTER TABLE restrictions RENAME COLUMN rst_state TO rstn_type;"
10 sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_lock (
11 name TEXT PRIMARY KEY,
15 sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_chains (
16 chain TEXT PRIMARY KEY,
21 sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE TABLE IF NOT EXISTS fw_rules (
22 key BIGINT PRIMARY KEY,
42 log_prefix TEXT NOT NULL,
44 nflog_prefix TEXT NOT NULL,
47 identifier TEXT NOT NULL
50 sqlite3 /opt/usr/dbspace/.stc-manager-datausage.db "CREATE INDEX IF NOT EXISTS rules_index ON fw_rules (chain, target);"