1
2
3
4
5
6
7
8
9
10
11
12
13
14

CREATE TABLE `module_watchdog_disk_event` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `device` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `name` enum('RATE_EXCESS','BACK_TO_NORMAL','UNMOUNTED','MOUNTED') DEFAULT NULL,
  `mount_point` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL,
  `fs_size` int(10) unsigned DEFAULT NULL,
  `used_size` int(10) unsigned DEFAULT NULL,
  `inodes_num` int(10) unsigned DEFAULT NULL,
  `used_inodes` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `time` (`time`),
  KEY `device` (`device`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `module_watchdog_disk_event` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `device` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `name` enum('RATE_EXCESS','BACK_TO_NORMAL','UNMOUNTED','MOUNTED') DEFAULT NULL, `mount_point` varchar(255) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL, `fs_size` int(10) unsigned DEFAULT NULL, `used_size` int(10) unsigned DEFAULT NULL, `inodes_num` int(10) unsigned DEFAULT NULL, `used_inodes` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `time` (`time`), KEY `device` (`device`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1