Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K (Anmerkung zu fehlenden Contributors) |
Keine Bearbeitungszusammenfassung |
||
| Zeile 217: | Zeile 217: | ||
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Peuler', 'Chris'); | 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'); | INSERT INTO contributors(id_contributor, surname, forename_second, forename_first) VALUES(+[ID], 'Webster', 'Cory', 'James'); | ||
</pre> | |||
Und hier mal ein erster Schwung für contributions_illustration (Shadow Spells, Street Grimoire, Data Trails): | |||
<pre> | |||
Shadow Spells: | |||
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 326075); | |||
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 934215); | |||
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 63948); | |||
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5790, 962138); | |||
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 297816); | |||
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(7645, 207986); | |||
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(3862, 918235); | |||
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); | |||
</pre> | </pre> | ||
Version vom 1. März 2016, 17:40 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(446, 'https://www.artstation.com/artist/widulinski'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(532, 'http://hypersteve.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(717, 'http://jameswolfart.blogspot.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(766, 'http://barelynormalactivity.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(830, 'http://www.facebook.com/chad.sergesketter'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(903, 'http://www.facebook.com/victormanuel.lezamoreno'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'http://www.artflakes.com/de/shop/kunrong-yap'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'https://www.artstation.com/artist/krypt'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'http://yapkunrong.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1156, 'http://dc-concept.blogspot.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1156, 'http://danielmchavez.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1367, 'http://seanmcmurchy.blogspot.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1588, 'http://www.facebook.com/groups/114658181901791'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'http://jasonbehnke.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'http://jasonbehnke.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'https://www.facebook.com/behnkestudio'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1997, 'http://www.alexstoneart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(1997, 'http://alexstoneart.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(2002, 'https://www.artstation.com/artist/matthansenart'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(2310, 'http://smilout.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(2568, 'http://igorkieryluk.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(2620, 'http://www.rkpost.net'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3010, 'https://www.facebook.com/bOne77'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3034, 'http://ryanbarger.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3034, 'https://www.facebook.com/ryan.barger.923'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3237, 'http://bennewmanart.bigcartel.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3242, 'https://www.artstation.com/artist/bengiskhan'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3402, 'http://bgk-bengiskhan.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3536, 'http://larrymacdougallart.tumblr.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3557, 'http://www.facebook.com/razorfang'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'http://cargocollective.com/art-ly'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'https://www.facebook.com/Lydia-Schuchmann-234211253281512/'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'https://www.behance.net/LydiaSchuchmann'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(4180, 'http://www.facebook.com/jim.nelson.9'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(4232, 'http://nateabell.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(4302, 'http://mattwilsonprime.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5100, 'http://brisbaneillustrators.com/caleb-salisbury.html'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.cgsociety.org'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.artstation.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5170, 'http://blog.johngravato.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'http://arndtdrechsler.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'https://www.facebook.com/arndt.drechsler'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5252, 'http://www.woodillustration.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5252, 'http://stevethebunny.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5310, 'http://alradeck.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5310, 'http://alradeck.tumblr.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5618, 'https://twitter.com/emilyzeinner'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5618, 'https://www.artstation.com/artist/emilyzeinner'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5763, 'https://robertruffolo.carbonmade.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5763, 'https://twitter.com/rruffs'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5848, 'http://peterdora.blogspot.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5848, 'http://peterman2070.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5880, 'http://kristenplescow.tumblr.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5880, 'http://kristenplescow.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(5917, 'https://www.artstation.com/artist/ianllanas'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6077, 'https://www.facebook.com/brent.evans.735'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6100, 'http://envertigo.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6115, 'http://www.facebook.com/peter.bergting'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6244, 'http://www.artworksillustration.com/portfolio%20keithbirdsong.htm'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6244, 'http://www.keith-birdsong.blogspot.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6343, 'http://davidsmit.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6357, 'http://ectmonster.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6550, 'http://www.artstation.com/artist/hounworks'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6550, 'http://hounworks.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6705, 'http://donatoarts.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6739, 'http://jasoncaffoe.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(6880, 'http://takashitan2.wix.com/takashitanportfolio'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7071, 'http://www.davidnashart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7071, 'http://davidnashart.tumblr.com/'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7205, 'http://inkthinker.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7291, 'http://dougkovacs.com/dkblog'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.behance.net/gallery/Galefire-Portfolio/11389539'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'http://michael-galefire.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.facebook.com/MichaelRookardArt'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(7842, 'http://www.mikesutfin.blogspot.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8009, 'http://lucasdurham.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8027, 'http://www.gepart.com.au'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8046, 'https://www.facebook.com/derekgpoole'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8051, 'http://davidkeggillustration.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8051, 'http://david-kegg.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8545, 'http://davidroberthovey.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8577, 'http://mariusandrei.carbonmade.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8580, 'http://drewsil.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8621, 'http://bocetillos.blogspot.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://bryansyme.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://www.bryansyme.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://fineartamerica.com/profiles/bryan-syme.html'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8703, 'http://runfreakrun.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8703, 'http://runfreakrun.blogspot.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8964, 'https://www.artstation.com/artist/mauroperoni'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(8964, 'http://mauroperoni.deviantart.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(9435, 'http://www.facebook.com/mark.zug'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(9495, 'https://www.facebook.com/MichaelKomarckIllustration'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(9785, 'http://www.baldegografix.com'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(9854, 'https://www.artstation.com/artist/ryanportillo'); INSERT INTO contributors_weblink(id_contributor, url) VALUES(9854, 'http://ryanportillo.deviantart.com');
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');
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');
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');
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], 'Nielsen', 'Terese'); INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gianni', 'Tom'); 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], 'Sintes', 'Marc'); 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):
Shadow Spells: INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 326075); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 934215); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 63948); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5790, 962138); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 297816); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(7645, 207986); INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(3862, 918235); 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);
Korrektur
Dopplungen?
- 3077 - Joshua Howell
- 7157 - Joshua Rowell
- 7468 - Larry Almore
- 8047 - Larry Elmore
- 5665 - Jacob Glaser
- 8919 - Jason Glaser