[brackets.git] / migrations / 003-create_artist_genre_xref.sql

CREATE TABLE ARTIST_GENRE_XREF (
  ID INTEGER PRIMARY KEY AUTOINCREMENT,
  ARTIST_ID NOT NULL,
  GENRE_ID NOT NULL,
  UNIQUE(ARTIST_ID, GENRE_ID),
  FOREIGN KEY(ARTIST_ID) REFERENCES ARTIST(ID),
  FOREIGN KEY(GENRE_ID) REFERENCES GENRE(ID)
);
Commit	Line	Data
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	);