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_ioc" TEXT,
"winner_ioc" TEXT
);

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

CREATE TABLE "rankings" (
"player_id" INT,
FOREIGN KEY ("player_id") REFERENCES "players"("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", "CAN");
INSERT INTO "players" VALUES ("53", "CAN");
INSERT INTO "players" VALUES ("54", "CAN");
INSERT INTO "players" VALUES ("55", "CAN");
INSERT INTO "players" VALUES ("56", "CAN");
INSERT INTO "players" VALUES ("57", "CAN");
INSERT INTO "players" VALUES ("58", "CAN");
INSERT INTO "players" VALUES ("59", "CAN");
INSERT INTO "players" VALUES ("60", "CAN");
INSERT INTO "players" VALUES ("61", "CAN");
INSERT INTO "players" VALUES ("62", "CAN");
INSERT INTO "players" VALUES ("63", "CAN");
INSERT INTO "players" VALUES ("64", "CAN");
INSERT INTO "players" VALUES ("65", "CAN");
INSERT INTO "players" VALUES ("66", "CAN");
INSERT INTO "players" VALUES ("67", "CAN");
INSERT INTO "players" VALUES ("68", "CAN");
INSERT INTO "players" VALUES ("69", "CAN");
INSERT INTO "players" VALUES ("70", "CAN");
INSERT INTO "players" VALUES ("71", "CAN");
INSERT INTO "players" VALUES ("72", "CAN");
INSERT INTO "players" VALUES ("73", "CAN");
INSERT INTO "players" VALUES ("74", "CAN");
INSERT INTO "players" VALUES ("75", "CAN");
INSERT INTO "players" VALUES ("76", "CAN");
INSERT INTO "players" VALUES ("77", "CAN");
INSERT INTO "players" VALUES ("78", "CAN");
INSERT INTO "players" VALUES ("79", "CAN");
INSERT INTO "players" VALUES ("80", "CAN");
INSERT INTO "players" VALUES ("81", "CAN");
INSERT INTO "players" VALUES ("82", "CAN");
INSERT INTO "players" VALUES ("83", "CAN");
INSERT INTO "players" VALUES ("84", "CAN");
INSERT INTO "players" VALUES ("85", "CAN");
INSERT INTO "players" VALUES ("86", "CAN");
INSERT INTO "players" VALUES ("87", "CAN");
INSERT INTO "players" VALUES ("88", "CAN");
INSERT INTO "players" VALUES ("89", "CAN");
INSERT INTO "players" VALUES ("90", "CAN");
INSERT INTO "players" VALUES ("91", "CAN");
INSERT INTO "players" VALUES ("92", "CAN");
INSERT INTO "players" VALUES ("93", "CAN");
INSERT INTO "players" VALUES ("94", "CAN");
INSERT INTO "players" VALUES ("95", "CAN");
INSERT INTO "players" VALUES ("96", "CAN");
INSERT INTO "players" VALUES ("97", "CAN");
INSERT INTO "players" VALUES ("98", "CAN");
INSERT INTO "players" VALUES ("99", "CAN");
INSERT INTO "players" VALUES ("100", "CAN");
INSERT INTO "players" VALUES ("101", "CAN");
INSERT INTO "players" VALUES ("102", "GBR");
INSERT INTO "players" VALUES ("103", "GBR");
INSERT INTO "players" VALUES ("104", "GBR");
INSERT INTO "players" VALUES ("105", "GBR");
INSERT INTO "players" VALUES ("106", "GBR");
INSERT INTO "players" VALUES ("107", "GBR");
INSERT INTO "players" VALUES ("108", "GBR");
INSERT INTO "players" VALUES ("109", "GBR");
INSERT INTO "players" VALUES ("110", "GBR");
INSERT INTO "players" VALUES ("111", "GBR");
INSERT INTO "players" VALUES ("112", "GBR");
INSERT INTO "players" VALUES ("113", "GBR");
INSERT INTO "players" VALUES ("114", "GBR");
INSERT INTO "players" VALUES ("115", "GBR");
INSERT INTO "players" VALUES ("116", "GBR");
INSERT INTO "players" VALUES ("117", "GBR");
INSERT INTO "players" VALUES ("118", "GBR");
INSERT INTO "players" VALUES ("119", "GBR");
INSERT INTO "players" VALUES ("120", "GBR");
INSERT INTO "players" VALUES ("121", "GBR");
INSERT INTO "players" VALUES ("122", "GBR");
INSERT INTO "players" VALUES ("123", "GBR");
INSERT INTO "players" VALUES ("124", "GBR");
INSERT INTO "players" VALUES ("125", "GBR");
INSERT INTO "players" VALUES ("126", "GBR");
INSERT INTO "players" VALUES ("127", "GBR");
INSERT INTO "players" VALUES ("128", "GBR");
INSERT INTO "players" VALUES ("129", "GBR");
INSERT INTO "players" VALUES ("130", "GBR");
INSERT INTO "players" VALUES ("131", "GBR");
INSERT INTO "players" VALUES ("132", "GBR");
INSERT INTO "players" VALUES ("133", "GBR");
INSERT INTO "players" VALUES ("134", "GBR");
INSERT INTO "players" VALUES ("135", "GBR");
INSERT INTO "players" VALUES ("136", "GBR");
INSERT INTO "players" VALUES ("137", "GBR");
INSERT INTO "players" VALUES ("138", "GBR");
INSERT INTO "players" VALUES ("139", "GBR");
INSERT INTO "players" VALUES ("140", "GBR");
INSERT INTO "players" VALUES ("141", "GBR");
INSERT INTO "players" VALUES ("142", "GBR");
INSERT INTO "players" VALUES ("143", "GBR");
INSERT INTO "players" VALUES ("144", "GBR");
INSERT INTO "players" VALUES ("145", "GBR");
INSERT INTO "players" VALUES ("146", "GBR");
INSERT INTO "players" VALUES ("147", "GBR");
INSERT INTO "players" VALUES ("148", "GBR");
INSERT INTO "players" VALUES ("149", "GBR");
INSERT INTO "players" VALUES ("150", "GBR");
INSERT INTO "players" VALUES ("151", "GBR");
INSERT INTO "players" VALUES ("152", "AUS");
INSERT INTO "players" VALUES ("153", "AUS");
INSERT INTO "players" VALUES ("154", "AUS");
INSERT INTO "players" VALUES ("155", "AUS");
INSERT INTO "players" VALUES ("156", "AUS");
INSERT INTO "players" VALUES ("157", "AUS");
INSERT INTO "players" VALUES ("158", "AUS");
INSERT INTO "players" VALUES ("159", "AUS");
INSERT INTO "players" VALUES ("160", "AUS");
INSERT INTO "players" VALUES ("161", "AUS");
INSERT INTO "players" VALUES ("162", "AUS");
INSERT INTO "players" VALUES ("163", "AUS");
INSERT INTO "players" VALUES ("164", "AUS");
INSERT INTO "players" VALUES ("165", "AUS");
INSERT INTO "players" VALUES ("166", "AUS");
INSERT INTO "players" VALUES ("167", "AUS");
INSERT INTO "players" VALUES ("168", "AUS");
INSERT INTO "players" VALUES ("169", "AUS");
INSERT INTO "players" VALUES ("170", "AUS");
INSERT INTO "players" VALUES ("171", "AUS");
INSERT INTO "players" VALUES ("172", "AUS");
INSERT INTO "players" VALUES ("173", "AUS");
INSERT INTO "players" VALUES ("174", "AUS");
INSERT INTO "players" VALUES ("175", "AUS");
INSERT INTO "players" VALUES ("176", "AUS");
INSERT INTO "players" VALUES ("177", "AUS");
INSERT INTO "players" VALUES ("178", "AUS");
INSERT INTO "players" VALUES ("179", "AUS");
INSERT INTO "players" VALUES ("180", "AUS");
INSERT INTO "players" VALUES ("181", "AUS");
INSERT INTO "players" VALUES ("182", "AUS");
INSERT INTO "players" VALUES ("183", "AUS");
INSERT INTO "players" VALUES ("184", "AUS");
INSERT INTO "players" VALUES ("185", "AUS");
INSERT INTO "players" VALUES ("186", "AUS");
INSERT INTO "players" VALUES ("187", "AUS");
INSERT INTO "players" VALUES ("188", "AUS");
INSERT INTO "players" VALUES ("189", "AUS");
INSERT INTO "players" VALUES ("190", "AUS");
INSERT INTO "players" VALUES ("191", "AUS");
INSERT INTO "players" VALUES ("192", "AUS");
INSERT INTO "players" VALUES ("193", "AUS");
INSERT INTO "players" VALUES ("194", "AUS");
INSERT INTO "players" VALUES ("195", "AUS");
INSERT INTO "players" VALUES ("196", "AUS");
INSERT INTO "players" VALUES ("197", "AUS");
INSERT INTO "players" VALUES ("198", "AUS");
INSERT INTO "players" VALUES ("199", "AUS");
INSERT INTO "players" VALUES ("200", "AUS");
INSERT INTO "players" VALUES ("201", "AUS");
INSERT INTO "players" VALUES ("202", "FRA");
INSERT INTO "players" VALUES ("203", "FRA");
INSERT INTO "players" VALUES ("204", "FRA");
INSERT INTO "players" VALUES ("205", "FRA");
INSERT INTO "players" VALUES ("206", "FRA");
INSERT INTO "players" VALUES ("207", "FRA");
INSERT INTO "players" VALUES ("208", "FRA");
INSERT INTO "players" VALUES ("209", "FRA");
INSERT INTO "players" VALUES ("210", "FRA");
INSERT INTO "players" VALUES ("211", "FRA");
INSERT INTO "players" VALUES ("212", "FRA");
INSERT INTO "players" VALUES ("213", "FRA");
INSERT INTO "players" VALUES ("214", "FRA");
INSERT INTO "players" VALUES ("215", "FRA");
INSERT INTO "players" VALUES ("216", "FRA");
INSERT INTO "players" VALUES ("217", "FRA");
INSERT INTO "players" VALUES ("218", "FRA");
INSERT INTO "players" VALUES ("219", "FRA");
INSERT INTO "players" VALUES ("220", "FRA");
INSERT INTO "players" VALUES ("221", "FRA");
INSERT INTO "players" VALUES ("222", "FRA");
INSERT INTO "players" VALUES ("223", "FRA");
INSERT INTO "players" VALUES ("224", "FRA");
INSERT INTO "players" VALUES ("225", "FRA");
INSERT INTO "players" VALUES ("226", "FRA");
INSERT INTO "players" VALUES ("227", "FRA");
INSERT INTO "players" VALUES ("228", "FRA");
INSERT INTO "players" VALUES ("229", "FRA");
INSERT INTO "players" VALUES ("230", "FRA");
INSERT INTO "players" VALUES ("231", "FRA");
INSERT INTO "players" VALUES ("232", "FRA");
INSERT INTO "players" VALUES ("233", "FRA");
INSERT INTO "players" VALUES ("234", "FRA");
INSERT INTO "players" VALUES ("235", "FRA");
INSERT INTO "players" VALUES ("236", "FRA");
INSERT INTO "players" VALUES ("237", "FRA");
INSERT INTO "players" VALUES ("238", "FRA");
INSERT INTO "players" VALUES ("239", "FRA");
INSERT INTO "players" VALUES ("240", "FRA");
INSERT INTO "players" VALUES ("241", "FRA");
INSERT INTO "players" VALUES ("242", "FRA");
INSERT INTO "players" VALUES ("243", "FRA");
INSERT INTO "players" VALUES ("244", "FRA");
INSERT INTO "players" VALUES ("245", "FRA");
INSERT INTO "players" VALUES ("246", "FRA");
INSERT INTO "players" VALUES ("247", "FRA");
INSERT INTO "players" VALUES ("248", "FRA");
INSERT INTO "players" VALUES ("249", "FRA");
INSERT INTO "players" VALUES ("250", "FRA");
INSERT INTO "players" VALUES ("251", "FRA");
INSERT INTO "players" VALUES ("252", "GER");
INSERT INTO "players" VALUES ("253", "GER");
INSERT INTO "players" VALUES ("254", "GER");
INSERT INTO "players" VALUES ("255", "GER");
INSERT INTO "players" VALUES ("256", "GER");
INSERT INTO "players" VALUES ("257", "GER");
INSERT INTO "players" VALUES ("258", "GER");
INSERT INTO "players" VALUES ("259", "GER");
INSERT INTO "players" VALUES ("260", "GER");
INSERT INTO "players" VALUES ("261", "GER");
INSERT INTO "players" VALUES ("262", "GER");
INSERT INTO "players" VALUES ("263", "GER");
INSERT INTO "players" VALUES ("264", "GER");
INSERT INTO "players" VALUES ("265", "GER");
INSERT INTO "players" VALUES ("266", "GER");
INSERT INTO "players" VALUES ("267", "GER");
INSERT INTO "players" VALUES ("268", "GER");
INSERT INTO "players" VALUES ("269", "GER");
INSERT INTO "players" VALUES ("270", "GER");
INSERT INTO "players" VALUES ("271", "GER");
INSERT INTO "players" VALUES ("272", "GER");
INSERT INTO "players" VALUES ("273", "GER");
INSERT INTO "players" VALUES ("274", "GER");
INSERT INTO "players" VALUES ("275", "GER");
INSERT INTO "players" VALUES ("276", "GER");
INSERT INTO "players" VALUES ("277", "GER");
INSERT INTO "players" VALUES ("278", "GER");
INSERT INTO "players" VALUES ("279", "GER");
INSERT INTO "players" VALUES ("280", "GER");
INSERT INTO "players" VALUES ("281", "GER");
INSERT INTO "players" VALUES ("282", "GER");
INSERT INTO "players" VALUES ("283", "GER");
INSERT INTO "players" VALUES ("284", "GER");
INSERT INTO "players" VALUES ("285", "GER");
INSERT INTO "players" VALUES ("286", "GER");
INSERT INTO "players" VALUES ("287", "GER");
INSERT INTO "players" VALUES ("288", "GER");
INSERT INTO "players" VALUES ("289", "GER");
INSERT INTO "players" VALUES ("290", "GER");
INSERT INTO "players" VALUES ("291", "GER");
INSERT INTO "players" VALUES ("292", "GER");
INSERT INTO "players" VALUES ("293", "GER");
INSERT INTO "players" VALUES ("294", "GER");
INSERT INTO "players" VALUES ("295", "GER");
INSERT INTO "players" VALUES ("296", "GER");
INSERT INTO "players" VALUES ("297", "GER");
INSERT INTO "players" VALUES ("298", "GER");
INSERT INTO "players" VALUES ("299", "GER");
INSERT INTO "players" VALUES ("300", "GER");
INSERT INTO "players" VALUES ("301", "GER");
INSERT INTO "players" VALUES ("302", "CHN");
INSERT INTO "players" VALUES ("303", "CHN");
INSERT INTO "players" VALUES ("304", "CHN");
INSERT INTO "players" VALUES ("305", "CHN");
INSERT INTO "players" VALUES ("306", "CHN");
INSERT INTO "players" VALUES ("307", "CHN");
INSERT INTO "players" VALUES ("308", "CHN");
INSERT INTO "players" VALUES ("309", "CHN");
INSERT INTO "players" VALUES ("310", "CHN");
INSERT INTO "players" VALUES ("311", "CHN");
INSERT INTO "players" VALUES ("312", "CHN");
INSERT INTO "players" VALUES ("313", "CHN");
INSERT INTO "players" VALUES ("314", "CHN");
INSERT INTO "players" VALUES ("315", "CHN");
INSERT INTO "players" VALUES ("316", "CHN");
INSERT INTO "players" VALUES ("317", "CHN");
INSERT INTO "players" VALUES ("318", "CHN");
INSERT INTO "players" VALUES ("319", "CHN");
INSERT INTO "players" VALUES ("320", "CHN");
INSERT INTO "players" VALUES ("321", "CHN");
INSERT INTO "players" VALUES ("322", "CHN");
INSERT INTO "players" VALUES ("323", "CHN");
INSERT INTO "players" VALUES ("324", "CHN");
INSERT INTO "players" VALUES ("325", "CHN");
INSERT INTO "players" VALUES ("326", "CHN");
INSERT INTO "players" VALUES ("327", "CHN");
INSERT INTO "players" VALUES ("328", "CHN");
INSERT INTO "players" VALUES ("329", "CHN");
INSERT INTO "players" VALUES ("330", "CHN");
INSERT INTO "players" VALUES ("331", "CHN");
INSERT INTO "players" VALUES ("332", "CHN");
INSERT INTO "players" VALUES ("333", "CHN");
INSERT INTO "players" VALUES ("334", "CHN");
INSERT INTO "players" VALUES ("335", "CHN");
INSERT INTO "players" VALUES ("336", "CHN");
INSERT INTO "players" VALUES ("337", "CHN");
INSERT INTO "players" VALUES ("338", "CHN");
INSERT INTO "players" VALUES ("339", "CHN");
INSERT INTO "players" VALUES ("340", "CHN");
INSERT INTO "players" VALUES ("341", "CHN");
INSERT INTO "players" VALUES ("342", "CHN");
INSERT INTO "players" VALUES ("343", "CHN");
INSERT INTO "players" VALUES ("344", "CHN");
INSERT INTO "players" VALUES ("345", "CHN");
INSERT INTO "players" VALUES ("346", "CHN");
INSERT INTO "players" VALUES ("347", "CHN");
INSERT INTO "players" VALUES ("348", "CHN");
INSERT INTO "players" VALUES ("349", "CHN");
INSERT INTO "players" VALUES ("350", "CHN");
INSERT INTO "players" VALUES ("351", "CHN");
INSERT INTO "players" VALUES ("352", "JPN");
INSERT INTO "players" VALUES ("353", "JPN");
INSERT INTO "players" VALUES ("354", "JPN");
INSERT INTO "players" VALUES ("355", "JPN");
INSERT INTO "players" VALUES ("356", "JPN");
INSERT INTO "players" VALUES ("357", "JPN");
INSERT INTO "players" VALUES ("358", "JPN");
INSERT INTO "players" VALUES ("359", "JPN");
INSERT INTO "players" VALUES ("360", "JPN");
INSERT INTO "players" VALUES ("361", "JPN");
INSERT INTO "players" VALUES ("362", "JPN");
INSERT INTO "players" VALUES ("363", "JPN");
INSERT INTO "players" VALUES ("364", "JPN");
INSERT INTO "players" VALUES ("365", "JPN");
INSERT INTO "players" VALUES ("366", "JPN");
INSERT INTO "players" VALUES ("367", "JPN");
INSERT INTO "players" VALUES ("368", "JPN");
INSERT INTO "players" VALUES ("369", "JPN");
INSERT INTO "players" VALUES ("370", "JPN");
INSERT INTO "players" VALUES ("371", "JPN");
INSERT INTO "players" VALUES ("372", "JPN");
INSERT INTO "players" VALUES ("373", "JPN");
INSERT INTO "players" VALUES ("374", "JPN");
INSERT INTO "players" VALUES ("375", "JPN");
INSERT INTO "players" VALUES ("376", "JPN");
INSERT INTO "players" VALUES ("377", "JPN");
INSERT INTO "players" VALUES ("378", "JPN");
INSERT INTO "players" VALUES ("379", "JPN");
INSERT INTO "players" VALUES ("380", "JPN");
INSERT INTO "players" VALUES ("381", "JPN");
INSERT INTO "players" VALUES ("382", "JPN");
INSERT INTO "players" VALUES ("383", "JPN");
INSERT INTO "players" VALUES ("384", "JPN");
INSERT INTO "players" VALUES ("385", "JPN");
INSERT INTO "players" VALUES ("386", "JPN");
INSERT INTO "players" VALUES ("387", "JPN");
INSERT INTO "players" VALUES ("388", "JPN");
INSERT INTO "players" VALUES ("389", "JPN");
INSERT INTO "players" VALUES ("390", "JPN");
INSERT INTO "players" VALUES ("391", "JPN");
INSERT INTO "players" VALUES ("392", "JPN");
INSERT INTO "players" VALUES ("393", "JPN");
INSERT INTO "players" VALUES ("394", "JPN");
INSERT INTO "players" VALUES ("395", "JPN");
INSERT INTO "players" VALUES ("396", "JPN");
INSERT INTO "players" VALUES ("397", "JPN");
INSERT INTO "players" VALUES ("398", "JPN");
INSERT INTO "players" VALUES ("399", "JPN");
INSERT INTO "players" VALUES ("400", "JPN");
INSERT INTO "players" VALUES ("401", "JPN");
INSERT INTO "players" VALUES ("402", "RUS");
INSERT INTO "players" VALUES ("403", "RUS");