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), | |
113e8d16 | 9 | title TEXT NOT NULL, |
10 | year DATETIME | |
0c337847 | 11 | ); |
12 | ||
13 | CREATE TABLE track ( | |
14 | trackid INTEGER PRIMARY KEY, | |
15 | cd INTEGER NOT NULL REFERENCES cd(cdid), | |
16 | title TEXT NOT NULL | |
ffce4b65 | 17 | ); |