I treated myself to a rails training course last weekend (with Well House Consultants, rather good, I’ll write about it if I get around to it). Immediately I start to create my first ruby app and I forget all the sqltypes I can use in my Model and where to look them up. As I think I’ll be looking them up quite a lot, I’ve put them here on my blog for my later reference
:primary_key,
:string,
:text,
:integer,
:float,
:decimal,
:datetime,
:timestamp
:time,
:date,
:binary,
:boolean.
Options that I can use in my migration
I must remember to specify the decimal precision I need!
:precision [1..63], :scale [0..30]. Otherwise Mysql Default is (10,0).
* :limit – Requests a maximum column length. This is number of characters for :string and :text columns and number of bytes for :binary and :integer columns.
* :default – The column’s default value. Use nil for NULL.
* :null – Allows or disallows NULL values in the column. This option could have been named :null_allowed.
* :precision – Specifies the precision for a :decimal column.
* :scale – Specifies the scale for a :decimal column.
These came from: http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/TableDefinition.html