2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Tue Aug 8 01:53:20 2006
8 -- Table: cd_to_producer
10 CREATE TABLE cd_to_producer (
12 producer integer NOT NULL,
13 PRIMARY KEY (cd, producer)
20 artistid INTEGER PRIMARY KEY NOT NULL,
25 -- Table: artist_washed_up
27 CREATE TABLE artist_washed_up (
28 fk_artistid INTEGER PRIMARY KEY NOT NULL
35 cdid INTEGER PRIMARY KEY NOT NULL,
36 artist integer NOT NULL,
37 title varchar(100) NOT NULL,
38 year varchar(100) NOT NULL
45 trackid INTEGER PRIMARY KEY NOT NULL,
47 position integer NOT NULL,
48 title varchar(100) NOT NULL,
49 last_updated_on datetime NULL
56 tagid INTEGER PRIMARY KEY NOT NULL,
58 tag varchar(100) NOT NULL
64 CREATE TABLE producer (
65 producerid INTEGER PRIMARY KEY NOT NULL,
66 name varchar(100) NOT NULL