CREATE TABLE `dhcp_queue` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `mac` varchar(17) NOT NULL, `ip` varchar(15) NOT NULL, `action` varchar(10) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp(), `dhcp_hostname` varchar(250) DEFAULT NULL, PRIMARY KEY (`id`), KEY `timestamp` (`timestamp`,`action`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
