alter table `student` drop column parish, drop column commun, drop column recon,
  drop column confirm, drop column maiden, drop column baptism;

alter table `studentwd` drop column parish, drop column commun, drop column recon,
  drop column confirm, drop column maiden, drop column baptism;

alter table `prereg` drop column parish, drop column commun, drop column recon,
  drop column confirm, drop column maiden, drop column baptism;


alter table student add column par1_house varchar(64) after cell1;
alter table student add column par2_house varchar(64) after cell2;

alter table studentwd add column par1_house varchar(64) after cell1;
alter table studentwd add column par2_house varchar(64) after cell2;

alter table prereg add column par1_house varchar(64) after cell1;
alter table prereg add column par2_house varchar(64) after cell2;
