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.1 -r1.2
--- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql	3 May 2002 16:29:59 -0000	1.1
+++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql	29 Aug 2002 09:41:53 -0000	1.2
@@ -314,6 +314,10 @@
   action                        varchar(50)
                                 constraint bt_bug_actions_action_ck
                                 check (action in ('open','edit','comment','reassign','resolve','reopen','close')),
+  resolution                    varchar(50)
+                                constraint bt_bugs_actions_resolution_ck
+                                check (resolution is null or 
+                                       resolution in ('fixed','bydesign','wontfix','postponed','duplicate','norepro')),
   actor                         integer not null
                                 constraint bt_bug_actions_actor_fk
                                 references users(user_id),