From: Rogan Hamby <rhamby@esilibrary.com>
Date: Mon, 25 Mar 2019 18:31:41 +0000 (-0400)
Subject: adding columsn for specifying to migrates items and or patrons on tlc branches
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=ff15f932e850a3187ce3d8beff39cc63219fb8c1

adding columsn for specifying to migrates items and or patrons on tlc branches
---

diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
index 9fddeaf..25dbfef 100644
--- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql
+++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
@@ -3,8 +3,11 @@ CREATE TABLE map_tlc_branches (
     ,tlc_branch_id      TEXT
     ,tlc_name           TEXT
     ,org_unit           TEXT
+	,mig_patrons		TEXT
+	,mig_items			TEXT
     ,note               TEXT
     ,x_org_id           INTEGER
+	
 );
 
 INSERT INTO gsheet_tracked_table
@@ -21,6 +24,8 @@ VALUES
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_name')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'org_unit')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'note')
+	,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'mig_patrons')
+	,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'mig_items')
 ;
 
 -- ############################################