coloquio_api/sql/values.sql

insert into pais values(null,'Afganistán');
insert into pais values(null,'Albania');
insert into pais values(null,'Alemania');
insert into pais values(null,'Andorra');
insert into pais values(null,'Angola');
insert into pais values(null,'Antigua y Barbuda');
insert into pais values(null,'Arabia Saudita');
insert into pais values(null,'Argelia');
insert into pais values(null,'Argentina');
insert into pais values(null,'Armenia');
insert into pais values(null,'Australia');
insert into pais values(null,'Austria');
insert into pais values(null,'Azerbaiyán');
insert into pais values(null,'Bahamas');
insert into pais values(null,'Bangladés');
insert into pais values(null,'Barbados');
insert into pais values(null,'Baréin');
insert into pais values(null,'Bélgica');
insert into pais values(null,'Belice');
insert into pais values(null,'Benín');
insert into pais values(null,'Bielorrusia');
insert into pais values(null,'Birmania');
insert into pais values(null,'Bolivia');
insert into pais values(null,'Bosnia y Herzegovina');
insert into pais values(null,'Botsuana');
insert into pais values(null,'Brasil');
insert into pais values(null,'Brunéi');
insert into pais values(null,'Bulgaria');
insert into pais values(null,'Burkina Faso');
insert into pais values(null,'Burundi');
insert into pais values(null,'Bután');
insert into pais values(null,'Cabo Verde');
insert into pais values(null,'Camboya');
insert into pais values(null,'Camerún');
insert into pais values(null,'Canadá');
insert into pais values(null,'Catar');
insert into pais values(null,'Chad');
insert into pais values(null,'Chile');
insert into pais values(null,'China');
insert into pais values(null,'Chipre');
insert into pais values(null,'Ciudad del Vaticano');
insert into pais values(null,'Colombia');
insert into pais values(null,'Comoras');
insert into pais values(null,'Corea del Norte');
insert into pais values(null,'Corea del Sur');
insert into pais values(null,'Costa de Marfil');
insert into pais values(null,'Costa Rica');
insert into pais values(null,'Croacia');
insert into pais values(null,'Cuba');
insert into pais values(null,'Dinamarca');
insert into pais values(null,'Dominica');
insert into pais values(null,'Ecuador');
insert into pais values(null,'Egipto');
insert into pais values(null,'El Salvador');
insert into pais values(null,'Emiratos Árabes Unidos');
insert into pais values(null,'Eritrea');
insert into pais values(null,'Eslovaquia');
insert into pais values(null,'Eslovenia');
insert into pais values(null,'España');
insert into pais values(null,'Estados Unidos');
insert into pais values(null,'Estonia');
insert into pais values(null,'Etiopía');
insert into pais values(null,'Filipinas');
insert into pais values(null,'Finlandia');
insert into pais values(null,'Fiyi');
insert into pais values(null,'Francia');
insert into pais values(null,'Gabón');
insert into pais values(null,'Gambia');
insert into pais values(null,'Georgia');
insert into pais values(null,'Ghana');
insert into pais values(null,'Granada');
insert into pais values(null,'Grecia');
insert into pais values(null,'Guatemala');
insert into pais values(null,'Guyana');
insert into pais values(null,'Guinea');
insert into pais values(null,'Guinea-Bisáu');
insert into pais values(null,'Guinea Ecuatorial');
insert into pais values(null,'Haití');
insert into pais values(null,'Honduras');
insert into pais values(null,'Hungría');
insert into pais values(null,'India');
insert into pais values(null,'Indonesia');
insert into pais values(null,'Irak');
insert into pais values(null,'Irán');
insert into pais values(null,'Irlanda');
insert into pais values(null,'Islandia');
insert into pais values(null,'Islas Marshall');
insert into pais values(null,'Islas Salomón');
insert into pais values(null,'Israel');
insert into pais values(null,'Italia');
insert into pais values(null,'Jamaica');
insert into pais values(null,'Japón');
insert into pais values(null,'Jordania');
insert into pais values(null,'Kazajistán');
insert into pais values(null,'Kenia');
insert into pais values(null,'Kirguistán');
insert into pais values(null,'Kiribati');
insert into pais values(null,'Kuwait');
insert into pais values(null,'Laos');
insert into pais values(null,'Lesoto');
insert into pais values(null,'Letonia');
insert into pais values(null,'Líbano');
insert into pais values(null,'Liberia');
insert into pais values(null,'Libia');
insert into pais values(null,'Liechtenstein');
insert into pais values(null,'Lituania');
insert into pais values(null,'Luxemburgo');
insert into pais values(null,'Macedonia del Norte');
insert into pais values(null,'Madagascar');
insert into pais values(null,'Malasia');
insert into pais values(null,'Malaui');
insert into pais values(null,'Maldivas');
insert into pais values(null,'Malí');
insert into pais values(null,'Malta');
insert into pais values(null,'Marruecos');
insert into pais values(null,'Mauricio');
insert into pais values(null,'Mauritania');
insert into pais values(null,'México');
insert into pais values(null,'Micronesia');
insert into pais values(null,'Moldavia');
insert into pais values(null,'Mónaco');
insert into pais values(null,'Mongolia');
insert into pais values(null,'Montenegro');
insert into pais values(null,'Mozambique');
insert into pais values(null,'Namibia');
insert into pais values(null,'Nauru');
insert into pais values(null,'Nepal');
insert into pais values(null,'Nicaragua');
insert into pais values(null,'Níger');
insert into pais values(null,'Nigeria');
insert into pais values(null,'Noruega');
insert into pais values(null,'Nueva Zelanda');
insert into pais values(null,'Omán');
insert into pais values(null,'Países Bajos');
insert into pais values(null,'Pakistán');
insert into pais values(null,'Palaos');
insert into pais values(null,'Panamá');
insert into pais values(null,'Papúa Nueva Guinea');
insert into pais values(null,'Paraguay');
insert into pais values(null,'Perú');
insert into pais values(null,'Polonia');
insert into pais values(null,'Portugal');
insert into pais values(null,'Reino Unido de Gran Bretaña e Irlanda del Norte');
insert into pais values(null,'República Centroafricana');
insert into pais values(null,'República Checa');
insert into pais values(null,'República del Congo');
insert into pais values(null,'República Democrática del Congo');
insert into pais values(null,'República Dominicana');
insert into pais values(null,'República Sudafricana');
insert into pais values(null,'Ruanda');
insert into pais values(null,'Rumanía');
insert into pais values(null,'Rusia');
insert into pais values(null,'Samoa');
insert into pais values(null,'San Cristóbal y Nieves');
insert into pais values(null,'San Marino');
insert into pais values(null,'San Vicente y las Granadinas');
insert into pais values(null,'Santa Lucía');
insert into pais values(null,'Santo Tomé y Príncipe');
insert into pais values(null,'Senegal');
insert into pais values(null,'Serbia');
insert into pais values(null,'Seychelles');
insert into pais values(null,'Sierra Leona');
insert into pais values(null,'Singapur');
insert into pais values(null,'Siria');
insert into pais values(null,'Somalia');
insert into pais values(null,'Sri Lanka');
insert into pais values(null,'Suazilandia');
insert into pais values(null,'Sudán');
insert into pais values(null,'Sudán del Sur');
insert into pais values(null,'Suecia');
insert into pais values(null,'Suiza');
insert into pais values(null,'Surinam');
insert into pais values(null,'Tailandia');
insert into pais values(null,'Tanzania');
insert into pais values(null,'Tayikistán');
insert into pais values(null,'Timor Oriental');
insert into pais values(null,'Togo');
insert into pais values(null,'Tonga');
insert into pais values(null,'Trinidad y Tobago');
insert into pais values(null,'Túnez');
insert into pais values(null,'Turkmenistán');
insert into pais values(null,'Turquía');
insert into pais values(null,'Tuvalu');
insert into pais values(null,'Ucrania');
insert into pais values(null,'Uganda');
insert into pais values(null,'Uruguay');
insert into pais values(null,'Uzbekistán');
insert into pais values(null,'Vanuatu');
insert into pais values(null,'Venezuela');
insert into pais values(null,'Vietnam');
insert into pais values(null,'Yemen');
insert into pais values(null,'Yibuti');
insert into pais values(null,'Zambia');
insert into pais values(null,'Zimbabue');

