Commit | Line | Data |
---|---|---|
0c337847 | 1 | CREATE TABLE artist ( |
2 | artistid INTEGER PRIMARY KEY, | |
ffce4b65 | 3 | name TEXT NOT NULL |
0c337847 | 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 | |
ffce4b65 | 16 | ); |