From 58d3ae84f89c254684055b8bbb4f2e60b7666df4 Mon Sep 17 00:00:00 2001 From: gmc Date: Fri, 3 Sep 2010 19:28:01 +0000 Subject: [PATCH] give default OUs separate addresses Per suggestion from Anoop Atre to avoid a new user changing one OU address in a new database and wondering why all of the OU addresses were changed. Signed-off-by: Galen Charlton git-svn-id: svn://svn.open-ils.org/ILS/trunk@17484 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) 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 c1c1ff64f..00db4cb58 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -955,9 +955,11 @@ INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES (9, 6, 5, 'BM1', oils_i18n_gettext(9, 'Example Bookmobile 1', 'aou', 'name')); SELECT SETVAL('actor.org_unit_id_seq'::TEXT, 100); -INSERT INTO actor.org_address VALUES (DEFAULT,DEFAULT,DEFAULT,1,'123 Main St.',NULL,'Anywhere',NULL,'GA','US','30303'); +INSERT INTO actor.org_address (org_unit, street1, city, state, country, post_code) +SELECT id, '123 Main St.', 'Anywhere', 'GA', 'US', '30303' +FROM actor.org_unit; -UPDATE actor.org_unit SET holds_address = 1, ill_address = 1, billing_address = 1, mailing_address = 1; +UPDATE actor.org_unit SET holds_address = id, ill_address = id, billing_address = id, mailing_address = id; INSERT INTO config.billing_type (id, name, owner) VALUES ( 1, oils_i18n_gettext(1, 'Overdue Materials', 'cbt', 'name'), 1); -- 2.11.0