20171023155035_add_second_object_index_to_activty.exs
No OneTemporary
Actions

Size

644 B

Referenced Files

None

Subscribers

None

20171023155035_add_second_object_index_to_activty.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.AddSecondObjectIndexToActivty do
	use Ecto.Migration

	@disable_ddl_transaction true

	def change do
	drop_if_exists(
	index(:activities, ["(data->'object'->>'id')", "(data->>'type')"],
	name: :activities_create_objects_index
	)
	)

	create(
	index(:activities, ["(coalesce(data->'object'->>'id', data->>'object'))"],
	name: :activities_create_objects_index,
	concurrently: true
	)
	)
	end
	end

Mime Type: text/x-ruby
Expires: Sun, Feb 15, 5:50 AM (8 h, 23 s)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1094298
Default Alt Text: 20171023155035_add_second_object_index_to_activty.exs (644 B)