diff options
author | Alex Gleason <alex@alexgleason.me> | 2021-12-07 13:41:54 -0500 |
---|---|---|
committer | Alex Gleason <alex@alexgleason.me> | 2021-12-07 13:41:54 -0500 |
commit | 2c96668a2c20906e5159fdea9326dbba4ca6ca62 (patch) | |
tree | e7fc1def45d51ba8011c1cfacb28c2523279e09b /priv/repo/migrations/20210717000000_add_poll_to_notifications_enum.exs | |
parent | 335684182a094c10fb9f72e3865fd1b9606484a4 (diff) | |
parent | b57041c59a14df78b4a461e68911a9edc788bc0a (diff) | |
download | pleroma-2c96668a2c20906e5159fdea9326dbba4ca6ca62.tar.gz pleroma-2c96668a2c20906e5159fdea9326dbba4ca6ca62.zip |
Merge remote-tracking branch 'origin/develop' into fix-attachment-dimensions
Diffstat (limited to 'priv/repo/migrations/20210717000000_add_poll_to_notifications_enum.exs')
-rw-r--r-- | priv/repo/migrations/20210717000000_add_poll_to_notifications_enum.exs | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/priv/repo/migrations/20210717000000_add_poll_to_notifications_enum.exs b/priv/repo/migrations/20210717000000_add_poll_to_notifications_enum.exs new file mode 100644 index 000000000..9abf40b3d --- /dev/null +++ b/priv/repo/migrations/20210717000000_add_poll_to_notifications_enum.exs @@ -0,0 +1,49 @@ +defmodule Pleroma.Repo.Migrations.AddPollToNotificationsEnum do + use Ecto.Migration + + @disable_ddl_transaction true + + def up do + """ + alter type notification_type add value 'poll' + """ + |> execute() + end + + def down do + alter table(:notifications) do + modify(:type, :string) + end + + """ + delete from notifications where type = 'poll' + """ + |> execute() + + """ + drop type if exists notification_type + """ + |> execute() + + """ + create type notification_type as enum ( + 'follow', + 'follow_request', + 'mention', + 'move', + 'pleroma:emoji_reaction', + 'pleroma:chat_mention', + 'reblog', + 'favourite', + 'pleroma:report' + ) + """ + |> execute() + + """ + alter table notifications + alter column type type notification_type using (type::notification_type) + """ + |> execute() + end +end |