1 | -- $Id: Authors.sql,v 1.2 2000-02-10 22:42:33 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 initials alias email country city/location
|
---|
11 | INSERT INTO author VALUES ( 1, 'Sander van Leeuwen', 'SvL', NULL, 'sandervl@xs4all.nl', 'the Netherlands', 'Delft');
|
---|
12 | INSERT INTO author VALUES ( 2, 'Peter Fitzsimmons', 'PF', NULL, 'pfitzsim@home.com', 'Canada', 'Mississauga, Ontario');
|
---|
13 | INSERT INTO author VALUES ( 3, 'Patrick Haller', 'PT', NULL, 'haller@zebra.fh-weingarten.de', 'Germany', NULL);
|
---|
14 | INSERT INTO author VALUES ( 4, 'Joel Troster', 'JT', NULL, 'jtroster@atitech.ca', 'Canada', 'Thornhill, Ontario');
|
---|
15 | INSERT INTO author VALUES ( 5, 'Vince Vielhaber', 'VV', NULL, 'vev@michvhf.com', 'USA', 'Oxford, MI');
|
---|
16 | INSERT INTO author VALUES ( 6, 'Chris McKillop', 'CMK', NULL, 'cdmckill@engmail.uwaterloo.ca', 'Canada', 'Waterloo, Ontario');
|
---|
17 | INSERT INTO author VALUES ( 7, 'Felix Maschek', 'FM', NULL, 'felix@maschek.com', 'Germany', 'Ammersbek');
|
---|
18 |
|
---|
19 | INSERT INTO author VALUES ( 8, 'Mark Stead', 'MS', NULL, 'mar-@unico.com.au', NULL, NULL);
|
---|
20 | INSERT INTO author VALUES ( 9, 'Henk Kelder', 'HK', NULL, 'henk.kelde-@capgemini.nl', NULL, NULL);
|
---|
21 | INSERT INTO author VALUES (10, 'Daniela Engert', 'DE', NULL, 'd.enger-@odn.de', NULL, NULL);
|
---|
22 | INSERT INTO author VALUES (11, 'Jens Bckman', 'JB', NULL, 'os2war-@hem.passagen.se', NULL, NULL);
|
---|
23 | INSERT INTO author VALUES (12, 'Ed Ng', 'EG', NULL, 'en-@hubcap.clemson.edu', NULL, NULL);
|
---|
24 | INSERT INTO author VALUES (13, 'Ken Ames', 'KA', NULL, 'kename-@eathlink.net', NULL, NULL);
|
---|
25 | INSERT INTO author VALUES (14, 'Craig Bradney', 'CrB', NULL, 'cbradne-@zip.com.au', NULL, NULL);
|
---|
26 | INSERT INTO author VALUES (15, 'Achim Hasenmueller', 'AH', NULL, 'achimh-@innotek.de', NULL, NULL);
|
---|
27 | INSERT INTO author VALUES (16, 'Rene Pronk', 'RPr', NULL, 'r.pron-@twi.tudelft.nl', NULL, NULL);
|
---|
28 | INSERT INTO author VALUES (17, 'Christoph Bratschi', 'ChB', NULL, 'cbratsch-@datacomm.ch', NULL, NULL);
|
---|
29 | INSERT INTO author VALUES (18, 'Przemyslaw Dobrowolski','PD', NULL, 'dobrawk-@asua.org.pl', NULL, NULL);
|
---|
30 | INSERT INTO author VALUES (19, 'Bartosz Tomasik', 'BT', NULL, 'bart-@asua.org.pl', NULL, NULL);
|
---|
31 | INSERT INTO author VALUES (20, 'Radu Trimbitas', 'RT', NULL, 'rad-@rds.ro', NULL, NULL);
|
---|
32 | INSERT INTO author VALUES (21, 'Erast V. Kunenkov', 'ER', NULL, 'eras-@tips-gw.ips.ac.ru', NULL, NULL);
|
---|
33 | INSERT INTO author VALUES (22, 'Ulrich Muller', 'UM', NULL, 'ulrich.moelle-@rz.hu-berlin.de', NULL, NULL);
|
---|
34 | INSERT INTO author VALUES (23, 'Joachim Schneider', 'JS', NULL, 'joaschneide-@debitel.net', NULL, NULL);
|
---|
35 | INSERT INTO author VALUES (24, 'David Raison', 'DR', NULL, 'dj-@lemur.co.uk', NULL, NULL);
|
---|
36 | INSERT INTO author VALUES (25, 'Robert Pouliot', 'RPo', NULL, 'kryno-@clic.net', NULL, NULL);
|
---|
37 | INSERT INTO author VALUES (26, 'Markus Montkowski', 'MM', NULL, 'mmontkowsk-@norman.de', NULL, NULL);
|
---|
38 | INSERT INTO author VALUES (27, 'Marty ??', 'M??', NULL, 'mart-@rochester.rr.com', NULL, NULL);
|
---|
39 | INSERT INTO author VALUES (28, 'Josef Chmel', 'JCh', NULL, 'chme-@mujweb.cz', NULL, NULL);
|
---|
40 | INSERT INTO author VALUES (29, 'Lee Riemenschneider', 'LR', NULL, 'lwrieme-@wcic.cioe.com', NULL, NULL);
|
---|
41 | INSERT INTO author VALUES (30, 'Jeppe Cramon', 'JCr', NULL, 'jepp-@cramon.dk', NULL, NULL);
|
---|
42 | INSERT INTO author VALUES (31, 'Edgar Buerkle', 'EB', NULL, NULL, NULL, NULL);
|
---|
43 | INSERT INTO author VALUES (32, 'Yuri Dario', 'UD', NULL, NULL, NULL, NULL);
|
---|
44 | INSERT INTO author VALUES (33, 'Adrian Gschwend', 'AG', NULL, NULL, NULL, NULL);
|
---|
45 | INSERT INTO author VALUES (34, 'Jeroen van den Horn', 'JvH', NULL, NULL, NULL, NULL);
|
---|
46 | INSERT INTO author VALUES (35, 'Bart van Leeuwen', 'BvL', NULL, NULL, NULL, NULL);
|
---|
47 | INSERT INTO author VALUES (36, 'Nenad Milenkovic', 'NM', NULL, NULL, NULL, NULL);
|
---|
48 | INSERT INTO author VALUES (37, 'Michal Necasek', 'MN', NULL, NULL, NULL, NULL);
|
---|
49 | INSERT INTO author VALUES (38, 'Vitali E. Pelenyov', 'VEP', NULL, NULL, NULL, NULL);
|
---|
50 | INSERT INTO author VALUES (39, 'Vit Timchishin', 'VT', NULL, NULL, NULL, NULL);
|
---|
51 | INSERT INTO author VALUES (40, 'Jens Wiessner', 'JW', NULL, NULL, NULL, NULL);
|
---|
52 | INSERT INTO author VALUES (4095,'knut st. osmundsen', 'kso', 'bird', 'knut.stange.osmundsen@pmsc.no', 'Norway', 'Oslo');
|
---|
53 |
|
---|
54 |
|
---|
55 |
|
---|
56 |
|
---|
57 |
|
---|
58 |
|
---|
59 |
|
---|
60 |
|
---|
61 |
|
---|
62 |
|
---|
63 |
|
---|