On Fri, Feb 18, 2011 at 1:23 PM, Katsutoshi Itoh wrote:

Hi

I am developping web service *incrementally* by using devel-server. This is very good feel. but, a bit problem occurred, when the program install and setup new mathine. This service's Model.hs has 2 tables these are cross-reference like as below.

User    :    avatar  FileHeaderId Update    :

FileHeader    :    creator UserId    :

i settled like ...

1. migrate tables which has no column without id. 2. alter add columns.

i think yesod should separate the migration to 2 steps. 1 is to create tables these has no columns without id. 2 is to add colums and so on.

How about this?

I see the logic in it, and I'm not sure if there are any serious downsides to it. I'm assuming you're using PostgreSQL, correct? I don't know how well it would work for SQLite, since alter table statements are pretty weak there. On the other hand, I don't think it actually enforces foreign key constraints at all. Michael