2 -- Table: cd_to_producer
4 DROP TABLE IF EXISTS cd_to_producer;
5 CREATE TABLE cd_to_producer (
7 producer integer NOT NULL,
8 PRIMARY KEY (cd, producer)
14 DROP TABLE IF EXISTS artist;
16 artistid INTEGER PRIMARY KEY NOT NULL,
21 -- Table: artist_washed_up
23 DROP TABLE IF EXISTS artist_washed_up;
24 CREATE TABLE artist_washed_up (
25 fk_artistid INTEGER PRIMARY KEY NOT NULL
31 DROP TABLE IF EXISTS cd;
33 cdid INTEGER PRIMARY KEY NOT NULL,
34 artist integer NOT NULL,
35 title varchar(100) NOT NULL,
36 year varchar(100) NOT NULL
42 DROP TABLE IF EXISTS track;
44 trackid INTEGER PRIMARY KEY NOT NULL,
46 position integer NOT NULL,
47 title varchar(100) NOT NULL,
48 last_updated_on datetime NULL
54 DROP TABLE IF EXISTS tags;
56 tagid INTEGER PRIMARY KEY NOT NULL,
58 tag varchar(100) NOT NULL
64 DROP TABLE IF EXISTS producer;
65 CREATE TABLE producer (
66 producerid INTEGER PRIMARY KEY NOT NULL,
67 name varchar(100) NOT NULL