Poncha

CREATE TABLE `machines` (  `machine_id` bigint(20) unsigned NOT NULL auto_increment,  `machine_name` varchar(128) NOT NULL default '',  `machine_type` varchar(32) NOT NULL default 'linux',  `ip_address` varchar(32) NOT NULL default '',  `mac_address` varchar(32) NOT NULL default '',  `created` datetime NOT NULL default '0000-00-00 00:00:00',  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `is_modified` tinyint(1) unsigned NOT NULL default '0',  `processlist_sampling_interval` int(10) unsigned NOT NULL default '60',  `hwinfo_sampling_interval` int(10) unsigned NOT NULL default '86400',  PRIMARY KEY  (`machine_id`),  UNIQUE KEY `machine_name` (`machine_name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE `gkm` (  `gkm_id` bigint(20) unsigned NOT NULL auto_increment,  `machine_id` bigint(20) NOT NULL default '0',  `user` varchar(32) NOT NULL default '',  `realm` varchar(32) NOT NULL default '',  PRIMARY KEY  (`gkm_id`),  KEY `machine_id` (`machine_id`),  UNIQUE KEY `user_host` (`machine_id`,`user`,`realm`),  FOREIGN KEY `fk_machine_id` (`machine_id`) REFERENCES `machines` (`machine_id`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;