2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Thu Feb 19 22:09:32 2009
13 artistid INTEGER PRIMARY KEY NOT NULL,
15 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);
30 CREATE INDEX artist_undirected_map_idx_id2_ ON artist_undirected_map (id2);
35 CREATE TABLE cd_artwork (
36 cd_id INTEGER PRIMARY KEY NOT NULL
39 CREATE INDEX cd_artwork_idx_cd_id_cd_artwor ON cd_artwork (cd_id);
42 -- Table: artwork_to_artist
44 CREATE TABLE artwork_to_artist (
45 artwork_cd_id integer NOT NULL,
46 artist_id integer NOT NULL,
47 PRIMARY KEY (artwork_cd_id, artist_id)
50 CREATE INDEX artwork_to_artist_idx_artist_id_artwork_to_arti ON artwork_to_artist (artist_id);
51 CREATE INDEX artwork_to_artist_idx_artwork_cd_id_artwork_to_ ON artwork_to_artist (artwork_cd_id);
54 -- Table: bindtype_test
56 CREATE TABLE bindtype_test (
57 id INTEGER PRIMARY KEY NOT NULL,
66 CREATE TABLE bookmark (
67 id INTEGER PRIMARY KEY NOT NULL,
71 CREATE INDEX bookmark_idx_link_bookmark ON bookmark (link);
77 id INTEGER PRIMARY KEY NOT NULL,
78 source varchar(100) NOT NULL,
79 owner integer NOT NULL,
80 title varchar(100) NOT NULL,
88 cdid INTEGER PRIMARY KEY NOT NULL,
89 artist integer NOT NULL,
90 title varchar(100) NOT NULL,
91 year varchar(100) NOT NULL,
96 CREATE INDEX cd_idx_artist_cd ON cd (artist);
98 CREATE INDEX cd_idx_genreid_cd ON cd (genreid);
100 CREATE INDEX cd_idx_single_track_cd ON cd (single_track);
102 CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title);
105 -- Table: cd_to_producer
107 CREATE TABLE cd_to_producer (
109 producer integer NOT NULL,
110 PRIMARY KEY (cd, producer)
113 CREATE INDEX cd_to_producer_idx_cd_cd_to_pr ON cd_to_producer (cd);
115 CREATE INDEX cd_to_producer_idx_producer_cd ON cd_to_producer (producer);
120 CREATE TABLE collection (
121 collectionid INTEGER PRIMARY KEY NOT NULL,
122 name varchar(100) NOT NULL
126 -- Table: collection_object
128 CREATE TABLE collection_object (
129 collection integer NOT NULL,
130 object integer NOT NULL,
131 PRIMARY KEY (collection, object)
134 CREATE INDEX collection_object_idx_collection_collection_obj ON collection_object (collection);
136 CREATE INDEX collection_object_idx_object_c ON collection_object (object);
141 CREATE TABLE employee (
142 employee_id INTEGER PRIMARY KEY NOT NULL,
143 position integer NOT NULL,
152 CREATE TABLE encoded (
153 id INTEGER PRIMARY KEY NOT NULL,
161 id INTEGER PRIMARY KEY NOT NULL,
162 starts_at datetime NOT NULL,
163 created_on timestamp NOT NULL,
164 varchar_date varchar(20),
165 varchar_datetime varchar(20),
166 skip_inflation datetime
170 -- Table: file_columns
172 CREATE TABLE file_columns (
173 id INTEGER PRIMARY KEY NOT NULL,
174 file varchar(255) NOT NULL
178 -- Table: forceforeign
180 CREATE TABLE forceforeign (
181 artist INTEGER PRIMARY KEY NOT NULL,
185 CREATE INDEX forceforeign_idx_artist_forcef ON forceforeign (artist);
190 CREATE TABLE fourkeys (
191 foo integer NOT NULL,
192 bar integer NOT NULL,
193 hello integer NOT NULL,
194 goodbye integer NOT NULL,
195 sensors character NOT NULL,
196 PRIMARY KEY (foo, bar, hello, goodbye)
200 -- Table: fourkeys_to_twokeys
202 CREATE TABLE fourkeys_to_twokeys (
203 f_foo integer NOT NULL,
204 f_bar integer NOT NULL,
205 f_hello integer NOT NULL,
206 f_goodbye integer NOT NULL,
207 t_artist integer NOT NULL,
208 t_cd integer NOT NULL,
209 autopilot character NOT NULL,
210 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
213 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);
215 CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_twokeys (t_artist, t_cd);
221 genreid INTEGER PRIMARY KEY NOT NULL,
222 name varchar(100) NOT NULL
225 CREATE UNIQUE INDEX genre_name_genre ON genre (name);
230 CREATE TABLE images (
231 id INTEGER PRIMARY KEY NOT NULL,
232 artwork_id integer NOT NULL,
233 name varchar(100) NOT NULL,
237 CREATE INDEX images_idx_artwork_id_images ON images (artwork_id);
240 -- Table: liner_notes
242 CREATE TABLE liner_notes (
243 liner_id INTEGER PRIMARY KEY NOT NULL,
244 notes varchar(100) NOT NULL
247 CREATE INDEX liner_notes_idx_liner_id_liner ON liner_notes (liner_id);
253 id INTEGER PRIMARY KEY NOT NULL,
259 -- Table: lyric_versions
261 CREATE TABLE lyric_versions (
262 id INTEGER PRIMARY KEY NOT NULL,
263 lyric_id integer NOT NULL,
264 text varchar(100) NOT NULL
267 CREATE INDEX lyric_versions_idx_lyric_id_ly ON lyric_versions (lyric_id);
272 CREATE TABLE lyrics (
273 lyric_id INTEGER PRIMARY KEY NOT NULL,
274 track_id integer NOT NULL
277 CREATE INDEX lyrics_idx_track_id_lyrics ON lyrics (track_id);
280 -- Table: noprimarykey
282 CREATE TABLE noprimarykey (
283 foo integer NOT NULL,
284 bar integer NOT NULL,
288 CREATE UNIQUE INDEX foo_bar_noprimarykey ON noprimarykey (foo, bar);
293 CREATE TABLE onekey (
294 id INTEGER PRIMARY KEY NOT NULL,
295 artist integer NOT NULL,
302 CREATE TABLE owners (
303 ownerid INTEGER PRIMARY KEY NOT NULL,
304 name varchar(100) NOT NULL
310 CREATE TABLE producer (
311 producerid INTEGER PRIMARY KEY NOT NULL,
312 name varchar(100) NOT NULL
315 CREATE UNIQUE INDEX prod_name_producer ON producer (name);
320 CREATE TABLE self_ref (
321 id INTEGER PRIMARY KEY NOT NULL,
322 name varchar(100) NOT NULL
326 -- Table: self_ref_alias
328 CREATE TABLE self_ref_alias (
329 self_ref integer NOT NULL,
330 alias integer NOT NULL,
331 PRIMARY KEY (self_ref, alias)
334 CREATE INDEX self_ref_alias_idx_alias_self_ ON self_ref_alias (alias);
336 CREATE INDEX self_ref_alias_idx_self_ref_se ON self_ref_alias (self_ref);
339 -- Table: sequence_test
341 CREATE TABLE sequence_test (
342 pkid1 integer NOT NULL,
343 pkid2 integer NOT NULL,
344 nonpkid integer NOT NULL,
346 PRIMARY KEY (pkid1, pkid2)
352 CREATE TABLE serialized (
353 id INTEGER PRIMARY KEY NOT NULL,
354 serialized text NOT NULL
361 tagid INTEGER PRIMARY KEY NOT NULL,
363 tag varchar(100) NOT NULL
366 CREATE INDEX tags_idx_cd_tags ON tags (cd);
372 trackid INTEGER PRIMARY KEY NOT NULL,
374 position integer NOT NULL,
375 title varchar(100) NOT NULL,
376 last_updated_on datetime
379 CREATE INDEX track_idx_cd_track ON track (cd);
381 CREATE UNIQUE INDEX track_cd_position_track ON track (cd, position);
383 CREATE UNIQUE INDEX track_cd_title_track ON track (cd, title);
388 CREATE TABLE treelike (
389 id INTEGER PRIMARY KEY NOT NULL,
391 name varchar(100) NOT NULL
394 CREATE INDEX treelike_idx_parent_treelike ON treelike (parent);
397 -- Table: twokeytreelike
399 CREATE TABLE twokeytreelike (
400 id1 integer NOT NULL,
401 id2 integer NOT NULL,
402 parent1 integer NOT NULL,
403 parent2 integer NOT NULL,
404 name varchar(100) NOT NULL,
405 PRIMARY KEY (id1, id2)
408 CREATE INDEX twokeytreelike_idx_parent1_parent2_twokeytre ON twokeytreelike (parent1, parent2);
410 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike ON twokeytreelike (name);
415 CREATE TABLE twokeys (
416 artist integer NOT NULL,
418 PRIMARY KEY (artist, cd)
421 CREATE INDEX twokeys_idx_artist_twokeys ON twokeys (artist);
424 -- Table: typed_object
426 CREATE TABLE typed_object (
427 objectid INTEGER PRIMARY KEY NOT NULL,
428 type varchar(100) NOT NULL,
429 value varchar(100) NOT NULL
435 CREATE VIEW year2000cds AS
436 SELECT cdid, artist, title FROM cd WHERE year ='2000';