alter table student drop column ldap_uid;
alter table student drop column ldap_uidnumber;
alter table student drop column ldap_gidnumber;
alter table student drop column alias;

alter table studentwd drop column ldap_uid;
alter table studentwd drop column ldap_uidnumber;
alter table studentwd drop column ldap_gidnumber;
alter table studentwd drop column alias;

alter table prereg drop column ldap_uid;
alter table prereg drop column ldap_uidnumber;
alter table prereg drop column ldap_gidnumber;
alter table prereg drop column alias;


alter table student add column alias_lastname varchar(40) after initial;
alter table student add column alias_firstname varchar(40) after alias_lastname;

alter table studentwd add column alias_lastname varchar(40) after initial;
alter table studentwd add column alias_firstname varchar(40) after alias_lastname;

alter table prereg add column alias_lastname varchar(40) after initial;
alter table prereg add column alias_firstname varchar(40) after alias_lastname;
