CREATE TABLE `proxmox` (
  `proxmox_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `device_id` int(11) NOT NULL,
  `node_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `cluster_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `guest_id` int(11) NOT NULL,
  `guest_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `guest_type` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`proxmox_id`),
  KEY `device` (`device_id`),
  KEY `cluster_device` (`cluster_name`,`device_id`),
  KEY `cluster_guest` (`cluster_name`,`guest_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

