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

-- DROP TABLE IF EXISTS mug_continentes;
CREATE  TABLE mug_continentes
(
	continente Char(2) NOT NULL,
	nombre Varchar(20) NOT NULL
);

Alter Table "mug_continentes" add UNIQUE ("continente");
-- ALTER TABLE mug_continentes DROP CONSTRAINT pk_mug_continentes;
ALTER TABLE mug_continentes ADD CONSTRAINT pk_mug_continentes PRIMARY KEY (continente);

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