#creación del catalogo de zona
CREATE TABLE zone_address
(
	serial_zne int auto_increment not null,
	name_zne varchar(64) not null,
	status_zne ENUM('ACTIVE','INACTIVE') DEFAULT 'INACTIVE' not null,
	PRIMARY KEY (serial_zne)
)
ENGINE= InnoDB;

#cambio para la tabla student_address

ALTER TABLE student_address
ADD COLUMN serial_zne int null default null AFTER serial_par,
ADD CONSTRAINT FK_student_address_has_zone FOREIGN KEY (serial_zne) REFERENCES zone_address(serial_zne),
DROP COLUMN zone_sta;

#cambio para la tabla guardian_address
ALTER TABLE guardian_address
ADD COLUMN serial_zne int null default null AFTER serial_par,
ADD CONSTRAINT FK_gurdian_address_has_zone FOREIGN KEY (serial_zne) REFERENCES zone_address(serial_zne),
DROP COLUMN zone_gda;