Commit | Line | Data |
---|---|---|
0c337847 | 1 | CREATE TABLE artist ( |
2 | artistid INTEGER PRIMARY KEY, | |
3 | name TEXT NOT NULL | |
4 | ); | |
5 | ||
6 | CREATE TABLE cd ( | |
7 | cdid INTEGER PRIMARY KEY, | |
8 | artist INTEGER NOT NULL REFERENCES artist(artistid), | |
9 | title TEXT NOT NULL | |
10 | ); | |
11 | ||
12 | CREATE TABLE track ( | |
13 | trackid INTEGER PRIMARY KEY, | |
14 | cd INTEGER NOT NULL REFERENCES cd(cdid), | |
15 | title TEXT NOT NULL | |
16 | ); |