Changeset 3870 for trunk/tools/database/Authors.sql
- Timestamp:
- Jul 20, 2000, 1:39:59 PM (25 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/tools/database/Authors.sql
r3858 r3870 1 -- $Id: Authors.sql,v 1. 6 2000-07-18 22:18:55bird Exp $1 -- $Id: Authors.sql,v 1.7 2000-07-20 11:39:58 bird Exp $ 2 2 -- 3 3 -- Insert authors. … … 8 8 9 9 DELETE FROM author; 10 -- refcode name initials alias email country city/location 10 -- refcode name initials alias email country city/location description 11 11 -- (cvs user) 12 INSERT INTO author VALUES ( 1, 'Sander van Leeuwen', 'SvL', 'sandervl', 'sandervl@xs4all.nl', 'the Netherlands', 'Delft' );13 INSERT INTO author VALUES ( 2, 'Peter Fitzsimmons', 'PF', NULL, 'pfitzsim@home.com', 'Canada', 'Mississauga, Ontario' );14 INSERT INTO author VALUES ( 3, 'Patrick Haller', 'PT', 'phaller', 'phaller@gmx.net', 'Germany', NULL );15 INSERT INTO author VALUES ( 4, 'Joel Troster', 'JT', 'jtroster', 'jtroster@atitech.ca', 'Canada', 'Thornhill, Ontario' );16 INSERT INTO author VALUES ( 5, 'Vince Vielhaber', 'VV', 'vince', 'vev@michvhf.com', 'USA', 'Oxford, MI' );17 INSERT INTO author VALUES ( 6, 'Chris McKillop', 'CMK', NULL, 'cdmckill@engmail.uwaterloo.ca','Canada', 'Waterloo, Ontario' );18 INSERT INTO author VALUES ( 7, 'Felix Maschek', 'FM', NULL, 'felix@maschek.com', 'Germany', 'Ammersbek' );12 INSERT INTO author VALUES ( 1, 'Sander van Leeuwen', 'SvL', 'sandervl', 'sandervl@xs4all.nl', 'the Netherlands', 'Delft', NULL); 13 INSERT INTO author VALUES ( 2, 'Peter Fitzsimmons', 'PF', NULL, 'pfitzsim@home.com', 'Canada', 'Mississauga, Ontario', NULL); 14 INSERT INTO author VALUES ( 3, 'Patrick Haller', 'PT', 'phaller', 'phaller@gmx.net', 'Germany', NULL, NULL); 15 INSERT INTO author VALUES ( 4, 'Joel Troster', 'JT', 'jtroster', 'jtroster@atitech.ca', 'Canada', 'Thornhill, Ontario', NULL); 16 INSERT INTO author VALUES ( 5, 'Vince Vielhaber', 'VV', 'vince', 'vev@michvhf.com', 'USA', 'Oxford, MI', NULL); 17 INSERT INTO author VALUES ( 6, 'Chris McKillop', 'CMK', NULL, 'cdmckill@engmail.uwaterloo.ca','Canada', 'Waterloo, Ontario', NULL); 18 INSERT INTO author VALUES ( 7, 'Felix Maschek', 'FM', NULL, 'felix@maschek.com', 'Germany', 'Ammersbek', NULL); 19 19 20 INSERT INTO author VALUES ( 8, 'Mark Stead', 'MS', NULL, 'mar-@unico.com.au', NULL, NULL );21 INSERT INTO author VALUES ( 9, 'Henk Kelder', 'HK', NULL, 'henk.kelde-@capgemini.nl', NULL, NULL );22 INSERT INTO author VALUES (10, 'Daniela Engert', 'DE', 'dengert', 'dani@ngrt.de', NULL, NULL );23 INSERT INTO author VALUES (11, 'Jens Bckman', 'JB', NULL, 'os2war-@hem.passagen.se', NULL, NULL );24 INSERT INTO author VALUES (12, 'Ed Ng', 'EG', NULL, 'en-@hubcap.clemson.edu', NULL, NULL );25 INSERT INTO author VALUES (13, 'Ken Ames', 'KA', NULL, 'kename-@eathlink.net', NULL, NULL );26 INSERT INTO author VALUES (14, 'Craig Bradney', 'CrB', NULL, 'cbradne-@zip.com.au', NULL, NULL );27 INSERT INTO author VALUES (15, 'Achim Hasenmueller', 'AH', 'achimha', 'achimha@innotek.de', NULL, NULL );28 INSERT INTO author VALUES (16, 'Rene Pronk', 'RPr', NULL, 'r.pron-@twi.tudelft.nl', NULL, NULL );29 INSERT INTO author VALUES (17, 'Christoph Bratschi', 'ChB', 'cbratschi','cbratsch-@datacomm.ch', NULL, NULL );30 INSERT INTO author VALUES (18, 'Przemyslaw Dobrowolski', 'PD', NULL, 'dobrawka@asua.org.pl', NULL, NULL );31 INSERT INTO author VALUES (19, 'Bartosz Tomasik', 'BT', NULL, 'bart-@asua.org.pl', NULL, NULL );32 INSERT INTO author VALUES (20, 'Radu Trimbitas', 'RT', NULL, 'rad-@rds.ro', NULL, NULL );33 INSERT INTO author VALUES (21, 'Erast V. Kunenkov', 'ER', NULL, 'eras-@tips-gw.ips.ac.ru', NULL, NULL );34 INSERT INTO author VALUES (22, 'Ulrich Muller', 'UM', NULL, 'ulrich.moelle-@rz.hu-berlin.de',NULL, NULL );35 INSERT INTO author VALUES (23, 'Joachim Schneider', 'JS', NULL, 'joaschneide-@debitel.net', NULL, NULL );36 INSERT INTO author VALUES (24, 'David Raison', 'DR', 'davidr', 'djr@lemur.co.uk', NULL, NULL );37 INSERT INTO author VALUES (25, 'Robert Pouliot', 'RPo', NULL, 'kryno-@clic.net', NULL, NULL );38 INSERT INTO author VALUES (26, 'Markus Montkowski', 'MM', NULL, 'mmontkowski@gmx.de', NULL, NULL );39 INSERT INTO author VALUES (27, 'Marty Amodeo', 'MA', NULL, 'mart-@rochester.rr.com', NULL, NULL );40 INSERT INTO author VALUES (28, 'Josef Chmel', 'JCh', NULL, 'chme-@mujweb.cz', NULL, NULL );41 INSERT INTO author VALUES (29, 'Lee Riemenschneider', 'LR', NULL, 'lwrieme-@wcic.cioe.com', NULL, NULL );42 INSERT INTO author VALUES (30, 'Jeppe Cramon', 'JCr', NULL, 'jepp-@cramon.dk', NULL, NULL );43 INSERT INTO author VALUES (31, 'Edgar Buerkle', 'EB', 'buerkle', 'Edgar.Buerkle@gmx.net', NULL, NULL );44 INSERT INTO author VALUES (32, 'Yuri Dario', 'UD', NULL, 'mc6530@mclink.it', NULL, NULL );45 INSERT INTO author VALUES (33, 'Adrian Gschwend', 'AG', NULL, NULL, NULL, NULL );20 INSERT INTO author VALUES ( 8, 'Mark Stead', 'MS', NULL, 'mar-@unico.com.au', NULL, NULL, NULL); 21 INSERT INTO author VALUES ( 9, 'Henk Kelder', 'HK', NULL, 'henk.kelde-@capgemini.nl', NULL, NULL, NULL); 22 INSERT INTO author VALUES (10, 'Daniela Engert', 'DE', 'dengert', 'dani@ngrt.de', NULL, NULL, NULL); 23 INSERT INTO author VALUES (11, 'Jens Bckman', 'JB', NULL, 'os2war-@hem.passagen.se', NULL, NULL, NULL); 24 INSERT INTO author VALUES (12, 'Ed Ng', 'EG', NULL, 'en-@hubcap.clemson.edu', NULL, NULL, NULL); 25 INSERT INTO author VALUES (13, 'Ken Ames', 'KA', NULL, 'kename-@eathlink.net', NULL, NULL, NULL); 26 INSERT INTO author VALUES (14, 'Craig Bradney', 'CrB', NULL, 'cbradne-@zip.com.au', NULL, NULL, NULL); 27 INSERT INTO author VALUES (15, 'Achim Hasenmueller', 'AH', 'achimha', 'achimha@innotek.de', NULL, NULL, NULL); 28 INSERT INTO author VALUES (16, 'Rene Pronk', 'RPr', NULL, 'r.pron-@twi.tudelft.nl', NULL, NULL, NULL); 29 INSERT INTO author VALUES (17, 'Christoph Bratschi', 'ChB', 'cbratschi','cbratsch-@datacomm.ch', NULL, NULL, NULL); 30 INSERT INTO author VALUES (18, 'Przemyslaw Dobrowolski', 'PD', NULL, 'dobrawka@asua.org.pl', NULL, NULL, NULL); 31 INSERT INTO author VALUES (19, 'Bartosz Tomasik', 'BT', NULL, 'bart-@asua.org.pl', NULL, NULL, NULL); 32 INSERT INTO author VALUES (20, 'Radu Trimbitas', 'RT', NULL, 'rad-@rds.ro', NULL, NULL, NULL); 33 INSERT INTO author VALUES (21, 'Erast V. Kunenkov', 'ER', NULL, 'eras-@tips-gw.ips.ac.ru', NULL, NULL, NULL); 34 INSERT INTO author VALUES (22, 'Ulrich Muller', 'UM', NULL, 'ulrich.moelle-@rz.hu-berlin.de',NULL, NULL, NULL); 35 INSERT INTO author VALUES (23, 'Joachim Schneider', 'JS', NULL, 'joaschneide-@debitel.net', NULL, NULL, NULL); 36 INSERT INTO author VALUES (24, 'David Raison', 'DR', 'davidr', 'djr@lemur.co.uk', NULL, NULL, NULL); 37 INSERT INTO author VALUES (25, 'Robert Pouliot', 'RPo', NULL, 'kryno-@clic.net', NULL, NULL, NULL); 38 INSERT INTO author VALUES (26, 'Markus Montkowski', 'MM', NULL, 'mmontkowski@gmx.de', NULL, NULL, NULL); 39 INSERT INTO author VALUES (27, 'Marty Amodeo', 'MA', NULL, 'mart-@rochester.rr.com', NULL, NULL, NULL); 40 INSERT INTO author VALUES (28, 'Josef Chmel', 'JCh', NULL, 'chme-@mujweb.cz', NULL, NULL, NULL); 41 INSERT INTO author VALUES (29, 'Lee Riemenschneider', 'LR', NULL, 'lwrieme-@wcic.cioe.com', NULL, NULL, NULL); 42 INSERT INTO author VALUES (30, 'Jeppe Cramon', 'JCr', NULL, 'jepp-@cramon.dk', NULL, NULL, NULL); 43 INSERT INTO author VALUES (31, 'Edgar Buerkle', 'EB', 'buerkle', 'Edgar.Buerkle@gmx.net', NULL, NULL, NULL); 44 INSERT INTO author VALUES (32, 'Yuri Dario', 'UD', NULL, 'mc6530@mclink.it', NULL, NULL, NULL); 45 INSERT INTO author VALUES (33, 'Adrian Gschwend', 'AG', NULL, NULL, NULL, NULL, NULL); 46 46 -- correct cvs user? 47 INSERT INTO author VALUES (34, 'Jeroen van den Horn', 'JvH', 'hugh', 'J.vandenHorn@fibre.a2000.nl', NULL, NULL );48 INSERT INTO author VALUES (35, 'Bart van Leeuwen', 'BvL', NULL, NULL, NULL, NULL );49 INSERT INTO author VALUES (36, 'Nenad Milenkovic', 'NM', NULL, NULL, NULL, NULL );50 INSERT INTO author VALUES (37, 'Michal Necasek', 'MN', 'mike', 'mike@mendelu.cz', NULL, NULL );51 INSERT INTO author VALUES (38, 'Vitali E. Pelenyov', 'VEP', NULL, 'tvv@sbs.kiev.ua', NULL, NULL );52 INSERT INTO author VALUES (39, 'Vit Timchishin', 'VT', NULL, NULL, NULL, NULL );53 INSERT INTO author VALUES (40, 'Jens Wiessner', 'JW', 'jens', 'wiessnej@rfi.de', NULL, NULL );54 INSERT INTO author VALUES (41, 'Christian Langanke', 'CL', 'cla', 'cbratschi@datacomm.ch', NULL, NULL );55 INSERT INTO author VALUES (42, 'Marco A. Morales', 'MAM', NULL, NULL, NULL, NULL );56 INSERT INTO author VALUES (43, 'Richard P. Burke', 'RPB', NULL, NULL, NULL, NULL );57 INSERT INTO author VALUES (44, 'TechnicalDirector@...', 'TDi', NULL, 'TechnicalDirector@webwombat.com.au', NULL, NULL);58 INSERT INTO author VALUES (45, 'Charles Hunter', 'CH', NULL, NULL, NULL, NULL );59 INSERT INTO author VALUES (46, 'Ahti Heinla', 'AHe', NULL, NULL, NULL, NULL );60 INSERT INTO author VALUES (47, 'John P Baker', 'JPB', NULL, NULL, NULL, NULL );47 INSERT INTO author VALUES (34, 'Jeroen van den Horn', 'JvH', 'hugh', 'J.vandenHorn@fibre.a2000.nl', NULL, NULL, NULL); 48 INSERT INTO author VALUES (35, 'Bart van Leeuwen', 'BvL', NULL, NULL, NULL, NULL, NULL); 49 INSERT INTO author VALUES (36, 'Nenad Milenkovic', 'NM', NULL, NULL, NULL, NULL, NULL); 50 INSERT INTO author VALUES (37, 'Michal Necasek', 'MN', 'mike', 'mike@mendelu.cz', NULL, NULL, NULL); 51 INSERT INTO author VALUES (38, 'Vitali E. Pelenyov', 'VEP', NULL, 'tvv@sbs.kiev.ua', NULL, NULL, NULL); 52 INSERT INTO author VALUES (39, 'Vit Timchishin', 'VT', NULL, NULL, NULL, NULL, NULL); 53 INSERT INTO author VALUES (40, 'Jens Wiessner', 'JW', 'jens', 'wiessnej@rfi.de', NULL, NULL, NULL); 54 INSERT INTO author VALUES (41, 'Christian Langanke', 'CL', 'cla', 'cbratschi@datacomm.ch', NULL, NULL, NULL); 55 INSERT INTO author VALUES (42, 'Marco A. Morales', 'MAM', NULL, NULL, NULL, NULL, NULL); 56 INSERT INTO author VALUES (43, 'Richard P. Burke', 'RPB', NULL, NULL, NULL, NULL, NULL); 57 INSERT INTO author VALUES (44, 'TechnicalDirector@...', 'TDi', NULL, 'TechnicalDirector@webwombat.com.au', NULL, NULL, NULL); 58 INSERT INTO author VALUES (45, 'Charles Hunter', 'CH', NULL, NULL, NULL, NULL, NULL); 59 INSERT INTO author VALUES (46, 'Ahti Heinla', 'AHe', NULL, NULL, NULL, NULL, NULL); 60 INSERT INTO author VALUES (47, 'John P Baker', 'JPB', NULL, NULL, NULL, NULL, NULL); 61 61 --INSERT INTO author VALUES (, '', '', NULL, NULL, NULL, NULL); 62 62 --INSERT INTO author VALUES (, '', '', NULL, NULL, NULL, NULL); 63 63 64 INSERT INTO author VALUES (4095,'knut st. osmundsen', 'kso', 'bird', 'knut.stange.osmundsen@mynd.no', 'Norway', 'Oslo');64 INSERT INTO author VALUES (4095,'knut st. osmundsen', 'kso', 'bird', 'knut.stange.osmundsen@mynd.no', 'Norway', 'Oslo', NULL); 65 65 66 66
Note:
See TracChangeset
for help on using the changeset viewer.