ALTER TABLE COMPETENCE_COURSE_INFORMATION_CHANGE_REQUEST ADD COLUMN STATUS VARCHAR(100);
update COMPETENCE_COURSE_INFORMATION_CHANGE_REQUEST set STATUS = 'APPROVED' where APPROVED = 1;
update COMPETENCE_COURSE_INFORMATION_CHANGE_REQUEST set STATUS = 'DELETED' where APPROVED = 0;
update COMPETENCE_COURSE_INFORMATION_CHANGE_REQUEST set STATUS = 'ON_HOLD' where APPROVED is null;
ALTER TABLE COMPETENCE_COURSE_INFORMATION_CHANGE_REQUEST DROP COLUMN APPROVED;