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 ('1221', :eg_version); -- miker/JBoyer
+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
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;