1CREATE TABLE "artist" (
2  "artistid" INTEGER PRIMARY KEY NOT NULL,
3  "name" text NOT NULL
4);
5
6CREATE UNIQUE INDEX "artist_name" ON "artist" ("name");
7
8CREATE TABLE "cd" (
9  "cdid" INTEGER PRIMARY KEY NOT NULL,
10  "artistid" integer NOT NULL,
11  "title" text NOT NULL,
12  "year" datetime,
13  FOREIGN KEY ("artistid") REFERENCES "artist"("artistid") ON DELETE CASCADE ON UPDATE CASCADE
14);
15
16CREATE INDEX "cd_idx_artistid" ON "cd" ("artistid");
17
18CREATE UNIQUE INDEX "cd_title_artistid" ON "cd" ("title", "artistid");
19
20CREATE TABLE "track" (
21  "trackid" INTEGER PRIMARY KEY NOT NULL,
22  "cdid" integer NOT NULL,
23  "title" text NOT NULL,
24  FOREIGN KEY ("cdid") REFERENCES "cd"("cdid") ON DELETE CASCADE ON UPDATE CASCADE
25);
26
27CREATE INDEX "track_idx_cdid" ON "track" ("cdid");
28
29CREATE UNIQUE INDEX "track_title_cdid" ON "track" ("title", "cdid");
30