Index: openacs-4/packages/recruiting/sql/postgresql/recruiting-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/sql/postgresql/recruiting-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/recruiting/sql/postgresql/recruiting-create.sql	30 Jul 2002 22:38:34 -0000	1.3
+++ openacs-4/packages/recruiting/sql/postgresql/recruiting-create.sql	1 Aug 2002 22:14:36 -0000	1.4
@@ -153,7 +153,8 @@
        interviewer_id              integer 
                                    references users(user_id),
        candidate_id                integer
-                                   references recruiting_candidates(candidate_id)
+                                   references recruiting_candidates(candidate_id),
+       should_hire_p               boolean
 );
 
 select acs_object_type__create_type (
@@ -190,7 +191,8 @@
                                    references recruiting_criteria(criteria_id),
        rating                      integer
                                    constraint recruiting_rating_range
-                                   check (rating between 1 and 5)
+                                   check (rating between 1 and 5),
+       unique (package_id,interview_id,criteria_id)
 );
 
 select acs_object_type__create_type (
