25b9f421c640d55eb8510f64b46ce284b0d579e1
[brackets.git] / migrations / 003-create_artist_genre_xref.sql
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 );