One of the more useful features of rails is migrations, which remove the requirement to write database specific SQL statement and therefore make moving platforms easy...
anyway the docs are pretty sparse as to what can actually be put in a migration as options, and this post seems to fill in some of the missing blanks...
[update] also there's an article at IBM developerworks which does a reasonable job of introducing the topic.