3 lines
711 B
SQL
3 lines
711 B
SQL
CREATE TABLE `probes` ( `probe_id` int(11) NOT NULL, `device_id` int(11) NOT NULL, `probe_type` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `probe_param` text COLLATE utf8_unicode_ci, `probe_cli` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL, `probe_status` enum('ok','warning','alert','unknown') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown', `probe_msg` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `probe_output` text COLLATE utf8_unicode_ci, `probe_changed` timestamp NULL DEFAULT NULL, `probe_checked` timestamp NULL DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
|
ALTER TABLE `probes` ADD PRIMARY KEY (`probe_id`), ADD KEY `device_id` (`device_id`);
|