
-- PErmite guardar la extension del telefono de trabajo para el representante, en las tablas guardian, guardian_adrres, student_addres


ALTER TABLE `guardian` 
ADD COLUMN `ext_company_phone_grd` VARCHAR(10) NULL AFTER `company_phone_grd`;


ALTER TABLE `guardian_address` 
ADD COLUMN `ext_phone1_gda` VARCHAR(45) NULL AFTER `phone1_gda`,
ADD COLUMN `ext_phone2_gda` VARCHAR(45) NULL AFTER `phone2_gda`;

ALTER TABLE `student_address` 
ADD COLUMN `ext_phone1_sta` VARCHAR(45) NULL AFTER `phone1_sta`,
ADD COLUMN `ext_phone2_sta` VARCHAR(45) NULL AFTER `phone2_sta`;
