aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorMichel Etienne2014-11-12 16:55:40 +0100
committerMichel Etienne2014-11-12 16:55:40 +0100
commit28350f95744a03290a28dd8d941d1e6248f2eeb2 (patch)
tree6ce8b6b89525b0428d29fc93d27949e60e2c2efb /db
parent0906ff71269c2bcec1a6445a6fb53900be66be9b (diff)
downloadchouette-core-28350f95744a03290a28dd8d941d1e6248f2eeb2.tar.bz2
new fields for GTFS exchange
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20141105123536_add_gtfs_fields_to_companies.ninoxe_engine.rb9
-rw-r--r--db/migrate/20141105123537_add_gtfs_fields_to_stop_areas.ninoxe_engine.rb9
-rw-r--r--db/migrate/20141105123538_add_gtfs_fields_to_lines.ninoxe_engine.rb10
-rw-r--r--db/schema.rb9
4 files changed, 36 insertions, 1 deletions
diff --git a/db/migrate/20141105123536_add_gtfs_fields_to_companies.ninoxe_engine.rb b/db/migrate/20141105123536_add_gtfs_fields_to_companies.ninoxe_engine.rb
new file mode 100644
index 000000000..67ad43660
--- /dev/null
+++ b/db/migrate/20141105123536_add_gtfs_fields_to_companies.ninoxe_engine.rb
@@ -0,0 +1,9 @@
+# This migration comes from ninoxe_engine (originally 20141017075349)
+class AddGtfsFieldsToCompanies < ActiveRecord::Migration
+ def change
+ change_table :companies do |t|
+ t.string :url
+ t.string :time_zone
+ end
+ end
+end
diff --git a/db/migrate/20141105123537_add_gtfs_fields_to_stop_areas.ninoxe_engine.rb b/db/migrate/20141105123537_add_gtfs_fields_to_stop_areas.ninoxe_engine.rb
new file mode 100644
index 000000000..e7ea5f4d6
--- /dev/null
+++ b/db/migrate/20141105123537_add_gtfs_fields_to_stop_areas.ninoxe_engine.rb
@@ -0,0 +1,9 @@
+# This migration comes from ninoxe_engine (originally 20141017075515)
+class AddGtfsFieldsToStopAreas < ActiveRecord::Migration
+ def change
+ change_table :stop_areas do |t|
+ t.string :url
+ t.string :time_zone
+ end
+ end
+end
diff --git a/db/migrate/20141105123538_add_gtfs_fields_to_lines.ninoxe_engine.rb b/db/migrate/20141105123538_add_gtfs_fields_to_lines.ninoxe_engine.rb
new file mode 100644
index 000000000..ca960df76
--- /dev/null
+++ b/db/migrate/20141105123538_add_gtfs_fields_to_lines.ninoxe_engine.rb
@@ -0,0 +1,10 @@
+# This migration comes from ninoxe_engine (originally 20141017075627)
+class AddGtfsFieldsToLines < ActiveRecord::Migration
+ def change
+ change_table :lines do |t|
+ t.string :url
+ t.string :color, :limit => 6
+ t.string :text_color, :limit => 6
+ end
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 6c45bd44a..89cbf7d87 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
#
# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 20140820074844) do
+ActiveRecord::Schema.define(:version => 20141105123538) do
create_table "access_links", :force => true do |t|
t.integer "access_point_id", :limit => 8
@@ -85,6 +85,8 @@ ActiveRecord::Schema.define(:version => 20140820074844) do
t.string "fax"
t.string "email"
t.string "registration_number"
+ t.string "url"
+ t.string "time_zone"
end
add_index "companies", ["objectid"], :name => "companies_objectid_key", :unique => true
@@ -282,6 +284,9 @@ ActiveRecord::Schema.define(:version => 20140820074844) do
t.boolean "mobility_restricted_suitability"
t.integer "int_user_needs"
t.boolean "flexible_service"
+ t.string "url"
+ t.string "color", :limit => 6
+ t.string "text_color", :limit => 6
end
add_index "lines", ["objectid"], :name => "lines_objectid_key", :unique => true
@@ -394,6 +399,8 @@ ActiveRecord::Schema.define(:version => 20140820074844) do
t.integer "int_user_needs"
t.string "zip_code"
t.string "city_name"
+ t.string "url"
+ t.string "time_zone"
end
add_index "stop_areas", ["objectid"], :name => "stop_areas_objectid_key", :unique => true