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.6 -r1.7
--- openacs-4/packages/recruiting/sql/postgresql/recruiting-create.sql	7 Aug 2002 23:39:19 -0000	1.6
+++ openacs-4/packages/recruiting/sql/postgresql/recruiting-create.sql	14 Aug 2002 20:28:27 -0000	1.7
@@ -251,4 +251,25 @@
        'recruiting_rating__name'
 );
 
+create table recruiting_assignment_emails (
+       package_id                  integer
+                                   constraint recruiting_emails_pkg_id_fk
+                                   references apm_packages(package_id)
+                                   constraint recruiting_emails_pkg_id_uniq
+                                   unique,
+       email_body                  varchar(8000)
+);
+
+insert into recruiting_assignment_emails
+           (package_id,
+            email_body)
+    values (null,'\
+\
+Dear $interviewer_name,\
+\
+Please interview $candidate_name at your earliest convenience.  When you have completed the interview, please go to $url and rate the candidate.\
+\
+Thank you,\
+$sender_name');
+
 \i recruiting-api-create.sql