Contents

class CreateDateRanges < ActiveRecord::Migration[4.2]
  def change
    create_table :report_cat_date_ranges do |t|
      t.date :start_date
      t.date :stop_date
      t.string :period

      t.index [ :period, :start_date ], :unique => true
      t.index [ :period, :stop_date ], :unique => true
      t.index [ :period, :start_date, :stop_date ], :unique => true, :name => 'index_report_cat_date_ranges_on_period_and_dates'
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
report_cat-5.0.3	db/migrate/20130918075200_create_date_ranges.rb
report_cat-5.0.2	db/migrate/20130918075200_create_date_ranges.rb
report_cat-5.0.1	db/migrate/20130918075200_create_date_ranges.rb