2 -- Removing ingress and egress ports for SFC purposes.
3 -- Inserting only one port for ingress and egress.
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
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
;
16 DELETE FROM schema_version
WHERE version_int
='35';