CREATE TABLE `def_vm_hosts` (
`HostId` varchar(50) NOT NULL,
`Package` varchar(255) NOT NULL DEFAULT '',
`Module` VARCHAR(255) DEFAULT NULL,
`HostType` enum('libvirt','proxmox') NOT NULL,
`DisplayName` varchar(100) NOT NULL,
`ConnectionUri` varchar(255) NOT NULL,
`Username` varchar(100) DEFAULT NULL,
`Password` varchar(512) DEFAULT NULL,
`ApiToken` varchar(512) DEFAULT NULL,
`SshKeyPath` varchar(255) DEFAULT NULL,
`VerifySsl` tinyint(1) DEFAULT 1,
`IsActive` tinyint(1) DEFAULT 1,
`IsDefault` tinyint(1) DEFAULT 0,
`Metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`Metadata`)),
`LastCheck` datetime DEFAULT NULL,
`CreatedAt` datetime DEFAULT current_timestamp(),
`UpdatedAt` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`HostId`, `Package`),
KEY `idx_host_type` (`HostType`),
KEY `idx_is_active` (`IsActive`),
KEY `idx_display_name` (`DisplayName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};