3 INSERT INTO config.upgrade_log (version) VALUES ('0210'); -- Scott McKellar
5 CREATE TABLE acq.claim_policy (
7 org_unit INT NOT NULL REFERENCES actor.org_unit
8 DEFERRABLE INITIALLY DEFERRED,
10 description TEXT NOT NULL,
11 CONSTRAINT name_once_per_org UNIQUE (org_unit, name)
14 CREATE TABLE acq.claim_policy_action (
15 id SERIAL PRIMARY KEY,
16 claim_policy INT NOT NULL REFERENCES acq.claim_policy
18 DEFERRABLE INITIALLY DEFERRED,
19 action_interval INTERVAL NOT NULL,
20 action INT NOT NULL REFERENCES acq.claim_event_type
21 DEFERRABLE INITIALLY DEFERRED,
22 CONSTRAINT action_sequence UNIQUE (claim_policy, action_interval)