Commit | Line | Data |
ac50f57b |
1 | CREATE TABLE artist ( |
2 | artistid INTEGER PRIMARY KEY NOT NULL, |
3 | name varchar(100), |
4 | rank integer NOT NULL, |
5 | charfield char(10) |
6 | ); |
7 | |
8 | CREATE TABLE collection ( |
9 | collectionid INTEGER PRIMARY KEY NOT NULL, |
10 | name varchar(100) NOT NULL |
11 | ); |
12 | |
13 | CREATE TABLE encoded ( |
14 | id INTEGER PRIMARY KEY NOT NULL, |
15 | encoded varchar(100) |
16 | ); |
17 | |
18 | CREATE TABLE event ( |
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) |
26 | ); |
27 | |
28 | CREATE TABLE fourkeys ( |
29 | foo integer NOT NULL, |
30 | bar integer NOT NULL, |
31 | hello integer NOT NULL, |
32 | goodbye integer NOT NULL, |
33 | sensors char(10) NOT NULL, |
7606fd62 |
34 | read_count int, |
ac50f57b |
35 | PRIMARY KEY (foo, bar, hello, goodbye) |
36 | ); |
37 | |
38 | CREATE TABLE genre ( |
39 | genreid INTEGER PRIMARY KEY NOT NULL, |
40 | name varchar(100) NOT NULL |
41 | ); |
42 | |
7606fd62 |
43 | CREATE TABLE images ( |
44 | id INTEGER PRIMARY KEY NOT NULL, |
45 | artwork_id integer NOT NULL, |
46 | name varchar(100) NOT NULL, |
47 | data blob |
48 | ); |
49 | |
ac50f57b |
50 | CREATE TABLE link ( |
51 | id INTEGER PRIMARY KEY NOT NULL, |
52 | url varchar(100), |
53 | title varchar(100) |
54 | ); |
55 | |
56 | CREATE TABLE noprimarykey ( |
57 | foo integer NOT NULL, |
58 | bar integer NOT NULL, |
59 | baz integer NOT NULL |
60 | ); |
61 | |
62 | CREATE TABLE onekey ( |
63 | id INTEGER PRIMARY KEY NOT NULL, |
64 | artist integer NOT NULL, |
65 | cd integer NOT NULL |
66 | ); |
67 | |
68 | CREATE TABLE owners ( |
69 | id INTEGER PRIMARY KEY NOT NULL, |
70 | name varchar(100) NOT NULL |
71 | ); |
72 | |
73 | CREATE TABLE producer ( |
74 | producerid INTEGER PRIMARY KEY NOT NULL, |
75 | name varchar(100) NOT NULL |
76 | ); |
77 | |
78 | CREATE TABLE self_ref ( |
79 | id INTEGER PRIMARY KEY NOT NULL, |
80 | name varchar(100) NOT NULL |
81 | ); |
82 | |
83 | CREATE TABLE sequence_test ( |
84 | pkid1 integer NOT NULL, |
85 | pkid2 integer NOT NULL, |
86 | nonpkid integer NOT NULL, |
87 | name varchar(100), |
88 | PRIMARY KEY (pkid1, pkid2) |
89 | ); |
90 | |
91 | CREATE TABLE serialized ( |
92 | id INTEGER PRIMARY KEY NOT NULL, |
93 | serialized text NOT NULL |
94 | ); |
95 | |
96 | CREATE TABLE treelike ( |
97 | id INTEGER PRIMARY KEY NOT NULL, |
98 | parent integer, |
7606fd62 |
99 | name varchar(100) NOT NULL, |
100 | |
ac50f57b |
101 | ); |
102 | |
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, |
7606fd62 |
109 | PRIMARY KEY (id1, id2), |
110 | |
ac50f57b |
111 | ); |
112 | |
113 | CREATE TABLE typed_object ( |
114 | objectid INTEGER PRIMARY KEY NOT NULL, |
115 | type varchar(100) NOT NULL, |
116 | value varchar(100) NOT NULL |
117 | ); |
118 | |
119 | CREATE TABLE artist_undirected_map ( |
120 | id1 integer NOT NULL, |
121 | id2 integer NOT NULL, |
7606fd62 |
122 | PRIMARY KEY (id1, id2), |
123 | |
124 | |
125 | ); |
126 | |
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), |
131 | |
ac50f57b |
132 | ); |
133 | |
134 | CREATE TABLE bookmark ( |
135 | id INTEGER PRIMARY KEY NOT NULL, |
7606fd62 |
136 | link integer, |
137 | |
ac50f57b |
138 | ); |
139 | |
140 | CREATE TABLE books ( |
141 | id INTEGER PRIMARY KEY NOT NULL, |
142 | source varchar(100) NOT NULL, |
143 | owner integer NOT NULL, |
144 | title varchar(100) NOT NULL, |
7606fd62 |
145 | price integer, |
146 | |
ac50f57b |
147 | ); |
148 | |
149 | CREATE TABLE employee ( |
150 | employee_id INTEGER PRIMARY KEY NOT NULL, |
151 | position integer NOT NULL, |
152 | group_id integer, |
153 | group_id_2 integer, |
154 | group_id_3 integer, |
155 | name varchar(100), |
7606fd62 |
156 | encoded integer, |
157 | |
ac50f57b |
158 | ); |
159 | |
160 | CREATE TABLE forceforeign ( |
161 | artist INTEGER PRIMARY KEY NOT NULL, |
7606fd62 |
162 | cd integer NOT NULL, |
163 | |
ac50f57b |
164 | ); |
165 | |
166 | CREATE TABLE self_ref_alias ( |
167 | self_ref integer NOT NULL, |
168 | alias integer NOT NULL, |
7606fd62 |
169 | PRIMARY KEY (self_ref, alias), |
170 | |
171 | |
ac50f57b |
172 | ); |
173 | |
174 | CREATE TABLE track ( |
175 | trackid INTEGER PRIMARY KEY NOT NULL, |
176 | cd integer NOT NULL, |
177 | position int NOT NULL, |
178 | title varchar(100) NOT NULL, |
179 | last_updated_on varchar(20), |
7606fd62 |
180 | last_updated_at varchar(20), |
181 | |
ac50f57b |
182 | ); |
183 | |
184 | CREATE TABLE cd ( |
185 | cdid INTEGER PRIMARY KEY NOT NULL, |
186 | artist integer NOT NULL, |
187 | title varchar(100) NOT NULL, |
188 | year varchar(100) NOT NULL, |
189 | genreid integer, |
7606fd62 |
190 | single_track integer, |
191 | |
192 | |
193 | |
ac50f57b |
194 | ); |
195 | |
196 | CREATE TABLE collection_object ( |
197 | collection integer NOT NULL, |
198 | object integer NOT NULL, |
7606fd62 |
199 | PRIMARY KEY (collection, object), |
200 | |
201 | |
ac50f57b |
202 | ); |
203 | |
204 | CREATE TABLE lyrics ( |
205 | lyric_id INTEGER PRIMARY KEY NOT NULL, |
7606fd62 |
206 | track_id integer NOT NULL, |
207 | |
ac50f57b |
208 | ); |
209 | |
210 | CREATE TABLE liner_notes ( |
211 | liner_id INTEGER PRIMARY KEY NOT NULL, |
7606fd62 |
212 | notes varchar(100) NOT NULL, |
213 | |
ac50f57b |
214 | ); |
215 | |
216 | CREATE TABLE lyric_versions ( |
217 | id INTEGER PRIMARY KEY NOT NULL, |
218 | lyric_id integer NOT NULL, |
7606fd62 |
219 | texta varchar(100) NOT NULL, |
220 | |
ac50f57b |
221 | ); |
222 | |
223 | CREATE TABLE tags ( |
224 | tagid INTEGER PRIMARY KEY NOT NULL, |
225 | cd integer NOT NULL, |
7606fd62 |
226 | tag varchar(100) NOT NULL, |
227 | |
ac50f57b |
228 | ); |
229 | |
230 | CREATE TABLE cd_to_producer ( |
231 | cd integer NOT NULL, |
232 | producer integer NOT NULL, |
233 | attribute integer, |
7606fd62 |
234 | PRIMARY KEY (cd, producer), |
235 | |
ac50f57b |
236 | |
ac50f57b |
237 | ); |
238 | |
239 | CREATE TABLE twokeys ( |
240 | artist integer NOT NULL, |
241 | cd integer NOT NULL, |
7606fd62 |
242 | PRIMARY KEY (artist, cd), |
243 | |
ac50f57b |
244 | |
ac50f57b |
245 | ); |
246 | |
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, |
7606fd62 |
256 | PRIMARY KEY (f_foo, f_bar, f_hello, f_goodbye, t_artist, t_cd), |
257 | |
258 | |
ac50f57b |
259 | ); |