alter table prereg add column trans_type varchar(255) default NULL after email;
alter table prereg add column trans_name varchar(255) default NULL after trans_type;
alter table prereg add column trans_am_route varchar(64) default NULL after trans_name;
alter table prereg add column trans_pickup_time varchar(16) default NULL after trans_am_route;
alter table prereg add column trans_pm_route varchar(64) default NULL after trans_pickup_time;
alter table prereg add column trans_dropoff_time varchar(16) default NULL after trans_pm_route;
alter table prereg add column trans_bus_stop_location varchar(64) default NULL after trans_dropoff_time;
alter table prereg add column group_after_school_prog char(1) default NULL after trans_bus_stop_location;