EDIT:
The error is because you were missing the type of the column. Usage:
change_column(table_name, column_name, type, options = {})
So this should work for you:
change_column :users, :state, :string, :null => false, :default => 'active'
fig
2010-05-01 15:08:44