2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Sun Nov 9 16:28:17 2008
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 bookmark (
35 id INTEGER PRIMARY KEY NOT NULL,
39 CREATE INDEX bookmark_idx_link_bookmark ON bookmark (link);
45 id INTEGER PRIMARY KEY NOT NULL,
46 source varchar(100) NOT NULL,
47 owner integer NOT NULL,
48 title varchar(100) NOT NULL,
57 cdid INTEGER PRIMARY KEY NOT NULL,
58 artist integer NOT NULL,
59 title varchar(100) NOT NULL,
60 year varchar(100) NOT NULL,
64 CREATE INDEX cd_idx_artist_cd ON cd (artist);
65 CREATE INDEX cd_idx_genreid_cd ON cd (genreid);
66 CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title);
69 -- Table: cd_to_producer
71 CREATE TABLE cd_to_producer (
73 producer integer NOT NULL,
74 PRIMARY KEY (cd, producer)
77 CREATE INDEX cd_to_producer_idx_cd_cd_to_pr ON cd_to_producer (cd);
78 CREATE INDEX cd_to_producer_idx_producer_cd ON cd_to_producer (producer);
83 CREATE TABLE collection (
84 collectionid INTEGER PRIMARY KEY NOT NULL,
85 name varchar(100) NOT NULL
90 -- Table: collection_object
92 CREATE TABLE collection_object (
93 collection integer NOT NULL,
94 object integer NOT NULL,
95 PRIMARY KEY (collection, object)
98 CREATE INDEX collection_object_idx_collection_collection_obj ON collection_object (collection);
99 CREATE INDEX collection_object_idx_object_c ON collection_object (object);
104 CREATE TABLE employee (
105 employee_id INTEGER PRIMARY KEY NOT NULL,
106 position integer NOT NULL,
117 id INTEGER PRIMARY KEY NOT NULL,
118 starts_at datetime NOT NULL,
119 created_on timestamp NOT NULL,
120 varchar_date varchar(20),
121 varchar_datetime varchar(20),
122 skip_inflation datetime
127 -- Table: file_columns
129 CREATE TABLE file_columns (
130 id INTEGER PRIMARY KEY NOT NULL,
131 file varchar(255) NOT NULL
136 -- Table: forceforeign
138 CREATE TABLE forceforeign (
139 artist INTEGER PRIMARY KEY NOT NULL,
143 CREATE INDEX forceforeign_idx_artist_forcef ON forceforeign (artist);
148 CREATE TABLE fourkeys (
149 foo integer NOT NULL,
150 bar integer NOT NULL,
151 hello integer NOT NULL,
152 goodbye integer NOT NULL,
153 sensors character NOT NULL,
154 PRIMARY KEY (foo, bar, hello, goodbye)
159 -- Table: fourkeys_to_twokeys
161 CREATE TABLE fourkeys_to_twokeys (
162 f_foo integer NOT NULL,
163 f_bar integer NOT NULL,
164 f_hello integer NOT NULL,
165 f_goodbye integer NOT NULL,
166 t_artist integer NOT NULL,
167 t_cd integer NOT NULL,
168 autopilot character NOT NULL,
169 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
172 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);
173 CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_twokeys (t_artist, t_cd);
179 genreid INTEGER PRIMARY KEY NOT NULL,
180 name varchar(100) NOT NULL
183 CREATE UNIQUE INDEX genre_name_genre ON genre (name);
186 -- Table: liner_notes
188 CREATE TABLE liner_notes (
189 liner_id INTEGER PRIMARY KEY NOT NULL,
190 notes varchar(100) NOT NULL
198 id INTEGER PRIMARY KEY NOT NULL,
205 -- Table: noprimarykey
207 CREATE TABLE noprimarykey (
208 foo integer NOT NULL,
209 bar integer NOT NULL,
213 CREATE UNIQUE INDEX foo_bar_noprimarykey ON noprimarykey (foo, bar);
218 CREATE TABLE onekey (
219 id INTEGER PRIMARY KEY NOT NULL,
220 artist integer NOT NULL,
228 CREATE TABLE owners (
229 ownerid INTEGER PRIMARY KEY NOT NULL,
230 name varchar(100) NOT NULL
237 CREATE TABLE producer (
238 producerid INTEGER PRIMARY KEY NOT NULL,
239 name varchar(100) NOT NULL
242 CREATE UNIQUE INDEX prod_name_producer ON producer (name);
247 CREATE TABLE self_ref (
248 id INTEGER PRIMARY KEY NOT NULL,
249 name varchar(100) NOT NULL
254 -- Table: self_ref_alias
256 CREATE TABLE self_ref_alias (
257 self_ref integer NOT NULL,
258 alias integer NOT NULL,
259 PRIMARY KEY (self_ref, alias)
262 CREATE INDEX self_ref_alias_idx_alias_self_ ON self_ref_alias (alias);
263 CREATE INDEX self_ref_alias_idx_self_ref_se ON self_ref_alias (self_ref);
266 -- Table: sequence_test
268 CREATE TABLE sequence_test (
269 pkid1 integer NOT NULL,
270 pkid2 integer NOT NULL,
271 nonpkid integer NOT NULL,
273 PRIMARY KEY (pkid1, pkid2)
280 CREATE TABLE serialized (
281 id INTEGER PRIMARY KEY NOT NULL,
282 serialized text NOT NULL
290 tagid INTEGER PRIMARY KEY NOT NULL,
292 tag varchar(100) NOT NULL
295 CREATE INDEX tags_idx_cd_tags ON tags (cd);
301 trackid INTEGER PRIMARY KEY NOT NULL,
303 position integer NOT NULL,
304 title varchar(100) NOT NULL,
305 last_updated_on datetime
308 CREATE INDEX track_idx_cd_track ON track (cd);
309 CREATE UNIQUE INDEX track_cd_position_track ON track (cd, position);
310 CREATE UNIQUE INDEX track_cd_title_track ON track (cd, title);
315 CREATE TABLE treelike (
316 id INTEGER PRIMARY KEY NOT NULL,
318 name varchar(100) NOT NULL
321 CREATE INDEX treelike_idx_parent_treelike ON treelike (parent);
324 -- Table: twokeytreelike
326 CREATE TABLE twokeytreelike (
327 id1 integer NOT NULL,
328 id2 integer NOT NULL,
329 parent1 integer NOT NULL,
330 parent2 integer NOT NULL,
331 name varchar(100) NOT NULL,
332 PRIMARY KEY (id1, id2)
335 CREATE INDEX twokeytreelike_idx_parent1_parent2_twokeytre ON twokeytreelike (parent1, parent2);
336 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike ON twokeytreelike (name);
341 CREATE TABLE twokeys (
342 artist integer NOT NULL,
344 PRIMARY KEY (artist, cd)
347 CREATE INDEX twokeys_idx_artist_twokeys ON twokeys (artist);
350 -- Table: typed_object
352 CREATE TABLE typed_object (
353 objectid INTEGER PRIMARY KEY NOT NULL,
354 type varchar(100) NOT NULL,
355 value varchar(100) NOT NULL