One further idea that may be useful for fields that have defined values like spring,summer etc is the SET type http://dev.mysql.com/doc/refman/5.0/en/set.html

but they have to be set up when the table is created

poj