Add limit and FK to JourneyFrequency

1 files changed, 16 insertions, 0 deletions

diff --git a/db/migrate/20151215175635_add_limit_and_foreign_key_to_journey_frequencies.ninoxe_engine.rb b/db/migrate/20151215175635_add_limit_and_foreign_key_to_journey_frequencies.ninoxe_engine.rb
new file mode 100644
index 000000000..fc8869f1c
--- /dev/null
+++ b/db/migrate/20151215175635_add_limit_and_foreign_key_to_journey_frequencies.ninoxe_engine.rb
@@ -0,0 +1,16 @@
+# This migration comes from ninoxe_engine (originally 20151215175245)
+class AddLimitAndForeignKeyToJourneyFrequencies < ActiveRecord::Migration
+  def up
+    change_column :journey_frequencies, :vehicle_journey_id, :integer, limit: 8
+    change_column :journey_frequencies, :timeband_id, :integer, limit: 8
+    add_foreign_key :journey_frequencies, :vehicle_journeys, dependent: :nullify
+    add_foreign_key :journey_frequencies, :timebands, dependent: :nullify
+  end
+
+  def down
+    change_column :journey_frequencies, :vehicle_journey_id, :integer, limit: 4
+    change_column :journey_frequencies, :timeband_id, :integer, limit: 4
+    remove_foreign_key :journey_frequencies, :vehicle_journeys
+    remove_foreign_key :journey_frequencies, :timebands
+  end
+end