---liquibase formatted sql
+---liquibase formatted sql
 
 --changeset jesuspg:1-1
 CREATE TABLE artifact_attribute (

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



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 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);
