From 11639547a6d21bb92009a237473ff7b660d3d59c Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Fri, 12 Jul 2013 17:20:07 -0400 Subject: [PATCH] Move exchange_rate seed data to 950 file Since currency_type is a foreign key of acq.exchange_rate, if we move currency_type to the seed data file, exchange rate must follow. Signed-off-by: Dan Wells Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 3 --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 3 +++ 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 75185a003a..35be244e9f 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -36,9 +36,6 @@ CREATE TABLE acq.exchange_rate ( CONSTRAINT exchange_rate_from_to_once UNIQUE (from_currency,to_currency) ); -INSERT INTO acq.exchange_rate (from_currency,to_currency,ratio) VALUES ('USD','CAN',1.2); -INSERT INTO acq.exchange_rate (from_currency,to_currency,ratio) VALUES ('USD','EUR',0.5); - CREATE TABLE acq.claim_policy ( id SERIAL PRIMARY KEY, org_unit INT NOT NULL REFERENCES actor.org_unit 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 fadeb20a70..fe3c2b36a3 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -9046,6 +9046,9 @@ INSERT INTO acq.currency_type (code, label) VALUES ('USD', oils_i18n_gettext('US INSERT INTO acq.currency_type (code, label) VALUES ('CAN', oils_i18n_gettext('CAN', 'Canadian Dollars', 'acqct', 'label')); INSERT INTO acq.currency_type (code, label) VALUES ('EUR', oils_i18n_gettext('EUR', 'Euros', 'acqct', 'label')); +INSERT INTO acq.exchange_rate (from_currency,to_currency,ratio) VALUES ('USD','CAN',1.2); +INSERT INTO acq.exchange_rate (from_currency,to_currency,ratio) VALUES ('USD','EUR',0.5); + INSERT INTO acq.invoice_item_type (code,name) VALUES ('TAX',oils_i18n_gettext('TAX', 'Tax', 'aiit', 'name')); INSERT INTO acq.invoice_item_type (code,name) VALUES ('PRO',oils_i18n_gettext('PRO', 'Processing Fee', 'aiit', 'name')); INSERT INTO acq.invoice_item_type (code,name) VALUES ('SHP',oils_i18n_gettext('SHP', 'Shipping Charge', 'aiit', 'name')); -- 2.43.2