Index: openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql,v
diff -u -N -r1.20 -r1.21
--- openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql	19 Dec 2003 13:03:20 -0000	1.20
+++ openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql	14 Jan 2004 10:18:10 -0000	1.21
@@ -41,6 +41,19 @@
         
 comment on table sim_simulations is 'Each record is an instantiation of a simulation template, and the parent of zero to many simulation cases.';
 
+create table sim_simulation_emails (
+    simulation_id         integer       constraint sim_simulation_emails_sid_fk
+                                        references workflows
+                                        on delete cascade,
+    user_id               integer       constraint sim_simulation_emails_uid_fk
+                                        references users(user_id),
+    email_type            varchar(20)   constraint sim_simulation_emails_et_ck
+                                        check (email_type in ('reminder')),
+    send_date             timestamptz
+);
+
+comment on table sim_simulation_emails is 'Keeps track of notifications sent to users for a certain simulation.';      
+
 create table sim_roles (
     role_id             integer         constraint sim_roles_ri_fk
                                         references workflow_roles(role_id)
