From 2b2fd737b4b6e530e67de743e58b630d69228c57 Mon Sep 17 00:00:00 2001 From: jloup Date: Tue, 1 May 2018 02:44:04 +0200 Subject: [PATCH] Add reports CREATE TABLE. --- db/migrations.go | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) 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"}, }, } -- 2.41.0