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 "Friend" (
"student_id" INT,
"friend_id" INT,
PRIMARY KEY ("student_id", "friend_id"),
FOREIGN KEY ("student_id") REFERENCES "Highschooler"("ID"),
FOREIGN KEY ("friend_id") REFERENCES "Highschooler"("ID")
);

CREATE TABLE "Highschooler" (
"ID" INT UNIQUE,
PRIMARY KEY ("ID")
);

CREATE TABLE "Likes" (
"student_id" INT,
"liked_id" INT,
PRIMARY KEY ("student_id", "liked_id"),
FOREIGN KEY ("student_id") REFERENCES "Highschooler"("ID")
);





INSERT INTO "Highschooler" VALUES ("1001");
INSERT INTO "Highschooler" VALUES ("1002");
INSERT INTO "Highschooler" VALUES ("1003");
INSERT INTO "Highschooler" VALUES ("1004");
INSERT INTO "Highschooler" VALUES ("1005");
INSERT INTO "Highschooler" VALUES ("1006");
INSERT INTO "Highschooler" VALUES ("1007");
INSERT INTO "Highschooler" VALUES ("1008");
INSERT INTO "Highschooler" VALUES ("1009");
INSERT INTO "Highschooler" VALUES ("1010");
INSERT INTO "Highschooler" VALUES ("1011");
INSERT INTO "Highschooler" VALUES ("1012");
INSERT INTO "Highschooler" VALUES ("1013");
INSERT INTO "Highschooler" VALUES ("1014");
INSERT INTO "Highschooler" VALUES ("1015");
INSERT INTO "Highschooler" VALUES ("1016");
INSERT INTO "Highschooler" VALUES ("1017");
INSERT INTO "Highschooler" VALUES ("1018");
INSERT INTO "Highschooler" VALUES ("1019");
INSERT INTO "Highschooler" VALUES ("1020");
INSERT INTO "Highschooler" VALUES ("1021");
INSERT INTO "Highschooler" VALUES ("1022");
INSERT INTO "Highschooler" VALUES ("1023");
INSERT INTO "Highschooler" VALUES ("1024");
INSERT INTO "Highschooler" VALUES ("1025");
INSERT INTO "Highschooler" VALUES ("1026");
INSERT INTO "Highschooler" VALUES ("1027");
INSERT INTO "Highschooler" VALUES ("1028");
INSERT INTO "Highschooler" VALUES ("1029");
INSERT INTO "Highschooler" VALUES ("1030");
INSERT INTO "Highschooler" VALUES ("1031");
INSERT INTO "Highschooler" VALUES ("1032");
INSERT INTO "Highschooler" VALUES ("1033");
INSERT INTO "Highschooler" VALUES ("1034");
INSERT INTO "Highschooler" VALUES ("1035");
INSERT INTO "Highschooler" VALUES ("1036");
INSERT INTO "Highschooler" VALUES ("1037");
INSERT INTO "Highschooler" VALUES ("1038");
INSERT INTO "Highschooler" VALUES ("1039");
INSERT INTO "Highschooler" VALUES ("1040");
INSERT INTO "Highschooler" VALUES ("1041");
INSERT INTO "Highschooler" VALUES ("1042");
INSERT INTO "Highschooler" VALUES ("1043");
INSERT INTO "Highschooler" VALUES ("1044");
INSERT INTO "Highschooler" VALUES ("1045");
INSERT INTO "Highschooler" VALUES ("1046");
INSERT INTO "Highschooler" VALUES ("1047");
INSERT INTO "Highschooler" VALUES ("1048");
INSERT INTO "Highschooler" VALUES ("1049");
INSERT INTO "Highschooler" VALUES ("1050");
INSERT INTO "Highschooler" VALUES ("1051");
INSERT INTO "Highschooler" VALUES ("1052");
INSERT INTO "Highschooler" VALUES ("1053");
INSERT INTO "Highschooler" VALUES ("1054");
INSERT INTO "Highschooler" VALUES ("1055");
INSERT INTO "Highschooler" VALUES ("1056");
INSERT INTO "Highschooler" VALUES ("1057");
INSERT INTO "Highschooler" VALUES ("1058");
INSERT INTO "Highschooler" VALUES ("1059");
INSERT INTO "Highschooler" VALUES ("1060");
INSERT INTO "Highschooler" VALUES ("1061");
INSERT INTO "Highschooler" VALUES ("1062");
INSERT INTO "Highschooler" VALUES ("1063");
INSERT INTO "Highschooler" VALUES ("1064");
INSERT INTO "Highschooler" VALUES ("1065");
INSERT INTO "Highschooler" VALUES ("1066");
INSERT INTO "Highschooler" VALUES ("1067");
INSERT INTO "Highschooler" VALUES ("1068");
INSERT INTO "Highschooler" VALUES ("1069");
INSERT INTO "Highschooler" VALUES ("1070");
INSERT INTO "Highschooler" VALUES ("1071");
INSERT INTO "Highschooler" VALUES ("1072");
INSERT INTO "Highschooler" VALUES ("1073");
INSERT INTO "Highschooler" VALUES ("1074");
INSERT INTO "Highschooler" VALUES ("1075");
INSERT INTO "Highschooler" VALUES ("1076");
INSERT INTO "Highschooler" VALUES ("1077");
INSERT INTO "Highschooler" VALUES ("1078");
INSERT INTO "Highschooler" VALUES ("1079");
INSERT INTO "Highschooler" VALUES ("1080");
INSERT INTO "Highschooler" VALUES ("1081");
INSERT INTO "Highschooler" VALUES ("1082");
INSERT INTO "Highschooler" VALUES ("1083");
INSERT INTO "Highschooler" VALUES ("1084");
INSERT INTO "Highschooler" VALUES ("1085");
INSERT INTO "Highschooler" VALUES ("1086");
INSERT INTO "Highschooler" VALUES ("1087");
INSERT INTO "Highschooler" VALUES ("1088");
INSERT INTO "Highschooler" VALUES ("1089");
INSERT INTO "Highschooler" VALUES ("1090");
INSERT INTO "Highschooler" VALUES ("1091");
INSERT INTO "Highschooler" VALUES ("1092");
INSERT INTO "Highschooler" VALUES ("1093");
INSERT INTO "Highschooler" VALUES ("1094");
INSERT INTO "Highschooler" VALUES ("1095");
INSERT INTO "Highschooler" VALUES ("1096");
INSERT INTO "Highschooler" VALUES ("1097");
INSERT INTO "Highschooler" VALUES ("1098");
INSERT INTO "Highschooler" VALUES ("1099");
INSERT INTO "Highschooler" VALUES ("1100");
INSERT INTO "Highschooler" VALUES ("1101");
INSERT INTO "Highschooler" VALUES ("1102");
INSERT INTO "Highschooler" VALUES ("1103");
INSERT INTO "Highschooler" VALUES ("1104");
INSERT INTO "Highschooler" VALUES ("1105");
INSERT INTO "Highschooler" VALUES ("1106");
INSERT INTO "Highschooler" VALUES ("1107");
INSERT INTO "Highschooler" VALUES ("1108");
INSERT INTO "Highschooler" VALUES ("1109");
INSERT INTO "Highschooler" VALUES ("1110");
INSERT INTO "Highschooler" VALUES ("1111");
INSERT INTO "Highschooler" VALUES ("1112");
INSERT INTO "Highschooler" VALUES ("1113");
INSERT INTO "Highschooler" VALUES ("1114");
INSERT INTO "Highschooler" VALUES ("1115");
INSERT INTO "Highschooler" VALUES ("1116");
INSERT INTO "Highschooler" VALUES ("1117");
INSERT INTO "Highschooler" VALUES ("1118");
INSERT INTO "Highschooler" VALUES ("1119");
INSERT INTO "Highschooler" VALUES ("1120");
INSERT INTO "Highschooler" VALUES ("1121");
INSERT INTO "Highschooler" VALUES ("1122");
INSERT INTO "Highschooler" VALUES ("1123");
INSERT INTO "Highschooler" VALUES ("1124");
INSERT INTO "Highschooler" VALUES ("1125");
INSERT INTO "Highschooler" VALUES ("1126");
INSERT INTO "Highschooler" VALUES ("1127");
INSERT INTO "Highschooler" VALUES ("1128");
INSERT INTO "Highschooler" VALUES ("1129");
INSERT INTO "Highschooler" VALUES ("1130");
INSERT INTO "Highschooler" VALUES ("1131");
INSERT INTO "Highschooler" VALUES ("1132");
INSERT INTO "Highschooler" VALUES ("1133");
INSERT INTO "Highschooler" VALUES ("1134");
INSERT INTO "Highschooler" VALUES ("1135");
INSERT INTO "Highschooler" VALUES ("1136");
INSERT INTO "Highschooler" VALUES ("1137");
INSERT INTO "Highschooler" VALUES ("1138");
INSERT INTO "Highschooler" VALUES ("1139");
INSERT INTO "Highschooler" VALUES ("1140");
INSERT INTO "Highschooler" VALUES ("1141");
INSERT INTO "Highschooler" VALUES ("1142");
INSERT INTO "Highschooler" VALUES ("1143");
INSERT INTO "Highschooler" VALUES ("1144");
INSERT INTO "Highschooler" VALUES ("1145");
INSERT INTO "Highschooler" VALUES ("1146");
INSERT INTO "Highschooler" VALUES ("1147");
INSERT INTO "Highschooler" VALUES ("1148");
INSERT INTO "Highschooler" VALUES ("1149");
INSERT INTO "Highschooler" VALUES ("1150");
INSERT INTO "Highschooler" VALUES ("1151");
INSERT INTO "Highschooler" VALUES ("1152");
INSERT INTO "Highschooler" VALUES ("1153");
INSERT INTO "Highschooler" VALUES ("1154");
INSERT INTO "Highschooler" VALUES ("1155");
INSERT INTO "Highschooler" VALUES ("1156");
INSERT INTO "Highschooler" VALUES ("1157");
INSERT INTO "Highschooler" VALUES ("1158");
INSERT INTO "Highschooler" VALUES ("1159");
INSERT INTO "Highschooler" VALUES ("1160");
INSERT INTO "Highschooler" VALUES ("1161");
INSERT INTO "Highschooler" VALUES ("1162");
INSERT INTO "Highschooler" VALUES ("1163");
INSERT INTO "Highschooler" VALUES ("1164");
INSERT INTO "Highschooler" VALUES ("1165");
INSERT INTO "Highschooler" VALUES ("1166");
INSERT INTO "Highschooler" VALUES ("1167");
INSERT INTO "Highschooler" VALUES ("1168");
INSERT INTO "Highschooler" VALUES ("1169");
INSERT INTO "Highschooler" VALUES ("1170");
INSERT INTO "Highschooler" VALUES ("1171");
INSERT INTO "Highschooler" VALUES ("1172");
INSERT INTO "Highschooler" VALUES ("1173");
INSERT INTO "Highschooler" VALUES ("1174");
INSERT INTO "Highschooler" VALUES ("1175");
INSERT INTO "Highschooler" VALUES ("1176");
INSERT INTO "Highschooler" VALUES ("1177");
INSERT INTO "Highschooler" VALUES ("1178");
INSERT INTO "Highschooler" VALUES ("1179");
INSERT INTO "Highschooler" VALUES ("1180");
INSERT INTO "Highschooler" VALUES ("1181");
INSERT INTO "Highschooler" VALUES ("1182");
INSERT INTO "Highschooler" VALUES ("1183");
INSERT INTO "Highschooler" VALUES ("1184");
INSERT INTO "Highschooler" VALUES ("1185");
INSERT INTO "Highschooler" VALUES ("1186");
INSERT INTO "Highschooler" VALUES ("1187");
INSERT INTO "Highschooler" VALUES ("1188");
INSERT INTO "Highschooler" VALUES ("1189");
INSERT INTO "Highschooler" VALUES ("1190");
INSERT INTO "Highschooler" VALUES ("1191");
INSERT INTO "Highschooler" VALUES ("1192");
INSERT INTO "Highschooler" VALUES ("1193");
INSERT INTO "Highschooler" VALUES ("1194");
INSERT INTO "Highschooler" VALUES ("1195");
INSERT INTO "Highschooler" VALUES ("1196");
INSERT INTO "Highschooler" VALUES ("1197");
INSERT INTO "Highschooler" VALUES ("1198");
INSERT INTO "Highschooler" VALUES ("1199");
INSERT INTO "Highschooler" VALUES ("1200");
INSERT INTO "Highschooler" VALUES ("1201");
INSERT INTO "Highschooler" VALUES ("1202");
INSERT INTO "Highschooler" VALUES ("1203");
INSERT INTO "Highschooler" VALUES ("1204");
INSERT INTO "Highschooler" VALUES ("1205");
INSERT INTO "Highschooler" VALUES ("1206");
INSERT INTO "Highschooler" VALUES ("1207");
INSERT INTO "Highschooler" VALUES ("1208");
INSERT INTO "Highschooler" VALUES ("1209");
INSERT INTO "Highschooler" VALUES ("1210");
INSERT INTO "Highschooler" VALUES ("1211");
INSERT INTO "Highschooler" VALUES ("1212");
INSERT INTO "Highschooler" VALUES ("1213");
INSERT INTO "Highschooler" VALUES ("1214");
INSERT INTO "Highschooler" VALUES ("1215");
INSERT INTO "Highschooler" VALUES ("1216");
INSERT INTO "Highschooler" VALUES ("1217");
INSERT INTO "Highschooler" VALUES ("1218");
INSERT INTO "Highschooler" VALUES ("1219");
INSERT INTO "Highschooler" VALUES ("1220");
INSERT INTO "Highschooler" VALUES ("1221");
INSERT INTO "Highschooler" VALUES ("1222");
INSERT INTO "Highschooler" VALUES ("1223");
INSERT INTO "Highschooler" VALUES ("1224");
INSERT INTO "Highschooler" VALUES ("1225");
INSERT INTO "Highschooler" VALUES ("1226");
INSERT INTO "Highschooler" VALUES ("1227");
INSERT INTO "Highschooler" VALUES ("1228");
INSERT INTO "Highschooler" VALUES ("1229");
INSERT INTO "Highschooler" VALUES ("1230");
INSERT INTO "Highschooler" VALUES ("1231");
INSERT INTO "Highschooler" VALUES ("1232");
INSERT INTO "Highschooler" VALUES ("1233");
INSERT INTO "Highschooler" VALUES ("1234");
INSERT INTO "Highschooler" VALUES ("1235");
INSERT INTO "Highschooler" VALUES ("1236");
INSERT INTO "Highschooler" VALUES ("1237");
INSERT INTO "Highschooler" VALUES ("1238");
INSERT INTO "Highschooler" VALUES ("1239");
INSERT INTO "Highschooler" VALUES ("1240");
INSERT INTO "Highschooler" VALUES ("1241");
INSERT INTO "Highschooler" VALUES ("1242");
INSERT INTO "Highschooler" VALUES ("1243");
INSERT INTO "Highschooler" VALUES ("1244");
INSERT INTO "Highschooler" VALUES ("1245");
INSERT INTO "Highschooler" VALUES ("1246");
INSERT INTO "Highschooler" VALUES ("1247");
INSERT INTO "Highschooler" VALUES ("1248");
INSERT INTO "Highschooler" VALUES ("1249");
INSERT INTO "Highschooler" VALUES ("1250");
INSERT INTO "Highschooler" VALUES ("1251");
INSERT INTO "Highschooler" VALUES ("1252");
INSERT INTO "Highschooler" VALUES ("1253");
INSERT INTO "Highschooler" VALUES ("1254");
INSERT INTO "Highschooler" VALUES ("1255");
INSERT INTO "Highschooler" VALUES ("1256");
INSERT INTO "Highschooler" VALUES ("1257");
INSERT INTO "Highschooler" VALUES ("1258");
INSERT INTO "Highschooler" VALUES ("1259");
INSERT INTO "Highschooler" VALUES ("1260");
INSERT INTO "Highschooler" VALUES ("1261");
INSERT INTO "Highschooler" VALUES ("1262");
INSERT INTO "Highschooler" VALUES ("1263");
INSERT INTO "Highschooler" VALUES ("1264");
INSERT INTO "Highschooler" VALUES ("1265");
INSERT INTO "Highschooler" VALUES ("1266");
INSERT INTO "Highschooler" VALUES ("1267");
INSERT INTO "Highschooler" VALUES ("1268");
INSERT INTO "Highschooler" VALUES ("1269");
INSERT INTO "Highschooler" VALUES ("1270");
INSERT INTO "Highschooler" VALUES ("1271");
INSERT INTO "Highschooler" VALUES ("1272");
INSERT INTO "Highschooler" VALUES ("1273");
INSERT INTO "Highschooler" VALUES ("1274");
INSERT INTO "Highschooler" VALUES ("1275");
INSERT INTO "Highschooler" VALUES ("1276");
INSERT INTO "Highschooler" VALUES ("1277");
INSERT INTO "Highschooler" VALUES ("1278");
INSERT INTO "Highschooler" VALUES ("1279");
INSERT INTO "Highschooler" VALUES ("1280");
INSERT INTO "Highschooler" VALUES ("1281");
INSERT INTO "Highschooler" VALUES ("1282");
INSERT INTO "Highschooler" VALUES ("1283");
INSERT INTO "Highschooler" VALUES ("1284");
INSERT INTO "Highschooler" VALUES ("1285");
INSERT INTO "Highschooler" VALUES ("1286");
INSERT INTO "Highschooler" VALUES ("1287");
INSERT INTO "Highschooler" VALUES ("1288");
INSERT INTO "Highschooler" VALUES ("1289");
INSERT INTO "Highschooler" VALUES ("1290");
INSERT INTO "Highschooler" VALUES ("1291");
INSERT INTO "Highschooler" VALUES ("1292");
INSERT INTO "Highschooler" VALUES ("1293");
INSERT INTO "Highschooler" VALUES ("1294");
INSERT INTO "Highschooler" VALUES ("1295");
INSERT INTO "Highschooler" VALUES ("1296");
INSERT INTO "Highschooler" VALUES ("1297");
INSERT INTO "Highschooler" VALUES ("1298");
INSERT INTO "Highschooler" VALUES ("1299");
INSERT INTO "Highschooler" VALUES ("1300");
INSERT INTO "Highschooler" VALUES ("1301");
INSERT INTO "Highschooler" VALUES ("1302");
INSERT INTO "Highschooler" VALUES ("1303");
INSERT INTO "Highschooler" VALUES ("1304");
INSERT INTO "Highschooler" VALUES ("1305");
INSERT INTO "Highschooler" VALUES ("1306");
INSERT INTO "Highschooler" VALUES ("1307");
INSERT INTO "Highschooler" VALUES ("1308");
INSERT INTO "Highschooler" VALUES ("1309");
INSERT INTO "Highschooler" VALUES ("1310");
INSERT INTO "Highschooler" VALUES ("1311");
INSERT INTO "Highschooler" VALUES ("1312");
INSERT INTO "Highschooler" VALUES ("1313");
INSERT INTO "Highschooler" VALUES ("1314");
INSERT INTO "Highschooler" VALUES ("1315");
INSERT INTO "Highschooler" VALUES ("1316");
INSERT INTO "Highschooler" VALUES ("1317");
INSERT INTO "Highschooler" VALUES ("1318");
INSERT INTO "Highschooler" VALUES ("1319");
INSERT INTO "Highschooler" VALUES ("1320");
INSERT INTO "Highschooler" VALUES ("1321");
INSERT INTO "Highschooler" VALUES ("1322");
INSERT INTO "Highschooler" VALUES ("1323");
INSERT INTO "Highschooler" VALUES ("1324");
INSERT INTO "Highschooler" VALUES ("1325");
INSERT INTO "Highschooler" VALUES ("1326");
INSERT INTO "Highschooler" VALUES ("1327");
INSERT INTO "Highschooler" VALUES ("1328");
INSERT INTO "Highschooler" VALUES ("1329");
INSERT INTO "Highschooler" VALUES ("1330");
INSERT INTO "Highschooler" VALUES ("1331");
INSERT INTO "Highschooler" VALUES ("1332");
INSERT INTO "Highschooler" VALUES ("1333");
INSERT INTO "Highschooler" VALUES ("1334");
INSERT INTO "Highschooler" VALUES ("1335");
INSERT INTO "Highschooler" VALUES ("1336");
INSERT INTO "Highschooler" VALUES ("1337");
INSERT INTO "Highschooler" VALUES ("1338");
INSERT INTO "Highschooler" VALUES ("1339");
INSERT INTO "Highschooler" VALUES ("1340");
INSERT INTO "Highschooler" VALUES ("1341");
INSERT INTO "Highschooler" VALUES ("1342");
INSERT INTO "Highschooler" VALUES ("1343");
INSERT INTO "Highschooler" VALUES ("1344");
INSERT INTO "Highschooler" VALUES ("1345");
INSERT INTO "Highschooler" VALUES ("1346");
INSERT INTO "Highschooler" VALUES ("1347");
INSERT INTO "Highschooler" VALUES ("1348");
INSERT INTO "Highschooler" VALUES ("1349");
INSERT INTO "Highschooler" VALUES ("1350");
INSERT INTO "Highschooler" VALUES ("1351");
INSERT INTO "Highschooler" VALUES ("1352");
INSERT INTO "Highschooler" VALUES ("1353");
INSERT INTO "Highschooler" VALUES ("1354");
INSERT INTO "Highschooler" VALUES ("1355");
INSERT INTO "Highschooler" VALUES ("1356");
INSERT INTO "Highschooler" VALUES ("1357");
INSERT INTO "Highschooler" VALUES ("1358");
INSERT INTO "Highschooler" VALUES ("1359");
INSERT INTO "Highschooler" VALUES ("1360");
INSERT INTO "Highschooler" VALUES ("1361");
INSERT INTO "Highschooler" VALUES ("1362");
INSERT INTO "Highschooler" VALUES ("1363");
INSERT INTO "Highschooler" VALUES ("1364");
INSERT INTO "Highschooler" VALUES ("1365");
INSERT INTO "Highschooler" VALUES ("1366");
INSERT INTO "Highschooler" VALUES ("1367");
INSERT INTO "Highschooler" VALUES ("1368");
INSERT INTO "Highschooler" VALUES ("1369");
INSERT INTO "Highschooler" VALUES ("1370");
INSERT INTO "Highschooler" VALUES ("1371");
INSERT INTO "Highschooler" VALUES ("1372");
INSERT INTO "Highschooler" VALUES ("1373");
INSERT INTO "Highschooler" VALUES ("1374");
INSERT INTO "Highschooler" VALUES ("1375");
INSERT INTO "Highschooler" VALUES ("1376");
INSERT INTO "Highschooler" VALUES ("1377");
INSERT INTO "Highschooler" VALUES ("1378");
INSERT INTO "Highschooler" VALUES ("1379");
INSERT INTO "Highschooler" VALUES ("1380");
INSERT INTO "Highschooler" VALUES ("1381");
INSERT INTO "Highschooler" VALUES ("1382");
INSERT INTO "Highschooler" VALUES ("1383");
INSERT INTO "Highschooler" VALUES ("1384");
INSERT INTO "Highschooler" VALUES ("1385");
INSERT INTO "Highschooler" VALUES ("1386");
INSERT INTO "Highschooler" VALUES ("1387");
INSERT INTO "Highschooler" VALUES ("1388");
INSERT INTO "Highschooler" VALUES ("1389");
INSERT INTO "Highschooler" VALUES ("1390");
INSERT INTO "Highschooler" VALUES ("1391");
INSERT INTO "Highschooler" VALUES ("1392");
INSERT INTO "Highschooler" VALUES ("1393");
INSERT INTO "Highschooler" VALUES ("1394");
INSERT INTO "Highschooler" VALUES ("1395");
INSERT INTO "Highschooler" VALUES ("1396");
INSERT INTO "Highschooler" VALUES ("1397");
INSERT INTO "Highschooler" VALUES ("1398");
INSERT INTO "Highschooler" VALUES ("1399");