-- ----------------------------------------------------------
-- APM-2700                                                --
-- CNS, start and service temp tables has too short fields --
-- ----------------------------------------------------------
DROP TABLE `temp_service`;
CREATE TABLE `temp_service` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`guiid` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	`service` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE `temp_start`;
CREATE TABLE `temp_start` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`guiid` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	`start` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
	`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
