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