cirandas.net

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

class InitAnalyticsPlugin < ActiveRecord::Migration

  def up
    create_table :analytics_plugin_visits do |t|
      t.integer :profile_id
    end

    create_table :analytics_plugin_page_views do |t|
      t.string :type
      t.integer :visit_id
      t.integer :track_id
      t.integer :referer_page_view_id
      t.string :request_id

      t.integer :user_id
      t.integer :session_id
      t.integer :profile_id

      t.text :url
      t.text :referer_url

      t.text :user_agent
      t.string :remote_ip

      t.datetime :request_started_at
      t.datetime :request_finished_at
      t.datetime :page_loaded_at
      t.integer :time_on_page, default: 0

      t.text :data, default: {}.to_yaml
    end
    add_index :analytics_plugin_page_views, :request_id
    add_index :analytics_plugin_page_views, :referer_page_view_id

    add_index :analytics_plugin_page_views, :user_id
    add_index :analytics_plugin_page_views, :session_id
    add_index :analytics_plugin_page_views, :profile_id
    add_index :analytics_plugin_page_views, :url
    add_index :analytics_plugin_page_views, [:user_id, :session_id, :profile_id, :url], name: :analytics_plugin_referer_find
  end

  def down
    drop_table :analytics_plugin_visits
    drop_table :analytics_plugin_page_views
  end

end