From 9fbf1dcdf59deee10d2636e9367cac4153fa49dd Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 30 Aug 2019 16:23:47 -0400 Subject: [PATCH] adding tables to support reporter output --- mig-sql/init/011_reporter_tables.sql | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) create mode 100644 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 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); + + -- 1.7.2.5