From 86cd6fb168b94debc3fc0eb99ac61f1a9b9b0049 Mon Sep 17 00:00:00 2001
From: Vlatka Pavisic
Date: Mon, 13 Feb 2017 17:39:30 +0100
Subject: Refs #2596 : Replace creation_time with timestamps

---
 db/schema.rb | 49 +++++++++++++++++++++++++++++++------------------
 1 file changed, 31 insertions(+), 18 deletions(-)

(limited to 'db/schema.rb')

diff --git a/db/schema.rb b/db/schema.rb
index 217983cdd..2a1c0334c 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: 20170203144307) do
+ActiveRecord::Schema.define(version: 20170213163747) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -23,7 +23,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.integer  "stop_area_id",                           limit: 8
     t.string   "objectid",                                                                  null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.string   "name"
     t.string   "comment"
@@ -38,6 +37,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.string   "link_type"
     t.integer  "int_user_needs"
     t.string   "link_orientation"
+    t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   add_index "access_links", ["objectid"], :name => "access_links_objectid_key", :unique => true
@@ -45,7 +46,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
   create_table "access_points", force: true do |t|
     t.string   "objectid"
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.string   "name"
     t.string   "comment"
@@ -65,6 +65,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.string   "zip_code"
     t.string   "city_name"
     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
@@ -117,7 +119,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
   create_table "companies", 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.string   "short_name"
@@ -132,6 +133,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.string   "time_zone"
     t.integer  "line_referential_id"
     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"
@@ -143,7 +146,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.integer  "arrival_id",                             limit: 8
     t.string   "objectid",                                                                  null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.string   "name"
     t.string   "comment"
@@ -157,6 +159,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     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
@@ -221,13 +225,14 @@ ActiveRecord::Schema.define(version: 20170203144307) do
   create_table "group_of_lines", 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.string   "comment"
     t.string   "registration_number"
     t.integer  "line_referential_id"
     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"
@@ -268,7 +273,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.integer  "route_id",                limit: 8
     t.string   "objectid",                                      null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.string   "name"
     t.string   "comment"
@@ -277,6 +281,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     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
@@ -328,7 +334,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     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   "name"
     t.string   "number"
@@ -348,6 +353,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.text     "import_xml"
     t.string   "transport_submode"
     t.integer  "secondary_company_ids",                                                  array: true
+    t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   add_index "lines", ["line_referential_id"], :name => "index_lines_on_line_referential_id"
@@ -358,7 +365,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
   create_table "networks", force: true do |t|
     t.string   "objectid",            null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.date     "version_date"
     t.string   "description"
@@ -370,6 +376,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.string   "comment"
     t.text     "import_xml"
     t.integer  "line_referential_id"
+    t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   add_index "networks", ["line_referential_id"], :name => "index_networks_on_line_referential_id"
@@ -394,11 +402,12 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.integer  "route_id",         limit: 8
     t.string   "objectid",                                            null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.string   "name"
     t.string   "comment"
     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
@@ -458,19 +467,19 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.integer  "arrival_id",         limit: 8
     t.string   "objectid",                                                       null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.float    "distance"
     t.boolean  "no_processing"
     t.spatial  "input_geometry",     limit: {:srid=>4326, :type=>"line_string"}
     t.spatial  "processed_geometry", limit: {:srid=>4326, :type=>"line_string"}
+    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",                    null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.string   "name"
     t.string   "comment"
@@ -479,6 +488,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.string   "number"
     t.string   "direction"
     t.string   "wayback"
+    t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   add_index "routes", ["objectid"], :name => "routes_objectid_key", :unique => true
@@ -491,7 +502,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.datetime "updated_at"
     t.string   "objectid",       null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
   end
 
@@ -548,7 +558,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.integer  "parent_id",                       limit: 8
     t.string   "objectid",                                                            null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.string   "name"
     t.string   "comment"
@@ -573,6 +582,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.string   "status"
     t.text     "import_xml"
     t.datetime "deleted_at"
+    t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   add_index "stop_areas", ["name"], :name => "index_stop_areas_on_name"
@@ -590,11 +601,12 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.integer  "stop_area_id",   limit: 8
     t.string   "objectid",                 null: false
     t.integer  "object_version"
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.integer  "position"
     t.string   "for_boarding"
     t.string   "for_alighting"
+    t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   add_index "stop_points", ["objectid"], :name => "stop_points_objectid_key", :unique => true
@@ -640,7 +652,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
   create_table "time_tables", force: true do |t|
     t.string   "objectid",                   null: false
     t.integer  "object_version", default: 1
-    t.datetime "creation_time"
     t.string   "creator_id"
     t.string   "version"
     t.string   "comment"
@@ -648,6 +659,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     t.date     "start_date"
     t.date     "end_date"
     t.integer  "calendar_id"
+    t.datetime "created_at"
+    t.datetime "updated_at"
   end
 
   add_index "time_tables", ["calendar_id"], :name => "index_time_tables_on_calendar_id"
@@ -664,7 +677,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
   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
@@ -733,7 +745,6 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     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"
@@ -746,6 +757,8 @@ ActiveRecord::Schema.define(version: 20170203144307) do
     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
-- 
cgit v1.2.3


From 893cc9d5683ae04e202cbe0560261b2a7c2f90fb Mon Sep 17 00:00:00 2001
From: Xinhui
Date: Mon, 20 Feb 2017 11:51:58 +0100
Subject: Vehicle Journey update state for arrival & departure time

---
 db/schema.rb | 69 ++++++++++++++++++++++++++++++++++--------------------------
 1 file changed, 39 insertions(+), 30 deletions(-)

(limited to 'db/schema.rb')

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"
-- 
cgit v1.2.3