| actions | CREATE TABLE `actions` (
`actionid` bigint(20) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`eventsource` int(11) NOT NULL DEFAULT '0',
`evaltype` int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '0',
`esc_period` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '1h',
`formula` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`pause_suppressed` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`actionid`),
UNIQUE KEY `actions_2` (`name`),
KEY `actions_1` (`eventsource`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
`actionid` bigint(20) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`eventsource` int(11) NOT NULL DEFAULT '0',
`evaltype` int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '0',
`esc_period` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '1h',
`formula` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`pause_suppressed` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`actionid`),
UNIQUE KEY `actions_2` (`name`),
KEY `actions_1` (`eventsource`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
Comment