2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Fri May 12 01:09:57 2006
10 CREATE TABLE serialized (
11 id INTEGER PRIMARY KEY NOT NULL,
12 serialized text NOT NULL
18 CREATE TABLE liner_notes (
19 liner_id INTEGER PRIMARY KEY NOT NULL,
20 notes varchar(100) NOT NULL
24 -- Table: cd_to_producer
26 CREATE TABLE cd_to_producer (
28 producer integer NOT NULL,
29 PRIMARY KEY (cd, producer)
36 artistid INTEGER PRIMARY KEY NOT NULL,
41 -- Table: twokeytreelike
43 CREATE TABLE twokeytreelike (
46 parent1 integer NOT NULL,
47 parent2 integer NOT NULL,
48 name varchar(100) NOT NULL,
49 PRIMARY KEY (id1, id2)
53 -- Table: self_ref_alias
55 CREATE TABLE self_ref_alias (
56 self_ref integer NOT NULL,
57 alias integer NOT NULL,
58 PRIMARY KEY (self_ref, alias)
65 cdid INTEGER PRIMARY KEY NOT NULL,
66 artist integer NOT NULL,
67 title varchar(100) NOT NULL,
68 year varchar(100) NOT NULL
74 CREATE TABLE bookmark (
75 id INTEGER PRIMARY KEY NOT NULL,
83 trackid INTEGER PRIMARY KEY NOT NULL,
85 position integer NOT NULL,
86 title varchar(100) NOT NULL
93 id INTEGER PRIMARY KEY NOT NULL,
101 CREATE TABLE self_ref (
102 id INTEGER PRIMARY KEY NOT NULL,
103 name varchar(100) NOT NULL
109 CREATE TABLE treelike (
110 id INTEGER PRIMARY KEY NOT NULL,
111 parent integer NOT NULL,
112 name varchar(100) NOT NULL
119 tagid INTEGER PRIMARY KEY NOT NULL,
121 tag varchar(100) NOT NULL
127 CREATE TABLE twokeys (
128 artist integer NOT NULL,
130 PRIMARY KEY (artist, cd)
136 CREATE TABLE fourkeys (
137 foo integer NOT NULL,
138 bar integer NOT NULL,
139 hello integer NOT NULL,
140 goodbye integer NOT NULL,
141 PRIMARY KEY (foo, bar, hello, goodbye)
145 -- Table: artist_undirected_map
147 CREATE TABLE artist_undirected_map (
148 id1 integer NOT NULL,
149 id2 integer NOT NULL,
150 PRIMARY KEY (id1, id2)
156 CREATE TABLE producer (
157 producerid INTEGER PRIMARY KEY NOT NULL,
158 name varchar(100) NOT NULL
164 CREATE TABLE onekey (
165 id INTEGER PRIMARY KEY NOT NULL,
166 artist integer NOT NULL,