Add reports CREATE TABLE.

diff --git a/db/migrations.go b/db/migrations.go
index ce5caf6c2ef6db08d2fc7bb86d69c5c392066a76..286fe17eb334427adcef19bad5aa2189c8825c9d 100644 (file)
--- 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"},
        },
 }