Commit | Line | Data |
0566a82d |
1 | -- |
2 | -- Table: cd_to_producer |
3 | -- |
4 | DROP TABLE IF EXISTS cd_to_producer; |
5 | CREATE TABLE cd_to_producer ( |
6 | cd integer NOT NULL, |
7 | producer integer NOT NULL, |
8 | PRIMARY KEY (cd, producer) |
9 | ); |
10 | |
11 | -- |
12 | -- Table: artist |
13 | -- |
14 | DROP TABLE IF EXISTS artist; |
15 | CREATE TABLE artist ( |
16 | artistid INTEGER PRIMARY KEY NOT NULL, |
17 | name varchar(100) |
18 | ); |
19 | |
20 | |
21 | -- |
22 | -- Table: cd |
23 | -- |
24 | DROP TABLE IF EXISTS cd; |
25 | CREATE TABLE cd ( |
26 | cdid INTEGER PRIMARY KEY NOT NULL, |
27 | artist integer NOT NULL, |
28 | title varchar(100) NOT NULL, |
29 | year varchar(100) NOT NULL |
30 | ); |
31 | |
32 | -- |
33 | -- Table: track |
34 | -- |
35 | DROP TABLE IF EXISTS track; |
36 | CREATE TABLE track ( |
37 | trackid INTEGER PRIMARY KEY NOT NULL, |
38 | cd integer NOT NULL, |
39 | position integer NOT NULL, |
40 | title varchar(100) NOT NULL, |
41 | last_updated_on datetime NULL |
42 | ); |
43 | |
44 | -- |
45 | -- Table: tags |
46 | -- |
47 | DROP TABLE IF EXISTS tags; |
48 | CREATE TABLE tags ( |
49 | tagid INTEGER PRIMARY KEY NOT NULL, |
50 | cd integer NOT NULL, |
51 | tag varchar(100) NOT NULL |
52 | ); |
53 | |
54 | -- |
55 | -- Table: producer |
56 | -- |
57 | DROP TABLE IF EXISTS producer; |
58 | CREATE TABLE producer ( |
59 | producerid INTEGER PRIMARY KEY NOT NULL, |
60 | name varchar(100) NOT NULL |
61 | ); |