qZu0nj1h

1USE songbrowser;
2
3/** 2.1 Albums table */
4CREATE TABLE IF NOT EXISTS albums (
5  album_title    VARCHAR,
6  artist         VARCHAR,
7  genre          VARCHAR,
8  producer       VARCHAR,
9  record_label   VARCHAR,
10  release_year   INT,
11  PRIMARY KEY ((artist), release_year, album_title)
12);
13
14/** 2.2 Songs by album table */
15CREATE TABLE IF NOT EXISTS songs_by_albums (
16  album_title    VARCHAR,
17  artist         VARCHAR,
18  genre          VARCHAR,
19  performers     LIST<VARCHAR>,
20  release_year   INT,
21  song_title     VARCHAR,
22  track_no       INT,
23  PRIMARY KEY ((release_year, album_title), track_no)
24);
25
26/** 2.3 Songs by artist table */
27CREATE TABLE IF NOT EXISTS songs_by_artists (
28  album_title    VARCHAR,
29  artist         VARCHAR,
30  genre          VARCHAR,
31  performers     LIST<VARCHAR>,
32  release_year   INT,
33  song_title     VARCHAR,
34  track_no       INT,
35  PRIMARY KEY ((artist), release_year, album_title, track_no)
36);