From ff15f932e850a3187ce3d8beff39cc63219fb8c1 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 25 Mar 2019 14:31:41 -0400 Subject: [PATCH] adding columsn for specifying to migrates items and or patrons on tlc branches --- mig-sql/system/tlc/030_tlc_mapping_tables.sql | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) 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') ; -- ############################################ -- 1.7.2.5