2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Thu Nov 18 08:18:15 2010
10 artistid INTEGER PRIMARY KEY NOT NULL,
12 rank integer NOT NULL DEFAULT 13,
16 CREATE INDEX artist_name_hookidx ON artist (name);
18 CREATE UNIQUE INDEX artist_name ON artist (name);
20 CREATE UNIQUE INDEX u_nullable ON artist (charfield, rank);
23 -- Table: bindtype_test
25 CREATE TABLE bindtype_test (
26 id INTEGER PRIMARY KEY NOT NULL,
35 CREATE TABLE collection (
36 collectionid INTEGER PRIMARY KEY NOT NULL,
37 name varchar(100) NOT NULL
43 CREATE TABLE encoded (
44 id INTEGER PRIMARY KEY NOT NULL,
52 id INTEGER PRIMARY KEY NOT NULL,
53 starts_at date NOT NULL,
54 created_on timestamp NOT NULL,
55 varchar_date varchar(20),
56 varchar_datetime varchar(20),
57 skip_inflation datetime,
58 ts_without_tz datetime
62 -- Table: file_columns
64 CREATE TABLE file_columns (
65 id INTEGER PRIMARY KEY NOT NULL,
66 file varchar(255) NOT NULL
72 CREATE TABLE fourkeys (
75 hello integer NOT NULL,
76 goodbye integer NOT NULL,
77 sensors character(10) NOT NULL,
79 PRIMARY KEY (foo, bar, hello, goodbye)
86 genreid INTEGER PRIMARY KEY NOT NULL,
87 name varchar(100) NOT NULL
90 CREATE UNIQUE INDEX genre_name ON genre (name);
96 id INTEGER PRIMARY KEY NOT NULL,
104 CREATE TABLE money_test (
105 id INTEGER PRIMARY KEY NOT NULL,
110 -- Table: noprimarykey
112 CREATE TABLE noprimarykey (
113 foo integer NOT NULL,
114 bar integer NOT NULL,
118 CREATE UNIQUE INDEX foo_bar ON noprimarykey (foo, bar);
123 CREATE TABLE onekey (
124 id INTEGER PRIMARY KEY NOT NULL,
125 artist integer NOT NULL,
132 CREATE TABLE owners (
133 id INTEGER PRIMARY KEY NOT NULL,
134 name varchar(100) NOT NULL
140 CREATE TABLE producer (
141 producerid INTEGER PRIMARY KEY NOT NULL,
142 name varchar(100) NOT NULL
145 CREATE UNIQUE INDEX prod_name ON producer (name);
150 CREATE TABLE self_ref (
151 id INTEGER PRIMARY KEY NOT NULL,
152 name varchar(100) NOT NULL
156 -- Table: sequence_test
158 CREATE TABLE sequence_test (
159 pkid1 integer NOT NULL,
160 pkid2 integer NOT NULL,
161 nonpkid integer NOT NULL,
163 PRIMARY KEY (pkid1, pkid2)
169 CREATE TABLE serialized (
170 id INTEGER PRIMARY KEY NOT NULL,
171 serialized text NOT NULL
175 -- Table: timestamp_primary_key_test
177 CREATE TABLE timestamp_primary_key_test (
178 id timestamp NOT NULL DEFAULT current_timestamp,
185 CREATE TABLE treelike (
186 id INTEGER PRIMARY KEY NOT NULL,
188 name varchar(100) NOT NULL
191 CREATE INDEX treelike_idx_parent ON treelike (parent);
194 -- Table: twokeytreelike
196 CREATE TABLE twokeytreelike (
197 id1 integer NOT NULL,
198 id2 integer NOT NULL,
199 parent1 integer NOT NULL,
200 parent2 integer NOT NULL,
201 name varchar(100) NOT NULL,
202 PRIMARY KEY (id1, id2)
205 CREATE INDEX twokeytreelike_idx_parent1_parent2 ON twokeytreelike (parent1, parent2);
207 CREATE UNIQUE INDEX tktlnameunique ON twokeytreelike (name);
210 -- Table: typed_object
212 CREATE TABLE typed_object (
213 objectid INTEGER PRIMARY KEY NOT NULL,
214 type varchar(100) NOT NULL,
215 value varchar(100) NOT NULL
219 -- Table: artist_undirected_map
221 CREATE TABLE artist_undirected_map (
222 id1 integer NOT NULL,
223 id2 integer NOT NULL,
224 PRIMARY KEY (id1, id2)
227 CREATE INDEX artist_undirected_map_idx_id1 ON artist_undirected_map (id1);
229 CREATE INDEX artist_undirected_map_idx_id2 ON artist_undirected_map (id2);
234 CREATE TABLE bookmark (
235 id INTEGER PRIMARY KEY NOT NULL,
239 CREATE INDEX bookmark_idx_link ON bookmark (link);
245 id INTEGER PRIMARY KEY NOT NULL,
246 source varchar(100) NOT NULL,
247 owner integer NOT NULL,
248 title varchar(100) NOT NULL,
252 CREATE INDEX books_idx_owner ON books (owner);
254 CREATE UNIQUE INDEX books_title ON books (title);
259 CREATE TABLE employee (
260 employee_id INTEGER PRIMARY KEY NOT NULL,
261 position integer NOT NULL,
269 CREATE INDEX employee_idx_encoded ON employee (encoded);
272 -- Table: forceforeign
274 CREATE TABLE forceforeign (
275 artist INTEGER PRIMARY KEY NOT NULL,
280 -- Table: self_ref_alias
282 CREATE TABLE self_ref_alias (
283 self_ref integer NOT NULL,
284 alias integer NOT NULL,
285 PRIMARY KEY (self_ref, alias)
288 CREATE INDEX self_ref_alias_idx_alias ON self_ref_alias (alias);
290 CREATE INDEX self_ref_alias_idx_self_ref ON self_ref_alias (self_ref);
296 trackid INTEGER PRIMARY KEY NOT NULL,
298 position int NOT NULL,
299 title varchar(100) NOT NULL,
300 last_updated_on datetime,
301 last_updated_at datetime
304 CREATE INDEX track_idx_cd ON track (cd);
306 CREATE UNIQUE INDEX track_cd_position ON track (cd, position);
308 CREATE UNIQUE INDEX track_cd_title ON track (cd, title);
314 cdid INTEGER PRIMARY KEY NOT NULL,
315 artist integer NOT NULL,
316 title varchar(100) NOT NULL,
317 year varchar(100) NOT NULL,
322 CREATE INDEX cd_idx_artist ON cd (artist);
324 CREATE INDEX cd_idx_genreid ON cd (genreid);
326 CREATE INDEX cd_idx_single_track ON cd (single_track);
328 CREATE UNIQUE INDEX cd_artist_title ON cd (artist, title);
331 -- Table: collection_object
333 CREATE TABLE collection_object (
334 collection integer NOT NULL,
335 object integer NOT NULL,
336 PRIMARY KEY (collection, object)
339 CREATE INDEX collection_object_idx_collection ON collection_object (collection);
341 CREATE INDEX collection_object_idx_object ON collection_object (object);
346 CREATE TABLE lyrics (
347 lyric_id INTEGER PRIMARY KEY NOT NULL,
348 track_id integer NOT NULL
351 CREATE INDEX lyrics_idx_track_id ON lyrics (track_id);
356 CREATE TABLE cd_artwork (
357 cd_id INTEGER PRIMARY KEY NOT NULL
361 -- Table: liner_notes
363 CREATE TABLE liner_notes (
364 liner_id INTEGER PRIMARY KEY NOT NULL,
365 notes varchar(100) NOT NULL
369 -- Table: lyric_versions
371 CREATE TABLE lyric_versions (
372 id INTEGER PRIMARY KEY NOT NULL,
373 lyric_id integer NOT NULL,
374 text varchar(100) NOT NULL
377 CREATE INDEX lyric_versions_idx_lyric_id ON lyric_versions (lyric_id);
383 tagid INTEGER PRIMARY KEY NOT NULL,
385 tag varchar(100) NOT NULL
388 CREATE INDEX tags_idx_cd ON tags (cd);
390 CREATE UNIQUE INDEX tagid_cd ON tags (tagid, cd);
392 CREATE UNIQUE INDEX tagid_cd_tag ON tags (tagid, cd, tag);
394 CREATE UNIQUE INDEX tags_tagid_tag ON tags (tagid, tag);
396 CREATE UNIQUE INDEX tags_tagid_tag_cd ON tags (tagid, tag, cd);
399 -- Table: cd_to_producer
401 CREATE TABLE cd_to_producer (
403 producer integer NOT NULL,
405 PRIMARY KEY (cd, producer)
408 CREATE INDEX cd_to_producer_idx_cd ON cd_to_producer (cd);
410 CREATE INDEX cd_to_producer_idx_producer ON cd_to_producer (producer);
415 CREATE TABLE images (
416 id INTEGER PRIMARY KEY NOT NULL,
417 artwork_id integer NOT NULL,
418 name varchar(100) NOT NULL,
422 CREATE INDEX images_idx_artwork_id ON images (artwork_id);
427 CREATE TABLE twokeys (
428 artist integer NOT NULL,
430 PRIMARY KEY (artist, cd)
433 CREATE INDEX twokeys_idx_artist ON twokeys (artist);
436 -- Table: artwork_to_artist
438 CREATE TABLE artwork_to_artist (
439 artwork_cd_id integer NOT NULL,
440 artist_id integer NOT NULL,
441 PRIMARY KEY (artwork_cd_id, artist_id)
444 CREATE INDEX artwork_to_artist_idx_artist_id ON artwork_to_artist (artist_id);
446 CREATE INDEX artwork_to_artist_idx_artwork_cd_id ON artwork_to_artist (artwork_cd_id);
449 -- Table: fourkeys_to_twokeys
451 CREATE TABLE fourkeys_to_twokeys (
452 f_foo integer NOT NULL,
453 f_bar integer NOT NULL,
454 f_hello integer NOT NULL,
455 f_goodbye integer NOT NULL,
456 t_artist integer NOT NULL,
457 t_cd integer NOT NULL,
458 autopilot character NOT NULL,
459 pilot_sequence integer,
460 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
463 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);
465 CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd ON fourkeys_to_twokeys (t_artist, t_cd);
470 CREATE VIEW year2000cds AS
471 SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000";