BEGIN TRANSACTION;
CREATE TABLE tess(item_no INT PRIMARY KEY, family_name VARCHAR(20), first_name VARCHAR(30), date_of_birth datetime, gender VARCHAR(10), email VARCHAR(30), country VARCHAR(20), citizenship VARCHAR(30), home_university text, univ_country VARCHAR(20), departure VARCHAR(20), on_campus VARCHAR(10), confirmed VARCHAR(2), room_no VARCHAR(10));
INSERT INTO "tess" VALUES(1,'Sun','Bo',19861226,'Female','sunbo1226@gmail.com','Sweden','China','SE_KTH, Royal Institute of Technology','Sweden','July 14','','X','A1-06');
INSERT INTO "tess" VALUES(2,'Galiano Molina','Sebastián',19830310,'Male','sgm@kth.se','Spain','Spanish','SE_KTH, Royal Institute of Technology','Sweden','','No','X','');
INSERT INTO "tess" VALUES(3,'Dombi','Gergely',19860910,'Male','dombika-steve@freemail.hu','Hungary','Hungarian','HU_Budapest Univ. of Technology and Economics','Hungary','','','X','A2-08');
INSERT INTO "tess" VALUES(4,'Chen','Xiaohu',19860828,'Male','xiaohu.angel@gmail.com','Sweden','Chinese','SE_KTH, Royal Institute of Technology','Sweden','July 14','','X','A1-12');
INSERT INTO "tess" VALUES(5,'Arany-Tóth','Krisztina',19870202,'Female','aranytothkrisztina@citromail.hu','Hungary','Hungarian','HU_Budapest Univ. of Technology and Economics','Hungary','July 12','','X','A1-15');
INSERT INTO "tess" VALUES(6,'Gyetvai','Máté',1986,'Male','gyetvaim@gmail.com','Hungary','Hungary','HU_Budapest Univ. of Technology and Economics','','July 11, 1:20pm','','X','A1-17');
INSERT INTO "tess" VALUES(7,'Blanding','Michael',19851011,'Male','blanding@kth.se','Sweden','United States of America','SE_KTH, Royal Institute of Technology','','','No','X','');
INSERT INTO "tess" VALUES(8,'Beaini','Chadi',19850901,'Male','chady.beainy@gmail.com','Sweden','Lebanese','SE_KTH, Royal Institute of Technology','','July 13','','X','A1-07');
COMMIT;