X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;h=a50b810d9f4b6bd58f52e06bc87aa1de4f54efcb;hp=ab1b01136a1eda65e5c0fb7e3075633937902415;hb=3198dd53c3f3932a2806c9d101a055a58c716d42;hpb=2d416d5e39c1f6a1b32876cf66512f99817d7ee3

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index ab1b011..a50b810 100644
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -147,3 +147,34 @@ VALUES
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
 ;
+
+
+CREATE TABLE map_bib_manipulations (
+    id               SERIAL
+    ,action          TEXT
+    ,field           TEXT
+    ,subfield        TEXT
+    ,matching_value  TEXT
+    ,target_value    TEXT
+    ,note            TEXT
+);
+
+INSERT INTO gsheet_tracked_table
+    (table_name,tab_name,created)
+VALUES
+    ('map_bib_manipulations','Bib Records',NOW())
+;
+
+INSERT INTO gsheet_tracked_column
+    (table_id,column_name)
+VALUES
+     ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')
+;
+
+