2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Tue Aug 8 01:53:20 2006
10 CREATE TABLE employee (
11 employee_id INTEGER PRIMARY KEY NOT NULL,
12 position integer NOT NULL,
21 CREATE TABLE serialized (
22 id INTEGER PRIMARY KEY NOT NULL,
23 serialized text NOT NULL
29 CREATE TABLE liner_notes (
30 liner_id INTEGER PRIMARY KEY NOT NULL,
31 notes varchar(100) NOT NULL
35 -- Table: cd_to_producer
37 CREATE TABLE cd_to_producer (
39 producer integer NOT NULL,
40 PRIMARY KEY (cd, producer)
47 artistid INTEGER PRIMARY KEY NOT NULL,
52 -- Table: twokeytreelike
54 CREATE TABLE twokeytreelike (
57 parent1 integer NOT NULL,
58 parent2 integer NOT NULL,
59 name varchar(100) NOT NULL,
60 PRIMARY KEY (id1, id2)
64 -- Table: fourkeys_to_twokeys
66 CREATE TABLE fourkeys_to_twokeys (
67 f_foo integer NOT NULL,
68 f_bar integer NOT NULL,
69 f_hello integer NOT NULL,
70 f_goodbye integer NOT NULL,
71 t_artist integer NOT NULL,
72 t_cd integer NOT NULL,
73 autopilot character NOT NULL,
74 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
78 -- Table: self_ref_alias
80 CREATE TABLE self_ref_alias (
81 self_ref integer NOT NULL,
82 alias integer NOT NULL,
83 PRIMARY KEY (self_ref, alias)
90 cdid INTEGER PRIMARY KEY NOT NULL,
91 artist integer NOT NULL,
92 title varchar(100) NOT NULL,
93 year varchar(100) NOT NULL,
101 genreid INTEGER PRIMARY KEY NOT NULL,
102 name varchar(100) NOT NULL
108 CREATE TABLE bookmark (
109 id INTEGER PRIMARY KEY NOT NULL,
110 link integer NOT NULL
117 trackid INTEGER PRIMARY KEY NOT NULL,
119 position integer NOT NULL,
120 title varchar(100) NOT NULL,
121 last_updated_on datetime NULL
127 CREATE TABLE self_ref (
128 id INTEGER PRIMARY KEY NOT NULL,
129 name varchar(100) NOT NULL
136 id INTEGER PRIMARY KEY NOT NULL,
142 -- Table: file_columns
144 CREATE TABLE file_columns (
145 id INTEGER PRIMARY KEY NOT NULL,
153 tagid INTEGER PRIMARY KEY NOT NULL,
155 tag varchar(100) NOT NULL
161 CREATE TABLE treelike (
162 id INTEGER PRIMARY KEY NOT NULL,
164 name varchar(100) NOT NULL
171 id INTEGER PRIMARY KEY NOT NULL,
172 starts_at datetime NOT NULL,
173 created_on timestamp NOT NULL
179 CREATE TABLE twokeys (
180 artist integer NOT NULL,
182 PRIMARY KEY (artist, cd)
186 -- Table: noprimarykey
188 CREATE TABLE noprimarykey (
189 foo integer NOT NULL,
190 bar integer NOT NULL,
197 CREATE TABLE fourkeys (
198 foo integer NOT NULL,
199 bar integer NOT NULL,
200 hello integer NOT NULL,
201 goodbye integer NOT NULL,
202 sensors character NOT NULL,
203 PRIMARY KEY (foo, bar, hello, goodbye)
207 -- Table: artist_undirected_map
209 CREATE TABLE artist_undirected_map (
210 id1 integer NOT NULL,
211 id2 integer NOT NULL,
212 PRIMARY KEY (id1, id2)
218 CREATE TABLE producer (
219 producerid INTEGER PRIMARY KEY NOT NULL,
220 name varchar(100) NOT NULL
226 CREATE TABLE onekey (
227 id INTEGER PRIMARY KEY NOT NULL,
228 artist integer NOT NULL,
233 -- Table: typed_object
235 CREATE TABLE typed_object (
236 objectid INTEGER PRIMARY KEY NOT NULL,
237 type VARCHAR(100) NOT NULL,
244 CREATE TABLE collection (
245 collectionid INTEGER PRIMARY KEY NOT NULL,
250 -- Table: collection_object
252 CREATE TABLE collection_object (
253 collection INTEGER NOT NULL,
254 object INTEGER NOT NULL
260 CREATE TABLE owners (
261 ownerid INTEGER PRIMARY KEY NOT NULL,
269 id INTEGER PRIMARY KEY NOT NULL,
276 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike on twokeytreelike (name);
277 CREATE UNIQUE INDEX cd_artist_title_cd on cd (artist, title);
278 CREATE UNIQUE INDEX track_cd_position_track on track (cd, position);
279 CREATE UNIQUE INDEX track_cd_title_track on track (cd, title);
280 CREATE UNIQUE INDEX foo_bar_noprimarykey on noprimarykey (foo, bar);
281 CREATE UNIQUE INDEX prod_name_producer on producer (name);