bt-source/panel/data/system.sql

CREATE TABLE IF NOT EXISTS `network` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `up` INTEGER,
    `down` INTEGER,
    `total_up` INTEGER,
    `total_down` INTEGER,
    `down_packets` INTEGER,
    `up_packets` INTEGER,
    `addtime` INTEGER
);

CREATE TABLE IF NOT EXISTS `cpuio` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `pro` INTEGER,
    `mem` INTEGER,
    `addtime` INTEGER
);

CREATE TABLE IF NOT EXISTS `diskio` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `read_count` INTEGER,
    `write_count` INTEGER,
    `read_bytes` INTEGER,
    `write_bytes` INTEGER,
    `read_time` INTEGER,
    `write_time` INTEGER,
    `addtime` INTEGER
);

CREATE TABLE IF NOT EXISTS `process_top_list` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `cpu_top` REAL,
    `memory_top` REAL,
    `disk_top` REAL,
    `net_top` REAL,
    `all_top` REAL,
    `addtime` INTEGER
);

CREATE TABLE IF NOT EXISTS `load_average` (
    `id` INTEGER PRIMARY KEY AUTOINCREMENT,
    `pro` REAL,
    `one` REAL,
    `five` REAL,
    `fifteen` REAL,
    `addtime` INTEGER
);

CREATE TABLE IF NOT EXISTS `backup_status` (
    `id` INTEGER,
    `target` TEXT,
    `status` INTEGER,
    `msg` TEXT DEFAULT "",
    `addtime` DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS `app_usage` (
    `time_key` INTEGER PRIMARY KEY,
    `app` TEXT,
    `disks` TEXT,
    `addtime` DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS `server_status` (
    `status` TEXT,
    `addtime` DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS `daily` (
    `time_key` INTEGER,
    `evaluate` INTEGER,
    `addtime` DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX IF NOT EXISTS 'cpu' ON 'cpuio'('addtime');
CREATE INDEX IF NOT EXISTS 'ntwk' ON 'network'('addtime');
CREATE INDEX IF NOT EXISTS 'disk' ON 'diskio'('addtime');
CREATE INDEX IF NOT EXISTS 'load' ON 'load_average'('addtime');
CREATE INDEX IF NOT EXISTS 'proc' ON 'process_top_list'('addtime');