1 files changed, 14 insertions, 5 deletions
diff --git a/sql/tcourse.sql b/sql/tcourse.sql
index a20ad31..171a30c 100644
--- a/sql/tcourse.sql
+++ b/sql/tcourse.sql
@@ -1,5 +1,14 @@
-INSERT INTO courses (title, ctype, teacher, location, nmax) VALUES('Floorball', 'Sport', 'Chen Xiaojia', 'Gym', 1000);
-INSERT INTO courses (title, ctype, teacher, location, nmax) VALUES('Flag Football', 'Sport', 'Ding Zhaoyuan', 'Pitch', 1000);
-INSERT INTO courses (title, ctype, teacher, location, nmax) VALUES('Chamber Music', 'Enrichment', '(?)', 'Music Rooms', 1000);
-INSERT INTO courses (title, ctype, teacher, location, nmax) VALUES('Math and Computer Science', 'Enrichment', 'Jeff Zhang', '2307', 1000);
-INSERT INTO courses (title, ctype, teacher, location, nmax) VALUES('Chinese Drama', 'Culture', 'Monica Chen (?)', 'Black Box (?)', 1000);
+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);
+INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Math and Computer Science', 'Enrichment', 'TT2', 'Jeff Zhang', '2307', 1000);
+INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Chinese Drama', 'Culture', 'TT2', 'Monica Chen (?)', 'Black Box (?)', 1000);