refine the transcoder.sql to modify database table column