diff options
Diffstat (limited to '')
-rw-r--r-- | sql/drop.sql | 2 | ||||
-rw-r--r-- | sql/schema.sql | 10 | ||||
-rw-r--r-- | sql/tcourse.sql | 9 |
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); |