-- insert into admin values(null, 'Mesa_1', 'psorem12Ps', 'Educación inclusiva' );
insert into admin values(null, 'Mesa_1', '$2b$10$6a14ky/x3/jCHnUvFCt.2u4FWevFPunJ2TcItkr2S4Inm2LetxcVi', 'Educación inclusiva' );
-- insert into admin values(null, 'Mesa_2', 'Os3AeM12j4', 'Educación y género' );
insert into admin values(null, 'Mesa_2', '$2b$10$rYSFHOa3hqE5nXCmORIlQuG.IkKDoXl0uJt/PJ7Zi6CFLhHALTVNW', 'Educación y género' );
-- insert into admin values(null, 'Mesa_3', 'Psa212uyj9', 'Ética, valores y formación socioemocial' );
insert into admin values(null, 'Mesa_3', '$2b$10$Cl9oZQBceciU2sNl.1fmEuXxYd25NA8O52lsgFJCSKIU5vQc/AcDi', 'Ética, valores y formación socioemocial' );

--insert into admin values(null, 'Mesa_5', 'qieuX98sPv', 'Experiencias de innovación e intervención en la educación' );
insert into admin values(null, 'Mesa_4', '$2b$10$9Vm2v.wiHq6UCyNDQlgGbO/0ckRDX8OFoYGm38tOlRFbxffKKPFcO', 'Experiencias de innovación e intervención en la educación' );

--insert into admin values(null, 'Mesa_4', 'PiAWn857m1', 'Educación inclusiva' );
insert into admin values(null, 'Mesa_5', '$2b$10$JuknC0rVgnEeYHffeN6tSu6SgrLJcI1uIVQ7e9RX8sku8hdQ/qPc2', 'Las TIC y las TAC en la educación' );

--insert into admin values(null, 'Mesa_6', '784ycs5Rsa', 'Lectura y escritura en la formación académica' );
insert into admin values(null, 'Mesa_6', '$2b$10$QB7RnmzxCMc.l3x3LBP3s.wj9.k0E3LxY3MlR7HGU6flLcWKsnDpa', 'Lectura y escritura en la formación académica' );

--insert into admin values(null, 'Mesa_7', 'aks8943PJH', 'Propuestas de transformación curricular' );
insert into admin values(null, 'Mesa_7', '$2b$10$P2LUgBFfkoWkTFwexJJneuyT23SPOKsnjboUnLIJ5bm1k0N3pNB8m', 'Propuestas de transformación curricular' );

--insert into admin values(null, 'Mesa_8', '8H7aje9Cv2', 'Políticas públicas para la innovación y transformación educativa' );
insert into admin values(null, 'Mesa_8', '$2b$10$sBQYtnJsqCuNGVH.IKv4zu8x.KazpMGsAhCpf/f4AhDzVAdL0eLaW', 'Políticas públicas para la innovación y transformación educativa' );

--insert into admin values(null, 'Mesa_9', 'ksi8REn91C', 'Educación ambiental y bioética' );
insert into admin values(null, 'Mesa_9', '$2b$10$zULlGphKeqXkvqAifLX7r.XlZYDJ4035O2mNKUvLOK9DW7cL9wMA2', 'Educación ambiental y bioética' );

--insert into admin values(null, 'Administrador', 'CMfcStNPjz', '' );
insert into admin values(null, 'Administrador', '$2b$10$YqVknXcVK3g4H.b4X7ecVO9inEvBA0vBKrN1lZyRL1U9p0qwEQGJm', '' );





insert into evento values (null,"Mesa tematica",  "Mesa 9: Educación ambiental y bioética.", 60,  "Sala 1");

