From 87712bc5dd025157d70cff67376a2092a9cda18f Mon Sep 17 00:00:00 2001 From: "terry%netscape.com" <> Date: Thu, 4 Feb 1999 03:00:12 +0000 Subject: Allow components to have a default qacontact. --- CHANGES | 8 ++ makecomponenttable.sh | 246 +++++++++++++++++++++++++------------------------- post_bug.cgi | 16 ++++ 3 files changed, 147 insertions(+), 123 deletions(-) diff --git a/CHANGES b/CHANGES index 8cd49cc71..3c2ec1307 100644 --- a/CHANGES +++ b/CHANGES @@ -10,6 +10,14 @@ query the CVS tree. For example, will tell you what has been changed in the last week. +2/3/99 Added a new column "initialqacontact" to the components table that gives +an initial QA contact field. It may be empty if you wish the initial qa +contact to be empty. If you're not using the QA contact field, you don't need +to add this column, but you might as well be safe and add it anyway: + + alter table components add column initialqacontact tinytext not null; + + 2/2/99 Added a new column "milestoneurl" to the products table that gives a URL which is to describe the currently defined milestones for a product. If you don't use target milestone, you might be able to get away without adding this diff --git a/makecomponenttable.sh b/makecomponenttable.sh index 7a6721c90..35be505af 100755 --- a/makecomponenttable.sh +++ b/makecomponenttable.sh @@ -30,133 +30,133 @@ use bugs; create table components ( value tinytext, program tinytext, -initialowner tinytext # Should arguably be a mediumint! +initialowner tinytext not null, # Should arguably be a mediumint! +initialqacontact tinytext not null # Should arguably be a mediumint! ); - -insert into components (value, program, initialowner) values ("XPFC", "Calendar", "spider@netscape.com"); -insert into components (value, program, initialowner) values ("config", "Calendar", "spider@netscape.com"); -insert into components (value, program, initialowner) values ("Core", "Calendar", "sman@netscape.com"); -insert into components (value, program, initialowner) values ("NLS", "Calendar", "jusn@netscape.com"); -insert into components (value, program, initialowner) values ("UI", "Calendar", "eyork@netscape.com"); -insert into components (value, program, initialowner) values ("Test", "Calendar", "sman@netscape.com"); -insert into components (value, program, initialowner) values ("Install", "Calendar", "sman@netscape.com"); - -insert into components (value, program, initialowner) values ("CCK-Wizard", "CCK", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("CCK-Installation", "CCK", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("CCK-Shell", "CCK", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("CCK-Whitebox", "CCK", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("Dialup-Install", "CCK", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("Dialup-Account Setup", "CCK", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("Dialup-Mup/Muc", "CCK", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("Dialup-Upgrade", "CCK", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("AS-Whitebox", "CCK", "selmer@netscape.com"); - -insert into components (value, program, initialowner) values ("LDAP C SDK", "Directory", "chuckb@netscape.com"); -insert into components (value, program, initialowner) values ("LDAP Java SDK", "Directory", "chuckb@netscape.com"); -insert into components (value, program, initialowner) values ("PerLDAP", "Directory", "leif@netscape.com"); -insert into components (value, program, initialowner) values ("LDAP Tools", "Directory", "chuckb@netscape.com"); - - -insert into components (value, program, initialowner) values ("Networking", "MailNews", "mscott@netscape.com"); -insert into components (value, program, initialowner) values ("Database", "MailNews", "davidmc@netscape.com"); -insert into components (value, program, initialowner) values ("MIME", "MailNews", "rhp@netscape.com"); -insert into components (value, program, initialowner) values ("Security", "MailNews", "jefft@netscape.com"); -insert into components (value, program, initialowner) values ("Composition", "MailNews", "ducarroz@netscape.com"); -insert into components (value, program, initialowner) values ("Address Book", "MailNews", "putterman@netscape.com"); -insert into components (value, program, initialowner) values ("Front End", "MailNews", "warren@netscape.com"); -insert into components (value, program, initialowner) values ("Back End", "MailNews", "phil@netscape.com"); - - - -insert into components (value, program, initialowner) values ("Macintosh FE", "Mozilla", "sdagley@netscape.com"); -insert into components (value, program, initialowner) values ("Windows FE", "Mozilla", "blythe@netscape.com"); -insert into components (value, program, initialowner) values ("XFE", "Mozilla", "ramiro@netscape.com"); -insert into components (value, program, initialowner) values ("StubFE", "Mozilla", "rickg@netscape.com"); -insert into components (value, program, initialowner) values ("Aurora/RDF FE", "Mozilla", "don@netscape.com"); -insert into components (value, program, initialowner) values ("Aurora/RDF BE", "Mozilla", "guha@netscape.com"); -insert into components (value, program, initialowner) values ("Berkeley DB", "Mozilla", "montulli@netscape.com"); -insert into components (value, program, initialowner) values ("Browser Hooks", "Mozilla", "ebina@netscape.com"); -insert into components (value, program, initialowner) values ("Build Config", "Mozilla", "briano@netscape.com"); -insert into components (value, program, initialowner) values ("Composer", "Mozilla", "akkana@netscape.com"); -insert into components (value, program, initialowner) values ("Compositor Library", "Mozilla", "vidur@netscape.com"); -insert into components (value, program, initialowner) values ("Dialup", "Mozilla", "selmer@netscape.com"); -insert into components (value, program, initialowner) values ("FontLib", "Mozilla", "dp@netscape.com"); -insert into components (value, program, initialowner) values ("HTML Dialogs", "Mozilla", "nisheeth@netscape.com"); -insert into components (value, program, initialowner) values ("HTML to Text/PostScript Translation", "Mozilla", "brendan@netscape.com"); -insert into components (value, program, initialowner) values ("ImageLib", "Mozilla", "pnunn@netscape.com"); -insert into components (value, program, initialowner) values ("JPEG Image Handling", "Mozilla", "tgl@sss.pgh.pa.us"); -insert into components (value, program, initialowner) values ("PNG Image Handling", "Mozilla", "png@wco.com"); -insert into components (value, program, initialowner) values ("Image Conversion Library", "Mozilla", "mjudge@netscape.com"); -insert into components (value, program, initialowner) values ("I18N Library", "Mozilla", "bobj@netscape.com"); -insert into components (value, program, initialowner) values ("Java Stubs", "Mozilla", "warren@netscape.com"); -insert into components (value, program, initialowner) values ("JavaScript", "Mozilla", "mccabe@netscape.com"); -insert into components (value, program, initialowner) values ("JavaScript Debugger", "Mozilla", "jband@netscape.com"); -insert into components (value, program, initialowner) values ("JavaScript/Java Reflection", "Mozilla", "fur@netscape.com"); -insert into components (value, program, initialowner) values ("Layout", "Mozilla", "rickg@netscape.com"); -insert into components (value, program, initialowner) values ("LibMocha", "Mozilla", "mlm@netscape.com"); -insert into components (value, program, initialowner) values ("MIMELib", "Mozilla", "terry@mozilla.org"); -insert into components (value, program, initialowner) values ("NetLib", "Mozilla", "gagan@netscape.com"); -insert into components (value, program, initialowner) values ("NSPR", "Mozilla", "srinivas@netscape.com"); -insert into components (value, program, initialowner) values ("Password Cache", "Mozilla", "montulli@netscape.com"); -insert into components (value, program, initialowner) values ("PICS", "Mozilla", "montulli@netscape.com"); -insert into components (value, program, initialowner) values ("Plugins", "Mozilla", "amusil@netscape.com"); -insert into components (value, program, initialowner) values ("Preferences", "Mozilla", "aoki@netscape.com"); -insert into components (value, program, initialowner) values ("Progress Window", "Mozilla", "atotic@netscape.com"); -insert into components (value, program, initialowner) values ("Registry", "Mozilla", "dveditz@netscape.com"); -insert into components (value, program, initialowner) values ("Scheduler", "Mozilla", "aoki@netscape.com"); -insert into components (value, program, initialowner) values ("Security Stubs", "Mozilla", "jsw@netscape.com"); -insert into components (value, program, initialowner) values ("SmartUpdate", "Mozilla", "dveditz@netscape.com"); -insert into components (value, program, initialowner) values ("XML", "Mozilla", "guha@netscape.com"); -insert into components (value, program, initialowner) values ("XP-COM", "Mozilla", "scullin@netscape.com"); -insert into components (value, program, initialowner) values ("XP File Handling", "Mozilla", "atotic@netscape.com"); -insert into components (value, program, initialowner) values ("XP Miscellany", "Mozilla", "brendan@netscape.com"); -insert into components (value, program, initialowner) values ("XP Utilities", "Mozilla", "rickg@netscape.com"); -insert into components (value, program, initialowner) values ("Zlib", "Mozilla", "pnunn@netscape.com"); - - - -insert into components (value, program, initialowner) values ("Platform: Lesstif on Linux", "Mozilla", "ramiro@netscape.com"); -insert into components (value, program, initialowner) values ("Platform: OS/2", "Mozilla", "law@netscape.com"); -insert into components (value, program, initialowner) values ("Platform: MacOS/PPC", "Mozilla", "sdagley@netscape.com"); -insert into components (value, program, initialowner) values ("Platform: Rhapsody", "Mozilla", "mcafee@netscape.com"); -insert into components (value, program, initialowner) values ("Platform: MFC/Win32 on Windows", "Mozilla", "blythe@netscape.com"); - - -insert into components (value, program, initialowner) values ("ActiveX Wrapper", "NGLayout", "locka@iol.ie"); -insert into components (value, program, initialowner) values ("Content Model", "NGLayout", "kipp@netscape.com"); -insert into components (value, program, initialowner) values ("Cookies", "NGLayout", "scullin@netscape.com"); -insert into components (value, program, initialowner) values ("DOM", "NGLayout", "vidur@netscape.com"); -insert into components (value, program, initialowner) values ("DOM", "NGLayout", "vidur@netscape.com"); -insert into components (value, program, initialowner) values ("Editor", "NGLayout", "kostello@netscape.com"); -insert into components (value, program, initialowner) values ("Embedding APIs", "NGLayout", "jevering@netscape.com"); -insert into components (value, program, initialowner) values ("Event Handling", "NGLayout", "joki@netscape.com"); -insert into components (value, program, initialowner) values ("Event Handling", "NGLayout", "joki@netscape.com"); -insert into components (value, program, initialowner) values ("Form Submission", "NGLayout", "pollmann@netscape.com"); -insert into components (value, program, initialowner) values ("HTMLFrames", "NGLayout", "karnaze@netscape.com"); -insert into components (value, program, initialowner) values ("HTMLTables", "NGLayout", "karnaze@netscape.com"); -insert into components (value, program, initialowner) values ("Layout", "NGLayout", "troy@netscape.com"); -insert into components (value, program, initialowner) values ("Networking Library", "NGLayout", "gagan@netscape.com"); -insert into components (value, program, initialowner) values ("Parser", "NGLayout", "rickg@netscape.com"); -insert into components (value, program, initialowner) values ("Plug-ins", "NGLayout", "amusil@netscape.com"); -insert into components (value, program, initialowner) values ("Rendering", "NGLayout", "michaelp@netscape.com"); -insert into components (value, program, initialowner) values ("Selection and Search", "NGLayout", "kostello@netscape.com"); -insert into components (value, program, initialowner) values ("Style System", "NGLayout", "peterl@netscape.com"); -insert into components (value, program, initialowner) values ("Threading", "NGLayout", "rpotts@netscape.com"); -insert into components (value, program, initialowner) values ("Viewer App", "NGLayout", "rickg@netscape.com"); -insert into components (value, program, initialowner) values ("Widget Set", "NGLayout", "kmcclusk@netscape.com"); -insert into components (value, program, initialowner) values ("XPCOM", "NGLayout", "scullin@netscape.com"); -insert into components (value, program, initialowner) values ("xpidl", "NGLayout", "shaver@netscape.com"); - - -insert into components (value, program, initialowner) values ("Bonsai", "Webtools", "terry@mozilla.org"); -insert into components (value, program, initialowner) values ("Bugzilla", "Webtools", "terry@mozilla.org"); -insert into components (value, program, initialowner) values ("Despot", "Webtools", "terry@mozilla.org"); -insert into components (value, program, initialowner) values ("LXR", "Webtools", "endico@mozilla.org"); -insert into components (value, program, initialowner) values ("Mozbot", "Webtools", "terry@netscape.com"); -insert into components (value, program, initialowner) values ("Tinderbox", "Webtools", "terry@mozilla.org"); +insert into components (value, program, initialowner, initialqacontact) values ("XPFC", "Calendar", "spider@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("config", "Calendar", "spider@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Core", "Calendar", "sman@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("NLS", "Calendar", "jusn@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("UI", "Calendar", "eyork@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Test", "Calendar", "sman@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Install", "Calendar", "sman@netscape.com", ""); + +insert into components (value, program, initialowner, initialqacontact) values ("CCK-Wizard", "CCK", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("CCK-Installation", "CCK", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("CCK-Shell", "CCK", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("CCK-Whitebox", "CCK", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Dialup-Install", "CCK", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Dialup-Account Setup", "CCK", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Dialup-Mup/Muc", "CCK", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Dialup-Upgrade", "CCK", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("AS-Whitebox", "CCK", "selmer@netscape.com", ""); + +insert into components (value, program, initialowner, initialqacontact) values ("LDAP C SDK", "Directory", "chuckb@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("LDAP Java SDK", "Directory", "chuckb@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("PerLDAP", "Directory", "leif@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("LDAP Tools", "Directory", "chuckb@netscape.com", ""); + + +insert into components (value, program, initialowner, initialqacontact) values ("Networking", "MailNews", "mscott@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Database", "MailNews", "davidmc@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("MIME", "MailNews", "rhp@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Security", "MailNews", "jefft@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Composition", "MailNews", "ducarroz@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Address Book", "MailNews", "putterman@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Front End", "MailNews", "warren@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Back End", "MailNews", "phil@netscape.com", ""); + + + +insert into components (value, program, initialowner, initialqacontact) values ("Macintosh FE", "Mozilla", "sdagley@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Windows FE", "Mozilla", "blythe@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("XFE", "Mozilla", "ramiro@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("StubFE", "Mozilla", "rickg@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Aurora/RDF FE", "Mozilla", "don@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Aurora/RDF BE", "Mozilla", "guha@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Berkeley DB", "Mozilla", "montulli@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Browser Hooks", "Mozilla", "ebina@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Build Config", "Mozilla", "briano@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Composer", "Mozilla", "akkana@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Compositor Library", "Mozilla", "vidur@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Dialup", "Mozilla", "selmer@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("FontLib", "Mozilla", "dp@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("HTML Dialogs", "Mozilla", "nisheeth@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("HTML to Text/PostScript Translation", "Mozilla", "brendan@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("ImageLib", "Mozilla", "pnunn@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("JPEG Image Handling", "Mozilla", "tgl@sss.pgh.pa.us", ""); +insert into components (value, program, initialowner, initialqacontact) values ("PNG Image Handling", "Mozilla", "png@wco.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Image Conversion Library", "Mozilla", "mjudge@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("I18N Library", "Mozilla", "bobj@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Java Stubs", "Mozilla", "warren@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("JavaScript", "Mozilla", "mccabe@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("JavaScript Debugger", "Mozilla", "jband@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("JavaScript/Java Reflection", "Mozilla", "fur@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Layout", "Mozilla", "rickg@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("LibMocha", "Mozilla", "mlm@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("MIMELib", "Mozilla", "terry@mozilla.org", ""); +insert into components (value, program, initialowner, initialqacontact) values ("NetLib", "Mozilla", "gagan@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("NSPR", "Mozilla", "srinivas@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Password Cache", "Mozilla", "montulli@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("PICS", "Mozilla", "montulli@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Plugins", "Mozilla", "amusil@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Preferences", "Mozilla", "aoki@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Progress Window", "Mozilla", "atotic@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Registry", "Mozilla", "dveditz@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Scheduler", "Mozilla", "aoki@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Security Stubs", "Mozilla", "jsw@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("SmartUpdate", "Mozilla", "dveditz@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("XML", "Mozilla", "guha@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("XP-COM", "Mozilla", "scullin@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("XP File Handling", "Mozilla", "atotic@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("XP Miscellany", "Mozilla", "brendan@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("XP Utilities", "Mozilla", "rickg@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Zlib", "Mozilla", "pnunn@netscape.com", ""); + + + +insert into components (value, program, initialowner, initialqacontact) values ("Platform: Lesstif on Linux", "Mozilla", "ramiro@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Platform: OS/2", "Mozilla", "law@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Platform: MacOS/PPC", "Mozilla", "sdagley@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Platform: Rhapsody", "Mozilla", "mcafee@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Platform: MFC/Win32 on Windows", "Mozilla", "blythe@netscape.com", ""); + + +insert into components (value, program, initialowner, initialqacontact) values ("ActiveX Wrapper", "NGLayout", "locka@iol.ie", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Content Model", "NGLayout", "kipp@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Cookies", "NGLayout", "scullin@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("DOM", "NGLayout", "vidur@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("DOM", "NGLayout", "vidur@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Editor", "NGLayout", "kostello@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Embedding APIs", "NGLayout", "jevering@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Event Handling", "NGLayout", "joki@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Event Handling", "NGLayout", "joki@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Form Submission", "NGLayout", "pollmann@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("HTMLFrames", "NGLayout", "karnaze@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("HTMLTables", "NGLayout", "karnaze@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Layout", "NGLayout", "troy@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Networking Library", "NGLayout", "gagan@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Parser", "NGLayout", "rickg@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Plug-ins", "NGLayout", "amusil@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Rendering", "NGLayout", "michaelp@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Selection and Search", "NGLayout", "kostello@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Style System", "NGLayout", "peterl@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Threading", "NGLayout", "rpotts@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Viewer App", "NGLayout", "rickg@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Widget Set", "NGLayout", "kmcclusk@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("XPCOM", "NGLayout", "scullin@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("xpidl", "NGLayout", "shaver@netscape.com", ""); + + +insert into components (value, program, initialowner, initialqacontact) values ("Bonsai", "Webtools", "terry@mozilla.org", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Bugzilla", "Webtools", "terry@mozilla.org", "terry@mozilla.org"); +insert into components (value, program, initialowner, initialqacontact) values ("Despot", "Webtools", "terry@mozilla.org", ""); +insert into components (value, program, initialowner, initialqacontact) values ("LXR", "Webtools", "endico@mozilla.org", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Mozbot", "Webtools", "terry@netscape.com", ""); +insert into components (value, program, initialowner, initialqacontact) values ("Tinderbox", "Webtools", "terry@mozilla.org", ""); select * from components; diff --git a/post_bug.cgi b/post_bug.cgi index 3ea3b070f..1cff52326 100755 --- a/post_bug.cgi +++ b/post_bug.cgi @@ -79,6 +79,22 @@ $::FORM{'reporter'} = DBNameToIdAndCheck($::FORM{'reporter'}); my @bug_fields = ("reporter", "product", "version", "rep_platform", "bug_severity", "priority", "op_sys", "assigned_to", "bug_status", "bug_file_loc", "short_desc", "component"); + +if (Param("useqacontact")) { + SendSQL("select initialqacontact from components where program=" . + SqlQuote($::FORM{'product'}) . + " and value=" . SqlQuote($::FORM{'component'})); + my $qacontact = FetchOneColumn(); + if (defined $qacontact && $qacontact ne "") { + $::FORM{'qa_contact'} = DBNameToIdAndCheck($qacontact, 1); + push(@bug_fields, "qa_contact"); + } +} + + + + + my $query = "insert into bugs (\n" . join(",\n", @bug_fields) . ", creation_ts, long_desc ) values ( -- cgit v1.2.3-24-g4f1b