1 -- serials schema tweaks
5 INSERT INTO config.upgrade_log (version) VALUES ('0403'); -- dbwells via miker
7 ------- caption_and_pattern changes
8 ALTER TABLE serial.caption_and_pattern
9 ADD COLUMN start_date TIMESTAMP WITH TIME ZONE DEFAULT NOW();
11 ALTER TABLE serial.caption_and_pattern
12 ADD COLUMN end_date TIMESTAMP WITH TIME ZONE;
15 ------- *_summary changes
16 ALTER TABLE serial.basic_summary
17 ADD COLUMN show_generated BOOL NOT NULL DEFAULT TRUE;
19 ALTER TABLE serial.supplement_summary
20 ADD COLUMN show_generated BOOL NOT NULL DEFAULT TRUE;
22 ALTER TABLE serial.index_summary
23 ADD COLUMN show_generated BOOL NOT NULL DEFAULT TRUE;
26 ------- distribution changes
27 ALTER TABLE serial.distribution
29 ADD COLUMN summary_method TEXT CONSTRAINT summary_method_check CHECK (
30 summary_method IS NULL
31 OR summary_method IN ( 'add_to_sre',
32 'merge_with_sre', 'use_sre_only',