1 defmodule Pleroma.Repo.Migrations.AddUserFrontendProfiles do
5 create_if_not_exists table("user_frontend_setting_profiles", primary_key: false) do
6 add(:user_id, references(:users, type: :uuid, on_delete: :delete_all), primary_key: true)
7 add(:frontend_name, :string, primary_key: true)
8 add(:profile_name, :string, primary_key: true)
9 add(:version, :integer)
14 create_if_not_exists(index(:user_frontend_setting_profiles, [:user_id, :frontend_name]))
17 unique_index(:user_frontend_setting_profiles, [:user_id, :frontend_name, :profile_name])
22 drop_if_exists(table("user_frontend_setting_profiles"))
23 drop_if_exists(index(:user_frontend_setting_profiles, [:user_id, :frontend_name]))
26 unique_index(:user_frontend_setting_profiles, [:user_id, :frontend_name, :profile_name])