2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Thu May 28 10:10:00 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);
52 CREATE INDEX artwork_to_artist_idx_artwork_cd_id_artwork_to_ ON artwork_to_artist (artwork_cd_id);
55 -- Table: bindtype_test
57 CREATE TABLE bindtype_test (
58 id INTEGER PRIMARY KEY NOT NULL,
67 CREATE TABLE bookmark (
68 id INTEGER PRIMARY KEY NOT NULL,
72 CREATE INDEX bookmark_idx_link_bookmark ON bookmark (link);
78 id INTEGER PRIMARY KEY NOT NULL,
79 source varchar(100) NOT NULL,
80 owner integer NOT NULL,
81 title varchar(100) NOT NULL,
85 CREATE INDEX books_idx_owner_books ON books (owner);
91 cdid INTEGER PRIMARY KEY NOT NULL,
92 artist integer NOT NULL,
93 title varchar(100) NOT NULL,
94 year varchar(100) NOT NULL,
99 CREATE INDEX cd_idx_artist_cd ON cd (artist);
101 CREATE INDEX cd_idx_genreid_cd ON cd (genreid);
103 CREATE INDEX cd_idx_single_track_cd ON cd (single_track);
105 CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title);
108 -- Table: cd_to_producer
110 CREATE TABLE cd_to_producer (
112 producer integer NOT NULL,
114 PRIMARY KEY (cd, producer)
117 CREATE INDEX cd_to_producer_idx_cd_cd_to_pr ON cd_to_producer (cd);
119 CREATE INDEX cd_to_producer_idx_producer_cd ON cd_to_producer (producer);
124 CREATE TABLE collection (
125 collectionid INTEGER PRIMARY KEY NOT NULL,
126 name varchar(100) NOT NULL
130 -- Table: collection_object
132 CREATE TABLE collection_object (
133 collection integer NOT NULL,
134 object integer NOT NULL,
135 PRIMARY KEY (collection, object)
138 CREATE INDEX collection_object_idx_collection_collection_obj ON collection_object (collection);
140 CREATE INDEX collection_object_idx_object_c ON collection_object (object);
145 CREATE TABLE employee (
146 employee_id INTEGER PRIMARY KEY NOT NULL,
147 position integer NOT NULL,
157 CREATE TABLE encoded (
158 id INTEGER PRIMARY KEY NOT NULL,
166 id INTEGER PRIMARY KEY NOT NULL,
167 starts_at datetime NOT NULL,
168 created_on timestamp NOT NULL,
169 varchar_date varchar(20),
170 varchar_datetime varchar(20),
171 skip_inflation datetime
175 -- Table: file_columns
177 CREATE TABLE file_columns (
178 id INTEGER PRIMARY KEY NOT NULL,
179 file varchar(255) NOT NULL
183 -- Table: forceforeign
185 CREATE TABLE forceforeign (
186 artist INTEGER PRIMARY KEY NOT NULL,
190 CREATE INDEX forceforeign_idx_artist_forcef ON forceforeign (artist);
195 CREATE TABLE fourkeys (
196 foo integer NOT NULL,
197 bar integer NOT NULL,
198 hello integer NOT NULL,
199 goodbye integer NOT NULL,
200 sensors character(10) NOT NULL,
202 PRIMARY KEY (foo, bar, hello, goodbye)
206 -- Table: fourkeys_to_twokeys
208 CREATE TABLE fourkeys_to_twokeys (
209 f_foo integer NOT NULL,
210 f_bar integer NOT NULL,
211 f_hello integer NOT NULL,
212 f_goodbye integer NOT NULL,
213 t_artist integer NOT NULL,
214 t_cd integer NOT NULL,
215 autopilot character NOT NULL,
216 pilot_sequence integer,
217 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
220 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);
222 CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_twokeys (t_artist, t_cd);
228 genreid INTEGER PRIMARY KEY NOT NULL,
229 name varchar(100) NOT NULL
232 CREATE UNIQUE INDEX genre_name_genre ON genre (name);
237 CREATE TABLE images (
238 id INTEGER PRIMARY KEY NOT NULL,
239 artwork_id integer NOT NULL,
240 name varchar(100) NOT NULL,
244 CREATE INDEX images_idx_artwork_id_images ON images (artwork_id);
247 -- Table: liner_notes
249 CREATE TABLE liner_notes (
250 liner_id INTEGER PRIMARY KEY NOT NULL,
251 notes varchar(100) NOT NULL
254 CREATE INDEX liner_notes_idx_liner_id_liner ON liner_notes (liner_id);
260 id INTEGER PRIMARY KEY NOT NULL,
266 -- Table: lyric_versions
268 CREATE TABLE lyric_versions (
269 id INTEGER PRIMARY KEY NOT NULL,
270 lyric_id integer NOT NULL,
271 text varchar(100) NOT NULL
274 CREATE INDEX lyric_versions_idx_lyric_id_ly ON lyric_versions (lyric_id);
279 CREATE TABLE lyrics (
280 lyric_id INTEGER PRIMARY KEY NOT NULL,
281 track_id integer NOT NULL
284 CREATE INDEX lyrics_idx_track_id_lyrics ON lyrics (track_id);
287 -- Table: noprimarykey
289 CREATE TABLE noprimarykey (
290 foo integer NOT NULL,
291 bar integer NOT NULL,
295 CREATE UNIQUE INDEX foo_bar_noprimarykey ON noprimarykey (foo, bar);
300 CREATE TABLE onekey (
301 id INTEGER PRIMARY KEY NOT NULL,
302 artist integer NOT NULL,
309 CREATE TABLE owners (
310 id INTEGER PRIMARY KEY NOT NULL,
311 name varchar(100) NOT NULL
317 CREATE TABLE producer (
318 producerid INTEGER PRIMARY KEY NOT NULL,
319 name varchar(100) NOT NULL
322 CREATE UNIQUE INDEX prod_name_producer ON producer (name);
327 CREATE TABLE self_ref (
328 id INTEGER PRIMARY KEY NOT NULL,
329 name varchar(100) NOT NULL
333 -- Table: self_ref_alias
335 CREATE TABLE self_ref_alias (
336 self_ref integer NOT NULL,
337 alias integer NOT NULL,
338 PRIMARY KEY (self_ref, alias)
341 CREATE INDEX self_ref_alias_idx_alias_self_ ON self_ref_alias (alias);
343 CREATE INDEX self_ref_alias_idx_self_ref_se ON self_ref_alias (self_ref);
346 -- Table: sequence_test
348 CREATE TABLE sequence_test (
349 pkid1 integer NOT NULL,
350 pkid2 integer NOT NULL,
351 nonpkid integer NOT NULL,
353 PRIMARY KEY (pkid1, pkid2)
359 CREATE TABLE serialized (
360 id INTEGER PRIMARY KEY NOT NULL,
361 serialized text NOT NULL
368 tagid INTEGER PRIMARY KEY NOT NULL,
370 tag varchar(100) NOT NULL
373 CREATE INDEX tags_idx_cd_tags ON tags (cd);
379 trackid INTEGER PRIMARY KEY NOT NULL,
381 position integer NOT NULL,
382 title varchar(100) NOT NULL,
383 last_updated_on datetime,
384 last_updated_at datetime
387 CREATE INDEX track_idx_cd_track ON track (cd);
389 CREATE UNIQUE INDEX track_cd_position_track ON track (cd, position);
391 CREATE UNIQUE INDEX track_cd_title_track ON track (cd, title);
396 CREATE TABLE treelike (
397 id INTEGER PRIMARY KEY NOT NULL,
399 name varchar(100) NOT NULL
402 CREATE INDEX treelike_idx_parent_treelike ON treelike (parent);
405 -- Table: twokeytreelike
407 CREATE TABLE twokeytreelike (
408 id1 integer NOT NULL,
409 id2 integer NOT NULL,
410 parent1 integer NOT NULL,
411 parent2 integer NOT NULL,
412 name varchar(100) NOT NULL,
413 PRIMARY KEY (id1, id2)
416 CREATE INDEX twokeytreelike_idx_parent1_parent2_twokeytre ON twokeytreelike (parent1, parent2);
418 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike ON twokeytreelike (name);
423 CREATE TABLE twokeys (
424 artist integer NOT NULL,
426 PRIMARY KEY (artist, cd)
429 CREATE INDEX twokeys_idx_artist_twokeys ON twokeys (artist);
432 -- Table: typed_object
434 CREATE TABLE typed_object (
435 objectid INTEGER PRIMARY KEY NOT NULL,
436 type varchar(100) NOT NULL,
437 value varchar(100) NOT NULL
443 CREATE VIEW year2000cds AS
444 SELECT cdid, artist, title FROM cd WHERE year ='2000';