2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Sun Nov 16 10:43:11 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,
65 CREATE INDEX cd_idx_artist_cd ON cd (artist);
66 CREATE INDEX cd_idx_genreid_cd ON cd (genreid);
67 CREATE INDEX cd_idx_single_track_cd ON cd (single_track);
68 CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title);
71 -- Table: cd_to_producer
73 CREATE TABLE cd_to_producer (
75 producer integer NOT NULL,
76 PRIMARY KEY (cd, producer)
79 CREATE INDEX cd_to_producer_idx_cd_cd_to_pr ON cd_to_producer (cd);
80 CREATE INDEX cd_to_producer_idx_producer_cd ON cd_to_producer (producer);
85 CREATE TABLE collection (
86 collectionid INTEGER PRIMARY KEY NOT NULL,
87 name varchar(100) NOT NULL
92 -- Table: collection_object
94 CREATE TABLE collection_object (
95 collection integer NOT NULL,
96 object integer NOT NULL,
97 PRIMARY KEY (collection, object)
100 CREATE INDEX collection_object_idx_collection_collection_obj ON collection_object (collection);
101 CREATE INDEX collection_object_idx_object_c ON collection_object (object);
106 CREATE TABLE employee (
107 employee_id INTEGER PRIMARY KEY NOT NULL,
108 position integer NOT NULL,
119 id INTEGER PRIMARY KEY NOT NULL,
120 starts_at datetime NOT NULL,
121 created_on timestamp NOT NULL,
122 varchar_date varchar(20),
123 varchar_datetime varchar(20),
124 skip_inflation datetime
129 -- Table: file_columns
131 CREATE TABLE file_columns (
132 id INTEGER PRIMARY KEY NOT NULL,
133 file varchar(255) NOT NULL
138 -- Table: forceforeign
140 CREATE TABLE forceforeign (
141 artist INTEGER PRIMARY KEY NOT NULL,
145 CREATE INDEX forceforeign_idx_artist_forcef ON forceforeign (artist);
150 CREATE TABLE fourkeys (
151 foo integer NOT NULL,
152 bar integer NOT NULL,
153 hello integer NOT NULL,
154 goodbye integer NOT NULL,
155 sensors character NOT NULL,
156 PRIMARY KEY (foo, bar, hello, goodbye)
161 -- Table: fourkeys_to_twokeys
163 CREATE TABLE fourkeys_to_twokeys (
164 f_foo integer NOT NULL,
165 f_bar integer NOT NULL,
166 f_hello integer NOT NULL,
167 f_goodbye integer NOT NULL,
168 t_artist integer NOT NULL,
169 t_cd integer NOT NULL,
170 autopilot character NOT NULL,
171 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
174 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);
175 CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_twokeys (t_artist, t_cd);
181 genreid INTEGER PRIMARY KEY NOT NULL,
182 name varchar(100) NOT NULL
185 CREATE UNIQUE INDEX genre_name_genre ON genre (name);
188 -- Table: liner_notes
190 CREATE TABLE liner_notes (
191 liner_id INTEGER PRIMARY KEY NOT NULL,
192 notes varchar(100) NOT NULL
195 CREATE INDEX liner_notes_idx_liner_id_liner ON liner_notes (liner_id);
201 id INTEGER PRIMARY KEY NOT NULL,
208 -- Table: noprimarykey
210 CREATE TABLE noprimarykey (
211 foo integer NOT NULL,
212 bar integer NOT NULL,
216 CREATE UNIQUE INDEX foo_bar_noprimarykey ON noprimarykey (foo, bar);
221 CREATE TABLE onekey (
222 id INTEGER PRIMARY KEY NOT NULL,
223 artist integer NOT NULL,
231 CREATE TABLE owners (
232 ownerid INTEGER PRIMARY KEY NOT NULL,
233 name varchar(100) NOT NULL
240 CREATE TABLE producer (
241 producerid INTEGER PRIMARY KEY NOT NULL,
242 name varchar(100) NOT NULL
245 CREATE UNIQUE INDEX prod_name_producer ON producer (name);
250 CREATE TABLE self_ref (
251 id INTEGER PRIMARY KEY NOT NULL,
252 name varchar(100) NOT NULL
257 -- Table: self_ref_alias
259 CREATE TABLE self_ref_alias (
260 self_ref integer NOT NULL,
261 alias integer NOT NULL,
262 PRIMARY KEY (self_ref, alias)
265 CREATE INDEX self_ref_alias_idx_alias_self_ ON self_ref_alias (alias);
266 CREATE INDEX self_ref_alias_idx_self_ref_se ON self_ref_alias (self_ref);
269 -- Table: sequence_test
271 CREATE TABLE sequence_test (
272 pkid1 integer NOT NULL,
273 pkid2 integer NOT NULL,
274 nonpkid integer NOT NULL,
276 PRIMARY KEY (pkid1, pkid2)
283 CREATE TABLE serialized (
284 id INTEGER PRIMARY KEY NOT NULL,
285 serialized text NOT NULL
293 tagid INTEGER PRIMARY KEY NOT NULL,
295 tag varchar(100) NOT NULL
298 CREATE INDEX tags_idx_cd_tags ON tags (cd);
304 trackid INTEGER PRIMARY KEY NOT NULL,
306 position integer NOT NULL,
307 title varchar(100) NOT NULL,
308 last_updated_on datetime
311 CREATE INDEX track_idx_cd_track ON track (cd);
312 CREATE UNIQUE INDEX track_cd_position_track ON track (cd, position);
313 CREATE UNIQUE INDEX track_cd_title_track ON track (cd, title);
318 CREATE TABLE treelike (
319 id INTEGER PRIMARY KEY NOT NULL,
321 name varchar(100) NOT NULL
324 CREATE INDEX treelike_idx_parent_treelike ON treelike (parent);
327 -- Table: twokeytreelike
329 CREATE TABLE twokeytreelike (
330 id1 integer NOT NULL,
331 id2 integer NOT NULL,
332 parent1 integer NOT NULL,
333 parent2 integer NOT NULL,
334 name varchar(100) NOT NULL,
335 PRIMARY KEY (id1, id2)
338 CREATE INDEX twokeytreelike_idx_parent1_parent2_twokeytre ON twokeytreelike (parent1, parent2);
339 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike ON twokeytreelike (name);
344 CREATE TABLE twokeys (
345 artist integer NOT NULL,
347 PRIMARY KEY (artist, cd)
350 CREATE INDEX twokeys_idx_artist_twokeys ON twokeys (artist);
353 -- Table: typed_object
355 CREATE TABLE typed_object (
356 objectid INTEGER PRIMARY KEY NOT NULL,
357 type varchar(100) NOT NULL,
358 value varchar(100) NOT NULL