1 # Pleroma: A lightweight social networking server
2 # Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
3 # SPDX-License-Identifier: AGPL-3.0-only
5 defmodule Pleroma.Repo.Migrations.SetNotNullForFilters do
8 # modify/3 function will require index recreation, so using execute/1 instead
11 execute("ALTER TABLE filters
12 ALTER COLUMN user_id SET NOT NULL,
13 ALTER COLUMN filter_id SET NOT NULL,
14 ALTER COLUMN whole_word SET NOT NULL")
18 execute("ALTER TABLE filters
19 ALTER COLUMN user_id DROP NOT NULL,
20 ALTER COLUMN filter_id DROP NOT NULL,
21 ALTER COLUMN whole_word DROP NOT NULL")