X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=db%2Fmigrations.go;h=1a105fcc5ba4d34fe9d3675c2f219d2e158f9815;hb=refs%2Ftags%2Fv0.0.25;hp=e8fc40d12762934caa1222995879a0ab2f973b3c;hpb=1fcb77583201f9979a839fcae2dd642edc25af96;p=perso%2FImmae%2FProjets%2FCryptomonnaies%2FCryptoportfolio%2FFront.git

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