 |
migration.rb - reportable - Fork of reportable required by WarVox, from hdm/rep… |
 |
git clone git://jay.scot/reportable |
 |
Log |
|
Files |
|
Refs |
|
README |
|
--- |
|
migration.rb (1250B) |
|
--- |
|
1 class CreateReportableCache < ActiveRecord::Migration |
|
2 |
|
3 def self.up |
|
4 create_table :reportable_cache, :force => true do |t| |
|
5 t.string :model_name, :null => false, :limit => 100 |
|
6 t.string :report_name, :null => false, :limit => 100 |
|
7 t.string :grouping, :null => false, :limit => 10 |
|
8 t.string :aggregation, :null => false, :limit => 10 |
|
9 t.string :conditions, :null => false, :limit => 100 |
|
10 t.float :value, :null => false, :defa… |
|
11 t.datetime :reporting_period, :null => false |
|
12 |
|
13 t.timestamps |
|
14 end |
|
15 |
|
16 add_index :reportable_cache, [ |
|
17 :model_name, |
|
18 :report_name, |
|
19 :grouping, |
|
20 :aggregation, |
|
21 :conditions |
|
22 ], :name => :name_model_grouping_agregation |
|
23 add_index :reportable_cache, [ |
|
24 :model_name, |
|
25 :report_name, |
|
26 :grouping, |
|
27 :aggregation, |
|
28 :conditions, |
|
29 :reporting_period |
|
30 ], :unique => true, :name => :name_model_grouping_aggregation_period |
|
31 end |
|
32 |
|
33 def self.down |
|
34 remove_index :reportable_cache, :name => :name_model_grouping_agrega… |
|
35 remove_index :reportable_cache, :name => :name_model_grouping_aggreg… |
|
36 |
|
37 drop_table :reportable_cache |
|
38 end |
|
39 |
|
40 end |
