Sha256: f7bb462c6146f7e7cd5651b53600c991fe77792edb18d82a5a60d37b604ef9f0

Contents?: true

Size: 707 Bytes

Versions: 68

Compression:

Stored size: 707 Bytes

Contents

class CreateAwakePeriods < ActiveRecord::Migration
  def change
    create_table :awake_periods do |t|
      t.references :participant, index: true, null: false
      t.datetime :start_time, null: false
      t.datetime :end_time, null: false

      t.timestamps
    end

    reversible do |dir|
      dir.up do
        execute <<-SQL
          ALTER TABLE awake_periods
            ADD CONSTRAINT fk_awake_periods_participants
            FOREIGN KEY (participant_id)
            REFERENCES participants(id)
        SQL
      end

      dir.down do
        execute <<-SQL
          ALTER TABLE awake_periods
            DROP CONSTRAINT fk_awake_periods_participants
        SQL
      end
    end
  end
end

Version data entries

68 entries across 68 versions & 1 rubygems

Version Path
think_feel_do_engine-3.22.9 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.22.8 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.22.7 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.22.6 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.22.5 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.22.4 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.22.2 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.22.1 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.22.0 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.21.2 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.21.1 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.21.0 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.20.1 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.19.9 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.19.8 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.19.7 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.19.6 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.19.5 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.19.4 db/migrate/20140221214020_create_awake_periods.rb
think_feel_do_engine-3.19.3 db/migrate/20140221214020_create_awake_periods.rb