mig-init: loop through sorted mig-sql/ directory

[migration-tools.git] / mig-sql / 000-tracked_column.sql

diff --git a/mig-sql/000-tracked_column.sql b/mig-sql/000-tracked_column.sql
new file mode 100644 (file)
index 0000000..3f73454
--- /dev/null
+++ b/mig-sql/000-tracked_column.sql
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS tracked_column;
+CREATE TABLE tracked_column (
+     id                 serial
+    ,base_filename      TEXT
+    ,parent_table       TEXT
+    ,staged_table       TEXT
+    ,staged_column      TEXT
+    ,comment            TEXT
+    ,target_table       TEXT
+    ,target_column      TEXT
+    ,transform          TEXT
+    ,summarize          BOOLEAN
+);
+CREATE INDEX ON tracked_column(target_table,target_column);
+CREATE INDEX ON tracked_column(base_filename);