# How can I set default value for each column in a Database?

**URL:** <https://www.ruby-forum.com/t/how-can-i-set-default-value-for-each-column-in-a-database/153937>\
**Category:** Rails\
**Created:** [November 23, 2008, 12:11pm UTC](https://www.ruby-forum.com/t/how-can-i-set-default-value-for-each-column-in-a-database/153937 "2008-11-23T12:11:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![youhaodeyi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/b9bd4f/32.png) [@youhaodeyi](https://www.ruby-forum.com/u/youhaodeyi)\
**Post date:** [November 23, 2008, 12:11pm UTC](https://www.ruby-forum.com/t/how-can-i-set-default-value-for-each-column-in-a-database/153937/1 "2008-11-23T12:11:22Z")

</div>

I know I can set it on add\_column command but I am looking for a way to  
set the default when creating the Table. See below code, how can I set  
each of them a default value.

def self.up  
create\_table :bay\_infos, :primary\_key =\> :IP do |t|  
t.string :HostName  
t.string :IP  
t.string :Description  
t.string :user\_name  
t.string :password

```
  t.timestamps
end

```

end

---

<div class="post-metadata">

**Author:** ![youhaodeyi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/y/b9bd4f/32.png) [@youhaodeyi](https://www.ruby-forum.com/u/youhaodeyi)\
**Post date:** [November 23, 2008, 12:42pm UTC](https://www.ruby-forum.com/t/how-can-i-set-default-value-for-each-column-in-a-database/153937/2 "2008-11-23T12:42:52Z")

</div>

On Nov 23, 11:11 am, Zhao Yi [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> I know I can set it on add\_column command but I am looking for a way to  
> set the default when creating the Table. See below code, how can I set  
> each of them a default value.

[http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/TableDefinition.html#M001735](http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/TableDefinition.html#M001735)

Fred