PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "matches" (
"loser_id" INT,
"loser_ioc" TEXT,
"winner_id" INT,
FOREIGN KEY ("loser_id") REFERENCES "players"("player_id"),
FOREIGN KEY ("winner_id") REFERENCES "players"("player_id")
);

CREATE TABLE "players" (
"player_id" INT UNIQUE,
"country_code" TEXT,
PRIMARY KEY ("player_id")
);





INSERT INTO "players" VALUES ("1", "USA");
INSERT INTO "players" VALUES ("2", "USA");
INSERT INTO "players" VALUES ("3", "USA");
INSERT INTO "players" VALUES ("4", "USA");
INSERT INTO "players" VALUES ("5", "USA");
INSERT INTO "players" VALUES ("6", "USA");
INSERT INTO "players" VALUES ("7", "USA");
INSERT INTO "players" VALUES ("8", "USA");
INSERT INTO "players" VALUES ("9", "USA");
INSERT INTO "players" VALUES ("10", "USA");
INSERT INTO "players" VALUES ("11", "USA");
INSERT INTO "players" VALUES ("12", "USA");
INSERT INTO "players" VALUES ("13", "USA");
INSERT INTO "players" VALUES ("14", "USA");
INSERT INTO "players" VALUES ("15", "USA");
INSERT INTO "players" VALUES ("16", "USA");
INSERT INTO "players" VALUES ("17", "USA");
INSERT INTO "players" VALUES ("18", "USA");
INSERT INTO "players" VALUES ("19", "USA");
INSERT INTO "players" VALUES ("20", "USA");
INSERT INTO "players" VALUES ("21", "USA");
INSERT INTO "players" VALUES ("22", "USA");
INSERT INTO "players" VALUES ("23", "USA");
INSERT INTO "players" VALUES ("24", "USA");
INSERT INTO "players" VALUES ("25", "USA");
INSERT INTO "players" VALUES ("26", "USA");
INSERT INTO "players" VALUES ("27", "USA");
INSERT INTO "players" VALUES ("28", "USA");
INSERT INTO "players" VALUES ("29", "USA");
INSERT INTO "players" VALUES ("30", "USA");
INSERT INTO "players" VALUES ("31", "USA");
INSERT INTO "players" VALUES ("32", "USA");
INSERT INTO "players" VALUES ("33", "USA");
INSERT INTO "players" VALUES ("34", "USA");
INSERT INTO "players" VALUES ("35", "USA");
INSERT INTO "players" VALUES ("36", "USA");
INSERT INTO "players" VALUES ("37", "USA");
INSERT INTO "players" VALUES ("38", "USA");
INSERT INTO "players" VALUES ("39", "USA");
INSERT INTO "players" VALUES ("40", "USA");
INSERT INTO "players" VALUES ("41", "USA");
INSERT INTO "players" VALUES ("42", "USA");
INSERT INTO "players" VALUES ("43", "USA");
INSERT INTO "players" VALUES ("44", "USA");
INSERT INTO "players" VALUES ("45", "USA");
INSERT INTO "players" VALUES ("46", "USA");
INSERT INTO "players" VALUES ("47", "USA");
INSERT INTO "players" VALUES ("48", "USA");
INSERT INTO "players" VALUES ("49", "USA");
INSERT INTO "players" VALUES ("50", "USA");
INSERT INTO "players" VALUES ("51", "USA");
INSERT INTO "players" VALUES ("52", "USA");
INSERT INTO "players" VALUES ("53", "USA");
INSERT INTO "players" VALUES ("54", "USA");
INSERT INTO "players" VALUES ("55", "USA");
INSERT INTO "players" VALUES ("56", "USA");
INSERT INTO "players" VALUES ("57", "USA");
INSERT INTO "players" VALUES ("58", "USA");
INSERT INTO "players" VALUES ("59", "USA");
INSERT INTO "players" VALUES ("60", "USA");
INSERT INTO "players" VALUES ("61", "FRA");
INSERT INTO "players" VALUES ("62", "FRA");
INSERT INTO "players" VALUES ("63", "FRA");
INSERT INTO "players" VALUES ("64", "FRA");
INSERT INTO "players" VALUES ("65", "FRA");
INSERT INTO "players" VALUES ("66", "FRA");
INSERT INTO "players" VALUES ("67", "FRA");
INSERT INTO "players" VALUES ("68", "FRA");
INSERT INTO "players" VALUES ("69", "FRA");
INSERT INTO "players" VALUES ("70", "FRA");
INSERT INTO "players" VALUES ("71", "FRA");
INSERT INTO "players" VALUES ("72", "FRA");
INSERT INTO "players" VALUES ("73", "FRA");
INSERT INTO "players" VALUES ("74", "FRA");
INSERT INTO "players" VALUES ("75", "FRA");
INSERT INTO "players" VALUES ("76", "FRA");
INSERT INTO "players" VALUES ("77", "FRA");
INSERT INTO "players" VALUES ("78", "FRA");
INSERT INTO "players" VALUES ("79", "FRA");
INSERT INTO "players" VALUES ("80", "FRA");
INSERT INTO "players" VALUES ("81", "FRA");
INSERT INTO "players" VALUES ("82", "FRA");
INSERT INTO "players" VALUES ("83", "FRA");
INSERT INTO "players" VALUES ("84", "FRA");
INSERT INTO "players" VALUES ("85", "FRA");
INSERT INTO "players" VALUES ("86", "FRA");
INSERT INTO "players" VALUES ("87", "FRA");
INSERT INTO "players" VALUES ("88", "FRA");
INSERT INTO "players" VALUES ("89", "FRA");
INSERT INTO "players" VALUES ("90", "FRA");
INSERT INTO "players" VALUES ("91", "FRA");
INSERT INTO "players" VALUES ("92", "FRA");
INSERT INTO "players" VALUES ("93", "FRA");
INSERT INTO "players" VALUES ("94", "FRA");
INSERT INTO "players" VALUES ("95", "FRA");
INSERT INTO "players" VALUES ("96", "FRA");
INSERT INTO "players" VALUES ("97", "FRA");
INSERT INTO "players" VALUES ("98", "FRA");
INSERT INTO "players" VALUES ("99", "FRA");
INSERT INTO "players" VALUES ("100", "FRA");
INSERT INTO "players" VALUES ("101", "GER");
INSERT INTO "players" VALUES ("102", "GER");
INSERT INTO "players" VALUES ("103", "GER");
INSERT INTO "players" VALUES ("104", "GER");
INSERT INTO "players" VALUES ("105", "GER");
INSERT INTO "players" VALUES ("106", "GER");
INSERT INTO "players" VALUES ("107", "GER");
INSERT INTO "players" VALUES ("108", "GER");
INSERT INTO "players" VALUES ("109", "GER");
INSERT INTO "players" VALUES ("110", "GER");
INSERT INTO "players" VALUES ("111", "GER");
INSERT INTO "players" VALUES ("112", "GER");
INSERT INTO "players" VALUES ("113", "GER");
INSERT INTO "players" VALUES ("114", "GER");
INSERT INTO "players" VALUES ("115", "GER");
INSERT INTO "players" VALUES ("116", "GER");
INSERT INTO "players" VALUES ("117", "GER");
INSERT INTO "players" VALUES ("118", "GER");
INSERT INTO "players" VALUES ("119", "GER");
INSERT INTO "players" VALUES ("120", "GER");
INSERT INTO "players" VALUES ("121", "GER");
INSERT INTO "players" VALUES ("122", "GER");
INSERT INTO "players" VALUES ("123", "GER");
INSERT INTO "players" VALUES ("124", "GER");
INSERT INTO "players" VALUES ("125", "GER");
INSERT INTO "players" VALUES ("126", "GER");
INSERT INTO "players" VALUES ("127", "GER");
INSERT INTO "players" VALUES ("128", "GER");
INSERT INTO "players" VALUES ("129", "GER");
INSERT INTO "players" VALUES ("130", "GER");
INSERT INTO "players" VALUES ("131", "GER");
INSERT INTO "players" VALUES ("132", "GER");
INSERT INTO "players" VALUES ("133", "GER");
INSERT INTO "players" VALUES ("134", "GER");
INSERT INTO "players" VALUES ("135", "GER");
INSERT INTO "players" VALUES ("136", "GER");
INSERT INTO "players" VALUES ("137", "GER");
INSERT INTO "players" VALUES ("138", "GER");
INSERT INTO "players" VALUES ("139", "GER");
INSERT INTO "players" VALUES ("140", "GER");
INSERT INTO "players" VALUES ("141", "ESP");
INSERT INTO "players" VALUES ("142", "ESP");
INSERT INTO "players" VALUES ("143", "ESP");
INSERT INTO "players" VALUES ("144", "ESP");
INSERT INTO "players" VALUES ("145", "ESP");
INSERT INTO "players" VALUES ("146", "ESP");
INSERT INTO "players" VALUES ("147", "ESP");
INSERT INTO "players" VALUES ("148", "ESP");
INSERT INTO "players" VALUES ("149", "ESP");
INSERT INTO "players" VALUES ("150", "ESP");
INSERT INTO "players" VALUES ("151", "ESP");
INSERT INTO "players" VALUES ("152", "ESP");
INSERT INTO "players" VALUES ("153", "ESP");
INSERT INTO "players" VALUES ("154", "ESP");
INSERT INTO "players" VALUES ("155", "ESP");
INSERT INTO "players" VALUES ("156", "ESP");
INSERT INTO "players" VALUES ("157", "ESP");
INSERT INTO "players" VALUES ("158", "ESP");
INSERT INTO "players" VALUES ("159", "ESP");
INSERT INTO "players" VALUES ("160", "ESP");
INSERT INTO "players" VALUES ("161", "ESP");
INSERT INTO "players" VALUES ("162", "ESP");
INSERT INTO "players" VALUES ("163", "ESP");
INSERT INTO "players" VALUES ("164", "ESP");
INSERT INTO "players" VALUES ("165", "ESP");
INSERT INTO "players" VALUES ("166", "ESP");
INSERT INTO "players" VALUES ("167", "ESP");
INSERT INTO "players" VALUES ("168", "ESP");
INSERT INTO "players" VALUES ("169", "ESP");
INSERT INTO "players" VALUES ("170", "ESP");
INSERT INTO "players" VALUES ("171", "ESP");
INSERT INTO "players" VALUES ("172", "ESP");
INSERT INTO "players" VALUES ("173", "ESP");
INSERT INTO "players" VALUES ("174", "ESP");
INSERT INTO "players" VALUES ("175", "ESP");
INSERT INTO "players" VALUES ("176", "ESP");
INSERT INTO "players" VALUES ("177", "ESP");
INSERT INTO "players" VALUES ("178", "ESP");
INSERT INTO "players" VALUES ("179", "ESP");
INSERT INTO "players" VALUES ("180", "ESP");
INSERT INTO "players" VALUES ("181", "ESP");
INSERT INTO "players" VALUES ("182", "ESP");
INSERT INTO "players" VALUES ("183", "ESP");
INSERT INTO "players" VALUES ("184", "ESP");
INSERT INTO "players" VALUES ("185", "ESP");
INSERT INTO "players" VALUES ("186", "ESP");
INSERT INTO "players" VALUES ("187", "ESP");
INSERT INTO "players" VALUES ("188", "ESP");
INSERT INTO "players" VALUES ("189", "ESP");
INSERT INTO "players" VALUES ("190", "ESP");
INSERT INTO "players" VALUES ("191", "ITA");
INSERT INTO "players" VALUES ("192", "ITA");
INSERT INTO "players" VALUES ("193", "ITA");
INSERT INTO "players" VALUES ("194", "ITA");
INSERT INTO "players" VALUES ("195", "ITA");
INSERT INTO "players" VALUES ("196", "ITA");
INSERT INTO "players" VALUES ("197", "ITA");
INSERT INTO "players" VALUES ("198", "ITA");
INSERT INTO "players" VALUES ("199", "ITA");
INSERT INTO "players" VALUES ("200", "ITA");
INSERT INTO "players" VALUES ("201", "ITA");
INSERT INTO "players" VALUES ("202", "ITA");
INSERT INTO "players" VALUES ("203", "ITA");
INSERT INTO "players" VALUES ("204", "ITA");
INSERT INTO "players" VALUES ("205", "ITA");
INSERT INTO "players" VALUES ("206", "ITA");
INSERT INTO "players" VALUES ("207", "ITA");
INSERT INTO "players" VALUES ("208", "ITA");
INSERT INTO "players" VALUES ("209", "ITA");
INSERT INTO "players" VALUES ("210", "ITA");
INSERT INTO "players" VALUES ("211", "ITA");
INSERT INTO "players" VALUES ("212", "ITA");
INSERT INTO "players" VALUES ("213", "ITA");
INSERT INTO "players" VALUES ("214", "ITA");
INSERT INTO "players" VALUES ("215", "ITA");
INSERT INTO "players" VALUES ("216", "ITA");
INSERT INTO "players" VALUES ("217", "ITA");
INSERT INTO "players" VALUES ("218", "ITA");
INSERT INTO "players" VALUES ("219", "ITA");
INSERT INTO "players" VALUES ("220", "ITA");
INSERT INTO "players" VALUES ("221", "ITA");
INSERT INTO "players" VALUES ("222", "ITA");
INSERT INTO "players" VALUES ("223", "ITA");
INSERT INTO "players" VALUES ("224", "ITA");
INSERT INTO "players" VALUES ("225", "ITA");
INSERT INTO "players" VALUES ("226", "ITA");
INSERT INTO "players" VALUES ("227", "ITA");
INSERT INTO "players" VALUES ("228", "ITA");
INSERT INTO "players" VALUES ("229", "ITA");
INSERT INTO "players" VALUES ("230", "ITA");
INSERT INTO "players" VALUES ("231", "ITA");
INSERT INTO "players" VALUES ("232", "ITA");
INSERT INTO "players" VALUES ("233", "ITA");
INSERT INTO "players" VALUES ("234", "ITA");
INSERT INTO "players" VALUES ("235", "ITA");
INSERT INTO "players" VALUES ("236", "ITA");
INSERT INTO "players" VALUES ("237", "ITA");
INSERT INTO "players" VALUES ("238", "ITA");
INSERT INTO "players" VALUES ("239", "ITA");
INSERT INTO "players" VALUES ("240", "ITA");
INSERT INTO "matches" VALUES ("1", "USA", "2");
INSERT INTO "matches" VALUES ("3", "USA", "4");
INSERT INTO "matches" VALUES ("5", "USA", "6");
INSERT INTO "matches" VALUES ("7", "USA", "8");
INSERT INTO "matches" VALUES ("9", "USA", "10");
INSERT INTO "matches" VALUES ("11", "USA", "12");
INSERT INTO "matches" VALUES ("13", "USA", "14");
INSERT INTO "matches" VALUES ("15", "USA", "16");
INSERT INTO "matches" VALUES ("17", "USA", "18");
INSERT INTO "matches" VALUES ("19", "USA", "20");
INSERT INTO "matches" VALUES ("21", "USA", "22");
INSERT INTO "matches" VALUES ("23", "USA", "24");
INSERT INTO "matches" VALUES ("25", "USA", "26");
INSERT INTO "matches" VALUES ("27", "USA", "28");
INSERT INTO "matches" VALUES ("29", "USA", "30");
INSERT INTO "matches" VALUES ("31", "USA", "32");
INSERT INTO "matches" VALUES ("33", "USA", "34");
INSERT INTO "matches" VALUES ("35", "USA", "36");
INSERT INTO "matches" VALUES ("37", "USA", "38");
INSERT INTO "matches" VALUES ("39", "USA", "40");
INSERT INTO "matches" VALUES ("41", "USA", "42");
INSERT INTO "matches" VALUES ("43", "USA", "44");
INSERT INTO "matches" VALUES ("45", "USA", "46");
INSERT INTO "matches" VALUES ("47", "USA", "48");
INSERT INTO "matches" VALUES ("49", "USA", "50");
INSERT INTO "matches" VALUES ("51", "USA", "52");
INSERT INTO "matches" VALUES ("53", "USA", "54");
INSERT INTO "matches" VALUES ("55", "USA", "56");
INSERT INTO "matches" VALUES ("57", "USA", "58");
INSERT INTO "matches" VALUES ("59", "USA", "60");
INSERT INTO "matches" VALUES ("61", "FRA", "62");
INSERT INTO "matches" VALUES ("63", "FRA", "64");
INSERT INTO "matches" VALUES ("65", "FRA", "66");
INSERT INTO "matches" VALUES ("67", "FRA", "68");
INSERT INTO "matches" VALUES ("69", "FRA", "70");
INSERT INTO "matches" VALUES ("71", "FRA", "72");
INSERT INTO "matches" VALUES ("73", "FRA", "74");
INSERT INTO "matches" VALUES ("75", "FRA", "76");
INSERT INTO "matches" VALUES ("77", "FRA", "78");
INSERT INTO "matches" VALUES ("79", "FRA", "80");
INSERT INTO "matches" VALUES ("81", "FRA", "82");
INSERT INTO "matches" VALUES ("83", "FRA", "84");
INSERT INTO "matches" VALUES ("85", "FRA", "86");
INSERT INTO "matches" VALUES ("87", "FRA", "88");
INSERT INTO "matches" VALUES ("89", "FRA", "90");
INSERT INTO "matches" VALUES ("91", "FRA", "92");
INSERT INTO "matches" VALUES ("93", "FRA", "94");
INSERT INTO "matches" VALUES ("95", "FRA", "96");
INSERT INTO "matches" VALUES ("97", "FRA", "98");
INSERT INTO "matches" VALUES ("99", "FRA", "100");
INSERT INTO "matches" VALUES ("101", "GER", "102");
INSERT INTO "matches" VALUES ("103", "GER", "104");
INSERT INTO "matches" VALUES ("105", "GER", "106");
INSERT INTO "matches" VALUES ("107", "GER", "108");
INSERT INTO "matches" VALUES ("109", "GER", "110");
INSERT INTO "matches" VALUES ("111", "GER", "112");
INSERT INTO "matches" VALUES ("113", "GER", "114");
INSERT INTO "matches" VALUES ("115", "GER", "116");
INSERT INTO "matches" VALUES ("117", "GER", "118");
INSERT INTO "matches" VALUES ("119", "GER", "120");
INSERT INTO "matches" VALUES ("121", "GER", "122");
INSERT INTO "matches" VALUES ("123", "GER", "124");
INSERT INTO "matches" VALUES ("125", "GER", "126");
INSERT INTO "matches" VALUES ("127", "GER", "128");
INSERT INTO "matches" VALUES ("129", "GER", "130");
INSERT INTO "matches" VALUES ("131", "GER", "132");
INSERT INTO "matches" VALUES ("133", "GER", "134");
INSERT INTO "matches" VALUES ("135", "GER", "136");
INSERT INTO "matches" VALUES ("137", "GER", "138");
INSERT INTO "matches" VALUES ("139", "GER", "140");
INSERT INTO "matches" VALUES ("141", "ESP", "142");
INSERT INTO "matches" VALUES ("143", "ESP", "144");
INSERT INTO "matches" VALUES ("145", "ESP", "146");
INSERT INTO "matches" VALUES ("147", "ESP", "148");
INSERT INTO "matches" VALUES ("149", "ESP", "150");
INSERT INTO "matches" VALUES ("151", "ESP", "152");
INSERT INTO "matches" VALUES ("153", "ESP", "154");
INSERT INTO "matches" VALUES ("155", "ESP", "156");
INSERT INTO "matches" VALUES ("157", "ESP", "158");
INSERT INTO "matches" VALUES ("159", "ESP", "160");
INSERT INTO "matches" VALUES ("161", "ESP", "162");
INSERT INTO "matches" VALUES ("163", "ESP", "164");
INSERT INTO "matches" VALUES ("165", "ESP", "166");
INSERT INTO "matches" VALUES ("167", "ESP", "168");
INSERT INTO "matches" VALUES ("169", "ESP", "170");
INSERT INTO "matches" VALUES ("171", "ESP", "172");
INSERT INTO "matches" VALUES ("173", "ESP", "174");
INSERT INTO "matches" VALUES ("175", "ESP", "176");
INSERT INTO "matches" VALUES ("177", "ESP", "178");
INSERT INTO "matches" VALUES ("179", "ESP", "180");
INSERT INTO "matches" VALUES ("191", "ITA", "192");
INSERT INTO "matches" VALUES ("193", "ITA", "194");
INSERT INTO "matches" VALUES ("195", "ITA", "196");
INSERT INTO "matches" VALUES ("197", "ITA", "198");
INSERT INTO "matches" VALUES ("199", "ITA", "200");
INSERT INTO "matches" VALUES ("201", "ITA", "202");
INSERT INTO "matches" VALUES ("203", "ITA", "204");
INSERT INTO "matches" VALUES ("205", "ITA", "206");
INSERT INTO "matches" VALUES ("207", "ITA", "208");
INSERT INTO "matches" VALUES ("209", "ITA", "210");
INSERT INTO "matches" VALUES ("211", "ITA", "212");
INSERT INTO "matches" VALUES ("213", "ITA", "214");
INSERT INTO "matches" VALUES ("215", "ITA", "216");
INSERT INTO "matches" VALUES ("217", "ITA", "218");
INSERT INTO "matches" VALUES ("219", "ITA", "220");
INSERT INTO "matches" VALUES ("221", "ITA", "222");
INSERT INTO "matches" VALUES ("223", "ITA", "224");
INSERT INTO "matches" VALUES ("225", "ITA", "226");
INSERT INTO "matches" VALUES ("227", "ITA", "228");
INSERT INTO "matches" VALUES ("229", "ITA", "230");
INSERT INTO "matches" VALUES ("231", "ITA", "232");
INSERT INTO "matches" VALUES ("233", "ITA", "234");
INSERT INTO "matches" VALUES ("235", "ITA", "236");
INSERT INTO "matches" VALUES ("237", "ITA", "238");
INSERT INTO "matches" VALUES ("239", "ITA", "240");