-- ********************************************************************************
-- Base de Datos: El Mundo
-- Autor: A/S Leonardo Carámbula
-- Tema: Consultas SQL
-- Para: CETP - UTU
-- ********************************************************************************

-- Crear la base de datos
CREATE DATABASE IF NOT EXISTS el_mundo;

-- Seleccionar la base de datos creada
USE el_mundo;

-- Crear las tablas

-- Crear la tabla Región
CREATE TABLE IF NOT EXISTS region 
  (
    idreg smallint not null ,
    nombre varchar(10) not null ,
    tipo enum ('continente' ,'oceano' ),
    unique (nombre) ,
    PRIMARY KEY (idreg) 
  );

-- Crear la tabla territorio
CREATE TABLE IF NOT EXISTS territorio 
  (
    idter smallint not null ,
    nombre varchar(43),
    oficial varchar(53),
    capital varchar(24),
    poblacion integer not null ,
    superficie decimal(12,3) not null ,
    tipo enum('arrecife' ,'atolon' ,'autonomo' ,'comunidad' ,'dependiente' ,'estado_asociado' ,'glaciar' ,'independiente' ,'no_incorporado' ,'ONU' ,'region_administrativa' ,'region_autonoma' ,'territorio_externo' ,'ultramar' ),
    idreg smallint,
    PRIMARY KEY (idter) 
  );


-- Crear la tabla dependencia
CREATE TABLE IF NOT EXISTS dependencia 
  (
    tiene smallint not null ,
    de smallint not null ,
    PRIMARY KEY (tiene) 
  );


-- Crear la tabla independencia
CREATE TABLE IF NOT EXISTS independencia 
  (
    tiene smallint not null ,
    de smallint not null ,
    PRIMARY KEY (tiene) 
  );



-- Crear las claves foráneas para representar las relaciones
-- entre las tablas

ALTER TABLE dependencia ADD constraint FOREIGN KEY(tiene)
    references territorio(idter);

ALTER TABLE dependencia ADD constraint FOREIGN KEY(de)
    references territorio(idter) ;

ALTER TABLE independencia ADD constraint FOREIGN KEY(tiene)
    references territorio(idter) ;

ALTER TABLE independencia ADD constraint FOREIGN KEY(de)
    references territorio(idter);

ALTER TABLE territorio ADD constraint FOREIGN KEY(idreg)
    references region (idreg);


-- Ingresar Datos en las tablas

-- Tabla Región 
INSERT INTO region VALUES (1,'Africa','continente');
INSERT INTO region VALUES (2,'America','continente');
INSERT INTO region VALUES (3,'Asia','continente');
INSERT INTO region VALUES (4,'Antartida','continente');
INSERT INTO region VALUES (5,'Europa','continente');
INSERT INTO region VALUES (6,'Oceania','continente');
INSERT INTO region VALUES (7,'Atlantico','oceano');
INSERT INTO region VALUES (8,'Pacifico','oceano');

