Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Loki (Diskussion | Beiträge) (-illustrations_source (02.03.2016) - bis auf 4160 43, war schon in der Datenbank id_illustration 53192) |
(Terese Nielsen, Tom Gianni und Marc Sintes verschoben) |
||
| Zeile 34: | Zeile 34: | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 133, 'illustration'); | INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 133, 'illustration'); | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 6880, 'illustration'); | INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 6880, 'illustration'); | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 1380, 'illustration'); | |||
</pre> | </pre> | ||
| Zeile 54: | Zeile 55: | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5763, 'illustration'); | INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5763, 'illustration'); | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 40, 'illustration'); | INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 40, 'illustration'); | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 1380, 'illustration'); | |||
</pre> | </pre> | ||
| Zeile 104: | Zeile 106: | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3862, 'illustration', 'Color'); | INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3862, 'illustration', 'Color'); | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4305, 'illustration', 'Color'); | INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4305, 'illustration', 'Color'); | ||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8427, 'illustration', 'Color'); | |||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4305, 'illustration', 'Color'); | |||
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6802, 'illustration', 'Color'); | |||
</pre> | </pre> | ||
| Zeile 111: | Zeile 116: | ||
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Ho', 'Patrick'); | INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Ho', 'Patrick'); | ||
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Fischer', 'Scott'); | INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Fischer', 'Scott'); | ||
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gregory', 'Barry'); | INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gregory', 'Barry'); | ||
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Goleash', 'Grant'); | INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Goleash', 'Grant'); | ||
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Petersen', 'John'); | INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Petersen', 'John'); | ||
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Grierson', 'Katy'); | INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Grierson', 'Katy'); | ||
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Sondered', 'David'); | INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Sondered', 'David'); | ||
Version vom 3. März 2016, 11:41 Uhr
Erweiterung
INSERT INTO contributors(forename_first) VALUES('Liam.C');
INSERT INTO contributors(surname, forename_first) VALUES('Petrov', 'Miroslav');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Manold', 'Alyssa', 'Ann');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Thiesen', 'James', 'Joseph');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(446, 'http://widulinskiart.carbonmade.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3010, 'https://www.facebook.com/bOne77'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1588, 'https://www.facebook.com/groups/114658181901791'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'https://www.facebook.com/arndt.drechsler'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.facebook.com/MichaelRookardArt'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6115, 'https://www.facebook.com/peter.bergting');
Chrome Flesh:
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8545, 'cover art'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 2331, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8147, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 2310, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 3402, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 4485, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8102, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 903, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8964, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 5763, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 133, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 6880, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 1380, 'illustration');
Data Trails:
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 6698, 'cover art'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5140, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2331, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8123, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8147, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2310, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 4662, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 3402, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 3904, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8545, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2568, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 903, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8964, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5880, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5763, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 40, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 1380, 'illustration');
Rigger 5.0:
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8227, 'cover art'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 4662, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 3402, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8545, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 4485, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 5837, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 903, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8964, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 6880, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 446, 'illustration'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 458, 'illustration');
Shadowrun TCG:
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5699, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4080, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5475, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 13, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6666, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6131, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1009, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5790, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1588, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7645, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4180, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3557, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8123, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3963, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 9243, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4845, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1212, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3536, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 2820, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 9435, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7832, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4302, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7842, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1628, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 2792, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6115, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8207, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6937, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4962, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3862, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4305, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8427, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4305, 'illustration', 'Color'); INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6802, 'illustration', 'Color');
Folgende Contributors fehlen (aus Chrome Flesh, Rigger 5.0, Data Trails und Shadowrun TCG, müssen dann auch alle noch in contributions eingetragen werden). Mit Ausnahme des TCGs (erster Block), wo die Namen direkt von den Karten kommen, habe ich die Namen direkt aus den CGL-Credits und nicht aus dem Internet, kann also sein, dass die noch falsch sind (CGL ist da sehr nachlässig):
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Hudson', 'Heather'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Ho', 'Patrick'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Fischer', 'Scott'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gregory', 'Barry'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Goleash', 'Grant'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Petersen', 'John'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Grierson', 'Katy'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Sondered', 'David'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Vasburg', 'Erich'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Garcia', 'Andre'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Mizzoni', 'Marco'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Peuler', 'Chris'); INSERT INTO contributors(id_contributor, surname, forename_second, forename_first) VALUES(+[ID], 'Webster', 'Cory', 'James');
Und hier mal ein erster Schwung für contributions_illustration (Shadow Spells, Street Grimoire, Data Trails):
Street Grimoire: INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 271835); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 824173); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 917520); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 693025); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 745098); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 102698); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8545, 450739); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8545, 412756); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5763, 624135); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8051, 983270); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 384560); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 74281); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6346, 596048); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6131, 715824); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 437956); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 602948); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 980342); Data Trails: INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6698, 816904); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6698, 491302); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 712869); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 265013); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 27319); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 618974); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5763, 410625); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5880, 562419); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(4662, 970358); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8964, 481253);
Update vom 02.03.2016:
contributions 8051 6427 illustration u Color 6346 6427 illustration u Color 5790 7366 illustration u Color 7645 7366 illustration u Color 3862 7366 illustration u Color
Korrektur
Dopplungen?
- 3077 - Joshua Howell
- 7157 - Joshua Rowell
- 7468 - Larry Almore
- 8047 - Larry Elmore
- 5665 - Jacob Glaser
- 8919 - Jason Glaser