ALTER TABLE `student` ADD `previous_school_std` TEXT NULL DEFAULT NULL , ADD `school_entrydate_std` DATE NULL DEFAULT NULL; -- SERIAL USR EN PAYMENT__DETAIL/NON ACADEMIC ALTER TABLE `payment_detail` ADD `serial_usr` INT( 11 ) NULL DEFAULT NULL ; ALTER TABLE `payment_detail_non_academic` ADD `serial_usr` INT( 11 ) NULL DEFAULT NULL ; -- BUS_YEAR_USER ALTER TABLE `bus_year_user` ADD `type_address_byu` ENUM( 'HOME', 'OTHER' ) NOT NULL AFTER serial_sft; ALTER TABLE `bus_year_user` ADD `address_byu` text NULL DEFAULT NULL AFTER type_address_byu; -- VISITS_MEDICAL_FILE ALTER TABLE `visits_medical_center` CHANGE `date_vmc` `date_vmc` TIMESTAMP NOT NULL ;