mdserver-web/web/admin/setup/sql/system.sql

41 lines
1.0 KiB
MySQL
Raw Permalink Normal View History

2024-11-04 12:26:45 -05:00
CREATE TABLE IF NOT EXISTS `network` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`up` TEXT,
`down` TEXT,
`total_up` INTEGER,
`total_down` INTEGER,
`down_packets` INTEGER,
`up_packets` INTEGER,
`addtime` INTEGER
);
2024-11-26 14:45:31 -05:00
CREATE INDEX network_addtime_idx ON network(`addtime`);
2024-11-04 12:26:45 -05:00
CREATE TABLE IF NOT EXISTS `cpuio` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`pro` TEXT,
`mem` TEXT,
`addtime` INTEGER
);
2024-11-26 14:45:31 -05:00
CREATE INDEX cpuio_addtime_idx ON cpuio(`addtime`);
2024-11-04 12:26:45 -05:00
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
);
2024-11-26 14:45:31 -05:00
CREATE INDEX diskio_addtime_idx ON diskio(`addtime`);
2024-11-04 12:26:45 -05:00
CREATE TABLE IF NOT EXISTS `load_average` (
`id` INTEGER PRIMARY KEY AUTOINCREMENT,
`pro` REAL,
`one` REAL,
`five` REAL,
`fifteen` REAL,
`addtime` INTEGER
);
2024-11-26 14:45:31 -05:00
CREATE INDEX load_average_addtime_idx ON load_average(`addtime`);