RO/osm_ro/database_utils/migrations/down/35_remove_sfc_ingress_and_egress.sql

   1 --
   2 -- Removing ingress and egress ports for SFC purposes.
   3 -- Inserting only one port for ingress and egress.
   4 --
   5
   6 ALTER TABLE sce_rsp_hops
   7   DROP FOREIGN KEY FK_interfaces_rsp_hop_ingress,
   8   CHANGE COLUMN ingress_interface_id interface_id VARCHAR(36) NOT NULL
   9     AFTER if_order,
  10   ADD CONSTRAINT FK_interfaces_rsp_hop
  11     FOREIGN KEY (interface_id)
  12     REFERENCES interfaces (uuid) ON UPDATE CASCADE ON DELETE CASCADE,
  13   DROP FOREIGN KEY FK_interfaces_rsp_hop_egress,
  14   DROP COLUMN egress_interface_id;
  15
  16 DELETE FROM schema_version WHERE version_int='35';