aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20170213135212_add_timestamps_to_some_models.rb18
-rw-r--r--db/schema.rb49
2 files changed, 49 insertions, 18 deletions
diff --git a/db/migrate/20170213135212_add_timestamps_to_some_models.rb b/db/migrate/20170213135212_add_timestamps_to_some_models.rb
new file mode 100644
index 000000000..4c5797058
--- /dev/null
+++ b/db/migrate/20170213135212_add_timestamps_to_some_models.rb
@@ -0,0 +1,18 @@
+class AddTimestampsToSomeModels < ActiveRecord::Migration
+ def change
+ models = %i(vehicle_journeys timebands time_tables stop_points routing_constraint_zones routes route_sections pt_links networks lines
+ journey_patterns group_of_lines connection_links companies access_points access_links)
+
+ models.each do |table|
+ if !column_exists?(table, :created_at) && column_exists?(table, :creation_time)
+ add_timestamps table
+
+ Object.const_get("Chouette::#{table.to_s.classify}").all.each do |record|
+ record.update(created_at: record.creation_time) if record.respond_to? :creation_time
+ end
+ end
+
+ remove_column table, :creation_time if column_exists?(table, :creation_time)
+ end
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 1b40861e7..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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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: 20170207102136) 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-11-01 13:13:21 +0000