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,
24 DROP TABLE IF EXISTS 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
35 DROP TABLE IF EXISTS track;
37 trackid INTEGER PRIMARY KEY NOT NULL,
39 position integer NOT NULL,
40 title varchar(100) NOT NULL,
41 last_updated_on datetime NULL
47 DROP TABLE IF EXISTS tags;
49 tagid INTEGER PRIMARY KEY NOT NULL,
51 tag varchar(100) NOT NULL
57 DROP TABLE IF EXISTS producer;
58 CREATE TABLE producer (
59 producerid INTEGER PRIMARY KEY NOT NULL,
60 name varchar(100) NOT NULL