2 -- Adding different ingress and egress ports for SFC.
5 ALTER TABLE sce_rsp_hops
6 DROP FOREIGN KEY FK_interfaces_rsp_hop
,
7 CHANGE
COLUMN interface_id ingress_interface_id
VARCHAR(36) NOT NULL
9 ADD CONSTRAINT FK_interfaces_rsp_hop_ingress
10 FOREIGN KEY (ingress_interface_id
)
11 REFERENCES interfaces (uuid
) ON UPDATE CASCADE ON DELETE CASCADE,
12 ADD COLUMN egress_interface_id
VARCHAR(36) NULL DEFAULT NULL
13 AFTER ingress_interface_id
;
16 SET egress_interface_id
= ingress_interface_id
;
18 ALTER TABLE sce_rsp_hops
19 ALTER COLUMN egress_interface_id
DROP DEFAULT;
21 ALTER TABLE sce_rsp_hops
22 MODIFY COLUMN egress_interface_id
VARCHAR(36) NOT NULL
23 AFTER ingress_interface_id
,
24 ADD CONSTRAINT FK_interfaces_rsp_hop_egress
25 FOREIGN KEY (egress_interface_id
)
26 REFERENCES interfaces (uuid
) ON UPDATE CASCADE ON DELETE CASCADE;
28 INSERT INTO schema_version (version_int
, version, openmano_ver
, comments, date)
29 VALUES (35, '0.35', '0.6.02', 'Adding ingress and egress ports for RSPs', '2018-12-11');