1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

CREATE TABLE `module_watchdog_service` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(63) CHARACTER SET ascii NOT NULL,
  `label` varchar(63) CHARACTER SET utf8 NOT NULL,
  `sort_val` smallint(5) unsigned NOT NULL DEFAULT '65535',
  `mon_status` enum('monitored','notmonitored') NOT NULL DEFAULT 'notmonitored',
  `save_stats` enum('on','off') NOT NULL DEFAULT 'on',
  `timeout` enum('on','off') NOT NULL DEFAULT 'on',
  `timeout_restart_num` smallint(5) unsigned NOT NULL DEFAULT '5',
  `timeout_cycles_num` smallint(5) unsigned NOT NULL DEFAULT '5',
  `connection_timeout` smallint(5) unsigned NOT NULL DEFAULT '5',
  `start_cmd` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `stop_cmd` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
  `start_time` smallint(5) unsigned NOT NULL DEFAULT '60',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `label` (`label`),
  KEY `name_2` (`name`),
  KEY `sort_val` (`sort_val`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1

CREATE TABLE `module_watchdog_service` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(63) CHARACTER SET ascii NOT NULL, `label` varchar(63) CHARACTER SET utf8 NOT NULL, `sort_val` smallint(5) unsigned NOT NULL DEFAULT '65535', `mon_status` enum('monitored','notmonitored') NOT NULL DEFAULT 'notmonitored', `save_stats` enum('on','off') NOT NULL DEFAULT 'on', `timeout` enum('on','off') NOT NULL DEFAULT 'on', `timeout_restart_num` smallint(5) unsigned NOT NULL DEFAULT '5', `timeout_cycles_num` smallint(5) unsigned NOT NULL DEFAULT '5', `connection_timeout` smallint(5) unsigned NOT NULL DEFAULT '5', `start_cmd` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `stop_cmd` varchar(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, `start_time` smallint(5) unsigned NOT NULL DEFAULT '60', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `label` (`label`), KEY `name_2` (`name`), KEY `sort_val` (`sort_val`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1