Add reports CREATE TABLE.

1 files changed, 8 insertions, 1 deletions

diff --git a/db/migrations.go b/db/migrations.go
index ce5caf6..286fe17 100644
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -35,7 +35,14 @@ var migrations []Migration = []Migration{
                         )`,
                         "CREATE INDEX IF NOT EXISTS report_lines_report_id ON report_lines (report_id)",
                         "CREATE INDEX IF NOT EXISTS report_lines_type      ON report_lines (type)",
+                        `CREATE TABLE reports (
+                                id               BIGSERIAL PRIMARY KEY,
+                                date             timestamp with time zone NOT NULL,
+                                market_config_id bigint NOT NULL,
+                                debug            boolean
+                        )`,
+                        "CREATE INDEX IF NOT EXISTS reports_market_config_id ON reports (market_config_id)",
                 },
-                Down: []string{"DROP TABLE users", "DROP TABLE market_configs", "DROP TABLE report_lines"},
+                Down: []string{"DROP TABLE users", "DROP TABLE market_configs", "DROP TABLE report_lines", "DROP TABLE reports"},
         },
 }