From e65f7f8f07f52557db2cb687532ba75644206b19 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 2 Mar 2011 16:13:49 -0500 Subject: [PATCH] Move seed data to appropriate script --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 2 -- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 2 ++ 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 965bc96b23..94d18f0a83 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -307,7 +307,6 @@ CREATE TABLE asset.call_number_prefix ( CREATE TRIGGER prefix_normalize_tgr BEFORE INSERT OR UPDATE ON asset.call_number_prefix FOR EACH ROW EXECUTE PROCEDURE 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_prefix (id, owning_lib, label) VALUES (-1, 1, ''); CREATE TABLE asset.call_number_suffix ( id SERIAL PRIMARY KEY, @@ -318,7 +317,6 @@ CREATE TABLE asset.call_number_suffix ( CREATE TRIGGER suffix_normalize_tgr BEFORE INSERT OR UPDATE ON asset.call_number_suffix FOR EACH ROW EXECUTE PROCEDURE 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_suffix (id, owning_lib, label) VALUES (-1, 1, ''); CREATE TABLE asset.call_number ( id bigserial PRIMARY KEY, 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 ad5dbb2ef8..35f7c50751 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -2171,6 +2171,8 @@ INSERT INTO biblio.record_entry VALUES (-1,1,1,1,-1,NOW(),NOW(),FALSE,FALSE,'',' INSERT INTO asset.copy_location (id, name,owning_lib) VALUES (1, oils_i18n_gettext(1, 'Stacks', 'acpl', 'name'),1); SELECT SETVAL('asset.copy_location_id_seq'::TEXT, 100); +INSERT INTO asset.call_number_suffix (id, owning_lib, label) VALUES (-1, 1, ''); +INSERT INTO asset.call_number_prefix (id, owning_lib, label) VALUES (-1, 1, ''); INSERT INTO asset.call_number VALUES (-1,1,NOW(),1,NOW(),-1,1,'UNCATALOGED'); -- circ matrix -- 2.11.0