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;