Fix PG migrations + redis config.

[perso/Immae/Projets/Cryptomonnaies/Cryptoportfolio/Front.git] / db / migrations.go

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