Merge branch 'refactor/db-not-null-constraints-for-oauth_tokens' into 'develop'
[akkoma] / priv / repo / migrations / 20191026190712_set_not_null_for_conversation_participation_recipient_ships.exs
1 defmodule Pleroma.Repo.Migrations.SetNotNullForConversationParticipationRecipientShips do
2 use Ecto.Migration
3
4 # modify/3 function will require index recreation, so using execute/1 instead
5
6 def up do
7 execute("ALTER TABLE conversation_participation_recipient_ships
8 ALTER COLUMN user_id SET NOT NULL,
9 ALTER COLUMN participation_id SET NOT NULL")
10 end
11
12 def down do
13 execute("ALTER TABLE conversation_participation_recipient_ships
14 ALTER COLUMN user_id DROP NOT NULL,
15 ALTER COLUMN participation_id DROP NOT NULL")
16 end
17 end