Virtual Column Index for ahoy_events table

add_virtual_column_index_to_ahoy_events.rb

class AddVirtualColumnIndexToAhoyEvents < ActiveRecord::Migration[6.0]
  def up
    ActiveRecord::Base.connection.execute (
      'ALTER TABLE ahoy_events ADD properties_id INT AS (JSON_UNQUOTE(properties->"$.id")) STORED;'
    )
    ActiveRecord::Base.connection.execute (
      'ALTER TABLE ahoy_events ADD INDEX (properties_id);'
    )
  end
  def down
    ActiveRecord::Base.connection.execute (
      "ALTER TABLE ahoy_events DROP properties_id;"
    )
  end
end