From e7f09c8dbca85aba863d5062eb7e2778fa8ec486 Mon Sep 17 00:00:00 2001 From: dbs Date: Sun, 3 May 2009 15:41:11 +0000 Subject: [PATCH] Update org_unit short names and org_unit_type descriptions to something relatively modern git-svn-id: svn://svn.open-ils.org/ILS-Contrib/conifer/trunk@442 6d9bc8c9-1ec2-4278-b937-99fde70a366f --- tools/migration-scripts/generate_copies.sql | 16 ++++++++++++++-- tools/migration-scripts/org_units.sql | 18 +++++++++--------- 2 files changed, 23 insertions(+), 11 deletions(-) diff --git a/tools/migration-scripts/generate_copies.sql b/tools/migration-scripts/generate_copies.sql index 62c31f272e..09e8d042da 100644 --- a/tools/migration-scripts/generate_copies.sql +++ b/tools/migration-scripts/generate_copies.sql @@ -10,15 +10,23 @@ UPDATE staging_items WHERE owning_lib = 'ALGOMA'; UPDATE staging_items - SET owning_lib = 'LUEDUC' + SET owning_lib = 'CRC' WHERE location = 'ELSE-CURR'; UPDATE staging_items + SET owning_lib = 'VALE' + WHERE location = 'INCO'; + +UPDATE staging_items + SET owning_lib = 'LDRC' + WHERE location = 'EDUCATION'; + +UPDATE staging_items SET owning_lib = 'OSM', location = 'WWW' WHERE location = 'HIRC-WWW'; UPDATE staging_items - SET owning_lib = 'LUMUSIC' + SET owning_lib = 'MRC' WHERE location = 'DESM-MRC'; UPDATE staging_items @@ -53,6 +61,10 @@ UPDATE staging_items SET owning_lib = 'SAH' WHERE location = 'NEORCC'; +UPDATE staging_items + SET owning_lib = 'XSTRATA' + WHERE location = 'FALCON'; + -- Map locations UPDATE staging_items SET location = 'AV' diff --git a/tools/migration-scripts/org_units.sql b/tools/migration-scripts/org_units.sql index ae667a0fdc..7bd3a21abf 100644 --- a/tools/migration-scripts/org_units.sql +++ b/tools/migration-scripts/org_units.sql @@ -31,15 +31,15 @@ COPY org_unit (id, parent_ou, ou_type, ill_address, holds_address, mailing_addre 104 105 7 1 1 1 1 HUNTINGTON Huntington College Library t 117 105 7 \N \N \N \N MEDB Mining and the Environment Database t 1 \N 1 1 1 1 1 CONIFER Conifer t -102 1 2 1 1 1 1 LAURSYS Laurentian System t +102 1 4 1 1 1 1 LAURSYS Laurentian System t 106 1 2 \N \N \N \N WINDSYS Windsor System t 109 106 3 \N \N \N \N OWA Leddy Library t 112 102 3 \N \N \N \N ARTGALL Art Gallery of Sudbury t 113 102 3 \N \N \N \N CFOF Centre Franco-Ontarien de Folklore t 116 102 3 \N \N \N \N SAH Sault Area Hospital t 118 102 3 \N \N \N \N MNDM Mines Library, Willet Green Miller Centre t -119 102 3 \N \N \N \N FALCON Xstrata Process Support Centre Library, Falconbridge t -120 102 3 \N \N \N \N INCO Vale Inco t +119 102 3 \N \N \N \N XSTRATA Xstrata Process Support Centre Library t +120 102 3 \N \N \N \N VALE Vale Inco t 122 106 3 \N \N \N \N OWAL Paul Martin Law Library t 111 1 2 \N \N \N \N ALGOMASYS Algoma System \N \N t 124 111 3 \N \N \N \N OSTMA Algoma University, Wishart Library t @@ -50,9 +50,9 @@ COPY org_unit (id, parent_ou, ou_type, ill_address, holds_address, mailing_addre 127 114 7 \N \N \N \N HEARST Hearst, Bibliothèque Maurice-Saulnier \N \N t 128 114 7 \N \N \N \N KAP Hearst Kapuskasing, Centre de Ressources \N \N t 129 114 7 \N \N \N \N TIMMINS Hearst Timmins, Centre de Ressources \N \N t -130 105 7 \N \N \N \N LUEDUC Curriculum Resource Centre \N \N t -131 105 7 \N \N \N \N LUMUSIC Music Resource Centre \N \N t -132 105 7 \N \N \N \N EDUCATION Laboratoire de didactiques, E.S.E. \N \N t +130 105 7 \N \N \N \N CRC Curriculum Resource Centre \N \N t +131 105 7 \N \N \N \N MRC Music Resource Centre \N \N t +132 105 7 \N \N \N \N LDCR Laboratoire de didactiques, E.S.E. \N \N t \. @@ -63,12 +63,12 @@ COPY org_unit (id, parent_ou, ou_type, ill_address, holds_address, mailing_addre COPY org_unit_type (id, name, opac_label, depth, parent, can_have_vols, can_have_users) FROM stdin; 1 Consortium Everywhere 0 \N f f -2 System Local Library System 1 1 f f -4 Sub-lib This Specialized Library 3 3 t t +2 System University Libraries 1 1 f f +4 LU System University and Partners 1 1 f f 5 Bookmobile Your Bookmobile 3 3 t t 7 University-Library University Library 3 6 t t 3 Branch This Branch 2 2 t t -6 University University System 2 2 t t +6 University Campus Libraries 2 2 t t \. -- 2.11.0