-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- SIU-GUARANI 3 - Sistema de Gestión Académica
-- Versión x.y.z
-- Tabla: mug_cod_postales
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- DROP TABLE IF EXISTS mug_cod_postales;
CREATE  TABLE mug_cod_postales
(
	localidad Integer NOT NULL,
	codigo_postal Varchar(15) NOT NULL
);

-- ALTER TABLE mug_cod_postales DROP CONSTRAINT pk_mug_cod_postales;
ALTER TABLE mug_cod_postales ADD CONSTRAINT pk_mug_cod_postales PRIMARY KEY (localidad,codigo_postal);

Revoke all ON mug_cod_postales FROM public;
-- ++++++++++++++++++++++++++ Fin tabla mug_cod_postales +++++++++++++++++++++++++++++