3 INSERT INTO config.upgrade_log (version) VALUES ('0297'); -- Scott McKellar
5 ALTER TABLE serial.record_entry
6 ALTER COLUMN marc DROP NOT NULL;
8 CREATE TABLE serial.caption_and_pattern (
10 record BIGINT NOT NULL
11 REFERENCES serial.record_entry (id)
13 DEFERRABLE INITIALLY DEFERRED,
15 CONSTRAINT cap_type CHECK ( type in
16 ( 'basic', 'supplement', 'index' )),
17 create_time TIMESTAMPTZ NOT NULL DEFAULT now(),
18 active BOOL NOT NULL DEFAULT FALSE,
19 pattern_code TEXT NOT NULL, -- must contain JSON