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 "Sections" (
"section_id" INT,
"course_id" INT,
"section_name" VARCHAR(255),
PRIMARY KEY ("section_id")
);





INSERT INTO "Sections" VALUES ("101", "1", "Calculus I - Fall 2023");
INSERT INTO "Sections" VALUES ("102", "1", "Calculus I - Spring 2024");
INSERT INTO "Sections" VALUES ("201", "2", "Introduction to Programming - Section A");
INSERT INTO "Sections" VALUES ("202", "2", "Introduction to Programming - Section B");
INSERT INTO "Sections" VALUES ("301", "3", "Linear Algebra - Morning");
INSERT INTO "Sections" VALUES ("302", "3", "Linear Algebra - Afternoon");
INSERT INTO "Sections" VALUES ("401", "4", "Database Systems - Lecture");
INSERT INTO "Sections" VALUES ("402", "4", "Database Systems - Lab");
INSERT INTO "Sections" VALUES ("501", "5", "Organic Chemistry I - Section 001");
INSERT INTO "Sections" VALUES ("502", "5", "Organic Chemistry I - Section 002");
INSERT INTO "Sections" VALUES ("601", "6", "Art History - Renaissance Period");
INSERT INTO "Sections" VALUES ("602", "6", "Art History - Modern Art");
INSERT INTO "Sections" VALUES ("701", "7", "Microeconomics - Online");
INSERT INTO "Sections" VALUES ("702", "7", "Microeconomics - In-person");
INSERT INTO "Sections" VALUES ("801", "8", "Advanced Algorithms - Graduate");
INSERT INTO "Sections" VALUES ("802", "8", "Advanced Algorithms - Undergraduate");
INSERT INTO "Sections" VALUES ("901", "9", "World Literature - Part 1");
INSERT INTO "Sections" VALUES ("902", "9", "World Literature - Part 2");
INSERT INTO "Sections" VALUES ("1001", "10", "Introduction to Psychology - Evening");
INSERT INTO "Sections" VALUES ("1002", "10", "Introduction to Psychology - Day");