From 5447fceb9c47b7d92c2fd81fe9608f4f192ae2ee Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 2 Mar 2011 13:32:18 -0500 Subject: [PATCH] typos spotted by Thomas Berezansky -- thanks for the eyes --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 6becef0bf3..0333d47264 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -298,27 +298,27 @@ BEGIN END; $$ LANGUAGE PLPGSQL; -CREATE TABLE asset.call_number_preffix ( +CREATE TABLE asset.call_number_prefix ( id SERIAL PRIMARY KEY, owning_lib INT NOT NULL REFERENCES actor.org_unit (id), label TEXT NOT NULL, -- i18n label_sortkey TEXT ); -CREATE TRIGGER prefix_normalize_tgr ON asset.call_number_preffix BEFORE INSERT OR UPDATE FOR EACH ROW EXECUTE asset.normalize_affix_sortkey(); +CREATE TRIGGER prefix_normalize_tgr ON asset.call_number_prefix BEFORE INSERT OR UPDATE FOR EACH ROW EXECUTE asset.normalize_affix_sortkey(); CREATE UNIQUE INDEX asset_call_number_prefix_once_per_lib ON asset.call_number_prefix (label, owning_lib); CREATE INDEX asset_call_number_prefix_sortkey_idx ON asset.call_number_prefix (label_sortkey); -INSERT INTO asset.call_number_preffix (id, owning_lib, label) VALUES (-1, 1, ''); +INSERT INTO asset.call_number_prefix (id, owning_lib, label) VALUES (-1, 1, ''); -CREATE TABLE asset.call_number_sufffix ( +CREATE TABLE asset.call_number_suffix ( id SERIAL PRIMARY KEY, owning_lib INT NOT NULL REFERENCES actor.org_unit (id), label TEXT NOT NULL, -- i18n label_sortkey TEXT ); -CREATE TRIGGER suffix_normalize_tgr ON asset.call_number_sufffix BEFORE INSERT OR UPDATE FOR EACH ROW EXECUTE asset.normalize_affix_sortkey(); +CREATE TRIGGER suffix_normalize_tgr ON asset.call_number_suffix BEFORE INSERT OR UPDATE FOR EACH ROW EXECUTE asset.normalize_affix_sortkey(); CREATE UNIQUE INDEX asset_call_number_suffix_once_per_lib ON asset.call_number_suffix (label, owning_lib); CREATE INDEX asset_call_number_suffix_sortkey_idx ON asset.call_number_suffix (label_sortkey); -INSERT INTO asset.call_number_sufffix (id, owning_lib, label) VALUES (-1, 1, ''); +INSERT INTO asset.call_number_suffix (id, owning_lib, label) VALUES (-1, 1, ''); CREATE TABLE asset.call_number ( id bigserial PRIMARY KEY, -- 2.11.0