bot_setting table.

[perso/Immae/Projets/Cryptomonnaies/Cryptoportfolio/Front.git] / db / migrations.go

diff --git a/db/migrations.go b/db/migrations.go
index f0df49c6b9c4339965f783abd24c6111f85e7164..1a105fcc5ba4d34fe9d3675c2f219d2e158f9815 100644 (file)
--- a/db/migrations.go
+++ b/db/migrations.go
@@ -89,4 +89,32 @@ var migrations []Migration = []Migration{
                        "DROP TYPE market_config_status",
                },
        },
+       {
+               Version: 201805131000,
+               Up: []string{
+                       "CREATE TYPE user_role AS ENUM ('admin', 'user')",
+                       "ALTER TABLE users ADD role user_role NOT NULL DEFAULT 'user'",
+               },
+               Down: []string{
+                       "ALTER TABLE users DROP COLUMN role",
+                       "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",
+               },
+       },
 }