1 PRAGMA journal_mode = PERSIST;
3 CREATE TABLE IF NOT EXISTS statistics (
10 hw_net_protocol_type INT,
12 PRIMARY KEY (binpath, time_stamp, iftype)
15 CREATE INDEX IF NOT EXISTS binpath_st_idx ON statistics(binpath, iftype);
17 CREATE TABLE IF NOT EXISTS quotas (
21 snd_warning_threshold INT,
22 rcv_warning_threshold INT,
27 PRIMARY KEY(binpath, iftype, roaming)
30 CREATE INDEX IF NOT EXISTS binpath_qt_idx ON quotas(binpath, iftype);
32 CREATE TABLE IF NOT EXISTS effective_quotas (
34 sent_used_quota BIGINT,
35 rcv_used_quota BIGINT,
41 PRIMARY KEY (binpath, iftype, start_time, finish_time, roaming)
44 CREATE INDEX IF NOT EXISTS binpath_effective_quotas_idx ON effective_quotas(binpath, iftype);
46 CREATE TABLE IF NOT EXISTS restrictions (
54 PRIMARY KEY (binpath, iftype)
57 CREATE INDEX IF NOT EXISTS binpath_restrictions_idx ON restrictions(binpath, iftype);
59 CREATE TABLE IF NOT EXISTS iface_status (
63 PRIMARY KEY (update_time)
66 CREATE INDEX IF NOT EXISTS update_tm_if_idx ON iface_status(update_time, iftype, ifstatus);