toward renaming mig to emig and tweaking the directory layout

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

diff --git a/emig.d/sql/init/011_reporter_tables.sql b/emig.d/sql/init/011_reporter_tables.sql
new file mode 100644 (file)
index 0000000..5a0bc77
--- /dev/null
+++ b/emig.d/sql/init/011_reporter_tables.sql
@@ -0,0 +1,5 @@
+CREATE TABLE report (id SERIAL, create_date TIMESTAMPTZ, 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);
+
+