| 1 | -- $Id: Authors.sql,v 1.9 2000-08-02 18:09:24 bird Exp $
|
|---|
| 2 | --
|
|---|
| 3 | -- Insert authors.
|
|---|
| 4 | --
|
|---|
| 5 | -- Note: these are taken from the assignment list(s).
|
|---|
| 6 | --
|
|---|
| 7 | -- USE odin32;
|
|---|
| 8 |
|
|---|
| 9 | DELETE FROM author;
|
|---|
| 10 | -- refcode name first, last initials alias email country city/location description
|
|---|
| 11 | -- (cvs user)
|
|---|
| 12 | INSERT INTO author VALUES ( 1, 'Sander van Leeuwen', 'Sander', 'van Leeuwen', 'SvL', 'sandervl', 'sandervl@xs4all.nl', 'the Netherlands', 'Delft', NULL);
|
|---|
| 13 | INSERT INTO author VALUES ( 2, 'Peter Fitzsimmons', 'Peter', 'Fitzsimmons', 'PF', NULL, 'pfitzsim@home.com', 'Canada', 'Mississauga, Ontario', NULL);
|
|---|
| 14 | INSERT INTO author VALUES ( 3, 'Patrick Haller', 'Patrick', 'Haller', 'PT', 'phaller', 'phaller@gmx.net', 'Germany', NULL, NULL);
|
|---|
| 15 | INSERT INTO author VALUES ( 4, 'Joel Troster', 'Joel', 'Troster', 'JT', 'jtroster', 'jtroster@atitech.ca', 'Canada', 'Thornhill, Ontario', NULL);
|
|---|
| 16 | INSERT INTO author VALUES ( 5, 'Vince Vielhaber', 'Vince', 'Vielhaber', 'VV', 'vince', 'vev@michvhf.com', 'USA', 'Oxford, MI', NULL);
|
|---|
| 17 | INSERT INTO author VALUES ( 6, 'Chris McKillop', 'Chris', 'McKillop', 'CMK', NULL, 'cdmckill@engmail.uwaterloo.ca','Canada', 'Waterloo, Ontario', NULL);
|
|---|
| 18 | INSERT INTO author VALUES ( 7, 'Felix Maschek', 'Felix', 'Maschek', 'FM', NULL, 'felix@maschek.com', 'Germany', 'Ammersbek', NULL);
|
|---|
| 19 |
|
|---|
| 20 | INSERT INTO author VALUES ( 8, 'Mark Stead', 'Mark', 'Stead', 'MS', NULL, 'mar-@unico.com.au', NULL, NULL, NULL);
|
|---|
| 21 | INSERT INTO author VALUES ( 9, 'Henk Kelder', 'Henk', 'Kelder', 'HK', NULL, 'henk.kelde-@capgemini.nl', NULL, NULL, NULL);
|
|---|
| 22 | INSERT INTO author VALUES (10, 'Daniela Engert', 'Daniela', 'Engert', 'DE', 'dengert', 'dani@ngrt.de', NULL, NULL, NULL);
|
|---|
| 23 | INSERT INTO author VALUES (11, 'Jens Bckman', 'Jens', 'Bckman', 'JB', NULL, 'os2war-@hem.passagen.se', NULL, NULL, NULL);
|
|---|
| 24 | INSERT INTO author VALUES (12, 'Ed Ng', 'Ed', 'Ng', 'EG', NULL, 'en-@hubcap.clemson.edu', NULL, NULL, NULL);
|
|---|
| 25 | INSERT INTO author VALUES (13, 'Ken Ames', 'Ken', 'Ames', 'KA', NULL, 'kename-@eathlink.net', NULL, NULL, NULL);
|
|---|
| 26 | INSERT INTO author VALUES (14, 'Craig Bradney', 'Craig', 'Bradney', 'CrB', NULL, 'cbradne-@zip.com.au', NULL, NULL, NULL);
|
|---|
| 27 | INSERT INTO author VALUES (15, 'Achim Hasenmueller', 'Achim', 'Hasenmueller', 'AH', 'achimha', 'achimha@innotek.de', NULL, NULL, NULL);
|
|---|
| 28 | INSERT INTO author VALUES (16, 'Rene Pronk', 'Rene', 'Pronk', 'RPr', NULL, 'r.pron-@twi.tudelft.nl', NULL, NULL, NULL);
|
|---|
| 29 | INSERT INTO author VALUES (17, 'Christoph Bratschi', 'Christoph', 'Bratschi', 'ChB', 'cbratschi','cbratsch-@datacomm.ch', NULL, NULL, NULL);
|
|---|
| 30 | INSERT INTO author VALUES (18, 'Przemyslaw Dobrowolski', 'Przemyslaw ', 'Dobrowolski', 'PD', NULL, 'dobrawka@asua.org.pl', NULL, NULL, NULL);
|
|---|
| 31 | INSERT INTO author VALUES (19, 'Bartosz Tomasik', 'Bartosz', 'Tomasik', 'BT', NULL, 'bart-@asua.org.pl', NULL, NULL, NULL);
|
|---|
| 32 | INSERT INTO author VALUES (20, 'Radu Trimbitas', 'Radu', 'Trimbitas', 'RT', NULL, 'rad-@rds.ro', NULL, NULL, NULL);
|
|---|
| 33 | INSERT INTO author VALUES (21, 'Erast V. Kunenkov', 'Erast V.', 'Kunenkov', 'ER', NULL, 'eras-@tips-gw.ips.ac.ru', NULL, NULL, NULL);
|
|---|
| 34 | INSERT INTO author VALUES (22, 'Ulrich Muller', 'Ulrich', 'Muller', 'UM', NULL, 'ulrich.moelle-@rz.hu-berlin.de',NULL, NULL, NULL);
|
|---|
| 35 | INSERT INTO author VALUES (23, 'Joachim Schneider', 'Joachim', 'Schneider', 'JS', NULL, 'joaschneide-@debitel.net', NULL, NULL, NULL);
|
|---|
| 36 | INSERT INTO author VALUES (24, 'David Raison', 'David', 'Raison', 'DR', 'davidr', 'djr@lemur.co.uk', NULL, NULL, NULL);
|
|---|
| 37 | INSERT INTO author VALUES (25, 'Robert Pouliot', 'Robert', 'Pouliot', 'RPo', NULL, 'kryno-@clic.net', NULL, NULL, NULL);
|
|---|
| 38 | INSERT INTO author VALUES (26, 'Markus Montkowski', 'Markus', 'Montkowski', 'MM', NULL, 'mmontkowski@gmx.de', NULL, NULL, NULL);
|
|---|
| 39 | INSERT INTO author VALUES (27, 'Marty Amodeo', 'Marty', 'Amodeo', 'MA', NULL, 'mart-@rochester.rr.com', NULL, NULL, NULL);
|
|---|
| 40 | INSERT INTO author VALUES (28, 'Josef Chmel', 'Josef', 'Chmel', 'JCh', NULL, 'chme-@mujweb.cz', NULL, NULL, NULL);
|
|---|
| 41 | INSERT INTO author VALUES (29, 'Lee Riemenschneider', 'Lee', 'Riemenschneider', 'LR', NULL, 'lwrieme-@wcic.cioe.com', NULL, NULL, NULL);
|
|---|
| 42 | INSERT INTO author VALUES (30, 'Jeppe Cramon', 'Jeppe', 'Cramon', 'JCr', NULL, 'jepp-@cramon.dk', NULL, NULL, NULL);
|
|---|
| 43 | INSERT INTO author VALUES (31, 'Edgar Buerkle', 'Edgar', 'Buerkle', 'EB', 'buerkle', 'Edgar.Buerkle@gmx.net', NULL, NULL, NULL);
|
|---|
| 44 | INSERT INTO author VALUES (32, 'Yuri Dario', 'Yuri', 'Dario', 'UD', NULL, 'mc6530@mclink.it', NULL, NULL, NULL);
|
|---|
| 45 | INSERT INTO author VALUES (33, 'Adrian Gschwend', 'Adrian', 'Gschwend', 'AG', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 46 | -- correct cvs user?
|
|---|
| 47 | INSERT INTO author VALUES (34, 'Jeroen van den Horn', 'Jeroen', 'van den Horn', 'JvH', 'hugh', 'J.vandenHorn@fibre.a2000.nl', NULL, NULL, NULL);
|
|---|
| 48 | INSERT INTO author VALUES (35, 'Bart van Leeuwen', 'Bart', 'van Leeuwen', 'BvL', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 49 | INSERT INTO author VALUES (36, 'Nenad Milenkovic', 'Nenad', 'Milenkovic', 'NM', NULL, 'nenad_milenkovic@softhome.net',NULL, NULL, NULL);
|
|---|
| 50 | INSERT INTO author VALUES (37, 'Michal Necasek', 'Michal', 'Necasek', 'MN', 'mike', 'mike@mendelu.cz', NULL, NULL, NULL);
|
|---|
| 51 | INSERT INTO author VALUES (38, 'Vitali E. Pelenyov', 'Vitali E.', 'Pelenyov', 'VEP', NULL, 'tvv@sbs.kiev.ua', NULL, NULL, NULL);
|
|---|
| 52 | INSERT INTO author VALUES (39, 'Vit Timchishin', 'Vit', 'Timchishin', 'VT', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 53 | INSERT INTO author VALUES (40, 'Jens Wiessner', 'Jens', 'Wiessner', 'JW', 'jens', 'wiessnej@rfi.de', NULL, NULL, NULL);
|
|---|
| 54 | INSERT INTO author VALUES (41, 'Christian Langanke', 'Christian', 'Langanke', 'CL', 'cla', 'cbratschi@datacomm.ch', NULL, NULL, NULL);
|
|---|
| 55 | INSERT INTO author VALUES (42, 'Marco A. Morales', 'Marco A.', 'Morales', 'MAM', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 56 | INSERT INTO author VALUES (43, 'Richard P. Burke', 'Richard P.', 'Burke', 'RPB', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 57 | INSERT INTO author VALUES (44, 'TechnicalDirector@...', '','TechnicalDirector@...', 'TDi', NULL, 'TechnicalDirector@webwombat.com.au', NULL, NULL, NULL);
|
|---|
| 58 | INSERT INTO author VALUES (45, 'Charles Hunter', 'Charles', 'Hunter', 'CH', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 59 | INSERT INTO author VALUES (46, 'Ahti Heinla', 'Ahti', 'Heinla', 'AHe', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 60 | INSERT INTO author VALUES (47, 'John P. Baker', 'John P.', 'Baker', 'JPB', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 61 | INSERT INTO author VALUES (48, 'Alan Lo', 'Alan', 'Lo', 'AL', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 62 | INSERT INTO author VALUES (49, 'Andrew Hagen', 'Andrew', 'Hagen', 'AHa', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 63 | INSERT INTO author VALUES (50, 'Carsten Tenbrink', 'Carsten', 'Tenbrink', 'CT', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 64 | INSERT INTO author VALUES (51, 'Eric Norman', 'Eric', 'Norman', 'EN', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 65 | INSERT INTO author VALUES (52, 'Oliver Wilcock', 'Oliver', 'Wilcock', 'OW', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 66 | INSERT INTO author VALUES (53, 'omurata@ga2.so-net.ne.jp', '','omurata@ga2.so-net.ne.jp', 'OM', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 67 | INSERT INTO author VALUES (54, 'rprice@wdn.com', '','rprice@wdn.com', 'RPi', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 68 | INSERT INTO author VALUES (55, 'Samuel Audet', 'Samuel', 'Audet', 'SA', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 69 | INSERT INTO author VALUES (56, 'Timothy J. Massey', 'Timothy J.', 'Massey', 'TJM', NULL, NULL, NULL, NULL, NULL);
|
|---|
| 70 | INSERT INTO author VALUES (57, 'Abey George', 'Abey', 'George', 'AbB', NULL, NULL, NULL, NULL, 'Wine?');
|
|---|
| 71 | --INSERT INTO author VALUES (, '', '', NULL, NULL, NULL, NULL);
|
|---|
| 72 | --INSERT INTO author VALUES (, '', '', NULL, NULL, NULL, NULL);
|
|---|
| 73 |
|
|---|
| 74 | INSERT INTO author VALUES (4095,'knut st. osmundsen', 'knut st.', 'osmundsen', 'kso', 'bird', 'knut.stange.osmundsen@mynd.no', 'Norway', 'Oslo', NULL);
|
|---|
| 75 |
|
|---|
| 76 |
|
|---|
| 77 |
|
|---|
| 78 |
|
|---|
| 79 |
|
|---|
| 80 |
|
|---|
| 81 |
|
|---|
| 82 |
|
|---|
| 83 |
|
|---|
| 84 |
|
|---|
| 85 |
|
|---|
