When adding a new field in HeidiSQL table editor the new field takes the default value from the previous field. So if I add a field and the previous was datatype INT the new one will be INT and have the default '0'. The problem is that if I then change to datatype TEXT the default does not get altered and MySQL throws an error when I try to save:
Would it be possible to either clear the default (in this case) or set a default that can be used in the new field (which in this example will just be the default as empty).
NOTE: One thing I did notice is that if I change from Text type to a Integer type I do get the default change to 0, so I guess the code is already setup for setting defaults but not for removing them I guess.