bot_setting table.v0.0.25bot-settings

1 files changed, 17 insertions, 0 deletions

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