HEX

File: //volume1/@appstore/SynologyApplicationService/share/synoscim/db/7__externalID_not_so_unique.sql

--
-- SAS #370
-- Unique of External Id should also consider its meta
--
BEGIN;

INSERT INTO sql_version (version) VALUES (7);

ALTER TABLE ONLY scim_id
DROP CONSTRAINT uk_164dcfif0r82xubvindi9vrnc;

ALTER TABLE ONLY scim_id
ADD CONSTRAINT uk_164dcfif0r82xubvindi9vrnc UNIQUE (external_id, meta);

COMMIT;