Contents

class CreateAhoyVisitsAndEvents < ActiveRecord::Migration[6.1]
  def change
    create_table :ahoy_visits do |t|
      t.string :visit_token
      t.string :visitor_token

      # the rest are recommended but optional
      # simply remove any you don't want

      # user
      t.references :user

      # standard
      t.string :ip
      t.text :user_agent
      t.text :referrer
      t.string :referring_domain
      t.text :landing_page

      # technology
      t.string :browser
      t.string :os
      t.string :device_type

      # location
      t.string :country
      t.string :region
      t.string :city
      t.float :latitude
      t.float :longitude

      # utm parameters
      t.string :utm_source
      t.string :utm_medium
      t.string :utm_term
      t.string :utm_content
      t.string :utm_campaign

      # native apps
      t.string :app_version
      t.string :os_version
      t.string :platform

      t.datetime :started_at
    end

    add_index :ahoy_visits, :visit_token, unique: true

    create_table :ahoy_events do |t|
      t.references :visit
      t.bigint :user_id
      t.bigint :admin_action_on_user_id
      
      t.string :user_type
      t.string :name
      t.jsonb :properties
      t.jsonb :cloudfront_headers, default: {}
      t.datetime :time
    end

    add_index :ahoy_events, [:name, :time]
    add_index :ahoy_events, :properties, using: :gin, opclass: :jsonb_path_ops
    add_index :ahoy_events, %i[user_id user_type]
    add_index :ahoy_events, :cloudfront_headers, using: :gin
    add_index :ahoy_events, :admin_action_on_user_id
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
pixelforce_kit-0.9	db/migrate/20220617021719_create_ahoy_visits_and_events.rb