X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Fsystem%2Ftlc%2F030_tlc_mapping_tables.sql;fp=mig-sql%2Fsystem%2Ftlc%2F030_tlc_mapping_tables.sql;h=d1caa54d8c5dcfaa2330b8e9270d2be6d494c323;hp=8d19ad098c58762dcf274e6ae9bd44a52c4e892a;hb=af66e5408e31e25bc6fed62b99cc39be95d480ef;hpb=7722d81c31b9036d91a174621404b134f4e25893

diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
index 8d19ad0..d1caa54 100644
--- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql
+++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
@@ -1,3 +1,30 @@
+CREATE TABLE map_tlc_branches (
+    id                  SERIAL
+    ,tlc_branch_id      TEXT
+    ,tlc_name           TEXT
+    ,org_unit           TEXT
+    ,note               TEXT
+    ,x_org_id           INTEGER
+);
+
+INSERT INTO gsheet_tracked_table
+    (table_name,tab_name,created)
+VALUES
+    ('map_tlc_branches','Branches Present in Extract',NOW())
+;
+
+INSERT INTO gsheet_tracked_column
+    (table_id,column_name)
+VALUES
+     ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'x_count')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_branch_id')
+    ,((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')
+;
+
+-- ############################################
+
 CREATE TABLE map_tlc_perm_group (
     id                  SERIAL
     ,x_count            TEXT