From: jloup <jean-loup.jamet@trainline.com>
Date: Thu, 2 Aug 2018 22:09:57 +0000 (+0200)
Subject: bot_setting table.
X-Git-Tag: v0.0.25
X-Git-Url: https://git.immae.eu/?p=perso%2FImmae%2FProjets%2FCryptomonnaies%2FCryptoportfolio%2FFront.git;a=commitdiff_plain;h=refs%2Fheads%2Fbot-settings

bot_setting table.
---

diff --git a/db/migrations.go b/db/migrations.go
index e8fc40d..1a105fc 100644
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -100,4 +100,21 @@ var migrations []Migration = []Migration{
 			"DROP TYPE user_role",
 		},
 	},
+	{
+		Version: 201807311000,
+		Up: []string{
+			"CREATE TYPE portfolio_profile AS ENUM ('high-liquidity', 'medium-liquidity')",
+			`CREATE TABLE bot_settings (
+				id                BIGSERIAL PRIMARY KEY,
+				user_id           bigint REFERENCES users(id) ON DELETE CASCADE,
+				portfolio_profile portfolio_profile
+			)`,
+			`CREATE INDEX IF NOT EXISTS bot_settings_user_id ON bot_settings (user_id)`,
+			`CREATE UNIQUE INDEX bot_settings_unique_null_user_id ON bot_settings (coalesce(user_id, 0))`,
+		},
+		Down: []string{
+			"DROP TABLE bot_settings",
+			"DROP TYPE portfolio_profile",
+		},
+	},
 }