adding tables to support reporter output

[migration-tools.git] / mig-sql / init / 011_reporter_tables.sql

diff --git a/mig-sql/init/011_reporter_tables.sql b/mig-sql/init/011_reporter_tables.sql
new file mode 100644 (file)
index 0000000..43bff39
--- /dev/null
+++ b/mig-sql/init/011_reporter_tables.sql
@@ -0,0 +1,5 @@
+CREATE TABLE report (id SERIAL, create_date TIMESTAMPZ, name TEXT);
+CREATE TABLE reporter_columns (id SERIAL, report INTEGER, header TEXT, ordinal_position INTEGER);
+CREATE TABLE reporter_rows (id SERIAL, report INTEGER, row INTEGER, ordinal_position INTEGER);
+
+