Files F41667544

20190115085500_create_user_fts_index.exs
No OneTemporary
Actions

Size

471 B

Referenced Files

None

Subscribers

None

20190115085500_create_user_fts_index.exs
View Options

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

	def change do
	create_if_not_exists(
	index(
	:users,
	[
	"""
	(setweight(to_tsvector('simple', regexp_replace(nickname, '\\W', ' ', 'g')), 'A') \|\|
	setweight(to_tsvector('simple', regexp_replace(coalesce(name, ''), '\\W', ' ', 'g')), 'B'))
	"""
	],
	name: :users_fts_index,
	using: :gin
	)
	)
	end
	end

File Metadata

Mime Type: text/x-ruby
Expires: Sun, Feb 15, 5:48 AM (1 d, 16 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1091649
Default Alt Text: 20190115085500_create_user_fts_index.exs (471 B)

Event Timeline