Class: VanityMigration

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/templates/vanity_migration.rb

Class Method Summary (collapse)

Class Method Details

+ (Object) down 



46
47
48
49
50
51
52
 
# File 'lib/generators/templates/vanity_migration.rb', line 46

def self.down
  drop_table :vanity_metrics
  drop_table :vanity_metric_values
  drop_table :vanity_experiments
  drop_table :vanity_conversions
  drop_table :vanity_participants
end

+ (Object) up 



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
 
# File 'lib/generators/templates/vanity_migration.rb', line 2

def self.up
  create_table :vanity_metrics do |t|
    t.string :metric_id
    t.datetime :updated_at
  end
  add_index :vanity_metrics, [:metric_id]

  create_table :vanity_metric_values do |t|
    t.integer :vanity_metric_id
    t.integer :index
    t.integer :value
    t.string :date
  end
  add_index :vanity_metric_values, [:vanity_metric_id]

  create_table :vanity_experiments do |t|
    t.string :experiment_id
    t.integer :outcome
    t.datetime :created_at
    t.datetime :completed_at
  end
  add_index :vanity_experiments, [:experiment_id]

  create_table :vanity_conversions do |t|
    t.integer :vanity_experiment_id
    t.integer :alternative
    t.integer :conversions
  end
  add_index :vanity_conversions, [:vanity_experiment_id, :alternative], :name => "by_experiment_id_and_alternative"

  create_table :vanity_participants do |t|
    t.string :experiment_id
    t.string :identity
    t.integer :shown
    t.integer :seen
    t.integer :converted
  end
  add_index :vanity_participants, [:experiment_id]
  add_index :vanity_participants, [:experiment_id, :identity], :name => "by_experiment_id_and_identity"
  add_index :vanity_participants, [:experiment_id, :shown], :name => "by_experiment_id_and_shown"
  add_index :vanity_participants, [:experiment_id, :seen], :name => "by_experiment_id_and_seen"
  add_index :vanity_participants, [:experiment_id, :converted], :name => "by_experiment_id_and_converted"
end