1
2
3
4
5
6
7
8
9

CREATE TABLE `event_handlers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `action_id` int(10) unsigned NOT NULL,
  `priority` int(10) unsigned NOT NULL DEFAULT '0',
  `user` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'nobody',
  `command` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `action_id` (`action_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE `event_handlers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `action_id` int(10) unsigned NOT NULL, `priority` int(10) unsigned NOT NULL DEFAULT '0', `user` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'nobody', `command` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `action_id` (`action_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1