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