Merge branch 'refactor/db-not-null-constraints-for-oauth_tokens' into 'develop'
[akkoma] / priv / repo / migrations / 20191026191249_set_not_null_for_notifications.exs
1 defmodule Pleroma.Repo.Migrations.SetNotNullForNotifications 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 notifications
8 ALTER COLUMN user_id SET NOT NULL,
9 ALTER COLUMN seen SET NOT NULL")
10 end
11
12 def down do
13 execute("ALTER TABLE notifications
14 ALTER COLUMN user_id DROP NOT NULL,
15 ALTER COLUMN seen DROP NOT NULL")
16 end
17 end