1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE `exp_event` (
  `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `source` enum('pa','plesk') DEFAULT NULL,
  `event_type` enum('started','stopped','created','updated','deleted','status_changed','terminated','flushed','installed','uninstalled','siteapp_added','siteapp_removed','expired','exceeded','guid_changed') NOT NULL,
  `event_time` datetime NOT NULL,
  `obj_class` varchar(255) CHARACTER SET utf8 NOT NULL,
  `obj_id` varchar(255) CHARACTER SET utf8 NOT NULL,
  `host` varchar(255) CHARACTER SET utf8 NOT NULL,
  `user` varchar(255) CHARACTER SET ascii NOT NULL,
  `flushed` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5508 DEFAULT CHARSET=latin1

CREATE TABLE `exp_event` ( `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `source` enum('pa','plesk') DEFAULT NULL, `event_type` enum('started','stopped','created','updated','deleted','status_changed','terminated','flushed','installed','uninstalled','siteapp_added','siteapp_removed','expired','exceeded','guid_changed') NOT NULL, `event_time` datetime NOT NULL, `obj_class` varchar(255) CHARACTER SET utf8 NOT NULL, `obj_id` varchar(255) CHARACTER SET utf8 NOT NULL, `host` varchar(255) CHARACTER SET utf8 NOT NULL, `user` varchar(255) CHARACTER SET ascii NOT NULL, `flushed` enum('true','false') NOT NULL DEFAULT 'false', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5508 DEFAULT CHARSET=latin1