3 INSERT INTO config.upgrade_log (version) VALUES ('0360'); -- miker
5 INSERT INTO acq.invoice_item_type (code,name) VALUES ('SUB',oils_i18n_gettext('SUB', 'Searial Subscription', 'aiit', 'name'));
7 ALTER TABLE acq.po_item ADD COLUMN target BIGINT;
8 ALTER TABLE acq.invoice_item ADD COLUMN target BIGINT;
9 ALTER TABLE asset.copy ADD COLUMN cost NUMERIC(8,2);
11 CREATE TABLE acq.serial_claim (
12 id SERIAL PRIMARY KEY,
13 type INT NOT NULL REFERENCES acq.claim_type
14 DEFERRABLE INITIALLY DEFERRED,
15 item BIGINT NOT NULL REFERENCES serial.item
16 DEFERRABLE INITIALLY DEFERRED
19 CREATE INDEX serial_claim_lid_idx ON acq.serial_claim( item );
21 CREATE TABLE acq.serial_claim_event (
22 id BIGSERIAL PRIMARY KEY,
23 type INT NOT NULL REFERENCES acq.claim_event_type
24 DEFERRABLE INITIALLY DEFERRED,
25 claim SERIAL NOT NULL REFERENCES acq.serial_claim
26 DEFERRABLE INITIALLY DEFERRED,
27 event_date TIMESTAMPTZ NOT NULL DEFAULT now(),
28 creator INT NOT NULL REFERENCES actor.usr
29 DEFERRABLE INITIALLY DEFERRED,
33 CREATE INDEX serial_claim_event_claim_date_idx ON acq.serial_claim_event( claim, event_date );