2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Sat Jan 17 19:40:47 2009
12 artistid INTEGER PRIMARY KEY NOT NULL,
14 rank integer NOT NULL DEFAULT '13',
20 -- Table: artist_undirected_map
22 CREATE TABLE artist_undirected_map (
25 PRIMARY KEY (id1, id2)
28 CREATE INDEX artist_undirected_map_idx_id1_ ON artist_undirected_map (id1);
29 CREATE INDEX artist_undirected_map_idx_id2_ ON artist_undirected_map (id2);
34 CREATE TABLE cd_artwork (
35 cd_id INTEGER PRIMARY KEY NOT NULL
38 CREATE INDEX cd_artwork_idx_cd_id_cd_artwor ON cd_artwork (cd_id);
41 -- Table: bindtype_test
43 CREATE TABLE bindtype_test (
44 id INTEGER PRIMARY KEY NOT NULL,
54 CREATE TABLE bookmark (
55 id INTEGER PRIMARY KEY NOT NULL,
59 CREATE INDEX bookmark_idx_link_bookmark ON bookmark (link);
65 id INTEGER PRIMARY KEY NOT NULL,
66 source varchar(100) NOT NULL,
67 owner integer NOT NULL,
68 title varchar(100) NOT NULL,
77 cdid INTEGER PRIMARY KEY NOT NULL,
78 artist integer NOT NULL,
79 title varchar(100) NOT NULL,
80 year varchar(100) NOT NULL,
85 CREATE INDEX cd_idx_artist_cd ON cd (artist);
86 CREATE INDEX cd_idx_genreid_cd ON cd (genreid);
87 CREATE INDEX cd_idx_single_track_cd ON cd (single_track);
88 CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title);
91 -- Table: cd_to_producer
93 CREATE TABLE cd_to_producer (
95 producer integer NOT NULL,
96 PRIMARY KEY (cd, producer)
99 CREATE INDEX cd_to_producer_idx_cd_cd_to_pr ON cd_to_producer (cd);
100 CREATE INDEX cd_to_producer_idx_producer_cd ON cd_to_producer (producer);
105 CREATE TABLE collection (
106 collectionid INTEGER PRIMARY KEY NOT NULL,
107 name varchar(100) NOT NULL
112 -- Table: collection_object
114 CREATE TABLE collection_object (
115 collection integer NOT NULL,
116 object integer NOT NULL,
117 PRIMARY KEY (collection, object)
120 CREATE INDEX collection_object_idx_collection_collection_obj ON collection_object (collection);
121 CREATE INDEX collection_object_idx_object_c ON collection_object (object);
126 CREATE TABLE employee (
127 employee_id INTEGER PRIMARY KEY NOT NULL,
128 position integer NOT NULL,
139 id INTEGER PRIMARY KEY NOT NULL,
140 starts_at datetime NOT NULL,
141 created_on timestamp NOT NULL,
142 varchar_date varchar(20),
143 varchar_datetime varchar(20),
144 skip_inflation datetime
149 -- Table: file_columns
151 CREATE TABLE file_columns (
152 id INTEGER PRIMARY KEY NOT NULL,
153 file varchar(255) NOT NULL
158 -- Table: forceforeign
160 CREATE TABLE forceforeign (
161 artist INTEGER PRIMARY KEY NOT NULL,
165 CREATE INDEX forceforeign_idx_artist_forcef ON forceforeign (artist);
170 CREATE TABLE fourkeys (
171 foo integer NOT NULL,
172 bar integer NOT NULL,
173 hello integer NOT NULL,
174 goodbye integer NOT NULL,
175 sensors character NOT NULL,
176 PRIMARY KEY (foo, bar, hello, goodbye)
181 -- Table: fourkeys_to_twokeys
183 CREATE TABLE fourkeys_to_twokeys (
184 f_foo integer NOT NULL,
185 f_bar integer NOT NULL,
186 f_hello integer NOT NULL,
187 f_goodbye integer NOT NULL,
188 t_artist integer NOT NULL,
189 t_cd integer NOT NULL,
190 autopilot character NOT NULL,
191 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
194 CREATE INDEX fourkeys_to_twokeys_idx_f_foo_f_bar_f_hello_f_goodbye_ ON fourkeys_to_twokeys (f_foo, f_bar, f_hello, f_goodbye);
195 CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_twokeys (t_artist, t_cd);
201 genreid INTEGER PRIMARY KEY NOT NULL,
202 name varchar(100) NOT NULL
205 CREATE UNIQUE INDEX genre_name_genre ON genre (name);
210 CREATE TABLE images (
211 id INTEGER PRIMARY KEY NOT NULL,
212 artwork_id integer NOT NULL,
213 name varchar(100) NOT NULL,
217 CREATE INDEX images_idx_artwork_id_images ON images (artwork_id);
220 -- Table: liner_notes
222 CREATE TABLE liner_notes (
223 liner_id INTEGER PRIMARY KEY NOT NULL,
224 notes varchar(100) NOT NULL
227 CREATE INDEX liner_notes_idx_liner_id_liner ON liner_notes (liner_id);
233 id INTEGER PRIMARY KEY NOT NULL,
240 -- Table: lyric_versions
242 CREATE TABLE lyric_versions (
243 id INTEGER PRIMARY KEY NOT NULL,
244 lyric_id integer NOT NULL,
245 text varchar(100) NOT NULL
248 CREATE INDEX lyric_versions_idx_lyric_id_ly ON lyric_versions (lyric_id);
253 CREATE TABLE lyrics (
254 lyric_id INTEGER PRIMARY KEY NOT NULL,
255 track_id integer NOT NULL
258 CREATE INDEX lyrics_idx_track_id_lyrics ON lyrics (track_id);
261 -- Table: noprimarykey
263 CREATE TABLE noprimarykey (
264 foo integer NOT NULL,
265 bar integer NOT NULL,
269 CREATE UNIQUE INDEX foo_bar_noprimarykey ON noprimarykey (foo, bar);
274 CREATE TABLE onekey (
275 id INTEGER PRIMARY KEY NOT NULL,
276 artist integer NOT NULL,
284 CREATE TABLE owners (
285 ownerid INTEGER PRIMARY KEY NOT NULL,
286 name varchar(100) NOT NULL
293 CREATE TABLE producer (
294 producerid INTEGER PRIMARY KEY NOT NULL,
295 name varchar(100) NOT NULL
298 CREATE UNIQUE INDEX prod_name_producer ON producer (name);
303 CREATE TABLE self_ref (
304 id INTEGER PRIMARY KEY NOT NULL,
305 name varchar(100) NOT NULL
310 -- Table: self_ref_alias
312 CREATE TABLE self_ref_alias (
313 self_ref integer NOT NULL,
314 alias integer NOT NULL,
315 PRIMARY KEY (self_ref, alias)
318 CREATE INDEX self_ref_alias_idx_alias_self_ ON self_ref_alias (alias);
319 CREATE INDEX self_ref_alias_idx_self_ref_se ON self_ref_alias (self_ref);
322 -- Table: sequence_test
324 CREATE TABLE sequence_test (
325 pkid1 integer NOT NULL,
326 pkid2 integer NOT NULL,
327 nonpkid integer NOT NULL,
329 PRIMARY KEY (pkid1, pkid2)
336 CREATE TABLE serialized (
337 id INTEGER PRIMARY KEY NOT NULL,
338 serialized text NOT NULL
346 tagid INTEGER PRIMARY KEY NOT NULL,
348 tag varchar(100) NOT NULL
351 CREATE INDEX tags_idx_cd_tags ON tags (cd);
357 trackid INTEGER PRIMARY KEY NOT NULL,
359 position integer NOT NULL,
360 title varchar(100) NOT NULL,
361 last_updated_on datetime
364 CREATE INDEX track_idx_cd_track ON track (cd);
365 CREATE UNIQUE INDEX track_cd_position_track ON track (cd, position);
366 CREATE UNIQUE INDEX track_cd_title_track ON track (cd, title);
371 CREATE TABLE treelike (
372 id INTEGER PRIMARY KEY NOT NULL,
374 name varchar(100) NOT NULL
377 CREATE INDEX treelike_idx_parent_treelike ON treelike (parent);
380 -- Table: twokeytreelike
382 CREATE TABLE twokeytreelike (
383 id1 integer NOT NULL,
384 id2 integer NOT NULL,
385 parent1 integer NOT NULL,
386 parent2 integer NOT NULL,
387 name varchar(100) NOT NULL,
388 PRIMARY KEY (id1, id2)
391 CREATE INDEX twokeytreelike_idx_parent1_parent2_twokeytre ON twokeytreelike (parent1, parent2);
392 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike ON twokeytreelike (name);
397 CREATE TABLE twokeys (
398 artist integer NOT NULL,
400 PRIMARY KEY (artist, cd)
403 CREATE INDEX twokeys_idx_artist_twokeys ON twokeys (artist);
406 -- Table: typed_object
408 CREATE TABLE typed_object (
409 objectid INTEGER PRIMARY KEY NOT NULL,
410 type varchar(100) NOT NULL,
411 value varchar(100) NOT NULL