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 "Courses" (
"course_id" INT,
"course_name" VARCHAR(255),
PRIMARY KEY ("course_id")
);

CREATE TABLE "Sections" (
"section_id" INT,
"section_name" VARCHAR(255),
"section_description" VARCHAR(255),
PRIMARY KEY ("section_id")
);

CREATE TABLE "Semesters" (
"semester_id" INT,
"semester_name" VARCHAR(255),
PRIMARY KEY ("semester_id")
);





INSERT INTO "Sections" VALUES ("1", "Alpha", "Basic concepts of alpha testing");
INSERT INTO "Sections" VALUES ("2", "alphaBeta", "Intermediate alpha and beta concepts");
INSERT INTO "Sections" VALUES ("3", "Alph@", "Special characters in section name");
INSERT INTO "Sections" VALUES ("4", "Beta", "Beta testing overview");
INSERT INTO "Sections" VALUES ("5", "betaGamma", "Advanced beta and gamma topics");
INSERT INTO "Sections" VALUES ("6", "Gamma", "Gamma ray physics");
INSERT INTO "Sections" VALUES ("7", "gammaDelta", "Gamma to delta transition");
INSERT INTO "Sections" VALUES ("8", "Delta", "Delta force operations");
INSERT INTO "Sections" VALUES ("9", "deltaEpsilon", "Delta and epsilon studies");
INSERT INTO "Sections" VALUES ("10", "Epsilon", "Epsilon level mathematics");
INSERT INTO "Sections" VALUES ("11", "epsilonZeta", "Epsilon to zeta progression");
INSERT INTO "Sections" VALUES ("12", "Zeta", "Zeta function analysis");
INSERT INTO "Sections" VALUES ("13", "zetaEta", "Zeta and eta relations");
INSERT INTO "Sections" VALUES ("14", "Eta", "Eta particle physics");
INSERT INTO "Sections" VALUES ("15", "etaTheta", "Eta to theta concepts");
INSERT INTO "Sections" VALUES ("16", "Theta", "Theta wave studies");
INSERT INTO "Sections" VALUES ("17", "thetaIota", "Theta and iota comparison");
INSERT INTO "Sections" VALUES ("18", "Iota", "Iota notation in math");
INSERT INTO "Sections" VALUES ("19", "iotaKappa", "Iota to kappa transition");
INSERT INTO "Sections" VALUES ("20", "Kappa", "Kappa statistics basics");
INSERT INTO "Sections" VALUES ("21", "kappaLambda", "Kappa and lambda functions");
INSERT INTO "Sections" VALUES ("22", "Lambda", "Lambda calculus introduction");
INSERT INTO "Sections" VALUES ("23", "lambdaMu", "Lambda to mu progression");
INSERT INTO "Sections" VALUES ("24", "Mu", "Mu particle physics");
INSERT INTO "Sections" VALUES ("25", "muNu", "Mu and nu comparison");
INSERT INTO "Sections" VALUES ("26", "Nu", "Nu notation in science");
INSERT INTO "Sections" VALUES ("27", "nuXi", "Nu to xi transition");
INSERT INTO "Sections" VALUES ("28", "Xi", "Xi particle studies");
INSERT INTO "Sections" VALUES ("29", "xiOmicron", "Xi and omicron relations");
INSERT INTO "Sections" VALUES ("30", "Omicron", "Omicron variant overview");
INSERT INTO "Sections" VALUES ("31", "omicronPi", "Omicron to pi concepts");
INSERT INTO "Sections" VALUES ("32", "Pi", "Pi constant and uses");
INSERT INTO "Sections" VALUES ("33", "piRho", "Pi and rho comparison");
INSERT INTO "Sections" VALUES ("34", "Rho", "Rho protein studies");
INSERT INTO "Sections" VALUES ("35", "rhoSigma", "Rho to sigma transition");
INSERT INTO "Sections" VALUES ("36", "Sigma", "Sigma notation basics");
INSERT INTO "Sections" VALUES ("37", "sigmaTau", "Sigma and tau relations");
INSERT INTO "Sections" VALUES ("38", "Tau", "Tau particle physics");
INSERT INTO "Sections" VALUES ("39", "tauUpsilon", "Tau to upsilon concepts");
INSERT INTO "Sections" VALUES ("40", "Upsilon", "Upsilon meson studies");
INSERT INTO "Sections" VALUES ("41", "upsilonPhi", "Upsilon and phi comparison");
INSERT INTO "Sections" VALUES ("42", "Phi", "Phi constant and applications");
INSERT INTO "Sections" VALUES ("43", "phiChi", "Phi to chi transition");
INSERT INTO "Sections" VALUES ("44", "Chi", "Chi square tests");
INSERT INTO "Sections" VALUES ("45", "chiPsi", "Chi and psi relations");
INSERT INTO "Sections" VALUES ("46", "Psi", "Psi particle physics");
INSERT INTO "Sections" VALUES ("47", "psiOmega", "Psi to omega concepts");
INSERT INTO "Sections" VALUES ("48", "Omega", "Omega constant overview");
INSERT INTO "Sections" VALUES ("49", "omegaAlpha", "Omega and alpha cycle");
INSERT INTO "Sections" VALUES ("50", "alpha1", "Alpha with numeric suffix");