Add column 'status' to market_configs.

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

diff --git a/db/migrations.go b/db/migrations.go
index 23847c9f4ad201494afe8f0a8db2ec9180ce5d8e..f0df49c6b9c4339965f783abd24c6111f85e7164 100644 (file)
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -73,9 +73,20 @@ var migrations []Migration = []Migration{
                                              FROM report_lines
                                                JOIN reports ON reports.id = report_lines.report_id
                                                JOIN market_configs ON reports.market_config_id = market_configs.id
-                                             WHERE report_lines.payload::jsonb->'checkpoint' IS NOT NULL`,
+                                             WHERE report_lines.payload::jsonb->>'checkpoint' IS NOT NULL`,
                        `CREATE INDEX checkpoints_idx ON report_lines ((payload->>'checkpoint'))`,
                },
                Down: []string{"DROP VIEW view_balances", "DROP INDEX checkpoints_idx"},
        },
+       {
+               Version: 201805101000,
+               Up: []string{
+                       "CREATE TYPE market_config_status AS ENUM ('enabled', 'disabled', 'invalid_credentials')",
+                       "ALTER TABLE market_configs ADD status market_config_status NOT NULL DEFAULT 'disabled'",
+               },
+               Down: []string{
+                       "ALTER TABLE market_configs DROP COLUMN status",
+                       "DROP TYPE market_config_status",
+               },
+       },
 }