insert into fecha values(null , 1, '2020-08-17 12:00:00' , '2020-08-17 15:00:00');

insert into evento values (null,"Mesa tematica",  "Mesa 8: Políticas Públicas  para la innovación y transoformación educativa.", 60, "Sala 2");

insert into fecha values(null , 2, '2020-08-17 12:00:00', '2020-08-17 15:00:00');

insert into evento values (null,"Mesa tematica", "Mesa 7: Propuestas de Tranformación Curricular.", 50, "Sala de videoconferencias");

insert into fecha values(null , 3, '2020-08-17 12:00:00', '2020-08-17 15:00:00');



insert into evento values (null,"Mesa tematica", "Mesa 4: Experiencias de innovación e intervención.", 60, "Sala 1");
 
insert into fecha values(null , 4, '2020-08-18 11:00:00', '2020-08-18 15:00:00');

insert into evento values (null,"Mesa tematica", "Mesa 1: Educación Inclusiva.", 60, "Sala 2");

insert into fecha values(null , 5, '2020-08-18 11:00:00', '2020-08-18 15:00:00');

insert into evento values (null,"Mesa tematica", "Mesa 6: Lectura y Escritura.", 50, "Sala de videoconferencias");

insert into fecha values (null , 6, '2020-08-18 11:00:00', '2020-08-18 15:00:00');



insert into evento values (null,"Mesa tematica", "Mesa 5: TIC y las TAC en la Educación.", 60, "Sala 1");

insert into fecha values (null , 7, '2020-08-19 12:00:00', '2020-08-19 15:00:00');

insert into evento values (null,"Mesa tematica", "Mesa 2: Educación y Género", 60, "Sala 2");

insert into fecha values (null , 8, '2020-08-19 12:00:00', '2020-08-19 15:00:00');

insert into evento values (null,"Mesa tematica", "Mesa 3: Ética, Valores y formación Socioemocial.", 50, "Sala de videoconferencias");

insert into fecha values (null , 9 , '2020-08-19 12:00:00', '2020-08-19 15:00:00');



insert into evento values (null, "Taller",  "Taller 1: Lectura y Escritura.", 35, "Aula Magna UIM II" );

insert into fecha values (null , 10 , '2020-08-17 16:00:00', '2020-08-17 17:00:00');

insert into fecha values (null , 10 , '2020-08-18 16:00:00', '2020-08-18 18:00:00');

insert into fecha values (null , 10 , '2020-08-19 16:00:00', '2020-08-19 17:00:00');



insert into evento values (null, "Taller",  "Taller 2: Educación Inclusiva.", 35, "Sala de Seminarios" );

insert into fecha values (null , 11 , '2020-08-17 17:00:00', '2020-08-17 18:00:00');

insert into fecha values (null , 11 , '2020-08-18 16:00:00', '2020-08-18 18:00:00');

insert into fecha values (null , 11 , '2020-08-19 16:00:00', '2020-08-19 17:00:00');



insert into evento values (null, "Ponencia",  "Ponencia Magistral: Dra. Raquel Glazman.", 150, "Unidad de Congresos UIM II" );

insert into fecha values (null , 12 , '2020-08-17 10:00:00', '2020-08-17 12:00:00');

insert into evento values (null, "Ponencia",  "Ponencia Magistral: Dra. Alma Rosa Sánchez.", 150, "Unidad de Congresos UIM II" );

insert into fecha values (null , 13 , '2020-08-18 10:00:00', '2020-08-18 11:00:00');

insert into evento values (null, "Ponencia",  "Ponencia Magistral: J. César Arboleda.", 150, "Unidad de Congresos UIM II" );

insert into fecha values (null , 14 , '2020-08-19 10:00:00', '2020-08-18 11:00:00');

insert into evento values (null, "Ponencia",  "Ponencia Magistral: Lucie Sauvé", 150, "Unidad de Congresos UIM II" );

insert into fecha values (null , 15 , '2020-08-19 10:45:00', '2020-08-18 12:00:00');