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,
29 cdid INTEGER PRIMARY KEY NOT NULL,
30 artist integer NOT NULL,
31 title varchar(100) NOT NULL,
32 year varchar(100) NOT NULL
39 trackid INTEGER PRIMARY KEY NOT NULL,
41 position integer NOT NULL,
42 title varchar(100) NULL,
43 last_updated_on datetime NULL
50 tagid INTEGER PRIMARY KEY NOT NULL,
52 tag varchar(100) NOT NULL
58 CREATE TABLE producer (
59 producerid INTEGER PRIMARY KEY NOT NULL,
60 name varchar(100) NOT NULL