SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for servers -- ---------------------------- DROP TABLE IF EXISTS `servers`; CREATE TABLE `servers` ( `server_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ip` varchar(500) NOT NULL, `port` int(5) unsigned DEFAULT NULL, `label` varchar(255) NOT NULL, `type` enum('service','website') NOT NULL DEFAULT 'service', `pattern` varchar(255) DEFAULT NULL, `status` enum('on','off') DEFAULT 'on', `error` varchar(255) DEFAULT NULL, `rtime` float(9,7) DEFAULT NULL, `last_online` datetime DEFAULT NULL, `last_check` datetime DEFAULT NULL, `active` enum('yes','no') DEFAULT 'yes', `email` enum('yes','no') DEFAULT 'yes', `sms` enum('yes','no') DEFAULT 'no', `pushover` enum('yes','no') DEFAULT 'yes', `warning_threshold` mediumint(1) unsigned DEFAULT '1', `warning_threshold_counter` mediumint(1) unsigned DEFAULT '0', `timeout` smallint(1) unsigned DEFAULT NULL, `website_username` varchar(255) DEFAULT NULL, `website_password` varchar(255) DEFAULT NULL, `add_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `is_delete` enum('yes','no') DEFAULT 'no', PRIMARY KEY (`server_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

分类: web

标签: