projects
/
brackets.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Format SQL style
[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
);