bot_setting table.

diff --git a/db/migrations.go b/db/migrations.go
index e8fc40d12762934caa1222995879a0ab2f973b3c..1a105fcc5ba4d34fe9d3675c2f219d2e158f9815 100644 (file)
--- 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",
+               },
+       },
 }