adding tables to support reporter output
authorRogan Hamby <rhamby@equinoxinitiative.org>
Fri, 30 Aug 2019 20:23:47 +0000 (16:23 -0400)
committerRogan Hamby <rhamby@equinoxinitiative.org>
Fri, 30 Aug 2019 20:23:47 +0000 (16:23 -0400)
mig-sql/init/011_reporter_tables.sql [new file with mode: 0644]

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
@@ -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);
+
+