toward renaming mig to emig and tweaking the directory layout

[migration-tools.git] / emig.d / sql / init / 000-tracked_column.sql

diff --git a/emig.d/sql/init/000-tracked_column.sql b/emig.d/sql/init/000-tracked_column.sql
new file mode 100644 (file)
index 0000000..3f73454
--- /dev/null
+++ b/emig.d/sql/init/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);