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 -N -r1.3 -r1.4
--- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql	29 Aug 2002 13:39:00 -0000	1.3
+++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql	29 Aug 2002 15:15:11 -0000	1.4
@@ -9,6 +9,8 @@
                                 constraint bt_projects_pk 
                                 primary key,
   description                   text,
+  -- short string will be included in the subject line of emails                                                                
+  email_subject_name            text,
   maintainer                    integer 
                                 constraint bt_projects_maintainer_fk
                                 references users(user_id)
@@ -141,6 +143,8 @@
                                 references bt_projects(project_id),
   component_name                varchar(500) not null,
   description                   text,
+  -- This is what the component can be referred to in the URL
+  url_name                      text,
   -- a component can be without maintainer, in which case we just default to the project maintainer
   maintainer                    integer 
                                 constraint bt_components_maintainer_fk