3 SELECT evergreen.upgrade_deps_block_check('1062', :eg_version);
5 CREATE TABLE acq.edi_attr (
7 label TEXT NOT NULL UNIQUE
10 CREATE TABLE acq.edi_attr_set (
11 id SERIAL PRIMARY KEY,
12 label TEXT NOT NULL UNIQUE
15 CREATE TABLE acq.edi_attr_set_map (
16 id SERIAL PRIMARY KEY,
17 attr_set INTEGER NOT NULL REFERENCES acq.edi_attr_set(id)
18 ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
19 attr TEXT NOT NULL REFERENCES acq.edi_attr(key)
20 ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
21 CONSTRAINT edi_attr_set_map_attr_once UNIQUE (attr_set, attr)
24 -- An attr_set is not strictly required, since some edi_accounts/vendors
25 -- may not need to apply any attributes.
26 ALTER TABLE acq.edi_account
27 ADD COLUMN attr_set INTEGER REFERENCES acq.edi_attr_set(id),
28 ADD COLUMN use_attrs BOOLEAN NOT NULL DEFAULT FALSE;