projects
/
brackets.git
/ blame_incremental
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
blob
|
blame
(non-incremental) |
history
|
HEAD
Track artist popularity
[brackets.git]
/
migrations
/
003-create_artist_genre_xref.sql
This page requires JavaScript to run. Use
this page
instead.
... / ...
Commit
Line
Data
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
);