priv/repo/migrations/20191026190622_set_not_null_for_config.exs


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

# Pleroma: A lightweight social networking server
# Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
# SPDX-License-Identifier: AGPL-3.0-only

defmodule Pleroma.Repo.Migrations.SetNotNullForConfig do
  use Ecto.Migration

  # modify/3 function will require index recreation, so using execute/1 instead

  def up do
    execute("ALTER TABLE config
    ALTER COLUMN key SET NOT NULL,
    ALTER COLUMN value SET NOT NULL")
  end

  def down do
    execute("ALTER TABLE config
    ALTER COLUMN key DROP NOT NULL,
    ALTER COLUMN value DROP NOT NULL")
  end
end