/**********************************************************************/
-- CONTINENTES
/**********************************************************************/

CREATE TABLE mug_continentes (
    continente character(2) NOT NULL,
    nombre character varying(100) NOT NULL
);
ALTER TABLE mug_continentes OWNER TO postgres;

ALTER TABLE ONLY mug_continentes
    ADD CONSTRAINT mug_continentes_continente_key UNIQUE (continente);

ALTER TABLE ONLY mug_continentes
    ADD CONSTRAINT pk_mug_continentes PRIMARY KEY (continente);


/**********************************************************************/
-- PAISES
/**********************************************************************/

ALTER TABLE mug_paises ALTER descripcion TYPE character varying(100);
ALTER TABLE mug_paises ADD COLUMN continente character(2);
ALTER TABLE mug_paises ADD COLUMN codigo_iso character(2);

/**********************************************************************/
-- LOCALIDADES
/**********************************************************************/
ALTER TABLE mug_localidades ADD COLUMN ddn integer;
ALTER TABLE mug_localidades ALTER descripcion TYPE character varying(250);
ALTER TABLE mug_localidades ALTER desc_abreviada TYPE character varying(100);