Changeset 3915 for trunk/tools/database/Teams.sql

Timestamp:

Aug 2, 2000, 3:01:36 AM (25 years ago)

Author:

bird

Message:

Corrections and changes.

File:

• trunk/tools/database/Teams.sql (modified) (6 diffs)

trunk/tools/database/Teams.sql

@@ -1 @@
--- $Id: Teams.sql,v 1.4 2000-08-01 01:49:56 bird Exp $
+-- $Id: Teams.sql,v 1.5 2000-08-02 01:01:36 bird Exp $
 --
 -- Team data.
@@ -53 +53 @@
 
 INSERT INTO tgroupmember(tgroup, author)
-    SELECT 1000, refcode FROM author WHERE name = 'Sander van Leeuwen';
-INSERT INTO tgroupmember(tgroup, author)
-    SELECT 1000, refcode FROM author WHERE name = 'Achim Hasenmueller';
-INSERT INTO tgroupmember(tgroup, author)
-    SELECT 1000, refcode FROM author WHERE name = 'Peter Fitzsimmons';
-INSERT INTO tgroupmember(tgroup, author)
-    SELECT 1000, refcode FROM author WHERE name = 'Vince Vielhaber';
-INSERT INTO tgroupmember(tgroup, author)
-    SELECT 1000, refcode FROM author WHERE name = 'Patrick Haller';
-INSERT INTO tgroupmember(tgroup, author)
-    SELECT 1000, refcode FROM author WHERE name = 'Christian Langanke';
-INSERT INTO tgroupmember(tgroup, author)
-    SELECT 1000, refcode FROM author WHERE name = 'Adrian Gschwend';
-INSERT INTO tgroupmember(tgroup, author)
-    SELECT 1000, refcode FROM author WHERE name = 'knut st. osmundsen';
+    SELECT 1000, refcode FROM author
+        WHERE name IN (
+                        'Sander van Leeuwen',
+                        'Achim Hasenmueller',
+                        'Peter Fitzsimmons',
+                        'Vince Vielhaber',
+                        'Patrick Haller',
+                        'Christian Langanke',
+                        'Adrian Gschwend',
+                        'Nenad Milenkovic',
+                        'knut st. osmundsen'
+                       );
 
 
@@ -145 +142 @@
 3,
 'WAI',
-'Portable Executable Loader'
+'Win32 API Implementation'
 ,
 
@@ -573 +570 @@
         WHERE name IN (
                         'Sander van Leeuwen',
-                        'John P Baker'
+                        'John P. Baker'
                        );
 INSERT INTO tgroupdll(tgroup, dll)
@@ -651 +648 @@
 -- MAPI32
 INSERT INTO tgroup(refcode, team,        name,  description, notes)
-    VALUES        (      3, 3016, 'MAPI32'
+    VALUES        (   3016,    3, 'MAPI32'
 ,'Implementing \'high-level\' MAIL API so MAPI compilant applications can
 directly send mail using OS/2 messaging software and native mail packages.'
@@ -673 +670 @@
 
 INSERT INTO tgroup(refcode, team,        name,  description)
-    VALUES        (   3999,    3, 'unassigned',
+    VALUES        (   3999,    3, 'Unassigned',
 'To get out of this group and join one that works on something! :)\n
-</i>Note: Consisting mostly of lurkers that offered their help but have yet to
-decide (or to be told) which group to join and what to do.'
+<i>Note: Consisting mostly of lurkers that offered their help but have yet to
+decide (or to be told) which group to join and what to do.</i>'
 );