2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Fri Aug 4 19:03:21 2006
10 CREATE TABLE employee (
11 employee_id INTEGER PRIMARY KEY NOT NULL,
12 position integer NOT NULL,
20 CREATE TABLE serialized (
21 id INTEGER PRIMARY KEY NOT NULL,
22 serialized text NOT NULL
28 CREATE TABLE liner_notes (
29 liner_id INTEGER PRIMARY KEY NOT NULL,
30 notes varchar(100) NOT NULL
34 -- Table: cd_to_producer
36 CREATE TABLE cd_to_producer (
38 producer integer NOT NULL,
39 PRIMARY KEY (cd, producer)
46 artistid INTEGER PRIMARY KEY NOT NULL,
55 labelid INTEGER PRIMARY KEY NOT NULL,
60 -- Table: twokeytreelike
62 CREATE TABLE twokeytreelike (
65 parent1 integer NOT NULL,
66 parent2 integer NOT NULL,
67 name varchar(100) NOT NULL,
68 PRIMARY KEY (id1, id2)
72 -- Table: fourkeys_to_twokeys
74 CREATE TABLE fourkeys_to_twokeys (
75 f_foo integer NOT NULL,
76 f_bar integer NOT NULL,
77 f_hello integer NOT NULL,
78 f_goodbye integer NOT NULL,
79 t_artist integer NOT NULL,
80 t_cd integer NOT NULL,
81 autopilot character NOT NULL,
82 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
86 -- Table: self_ref_alias
88 CREATE TABLE self_ref_alias (
89 self_ref integer NOT NULL,
90 alias integer NOT NULL,
91 PRIMARY KEY (self_ref, alias)
98 cdid INTEGER PRIMARY KEY NOT NULL,
99 artist integer NOT NULL,
100 title varchar(100) NOT NULL,
101 year varchar(100) NOT NULL
107 CREATE TABLE bookmark (
108 id INTEGER PRIMARY KEY NOT NULL,
109 link integer NOT NULL
116 trackid INTEGER PRIMARY KEY NOT NULL,
118 position integer NOT NULL,
119 title varchar(100) NOT NULL
125 CREATE TABLE self_ref (
126 id INTEGER PRIMARY KEY NOT NULL,
127 name varchar(100) NOT NULL
134 tagid INTEGER PRIMARY KEY NOT NULL,
136 tag varchar(100) NOT NULL
143 agentid INTEGER PRIMARY KEY NOT NULL,
144 label integer NOT NULL,
152 id INTEGER PRIMARY KEY NOT NULL,
160 CREATE TABLE treelike (
161 id INTEGER PRIMARY KEY NOT NULL,
162 parent integer NOT NULL,
163 name varchar(100) NOT NULL
170 id INTEGER PRIMARY KEY NOT NULL,
171 starts_at datetime NOT NULL,
172 created_on timestamp NOT NULL
178 CREATE TABLE twokeys (
179 artist integer NOT NULL,
181 PRIMARY KEY (artist, cd)
185 -- Table: noprimarykey
187 CREATE TABLE noprimarykey (
188 foo integer NOT NULL,
189 bar integer NOT NULL,
196 CREATE TABLE fourkeys (
197 foo integer NOT NULL,
198 bar integer NOT NULL,
199 hello integer NOT NULL,
200 goodbye integer NOT NULL,
201 sensors character NOT NULL,
202 PRIMARY KEY (foo, bar, hello, goodbye)
206 -- Table: artist_undirected_map
208 CREATE TABLE artist_undirected_map (
209 id1 integer NOT NULL,
210 id2 integer NOT NULL,
211 PRIMARY KEY (id1, id2)
217 CREATE TABLE producer (
218 producerid INTEGER PRIMARY KEY NOT NULL,
219 name varchar(100) NOT NULL
225 CREATE TABLE onekey (
226 id INTEGER PRIMARY KEY NOT NULL,
227 artist integer NOT NULL,
231 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike on twokeytreelike (name);
232 CREATE UNIQUE INDEX cd_artist_title_cd on cd (artist, title);
233 CREATE UNIQUE INDEX track_cd_position_track on track (cd, position);
234 CREATE UNIQUE INDEX track_cd_title_track on track (cd, title);
235 CREATE UNIQUE INDEX foo_bar_noprimarykey on noprimarykey (foo, bar);
236 CREATE UNIQUE INDEX prod_name_producer on producer (name);