Contents

class CreateChouetteVehicleJourney < ActiveRecord::Migration
  def up
    create_table :vehicle_journeys, :force => true do |t|
      t.integer  "route_id", :limit => 8
      t.integer  "journey_pattern_id", :limit => 8
      t.integer  "time_slot_id", :limit => 8
      t.integer  "company_id", :limit => 8

      t.string   "objectid", :null => false
      t.integer  "object_version"
      t.datetime "creation_time"
      t.string   "creator_id"

      t.string   "comment"
      t.string   "status_value"
      t.string   "transport_mode"
      t.string   "published_journey_name"
      t.string   "published_journey_identifier"
      t.string   "facility"
      t.string   "vehicle_type_identifier"

      # TODO: delete this column that are here just for chouette-command compliance
      t.integer  "number"
    end
   add_index "vehicle_journeys", ["objectid"], :name => "vehicle_journeys_objectid_key", :unique => true
   add_index "vehicle_journeys", ["route_id"], :name => "index_vehicle_journeys_on_route_id"
  end

  def down
   remove_index "vehicle_journeys", :name => "vehicle_journeys_objectid_key"
   remove_index "vehicle_journeys", :name => "index_vehicle_journeys_on_route_id"
   drop_table :vehicle_journeys
  end
end

Version data entries

23 entries across 23 versions & 1 rubygems

Version	Path
ninoxe-1.2.3	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.2.2	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.2.1	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.2.0	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.1.5	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.1.4	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.1.3	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.1.2	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.1.1	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.1.0	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.0.3	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.0.2	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.0.1	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-1.0.0	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-0.1.6	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-0.1.5	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-0.1.4	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-0.1.3	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-0.1.2	db/migrate/20120521073746_create_chouette_vehicle_journey.rb
ninoxe-0.1.1	db/migrate/20120521073746_create_chouette_vehicle_journey.rb