diff options
Diffstat (limited to 'db')
5 files changed, 84 insertions, 2 deletions
diff --git a/db/migrate/20151015150300_create_journey_frequencies.ninoxe_engine.rb b/db/migrate/20151015150300_create_journey_frequencies.ninoxe_engine.rb new file mode 100644 index 000000000..e5c763ab7 --- /dev/null +++ b/db/migrate/20151015150300_create_journey_frequencies.ninoxe_engine.rb @@ -0,0 +1,14 @@ +# This migration comes from ninoxe_engine (originally 20151015143707) +class CreateJourneyFrequencies < ActiveRecord::Migration + def change + create_table :journey_frequencies do |t| + t.references :vehicle_journey, index: true + t.time :scheduled_headway_interval, null: false + t.time :first_departure_time, null: false + t.time :last_departure_time + t.boolean :exact_time, default: false + + t.timestamps + end + end +end diff --git a/db/migrate/20151022150419_add_journey_category_to_vehicle_journey.ninoxe_engine.rb b/db/migrate/20151022150419_add_journey_category_to_vehicle_journey.ninoxe_engine.rb new file mode 100644 index 000000000..b8af53f24 --- /dev/null +++ b/db/migrate/20151022150419_add_journey_category_to_vehicle_journey.ninoxe_engine.rb @@ -0,0 +1,6 @@ +# This migration comes from ninoxe_engine (originally 20151022150156) +class AddJourneyCategoryToVehicleJourney < ActiveRecord::Migration + def change + add_column :vehicle_journeys, :journey_category, :integer, null: false, default: 0 + end +end diff --git a/db/migrate/20151023101306_create_timebands.ninoxe_engine.rb b/db/migrate/20151023101306_create_timebands.ninoxe_engine.rb new file mode 100644 index 000000000..3758fdf09 --- /dev/null +++ b/db/migrate/20151023101306_create_timebands.ninoxe_engine.rb @@ -0,0 +1,16 @@ +# This migration comes from ninoxe_engine (originally 20151023083836) +class CreateTimebands < ActiveRecord::Migration + def change + create_table :timebands do |t| + t.string "objectid", :null => false + t.integer "object_version" + t.datetime "creation_time" + t.string "creator_id" + t.string :name + t.time :start_time, null: false + t.time :end_time, null: false + + t.timestamps + end + end +end diff --git a/db/migrate/20151028105423_add_timeband_id_to_journey_frequencies.ninoxe_engine.rb b/db/migrate/20151028105423_add_timeband_id_to_journey_frequencies.ninoxe_engine.rb new file mode 100644 index 000000000..094efa005 --- /dev/null +++ b/db/migrate/20151028105423_add_timeband_id_to_journey_frequencies.ninoxe_engine.rb @@ -0,0 +1,6 @@ +# This migration comes from ninoxe_engine (originally 20151028105340) +class AddTimebandIdToJourneyFrequencies < ActiveRecord::Migration + def change + add_reference :journey_frequencies, :timeband, index: true + end +end diff --git a/db/schema.rb b/db/schema.rb index b68c3190a..38b935b6c 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20150922095511) do +ActiveRecord::Schema.define(version: 20151028105423) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" @@ -134,6 +134,19 @@ ActiveRecord::Schema.define(version: 20150922095511) do add_index "delayed_jobs", ["priority", "run_at"], name: "delayed_jobs_priority", using: :btree + create_table "exports", force: true do |t| + t.integer "referential_id", limit: 8 + t.string "status" + t.string "type" + t.string "options" + t.datetime "created_at" + t.datetime "updated_at" + t.string "references_type" + t.string "reference_ids" + end + + add_index "exports", ["referential_id"], name: "index_exports_on_referential_id", using: :btree + create_table "facilities", force: true do |t| t.integer "stop_area_id", limit: 8 t.integer "line_id", limit: 8 @@ -195,6 +208,20 @@ ActiveRecord::Schema.define(version: 20150922095511) do t.integer "line_id", limit: 8 end + create_table "journey_frequencies", force: true do |t| + t.integer "vehicle_journey_id" + t.time "scheduled_headway_interval", null: false + t.time "first_departure_time", null: false + t.time "last_departure_time" + t.boolean "exact_time", default: false + t.datetime "created_at" + t.datetime "updated_at" + t.integer "timeband_id" + end + + add_index "journey_frequencies", ["timeband_id"], name: "index_journey_frequencies_on_timeband_id", using: :btree + add_index "journey_frequencies", ["vehicle_journey_id"], name: "index_journey_frequencies_on_vehicle_journey_id", using: :btree + create_table "journey_patterns", force: true do |t| t.integer "route_id", limit: 8 t.string "objectid", null: false @@ -452,6 +479,18 @@ ActiveRecord::Schema.define(version: 20150922095511) do add_index "time_tables_vehicle_journeys", ["time_table_id"], name: "index_time_tables_vehicle_journeys_on_time_table_id", using: :btree add_index "time_tables_vehicle_journeys", ["vehicle_journey_id"], name: "index_time_tables_vehicle_journeys_on_vehicle_journey_id", using: :btree + create_table "timebands", force: true do |t| + t.string "objectid", null: false + t.integer "object_version" + t.datetime "creation_time" + t.string "creator_id" + t.string "name" + t.time "start_time", null: false + t.time "end_time", null: false + t.datetime "created_at" + t.datetime "updated_at" + end + create_table "users", force: true do |t| t.string "email", default: "", null: false t.string "encrypted_password", default: "" @@ -510,7 +549,7 @@ ActiveRecord::Schema.define(version: 20150922095511) do 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.string "objectid", null: false t.integer "object_version" t.datetime "creation_time" t.string "creator_id" @@ -524,6 +563,7 @@ ActiveRecord::Schema.define(version: 20150922095511) do t.integer "number", limit: 8 t.boolean "mobility_restricted_suitability" t.boolean "flexible_service" + t.integer "journey_category", default: 0, null: false end add_index "vehicle_journeys", ["objectid"], name: "vehicle_journeys_objectid_key", unique: true, using: :btree |