diff options
| author | Xinhui | 2017-02-20 11:51:58 +0100 |
|---|---|---|
| committer | Xinhui | 2017-02-20 11:52:06 +0100 |
| commit | 893cc9d5683ae04e202cbe0560261b2a7c2f90fb (patch) | |
| tree | 5c6007073bb31d3879131ffb8edf6f99f12d6208 /db | |
| parent | 86cd6fb168b94debc3fc0eb99ac61f1a9b9b0049 (diff) | |
| download | chouette-core-893cc9d5683ae04e202cbe0560261b2a7c2f90fb.tar.bz2 | |
Vehicle Journey update state for arrival & departure time
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema.rb | 69 |
1 files changed, 39 insertions, 30 deletions
diff --git a/db/schema.rb b/db/schema.rb index 2a1c0334c..1436aee37 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,8 +11,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20170213163747) do - +ActiveRecord::Schema.define(version: 20170215163027) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" enable_extension "postgis" @@ -22,7 +21,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do t.integer "access_point_id", limit: 8 t.integer "stop_area_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "comment" @@ -45,7 +44,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do create_table "access_points", force: true do |t| t.string "objectid" - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "comment" @@ -117,8 +116,8 @@ ActiveRecord::Schema.define(version: 20170213163747) do add_index "clean_ups", ["referential_id"], :name => "index_clean_ups_on_referential_id" create_table "companies", force: true do |t| - t.string "objectid", null: false - t.integer "object_version" + t.string "objectid", null: false + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "short_name" @@ -145,7 +144,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do t.integer "departure_id", limit: 8 t.integer "arrival_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "comment" @@ -184,7 +183,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do t.integer "connection_link_id", limit: 8 t.integer "stop_point_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.datetime "creation_time" t.string "creator_id" t.string "name" @@ -223,8 +222,8 @@ ActiveRecord::Schema.define(version: 20170213163747) do end create_table "group_of_lines", force: true do |t| - t.string "objectid", null: false - t.integer "object_version" + t.string "objectid", null: false + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "comment" @@ -272,7 +271,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do create_table "journey_patterns", force: true do |t| t.integer "route_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "comment" @@ -333,7 +332,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do t.integer "network_id", limit: 8 t.integer "company_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "number" @@ -363,8 +362,8 @@ ActiveRecord::Schema.define(version: 20170213163747) do add_index "lines", ["secondary_company_ids"], :name => "index_lines_on_secondary_company_ids" create_table "networks", force: true do |t| - t.string "objectid", null: false - t.integer "object_version" + t.string "objectid", null: false + t.integer "object_version", limit: 8 t.string "creator_id" t.date "version_date" t.string "description" @@ -401,7 +400,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do t.integer "end_of_link_id", limit: 8 t.integer "route_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "comment" @@ -466,7 +465,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do t.integer "departure_id", limit: 8 t.integer "arrival_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.float "distance" t.boolean "no_processing" @@ -479,7 +478,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do create_table "routes", force: true do |t| t.integer "line_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "comment" @@ -496,12 +495,12 @@ ActiveRecord::Schema.define(version: 20170213163747) do create_table "routing_constraint_zones", force: true do |t| t.string "name" - t.integer "stop_area_ids", array: true + t.integer "stop_area_ids", array: true t.integer "line_id" t.datetime "created_at" t.datetime "updated_at" - t.string "objectid", null: false - t.integer "object_version" + t.string "objectid", null: false + t.integer "object_version", limit: 8 t.string "creator_id" end @@ -557,7 +556,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do create_table "stop_areas", force: true do |t| t.integer "parent_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" t.string "comment" @@ -600,7 +599,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do t.integer "route_id", limit: 8 t.integer "stop_area_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.integer "position" t.string "for_boarding" @@ -650,12 +649,12 @@ ActiveRecord::Schema.define(version: 20170213163747) do 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", null: false - t.integer "object_version", default: 1 + t.string "objectid", null: false + t.integer "object_version", limit: 8, default: 1 t.string "creator_id" t.string "version" t.string "comment" - t.integer "int_day_types", default: 0 + t.integer "int_day_types", default: 0 t.date "start_date" t.date "end_date" t.integer "calendar_id" @@ -675,12 +674,22 @@ ActiveRecord::Schema.define(version: 20170213163747) do 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", null: false - t.integer "object_version" + t.string "objectid", null: false + t.integer "object_version", limit: 8 t.string "creator_id" t.string "name" - t.time "start_time", null: false - t.time "end_time", null: false + t.time "start_time", null: false + t.time "end_time", null: false + t.datetime "created_at" + t.datetime "updated_at" + end + + create_table "translations", force: true do |t| + t.string "locale" + t.string "key" + t.text "value" + t.text "interpolations" + t.boolean "is_proc", default: false t.datetime "created_at" t.datetime "updated_at" end @@ -744,7 +753,7 @@ ActiveRecord::Schema.define(version: 20170213163747) do t.integer "journey_pattern_id", limit: 8 t.integer "company_id", limit: 8 t.string "objectid", null: false - t.integer "object_version" + t.integer "object_version", limit: 8 t.string "creator_id" t.string "comment" t.string "status_value" |
