Contents

class DropRunStartMinuteFromApplicationSchedules < ActiveRecord::Migration
  def up
    execute <<-SQL
			ALTER TABLE #{Naf.schema_name}.application_schedules DROP COLUMN run_start_minute;
			ALTER TABLE #{Naf.schema_name}.application_schedules ALTER COLUMN run_interval SET NOT NULL;
			ALTER TABLE #{Naf.schema_name}.application_schedules ALTER COLUMN run_interval_style_id SET NOT NULL;
    SQL
  end

  def down
    execute <<-SQL
      ALTER TABLE #{Naf.schema_name}.application_schedules ADD COLUMN run_start_minute INTEGER NULL
      	CHECK (run_start_minute >= 0 and run_start_minute < (24 * 60));
			ALTER TABLE #{Naf.schema_name}.application_schedules ALTER COLUMN run_interval DROP NOT NULL;
			ALTER TABLE #{Naf.schema_name}.application_schedules ALTER COLUMN run_interval_style_id DROP NOT NULL;
    SQL
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
naf-2.1.2	db/migrate/20140113183243_drop_run_start_minute_from_application_schedules.rb
naf-2.1.1	db/migrate/20140113183243_drop_run_start_minute_from_application_schedules.rb
naf-2.1.0	db/migrate/20140113183243_drop_run_start_minute_from_application_schedules.rb