Is your feature request related to a problem? Please describe

I was just reviewing some of the old commits of Project Search implementation, I found out that the trigger function is both define in the migration file as well as in the model file of project, at first I thought it was needed but I tested removing the trigger function lines from the model/project.rb file. The trigger function of generating tsvector of name and description and storing it in searchable column was still working.

Describe the solution you'd like

By removing the unnecessary lines, from model/project.rb we could able to refactor this code.

# model/project.rb
  trigger.before(:insert, :update) do
    "tsvector_update_trigger(
        searchable, 'pg_catalog.english', description, name
      );"
  end

Describe alternatives you've considered

No response

Additional context

No response

Are you working on this?

Yes