2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Fri Feb 24 15:13:57 2006
10 CREATE TABLE twokeys (
11 artist integer NOT NULL,
13 PRIMARY KEY (artist, cd)
17 -- Table: cd_to_producer
19 CREATE TABLE cd_to_producer (
21 producer integer NOT NULL,
22 PRIMARY KEY (cd, producer)
28 CREATE TABLE liner_notes (
29 liner_id INTEGER PRIMARY KEY NOT NULL,
30 notes varchar NOT NULL
37 artistid INTEGER PRIMARY KEY NOT NULL,
43 -- Table: self_ref_alias
45 CREATE TABLE self_ref_alias (
46 self_ref integer NOT NULL,
47 alias integer NOT NULL,
48 PRIMARY KEY (self_ref, alias)
54 CREATE TABLE fourkeys (
57 hello integer NOT NULL,
58 goodbye integer NOT NULL,
59 PRIMARY KEY (foo, bar, hello, goodbye)
66 cdid INTEGER PRIMARY KEY NOT NULL,
67 artist integer NOT NULL,
68 title varchar NOT NULL,
73 -- Table: artist_undirected_map
75 CREATE TABLE artist_undirected_map (
78 PRIMARY KEY (id1, id2)
85 id INTEGER PRIMARY KEY NOT NULL,
86 artist integer NOT NULL,
94 trackid INTEGER PRIMARY KEY NOT NULL,
96 position integer NOT NULL,
97 title varchar NOT NULL
103 CREATE TABLE producer (
104 producerid INTEGER PRIMARY KEY NOT NULL,
105 name varchar NOT NULL
111 CREATE TABLE treelike (
112 id INTEGER PRIMARY KEY NOT NULL,
113 parent integer NOT NULL,
114 name varchar NOT NULL
121 tagid INTEGER PRIMARY KEY NOT NULL,
129 CREATE TABLE self_ref (
130 id INTEGER PRIMARY KEY NOT NULL,
131 name varchar NOT NULL
137 CREATE TABLE serialized (
138 id INTEGER PRIMARY KEY NOT NULL,
139 serialized text NOT NULL