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 "Player" (
"id" INT,
"player_api_id" INT UNIQUE,
"height" INT,
"weight" INT,
PRIMARY KEY ("id")
);

CREATE TABLE "Player_Attributes" (
"id" INT,
"overall_rating" INT,
"potential" INT,
PRIMARY KEY ("id")
);



INSERT INTO "Player" VALUES ("1", "100001", "180", "75");
INSERT INTO "Player" VALUES ("2", "100002", "185", "80");
INSERT INTO "Player" VALUES ("3", "100003", "190", "85");
INSERT INTO "Player" VALUES ("4", "100004", "175", "70");
INSERT INTO "Player" VALUES ("5", "100005", "192", "90");
INSERT INTO "Player" VALUES ("6", "100006", "188", "88");
INSERT INTO "Player" VALUES ("7", "100007", "170", "65");
INSERT INTO "Player" VALUES ("8", "100008", "195", "95");
INSERT INTO "Player" VALUES ("9", "100009", "183", "78");
INSERT INTO "Player" VALUES ("10", "100010", "178", "72");
INSERT INTO "Player" VALUES ("11", "100011", "191", "89");
INSERT INTO "Player" VALUES ("12", "100012", "186", "82");
INSERT INTO "Player" VALUES ("13", "100013", "193", "91");
INSERT INTO "Player" VALUES ("14", "100014", "187", "86");
INSERT INTO "Player" VALUES ("15", "100015", "194", "93");
INSERT INTO "Player_Attributes" VALUES ("1", "80", "85");
INSERT INTO "Player_Attributes" VALUES ("2", "82", "87");
INSERT INTO "Player_Attributes" VALUES ("3", "85", "90");
INSERT INTO "Player_Attributes" VALUES ("4", "78", "82");
INSERT INTO "Player_Attributes" VALUES ("5", "88", "92");
INSERT INTO "Player_Attributes" VALUES ("6", "86", "91");
INSERT INTO "Player_Attributes" VALUES ("7", "75", "80");
INSERT INTO "Player_Attributes" VALUES ("8", "90", "95");
INSERT INTO "Player_Attributes" VALUES ("9", "81", "86");
INSERT INTO "Player_Attributes" VALUES ("10", "79", "84");
INSERT INTO "Player_Attributes" VALUES ("11", "87", "92");
INSERT INTO "Player_Attributes" VALUES ("12", "83", "88");
INSERT INTO "Player_Attributes" VALUES ("13", "89", "94");
INSERT INTO "Player_Attributes" VALUES ("14", "84", "89");
INSERT INTO "Player_Attributes" VALUES ("15", "91", "96");