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.AddFeaturedAddressToUsers do
10 add(:featured_address, :string)
13 create(index(:users, [:featured_address]))
17 update users set featured_address = concat(ap_id, '/collections/featured') where local = true and featured_address is null;
23 alter table(:users) do
24 remove(:featured_address)