X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=db%2Fmigrations.go;h=38ea8aa03f713ba234efb1a9c563b52588a9f2cf;hb=17b685396a34cb1fef8439e1b6802c6b7f59fbe2;hp=286fe17eb334427adcef19bad5aa2189c8825c9d;hpb=2b2fd737b4b6e530e67de743e58b630d69228c57;p=perso%2FImmae%2FProjets%2FCryptomonnaies%2FCryptoportfolio%2FFront.git

diff --git a/db/migrations.go b/db/migrations.go
index 286fe17..38ea8aa 100644
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -26,22 +26,22 @@ var migrations []Migration = []Migration{
 				config      jsonb,
 				UNIQUE(user_id, market_name)
 			)`,
+			`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)",
 			`CREATE TABLE report_lines (
 				id        BIGSERIAL PRIMARY KEY,
 				date      timestamp with time zone NOT NULL,
-				report_id bigint NOT NULL,
+				report_id bigint NOT NULL REFERENCES reports(id),
 				type      text,
 				payload   jsonb
 			)`,
 			"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", "DROP TABLE reports"},
 	},