diff options
Diffstat (limited to '')
-rw-r--r-- | sql/tcourse.sql | 19 |
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); |