BEFORE INSERT OR UPDATE ON config.db_patch_dependencies
FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates');
-INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1182', :eg_version); -- liam/jeffdavis/gmcharlt
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1269', :eg_version); -- sandbergja/tmcanna/gmcharlt
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
opac_visible BOOL NOT NULL DEFAULT FALSE,
copy_active BOOL NOT NULL DEFAULT FALSE,
restrict_copy_delete BOOL NOT NULL DEFAULT FALSE,
- is_available BOOL NOT NULL DEFAULT FALSE
+ is_available BOOL NOT NULL DEFAULT FALSE,
+ hopeless_prone BOOL NOT NULL DEFAULT FALSE
);
COMMENT ON TABLE config.copy_status IS $$
Copy Statuses
name TEXT UNIQUE, -- i18n
pprox INT, -- copy capture <-> pickup lib prox
hprox INT, -- copy circ lib <-> request lib prox
+ owning_lib_to_home_lib_prox INT, -- copy owning lib <-> user home lib prox
aprox INT, -- copy circ lib <-> pickup lib ADJUSTED prox on ahcm
approx INT, -- copy capture <-> pickup lib ADJUSTED prox from function
priority INT, -- group hold priority
ALTER TABLE config.best_hold_order ADD CHECK ((
pprox IS NOT NULL OR
hprox IS NOT NULL OR
+ owning_lib_to_home_lib_prox IS NOT NULL OR
aprox IS NOT NULL OR
priority IS NOT NULL OR
cut IS NOT NULL OR
SELECT SETVAL('config.carousel_type_id_seq'::TEXT, 100);
+CREATE TABLE config.geolocation_service (
+ id SERIAL PRIMARY KEY,
+ active BOOLEAN,
+ owner INT NOT NULL, -- REFERENCES actor.org_unit (id)
+ name TEXT,
+ service_code TEXT,
+ api_key TEXT
+);
+
COMMIT;