Index: openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/Attic/simulation-tables-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	14 Oct 2003 13:58:03 -0000	1.1
+++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	27 Oct 2003 12:41:24 -0000	1.2
@@ -19,7 +19,7 @@
 					constraint sim_roles_pk
 					  primary key,
     character_id	integer		constraint sim_roles_character_fk
-                                          check (1=1)
+					  references cr_items
 );
 
 comment on table sim_roles is 'Each record is a role within a simulation template to be played by one or more users or a computer agent when the template is instantiated into cases.';