alter table vocab_phonetic rename column phonetic_symbol to phonetic_symbol_old;
alter table vocab_phonetic add column phonetic_symbol varchar(5);
update vocab_phonetic set phonetic_symbol=phonetic_symbol_old;
alter table vocab_phonetic drop column phonetic_symbol_old;