/**********************************************************************/
-- 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);

INSERT INTO mug_continentes (continente, nombre) VALUES ('AF', 'África');
INSERT INTO mug_continentes (continente, nombre) VALUES ('AM', 'América');
INSERT INTO mug_continentes (continente, nombre) VALUES ('AS', 'Asia');
INSERT INTO mug_continentes (continente, nombre) VALUES ('EU', 'Europa');
INSERT INTO mug_continentes (continente, nombre) VALUES ('OC','Oceanía');

/**********************************************************************/
-- 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);