[iggi]

For those new to mysql use this syntax:

alter table <table name> alter column <coulmn name> set default <default value>

cheers!