From: JZ <usenet@...>
Date: 2005-07-18T06:35:54+09:00
Subject: Re: Just seen on c.l.py

On Sun, 17 Jul 2005 22:23:09 +0900, David Heinemeier Hansson wrote:

> Exactly. Migrations were originally intended to solve the problem of
> evolving a database schema across multiple databases with as little
> pain as possible and without loosing your data. Especially the last
> bit is where most Object->SQL auto-generation schemes fall down.
> 
> But it can certainly also be used to create your entire database from
> scratch, so that you won't have to touch SQL at all. Example:
> 
>       create_table :system_settings do |t|
>         t.column :name,     :string
>         t.column :label,    :string
>         t.column :value,    :text
>         t.column :type,     :string
>         t.column :position, :integer
>       end

David, how would you define collations or constrains here?

--

JZ