2 -- Created by SQL::Translator::Producer::SQLite
3 -- Created on Thu Jun 6 23:36:19 2006
10 CREATE TABLE employee (
11 employee_id INTEGER PRIMARY KEY NOT NULL,
12 position integer NOT NULL,
20 CREATE TABLE serialized (
21 id INTEGER PRIMARY KEY NOT NULL,
22 serialized text NOT NULL
26 -- Table: cd_to_producer
28 CREATE TABLE cd_to_producer (
30 producer integer NOT NULL,
31 PRIMARY KEY (cd, producer)
37 CREATE TABLE liner_notes (
38 liner_id INTEGER PRIMARY KEY NOT NULL,
39 notes varchar(100) NOT NULL
46 artistid INTEGER PRIMARY KEY NOT NULL,
51 -- Table: fourkeys_to_twokeys
53 CREATE TABLE fourkeys_to_twokeys (
54 f_foo integer NOT NULL,
55 f_bar integer NOT NULL,
56 f_hello integer NOT NULL,
57 f_goodbye integer NOT NULL,
58 t_artist integer NOT NULL,
59 t_cd integer NOT NULL,
60 autopilot character NOT NULL,
61 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd)
65 -- Table: twokeytreelike
67 CREATE TABLE twokeytreelike (
70 parent1 integer NOT NULL,
71 parent2 integer NOT NULL,
72 name varchar(100) NOT NULL,
73 PRIMARY KEY (id1, id2)
77 -- Table: self_ref_alias
79 CREATE TABLE self_ref_alias (
80 self_ref integer NOT NULL,
81 alias integer NOT NULL,
82 PRIMARY KEY (self_ref, alias)
89 cdid INTEGER PRIMARY KEY NOT NULL,
90 artist integer NOT NULL,
91 title varchar(100) NOT NULL,
92 year varchar(100) NOT NULL
98 CREATE TABLE bookmark (
99 id INTEGER PRIMARY KEY NOT NULL,
100 link integer NOT NULL
107 trackid INTEGER PRIMARY KEY NOT NULL,
109 position integer NOT NULL,
110 title varchar(100) NOT NULL
116 CREATE TABLE treelike (
117 id INTEGER PRIMARY KEY NOT NULL,
118 parent integer NOT NULL,
119 name varchar(100) NOT NULL
125 CREATE TABLE self_ref (
126 id INTEGER PRIMARY KEY NOT NULL,
127 name varchar(100) NOT NULL
134 id INTEGER PRIMARY KEY NOT NULL,
143 tagid INTEGER PRIMARY KEY NOT NULL,
145 tag varchar(100) NOT NULL
152 id INTEGER PRIMARY KEY NOT NULL,
153 starts_at datetime NOT NULL,
154 created_on timestamp NOT NULL
160 CREATE TABLE twokeys (
161 artist integer NOT NULL,
163 PRIMARY KEY (artist, cd)
169 CREATE TABLE fourkeys (
170 foo integer NOT NULL,
171 bar integer NOT NULL,
172 hello integer NOT NULL,
173 goodbye integer NOT NULL,
174 sensors character NOT NULL,
175 PRIMARY KEY (foo, bar, hello, goodbye)
179 -- Table: artist_undirected_map
181 CREATE TABLE artist_undirected_map (
182 id1 integer NOT NULL,
183 id2 integer NOT NULL,
184 PRIMARY KEY (id1, id2)
190 CREATE TABLE producer (
191 producerid INTEGER PRIMARY KEY NOT NULL,
192 name varchar(100) NOT NULL
198 CREATE TABLE onekey (
199 id INTEGER PRIMARY KEY NOT NULL,
200 artist integer NOT NULL,
204 CREATE UNIQUE INDEX tktlnameunique_twokeytreelike on twokeytreelike (name);
205 CREATE UNIQUE INDEX cd_artist_title_cd on cd (artist, title);
206 CREATE UNIQUE INDEX track_cd_position_track on track (cd, position);
207 CREATE UNIQUE INDEX track_cd_title_track on track (cd, title);
208 CREATE UNIQUE INDEX prod_name_producer on producer (name);