projects
/
brackets.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
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
);