2 artistid INTEGER PRIMARY KEY NOT NULL,
8 CREATE TABLE collection (
9 collectionid INTEGER PRIMARY KEY NOT NULL,
10 name varchar(100) NOT NULL
13 CREATE TABLE encoded (
14 id INTEGER PRIMARY KEY NOT NULL,
19 id INTEGER PRIMARY KEY NOT NULL,
20 starts_at varchar(20) NOT NULL,
21 created_on varchar(20) NOT NULL,
22 varchar_date varchar(20),
23 varchar_datetime varchar(20),
24 skip_inflation varchar(20),
25 ts_without_tz varchar(20)
28 CREATE TABLE fourkeys (
31 hello integer NOT NULL,
32 goodbye integer NOT NULL,
33 sensors char(10) NOT NULL,
35 PRIMARY KEY (foo, bar, hello, goodbye)
39 genreid INTEGER PRIMARY KEY NOT NULL,
40 name varchar(100) NOT NULL
44 id INTEGER PRIMARY KEY NOT NULL,
45 artwork_id integer NOT NULL,
46 name varchar(100) NOT NULL,
51 id INTEGER PRIMARY KEY NOT NULL,
56 CREATE TABLE noprimarykey (
63 id INTEGER PRIMARY KEY NOT NULL,
64 artist integer NOT NULL,
69 id INTEGER PRIMARY KEY NOT NULL,
70 name varchar(100) NOT NULL
73 CREATE TABLE producer (
74 producerid INTEGER PRIMARY KEY NOT NULL,
75 name varchar(100) NOT NULL
78 CREATE TABLE self_ref (
79 id INTEGER PRIMARY KEY NOT NULL,
80 name varchar(100) NOT NULL
83 CREATE TABLE sequence_test (
84 pkid1 integer NOT NULL,
85 pkid2 integer NOT NULL,
86 nonpkid integer NOT NULL,
88 PRIMARY KEY (pkid1, pkid2)
91 CREATE TABLE serialized (
92 id INTEGER PRIMARY KEY NOT NULL,
93 serialized text NOT NULL
96 CREATE TABLE treelike (
97 id INTEGER PRIMARY KEY NOT NULL,
99 name varchar(100) NOT NULL,
103 CREATE TABLE twokeytreelike (
104 id1 integer NOT NULL,
105 id2 integer NOT NULL,
106 parent1 integer NOT NULL,
107 parent2 integer NOT NULL,
108 name varchar(100) NOT NULL,
109 PRIMARY KEY (id1, id2),
113 CREATE TABLE typed_object (
114 objectid INTEGER PRIMARY KEY NOT NULL,
115 type varchar(100) NOT NULL,
116 value varchar(100) NOT NULL
119 CREATE TABLE artist_undirected_map (
120 id1 integer NOT NULL,
121 id2 integer NOT NULL,
122 PRIMARY KEY (id1, id2),
127 CREATE TABLE artwork_to_artist (
128 artwork_cd_id integer NOT NULL,
129 artist_id integer NOT NULL,
130 PRIMARY KEY (artwork_cd_id, artist_id),
134 CREATE TABLE bookmark (
135 id INTEGER PRIMARY KEY NOT NULL,
141 id INTEGER PRIMARY KEY NOT NULL,
142 source varchar(100) NOT NULL,
143 owner integer NOT NULL,
144 title varchar(100) NOT NULL,
149 CREATE TABLE employee (
150 employee_id INTEGER PRIMARY KEY NOT NULL,
151 position integer NOT NULL,
160 CREATE TABLE forceforeign (
161 artist INTEGER PRIMARY KEY NOT NULL,
166 CREATE TABLE self_ref_alias (
167 self_ref integer NOT NULL,
168 alias integer NOT NULL,
169 PRIMARY KEY (self_ref, alias),
175 trackid INTEGER PRIMARY KEY NOT NULL,
177 position int NOT NULL,
178 title varchar(100) NOT NULL,
179 last_updated_on varchar(20),
180 last_updated_at varchar(20),
185 cdid INTEGER PRIMARY KEY NOT NULL,
186 artist integer NOT NULL,
187 title varchar(100) NOT NULL,
188 year varchar(100) NOT NULL,
190 single_track integer,
196 CREATE TABLE collection_object (
197 collection integer NOT NULL,
198 object integer NOT NULL,
199 PRIMARY KEY (collection, object),
204 CREATE TABLE lyrics (
205 lyric_id INTEGER PRIMARY KEY NOT NULL,
206 track_id integer NOT NULL,
210 CREATE TABLE liner_notes (
211 liner_id INTEGER PRIMARY KEY NOT NULL,
212 notes varchar(100) NOT NULL,
216 CREATE TABLE lyric_versions (
217 id INTEGER PRIMARY KEY NOT NULL,
218 lyric_id integer NOT NULL,
219 texta varchar(100) NOT NULL,
224 tagid INTEGER PRIMARY KEY NOT NULL,
226 tag varchar(100) NOT NULL,
230 CREATE TABLE cd_to_producer (
232 producer integer NOT NULL,
234 PRIMARY KEY (cd, producer),
239 CREATE TABLE twokeys (
240 artist integer NOT NULL,
242 PRIMARY KEY (artist, cd),
247 CREATE TABLE fourkeys_to_twokeys (
248 f_foo integer NOT NULL,
249 f_bar integer NOT NULL,
250 f_hello integer NOT NULL,
251 f_goodbye integer NOT NULL,
252 t_artist integer NOT NULL,
253 t_cd integer NOT NULL,
254 autopilot char NOT NULL,
255 pilot_sequence integer,
256 PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd),