Index: openacs-4/packages/bug-tracker/bug-tracker.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/bug-tracker.info,v
diff -u -r1.25 -r1.26
--- openacs-4/packages/bug-tracker/bug-tracker.info	29 May 2008 15:09:52 -0000	1.25
+++ openacs-4/packages/bug-tracker/bug-tracker.info	26 Jun 2008 22:09:09 -0000	1.26
@@ -8,7 +8,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>f</singleton-p>
     
-    <version name="1.4d4" url="http://openacs.org/repository/download/apm/bug-tracker-1.4d4.apm">
+    <version name="1.4d7" url="http://openacs.org/repository/download/apm/bug-tracker-1.4d7.apm">
         <owner url="mailto:lars@collaboraid.biz">Lars Pind</owner>
         <summary>Tracks bugs and features, versions and maintainers, in software projects.</summary>
         <release-date>2008-05-13</release-date>
@@ -17,7 +17,7 @@
         Contains the best of SDM, Bugzilla, FogBUGZ, and bughost.com.</description>
         <maturity>0</maturity>
 
-        <provides url="bug-tracker" version="1.4d4"/>
+        <provides url="bug-tracker" version="1.4d7"/>
         <requires url="acs-content-repository" version="5.2.0d2"/>
         <requires url="acs-kernel" version="5.2.0d2"/>
         <requires url="acs-tcl" version="5.2.0d1"/>
Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql	30 Mar 2005 18:18:18 -0000	1.15
+++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql	26 Jun 2008 22:09:10 -0000	1.16
@@ -9,6 +9,10 @@
                                 on delete cascade
                                 constraint bt_projects_pk 
                                 primary key,
+  workflow_id                   integer 
+                                constraint bt_projects_workflow_id_fk
+                                references workflows(workflow_id) 
+                                on delete cascade,
   description                   text,
   -- short string will be included in the subject line of emails                                                                
   email_subject_name            text,
@@ -111,14 +115,19 @@
     p_project_id          alias for $1;
     v_folder_id           integer;
     v_root_keyword_id     integer;
+    v_workflow_id         integer;
     rec                   record;
 begin
-    -- get the content folder for this instance
-    select folder_id, root_keyword_id
-    into   v_folder_id, v_root_keyword_id
+    -- get the content folder and workflow_id for this instance
+    select folder_id, root_keyword_id, workflow_id
+    into   v_folder_id, v_root_keyword_id, v_workflow_id
     from   bt_projects
     where  project_id = p_project_id;
 
+    if v_workflow_id not null then
+      perform workflow__delete(v_workflow_id);
+    end if;
+
     -- This gets done in tcl before we are called ... for now
     --  Delete the bugs
     -- for rec in select item_id from cr_items where parent_id = v_folder_id
Index: openacs-4/packages/bug-tracker/tcl/install-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/install-procs.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/bug-tracker/tcl/install-procs.tcl	15 Jun 2008 19:37:01 -0000	1.6
+++ openacs-4/packages/bug-tracker/tcl/install-procs.tcl	26 Jun 2008 22:09:10 -0000	1.7
@@ -71,6 +71,13 @@
                     content::folder::register_content_type -folder_id $folder_id -content_type "image"
                 }
             }
+            1.4d6 1.4d7 { 
+                db_foreach select_project_ids {} {
+                    set workflow_id \
+                        [bug_tracker::bug::get_instance_workflow_id -package_id $project_id]
+                    db_dml update_project {}
+                }
+            }
         }
 }
 
Index: openacs-4/packages/bug-tracker/tcl/install-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/install-procs.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/bug-tracker/tcl/install-procs.xql	29 May 2008 15:09:52 -0000	1.3
+++ openacs-4/packages/bug-tracker/tcl/install-procs.xql	26 Jun 2008 22:09:10 -0000	1.4
@@ -23,4 +23,12 @@
     </querytext>
 </fullquery>
 
+<fullquery name="bug_tracker::install::package_upgrade.update_project">
+    <querytext>
+      update bt_projects
+      set workflow_id = :workflow_id
+      where project_id = :project_id
+    </querytext>
+</fullquery>
+
 </queryset>
Index: openacs-4/packages/bug-tracker/www/admin/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/index.adp,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/bug-tracker/www/admin/index.adp	20 Apr 2004 14:19:36 -0000	1.8
+++ openacs-4/packages/bug-tracker/www/admin/index.adp	26 Jun 2008 22:09:10 -0000	1.9
@@ -94,6 +94,7 @@
       &nbsp;
     </td>
   </tr>
+
   <tr bgcolor="#cccccc">
     <td colspan="3">
      #bug-tracker.Parameters#
@@ -106,7 +107,19 @@
     </td>
   </tr>
 
+  <tr bgcolor="#cccccc">
+    <td colspan="3">
+     #bug-tracker.Workflow#: <i>Foo!</i>
+    </td>
+    <td align="center">
+      <a href="@workflow_edit_url@"><img src="../graphics/Edit16.gif" width="16" height="16" border="0" alt="#acs-kernel.common_edit#"></a>
+    </td>
+    <td align="center">
+      &nbsp;
+    </td>
+  </tr>
 
+
 <!--
   <tr bgcolor="#cccccc">
     <td colspan="3">
Index: openacs-4/packages/bug-tracker/www/admin/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/index.tcl,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/bug-tracker/www/admin/index.tcl	29 Mar 2004 15:07:35 -0000	1.9
+++ openacs-4/packages/bug-tracker/www/admin/index.tcl	26 Jun 2008 22:09:10 -0000	1.10
@@ -29,6 +29,7 @@
 set versions_edit_url "versions"
 set categories_edit_url "categories"
 set permissions_edit_url "permissions"
+set workflow_edit_url "workflow-edit"
 set parameters_edit_url "/shared/parameters?[export_vars { { return_url [ad_return_url] } { package_id {[ad_conn package_id]} } }]"
 set severity_codes_edit_url "severity-codes"
 set priority_codes_edit_url "priority-codes"