Contents

class CreateAdvancedSearch < ActiveRecord::Migration
  def change
    create_table :segments, :force => true do |t|
      t.string  :name,            :null => false
      t.integer :organization_id, :null => false
      t.integer :search_id,       :null => false

      t.timestamps
    end
    add_index :segments, :organization_id
    add_index :segments, :search_id

    create_table "searches" do |t|
      t.integer  "organization_id",      :null => false
      t.string   "zip"
      t.string   "state"
      t.integer  "event_id"
      t.integer  "min_lifetime_value"
      t.integer  "min_donations_amount"
      t.integer  "max_lifetime_value"
      t.integer  "max_donations_amount"
      t.datetime "min_donations_date"
      t.datetime "max_donations_date"
      t.string   "tagging"

      t.timestamps
    end
    add_index :searches, :organization_id
  end
end

Version data entries

35 entries across 35 versions & 1 rubygems

Version	Path
artfully_ose-1.3.0.pre4	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.3.0.pre3	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.3.0.pre2	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.3.0.pre1	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.beta.1	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.alpha.2	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.alpha.1	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.27	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.26	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.24	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.23	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.21	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.20	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.19	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.18	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.17	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.16	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.15	db/migrate/20120831200120_create_advanced_search.rb
artfully_ose-1.2.0.pre.12	db/migrate/20120831200120_create_advanced_search.rb