20170501133231_add_id_contraints_to_activities_and_objects_part_two.exs
No OneTemporary
Actions

Size

730 B

Referenced Files

None

Subscribers

None

20170501133231_add_id_contraints_to_activities_and_objects_part_two.exs
View Options

	# 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.AddIdContraintsToActivitiesAndObjectsPartTwo do
	use Ecto.Migration

	def up do
	drop_if_exists(index(:objects, ["(data->>\"id\")"], name: :objects_unique_apid_index))
	drop_if_exists(index(:activities, ["(data->>\"id\")"], name: :activities_unique_apid_index))

	create_if_not_exists(
	unique_index(:objects, ["(data->>'id')"], name: :objects_unique_apid_index)
	)

	create_if_not_exists(
	unique_index(:activities, ["(data->>'id')"], name: :activities_unique_apid_index)
	)
	end

	def down, do: :ok
	end

Mime Type: text/x-ruby
Expires: Tue, Jan 20, 9:55 AM (1 d, 7 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 940353
Default Alt Text: 20170501133231_add_id_contraints_to_activities_and_objects_part_two.exs (730 B)