init/ subdirectory for mig-sql/, so we can more conveniently store sql for other...

[migration-tools.git] / mig-sql / init / 000-tracked_file.sql

diff --git a/mig-sql/init/000-tracked_file.sql b/mig-sql/init/000-tracked_file.sql
new file mode 100644 (file)
index 0000000..d80b12d
--- /dev/null
+++ b/mig-sql/init/000-tracked_file.sql
@@ -0,0 +1,14 @@
+DROP TABLE IF EXISTS tracked_file;
+CREATE TABLE tracked_file (
+     id                 serial
+    ,base_filename      TEXT UNIQUE
+    ,has_headers        BOOLEAN
+    ,headers_file       TEXT
+    ,utf8_filename      TEXT
+    ,clean_filename     TEXT
+    ,stage_sql_filename TEXT
+    ,map_sql_filename   TEXT
+    ,prod_sql_filename  TEXT
+    ,parent_table       TEXT
+    ,staged_table       TEXT
+);