gistfile1.sql

alter table remote_service add remoteServiceType varchar(50) not null;
update remote_service set remoteServiceType = 'VIRTUAL_FACTORY' where idRemoteServiceType = 1;
update remote_service set remoteServiceType = 'STORAGE_SYSTEM_MONITOR' where idRemoteServiceType = 2;
update remote_service set remoteServiceType = 'VIRTUAL_SYSTEM_MONITOR' where idRemoteServiceType = 3;
update remote_service set remoteServiceType = 'NODE_COLLECTOR' where idRemoteServiceType = 4;
update remote_service set remoteServiceType = 'DHCP_SERVICE' where idRemoteServiceType = 5;
alter table remote_service drop foreign key idRemoteServiceType_FK1;
alter table remote_service drop column idRemoteServiceType;

drop table remote_service_type;