-- [+] INSERT INTO [+]

-- INACIONALIDADES.

INSERT INTO nacionalidades (pais,codigo_pais) VALUES
("España","ES"),
("México","MX"),
("Colombia","CO"),
("Argentina","AR"),
("Perú","PE"),
("Bolivia","BO"),
("Cuba","CU"),
("Puerto Rico","PR"),
("Venezuela","VE"),
("Honduras","HO"),
("Costa Rica","CR"),
("Panama","PA"),
("Ecuador","EC"),
("República Dominicana","RD");

SELECT * FROM nacionalidades;

-- PERSONAS
INSERT INTO personas (nombre,apellido,edad,genero,email,fecha_nacimiento,altura,peso,ciudad) VALUES
("Francisco Javier","Parejo Arroyo",38,"Masculino","franparejo@gmail.com","1987-06-02",167.20,82.30,"Lucena");

INSERT INTO personas (nombre,apellido,edad,genero,email,fecha_nacimiento,altura,peso,ciudad) VALUES
("Alejandro","Martínez García",24,"Masculino","amg@gmail.com","2001-03-04",179.2,78.40,"Murcia");

INSERT INTO personas (nombre,apellido,edad,genero,email,fecha_nacimiento,altura,peso,ciudad) VALUES
("Alejandro","Martínez García",24,"Masculino","amg@gmail.com","2001-03-04",179.2,78.40,"Murcia");


INSERT INTO personas (nombre,apellido,edad,genero,email,fecha_nacimiento,altura,peso,ciudad) VALUES
("Sofía", "López Hernández", 32, "Femenino", "slh@hotmail.com", "1992-11-15", 165.5, 62.10, "Madrid"),
("Carlos", "González Rodríguez", 45, "Masculino", "cgr@yahoo.com", "1979-05-22", 182.3, 85.70, "Barcelona"),
("Valentina", "Pérez Sánchez", 28, "Femenino", "vps@gmail.com", "1996-08-30", 170.1, 68.90, "Ciudad de México"),
("Javier", "Ramírez Díaz", 39, "Masculino", "jrd@outlook.com", "1985-02-17", 175.8, 79.30, "Valencia"),
("Isabella", "Fernández Martín", 22, "Femenino", "ifm@gmail.com", "2002-07-12", 163.2, 59.80, "Sevilla"),
("Diego", "Torres Gómez", 51, "Masculino", "dtg@yahoo.com", "1973-12-03", 178.9, 82.50, "Buenos Aires"),
("Lucía", "Navarro Ruiz", 35, "Femenino", "lnr@hotmail.com", "1989-04-25", 167.4, 64.20, "Zaragoza"),
("Mateo", "Jiménez Serrano", 29, "Masculino", "mjs@gmail.com", "1995-10-08", 181.0, 80.10, "Málaga"),
("Camila", "Moreno Álvarez", 41, "Femenino", "cma@outlook.com", "1983-06-19", 169.3, 71.60, "Bogotá"),
("Adrián", "Romero Blanco", 26, "Masculino", "arb@gmail.com", "1998-01-14", 176.5, 77.40, "Las Palmas"),
("Emma", "Suárez Gil", 33, "Femenino", "esg@yahoo.com", "1991-09-27", 162.8, 61.70, "Lima"),
("Daniel", "Molina Ortega", 47, "Masculino", "dmo@hotmail.com", "1977-03-11", 180.2, 84.90, "Santiago"),
("Paula", "Delgado Castro", 30, "Femenino", "pdc@gmail.com", "1994-12-05", 168.7, 66.30, "Palma de Mallorca"),
("Hugo", "Vázquez Vidal", 36, "Masculino", "hvv@outlook.com", "1988-07-23", 177.4, 81.20, "Bilbao"),
("Martina", "Santos Marín", 25, "Femenino", "msm@gmail.com", "1999-04-16", 164.9, 63.50, "São Paulo"),
("Álvaro", "Reyes Núñez", 42, "Masculino", "arn@yahoo.com", "1982-10-29", 183.1, 86.70, "Alicante"),
("Valeria", "Herrera Medina", 31, "Femenino", "vhm@hotmail.com", "1993-05-07", 166.2, 65.80, "Montevideo"),
("Sergio", "Iglesias Calvo", 38, "Masculino", "sic@gmail.com", "1986-11-20", 179.6, 83.40, "Valladolid"),
("Elena", "Cruz Mora", 27, "Femenino", "ecm@outlook.com", "1997-08-13", 171.5, 69.10, "Caracas"),
("Pablo", "Garrido León", 44, "Masculino", "pgl@yahoo.com", "1980-02-26", 181.8, 87.20, "Córdoba"),
("Renata", "Flores Rivas", 23, "Femenino", "rfr@gmail.com", "2001-06-09", 163.7, 60.90, "Guadalajara"),
("Jorge", "Peña Ibáñez", 50, "Masculino", "jpi@hotmail.com", "1974-12-31", 178.3, 85.10, "Vigo"),
("Olivia", "Caballero Vega", 34, "Femenino", "ocv@outlook.com", "1990-07-24", 167.9, 67.40, "Medellín"),
("Raúl", "Nieto Fuentes", 37, "Masculino", "rnf@gmail.com", "1987-03-18", 176.1, 78.90, "Granada"),
("Ana", "Campos Silva", 21, "Femenino", "acs@yahoo.com", "2003-10-02", 165.0, 62.60, "Salvador"),
("David", "Vega Crespo", 46, "Masculino", "dvc@hotmail.com", "1978-05-15", 182.7, 88.30, "Santa Cruz de Tenerife"),
("Gabriela", "Prieto Cabrera", 32, "Femenino", "gpc@gmail.com", "1992-01-28", 169.8, 70.20, "Quito"),
("Iván", "Sanz Herrera", 40, "Masculino", "ish@outlook.com", "1984-08-11", 177.9, 82.10, "Pamplona"),
("Zoe", "Rojas Mendoza", 29, "Femenino", "zrm@yahoo.com", "1995-03-04", 162.3, 61.30, "La Paz"),
("Francisco", "Marcos Guerrero", 52, "Masculino", "fmg@hotmail.com", "1972-09-17", 179.4, 86.50, "San Sebastián"),
("Luna", "Giménez Pascual", 26, "Femenino", "lgp@gmail.com", "1998-04-30", 168.4, 66.90, "Maracaibo"),
("Rubén", "Hidalgo Soria", 43, "Masculino", "rhs@outlook.com", "1981-11-12", 180.5, 84.20, "Santander"),
("Claudia", "Benítez Montero", 35, "Femenino", "cbm@yahoo.com", "1989-06-25", 170.7, 71.80, "Toluca"),
("Antonio", "Vicente Arias", 48, "Masculino", "ava@hotmail.com", "1976-01-08", 181.2, 87.90, "A Coruña"),
("Aitana", "Méndez Lorenzo", 24, "Femenino", "aml@gmail.com", "2000-08-21", 164.1, 63.20, "Guayaquil"),
("Miguel", "Lara Gutiérrez", 39, "Masculino", "mlg@outlook.com", "1985-02-03", 178.0, 81.60, "Oviedo"),
("Carla", "Castillo Domínguez", 31, "Femenino", "ccd@yahoo.com", "1993-09-16", 166.9, 68.70, "Panamá"),
("José", "Rivero Cortés", 45, "Masculino", "jrc@hotmail.com", "1979-04-29", 182.0, 85.40, "Logroño"),
("Alba", "Soto Navarro", 27, "Femenino", "asn@gmail.com", "1997-12-12", 167.2, 65.10, "Managua"),
("Juan", "Bravo Méndez", 33, "Masculino", "jbm@outlook.com", "1991-07-25", 177.1, 79.80, "Albacete"),
("Nora", "Gallardo Palma", 22, "Femenino", "ngp@yahoo.com", "2002-03-08", 163.5, 60.40, "Tegucigalpa"),
("Fernando", "Pardo Soler", 49, "Masculino", "fps@hotmail.com", "1975-10-21", 179.7, 86.80, "Badajoz"),
("Daniela", "Rey Rubio", 36, "Femenino", "drr@gmail.com", "1988-05-04", 169.0, 70.90, "Asunción"),
("Roberto", "Cano Peinado", 41, "Masculino", "rcp@outlook.com", "1983-12-17", 180.9, 83.70, "Tarragona"),
("Victoria", "Aguilar Salas", 30, "Femenino", "vas@yahoo.com", "1994-07-30", 165.8, 67.30, "San José"),
("Manuel", "Santana Crespo", 53, "Masculino", "msc@hotmail.com", "1971-02-11", 181.5, 88.60, "Cáceres"),
("Julia", "Pascual Velasco", 28, "Femenino", "jpv@gmail.com", "1996-09-24", 168.6, 69.50, "San Salvador"),
("Óscar", "Ferrer Ríos", 38, "Masculino", "ofr@outlook.com", "1986-04-07", 178.5, 82.30, "Gijón"),
("Marina", "Sierra Campos", 25, "Femenino", "msc@yahoo.com", "1999-11-20", 164.4, 64.80, "Toulouse");

SELECT * FROM PERSONAS;

INSERT INTO caracteristicas_fisicas (persona_id,color_ojos, color_pelo, tipo_pelo, complexion, tiene_tatuajes,tiene_piercings) VALUES
(1,"Marrones","Castaño","Ondulado","Media",TRUE,TRUE);

