2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Fri Jan 27 01:16:24 2006
10 CREATE TABLE twokeys (
11 artist integer NOT NULL,
13 PRIMARY KEY (artist, cd)
19 CREATE TABLE liner_notes (
20 liner_id INTEGER PRIMARY KEY NOT NULL,
21 notes varchar NOT NULL
25 -- Table: cd_to_producer
27 CREATE TABLE cd_to_producer (
29 producer integer NOT NULL,
30 PRIMARY KEY (cd, producer)
37 artistid INTEGER PRIMARY KEY NOT NULL,
42 -- Table: self_ref_alias
44 CREATE TABLE self_ref_alias (
45 self_ref integer NOT NULL,
46 alias integer NOT NULL
52 CREATE TABLE fourkeys (
55 hello integer NOT NULL,
56 goodbye integer NOT NULL,
57 PRIMARY KEY (foo, bar, hello, goodbye)
64 cdid INTEGER PRIMARY KEY NOT NULL,
65 artist integer NOT NULL,
66 title varchar NOT NULL,
71 -- Table: artist_undirected_map
73 CREATE TABLE artist_undirected_map (
76 PRIMARY KEY (id1, id2)
83 id INTEGER PRIMARY KEY NOT NULL,
84 artist integer NOT NULL,
92 trackid INTEGER PRIMARY KEY NOT NULL,
94 position integer NOT NULL,
95 title varchar NOT NULL
101 CREATE TABLE producer (
102 producerid INTEGER PRIMARY KEY NOT NULL,
103 name varchar NOT NULL
109 CREATE TABLE self_ref (
110 id INTEGER PRIMARY KEY NOT NULL,
111 name varchar NOT NULL
118 tagid varchar NOT NULL,
120 tag varchar NOT NULL,