ALTER TABLE `customer` ADD COLUMN `type` json NULL DEFAULT NULL AFTER `email`;
ALTER TABLE `customer` ADD COLUMN `region` json NULL DEFAULT NULL AFTER `type`;

UPDATE customer
SET type = CONCAT('["',typeId,'"]'),updated = updated
WHERE typeId IS NOT NULL;
UPDATE customer
SET region = CONCAT('["',regionId,'"]'),updated = updated
WHERE regionId IS NOT NULL;

ALTER TABLE `customer` DROP COLUMN `typeId`;
ALTER TABLE `customer` DROP COLUMN `regionId`;

INSERT INTO taskstatus (name, description, active, created, createdById, updated, updatedById)
VALUES ('COMPLETED', 'Task is COMPLETED', '1', UTC_TIMESTAMP(), '10', UTC_TIMESTAMP(), '10');

