1 PRAGMA journal_mode = PERSIST;
2 PRAGMA user_version = 1;
4 CREATE TABLE IF NOT EXISTS statistics (
5 id INTEGER PRIMARY KEY AUTOINCREMENT,
12 hw_net_protocol_type INT,
18 CREATE TABLE IF NOT EXISTS restrictions (
19 restriction_id INTEGER PRIMARY KEY AUTOINCREMENT,
25 subscriber_id TEXT NOT NULL,
27 data_warn_limit BIGINT
30 CREATE INDEX IF NOT EXISTS restrictions_index ON restrictions (binpath, iftype, ifname);
32 CREATE TABLE IF NOT EXISTS counters (
33 restriction_id INTEGER NOT NULL,
35 PRIMARY KEY (restriction_id)