2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Fri Oct 24 21:31:55 2008
12 artistid INTEGER PRIMARY KEY NOT NULL,
14 rank integer NOT NULL DEFAULT '13'
19 -- Table: artist_undirected_map
21 CREATE TABLE artist_undirected_map (
24 PRIMARY KEY (id1, id2)
27 CREATE INDEX artist_undirected_map_idx_id1_ ON artist_undirected_map (id1);
28 CREATE INDEX artist_undirected_map_idx_id2_ ON artist_undirected_map (id2);
33 CREATE TABLE bookmark (
34 id INTEGER PRIMARY KEY NOT NULL,
38 CREATE INDEX bookmark_idx_link_bookmark ON bookmark (link);
44 id INTEGER PRIMARY KEY NOT NULL,
45 source varchar(100) NOT NULL,
46 owner integer NOT NULL,
47 title varchar(100) NOT NULL
55 cdid INTEGER PRIMARY KEY NOT NULL,
56 artist integer NOT NULL,
57 title varchar(100) NOT NULL,
58 year varchar(100) NOT NULL,
62 CREATE INDEX cd_idx_artist_cd ON cd (artist);
63 CREATE INDEX cd_idx_genreid_cd ON cd (genreid);
64 CREATE UNIQUE INDEX cd_artist_title_cd ON cd (artist, title);
67 -- Table: cd_to_producer
69 CREATE TABLE cd_to_producer (
71 producer integer NOT NULL,
72 PRIMARY KEY (cd, producer)
75 CREATE INDEX cd_to_producer_idx_cd_cd_to_pr ON cd_to_producer (cd);
76 CREATE INDEX cd_to_producer_idx_producer_cd ON cd_to_producer (producer);
81 CREATE TABLE collection (
82 collectionid INTEGER PRIMARY KEY NOT NULL,
83 name varchar(100) NOT NULL
88 -- Table: collection_object
90 CREATE TABLE collection_object (
91 collection integer NOT NULL,
92 object integer NOT NULL,
93 PRIMARY KEY (collection, object)
96 CREATE INDEX collection_object_idx_collection_collection_obj ON collection_object (collection);
97 CREATE INDEX collection_object_idx_object_c ON collection_object (object);
102 CREATE TABLE employee (
103 employee_id INTEGER PRIMARY KEY NOT NULL,
104 position integer NOT NULL,
115 id INTEGER PRIMARY KEY NOT NULL,
116 starts_at datetime NOT NULL,
117 created_on timestamp NOT NULL,
118 varchar_date varchar(20),
119 varchar_datetime varchar(20),
120 skip_inflation datetime(20)
125 -- Table: file_columns
127 CREATE TABLE file_columns (
128 id INTEGER PRIMARY KEY NOT NULL,
129 file varchar(255) NOT NULL
134 -- Table: forceforeign
136 CREATE TABLE forceforeign (
137 artist INTEGER PRIMARY KEY NOT NULL,
141 CREATE INDEX forceforeign_idx_artist_forcef ON forceforeign (artist);
146 CREATE TABLE fourkeys (
147 foo integer NOT NULL,
148 bar integer NOT NULL,
149 hello integer NOT NULL,
150 goodbye integer NOT NULL,
151 sensors character NOT NULL,
152 PRIMARY KEY (foo, bar, hello, goodbye)
157 -- Table: fourkeys_to_twokeys
159 CREATE TABLE fourkeys_to_twokeys (
160 f_foo integer NOT NULL,
161 f_bar integer NOT NULL,
162 f_hello integer NOT NULL,
163 f_goodbye integer NOT NULL,
164 t_artist integer NOT NULL,
165 t_cd integer NOT NULL,
166 autopilot character NOT NULL,
167 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
170 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);
171 CREATE INDEX fourkeys_to_twokeys_idx_t_artist_t_cd_fourkeys_to ON fourkeys_to_twokeys (t_artist, t_cd);
177 genreid INTEGER PRIMARY KEY NOT NULL,
178 name varchar(100) NOT NULL
181 CREATE UNIQUE INDEX genre_name_genre ON genre (name);
184 -- Table: liner_notes
186 CREATE TABLE liner_notes (
187 liner_id INTEGER PRIMARY KEY NOT NULL,
188 notes varchar(100) NOT NULL
196 id INTEGER PRIMARY KEY NOT NULL,
203 -- Table: noprimarykey
205 CREATE TABLE noprimarykey (
206 foo integer NOT NULL,
207 bar integer NOT NULL,
211 CREATE UNIQUE INDEX foo_bar_noprimarykey ON noprimarykey (foo, bar);
216 CREATE TABLE onekey (
217 id INTEGER PRIMARY KEY NOT NULL,
218 artist integer NOT NULL,
226 CREATE TABLE owners (
227 ownerid INTEGER PRIMARY KEY NOT NULL,
228 name varchar(100) NOT NULL
235 CREATE TABLE producer (
236 producerid INTEGER PRIMARY KEY NOT NULL,
237 name varchar(100) NOT NULL
240 CREATE UNIQUE INDEX prod_name_producer ON producer (name);
245 CREATE TABLE self_ref (
246 id INTEGER PRIMARY KEY NOT NULL,
247 name varchar(100) NOT NULL
252 -- Table: self_ref_alias
254 CREATE TABLE self_ref_alias (
255 self_ref integer NOT NULL,
256 alias integer NOT NULL,
257 PRIMARY KEY (self_ref, alias)
260 CREATE INDEX self_ref_alias_idx_alias_self_ ON self_ref_alias (alias);
261 CREATE INDEX self_ref_alias_idx_self_ref_se ON self_ref_alias (self_ref);
264 -- Table: sequence_test
266 CREATE TABLE sequence_test (
267 pkid1 integer NOT NULL,
268 pkid2 integer NOT NULL,
269 nonpkid integer NOT NULL,
271 PRIMARY KEY (pkid1, pkid2)
278 CREATE TABLE serialized (
279 id INTEGER PRIMARY KEY NOT NULL,
280 serialized text NOT NULL
288 tagid INTEGER PRIMARY KEY NOT NULL,
290 tag varchar(100) NOT NULL
293 CREATE INDEX tags_idx_cd_tags ON tags (cd);
299 trackid INTEGER PRIMARY KEY NOT NULL,
301 position integer NOT NULL,
302 title varchar(100) NOT NULL,
303 last_updated_on datetime
306 CREATE INDEX track_idx_cd_track ON track (cd);
307 CREATE UNIQUE INDEX track_cd_position_track ON track (cd, position);
308 CREATE UNIQUE INDEX track_cd_title_track ON track (cd, title);
313 CREATE TABLE treelike (
314 id INTEGER PRIMARY KEY NOT NULL,
316 name varchar(100) NOT NULL
319 CREATE INDEX treelike_idx_parent_treelike ON treelike (parent);
322 -- Table: twokeytreelike
324 CREATE TABLE twokeytreelike (
325 id1 integer NOT NULL,
326 id2 integer NOT NULL,
327 parent1 integer NOT NULL,
328 parent2 integer NOT NULL,
329 name varchar(100) NOT NULL,
330 PRIMARY KEY (id1, id2)
333 CREATE INDEX twokeytreelike_idx_parent1_parent2_twokeytre ON twokeytreelike (parent1, parent2);
334 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike ON twokeytreelike (name);
339 CREATE TABLE twokeys (
340 artist integer NOT NULL,
342 PRIMARY KEY (artist, cd)
345 CREATE INDEX twokeys_idx_artist_twokeys ON twokeys (artist);
348 -- Table: typed_object
350 CREATE TABLE typed_object (
351 objectid INTEGER PRIMARY KEY NOT NULL,
352 type varchar(100) NOT NULL,
353 value varchar(100) NOT NULL