From: Rogan Hamby <rhamby@esilibrary.com>
Date: Mon, 25 Mar 2019 18:31:57 +0000 (-0400)
Subject: Merge branch 'master' of git.esilibrary.com:migration-tools
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=32f8a87408763d0ace21af526d68ffb02559a33d;hp=4ec23f88c7f20557b13ec6f5be637e726904e114

Merge branch 'master' of git.esilibrary.com:migration-tools
---

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')
 ;
 
 -- ############################################