Remove code skipping migration version1.

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

diff --git a/db/migrations.go b/db/migrations.go
index ce5caf6c2ef6db08d2fc7bb86d69c5c392066a76..38ea8aa03f713ba234efb1a9c563b52588a9f2cf 100644 (file)
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -26,16 +26,23 @@ 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)",
                },
-               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"},
        },
 }