CREATE TABLE `admission` (
  `serial_admission` int(11) NOT NULL AUTO_INCREMENT,
  `number_sons` int(11) NOT NULL DEFAULT '1',
  `request` int(11) DEFAULT NULL,
  PRIMARY KEY (`serial_admission`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='tabla que guarda el numero de hijos y la solicitud, la solicutud es auto incremental';
ALTER TABLE `aspirant_student` 
DROP COLUMN `request`;
ALTER TABLE `aspirant_student` 
ADD COLUMN `serial_admission` INT NULL AFTER `serial_asfml`,
ADD INDEX `serial_admission_idx` (`serial_admission` ASC);
ALTER TABLE `aspirant_student` 
ADD CONSTRAINT `serial_admission`
FOREIGN KEY (`serial_admission`)
REFERENCES `admission` (`serial_admission`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;