-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- SIU-GUARANI 3 - Sistema de Gestión Académica
-- Version 3.0.0
-- Tabla: mdp_personas
-- FK: fk_mdp_personas_mug_paises
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- DROP INDEX ifk_mdp_personas_mug_paises;
CREATE INDEX ifk_mdp_personas_mug_paises ON mdp_personas (pais_origen);

-- ALTER TABLE mdp_personas DROP CONSTRAINT fk_mdp_personas_mug_paises;
ALTER TABLE mdp_personas 
	ADD CONSTRAINT fk_mdp_personas_mug_paises FOREIGN KEY (pais_origen) 
	REFERENCES mug_paises (pais) on update restrict on delete restrict;