feature 8029 change RO to python3. Using vim plugins

[osm/RO.git] / database_utils / migrations / up / 35_add_sfc_ingress_and_egress.sql

diff --git a/database_utils/migrations/up/35_add_sfc_ingress_and_egress.sql b/database_utils/migrations/up/35_add_sfc_ingress_and_egress.sql
deleted file mode 100644 (file)
index b528c6d..0000000
--- a/database_utils/migrations/up/35_add_sfc_ingress_and_egress.sql
+++ /dev/null
@@ -1,29 +0,0 @@
---
--- Adding different ingress and egress ports for SFC.
---
-
-ALTER TABLE sce_rsp_hops
-  DROP FOREIGN KEY FK_interfaces_rsp_hop,
-  CHANGE COLUMN interface_id ingress_interface_id VARCHAR(36) NOT NULL
-    AFTER if_order,
-  ADD CONSTRAINT FK_interfaces_rsp_hop_ingress
-    FOREIGN KEY (ingress_interface_id)
-    REFERENCES interfaces (uuid) ON UPDATE CASCADE ON DELETE CASCADE,
-  ADD COLUMN egress_interface_id VARCHAR(36) NULL DEFAULT NULL
-    AFTER ingress_interface_id;
-
-UPDATE sce_rsp_hops
-  SET egress_interface_id = ingress_interface_id;
-
-ALTER TABLE sce_rsp_hops
-  ALTER COLUMN egress_interface_id DROP DEFAULT;
-
-ALTER TABLE sce_rsp_hops
-  MODIFY COLUMN egress_interface_id VARCHAR(36) NOT NULL
-    AFTER ingress_interface_id,
-  ADD CONSTRAINT FK_interfaces_rsp_hop_egress
-    FOREIGN KEY (egress_interface_id)
-    REFERENCES interfaces (uuid) ON UPDATE CASCADE ON DELETE CASCADE;
-
-INSERT INTO schema_version (version_int, version, openmano_ver, comments, date)
-  VALUES (35, '0.35', '0.6.02', 'Adding ingress and egress ports for RSPs', '2018-12-11');