aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20180319043333_remove_attributes_from_models.rb6
-rw-r--r--db/migrate/20180326085804_bind_exports_and_imports_types_to_workgroups.rb6
-rw-r--r--db/schema.rb6
-rw-r--r--db/seeds/stif.seeds.rb1
4 files changed, 15 insertions, 4 deletions
diff --git a/db/migrate/20180319043333_remove_attributes_from_models.rb b/db/migrate/20180319043333_remove_attributes_from_models.rb
new file mode 100644
index 000000000..e6de2987e
--- /dev/null
+++ b/db/migrate/20180319043333_remove_attributes_from_models.rb
@@ -0,0 +1,6 @@
+class RemoveAttributesFromModels < ActiveRecord::Migration
+ def change
+ remove_column "vehicle_journeys", "status_value"
+ remove_column "journey_patterns", "section_status"
+ end
+end
diff --git a/db/migrate/20180326085804_bind_exports_and_imports_types_to_workgroups.rb b/db/migrate/20180326085804_bind_exports_and_imports_types_to_workgroups.rb
new file mode 100644
index 000000000..d75336673
--- /dev/null
+++ b/db/migrate/20180326085804_bind_exports_and_imports_types_to_workgroups.rb
@@ -0,0 +1,6 @@
+class BindExportsAndImportsTypesToWorkgroups < ActiveRecord::Migration
+ def change
+ add_column :workgroups, "import_types", :string, default: [], array: true
+ add_column :workgroups, "export_types", :string, default: [], array: true
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index d7f9a9b25..58c8b0779 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: 20180313110900) do
+ActiveRecord::Schema.define(version: 20180319043333) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
@@ -446,7 +446,7 @@ ActiveRecord::Schema.define(version: 20180313110900) do
create_table "journey_patterns", id: :bigserial, force: :cascade do |t|
t.integer "route_id", limit: 8
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
t.string "comment"
@@ -454,7 +454,6 @@ ActiveRecord::Schema.define(version: 20180313110900) do
t.string "published_name"
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"
t.string "checksum"
@@ -976,7 +975,6 @@ ActiveRecord::Schema.define(version: 20180313110900) do
t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "comment"
- t.string "status_value"
t.string "transport_mode"
t.string "published_journey_name"
t.string "published_journey_identifier"
diff --git a/db/seeds/stif.seeds.rb b/db/seeds/stif.seeds.rb
index f898021ce..aa87b6f6c 100644
--- a/db/seeds/stif.seeds.rb
+++ b/db/seeds/stif.seeds.rb
@@ -8,6 +8,7 @@ line_referential = LineReferential.find_or_create_by!(name: "CodifLigne", object
workgroup = Workgroup.find_or_create_by!(name: "Gestion de l'offre théorique IDFm") do |w|
w.line_referential = line_referential
w.stop_area_referential = stop_area_referential
+ w.export_types = ["Export::Netex"]
end
Workbench.update_all workgroup_id: workgroup