From: Rogan Hamby <rhamby@esilibrary.com>
Date: Wed, 28 Feb 2018 18:26:42 +0000 (-0500)
Subject: moving org to the holding code table
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=2d416d5e39c1f6a1b32876cf66512f99817d7ee3

moving org to the holding code table
---

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index c414c17..ab1b011 100644
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -9,7 +9,6 @@ CREATE TABLE map_create_shelving_location (
     ,l_note               TEXT
     ,x_migrate            BOOLEAN NOT NULL DEFAULT TRUE
     ,x_shelf              INTEGER
-    ,x_org                INTEGER
 ) INHERITS (asset_copy_location);
 
 INSERT INTO gsheet_tracked_table 
diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
index 144f7d6..d356508 100644
--- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql
+++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
@@ -230,6 +230,7 @@ CREATE TABLE map_tlc_holding_code (
     ,x_count            TEXT            
     ,holding_code       TEXT
     ,shelving_location  TEXT
+    ,org_unit           TEXT
     ,circ_mod           TEXT
     ,alert              TEXT
     ,alert_message      TEXT
@@ -249,6 +250,7 @@ VALUES
      ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')