ALTER TABLE `projects` CHANGE `active` `active` VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Y';
UPDATE `projects` SET `active` = 'active' WHERE `projects`.`active` = 'Y';
ALTER TABLE `projects` CHANGE `active` `status` ENUM('active','inactive','deleted','') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'active'

ALTER TABLE `employees` ADD `login_type` ENUM('admin','employee') NOT NULL DEFAULT 'employee' AFTER `username`;