From 903f703c12a4f310658ef0abeed6cd9f9e1fc97f Mon Sep 17 00:00:00 2001 From: "terry%netscape.com" <> Date: Thu, 28 Jan 1999 05:17:06 +0000 Subject: Added three new fields (which appear in the UI only if params are turned on): target_milestone, qa_contact, and status_whiteboard. --- CHANGES | 14 +++++++++++++ bug_form.pl | 58 +++++++++++++++++++++++++++++++++++++++++++++++++---- buglist.cgi | 41 ++++++++++++++++++++++++++++++++----- colchange.cgi | 16 +++++++++++++-- defparams.pl | 32 ++++++++++++++++++++++++++++- doeditparams.cgi | 2 ++ editparams.cgi | 2 +- globals.pl | 12 +++++++++++ long_list.cgi | 26 ++++++++++++++++++++---- makebugtable.sh | 8 ++++++-- process_bug.cgi | 17 ++++++++++++++-- query.cgi | 61 ++++++++++++++++++++++++++++++++++++++++++++++++-------- show_bug.cgi | 3 ++- 13 files changed, 262 insertions(+), 30 deletions(-) diff --git a/CHANGES b/CHANGES index fabe02e1e..1c52d8071 100644 --- a/CHANGES +++ b/CHANGES @@ -11,6 +11,20 @@ will tell you what has been changed in the last week. +1/20/99 Added new fields: Target Milestone, QA Contact, and Status Whiteboard. +These fields are all optional in the UI; there are parameters to turn them on. +However, whether or not you use them, the fields need to be in the DB. There +is some code that needs them, even if you don't. + +To update your DB to have these fields, send the following to MySQL: + + alter table bugs add column target_milestone varchar(20) not null, + add column qa_contact mediumint not null, + add column status_whiteboard mediumtext not null, + add index (target_milestone), add index (qa_contact); + + + 1/18/99 You can now query by CC. To make this perform reasonably, the CC table needs some indices. The following MySQL does the necessary stuff: diff --git a/bug_form.pl b/bug_form.pl index 003151423..595d5808e 100644 --- a/bug_form.pl +++ b/bug_form.pl @@ -37,6 +37,9 @@ select reporter, bug_file_loc, short_desc, + target_milestone, + qa_contact, + status_whiteboard, date_format(creation_ts,'Y-m-d') from bugs where bug_id = $::FORM{'id'}"; @@ -49,7 +52,8 @@ if (@row = FetchSQLData()) { foreach my $field ("bug_id", "product", "version", "rep_platform", "op_sys", "bug_status", "resolution", "priority", "bug_severity", "component", "assigned_to", "reporter", - "bug_file_loc", "short_desc", "creation_ts") { + "bug_file_loc", "short_desc", "target_milestone", + "qa_contact", "status_whiteboard", "creation_ts") { $bug{$field} = shift @row; if (!defined $bug{$field}) { $bug{$field} = ""; @@ -139,8 +143,38 @@ print "