Deprecation Warnings removed; Seeds corrected, Refs: #2070

1 files changed, 0 insertions, 887 deletions

diff --git a/db/schema.rb b/db/schema.rb
deleted file mode 100644
index 18952cfc6..000000000
--- a/db/schema.rb
+++ /dev/null
@@ -1,887 +0,0 @@
-# encoding: UTF-8
-# This file is auto-generated from the current state of the database. Instead
-# of editing this file, please use the migrations feature of Active Record to
-# incrementally modify your database, and then regenerate this schema definition.
-#
-# Note that this schema.rb definition is the authoritative source for your
-# database schema. If you need to create the application database on another
-# system, you should be using db:schema:load, not running all the migrations
-# from scratch. The latter is a flawed and unsustainable approach (the more migrations
-# you'll amass, the slower it'll run and the greater likelihood for issues).
-#
-# It's strongly recommended that you check this file into your version control system.
-
-ActiveRecord::Schema.define(version: 20170410134931) do
-
-  # These are extensions that must be enabled in order to support this database
-  enable_extension "plpgsql"
-  enable_extension "postgis"
-  enable_extension "hstore"
-
-  create_table "access_links", force: true do |t|
-    t.integer  "access_point_id",                        limit: 8
-    t.integer  "stop_area_id",                           limit: 8
-    t.string   "objectid",                               limit: nil,                          null: false
-    t.integer  "object_version",                         limit: 8
-    t.string   "creator_id",                             limit: nil
-    t.string   "name",                                   limit: nil
-    t.string   "comment",                                limit: nil
-    t.decimal  "link_distance",                                      precision: 19, scale: 2
-    t.boolean  "lift_availability"
-    t.boolean  "mobility_restricted_suitability"
-    t.boolean  "stairs_availability"
-    t.time     "default_duration"
-    t.time     "frequent_traveller_duration"
-    t.time     "occasional_traveller_duration"
-    t.time     "mobility_restricted_traveller_duration"
-    t.string   "link_type",                              limit: nil
-    t.integer  "int_user_needs"
-    t.string   "link_orientation",                       limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "access_links", ["objectid"], :name => "access_links_objectid_key", :unique => true
-
-  create_table "access_points", force: true do |t|
-    t.string   "objectid",                        limit: nil
-    t.integer  "object_version",                  limit: 8
-    t.string   "creator_id",                      limit: nil
-    t.string   "name",                            limit: nil
-    t.string   "comment",                         limit: nil
-    t.decimal  "longitude",                                   precision: 19, scale: 16
-    t.decimal  "latitude",                                    precision: 19, scale: 16
-    t.string   "long_lat_type",                   limit: nil
-    t.string   "country_code",                    limit: nil
-    t.string   "street_name",                     limit: nil
-    t.string   "contained_in",                    limit: nil
-    t.time     "openning_time"
-    t.time     "closing_time"
-    t.string   "access_type",                     limit: nil
-    t.boolean  "lift_availability"
-    t.boolean  "mobility_restricted_suitability"
-    t.boolean  "stairs_availability"
-    t.integer  "stop_area_id",                    limit: 8
-    t.string   "zip_code",                        limit: nil
-    t.string   "city_name",                       limit: nil
-    t.text     "import_xml"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "access_points", ["objectid"], :name => "access_points_objectid_key", :unique => true
-
-  create_table "api_keys", force: true do |t|
-    t.integer  "referential_id", limit: 8
-    t.string   "token",          limit: nil
-    t.string   "name",           limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  create_table "calendars", force: true do |t|
-    t.string    "name",            limit: nil
-    t.string    "short_name",      limit: nil
-    t.daterange "date_ranges",                 array: true
-    t.date      "dates",                       array: true
-    t.boolean   "shared"
-    t.integer   "organisation_id", limit: 8
-    t.datetime  "created_at"
-    t.datetime  "updated_at"
-  end
-
-  add_index "calendars", ["organisation_id"], :name => "index_calendars_on_organisation_id"
-  add_index "calendars", ["short_name"], :name => "index_calendars_on_short_name", :unique => true
-
-  create_table "clean_up_results", force: true do |t|
-    t.string   "message_key",       limit: nil
-    t.hstore   "message_attributs"
-    t.integer  "clean_up_id",       limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "clean_up_results", ["clean_up_id"], :name => "index_clean_up_results_on_clean_up_id"
-
-  create_table "clean_ups", force: true do |t|
-    t.string   "status",         limit: nil
-    t.datetime "started_at"
-    t.datetime "ended_at"
-    t.integer  "referential_id", limit: 8
-    t.datetime "begin_date"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.datetime "end_date"
-  end
-
-  add_index "clean_ups", ["referential_id"], :name => "index_clean_ups_on_referential_id"
-
-  create_table "companies", force: true do |t|
-    t.string   "objectid",                  limit: nil, null: false
-    t.integer  "object_version",            limit: 8
-    t.string   "creator_id",                limit: nil
-    t.string   "name",                      limit: nil
-    t.string   "short_name",                limit: nil
-    t.string   "organizational_unit",       limit: nil
-    t.string   "operating_department_name", limit: nil
-    t.string   "code",                      limit: nil
-    t.string   "phone",                     limit: nil
-    t.string   "fax",                       limit: nil
-    t.string   "email",                     limit: nil
-    t.string   "registration_number",       limit: nil
-    t.string   "url",                       limit: nil
-    t.string   "time_zone",                 limit: nil
-    t.integer  "line_referential_id",       limit: 8
-    t.text     "import_xml"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "companies", ["line_referential_id"], :name => "index_companies_on_line_referential_id"
-  add_index "companies", ["objectid"], :name => "companies_objectid_key", :unique => true
-  add_index "companies", ["registration_number"], :name => "companies_registration_number_key"
-
-  create_table "connection_links", force: true do |t|
-    t.integer  "departure_id",                           limit: 8
-    t.integer  "arrival_id",                             limit: 8
-    t.string   "objectid",                               limit: nil,                          null: false
-    t.integer  "object_version",                         limit: 8
-    t.string   "creator_id",                             limit: nil
-    t.string   "name",                                   limit: nil
-    t.string   "comment",                                limit: nil
-    t.decimal  "link_distance",                                      precision: 19, scale: 2
-    t.string   "link_type",                              limit: nil
-    t.time     "default_duration"
-    t.time     "frequent_traveller_duration"
-    t.time     "occasional_traveller_duration"
-    t.time     "mobility_restricted_traveller_duration"
-    t.boolean  "mobility_restricted_suitability"
-    t.boolean  "stairs_availability"
-    t.boolean  "lift_availability"
-    t.integer  "int_user_needs"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "connection_links", ["objectid"], :name => "connection_links_objectid_key", :unique => true
-
-  create_table "delayed_jobs", force: true do |t|
-    t.integer  "priority",   default: 0
-    t.integer  "attempts",   default: 0
-    t.text     "handler"
-    t.text     "last_error"
-    t.datetime "run_at"
-    t.datetime "locked_at"
-    t.datetime "failed_at"
-    t.string   "locked_by"
-    t.string   "queue"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "delayed_jobs", ["priority", "run_at"], :name => "delayed_jobs_priority"
-
-  create_table "exports", force: true do |t|
-    t.integer  "referential_id",  limit: 8
-    t.string   "status",          limit: nil
-    t.string   "type",            limit: nil
-    t.string   "options",         limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "references_type", limit: nil
-    t.string   "reference_ids",   limit: nil
-  end
-
-  add_index "exports", ["referential_id"], :name => "index_exports_on_referential_id"
-
-  create_table "facilities", force: true do |t|
-    t.integer  "stop_area_id",       limit: 8
-    t.integer  "line_id",            limit: 8
-    t.integer  "connection_link_id", limit: 8
-    t.integer  "stop_point_id",      limit: 8
-    t.string   "objectid",           limit: nil,                           null: false
-    t.integer  "object_version",     limit: 8
-    t.datetime "creation_time"
-    t.string   "creator_id",         limit: nil
-    t.string   "name",               limit: nil
-    t.string   "comment",            limit: nil
-    t.string   "description",        limit: nil
-    t.boolean  "free_access"
-    t.decimal  "longitude",                      precision: 19, scale: 16
-    t.decimal  "latitude",                       precision: 19, scale: 16
-    t.string   "long_lat_type",      limit: nil
-    t.decimal  "x",                              precision: 19, scale: 2
-    t.decimal  "y",                              precision: 19, scale: 2
-    t.string   "projection_type",    limit: nil
-    t.string   "country_code",       limit: nil
-    t.string   "street_name",        limit: nil
-    t.string   "contained_in",       limit: nil
-  end
-
-  add_index "facilities", ["objectid"], :name => "facilities_objectid_key", :unique => true
-
-  create_table "facilities_features", id: false, force: true do |t|
-    t.integer "facility_id", limit: 8
-    t.integer "choice_code"
-  end
-
-  create_table "footnotes", force: true do |t|
-    t.integer  "line_id",    limit: 8
-    t.string   "code",       limit: nil
-    t.string   "label",      limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  create_table "footnotes_vehicle_journeys", id: false, force: true do |t|
-    t.integer "vehicle_journey_id", limit: 8
-    t.integer "footnote_id",        limit: 8
-  end
-
-  create_table "group_of_lines", force: true do |t|
-    t.string   "objectid",            limit: nil, null: false
-    t.integer  "object_version",      limit: 8
-    t.string   "creator_id",          limit: nil
-    t.string   "name",                limit: nil
-    t.string   "comment",             limit: nil
-    t.string   "registration_number", limit: nil
-    t.integer  "line_referential_id", limit: 8
-    t.text     "import_xml"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "group_of_lines", ["line_referential_id"], :name => "index_group_of_lines_on_line_referential_id"
-  add_index "group_of_lines", ["objectid"], :name => "group_of_lines_objectid_key", :unique => true
-
-  create_table "group_of_lines_lines", id: false, force: true do |t|
-    t.integer "group_of_line_id", limit: 8
-    t.integer "line_id",          limit: 8
-  end
-
-  create_table "import_messages", force: true do |t|
-    t.integer  "criticity"
-    t.string   "message_key",         limit: nil
-    t.hstore   "message_attributs"
-    t.integer  "import_id",           limit: 8
-    t.integer  "resource_id",         limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.hstore   "resource_attributes"
-  end
-
-  add_index "import_messages", ["import_id"], :name => "index_import_messages_on_import_id"
-  add_index "import_messages", ["resource_id"], :name => "index_import_messages_on_resource_id"
-
-  create_table "import_resources", force: true do |t|
-    t.integer  "import_id",  limit: 8
-    t.string   "status",     limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "type",       limit: nil
-    t.string   "reference",  limit: nil
-    t.string   "name",       limit: nil
-    t.hstore   "metrics"
-  end
-
-  add_index "import_resources", ["import_id"], :name => "index_import_resources_on_import_id"
-
-  create_table "imports", force: true do |t|
-    t.string   "status",                limit: nil
-    t.string   "current_step_id",       limit: nil
-    t.float    "current_step_progress"
-    t.integer  "workbench_id",          limit: 8
-    t.integer  "referential_id",        limit: 8
-    t.string   "name",                  limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "file",                  limit: nil
-    t.datetime "started_at"
-    t.datetime "ended_at"
-    t.string   "token_download",        limit: nil
-    t.string   "type",                  limit: nil
-  end
-
-  add_index "imports", ["referential_id"], :name => "index_imports_on_referential_id"
-  add_index "imports", ["workbench_id"], :name => "index_imports_on_workbench_id"
-
-  create_table "journey_frequencies", force: true do |t|
-    t.integer  "vehicle_journey_id",         limit: 8
-    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",                limit: 8
-  end
-
-  add_index "journey_frequencies", ["timeband_id"], :name => "index_journey_frequencies_on_timeband_id"
-  add_index "journey_frequencies", ["vehicle_journey_id"], :name => "index_journey_frequencies_on_vehicle_journey_id"
-
-  create_table "journey_pattern_sections", force: true do |t|
-    t.integer  "journey_pattern_id", limit: 8, null: false
-    t.integer  "route_section_id",   limit: 8, null: false
-    t.integer  "rank",                         null: false
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "journey_pattern_sections", ["journey_pattern_id", "route_section_id", "rank"], :name => "index_jps_on_journey_pattern_id_and_route_section_id_and_rank", :unique => true
-  add_index "journey_pattern_sections", ["journey_pattern_id"], :name => "index_journey_pattern_sections_on_journey_pattern_id"
-  add_index "journey_pattern_sections", ["route_section_id"], :name => "index_journey_pattern_sections_on_route_section_id"
-
-  create_table "journey_patterns", force: true do |t|
-    t.integer  "route_id",                limit: 8
-    t.string   "objectid",                limit: nil,             null: false
-    t.integer  "object_version",          limit: 8
-    t.string   "creator_id",              limit: nil
-    t.string   "name",                    limit: nil
-    t.string   "comment",                 limit: nil
-    t.string   "registration_number",     limit: nil
-    t.string   "published_name",          limit: nil
-    t.integer  "departure_stop_point_id", limit: 8
-    t.integer  "arrival_stop_point_id",   limit: 8
-    t.integer  "section_status",                      default: 0, null: false
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "journey_patterns", ["objectid"], :name => "journey_patterns_objectid_key", :unique => true
-
-  create_table "journey_patterns_stop_points", id: false, force: true do |t|
-    t.integer "journey_pattern_id", limit: 8
-    t.integer "stop_point_id",      limit: 8
-  end
-
-  add_index "journey_patterns_stop_points", ["journey_pattern_id"], :name => "index_journey_pattern_id_on_journey_patterns_stop_points"
-
-  create_table "line_referential_memberships", force: true do |t|
-    t.integer "organisation_id",     limit: 8
-    t.integer "line_referential_id", limit: 8
-    t.boolean "owner"
-  end
-
-  create_table "line_referential_sync_messages", force: true do |t|
-    t.integer  "criticity"
-    t.string   "message_key",              limit: nil
-    t.hstore   "message_attributs"
-    t.integer  "line_referential_sync_id", limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "line_referential_sync_messages", ["line_referential_sync_id"], :name => "line_referential_sync_id"
-
-  create_table "line_referential_syncs", force: true do |t|
-    t.integer  "line_referential_id", limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.datetime "started_at"
-    t.datetime "ended_at"
-    t.string   "status",              limit: nil
-  end
-
-  add_index "line_referential_syncs", ["line_referential_id"], :name => "index_line_referential_syncs_on_line_referential_id"
-
-  create_table "line_referentials", force: true do |t|
-    t.string   "name",          limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.integer  "sync_interval",             default: 1
-  end
-
-  create_table "lines", force: true do |t|
-    t.integer  "network_id",                      limit: 8
-    t.integer  "company_id",                      limit: 8
-    t.string   "objectid",                        limit: nil,                 null: false
-    t.integer  "object_version",                  limit: 8
-    t.string   "creator_id",                      limit: nil
-    t.string   "name",                            limit: nil
-    t.string   "number",                          limit: nil
-    t.string   "published_name",                  limit: nil
-    t.string   "transport_mode",                  limit: nil
-    t.string   "registration_number",             limit: nil
-    t.string   "comment",                         limit: nil
-    t.boolean  "mobility_restricted_suitability"
-    t.integer  "int_user_needs"
-    t.boolean  "flexible_service"
-    t.string   "url",                             limit: nil
-    t.string   "color",                           limit: 6
-    t.string   "text_color",                      limit: 6
-    t.string   "stable_id",                       limit: nil
-    t.integer  "line_referential_id",             limit: 8
-    t.boolean  "deactivated",                                 default: false
-    t.text     "import_xml"
-    t.string   "transport_submode",               limit: nil
-    t.integer  "secondary_company_ids",           limit: 8,                                array: true
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "lines", ["line_referential_id"], :name => "index_lines_on_line_referential_id"
-  add_index "lines", ["objectid"], :name => "lines_objectid_key", :unique => true
-  add_index "lines", ["registration_number"], :name => "lines_registration_number_key"
-  add_index "lines", ["secondary_company_ids"], :name => "index_lines_on_secondary_company_ids"
-
-  create_table "networks", force: true do |t|
-    t.string   "objectid",            limit: nil, null: false
-    t.integer  "object_version",      limit: 8
-    t.string   "creator_id",          limit: nil
-    t.date     "version_date"
-    t.string   "description",         limit: nil
-    t.string   "name",                limit: nil
-    t.string   "registration_number", limit: nil
-    t.string   "source_name",         limit: nil
-    t.string   "source_type",         limit: nil
-    t.string   "source_identifier",   limit: nil
-    t.string   "comment",             limit: nil
-    t.text     "import_xml"
-    t.integer  "line_referential_id", limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "networks", ["line_referential_id"], :name => "index_networks_on_line_referential_id"
-  add_index "networks", ["objectid"], :name => "networks_objectid_key", :unique => true
-  add_index "networks", ["registration_number"], :name => "networks_registration_number_key"
-
-  create_table "organisations", force: true do |t|
-    t.string   "name",           limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "data_format",    limit: nil, default: "neptune"
-    t.string   "code",           limit: nil
-    t.datetime "synced_at"
-    t.hstore   "sso_attributes"
-  end
-
-  add_index "organisations", ["code"], :name => "index_organisations_on_code", :unique => true
-
-  create_table "pt_links", force: true do |t|
-    t.integer  "start_of_link_id", limit: 8
-    t.integer  "end_of_link_id",   limit: 8
-    t.integer  "route_id",         limit: 8
-    t.string   "objectid",         limit: nil,                          null: false
-    t.integer  "object_version",   limit: 8
-    t.string   "creator_id",       limit: nil
-    t.string   "name",             limit: nil
-    t.string   "comment",          limit: nil
-    t.decimal  "link_distance",                precision: 19, scale: 2
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "pt_links", ["objectid"], :name => "pt_links_objectid_key", :unique => true
-
-  create_table "referential_clonings", force: true do |t|
-    t.string   "status",                limit: nil
-    t.datetime "started_at"
-    t.datetime "ended_at"
-    t.integer  "source_referential_id", limit: 8
-    t.integer  "target_referential_id", limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "referential_clonings", ["source_referential_id"], :name => "index_referential_clonings_on_source_referential_id"
-  add_index "referential_clonings", ["target_referential_id"], :name => "index_referential_clonings_on_target_referential_id"
-
-  create_table "referential_metadata", force: true do |t|
-    t.integer   "referential_id",        limit: 8
-    t.integer   "line_ids",              limit: 8, array: true
-    t.integer   "referential_source_id", limit: 8
-    t.datetime  "created_at"
-    t.datetime  "updated_at"
-    t.daterange "periodes",                        array: true
-  end
-
-  add_index "referential_metadata", ["line_ids"], :name => "index_referential_metadata_on_line_ids"
-  add_index "referential_metadata", ["referential_id"], :name => "index_referential_metadata_on_referential_id"
-  add_index "referential_metadata", ["referential_source_id"], :name => "index_referential_metadata_on_referential_source_id"
-
-  create_table "referentials", force: true do |t|
-    t.string   "name",                     limit: nil
-    t.string   "slug",                     limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "prefix",                   limit: nil
-    t.string   "projection_type",          limit: nil
-    t.string   "time_zone",                limit: nil
-    t.string   "bounds",                   limit: nil
-    t.integer  "organisation_id",          limit: 8
-    t.text     "geographical_bounds"
-    t.integer  "user_id",                  limit: 8
-    t.string   "user_name",                limit: nil
-    t.string   "data_format",              limit: nil
-    t.integer  "line_referential_id",      limit: 8
-    t.integer  "stop_area_referential_id", limit: 8
-    t.integer  "workbench_id",             limit: 8
-    t.datetime "archived_at"
-    t.integer  "created_from_id",          limit: 8
-    t.boolean  "ready",                                default: false
-  end
-
-  add_index "referentials", ["created_from_id"], :name => "index_referentials_on_created_from_id"
-
-  create_table "route_sections", force: true do |t|
-    t.integer  "departure_id",       limit: 8
-    t.integer  "arrival_id",         limit: 8
-    t.spatial  "input_geometry",     limit: {:srid=>4326, :type=>"line_string"}
-    t.spatial  "processed_geometry", limit: {:srid=>4326, :type=>"line_string"}
-    t.string   "objectid",           limit: nil,                                 null: false
-    t.integer  "object_version",     limit: 8
-    t.string   "creator_id",         limit: nil
-    t.float    "distance"
-    t.boolean  "no_processing"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  create_table "routes", force: true do |t|
-    t.integer  "line_id",           limit: 8
-    t.string   "objectid",          limit: nil, null: false
-    t.integer  "object_version",    limit: 8
-    t.string   "creator_id",        limit: nil
-    t.string   "name",              limit: nil
-    t.string   "comment",           limit: nil
-    t.integer  "opposite_route_id", limit: 8
-    t.string   "published_name",    limit: nil
-    t.string   "number",            limit: nil
-    t.string   "direction",         limit: nil
-    t.string   "wayback",           limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "routes", ["objectid"], :name => "routes_objectid_key", :unique => true
-
-  create_table "routing_constraint_zones", force: true do |t|
-    t.string   "name",           limit: nil
-    t.integer  "stop_area_ids",                           array: true
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "objectid",       limit: nil, null: false
-    t.integer  "object_version", limit: 8
-    t.string   "creator_id",     limit: nil
-    t.integer  "route_id",       limit: 8
-  end
-
-  create_table "routing_constraints_lines", id: false, force: true do |t|
-    t.integer "stop_area_id", limit: 8
-    t.integer "line_id",      limit: 8
-  end
-
-  create_table "rule_parameter_sets", force: true do |t|
-    t.text     "parameters"
-    t.string   "name",            limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.integer  "organisation_id", limit: 8
-  end
-
-  create_table "stop_area_referential_memberships", force: true do |t|
-    t.integer "organisation_id",          limit: 8
-    t.integer "stop_area_referential_id", limit: 8
-    t.boolean "owner"
-  end
-
-  create_table "stop_area_referential_sync_messages", force: true do |t|
-    t.integer  "criticity"
-    t.string   "message_key",                   limit: nil
-    t.hstore   "message_attributs"
-    t.integer  "stop_area_referential_sync_id", limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "stop_area_referential_sync_messages", ["stop_area_referential_sync_id"], :name => "stop_area_referential_sync_id"
-
-  create_table "stop_area_referential_syncs", force: true do |t|
-    t.integer  "stop_area_referential_id", limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.datetime "ended_at"
-    t.datetime "started_at"
-    t.string   "status",                   limit: nil
-  end
-
-  add_index "stop_area_referential_syncs", ["stop_area_referential_id"], :name => "index_stop_area_referential_syncs_on_stop_area_referential_id"
-
-  create_table "stop_area_referentials", force: true do |t|
-    t.string   "name",       limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  create_table "stop_areas", force: true do |t|
-    t.integer  "parent_id",                       limit: 8
-    t.string   "objectid",                        limit: nil,                           null: false
-    t.integer  "object_version",                  limit: 8
-    t.string   "creator_id",                      limit: nil
-    t.string   "name",                            limit: nil
-    t.string   "comment",                         limit: nil
-    t.string   "area_type",                       limit: nil
-    t.string   "registration_number",             limit: nil
-    t.string   "nearest_topic_name",              limit: nil
-    t.integer  "fare_code"
-    t.decimal  "longitude",                                   precision: 19, scale: 16
-    t.decimal  "latitude",                                    precision: 19, scale: 16
-    t.string   "long_lat_type",                   limit: nil
-    t.string   "country_code",                    limit: nil
-    t.string   "street_name",                     limit: nil
-    t.boolean  "mobility_restricted_suitability"
-    t.boolean  "stairs_availability"
-    t.boolean  "lift_availability"
-    t.integer  "int_user_needs"
-    t.string   "zip_code",                        limit: nil
-    t.string   "city_name",                       limit: nil
-    t.string   "url",                             limit: nil
-    t.string   "time_zone",                       limit: nil
-    t.integer  "stop_area_referential_id",        limit: 8
-    t.string   "status",                          limit: nil
-    t.text     "import_xml"
-    t.datetime "deleted_at"
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "stif_type",                       limit: nil
-  end
-
-  add_index "stop_areas", ["name"], :name => "index_stop_areas_on_name"
-  add_index "stop_areas", ["objectid"], :name => "stop_areas_objectid_key", :unique => true
-  add_index "stop_areas", ["parent_id"], :name => "index_stop_areas_on_parent_id"
-  add_index "stop_areas", ["stop_area_referential_id"], :name => "index_stop_areas_on_stop_area_referential_id"
-
-  create_table "stop_areas_stop_areas", id: false, force: true do |t|
-    t.integer "child_id",  limit: 8
-    t.integer "parent_id", limit: 8
-  end
-
-  create_table "stop_points", force: true do |t|
-    t.integer  "route_id",       limit: 8
-    t.integer  "stop_area_id",   limit: 8
-    t.string   "objectid",       limit: nil, null: false
-    t.integer  "object_version", limit: 8
-    t.string   "creator_id",     limit: nil
-    t.integer  "position"
-    t.string   "for_boarding",   limit: nil
-    t.string   "for_alighting",  limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  add_index "stop_points", ["objectid"], :name => "stop_points_objectid_key", :unique => true
-
-  create_table "taggings", force: true do |t|
-    t.integer  "tag_id",        limit: 8
-    t.integer  "taggable_id",   limit: 8
-    t.string   "taggable_type", limit: nil
-    t.integer  "tagger_id",     limit: 8
-    t.string   "tagger_type",   limit: nil
-    t.string   "context",       limit: 128
-    t.datetime "created_at"
-  end
-
-  add_index "taggings", ["tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type"], :name => "taggings_idx", :unique => true
-  add_index "taggings", ["taggable_id", "taggable_type", "context"], :name => "index_taggings_on_taggable_id_and_taggable_type_and_context"
-
-  create_table "tags", force: true do |t|
-    t.string  "name",           limit: nil
-    t.integer "taggings_count",             default: 0
-  end
-
-  add_index "tags", ["name"], :name => "index_tags_on_name", :unique => true
-
-  create_table "time_table_dates", force: true do |t|
-    t.integer "time_table_id", limit: 8, null: false
-    t.date    "date"
-    t.integer "position",                null: false
-    t.boolean "in_out"
-  end
-
-  add_index "time_table_dates", ["time_table_id"], :name => "index_time_table_dates_on_time_table_id"
-
-  create_table "time_table_periods", force: true do |t|
-    t.integer "time_table_id", limit: 8, null: false
-    t.date    "period_start"
-    t.date    "period_end"
-    t.integer "position",                null: false
-  end
-
-  add_index "time_table_periods", ["time_table_id"], :name => "index_time_table_periods_on_time_table_id"
-
-  create_table "time_tables", force: true do |t|
-    t.string   "objectid",       limit: nil,             null: false
-    t.integer  "object_version", limit: 8,   default: 1
-    t.string   "creator_id",     limit: nil
-    t.string   "version",        limit: nil
-    t.string   "comment",        limit: nil
-    t.integer  "int_day_types",              default: 0
-    t.date     "start_date"
-    t.date     "end_date"
-    t.integer  "calendar_id",    limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.string   "color"
-  end
-
-  add_index "time_tables", ["calendar_id"], :name => "index_time_tables_on_calendar_id"
-  add_index "time_tables", ["objectid"], :name => "time_tables_objectid_key", :unique => true
-
-  create_table "time_tables_vehicle_journeys", id: false, force: true do |t|
-    t.integer "time_table_id",      limit: 8
-    t.integer "vehicle_journey_id", limit: 8
-  end
-
-  add_index "time_tables_vehicle_journeys", ["time_table_id"], :name => "index_time_tables_vehicle_journeys_on_time_table_id"
-  add_index "time_tables_vehicle_journeys", ["vehicle_journey_id"], :name => "index_time_tables_vehicle_journeys_on_vehicle_journey_id"
-
-  create_table "timebands", force: true do |t|
-    t.string   "objectid",       limit: nil, null: false
-    t.integer  "object_version", limit: 8
-    t.string   "creator_id",     limit: nil
-    t.string   "name",           limit: nil
-    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",                  limit: nil, default: "", null: false
-    t.string   "encrypted_password",     limit: nil, default: ""
-    t.string   "reset_password_token",   limit: nil
-    t.datetime "reset_password_sent_at"
-    t.datetime "remember_created_at"
-    t.integer  "sign_in_count",                      default: 0
-    t.datetime "current_sign_in_at"
-    t.datetime "last_sign_in_at"
-    t.string   "current_sign_in_ip",     limit: nil
-    t.string   "last_sign_in_ip",        limit: nil
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.integer  "organisation_id",        limit: 8
-    t.string   "name",                   limit: nil
-    t.string   "confirmation_token",     limit: nil
-    t.datetime "confirmed_at"
-    t.datetime "confirmation_sent_at"
-    t.string   "unconfirmed_email",      limit: nil
-    t.integer  "failed_attempts",                    default: 0
-    t.string   "unlock_token",           limit: nil
-    t.datetime "locked_at"
-    t.string   "authentication_token",   limit: nil
-    t.string   "invitation_token",       limit: nil
-    t.datetime "invitation_sent_at"
-    t.datetime "invitation_accepted_at"
-    t.integer  "invitation_limit"
-    t.integer  "invited_by_id",          limit: 8
-    t.string   "invited_by_type",        limit: nil
-    t.datetime "invitation_created_at"
-    t.string   "username",               limit: nil
-    t.datetime "synced_at"
-    t.string   "permissions",            limit: nil,                           array: true
-  end
-
-  add_index "users", ["email"], :name => "index_users_on_email", :unique => true
-  add_index "users", ["invitation_token"], :name => "index_users_on_invitation_token", :unique => true
-  add_index "users", ["reset_password_token"], :name => "index_users_on_reset_password_token", :unique => true
-  add_index "users", ["username"], :name => "index_users_on_username", :unique => true
-
-  create_table "vehicle_journey_at_stops", force: true do |t|
-    t.integer "vehicle_journey_id",             limit: 8
-    t.integer "stop_point_id",                  limit: 8
-    t.string  "connecting_service_id",          limit: nil
-    t.string  "boarding_alighting_possibility", limit: nil
-    t.time    "arrival_time"
-    t.time    "departure_time"
-    t.string  "for_boarding",                   limit: nil
-    t.string  "for_alighting",                  limit: nil
-    t.integer "departure_day_offset"
-    t.integer "arrival_day_offset"
-  end
-
-  add_index "vehicle_journey_at_stops", ["stop_point_id"], :name => "index_vehicle_journey_at_stops_on_stop_pointid"
-  add_index "vehicle_journey_at_stops", ["vehicle_journey_id"], :name => "index_vehicle_journey_at_stops_on_vehicle_journey_id"
-
-  create_table "vehicle_journeys", force: true do |t|
-    t.integer  "route_id",                        limit: 8
-    t.integer  "journey_pattern_id",              limit: 8
-    t.integer  "company_id",                      limit: 8
-    t.string   "objectid",                        limit: nil,             null: false
-    t.integer  "object_version",                  limit: 8
-    t.string   "creator_id",                      limit: nil
-    t.string   "comment",                         limit: nil
-    t.string   "status_value",                    limit: nil
-    t.string   "transport_mode",                  limit: nil
-    t.string   "published_journey_name",          limit: nil
-    t.string   "published_journey_identifier",    limit: nil
-    t.string   "facility",                        limit: nil
-    t.string   "vehicle_type_identifier",         limit: nil
-    t.integer  "number",                          limit: 8
-    t.boolean  "mobility_restricted_suitability"
-    t.boolean  "flexible_service"
-    t.integer  "journey_category",                            default: 0, null: false
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  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"
-
-  create_table "workbenches", force: true do |t|
-    t.string   "name",                     limit: nil
-    t.integer  "organisation_id",          limit: 8
-    t.datetime "created_at"
-    t.datetime "updated_at"
-    t.integer  "line_referential_id",      limit: 8
-    t.integer  "stop_area_referential_id", limit: 8
-  end
-
-  add_index "workbenches", ["line_referential_id"], :name => "index_workbenches_on_line_referential_id"
-  add_index "workbenches", ["organisation_id"], :name => "index_workbenches_on_organisation_id"
-  add_index "workbenches", ["stop_area_referential_id"], :name => "index_workbenches_on_stop_area_referential_id"
-
-  Foreigner.load
-  add_foreign_key "access_links", "access_points", name: "aclk_acpt_fkey"
-
-  add_foreign_key "group_of_lines_lines", "group_of_lines", name: "groupofline_group_fkey", dependent: :delete
-
-  add_foreign_key "journey_frequencies", "timebands", name: "fk_rails_60bb6f7bd3", dependent: :nullify
-  add_foreign_key "journey_frequencies", "vehicle_journeys", name: "fk_rails_d322c5d659", dependent: :nullify
-
-  add_foreign_key "journey_pattern_sections", "journey_patterns", name: "fk_rails_73ae46b20f", dependent: :delete
-  add_foreign_key "journey_pattern_sections", "route_sections", name: "fk_rails_0dbc726f14", dependent: :delete
-
-  add_foreign_key "journey_patterns", "routes", name: "jp_route_fkey", dependent: :delete
-  add_foreign_key "journey_patterns", "stop_points", name: "arrival_point_fkey", column: "arrival_stop_point_id", dependent: :nullify
-  add_foreign_key "journey_patterns", "stop_points", name: "departure_point_fkey", column: "departure_stop_point_id", dependent: :nullify
-
-  add_foreign_key "journey_patterns_stop_points", "journey_patterns", name: "jpsp_jp_fkey", dependent: :delete
-  add_foreign_key "journey_patterns_stop_points", "stop_points", name: "jpsp_stoppoint_fkey", dependent: :delete
-
-  add_foreign_key "route_sections", "stop_areas", name: "fk_rails_97b8dcfe1a", column: "departure_id"
-  add_foreign_key "route_sections", "stop_areas", name: "fk_rails_df1612606f", column: "arrival_id"
-
-  add_foreign_key "routes", "routes", name: "route_opposite_route_fkey", column: "opposite_route_id"
-
-  add_foreign_key "stop_areas", "stop_areas", name: "area_parent_fkey", column: "parent_id", dependent: :nullify
-
-  add_foreign_key "stop_areas_stop_areas", "stop_areas", name: "stoparea_child_fkey", column: "child_id", dependent: :delete
-  add_foreign_key "stop_areas_stop_areas", "stop_areas", name: "stoparea_parent_fkey", column: "parent_id", dependent: :delete
-
-  add_foreign_key "stop_points", "routes", name: "stoppoint_route_fkey", dependent: :delete
-
-  add_foreign_key "time_table_dates", "time_tables", name: "tm_date_fkey", dependent: :delete
-
-  add_foreign_key "time_table_periods", "time_tables", name: "tm_period_fkey", dependent: :delete
-
-  add_foreign_key "time_tables_vehicle_journeys", "time_tables", name: "vjtm_tm_fkey", dependent: :delete
-  add_foreign_key "time_tables_vehicle_journeys", "vehicle_journeys", name: "vjtm_vj_fkey", dependent: :delete
-
-  add_foreign_key "vehicle_journey_at_stops", "stop_points", name: "vjas_sp_fkey", dependent: :delete
-  add_foreign_key "vehicle_journey_at_stops", "vehicle_journeys", name: "vjas_vj_fkey", dependent: :delete
-
-  add_foreign_key "vehicle_journeys", "journey_patterns", name: "vj_jp_fkey", dependent: :delete
-  add_foreign_key "vehicle_journeys", "routes", name: "vj_route_fkey", dependent: :delete
-
-end