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

-- DROP TABLE IF EXISTS mug_paises;
CREATE  TABLE mug_paises
(
	pais Smallint NOT NULL,
	nombre Varchar(60) NOT NULL,
	continente Char(2) NOT NULL,
	codigo_iso Char(2) NOT NULL
);

-- ALTER TABLE mug_paises DROP CONSTRAINT pk_mug_paises;
ALTER TABLE mug_paises ADD CONSTRAINT pk_mug_paises PRIMARY KEY (pais);

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