4 INSERT INTO config.upgrade_log (version) VALUES ('0188'); -- miker
6 CREATE TABLE vandelay.merge_profile (
7 id BIGSERIAL PRIMARY KEY,
8 owner INT NOT NULL REFERENCES actor.org_unit (id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
14 CONSTRAINT vand_merge_prof_owner_name_idx UNIQUE (owner,name),
15 CONSTRAINT add_replace_strip_or_preserve CHECK (preserve_spec IS NULL OR (add_spec IS NULL AND replace_spec IS NULL AND strip_spec IS NULL))