RO/osm_ro/database_utils/migrations/up/35_add_sfc_ingress_and_egress.sql

   1 --
   2 -- Adding different ingress and egress ports for SFC.
   3 --
   4
   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
   8     AFTER if_order,
   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;
  14
  15 UPDATE sce_rsp_hops
  16   SET egress_interface_id = ingress_interface_id;
  17
  18 ALTER TABLE sce_rsp_hops
  19   ALTER COLUMN egress_interface_id DROP DEFAULT;
  20
  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;
  27
  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');