schema.rb - reportable - Fork of reportable required by WarVox, from hdm/reportable.
 (HTM) git clone git://jay.scot/reportable
 (DIR) Log
 (DIR) Files
 (DIR) Refs
 (DIR) README
       ---
       schema.rb (1221B)
       ---
            1 ActiveRecord::Schema.define(:version => 1) do
            2 
            3   create_table :users, :force => true do |t|
            4     t.string  :login,          :null => false
            5     t.integer :profile_visits, :null => false, :default => 0
            6     t.string  :type,           :null => false, :default => 'User'
            7     t.string  :sub_type
            8 
            9     t.timestamps
           10   end
           11 
           12   create_table :reportable_cache, :force => true do |t|
           13     t.string   :model_name,       :null => false, :limit => 100
           14     t.string   :report_name,      :null => false, :limit => 100
           15     t.string   :grouping,         :null => false, :limit => 10
           16     t.string   :aggregation,      :null => false, :limit => 10
           17     t.string   :conditions,       :null => false, :limit => 100
           18     t.float    :value,            :null => false,                :default => 0
           19     t.datetime :reporting_period, :null => false
           20 
           21     t.timestamps
           22   end
           23   add_index :reportable_cache, [
           24     :model_name,
           25     :report_name,
           26     :grouping,
           27     :aggregation,
           28     :conditions
           29   ], :name => 'name_model_grouping_agregation'
           30   add_index :reportable_cache, [
           31     :model_name,
           32     :report_name,
           33     :grouping,
           34     :aggregation,
           35     :conditions,
           36     :reporting_period
           37   ], :unique => true, :name => 'name_model_grouping_aggregation_period'
           38 
           39 end