{{{ ALTER TABLE at_san_person DROP COLUMN animal_type; ALTER TABLE at_san_person ADD COLUMN new_col varchar; UPDATE at_san_person SET new_col = CAST(sanitel_id AS varchar); ALTER TABLE at_san_person DROP COLUMN sanitel_id; ALTER TABLE at_san_person RENAME new_col TO sanitel_id; ALTER TABLE at_account drop column lab_alken; ALTER TABLE at_account drop column lab_drongen; ALTER TABLE at_account drop column lab_torhout; ALTER TABLE at_account drop column lab_lier; ALTER TABLE at_account drop column lab_ciney; ALTER TABLE at_account rename lab_marloie to lab_dgz; ALTER TABLE at_account rename lab_loncin to lab_arsia; ALTER TABLE at_account rename lab_mons to lab_var; }}}