remove projection attributes from stop areas and access points in database

2 files changed, 28 insertions, 0 deletions

diff --git a/db/migrate/20130628130527_remove_projection_from_stop_areas.ninoxe_engine.rb b/db/migrate/20130628130527_remove_projection_from_stop_areas.ninoxe_engine.rb
new file mode 100644
index 000000000..3eb30a601
--- /dev/null
+++ b/db/migrate/20130628130527_remove_projection_from_stop_areas.ninoxe_engine.rb
@@ -0,0 +1,14 @@
+# This migration comes from ninoxe_engine (originally 20130628124932)
+class RemoveProjectionFromStopAreas < ActiveRecord::Migration
+  def up
+    remove_column :stop_areas, :x
+    remove_column :stop_areas, :y
+    remove_column :stop_areas, :projection_type
+  end
+
+  def down
+    add_column :stop_areas, :x, :decimal,:precision => 19, :scale => 2
+    add_column :stop_areas, :y, :decimal,:precision => 19, :scale => 2
+    add_column :stop_areas, :projection_type, :string
+  end
+end
diff --git a/db/migrate/20130628130528_remove_projection_from_access_points.ninoxe_engine.rb b/db/migrate/20130628130528_remove_projection_from_access_points.ninoxe_engine.rb
new file mode 100644
index 000000000..f0640a623
--- /dev/null
+++ b/db/migrate/20130628130528_remove_projection_from_access_points.ninoxe_engine.rb
@@ -0,0 +1,14 @@
+# This migration comes from ninoxe_engine (originally 20130628124951)
+class RemoveProjectionFromAccessPoints < ActiveRecord::Migration
+  def up
+    remove_column :access_points, :x
+    remove_column :access_points, :y
+    remove_column :access_points, :projection_type
+  end
+
+  def down
+    add_column :access_points, :x, :decimal,:precision => 19, :scale => 2
+    add_column :access_points, :y, :decimal,:precision => 19, :scale => 2
+    add_column :access_points, :projection_type, :string
+  end
+end