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;

ALTER TABLE vetoweb_info ADD COLUMN new_col varchar;
UPDATE vetoweb_info SET new_col = CAST(vwinfo_rq_sanitel_id AS varchar);
ALTER TABLE vetoweb_info DROP COLUMN vwinfo_rq_sanitel_id;
ALTER TABLE vetoweb_info RENAME new_col TO vwinfo_rq_sanitel_id;
update vetoweb_info set vwinfo_rq_sanitel_id = 'BE'||vwinfo_rq_sanitel_id||'-0101' where vwinfo_rq_sanitel_id != '';