From c9fd7e01d8b155ec18b50fd08ff86ca64874a8b2 Mon Sep 17 00:00:00 2001
From: jloup <jean-loup.jamet@trainline.com>
Date: Fri, 3 Aug 2018 00:09:57 +0200
Subject: [PATCH] bot_setting table.

---
 db/migrations.go | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

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",
+		},
+	},
 }
-- 
2.41.0