MySQL column positioning option for add/modify column

[krrrr38]

Dear Ecto developers.

I want to add column position options, `after` and `first`, into Ecto.Migration only for MySQL.

We can use like following which same as rails (https://github.com/rails/rails/commit/e55284e8256461fc2440c41548ee9b4216f96b47).

defmodule MyApp.Repo.Migrations.AddColumnsToPosts do

  use Ecto.Migration

  def change do

    alter table(:posts) do
      add :author_id, :integer, first: true # add column in front of all the columns

      add :body, :text, after: :title # add column after `title`

    end

  end

end

I just implemented sample code as follows.

https://github.com/krrrr38/ecto/commit/b647bbe2d3501703e7f134ce25e701eafc512622

If you need, I will create new pull request into elixir/ecto.

Thanks.

[José Valim]

I am a little bit torn as MySQL is the only database that supports it. Also, because it is not a common feature, you can issue an execute command whenever you want to run it.

Finally I believe we shouldn't support those on modify. According to this answer, we can only change one position per alter table: http://stackoverflow.com/questions/3809603/mysql-arrange-existing-table-columns

Thank you for the proposal though. Btw, your patch is *perfect* code wise, great job!

José Valim

www.plataformatec.com.br

Skype: jv.ptec

Founder and Director of R&D

--
You received this message because you are subscribed to the Google Groups "elixir-ecto" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elixir-ecto...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elixir-ecto/59d4b15a-aba9-4e1e-a49e-676a027163b4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.