From 5017f8974699818dbedfbb545432da72fea22a8a Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 12 Oct 2009 16:41:34 +0000 Subject: [PATCH] rolling back a portion of the last commit -- unintended git-svn-id: svn://svn.open-ils.org/ILS/trunk@14371 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 33 ------------------------------- 1 file changed, 33 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index d4c5b05653..c63a5ccb56 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -562,38 +562,5 @@ CREATE TABLE config.org_unit_setting_type ( ( datatype <> 'link' AND fm_class IS NULL ) ) ); - --- Some handy functions, based on existing ones, to provide optional ingest normalization - -CREATE OR REPLACE FUNCTION public.left_trunc( TEXT, INT ) RETURNS TEXT AS $func$ - SELECT SUBSTRING($1,$2); -$func$ LANGUAGE SQL STRICT IMMUTABLE; - -CREATE OR REPLACE FUNCTION public.right_trunc( TEXT, INT ) RETURNS TEXT AS $func$ - SELECT SUBSTRING($1,1,$2); -$func$ LANGUAGE SQL STRICT IMMUTABLE; - -CREATE OR REPLACE FUNCTION public.split_date_range( TEXT ) RETURNS TEXT AS $func$ - SELECT REGEXP_REPLACE( $1, E'(\\d{4})-(\\d{4})', E'\\1 \\2', 'g' ); -$func$ LANGUAGE SQL STRICT IMMUTABLE; - --- And ... a table in which to register them - -CREATE TABLE config.index_normalizer ( - id SERIAL PRIMARY KEY, - name TEXT UNIQUE NOT NULL, - func TEXT NOT NULL, - param_count INT NOT NULL DEFAULT 0 -); - -CREATE TABLE config.metabib_field_index_norm_map ( - id SERIAL PRIMARY KEY, - field INT NOT NULL REFERENCES config.metabib_field (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, - norm INT NOT NULL REFERENCES config.index_normalizer (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, - params TEXT, - pos INT NOT NULL DEFAULT 0 -); - - COMMIT; -- 2.11.0