Shadowhelix:Datenbank/Vorschläge

Shadowhelix:Datenbank

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):

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');

Korrektur

Dopplungen?

• 3077 - Joshua Howell
• 7157 - Joshua Rowell

• 7468 - Larry Almore
• 8047 - Larry Elmore

• 5665 - Jacob Glaser
• 8919 - Jason Glaser