-- Tabla territorio
INSERT INTO territorio VALUES (1,'Acrotiri y Dhekelia','Bases Soberanas de Acrotiri y Dhekelia','Episkopi',13500,254.0,'ultramar',5);
INSERT INTO territorio VALUES (2,'Anguila','Anguila','El Valle',14000,91.0,'ultramar',2);
INSERT INTO territorio VALUES (3,'Bermudas','Bermudas','Hamilton',65000,54.0,'ultramar',2);
INSERT INTO territorio VALUES (4,'Caiman, Islas','Islas Caiman','George Town',54878,260.0,'ultramar',2);
INSERT INTO territorio VALUES (5,'Georgias del Sur y Sandwich del Sur, Islas ','Islas Georgias del Sur y Sandwich del Sur','King Edward Point',2,3093.0,'ultramar',2);
INSERT INTO territorio VALUES (6,'Gibraltar','Gibraltar','Gibraltar',30000,7.0,'ultramar',5);
INSERT INTO territorio VALUES (7,'Guadalupe','Guadalupe','Basse-Terre',407000,1704.0,'ultramar',2);
INSERT INTO territorio VALUES (8,'Guayana Francesa','Guayana Francesa','Cayena',262000,83846.0,'ultramar',2);
INSERT INTO territorio VALUES (9,'Jan Mayen','Jan Mayen','Olonkinbyen',18,377.0,'ultramar',5);
INSERT INTO territorio VALUES (10,'Jarvis, Isla','Isla Jarvis',NULL,0,4.5,'ultramar',8);
INSERT INTO territorio VALUES (11,'Johnston, Atolon','Atolon Johnston',NULL,1100,2.67,'ultramar',8);
INSERT INTO territorio VALUES (12,'Malvinas, Islas','Islas Malvinas/Falkland Islands','Puerto Argentino/Stanley',3000,12173.0,'ultramar',2);
INSERT INTO territorio VALUES (13,'Martinica','La Isla de Martinica','Fort de France',389000,1100.0,'ultramar',2);
INSERT INTO territorio VALUES (14,'Mayotte','Mayotte','Mamoudzou',223000,374.0,'ultramar',1);
INSERT INTO territorio VALUES (15,'Montserrat','Montserrat','Brades',5000,102.0,'ultramar',2);
INSERT INTO territorio VALUES (16,'Palmyra, Atolon','Atolon Palmyra','Palmyra',20,3.9,'ultramar',3);
INSERT INTO territorio VALUES (17,'Pitcairn, Islas','Islas Pitcairn, Henderson, Ducie y Oeno','Adamstown',60,47.0,'ultramar',6);
INSERT INTO territorio VALUES (18,'Polinesia Francesa','Polinesia Francesa','Papeete',272000,4167.0,'ultramar',6);
INSERT INTO territorio VALUES (19,'Reunion','La Isla de la Reunion','Saint Denis',850000,2512.0,'ultramar',1);
INSERT INTO territorio VALUES (20,'San Bartolome','Colectividad de San Bartolome','Gustavia',10000,21.0,'ultramar',2);
INSERT INTO territorio VALUES (21,'San Martin','Colectividad de San Martin','Marigot',39000,54.0,'ultramar',2);
INSERT INTO territorio VALUES (22,'San Pedro y Miquelon','San Pedro y Miquelon','San Pedro',6000,242.0,'ultramar',2);
INSERT INTO territorio VALUES (23,'Santa Elena, Ascension y Tristan de Acuña','Santa Elena, Ascension y Tristan de Acuña','Jamestown',4000,308.0,'ultramar',7);
INSERT INTO territorio VALUES (24,'Territorio Britanico del Oceano Índico','Territorio Britanico del Oceano Índico','Diego Garcia',3500,60.0,'ultramar',1);
INSERT INTO territorio VALUES (25,'Tierras Australes y Antarticas Francesas','Tierras Australes y Antarticas Francesas','Saint-Pierre',140,7829.0,'ultramar',4);
INSERT INTO territorio VALUES (26,'Turcas y Caicos, Islas','Islas Turcas y Caicos','Cockburn Town',44819,417.0,'ultramar',2);
INSERT INTO territorio VALUES (27,'Virgenes Britanicas, Islas','Islas Virgenes Britanicas','Road Town',33000,151.0,'ultramar',2);
INSERT INTO territorio VALUES (28,'Wake, Isla ','Isla Wake','Airport',45,7.37,'ultramar',8);
INSERT INTO territorio VALUES (29,'Wallis y Futuna','Territorio de las Islas Wallis y Futuna','Mata-Utu',12000,142.0,'ultramar',6);
INSERT INTO territorio VALUES (30,'Caribe Neerlandes','Caribe Neerlandes',NULL,18000,328.0,'territorio_externo',2);
INSERT INTO territorio VALUES (31,'Cocos, Islas','Territorio de las Islas Cocos','West Island',628,14.0,'territorio_externo',3);
INSERT INTO territorio VALUES (32,'Cook, Islas','Islas Cook','Avarua',15000,236.0,'territorio_externo',6);
INSERT INTO territorio VALUES (33,'Heard y McDonald, Islas','Islas Heard y McDonald',NULL,0,372.0,'territorio_externo',4);
INSERT INTO territorio VALUES (34,'Mar del Coral, Islas del','Islas del Mar del Coral',NULL,0,3.0,'territorio_externo',6);
INSERT INTO territorio VALUES (35,'Navidad, Isla de','Territorio de la Isla de Navidad','Flying Fish Cove',2000,135.0,'territorio_externo',3);
INSERT INTO territorio VALUES (36,'Norfolk, Isla','Territorio de las Islas Norfolk','Kingston',3000,36.0,'territorio_externo',6);
INSERT INTO territorio VALUES (37,'Åland','Islas de Åland','Mariehamn',28563,29000.0,'region_autonoma',5);
INSERT INTO territorio VALUES (38,'Aruba','Aruba','Oranjestad',106000,180.0,'region_autonoma',2);
INSERT INTO territorio VALUES (39,'Curazao','Pais de Curazao','Willemstad',158000,444.0,'region_autonoma',2);
INSERT INTO territorio VALUES (40,'Feroe, Islas','Islas Feroe','Torshavn',48000,1393.0,'region_autonoma',5);
INSERT INTO territorio VALUES (41,'Groenlandia','Groenlandia','Nuuk',56000,2166086.0,'region_autonoma',2);
INSERT INTO territorio VALUES (42,'Hong Kong','Region Administrativa Especial de Hong Kong','Hong Kong',7196000,1104.0,'region_administrativa',3);
INSERT INTO territorio VALUES (43,'Macao','Region Administrativa Especial de Macao','Macao',620000,28.0,'region_administrativa',3);
INSERT INTO territorio VALUES (44,'Svalbard','Svalbard','Longyearbyen',3000,62045.0,'region_administrativa',5);
INSERT INTO territorio VALUES (45,'Afganistan','Republica Islamica de Afganistan','Kabul',26285000,652230.0,'ONU',3);
INSERT INTO territorio VALUES (46,'Albania','Republica de Albania','Tirana',2761000,28748.0,'ONU',5);
INSERT INTO territorio VALUES (47,'Alemania','Republica Federal de Alemania','Berlin',80892000,357168.0,'ONU',5);
INSERT INTO territorio VALUES (48,'Andorra','Principado de Andorra','Andorra la Vieja',75000,468.0,'ONU',5);
INSERT INTO territorio VALUES (49,'Angola','Republica de Angola','Luanda',19743000,1246700.0,'ONU',1);
INSERT INTO territorio VALUES (50,'Antigua y Barbuda','Antigua y Barbuda','Saint John\'s',88000,443.0,'ONU',2);
INSERT INTO territorio VALUES (51,'Arabia Saudita','Reino de Arabia Saudita','Riad',30954000,2149690.0,'ONU',3);
INSERT INTO territorio VALUES (52,'Argelia','Republica Argelina Democratica y Popular','Argel',3909000,2381741.0,'ONU',1);
INSERT INTO territorio VALUES (53,'Argentina','Republica Argentina','Buenos Aires',42670000,2780400.0,'ONU',2);
INSERT INTO territorio VALUES (54,'Armenia','Republica de Armenia','Erevan',3017000,29743.0,'ONU',3);
INSERT INTO territorio VALUES (55,'Australia','Mancomunidad de Australia','Canberra',23545000,7692024.0,'ONU',6);
INSERT INTO territorio VALUES (56,'Austria','Republica de Austria','Viena',8531000,83871.0,'ONU',5);
INSERT INTO territorio VALUES (57,'Azerbaiyan','Republica de Azerbaiyan','Baku',9537000,86600.0,'ONU',3);
INSERT INTO territorio VALUES (58,'Bahamas','Mancomunidad de las Bahamas','Nasau',374000,13880.0,'ONU',2);
INSERT INTO territorio VALUES (59,'Banglades','Republica Popular de Banglades','Daca',156623000,143998.0,'ONU',3);
INSERT INTO territorio VALUES (60,'Barbados','Barbados','Bridgetown',282000,430.0,'ONU',2);
INSERT INTO territorio VALUES (61,'Barein','Reino de Barein','Manama',1659000,741.0,'ONU',3);
INSERT INTO territorio VALUES (62,'Belgica','Reino de Belgica','Bruselas',11315000,30528.0,'ONU',5);
INSERT INTO territorio VALUES (63,'Belice','Belice','Belmopan',358000,22966.0,'ONU',2);
INSERT INTO territorio VALUES (64,'Benin','Republica de Benin','Porto-Novo',10385000,112622.0,'ONU',1);
INSERT INTO territorio VALUES (65,'Bielorrusia','Republica de Bielorrusia','Minsk',9467000,207600.0,'ONU',5);
INSERT INTO territorio VALUES (66,'Birmania','Republica de la Union de Myanmar','Naipyido',62673000,676578.0,'ONU',3);
INSERT INTO territorio VALUES (67,'Bolivia','Estado Plurinacional de Bolivia','Sucre',10303000,1098581.0,'ONU',2);
INSERT INTO territorio VALUES (68,'Bosnia y Herzegovina','Bosnia y Herzegovina','Sarajevo',3774000,51197.0,'ONU',5);
INSERT INTO territorio VALUES (69,'Botsuana','Republica de Botsuana','Gaborone',2135000,581730.0,'ONU',1);
INSERT INTO territorio VALUES (70,'Brasil','Republica Federativa del Brasil','Brasilia',202790000,8514877.0,'ONU',2);
INSERT INTO territorio VALUES (71,'Brunei','Estado de Brunei, Morada de la Paz','Bandar Seri Begawan',414000,5765.0,'ONU',3);
INSERT INTO territorio VALUES (72,'Bulgaria','Republica de Bulgaria','Sofia',7218000,110879.0,'ONU',5);
INSERT INTO territorio VALUES (73,'Burkina Faso','Burkina Faso','Uagadugu',17891000,274200.0,'ONU',1);
INSERT INTO territorio VALUES (74,'Burundi','Republica de Burundi','Buyumbura',9728000,27830.0,'ONU',1);
INSERT INTO territorio VALUES (75,'Butan','Reino de Butan','Timbu',747000,38394.0,'ONU',3);
INSERT INTO territorio VALUES (76,'Cabo Verde','Republica de Cabo Verde','Praia',517000,4033.0,'ONU',1);
INSERT INTO territorio VALUES (77,'Camboya','Reino de Camboya','Phnom Penh',14804000,181035.0,'ONU',3);
INSERT INTO territorio VALUES (78,'Camerun','Republica de Camerun','Yaunde',21488000,475440.0,'ONU',1);
INSERT INTO territorio VALUES (79,'Canada','Canada','Ottawa',35518000,9984670.0,'ONU',2);
INSERT INTO territorio VALUES (80,'Catar','Estado de Catar','Doha',2045239,11586.0,'ONU',3);
INSERT INTO territorio VALUES (81,'Centroafricana, Republica','Republica Centroafricana','Bangui',2177000,622984.0,'ONU',1);
INSERT INTO territorio VALUES (82,'Chad','Republica de Chad','Yamena',13419000,1284000.0,'ONU',1);
INSERT INTO territorio VALUES (83,'Checa, Republica','Republica Checa','Praga',10519000,78866.0,'ONU',5);
INSERT INTO territorio VALUES (84,'Chile','Republica de Chile','Santiago de Chile',16645000,756102.0,'ONU',2);
INSERT INTO territorio VALUES (85,'China','Republica Popular China','Pekin',1364063000,9596961.0,'ONU',3);
INSERT INTO territorio VALUES (86,'Chipre','Republica de Chipre','Nicosia',872000,9251.0,'ONU',3);
INSERT INTO territorio VALUES (87,'Colombia','Republica de Colombia','Bogota',47681000,1141748.0,'ONU',2);
INSERT INTO territorio VALUES (88,'Comoras','Union de las Comoras','Moroni',763000,2235.0,'ONU',1);
INSERT INTO territorio VALUES (89,'Congo, Republica del','Republica del Congo','Brazzaville',4676000,342000.0,'ONU',1);
INSERT INTO territorio VALUES (90,'Congo, Republica Democratica del','Republica Democratica del Congo','Kinsasa',77028000,2344858.0,'ONU',1);
INSERT INTO territorio VALUES (91,'Corea del Norte','Republica Popular Democratica de Corea','Pionyang',25586000,120538.0,'ONU',3);
INSERT INTO territorio VALUES (92,'Corea del Sur','Republica de Corea','Seul',50787000,99720.0,'ONU',3);
INSERT INTO territorio VALUES (93,'Costa de Marfil','Republica de Costa de Marfil','Yamusukro',24658000,322463.0,'ONU',1);
INSERT INTO territorio VALUES (94,'Costa Rica','Republica de Costa Rica','San Jose',4740000,51100.0,'ONU',2);
INSERT INTO territorio VALUES (95,'Croacia','Republica de Croacia','Zagreb',4244000,56594.0,'ONU',5);
INSERT INTO territorio VALUES (96,'Cuba','Republica de Cuba','La Habana',11165000,110860.0,'ONU',2);
INSERT INTO territorio VALUES (97,'Dinamarca','Reino de Dinamarca','Copenhague',5641000,43094.0,'ONU',5);
INSERT INTO territorio VALUES (98,'Dominica','Mancomunidad de Dominica','Roseau',71000,751.0,'ONU',2);
INSERT INTO territorio VALUES (99,'Dominicana, Republica','Republica Dominicana','Santo Domingo',9863000,48670.0,'ONU',2);
INSERT INTO territorio VALUES (100,'Ecuador','Republica del Ecuador','Quito',16041000,283561.0,'ONU',2);
INSERT INTO territorio VALUES (101,'Egipto','Republica Arabe de Egipto','El Cairo',86542000,1001450.0,'ONU',1);
INSERT INTO territorio VALUES (102,'El Salvador','Republica de El Salvador','San Salvador',6458000,21041.0,'ONU',2);
INSERT INTO territorio VALUES (103,'Emiratos Arabes Unidos','Emiratos Arabes Unidos','Abu Dabi',8795000,83600.0,'ONU',3);
INSERT INTO territorio VALUES (104,'Eritrea','Estado de Eritrea','Asmara',5182000,117600.0,'ONU',1);
INSERT INTO territorio VALUES (105,'Eslovaquia','Republica Eslovaca','Bratislava',5420000,49035.0,'ONU',5);
INSERT INTO territorio VALUES (106,'Eslovenia','Republica de Eslovenia','Liubliana',2063000,20273.0,'ONU',5);
INSERT INTO territorio VALUES (107,'España','Reino de España','Madrid',46471000,505370.0,'ONU',5);
INSERT INTO territorio VALUES (108,'Estados Unidos','Estados Unidos de America','Washington D.C.',318191000,9371174.0,'ONU',2);
INSERT INTO territorio VALUES (109,'Estonia','Republica de Estonia','Tallin',1316000,9371174.0,'ONU',5);
INSERT INTO territorio VALUES (110,'Etiopia','Republica Democratica Federal de Etiopia','Adis Abeba',88928000,45228.0,'ONU',1);
INSERT INTO territorio VALUES (111,'Filipinas','Republica de Filipinas','Manila',98987000,300000.0,'ONU',3);
INSERT INTO territorio VALUES (112,'Finlandia','Republica de Finlandia','Helsinki',5463000,338145.0,'ONU',5);
INSERT INTO territorio VALUES (113,'Fiyi','Republica de Fiyi','Suva',867000,18274.0,'ONU',6);
INSERT INTO territorio VALUES (114,'Francia','Republica Francesa','Paris',64061000,643801.0,'ONU',5);
INSERT INTO territorio VALUES (115,'Gabon','Republica Gabonesa','Libreville',2291000,267667.0,'ONU',1);
INSERT INTO territorio VALUES (116,'Gambia','Republica del Gambia','Banjul',1958000,11295.0,'ONU',1);
INSERT INTO territorio VALUES (117,'Georgia','Georgia','Tiflis',4499000,69700.0,'ONU',3);
INSERT INTO territorio VALUES (118,'Ghana','Republica de Ghana','Accra',27117000,238533.0,'ONU',1);
INSERT INTO territorio VALUES (119,'Granada','Granada','Saint George\'s',104000,344.0,'ONU',2);
INSERT INTO territorio VALUES (120,'Grecia','Republica Helenica','Atenas',10779000,131957.0,'ONU',5);
INSERT INTO territorio VALUES (121,'Guatemala','Republica de Guatemala','Ciudad de Guatemala',15808000,108889.0,'ONU',2);
INSERT INTO territorio VALUES (122,'Guinea','Republica de Guinea','Conakry',12227000,245857.0,'ONU',1);
INSERT INTO territorio VALUES (123,'Guinea Ecuatorial','Republica de Guinea Ecuatorial','Malabo',1915000,28051.0,'ONU',1);
INSERT INTO territorio VALUES (124,'Guinea-Bisau','Republica de Guinea-Bisau','Bissau',1743000,36125.0,'ONU',1);
INSERT INTO territorio VALUES (125,'Guyana','Republica Cooperativa de Guyana','Georgetown',803000,214969.0,'ONU',2);
INSERT INTO territorio VALUES (126,'Haiti','Republica de Haiti','Puerto Principe',10936000,27750.0,'ONU',2);
INSERT INTO territorio VALUES (127,'Honduras','Republica de Honduras','Tegucigalpa',8750000,112492.0,'ONU',2);
INSERT INTO territorio VALUES (128,'Hungria','Hungria','Budapest',9866000,93028.0,'ONU',5);
INSERT INTO territorio VALUES (129,'India','Republica de la India','Nueva Delhi',1278501000,3287595.0,'ONU',3);
INSERT INTO territorio VALUES (130,'Indonesia','Republica de Indonesia','Yakarta',251913000,1904569.0,'ONU',3);
INSERT INTO territorio VALUES (131,'Irak','Republica de Irak','Bagdad',36104000,438317.0,'ONU',3);
INSERT INTO territorio VALUES (132,'Iran','Republica Islamica de Iran','Teheran',77777000,1648195.0,'ONU',3);
INSERT INTO territorio VALUES (133,'Irlanda','Republica de Irlanda','Dublin',4603000,70273.0,'ONU',5);
INSERT INTO territorio VALUES (134,'Islandia','Republica de Islandia','Reikiavik',327000,103000.0,'ONU',5);
INSERT INTO territorio VALUES (135,'Israel','Estado de Israel','Jerusalen',8208000,22072.0,'ONU',3);
INSERT INTO territorio VALUES (136,'Italia','Republica Italiana','Roma',60183000,301340.0,'ONU',5);
INSERT INTO territorio VALUES (137,'Jamaica','Jamaica','Kingston',2722000,10991.0,'ONU',2);
INSERT INTO territorio VALUES (138,'Japon','Japon','Tokio',127034000,377915.0,'ONU',3);
INSERT INTO territorio VALUES (139,'Jordania','Reino Hachemita de Jordania','Aman',6701000,89342.0,'ONU',3);
INSERT INTO territorio VALUES (140,'Kazajistan','Republica de Kazajistan','Astana',17283000,2724900.0,'ONU',3);
INSERT INTO territorio VALUES (141,'Kenia','Republica de Kenia','Nairobi',44595000,580367.0,'ONU',1);
INSERT INTO territorio VALUES (142,'Kirguistan','Republica Kirguisa','Biskek',5777000,199951.0,'ONU',3);
INSERT INTO territorio VALUES (143,'Kiribati','Republica de Kiribati','Tarawa',108000,811.0,'ONU',6);
INSERT INTO territorio VALUES (144,'Kuwait','Estado de Kuwait','Ciudad de Kuwait',3966000,17818.0,'ONU',3);
INSERT INTO territorio VALUES (145,'Laos','Republica Democratica Popular Lao','Vientian',6706000,236800.0,'ONU',3);
INSERT INTO territorio VALUES (146,'Lesoto','Reino de Lesoto','Maseru',1904000,30355.0,'ONU',1);
INSERT INTO territorio VALUES (147,'Letonia','Republica de Letonia','Riga',1996000,64589.0,'ONU',5);
INSERT INTO territorio VALUES (148,'Libano','Republica Libanesa','Beirut',4192000,10400.0,'ONU',3);
INSERT INTO territorio VALUES (149,'Liberia','Republica de Liberia','Monrovia',3963000,111369.0,'ONU',1);
INSERT INTO territorio VALUES (150,'Libia','Estado de Libia','Tripoli',6421000,1759540.0,'ONU',1);
INSERT INTO territorio VALUES (151,'Liechtenstein','Principado de Liechtenstein','Vaduz',37000,160.0,'ONU',5);
INSERT INTO territorio VALUES (152,'Lituania','Republica de Lituania','Vilna',2928000,65300.0,'ONU',5);
INSERT INTO territorio VALUES (153,'Luxemburgo','Gran Ducado de Luxemburgo','Luxemburgo',554000,2586.0,'ONU',5);
INSERT INTO territorio VALUES (154,'Macedonia','Republica de Macedonia','Skopie',2068000,25713.0,'ONU',5);
INSERT INTO territorio VALUES (155,'Madagascar','Republica de Madagascar','Antananarivo',22446000,587041.0,'ONU',1);
INSERT INTO territorio VALUES (156,'Malasia','Malasia','Kuala Lumpur',31229000,329847.0,'ONU',3);
INSERT INTO territorio VALUES (157,'Malaui','Republica de Malaui','Lilongüe',15802000,118484.0,'ONU',1);
INSERT INTO territorio VALUES (158,'Maldivas','Republica de las Maldivas','Male',335000,298.0,'ONU',3);
INSERT INTO territorio VALUES (159,'Mali','Republica de Mali','Bamako',17228000,1240192.0,'ONU',1);
INSERT INTO territorio VALUES (160,'Malta','Republica de Malta','La Valeta',423000,316.0,'ONU',5);
INSERT INTO territorio VALUES (161,'Marruecos','Reino de Marruecos','Rabat',33307000,446550.0,'ONU',1);
INSERT INTO territorio VALUES (162,'Marshall, Islas','Republica de las Islas Marshall','Majuro',57000,181.0,'ONU',6);
INSERT INTO territorio VALUES (163,'Mauricio','Republica de Mauricio','Port Louis',1280000,2040.0,'ONU',1);
INSERT INTO territorio VALUES (164,'Mauritania','Republica Islamica de Mauritania','Nuakchot',3550000,1030700.0,'ONU',1);
INSERT INTO territorio VALUES (165,'Mexico','Estados Unidos Mexicanos','Ciudad de Mexico',119713000,1964375.0,'ONU',2);
INSERT INTO territorio VALUES (166,'Moldavia','Republica de Moldavia','Chisinau',3494000,33851.0,'ONU',5);
INSERT INTO territorio VALUES (167,'Monaco','Principado de Monaco','Monaco',37000,2.0,'ONU',5);
INSERT INTO territorio VALUES (168,'Mongolia','Mongolia','Ulan Bator',2964000,1564116.0,'ONU',3);
INSERT INTO territorio VALUES (169,'Montenegro','Republica de Montenegro','Podgorica',620000,13812.0,'ONU',5);
INSERT INTO territorio VALUES (170,'Mozambique','Republica de Mozambique','Maputo',25307000,799380.0,'ONU',1);
INSERT INTO territorio VALUES (171,'Namibia','Republica de Namibia','Windhoek',2201000,824292.0,'ONU',1);
INSERT INTO territorio VALUES (172,'Nauru','Republica de Nauru','Yaren',10000,21.0,'ONU',6);
INSERT INTO territorio VALUES (173,'Nepal','Republica Federal Democratica de Nepal','Katmandu',27590000,147181.0,'ONU',3);
INSERT INTO territorio VALUES (174,'Nicaragua','Republica de Nicaragua','Managua',6363000,130370.0,'ONU',2);
INSERT INTO territorio VALUES (175,'Niger','Republica del Niger','Niamey',18179000,1267000.0,'ONU',1);
INSERT INTO territorio VALUES (176,'Nigeria','Republica Federal de Nigeria','Abuja',179626000,923768.0,'ONU',1);
INSERT INTO territorio VALUES (177,'Noruega','Reino de Noruega','Oslo',5139000,323802.0,'ONU',5);
INSERT INTO territorio VALUES (178,'Nueva Zelanda','Nueva Zelanda','Wellington',4509000,267710.0,'ONU',6);
INSERT INTO territorio VALUES (179,'Oman','Sultanato de Oman','Mascate',4054000,309500.0,'ONU',3);
INSERT INTO territorio VALUES (180,'Paises Bajos','Reino de los Paises Bajos','Amsterdam',16858000,41865.0,'ONU',5);
INSERT INTO territorio VALUES (181,'Pakistan','Republica Islamica de Pakistan','Islamabad',187900000,796095.0,'ONU',3);
INSERT INTO territorio VALUES (182,'Palaos','Republica de Palaos','Melekeok',21000,459.0,'ONU',6);
INSERT INTO territorio VALUES (183,'Panama','Republica de Panama','Panama',3671000,75420.0,'ONU',2);
INSERT INTO territorio VALUES (184,'Papua Nueva Guinea','Estado Independiente de Papua Nueva Guinea','Port Moresby',7672000,462840.0,'ONU',6);
INSERT INTO territorio VALUES (185,'Paraguay','Republica del Paraguay','Asuncion',6832000,406752.0,'ONU',2);
INSERT INTO territorio VALUES (186,'Peru','Republica del Peru','Lima',30819000,1285216.0,'ONU',2);
INSERT INTO territorio VALUES (187,'Polonia','Republica de Polonia','Varsovia',38507000,312685.0,'ONU',5);
INSERT INTO territorio VALUES (188,'Portugal','Republica Portuguesa','Lisboa',10511000,92090.0,'ONU',5);
INSERT INTO territorio VALUES (189,'Reino Unido','Reino Unido de Gran Bretaña e Irlanda del Norte','Londres',64551000,243610.0,'ONU',5);
INSERT INTO territorio VALUES (190,'Ruanda','Republica de Ruanda','Kigali',11036000,26338.0,'ONU',1);
INSERT INTO territorio VALUES (191,'Rumania','Rumania','Bucarest',19704000,238391.0,'ONU',5);
INSERT INTO territorio VALUES (192,'Rusia','Federacion Rusa','Moscu',143781000,17075400.0,'ONU',5);
INSERT INTO territorio VALUES (193,'Salomon, Islas','Islas Salomon','Honiara',574000,28896.0,'ONU',6);
INSERT INTO territorio VALUES (194,'Samoa','Estado Independiente de Samoa','Apia',192000,2831.0,'ONU',6);
INSERT INTO territorio VALUES (195,'San Cristobal y Nieves','Federacion de San Cristobal y Nieves','Basseterre',56000,261.0,'ONU',2);
INSERT INTO territorio VALUES (196,'San Marino','Serenisima Republica de San Marino','Ciudad de San Marino',33000,61.0,'ONU',5);
INSERT INTO territorio VALUES (197,'San Vicente y las Granadinas','San Vicente y las Granadinas','Kingstown',110000,389.0,'ONU',2);
INSERT INTO territorio VALUES (198,'Santa Lucia','Santa Lucia','Castries',171000,616.0,'ONU',2);
INSERT INTO territorio VALUES (199,'Santo Tome y Principe','Republica Democratica de Santo Tome y Principe','Santo Tome',189000,964.0,'ONU',1);
INSERT INTO territorio VALUES (200,'Senegal','Republica de Senegal','Dakar',13067000,196722.0,'ONU',1);
INSERT INTO territorio VALUES (201,'Serbia','Republica de Serbia','Belgrado',7139000,77474.0,'ONU',5);
INSERT INTO territorio VALUES (202,'Seychelles','Republica de las Seychelles','Victoria',96000,455.0,'ONU',1);
INSERT INTO territorio VALUES (203,'Sierra Leona','Republica de Sierra Leona','Freetown',6350000,71740.0,'ONU',1);
INSERT INTO territorio VALUES (204,'Singapur','Republica de Singapur','Singapur',5523000,697.0,'ONU',3);
INSERT INTO territorio VALUES (205,'Siria','Republica Arabe Siria','Damasco',22713000,185180.0,'ONU',3);
INSERT INTO territorio VALUES (206,'Somalia','Republica Federal de Somalia','Mogadiscio',9774000,637657.0,'ONU',1);
INSERT INTO territorio VALUES (207,'Sri Lanka','Republica Democratica Socialista de Sri Lanka','Colombo',20608000,65610.0,'ONU',3);
INSERT INTO territorio VALUES (208,'Suazilandia','Reino de Suazilandia','Lobamba',1087000,17364.0,'ONU',1);
INSERT INTO territorio VALUES (209,'Sudafrica','Republica de Sudafrica','Pretoria',53696000,1219090.0,'ONU',1);
INSERT INTO territorio VALUES (210,'Sudan','Republica del Sudan','Jartum',37289000,1886068.0,'ONU',1);
INSERT INTO territorio VALUES (211,'Sudan del Sur','Republica de Sudan del Sur','Yuba',10789000,619745.0,'ONU',1);
INSERT INTO territorio VALUES (212,'Suecia','Reino de Suecia','Estocolmo',9687000,450295.0,'ONU',5);
INSERT INTO territorio VALUES (213,'Suiza','Confederacion Helvetica','Berna',8171000,41277.0,'ONU',5);
INSERT INTO territorio VALUES (214,'Surinam','Republica del Surinam','Paramaribo',554000,163820.0,'ONU',2);
INSERT INTO territorio VALUES (215,'Tailandia','Reino de Tailandia','Bangkok',67948000,513120.0,'ONU',3);
INSERT INTO territorio VALUES (216,'Tanzania','Republica Unida de Tanzania','Dodoma',47186000,947300.0,'ONU',1);
INSERT INTO territorio VALUES (217,'Tayikistan','Republica de Tayikistan','Dusambe',8254000,143100.0,'ONU',3);
INSERT INTO territorio VALUES (218,'Timor Oriental','Republica Democratica de Timor Oriental','Dili',1212000,14874.0,'ONU',3);
INSERT INTO territorio VALUES (219,'Togo','Republica Togolesa','Lome',6868000,56785.0,'ONU',1);
INSERT INTO territorio VALUES (220,'Tonga','Reino de Tonga','Nukualofa',105000,747.0,'ONU',6);
INSERT INTO territorio VALUES (221,'Trinidad y Tobago','Republica de Trinidad y Tobago','Puerto España',1350000,5128.0,'ONU',2);
INSERT INTO territorio VALUES (222,'Tunez','Republica Tunecina','Tunez',11001000,163610.0,'ONU',1);
INSERT INTO territorio VALUES (223,'Turkmenistan','Turkmenistan','Asjabad',5562000,488100.0,'ONU',3);
INSERT INTO territorio VALUES (224,'Turquia','Republica de Turquia','Ankara',77192000,783562.0,'ONU',3);
INSERT INTO territorio VALUES (225,'Tuvalu','Tuvalu','Funafuti',12000,26.0,'ONU',6);
INSERT INTO territorio VALUES (226,'Ucrania','Ucrania','Kiev',45321000,603550.0,'ONU',5);
INSERT INTO territorio VALUES (227,'Uganda','Republica de Uganda','Kampala',36630000,241038.0,'ONU',1);
INSERT INTO territorio VALUES (228,'Uruguay','Republica Oriental del Uruguay','Montevideo',3304000,176215.0,'ONU',2);
INSERT INTO territorio VALUES (229,'Uzbekistan','Republica de Uzbekistan','Taskent',30570000,447400.0,'ONU',3);
INSERT INTO territorio VALUES (230,'Vanuatu','Republica de Vanuatu','Port Vila',272000,12189.0,'ONU',6);
INSERT INTO territorio VALUES (231,'Venezuela','Republica Bolivariana de Venezuela','Caracas',30258000,916445.0,'ONU',2);
INSERT INTO territorio VALUES (232,'Vietnam','Republica Socialista de Vietnam','Hanoi',90643000,331210.0,'ONU',3);
INSERT INTO territorio VALUES (233,'Yemen','Republica del Yemen','Sana',25999000,527968.0,'ONU',3);
INSERT INTO territorio VALUES (234,'Yibuti','Republica de Yibuti','Yibuti',936000,23200.0,'ONU',1);
INSERT INTO territorio VALUES (235,'Zambia','Republica de Zambia','Lusaka',15023000,752618.0,'ONU',1);
INSERT INTO territorio VALUES (236,'Zimbabue','Republica de Zimbabue','Harare',13347000,390757.0,'ONU',1);
INSERT INTO territorio VALUES (237,'Palestina','Estado de Palestina','Jerusalen Este',4549000,6220.0,'ONU',3);
INSERT INTO territorio VALUES (238,'Vaticano, Ciudad del','Estado de la Ciudad del Vaticano','Ciudad del Vaticano',800,0.44,'ONU',5);
INSERT INTO territorio VALUES (239,'Baker, isla','isla Baker','Meyerton City',0,1.64,'no_incorporado',8);
INSERT INTO territorio VALUES (240,'Guam','Guam','Agaña',161000,544.0,'no_incorporado',6);
INSERT INTO territorio VALUES (241,'Howland, Isla','Isla Howland',NULL,0,1.6,'no_incorporado',8);
INSERT INTO territorio VALUES (242,'Marianas del Norte, Islas','Estado Libre Asociado de las Islas Marianas del Norte','Saipan',48000,464.0,'no_incorporado',6);
INSERT INTO territorio VALUES (243,'Navaza, Isla de','Isla de Navaza',NULL,0,5.2,'no_incorporado',2);
INSERT INTO territorio VALUES (244,'Puerto Rico','Estado Libre Asociado de Puerto Rico','San Juan',3582000,9104.0,'no_incorporado',2);
INSERT INTO territorio VALUES (245,'Samoa Americana','Territorio de la Samoa Americana','Pago Pago',55000,199.0,'no_incorporado',6);
INSERT INTO territorio VALUES (246,'Virgenes de los Estados Unidos, Islas','Islas Virgenes de los Estados Unidos','Charlotte Amalie',105000,346.0,'no_incorporado',2);
INSERT INTO territorio VALUES (247,'Abjasia','Republica de Abjasia','Sujumi',242862,8600.0,'independiente',3);
INSERT INTO territorio VALUES (248,'Chipre del Norte','Republica Turca del Norte de Chipre','Nicosia',294906,3355.0,'independiente',3);
INSERT INTO territorio VALUES (249,'Kosovo','Republica de Kosovo','Pristina',1847000,10887.0,'independiente',5);
INSERT INTO territorio VALUES (250,'Nagorno Karabaj','Republica de Nagorno Karabaj','Stepanakert',138800,11458.0,'independiente',3);
INSERT INTO territorio VALUES (251,'Osetia del Sur','Republica de Osetia del Sur','Tsjinval',80000,3900.0,'independiente',3);
INSERT INTO territorio VALUES (252,'Somalilandia','Republica de Somalilandia','Hargeisa',3500000,137600.0,'independiente',1);
INSERT INTO territorio VALUES (253,'Taiwan','Republica de China','Taipei',23397000,35980.0,'independiente',3);
INSERT INTO territorio VALUES (254,'Transnistria','Republica Moldava Pridnestroviana','Tiraspol',518700,4163.0,'independiente',5);
INSERT INTO territorio VALUES (255,'Isla Bouvet','Isla Bouvet',NULL,0,49.0,'glaciar',7);
INSERT INTO territorio VALUES (256,'Niue','Niue','Alofi',2000,260.0,'estado_asociado',6);
INSERT INTO territorio VALUES (257,'Guernsey','Bailiazgo de Guernsey','Saint Peter Port',64000,78.0,'dependiente',5);
INSERT INTO territorio VALUES (258,'Jersey','Bailiazgo de Jersey','Saint Helier',102000,116.0,'dependiente',5);
INSERT INTO territorio VALUES (259,'Man, Isla de','Isla de Man','Douglas',88000,572.0,'dependiente',5);
INSERT INTO territorio VALUES (260,'Sahara Occidental','Republica Arabe Saharaui Democratica','El Aaiun',629000,266000.0,'dependiente',1);
INSERT INTO territorio VALUES (261,'Tokelau','Tokelau',NULL,1000,12.0,'dependiente',6);
INSERT INTO territorio VALUES (262,'Nueva Caledonia','Territorio de Nueva Caledonia y dependencias','Numea',262000,18575.0,'comunidad',6);
INSERT INTO territorio VALUES (263,'San Martin','Sint Maarten','Philipsburg',41000,34.0,'autonomo',2);
INSERT INTO territorio VALUES (264,'Clipperton, Isla','Isla Clipperton',NULL,0,6.0,'atolon',8);
INSERT INTO territorio VALUES (265,'Midway, Islas','Islas Midway',NULL,0,6.2,'atolon',8);
INSERT INTO territorio VALUES (266,'Kingman, Arrecife','Arrecife Kingman',NULL,0,1.0,'arrecife',3);

-- Tabla dependencia
INSERT INTO dependencia VALUES
(31,55),
(35,55),
(34,55),
(36,55),
(42,85),
(43,85),
(41,97),
(40,97),
(260,107),
(243,108),
(16,108),
(266,108),
(10,108),
(11,108),
(28,108),
(239,108),
(241,108),
(265,108),
(244,108),
(246,108),
(240,108),
(242,108),
(245,108),
(20,114),
(21,114),
(22,114),
(18,114),
(29,114),
(262,114),
(14,114),
(19,114),
(7,114),
(8,114),
(13,114),
(25,114),
(264,114),
(255,177),
(9,177),
(44,177),
(32,178),
(256,178),
(261,178),
(30,180),
(38,180),
(39,180),
(263,180),
(1,189),
(257,189),
(258,189),
(259,189),
(24,189),
(5,189),
(2,189),
(3,189),
(4,189),
(12,189),
(15,189),
(26,189),
(27,189),
(23,189),
(6,189),
(17,189),
(37,112);

-- Tabla independecia
INSERT INTO independencia VALUES
(250,57),
(248,86),
(247,117),
(251,117),
(254,166),
(249,201),
(252,206);