logo

pleroma

My custom branche(s) on git.pleroma.social/pleroma/pleroma git clone https://hacktivis.me/git/pleroma.git

20170916090107_add_fts_index_to_activities.exs (488B)


  1. # Pleroma: A lightweight social networking server
  2. # Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
  3. # SPDX-License-Identifier: AGPL-3.0-only
  4. defmodule Pleroma.Repo.Migrations.AddFTSIndexToActivities do
  5. use Ecto.Migration
  6. @disable_ddl_transaction true
  7. def change do
  8. create(
  9. index(:activities, ["(to_tsvector('english', data->'object'->>'content'))"],
  10. concurrently: true,
  11. using: :gin,
  12. name: :activities_fts
  13. )
  14. )
  15. end
  16. end