aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorAlban Peignier2016-05-13 11:56:54 +0200
committerAlban Peignier2016-05-13 11:56:54 +0200
commit6e28e49262ede9c57a6c5726570a4921f4b63d04 (patch)
tree31a26a03e2c1dd3af796c9854918d112ad6e97c8 /db
parent781142afdb90bb0ca62783435f582725794f4f57 (diff)
downloadchouette-core-6e28e49262ede9c57a6c5726570a4921f4b63d04.tar.bz2
Refactor models and controllers to manage Lines in LineReferential. Refs #825
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20160511082825_add_line_referential_to_lines.rb5
-rw-r--r--db/migrate/20160511082825_add_line_referential_to_stop_areas.rb5
-rw-r--r--db/migrate/20160512110510_add_line_referential_to_group_of_lines.rb5
-rw-r--r--db/schema.rb12
4 files changed, 17 insertions, 10 deletions
diff --git a/db/migrate/20160511082825_add_line_referential_to_lines.rb b/db/migrate/20160511082825_add_line_referential_to_lines.rb
new file mode 100644
index 000000000..e44ca4689
--- /dev/null
+++ b/db/migrate/20160511082825_add_line_referential_to_lines.rb
@@ -0,0 +1,5 @@
+class AddLineReferentialToLines < ActiveRecord::Migration
+ def change
+ add_reference :lines, :line_referential, index: true
+ end
+end
diff --git a/db/migrate/20160511082825_add_line_referential_to_stop_areas.rb b/db/migrate/20160511082825_add_line_referential_to_stop_areas.rb
deleted file mode 100644
index f71f5ee45..000000000
--- a/db/migrate/20160511082825_add_line_referential_to_stop_areas.rb
+++ /dev/null
@@ -1,5 +0,0 @@
-class AddLineReferentialToStopAreas < ActiveRecord::Migration
- def change
- add_reference :stop_areas, :line_referential, index: true
- end
-end
diff --git a/db/migrate/20160512110510_add_line_referential_to_group_of_lines.rb b/db/migrate/20160512110510_add_line_referential_to_group_of_lines.rb
new file mode 100644
index 000000000..f0081448b
--- /dev/null
+++ b/db/migrate/20160512110510_add_line_referential_to_group_of_lines.rb
@@ -0,0 +1,5 @@
+class AddLineReferentialToGroupOfLines < ActiveRecord::Migration
+ def change
+ add_reference :group_of_lines, :line_referential, index: true
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index dcd0e162f..f7245dd98 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: 20160511094753) do
+ActiveRecord::Schema.define(version: 20160512110510) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
@@ -200,8 +200,10 @@ ActiveRecord::Schema.define(version: 20160511094753) do
t.string "name"
t.string "comment"
t.string "registration_number"
+ t.integer "line_referential_id"
end
+ add_index "group_of_lines", ["line_referential_id"], :name => "index_group_of_lines_on_line_referential_id"
add_index "group_of_lines", ["objectid"], :name => "group_of_lines_objectid_key", :unique => true
create_table "group_of_lines_lines", id: false, force: true do |t|
@@ -291,8 +293,10 @@ ActiveRecord::Schema.define(version: 20160511094753) do
t.string "color", limit: 6
t.string "text_color", limit: 6
t.string "stable_id"
+ t.integer "line_referential_id"
end
+ add_index "lines", ["line_referential_id"], :name => "index_lines_on_line_referential_id"
add_index "lines", ["objectid"], :name => "lines_objectid_key", :unique => true
add_index "lines", ["registration_number"], :name => "lines_registration_number_key"
@@ -359,10 +363,10 @@ ActiveRecord::Schema.define(version: 20160511094753) do
t.integer "object_version"
t.datetime "creation_time"
t.string "creator_id"
- t.spatial "input_geometry", limit: {:srid=>4326, :type=>"line_string"}
- t.spatial "processed_geometry", limit: {:srid=>4326, :type=>"line_string"}
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"}
end
create_table "routes", force: true do |t|
@@ -433,10 +437,8 @@ ActiveRecord::Schema.define(version: 20160511094753) do
t.string "url"
t.string "time_zone"
t.integer "stop_area_referential_id"
- t.integer "line_referential_id"
end
- add_index "stop_areas", ["line_referential_id"], :name => "index_stop_areas_on_line_referential_id"
add_index "stop_areas", ["objectid"], :name => "stop_areas_objectid_key", :unique => true
add_index "stop_areas", ["parent_id"], :name => "index_stop_areas_on_parent_id"
add_index "stop_areas", ["stop_area_referential_id"], :name => "index_stop_areas_on_stop_area_referential_id"