From c3b0e473ef3e225afadb7f02deef5bdc89295a93 Mon Sep 17 00:00:00 2001
From: Jason Etheridge <jason@esilibrary.com>
Date: Fri, 12 Jan 2018 10:58:44 -0500
Subject: [PATCH] init/ subdirectory for mig-sql/, so we can more conveniently store sql for other mig commands

---
 mig-bin/mig-init                    |    4 ++--
 mig-sql/000-tracked_column.sql      |   15 ---------------
 mig-sql/000-tracked_file.sql        |   14 --------------
 mig-sql/init/000-tracked_column.sql |   15 +++++++++++++++
 mig-sql/init/000-tracked_file.sql   |   14 ++++++++++++++
 5 files changed, 31 insertions(+), 31 deletions(-)
 delete mode 100644 mig-sql/000-tracked_column.sql
 delete mode 100644 mig-sql/000-tracked_file.sql
 create mode 100644 mig-sql/init/000-tracked_column.sql
 create mode 100644 mig-sql/init/000-tracked_file.sql

diff --git a/mig-bin/mig-init b/mig-bin/mig-init
index 8382a24..98f92b5 100755
--- a/mig-bin/mig-init
+++ b/mig-bin/mig-init
@@ -31,7 +31,7 @@ use Pod::Usage;
 use DBI;
 use FindBin;
 my $mig_bin = "$FindBin::Bin/";
-my $mig_sql = $mig_bin . "../mig-sql/";
+my $mig_sql = $mig_bin . "../mig-sql/init/";
 use lib "$FindBin::Bin/";
 use Mig;
 
@@ -79,7 +79,7 @@ sub try_to_init_schema_with_migration_tools {
 }
 
 sub loop_through_mig_sql_templates {
-    print "Looping through mig-sql/ templates\n";
+    print "Looping through mig-sql/init/ templates\n";
     opendir my $dir, $mig_sql or die "Cannot open directory: $!";
     my @files = sort readdir $dir;
     closedir $dir;
diff --git a/mig-sql/000-tracked_column.sql b/mig-sql/000-tracked_column.sql
deleted file mode 100644
index 3f73454..0000000
--- a/mig-sql/000-tracked_column.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-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);
diff --git a/mig-sql/000-tracked_file.sql b/mig-sql/000-tracked_file.sql
deleted file mode 100644
index d80b12d..0000000
--- a/mig-sql/000-tracked_file.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-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
-);
diff --git a/mig-sql/init/000-tracked_column.sql b/mig-sql/init/000-tracked_column.sql
new file mode 100644
index 0000000..3f73454
--- /dev/null
+++ b/mig-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);
diff --git a/mig-sql/init/000-tracked_file.sql b/mig-sql/init/000-tracked_file.sql
new file mode 100644
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
+);
-- 
1.7.2.5