From fd742d6fc8849328749866dbff2936d43abcc7d1 Mon Sep 17 00:00:00 2001
From: "bugreport%peshkin.net" <>
Date: Sun, 13 Oct 2002 11:26:02 +0000
Subject: Bug 24789 [E|A|R] Add Estimated, Actual, Remaining Time Fields patch
 by jeff.hedlund@matrixsi.com 2xr=joel,justdave

---
 checksetup.pl | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'checksetup.pl')

diff --git a/checksetup.pl b/checksetup.pl
index 83cc06a5f..c44c03235 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -1438,6 +1438,8 @@ $table{bugs} =
     everconfirmed tinyint not null,
     reporter_accessible tinyint not null default 1,
     cclist_accessible tinyint not null default 1,
+    estimated_time decimal(5,2) not null default 0,
+    remaining_time decimal(5,2) not null default 0,
     alias varchar(20),
     
     index (assigned_to),
@@ -1478,6 +1480,7 @@ $table{longdescs} =
    'bug_id mediumint not null,
     who mediumint not null,
     bug_when datetime not null,
+    work_time decimal(5,2) not null default 0,
     thetext mediumtext,
     isprivate tinyint not null default 0,
     index(bug_id),
@@ -1853,6 +1856,8 @@ AddFDef("everconfirmed", "Ever Confirmed", 0);
 AddFDef("reporter_accessible", "Reporter Accessible", 0);
 AddFDef("cclist_accessible", "CC Accessible", 0);
 AddFDef("bug_group", "Group", 0);
+AddFDef("estimated_time", "Estimated Hours", 1);
+AddFDef("remaining_time", "Remaining Hours", 0);
 
 # Oops. Bug 163299
 $dbh->do("DELETE FROM fielddefs WHERE name='cc_accessible'");
@@ -1860,6 +1865,8 @@ $dbh->do("DELETE FROM fielddefs WHERE name='cc_accessible'");
 AddFDef("flagtypes.name", "Flag", 0);
 AddFDef("requesters.login_name", "Flag Requester", 0);
 AddFDef("setters.login_name", "Flag Setter", 0);
+AddFDef("work_time", "Hours Worked", 0);
+AddFDef("percentage_complete", "Percentage Complete", 0);
 
 ###########################################################################
 # Detect changed local settings
@@ -2903,6 +2910,11 @@ if (GetFieldDef("bugs","qacontact_accessible")) {
     DropField("bugs", "assignee_accessible");
 }
 
+# 2002-02-20 jeff.hedlund@matrixsi.com - bug 24789 time tracking
+AddField("longdescs", "work_time", "decimal(5,2) not null default 0");
+AddField("bugs", "estimated_time", "decimal(5,2) not null default 0");
+AddField("bugs", "remaining_time", "decimal(5,2) not null default 0");
+
 # 2002-03-15 bbaetz@student.usyd.edu.au - bug 129466
 # 2002-05-13 preed@sigkill.com - bug 129446 patch backported to the 
 #  BUGZILLA-2_14_1-BRANCH as a security blocker for the 2.14.2 release
-- 
cgit v1.2.3-24-g4f1b