· 9 years ago · Jan 25, 2017, 12:28 PM
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4--
5-- Datenbank: `discogs`
6--
7
8-- --------------------------------------------------------
9
10--
11-- Tabellenstruktur für Tabelle `artists`
12--
13
14CREATE TABLE IF NOT EXISTS `artists` (
15 `artistID` int(10) NOT NULL,
16 `name` varchar(256) NOT NULL,
17 `realname` varchar(256) NOT NULL,
18 `profile` text NOT NULL,
19 `data_quality` varchar(256) NOT NULL
20) ENGINE=InnoDB DEFAULT CHARSET=latin1;
21
22-- --------------------------------------------------------
23
24--
25-- Tabellenstruktur für Tabelle `artists_aliases`
26--
27
28CREATE TABLE IF NOT EXISTS `artists_aliases` (
29 `artist` int(10) NOT NULL,
30 `number` int(10) NOT NULL,
31 `name` varchar(256) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33
34-- --------------------------------------------------------
35
36--
37-- Tabellenstruktur für Tabelle `artists_groups`
38--
39
40CREATE TABLE IF NOT EXISTS `artists_groups` (
41 `artist` int(10) NOT NULL,
42 `number` int(10) NOT NULL,
43 `name` varchar(256) NOT NULL
44) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45
46-- --------------------------------------------------------
47
48--
49-- Tabellenstruktur für Tabelle `artists_images`
50--
51
52CREATE TABLE IF NOT EXISTS `artists_images` (
53 `artist` int(10) NOT NULL,
54 `number` int(10) NOT NULL,
55 `type` varchar(256) NOT NULL,
56 `width` int(10) NOT NULL,
57 `height` int(10) NOT NULL,
58 `uri` varchar(256) NOT NULL,
59 `uri150` varchar(256) NOT NULL
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61
62-- --------------------------------------------------------
63
64--
65-- Tabellenstruktur für Tabelle `artists_members`
66--
67
68CREATE TABLE IF NOT EXISTS `artists_members` (
69 `artist` int(10) NOT NULL,
70 `number` int(10) NOT NULL,
71 `member_id` int(10) NOT NULL,
72 `member_name` varchar(256) NOT NULL
73) ENGINE=InnoDB DEFAULT CHARSET=latin1;
74
75-- --------------------------------------------------------
76
77--
78-- Tabellenstruktur für Tabelle `artists_namevariations`
79--
80
81CREATE TABLE IF NOT EXISTS `artists_namevariations` (
82 `artist` int(10) NOT NULL,
83 `number` int(10) NOT NULL,
84 `name` varchar(256) NOT NULL
85) ENGINE=InnoDB DEFAULT CHARSET=latin1;
86
87-- --------------------------------------------------------
88
89--
90-- Tabellenstruktur für Tabelle `artists_urls`
91--
92
93CREATE TABLE IF NOT EXISTS `artists_urls` (
94 `artist` int(10) NOT NULL,
95 `number` int(10) NOT NULL,
96 `url` varchar(256) NOT NULL
97) ENGINE=InnoDB DEFAULT CHARSET=latin1;
98
99-- --------------------------------------------------------
100
101--
102-- Tabellenstruktur für Tabelle `labels`
103--
104
105CREATE TABLE IF NOT EXISTS `labels` (
106 `labelID` int(10) NOT NULL,
107 `name` varchar(256) NOT NULL,
108 `contactinfo` text NOT NULL,
109 `profile` text NOT NULL,
110 `parentlabel` varchar(256) NOT NULL,
111 `data_quality` varchar(256) NOT NULL
112) ENGINE=InnoDB DEFAULT CHARSET=latin1;
113
114-- --------------------------------------------------------
115
116--
117-- Tabellenstruktur für Tabelle `labels_images`
118--
119
120CREATE TABLE IF NOT EXISTS `labels_images` (
121 `label` int(10) NOT NULL,
122 `number` int(10) NOT NULL,
123 `type` varchar(256) NOT NULL,
124 `width` int(10) NOT NULL,
125 `height` int(10) NOT NULL,
126 `uri` varchar(256) NOT NULL,
127 `uri150` varchar(256) NOT NULL
128) ENGINE=InnoDB DEFAULT CHARSET=latin1;
129
130-- --------------------------------------------------------
131
132--
133-- Tabellenstruktur für Tabelle `labels_sublabels`
134--
135
136CREATE TABLE IF NOT EXISTS `labels_sublabels` (
137 `label` int(10) NOT NULL,
138 `number` int(10) NOT NULL,
139 `sublabel` varchar(256) NOT NULL
140) ENGINE=InnoDB DEFAULT CHARSET=latin1;
141
142-- --------------------------------------------------------
143
144--
145-- Tabellenstruktur für Tabelle `labels_urls`
146--
147
148CREATE TABLE IF NOT EXISTS `labels_urls` (
149 `label` int(10) NOT NULL,
150 `number` int(10) NOT NULL,
151 `url` varchar(256) NOT NULL
152) ENGINE=InnoDB DEFAULT CHARSET=latin1;
153
154-- --------------------------------------------------------
155
156--
157-- Tabellenstruktur für Tabelle `masters`
158--
159
160CREATE TABLE IF NOT EXISTS `masters` (
161 `masterID` int(10) NOT NULL,
162 `main_release` int(10) NOT NULL,
163 `year` int(10) NOT NULL,
164 `title` varchar(256) NOT NULL,
165 `data_quality` varchar(256) NOT NULL
166) ENGINE=InnoDB DEFAULT CHARSET=latin1;
167
168-- --------------------------------------------------------
169
170--
171-- Tabellenstruktur für Tabelle `masters_artists`
172--
173
174CREATE TABLE IF NOT EXISTS `masters_artists` (
175 `master` int(10) NOT NULL,
176 `number` int(10) NOT NULL,
177 `artist_id` int(10) NOT NULL,
178 `name` varchar(256) NOT NULL,
179 `anv` varchar(256) NOT NULL,
180 `jn` varchar(256) NOT NULL,
181 `role` varchar(256) NOT NULL,
182 `tracks` varchar(256) NOT NULL
183) ENGINE=InnoDB DEFAULT CHARSET=latin1;
184
185-- --------------------------------------------------------
186
187--
188-- Tabellenstruktur für Tabelle `masters_genres`
189--
190
191CREATE TABLE IF NOT EXISTS `masters_genres` (
192 `master` int(10) NOT NULL,
193 `number` int(10) NOT NULL,
194 `genre` varchar(256) NOT NULL
195) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196
197-- --------------------------------------------------------
198
199--
200-- Tabellenstruktur für Tabelle `masters_images`
201--
202
203CREATE TABLE IF NOT EXISTS `masters_images` (
204 `master` text NOT NULL,
205 `number` int(10) NOT NULL,
206 `type` varchar(256) NOT NULL,
207 `width` int(10) NOT NULL,
208 `height` int(10) NOT NULL,
209 `uri` varchar(256) NOT NULL,
210 `uri150` varchar(256) NOT NULL
211) ENGINE=InnoDB DEFAULT CHARSET=latin1;
212
213-- --------------------------------------------------------
214
215--
216-- Tabellenstruktur für Tabelle `masters_styles`
217--
218
219CREATE TABLE IF NOT EXISTS `masters_styles` (
220 `master` int(10) NOT NULL,
221 `number` int(10) NOT NULL,
222 `style` varchar(256) NOT NULL
223) ENGINE=InnoDB DEFAULT CHARSET=latin1;
224
225-- --------------------------------------------------------
226
227--
228-- Tabellenstruktur für Tabelle `masters_videos`
229--
230
231CREATE TABLE IF NOT EXISTS `masters_videos` (
232 `master` int(10) NOT NULL,
233 `number` int(10) NOT NULL,
234 `duration` int(10) NOT NULL,
235 `src` text NOT NULL,
236 `embed` varchar(256) NOT NULL,
237 `title` varchar(256) NOT NULL,
238 `description` text NOT NULL
239) ENGINE=InnoDB DEFAULT CHARSET=latin1;
240
241-- --------------------------------------------------------
242
243--
244-- Tabellenstruktur für Tabelle `releases`
245--
246
247CREATE TABLE IF NOT EXISTS `releases` (
248 `releaseID` bigint(20) NOT NULL,
249 `status` varchar(256) NOT NULL,
250 `title` varchar(256) NOT NULL,
251 `country` varchar(256) NOT NULL,
252 `releasedate` date NOT NULL,
253 `notes` text NOT NULL,
254 `master_id` int(10) NOT NULL,
255 `data_quality` varchar(256) NOT NULL
256) ENGINE=InnoDB DEFAULT CHARSET=latin1;
257
258-- --------------------------------------------------------
259
260--
261-- Tabellenstruktur für Tabelle `releases_artists`
262--
263
264CREATE TABLE IF NOT EXISTS `releases_artists` (
265 `release_id` bigint(13) NOT NULL,
266 `number` int(10) NOT NULL,
267 `artist_id` int(10) NOT NULL,
268 `name` varchar(256) NOT NULL,
269 `anv` varchar(256) NOT NULL,
270 `jn` varchar(256) NOT NULL,
271 `role` varchar(256) NOT NULL,
272 `tracks` varchar(256) NOT NULL
273) ENGINE=InnoDB DEFAULT CHARSET=latin1;
274
275-- --------------------------------------------------------
276
277--
278-- Tabellenstruktur für Tabelle `releases_companies`
279--
280
281CREATE TABLE IF NOT EXISTS `releases_companies` (
282 `release_id` bigint(13) NOT NULL,
283 `number` int(10) NOT NULL,
284 `company_id` int(10) NOT NULL,
285 `name` varchar(256) NOT NULL,
286 `catno` varchar(256) NOT NULL,
287 `entity_type` int(10) NOT NULL,
288 `entity_type_name` varchar(256) NOT NULL,
289 `resource_url` varchar(256) NOT NULL
290) ENGINE=InnoDB DEFAULT CHARSET=latin1;
291
292-- --------------------------------------------------------
293
294--
295-- Tabellenstruktur für Tabelle `releases_extraartists`
296--
297
298CREATE TABLE IF NOT EXISTS `releases_extraartists` (
299 `release_id` bigint(13) NOT NULL,
300 `number` int(10) NOT NULL,
301 `artist_id` int(10) NOT NULL,
302 `name` varchar(256) NOT NULL,
303 `anv` varchar(256) NOT NULL,
304 `jn` varchar(256) NOT NULL,
305 `role` varchar(256) NOT NULL,
306 `tracks` varchar(256) NOT NULL
307) ENGINE=InnoDB DEFAULT CHARSET=latin1;
308
309-- --------------------------------------------------------
310
311--
312-- Tabellenstruktur für Tabelle `releases_formats`
313--
314
315CREATE TABLE IF NOT EXISTS `releases_formats` (
316 `release_id` bigint(13) NOT NULL,
317 `number` int(10) NOT NULL,
318 `text` text NOT NULL,
319 `name` varchar(256) NOT NULL,
320 `quantity` varchar(256) NOT NULL
321) ENGINE=InnoDB DEFAULT CHARSET=latin1;
322
323-- --------------------------------------------------------
324
325--
326-- Tabellenstruktur für Tabelle `releases_formats_descriptions`
327--
328
329CREATE TABLE IF NOT EXISTS `releases_formats_descriptions` (
330 `release_format` int(10) NOT NULL,
331 `number` int(10) NOT NULL,
332 `description` text NOT NULL
333) ENGINE=InnoDB DEFAULT CHARSET=latin1;
334
335-- --------------------------------------------------------
336
337--
338-- Tabellenstruktur für Tabelle `releases_genres`
339--
340
341CREATE TABLE IF NOT EXISTS `releases_genres` (
342 `release_id` bigint(13) NOT NULL,
343 `number` int(10) NOT NULL,
344 `genre` varchar(256) NOT NULL
345) ENGINE=InnoDB DEFAULT CHARSET=latin1;
346
347-- --------------------------------------------------------
348
349--
350-- Tabellenstruktur für Tabelle `releases_identifiers`
351--
352
353CREATE TABLE IF NOT EXISTS `releases_identifiers` (
354 `release_id` bigint(13) NOT NULL,
355 `number` int(10) NOT NULL,
356 `type` varchar(256) NOT NULL,
357 `value` varchar(256) NOT NULL
358) ENGINE=InnoDB DEFAULT CHARSET=latin1;
359
360-- --------------------------------------------------------
361
362--
363-- Tabellenstruktur für Tabelle `releases_images`
364--
365
366CREATE TABLE IF NOT EXISTS `releases_images` (
367 `release_id` bigint(13) NOT NULL,
368 `number` int(10) NOT NULL,
369 `type` varchar(256) NOT NULL,
370 `width` int(10) NOT NULL,
371 `height` int(10) NOT NULL,
372 `uri` varchar(256) NOT NULL,
373 `uri150` varchar(256) NOT NULL
374) ENGINE=InnoDB DEFAULT CHARSET=latin1;
375
376-- --------------------------------------------------------
377
378--
379-- Tabellenstruktur für Tabelle `releases_labels`
380--
381
382CREATE TABLE IF NOT EXISTS `releases_labels` (
383 `release_id` bigint(13) NOT NULL,
384 `number` int(10) NOT NULL,
385 `catno` varchar(256) NOT NULL,
386 `name` varchar(256) NOT NULL
387) ENGINE=InnoDB DEFAULT CHARSET=latin1;
388
389-- --------------------------------------------------------
390
391--
392-- Tabellenstruktur für Tabelle `releases_styles`
393--
394
395CREATE TABLE IF NOT EXISTS `releases_styles` (
396 `release_id` bigint(13) NOT NULL,
397 `number` int(10) NOT NULL,
398 `style` varchar(256) NOT NULL
399) ENGINE=InnoDB DEFAULT CHARSET=latin1;
400
401-- --------------------------------------------------------
402
403--
404-- Tabellenstruktur für Tabelle `releases_tracks`
405--
406
407CREATE TABLE IF NOT EXISTS `releases_tracks` (
408 `trackID` bigint(20) NOT NULL,
409 `release_id` bigint(14) NOT NULL,
410 `number` int(10) NOT NULL,
411 `position` varchar(256) NOT NULL,
412 `title` varchar(256) NOT NULL,
413 `duration` varchar(256) NOT NULL
414) ENGINE=InnoDB DEFAULT CHARSET=latin1;
415
416-- --------------------------------------------------------
417
418--
419-- Tabellenstruktur für Tabelle `releases_tracks_artists`
420--
421
422CREATE TABLE IF NOT EXISTS `releases_tracks_artists` (
423 `track` bigint(20) NOT NULL,
424 `number` int(10) NOT NULL,
425 `artist_id` bigint(13) NOT NULL,
426 `name` varchar(256) NOT NULL,
427 `anv` varchar(256) NOT NULL,
428 `jn` varchar(256) NOT NULL,
429 `role` varchar(256) NOT NULL,
430 `tracks` varchar(256) NOT NULL
431) ENGINE=InnoDB DEFAULT CHARSET=latin1;
432
433-- --------------------------------------------------------
434
435--
436-- Tabellenstruktur für Tabelle `releases_tracks_extraartists`
437--
438
439CREATE TABLE IF NOT EXISTS `releases_tracks_extraartists` (
440 `track` bigint(20) NOT NULL,
441 `number` int(10) NOT NULL,
442 `artist_id` bigint(13) NOT NULL,
443 `name` varchar(256) NOT NULL,
444 `anv` varchar(256) NOT NULL,
445 `jn` varchar(256) NOT NULL,
446 `role` varchar(256) NOT NULL,
447 `tracks` varchar(256) NOT NULL
448) ENGINE=InnoDB DEFAULT CHARSET=latin1;
449
450-- --------------------------------------------------------
451
452--
453-- Tabellenstruktur für Tabelle `releases_videos`
454--
455
456CREATE TABLE IF NOT EXISTS `releases_videos` (
457 `release_id` bigint(13) NOT NULL,
458 `number` int(10) NOT NULL,
459 `duration` int(10) NOT NULL,
460 `src` text NOT NULL,
461 `embed` varchar(256) NOT NULL,
462 `title` varchar(256) NOT NULL,
463 `description` text NOT NULL
464) ENGINE=InnoDB DEFAULT CHARSET=latin1;
465
466--
467-- Indizes der exportierten Tabellen
468--
469
470--
471-- Indizes für die Tabelle `artists`
472--
473ALTER TABLE `artists`
474 ADD PRIMARY KEY (`artistID`);
475
476--
477-- Indizes für die Tabelle `labels`
478--
479ALTER TABLE `labels`
480 ADD PRIMARY KEY (`labelID`);
481
482--
483-- Indizes für die Tabelle `masters`
484--
485ALTER TABLE `masters`
486 ADD PRIMARY KEY (`masterID`);
487
488--
489-- Indizes für die Tabelle `releases`
490--
491ALTER TABLE `releases`
492 ADD PRIMARY KEY (`releaseID`);
493
494--
495-- Indizes für die Tabelle `releases_tracks`
496--
497ALTER TABLE `releases_tracks`
498 ADD PRIMARY KEY (`trackID`);
499
500--
501-- AUTO_INCREMENT für exportierte Tabellen
502--
503
504--
505-- AUTO_INCREMENT für Tabelle `artists`
506--
507ALTER TABLE `artists`
508 MODIFY `artistID` int(10) NOT NULL AUTO_INCREMENT;
509--
510-- AUTO_INCREMENT für Tabelle `labels`
511--
512ALTER TABLE `labels`
513 MODIFY `labelID` int(10) NOT NULL AUTO_INCREMENT;
514--
515-- AUTO_INCREMENT für Tabelle `masters`
516--
517ALTER TABLE `masters`
518 MODIFY `masterID` int(10) NOT NULL AUTO_INCREMENT;
519--
520-- AUTO_INCREMENT für Tabelle `releases`
521--
522ALTER TABLE `releases`
523 MODIFY `releaseID` bigint(20) NOT NULL AUTO_INCREMENT;
524--
525-- AUTO_INCREMENT für Tabelle `releases_tracks`
526--
527ALTER TABLE `releases_tracks`
528 MODIFY `trackID` bigint(20) NOT NULL AUTO_INCREMENT;
529Contact GitHub API Training Shop Blog About
530© 2017 GitHub, Inc. Terms Privacy Security Status Help