INSERT INTO caracteristicas_fisicas (persona_id,color_ojos, color_pelo, tipo_pelo, complexion, tiene_tatuajes,tiene_piercings) VALUES
(2, "Verdes", "Rubio", "Liso", "Delgada", FALSE, TRUE),
(3, "Azules", "Negro", "Liso", "Robusta", TRUE, FALSE),
(4, "Marrones", "Castaño oscuro", "Rizado", "Media", FALSE, FALSE),
(5, "Avellana", "Pelirrojo", "Ondulado", "Robusta", TRUE, TRUE),
(6, "Verdes", "Rubio", "Muy rizado", "Delgada", FALSE, TRUE),
(7, "Marrones", "Negro", "Liso", "Media", TRUE, FALSE),
(8, "Azules", "Castaño", "Ondulado", "Delgada", FALSE, TRUE),
(9, "Verdes", "Negro", "Liso", "Robusta", TRUE, TRUE),
(10, "Marrones", "Castaño", "Rizado", "Media", FALSE, FALSE),
(11, "Azules", "Rubio", "Ondulado", "Delgada", TRUE, FALSE),
(12, "Marrones", "Negro", "Liso", "Robusta", FALSE, TRUE),
(13, "Verdes", "Pelirrojo", "Muy rizado", "Media", TRUE, TRUE),
(14, "Azules", "Castaño", "Liso", "Delgada", FALSE, FALSE),
(15, "Marrones", "Negro", "Ondulado", "Robusta", TRUE, TRUE),
(16, "Avellana", "Rubio", "Rizado", "Media", FALSE, TRUE),
(17, "Verdes", "Castaño", "Liso", "Delgada", TRUE, FALSE),
(18, "Marrones", "Negro", "Ondulado", "Robusta", FALSE, TRUE),
(19, "Azules", "Rubio", "Muy rizado", "Media", TRUE, TRUE),
(20, "Marrones", "Castaño oscuro", "Liso", "Delgada", FALSE, FALSE),
(21, "Verdes", "Negro", "Ondulado", "Robusta", TRUE, TRUE),
(22, "Azules", "Rubio", "Rizado", "Media", FALSE, TRUE),
(23, "Marrones", "Castaño", "Liso", "Delgada", TRUE, FALSE),
(24, "Avellana", "Pelirrojo", "Ondulado", "Robusta", FALSE, TRUE),
(25, "Verdes", "Negro", "Muy rizado", "Media", TRUE, TRUE),
(26, "Marrones", "Rubio", "Liso", "Delgada", FALSE, FALSE),
(27, "Azules", "Castaño", "Ondulado", "Robusta", TRUE, TRUE),
(28, "Verdes", "Negro", "Rizado", "Media", FALSE, TRUE),
(29, "Marrones", "Rubio", "Liso", "Delgada", TRUE, FALSE),
(30, "Azules", "Castaño oscuro", "Ondulado", "Robusta", FALSE, TRUE),
(31, "Marrones", "Negro", "Muy rizado", "Media", TRUE, TRUE),
(32, "Verdes", "Rubio", "Liso", "Delgada", FALSE, FALSE),
(33, "Azules", "Castaño", "Ondulado", "Robusta", TRUE, TRUE),
(34, "Marrones", "Negro", "Rizado", "Media", FALSE, TRUE),
(35, "Avellana", "Pelirrojo", "Liso", "Delgada", TRUE, FALSE),
(36, "Verdes", "Rubio", "Ondulado", "Robusta", FALSE, TRUE),
(37, "Marrones", "Castaño", "Muy rizado", "Media", TRUE, TRUE),
(38, "Azules", "Negro", "Liso", "Delgada", FALSE, FALSE),
(39, "Verdes", "Rubio", "Ondulado", "Robusta", TRUE, TRUE),
(40, "Marrones", "Castaño oscuro", "Rizado", "Media", FALSE, TRUE),
(41, "Azules", "Negro", "Liso", "Delgada", TRUE, FALSE),
(42, "Marrones", "Rubio", "Ondulado", "Robusta", FALSE, TRUE),
(43, "Verdes", "Castaño", "Muy rizado", "Media", TRUE, TRUE),
(44, "Azules", "Negro", "Liso", "Delgada", FALSE, FALSE),
(45, "Marrones", "Rubio", "Ondulado", "Robusta", TRUE, TRUE),
(46, "Avellana", "Pelirrojo", "Rizado", "Media", FALSE, TRUE),
(47, "Verdes", "Negro", "Liso", "Delgada", TRUE, FALSE),
(48, "Azules", "Castaño", "Ondulado", "Robusta", FALSE, TRUE),
(49, "Marrones", "Rubio", "Muy rizado", "Media", TRUE, TRUE),
(50, "Verdes", "Negro", "Liso", "Delgada", FALSE, FALSE);

INSERT INTO persona_nacionalidad (persona_id, nacionalidad_id, es_principal) VALUES
 (1, 1, TRUE),   -- Francisco Javier (España)
(2, 1, TRUE),   -- Alejandro (España)
(3, 1, TRUE),   -- Sofía (España)
(4, 1, TRUE),   -- Carlos (España)
(5, 2, TRUE),   -- Valentina (México)
(6, 1, TRUE),   -- Javier (España)
(7, 1, TRUE),   -- Isabella (España)
(8, 4, TRUE),   -- Diego (Argentina)
(9, 1, TRUE),   -- Lucía (España)
(10, 1, TRUE),  -- Mateo (España)
(11, 3, TRUE),  -- Camila (Colombia)
(12, 1, TRUE),  -- Adrián (España)
(13, 5, TRUE),  -- Emma (Perú)
(14, 6, TRUE),  -- Daniel (Chile)
(15, 1, TRUE),  -- Paula (España)
(16, 1, TRUE),  -- Hugo (España)
(17, 7, TRUE),  -- Martina (Brasil)
(18, 1, TRUE),  -- Álvaro (España)
(19, 8, TRUE),  -- Valeria (Uruguay)
(20, 1, TRUE),  -- Sergio (España)
(21, 9, TRUE),  -- Elena (Venezuela)
(22, 1, TRUE),  -- Pablo (España)
(23, 2, TRUE),  -- Renata (México)
(24, 1, TRUE),  -- Jorge (España)
(25, 3, TRUE),  -- Olivia (Colombia)
(26, 1, TRUE),  -- Raúl (España)
(27, 7, TRUE),  -- Ana (Brasil)
(28, 1, TRUE),  -- David (España)
(29, 10, TRUE), -- Gabriela (Ecuador)
(30, 1, TRUE),  -- Iván (España)
(31, 11, TRUE), -- Zoe (Bolivia)
(32, 1, TRUE),  -- Francisco (España)
(33, 9, TRUE),  -- Luna (Venezuela)
(34, 1, TRUE),  -- Rubén (España)
(35, 2, TRUE),  -- Claudia (México)
(36, 1, TRUE),  -- Antonio (España)
(37, 10, TRUE), -- Aitana (Ecuador)
(38, 1, TRUE),  -- Miguel (España)
(39, 12, TRUE), -- Carla (Panamá)
(40, 1, TRUE),  -- José (España)
(41, 13, TRUE), -- Alba (Nicaragua)
(42, 1, TRUE),  -- Juan (España)
(43, 14, TRUE), -- Nora (Honduras)
(44, 1, TRUE),  -- Fernando (España)
(45, 2, TRUE), -- Daniela (Paraguay)
(46, 1, TRUE),  -- Roberto (España)
(47, 3, TRUE), -- Victoria (Costa Rica)
(48, 1, TRUE),  -- Manuel (España)
(49, 4, TRUE), -- Julia (El Salvador)
(50, 1, TRUE),  -- Óscar (España)
(51, 8, TRUE), -- Marina (Francia)

-- Algunas nacionalidades secundarias
(1, 5, FALSE),  -- Francisco Javier también tiene nacionalidad peruana
(5, 1, FALSE),  -- Valentina también tiene nacionalidad española
(8, 1, FALSE),  -- Diego también tiene nacionalidad española
(11, 1, FALSE), -- Camila también tiene nacionalidad española
(17, 1, FALSE), -- Martina también tiene nacionalidad española
(19, 1, FALSE), -- Valeria también tiene nacionalidad española
(21, 1, FALSE), -- Elena también tiene nacionalidad española
(25, 1, FALSE), -- Olivia también tiene nacionalidad española
(29, 1, FALSE), -- Gabriela también tiene nacionalidad española
(33, 1, FALSE), -- Luna también tiene nacionalidad española
(35, 1, FALSE), -- Claudia también tiene nacionalidad española
(37, 1, FALSE), -- Aitana también tiene nacionalidad española
(39, 1, FALSE), -- Carla también tiene nacionalidad española
(41, 1, FALSE), -- Alba también tiene nacionalidad española
(43, 1, FALSE), -- Nora también tiene nacionalidad española
(45, 1, FALSE), -- Daniela también tiene nacionalidad española
(47, 1, FALSE), -- Victoria también tiene nacionalidad española
(49, 1, FALSE), -- Julia también tiene nacionalidad española
(51, 1, FALSE); -- Marina también tiene nacionalidad española


