From 2cbb7f4de87fa05534cdba28d67f61995ffa7a66 Mon Sep 17 00:00:00 2001 From: dbs Date: Sun, 20 Apr 2008 03:09:22 +0000 Subject: [PATCH] Use 950.data.seed-values.sql to avoid referential integrity errors git-svn-id: svn://svn.open-ils.org/ILS/trunk@9388 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/110.hold_matrix.sql | 2 -- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 4 ++++ 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/110.hold_matrix.sql b/Open-ILS/src/sql/Pg/110.hold_matrix.sql index ac34949f9c..801440a238 100644 --- a/Open-ILS/src/sql/Pg/110.hold_matrix.sql +++ b/Open-ILS/src/sql/Pg/110.hold_matrix.sql @@ -34,8 +34,6 @@ CREATE TABLE config.hold_matrix_matchpoint ( CONSTRAINT hous_once_per_grp_loc_mod_marc UNIQUE (user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, requestor_grp, usr_grp, circ_modifier, marc_type, marc_form, marc_vr_format) ); -INSERT INTO config.hold_matrix_matchpoint (requestor_grp) VALUES (1); - -- Tests to determine if hold against a specific copy is possible for a user at (and from) a location CREATE TABLE config.hold_matrix_test ( matchpoint INT PRIMARY KEY REFERENCES config.hold_matrix_matchpoint (id), diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 5b8c9bd14e..02933e9dab 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1259,6 +1259,10 @@ INSERT INTO config.xml_transform VALUES ( 'mods32', 'http://www.loc.gov/mods/v3' INSERT INTO config.circ_matrix_matchpoint (org_unit,grp) VALUES (1,1); INSERT INTO config.circ_matrix_ruleset (matchpoint,duration_rule,recurring_fine_rule,max_fine_rule) VALUES (1,11,1,1); + +-- hold matrix - 110.hold_matrix.sql: +INSERT INTO config.hold_matrix_matchpoint (requestor_grp) VALUES (1); + -- Staged Search (for default matchpoints) INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(1, 'first_word', 1.5); INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(1, 'full_match', 20); -- 2.43.2