summaryrefslogtreecommitdiff
path: root/sql/tcourse.sql
blob: 05b9f23c8e3f035d0f51262a10c5046c88c08eb9 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Floorball', 'Sport', 'MW1', 'Chen Xiaojia', 'Gym', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Fakeball', 'Sport', 'MW1', 'Foo Bar', 'Gym', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Chamber Music', 'Enrichment', 'MW1', 'Bar Baz', 'Music Rooms', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Programming Club', 'Enrichment', 'MW1', 'Foo Baz', 'Library', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Flag Football', 'Sport', 'MW2', 'Ding Zhaoyuan', 'Pitch', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Table Tennis', 'Sport', 'MW2', 'Somebody', 'Table Tennis Room', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Spinning', 'Sport', 'MW2', 'Somebody', 'Spinning Room', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Some Music', 'Enrichment', 'TT1', 'Eeeee', 'Music Rooms', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Some More Music', 'Enrichment', 'TT1', 'Eeeee', 'Music Rooms', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Math and Computer Science', 'Enrichment', 'TT2', 'Jeff Zhang', '2307', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Basketball', 'Sport', 'TT2', 'Somebody', 'Gym', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Chinese Drama', 'Culture', 'TT2', 'Monica Chen (?)', 'Black Box (?)', 65535);
INSERT INTO courses (title, ctype, cgroup, teacher, location, nmax) VALUES('Actually Flag Football', 'Sport', 'TT3', 'Hmm', 'Pitch', 65535);