aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorXinhui2017-02-20 11:51:58 +0100
committerXinhui2017-02-20 11:52:06 +0100
commit893cc9d5683ae04e202cbe0560261b2a7c2f90fb (patch)
tree5c6007073bb31d3879131ffb8edf6f99f12d6208 /db
parent86cd6fb168b94debc3fc0eb99ac61f1a9b9b0049 (diff)
downloadchouette-core-893cc9d5683ae04e202cbe0560261b2a7c2f90fb.tar.bz2
Vehicle Journey update state for arrival & departure time
Diffstat (limited to 'db')
-rw-r--r--db/schema.rb69
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"