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