From: Mike Rylander Date: Tue, 17 May 2011 17:44:35 +0000 (-0400) Subject: Convert/move SQL script for Lazy Circ X-Git-Url: http://git.equinoxoli.org/?p=evergreen-equinox.git;a=commitdiff_plain;h=007195f83beb33519d90133818a7d114ae82428b Convert/move SQL script for Lazy Circ Signed-off-by: Mike Rylander --- diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 2f14205..741f4f1 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,7 @@ CREATE TRIGGER no_overlapping_deps 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 ('0535', :eg_version); -- dbs +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0536', :eg_version); -- miker for tsbere CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.lazy_circ.sql b/Open-ILS/src/sql/Pg/upgrade/0536.schema.lazy_circ-barcode_lookup.sql similarity index 87% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.lazy_circ.sql rename to Open-ILS/src/sql/Pg/upgrade/0536.schema.lazy_circ-barcode_lookup.sql index ab4692a..5d86035 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.lazy_circ.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0536.schema.lazy_circ-barcode_lookup.sql @@ -1,20 +1,25 @@ +-- Evergreen DB patch 0536.schema.lazy_circ-barcode_lookup.sql +-- +-- FIXME: insert description of change, if needed +-- BEGIN; -INSERT INTO config.upgrade_log (version) VALUES ('XXXX'); +-- check whether patch can be applied +SELECT evergreen.update_deps_block_check('0536', :eg_version); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype) VALUES ( 'circ.staff_client.actor_on_checkout', 'Load patron from Checkout', 'When scanning barcodes into Checkout auto-detect if a new patron barcode is scanned and auto-load the new patron.', 'bool'); CREATE TABLE config.barcode_completion ( - id SERIAL PRIMARY KEY, - active BOOL NOT NULL DEFAULT true, - org_unit INT NOT NULL, -- REFERENCES actor.org_unit(id) DEFERRABLE INITIALLY DEFERRED, + id SERIAL PRIMARY KEY, + active BOOL NOT NULL DEFAULT true, + org_unit INT NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, prefix TEXT, suffix TEXT, - length INT NOT NULL DEFAULT 0, + length INT NOT NULL DEFAULT 0, padding TEXT, - padding_end BOOL NOT NULL DEFAULT false, - asset BOOL NOT NULL DEFAULT true, - actor BOOL NOT NULL DEFAULT true + padding_end BOOL NOT NULL DEFAULT false, + asset BOOL NOT NULL DEFAULT true, + actor BOOL NOT NULL DEFAULT true ); CREATE TYPE evergreen.barcode_set AS (type TEXT, id BIGINT, barcode TEXT); @@ -108,6 +113,5 @@ Given user input, find an appropriate barcode in the proper class. Will add prefix/suffix information to do so, and return all results. $$; -ALTER TABLE config.barcode_completion ADD CONSTRAINT config_barcode_completion_org_unit_fkey FOREIGN KEY (org_unit) REFERENCES actor.org_unit (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED; - COMMIT; +