CREATE TABLE `tk_system_emails` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`is_user` TINYINT(1) NULL DEFAULT NULL,
	`task_type` TINYINT(4) NULL DEFAULT NULL,
	`to_emails` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`cc_emails` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`bcc_emails` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=4
;
CREATE TABLE `tk_system` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`email` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`phone_number` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`description` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`query_type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`status` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`error_description` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`external_ticket_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`ticket_no` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`created_at` DATE NULL DEFAULT NULL,
	`updated_at` DATE NULL DEFAULT NULL,
	`client_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`client_url` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`page_url` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`file_path` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=194
;