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
99 CREATE TABLE bookmark (
100 id INTEGER PRIMARY KEY NOT NULL,
101 link integer NOT NULL
108 trackid INTEGER PRIMARY KEY NOT NULL,
110 position integer NOT NULL,
111 title varchar(100) NOT NULL
117 CREATE TABLE self_ref (
118 id INTEGER PRIMARY KEY NOT NULL,
119 name varchar(100) NOT NULL
126 id INTEGER PRIMARY KEY NOT NULL,
135 tagid INTEGER PRIMARY KEY NOT NULL,
137 tag varchar(100) NOT NULL
143 CREATE TABLE treelike (
144 id INTEGER PRIMARY KEY NOT NULL,
145 parent integer NOT NULL,
146 name varchar(100) NOT NULL
153 id INTEGER PRIMARY KEY NOT NULL,
154 starts_at datetime NOT NULL,
155 created_on timestamp NOT NULL
161 CREATE TABLE twokeys (
162 artist integer NOT NULL,
164 PRIMARY KEY (artist, cd)
168 -- Table: noprimarykey
170 CREATE TABLE noprimarykey (
171 foo integer NOT NULL,
172 bar integer NOT NULL,
179 CREATE TABLE fourkeys (
180 foo integer NOT NULL,
181 bar integer NOT NULL,
182 hello integer NOT NULL,
183 goodbye integer NOT NULL,
184 sensors character NOT NULL,
185 PRIMARY KEY (foo, bar, hello, goodbye)
189 -- Table: artist_undirected_map
191 CREATE TABLE artist_undirected_map (
192 id1 integer NOT NULL,
193 id2 integer NOT NULL,
194 PRIMARY KEY (id1, id2)
200 CREATE TABLE producer (
201 producerid INTEGER PRIMARY KEY NOT NULL,
202 name varchar(100) NOT NULL
208 CREATE TABLE onekey (
209 id INTEGER PRIMARY KEY NOT NULL,
210 artist integer NOT NULL,
215 -- Table: typed_object
217 CREATE TABLE typed_object (
218 objectid INTEGER PRIMARY KEY NOT NULL,
219 type VARCHAR(100) NOT NULL,
226 CREATE TABLE collection (
227 collectionid INTEGER PRIMARY KEY NOT NULL,
232 -- Table: collection_object
234 CREATE TABLE collection_object (
235 collection INTEGER NOT NULL,
236 object INTEGER NOT NULL
242 CREATE TABLE owners (
243 ownerid INTEGER PRIMARY KEY NOT NULL,
251 id INTEGER PRIMARY KEY NOT NULL,
258 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike on twokeytreelike (name);
259 CREATE UNIQUE INDEX cd_artist_title_cd on cd (artist, title);
260 CREATE UNIQUE INDEX track_cd_position_track on track (cd, position);
261 CREATE UNIQUE INDEX track_cd_title_track on track (cd, title);
262 CREATE UNIQUE INDEX foo_bar_noprimarykey on noprimarykey (foo, bar);
263 CREATE UNIQUE INDEX prod_name_producer on producer (name);