From: jloup <jeanloup.jamet@gmail.com>
Date: Tue, 1 May 2018 00:44:04 +0000 (+0200)
Subject: Add reports CREATE TABLE.
X-Git-Tag: v0.0.5~2
X-Git-Url: https://git.immae.eu/?p=perso%2FImmae%2FProjets%2FCryptomonnaies%2FCryptoportfolio%2FFront.git;a=commitdiff_plain;h=2b2fd737b4b6e530e67de743e58b630d69228c57

Add reports CREATE TABLE.
---

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"},
 	},
 }