 ALTER TABLE tier ADD COLUMN affinity VARCHAR(128);
 DROP TABLE artifacttype;
 DROP TABLE configuration;
+DROP TABLE service_attribute;
 DROP TABLE service;
+ALTER TABLE applicationrelease drop constraint fk_applicationrelease_applicationtype;
 DROP TABLE applicationtype;
-ALTER TABLE productrelease DELETE COLUMN productType;
-ALTER TABLE applicationrelease DELETE COLUMN applicationType;
-DROP TABLE productype;
+ALTER TABLE productrelease DROP COLUMN producttype_id;
+ALTER TABLE applicationrelease DROP COLUMN applicationtype_id;
+-- DROP TABLE productype;
 
 -- changeset henar:5-3 --
 ALTER TABLE tierinstance ADD COLUMN floatingip VARCHAR(128);

ALTER TABLE network ADD COLUMN federatedRange VARCHAR(128);
ALTER TABLE networkinstance ADD COLUMN federatednetwork VARCHAR(128);
ALTER TABLE networkinstance ADD COLUMN federatedRange VARCHAR(128);
UPDATE network set federatednetwork=false where federatednetwork is NULL
UPDATE networkinstance set federatednetwork=false where federatednetwork is NULL
UPDATE networkinstance set federatedRange='' where federatedRange is NULL
UPDATE network set federatedRange='' where federatedRange is NULL



---liquibase formatted sql

--changeset jesuspg:1-1
CREATE TABLE artifact_attribute (
