63 lines
4.7 KiB
Plaintext
63 lines
4.7 KiB
Plaintext
PRAGMA foreign_keys=OFF;
|
|
BEGIN TRANSACTION;
|
|
CREATE TABLE Registro
|
|
(
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
nombre VARCHAR(50) NOT NULL,
|
|
apellido VARCHAR(50) NOT NULL,
|
|
titulo VARCHAR(50),
|
|
afiliacion VARCHAR(50),
|
|
ciudad VARCHAR(50),
|
|
pais VARCHAR(50),
|
|
email VARCHAR(80) NOT NULL UNIQUE,
|
|
fechaLlegada DATE,
|
|
fechaPartida DATE,
|
|
financiacion BOOLEAN NOT NULL,
|
|
invitado BOOLEAN NOT NULL,
|
|
cartaInvitacion BOOLEAN NOT NULL,
|
|
roomingPref VARCHAR(50),
|
|
roommate VARCHAR(50),
|
|
fechaRegistro DATETIME NOT NULL
|
|
);
|
|
INSERT INTO "Registro" VALUES(1,'German','Correa','','','Montevideo','Uruguay','german.correa.balier@gmail.com','','',0,0,0,'
|
|
','German Correa','2017-12-18 18:05:28');
|
|
INSERT INTO "Registro" VALUES(2,'German','Correa','','','Montevideo','Uruguay','german.correa.basslier@gmail.com','','',1,1,1,'
|
|
','German Correa','2017-12-18 19:04:38');
|
|
INSERT INTO "Registro" VALUES(3,'German','Correa','','','Montevideo','Uruguay','gaaerman.correa.balier@gmail.com','','',0,0,1,'
|
|
','German Correa','2017-12-18 19:05:15');
|
|
INSERT INTO "Registro" VALUES(4,'German','Correa','','','Montevideo','Uruguay','aagerman.correa.balier@gmail.com','','',1,0,1,'
|
|
','German Correa','2017-12-18 19:06:34');
|
|
CREATE TABLE Speakers
|
|
(
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
nombre VARCHAR(50) NOT NULL,
|
|
apellido VARCHAR(50) NOT NULL,
|
|
afiliacion VARCHAR(50) NOT NULL,
|
|
foto VARCHAR(200),
|
|
web VARCHAR(200),
|
|
confirmado BOOLEAN
|
|
);
|
|
INSERT INTO "Speakers" VALUES(1,'Jairo','Bochi','Universidad Católica de Chile','img/speakers/jariobochi.jpg','http://www.mat.uc.cl/~jairo.bochi/',1);
|
|
INSERT INTO "Speakers" VALUES(2,'Christian','Bonatti','Université de Bourgogne','img/speakers/cbonatti.jpg','http://bonatti.perso.math.cnrs.fr/',1);
|
|
INSERT INTO "Speakers" VALUES(3,'Keith','Burns','Northwestern University','img/speakers/kburns.jpg','http://www.math.northwestern.edu/~burns/',1);
|
|
INSERT INTO "Speakers" VALUES(4,'Yaiza','Canzani','University of North Carolina at Chapel Hill','img/speakers/ycanzani.jpg','http://canzani.web.unc.edu/',1);
|
|
INSERT INTO "Speakers" VALUES(5,'Gonzalo','Contreras','CIMAT, Guanajuato','img/speakers/gcontreras.jpg','http://www.cimat.mx/~gonzalo/',1);
|
|
INSERT INTO "Speakers" VALUES(6,'Adriana','da Luz','Universidad de la República','img/speakers/adaluz.jpg','',1);
|
|
INSERT INTO "Speakers" VALUES(7,'Colin','Guillarmou','Université Paris-Sud','img/speakers/cguillarmou.jpg','https://www.math.u-psud.fr/~guillarmou/',1);
|
|
INSERT INTO "Speakers" VALUES(8,'Ursula','Hamenstädt','Universität Bonn','img/speakers/uhamenstadt.jpg','http://www.math.uni-bonn.de/people/ursula/',1);
|
|
INSERT INTO "Speakers" VALUES(9,'Thomas','Koberda','University of Virginia','img/speakers/tkoberda.jpg','http://faculty.virginia.edu/Koberda/',1);
|
|
INSERT INTO "Speakers" VALUES(10,'Andrés','Koropecki','Universidade Federal Fluminense','img/speakers/akoropecki.jpg','http://www.professores.uff.br/koro/',1);
|
|
INSERT INTO "Speakers" VALUES(11,'François','Ledrappier','University of Notre Dame','img/speakers/fledrappier.jpg','http://math.nd.edu/people/faculty/francois-ledrappier/',1);
|
|
INSERT INTO "Speakers" VALUES(12,'Yash','Lodha','Cornell University','img/speakers/ylodha.jpg','http://www.math.cornell.edu/m/People/bynetid/yl763',1);
|
|
INSERT INTO "Speakers" VALUES(13,'Leonardo','Macarini','Universidade Federal do Rio de Janeiro','img/speakers/lmacarini.jpg','http://www.im.ufrj.br/visualizarDocente.php?idDepartamento=3&idDocente=28',1);
|
|
INSERT INTO "Speakers" VALUES(14,'Kathryn','Mann','Brown University','img/speakers/kmann.jpg','http://www.math.brown.edu/~mann/index.html',1);
|
|
INSERT INTO "Speakers" VALUES(15,'Andrés','Navas','Universidad de Santiago de Chile','img/speakers/anavas.jpg','http://www.mat.usach.cl/index.php/2012-12-19-12-50-19/academicos/75-andres-navas-flores',1);
|
|
INSERT INTO "Speakers" VALUES(16,'Jean-François','Quint','Université Bordeaux I','img/speakers/jfquint.jpg','https://www.math.u-bordeaux.fr/~jquint/',1);
|
|
INSERT INTO "Speakers" VALUES(17,'Andrés','Sambarino','Université Paris VI','img/speakers/asambarino.jpg','https://webusers.imj-prg.fr/~andres.sambarino/',1);
|
|
INSERT INTO "Speakers" VALUES(18,'Pablo','Shmerkin','Universidad Torcuato Di Tella','img/speakers/pshmerkin.jpg','http://www.utdt.edu/profesores/pshmerkin',1);
|
|
INSERT INTO "Speakers" VALUES(19,'Maxime','Wolff','Université Paris VI','img/speakers/mwolff.jpg','https://webusers.imj-prg.fr/~maxime.wolff/',1);
|
|
DELETE FROM sqlite_sequence;
|
|
INSERT INTO "sqlite_sequence" VALUES('Speakers',19);
|
|
INSERT INTO "sqlite_sequence" VALUES('Registro',4);
|
|
COMMIT;
|