9ce45a18 JC |
1 | CREATE TABLE ARTIST_GENRE_XREF ( |
2 | ID INTEGER PRIMARY KEY AUTOINCREMENT, |
3 | ARTIST_ID NOT NULL, |
4 | GENRE_ID NOT NULL, |
5 | UNIQUE(ARTIST_ID, GENRE_ID), |
6 | FOREIGN KEY(ARTIST_ID) REFERENCES ARTIST(ID), |
7 | FOREIGN KEY(GENRE_ID) REFERENCES GENRE(ID) |
8 | ); |