2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Tue May 26 18:29:15 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,
89 cdid INTEGER PRIMARY KEY NOT NULL,
90 artist integer NOT NULL,
91 title varchar(100) NOT NULL,
92 year varchar(100) NOT NULL,
97 CREATE INDEX cd_idx_artist_cd ON cd (artist);
99 CREATE INDEX cd_idx_genreid_cd ON cd (genreid);
101 CREATE INDEX cd_idx_single_track_cd ON cd (single_track);
103 CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title);
106 -- Table: cd_to_producer
108 CREATE TABLE cd_to_producer (
110 producer integer NOT NULL,
112 PRIMARY KEY (cd, producer)
115 CREATE INDEX cd_to_producer_idx_cd_cd_to_pr ON cd_to_producer (cd);
117 CREATE INDEX cd_to_producer_idx_producer_cd ON cd_to_producer (producer);
122 CREATE TABLE collection (
123 collectionid INTEGER PRIMARY KEY NOT NULL,
124 name varchar(100) NOT NULL
128 -- Table: collection_object
130 CREATE TABLE collection_object (
131 collection integer NOT NULL,
132 object integer NOT NULL,
133 PRIMARY KEY (collection, object)
136 CREATE INDEX collection_object_idx_collection_collection_obj ON collection_object (collection);
138 CREATE INDEX collection_object_idx_object_c ON collection_object (object);
143 CREATE TABLE employee (
144 employee_id INTEGER PRIMARY KEY NOT NULL,
145 position integer NOT NULL,
155 CREATE TABLE encoded (
156 id INTEGER PRIMARY KEY NOT NULL,
164 id INTEGER PRIMARY KEY NOT NULL,
165 starts_at datetime NOT NULL,
166 created_on timestamp NOT NULL,
167 varchar_date varchar(20),
168 varchar_datetime varchar(20),
169 skip_inflation datetime
173 -- Table: file_columns
175 CREATE TABLE file_columns (
176 id INTEGER PRIMARY KEY NOT NULL,
177 file varchar(255) NOT NULL
181 -- Table: forceforeign
183 CREATE TABLE forceforeign (
184 artist INTEGER PRIMARY KEY NOT NULL,
188 CREATE INDEX forceforeign_idx_artist_forcef ON forceforeign (artist);
193 CREATE TABLE fourkeys (
194 foo integer NOT NULL,
195 bar integer NOT NULL,
196 hello integer NOT NULL,
197 goodbye integer NOT NULL,
198 sensors character(10) NOT NULL,
200 PRIMARY KEY (foo, bar, hello, goodbye)
204 -- Table: fourkeys_to_twokeys
206 CREATE TABLE fourkeys_to_twokeys (
207 f_foo integer NOT NULL,
208 f_bar integer NOT NULL,
209 f_hello integer NOT NULL,
210 f_goodbye integer NOT NULL,
211 t_artist integer NOT NULL,
212 t_cd integer NOT NULL,
213 autopilot character NOT NULL,
214 pilot_sequence integer,
215 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
218 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);
220 CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_twokeys (t_artist, t_cd);
226 genreid INTEGER PRIMARY KEY NOT NULL,
227 name varchar(100) NOT NULL
230 CREATE UNIQUE INDEX genre_name_genre ON genre (name);
235 CREATE TABLE images (
236 id INTEGER PRIMARY KEY NOT NULL,
237 artwork_id integer NOT NULL,
238 name varchar(100) NOT NULL,
242 CREATE INDEX images_idx_artwork_id_images ON images (artwork_id);
245 -- Table: liner_notes
247 CREATE TABLE liner_notes (
248 liner_id INTEGER PRIMARY KEY NOT NULL,
249 notes varchar(100) NOT NULL
252 CREATE INDEX liner_notes_idx_liner_id_liner ON liner_notes (liner_id);
258 id INTEGER PRIMARY KEY NOT NULL,
264 -- Table: lyric_versions
266 CREATE TABLE lyric_versions (
267 id INTEGER PRIMARY KEY NOT NULL,
268 lyric_id integer NOT NULL,
269 text varchar(100) NOT NULL
272 CREATE INDEX lyric_versions_idx_lyric_id_ly ON lyric_versions (lyric_id);
277 CREATE TABLE lyrics (
278 lyric_id INTEGER PRIMARY KEY NOT NULL,
279 track_id integer NOT NULL
282 CREATE INDEX lyrics_idx_track_id_lyrics ON lyrics (track_id);
285 -- Table: noprimarykey
287 CREATE TABLE noprimarykey (
288 foo integer NOT NULL,
289 bar integer NOT NULL,
293 CREATE UNIQUE INDEX foo_bar_noprimarykey ON noprimarykey (foo, bar);
298 CREATE TABLE onekey (
299 id INTEGER PRIMARY KEY NOT NULL,
300 artist integer NOT NULL,
307 CREATE TABLE owners (
308 id INTEGER PRIMARY KEY NOT NULL,
309 name varchar(100) NOT NULL
315 CREATE TABLE producer (
316 producerid INTEGER PRIMARY KEY NOT NULL,
317 name varchar(100) NOT NULL
320 CREATE UNIQUE INDEX prod_name_producer ON producer (name);
325 CREATE TABLE self_ref (
326 id INTEGER PRIMARY KEY NOT NULL,
327 name varchar(100) NOT NULL
331 -- Table: self_ref_alias
333 CREATE TABLE self_ref_alias (
334 self_ref integer NOT NULL,
335 alias integer NOT NULL,
336 PRIMARY KEY (self_ref, alias)
339 CREATE INDEX self_ref_alias_idx_alias_self_ ON self_ref_alias (alias);
341 CREATE INDEX self_ref_alias_idx_self_ref_se ON self_ref_alias (self_ref);
344 -- Table: sequence_test
346 CREATE TABLE sequence_test (
347 pkid1 integer NOT NULL,
348 pkid2 integer NOT NULL,
349 nonpkid integer NOT NULL,
351 PRIMARY KEY (pkid1, pkid2)
357 CREATE TABLE serialized (
358 id INTEGER PRIMARY KEY NOT NULL,
359 serialized text NOT NULL
366 tagid INTEGER PRIMARY KEY NOT NULL,
368 tag varchar(100) NOT NULL
371 CREATE INDEX tags_idx_cd_tags ON tags (cd);
377 trackid INTEGER PRIMARY KEY NOT NULL,
379 position integer NOT NULL,
380 title varchar(100) NOT NULL,
381 last_updated_on datetime,
382 last_updated_at datetime
385 CREATE INDEX track_idx_cd_track ON track (cd);
387 CREATE UNIQUE INDEX track_cd_position_track ON track (cd, position);
389 CREATE UNIQUE INDEX track_cd_title_track ON track (cd, title);
394 CREATE TABLE treelike (
395 id INTEGER PRIMARY KEY NOT NULL,
397 name varchar(100) NOT NULL
400 CREATE INDEX treelike_idx_parent_treelike ON treelike (parent);
403 -- Table: twokeytreelike
405 CREATE TABLE twokeytreelike (
406 id1 integer NOT NULL,
407 id2 integer NOT NULL,
408 parent1 integer NOT NULL,
409 parent2 integer NOT NULL,
410 name varchar(100) NOT NULL,
411 PRIMARY KEY (id1, id2)
414 CREATE INDEX twokeytreelike_idx_parent1_parent2_twokeytre ON twokeytreelike (parent1, parent2);
416 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike ON twokeytreelike (name);
421 CREATE TABLE twokeys (
422 artist integer NOT NULL,
424 PRIMARY KEY (artist, cd)
427 CREATE INDEX twokeys_idx_artist_twokeys ON twokeys (artist);
430 -- Table: typed_object
432 CREATE TABLE typed_object (
433 objectid INTEGER PRIMARY KEY NOT NULL,
434 type varchar(100) NOT NULL,
435 value varchar(100) NOT NULL
441 CREATE VIEW year2000cds AS
442 SELECT cdid, artist, title FROM cd WHERE year ='2000';