1 defmodule Pleroma.Repo.Migrations.SetNotNullForPushSubscriptions do
4 # modify/3 function will require index recreation, so using execute/1 instead
7 execute("ALTER TABLE push_subscriptions
8 ALTER COLUMN user_id SET NOT NULL,
9 ALTER COLUMN token_id SET NOT NULL,
10 ALTER COLUMN endpoint SET NOT NULL,
11 ALTER COLUMN key_p256dh SET NOT NULL,
12 ALTER COLUMN key_auth SET NOT NULL,
13 ALTER COLUMN data SET NOT NULL")
17 execute("ALTER TABLE push_subscriptions
18 ALTER COLUMN user_id DROP NOT NULL,
19 ALTER COLUMN token_id DROP NOT NULL,
20 ALTER COLUMN endpoint DROP NOT NULL,
21 ALTER COLUMN key_p256dh DROP NOT NULL,
22 ALTER COLUMN key_auth DROP NOT NULL,
23 ALTER COLUMN data DROP NOT NULL")