3 files changed, 1 insertions, 20 deletions
diff --git a/sql/drop.sql b/sql/drop.sql
index cc21040..549db26 100644
--- a/sql/drop.sql
+++ b/sql/drop.sql
@@ -1,5 +1,3 @@
 DROP TABLE choices;
 DROP TABLE users;
 DROP TABLE courses;
-DROP TABLE ctypes;
-DROP TABLE cgroups;
diff --git a/sql/schema.sql b/sql/schema.sql
index ecf31a2..3248f14 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -1,9 +1,3 @@
-CREATE TABLE ctypes (
-	name TEXT PRIMARY KEY NOT NULL
-);
-CREATE TABLE cgroups (
-	name TEXT PRIMARY KEY NOT NULL
-);
 CREATE TABLE courses (
 	id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
 	nmax INTEGER NOT NULL,
@@ -11,9 +5,7 @@ CREATE TABLE courses (
 	teacher TEXT NOT NULL,
 	location TEXT NOT NULL,
 	ctype TEXT NOT NULL,
-	FOREIGN KEY(ctype) REFERENCES ctypes(name),
-	cgroup TEXT NOT NULL,
-	FOREIGN KEY(cgroup) REFERENCES cgroups(name)
+	cgroup TEXT NOT NULL
 );
 CREATE TABLE users (
 	id TEXT PRIMARY KEY NOT NULL, -- should be UUID
diff --git a/sql/tcourse.sql b/sql/tcourse.sql
index 171a30c..64c315e 100644
--- a/sql/tcourse.sql
+++ b/sql/tcourse.sql
@@ -1,12 +1,3 @@
-INSERT INTO ctypes (name) VALUES('Enrichment');
-INSERT INTO ctypes (name) VALUES('Sport');
-INSERT INTO ctypes (name) VALUES('Culture');
-INSERT INTO cgroups (name) VALUES('MW1');
-INSERT INTO cgroups (name) VALUES('MW2');
-INSERT INTO cgroups (name) VALUES('MW3');
-INSERT INTO cgroups (name) VALUES('TT1');
-INSERT INTO cgroups (name) VALUES('TT2');
-INSERT INTO cgroups (name) VALUES('TT3');
 INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Floorball', 'Sport', 'MW1', 'Chen Xiaojia', 'Gym', 1000);
 INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Flag Football', 'Sport', 'MW2', 'Ding Zhaoyuan', 'Pitch', 1000);
 INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Chamber Music', 'Enrichment', 'TT1', '(?)', 'Music Rooms', 1000);