Index: openacs-4/packages/scholarship-fund/sql/postgresql/scholarship-fund-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/scholarship-fund/sql/postgresql/scholarship-fund-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/scholarship-fund/sql/postgresql/scholarship-fund-create.sql	3 Aug 2005 22:49:48 -0000	1.1
+++ openacs-4/packages/scholarship-fund/sql/postgresql/scholarship-fund-create.sql	6 Aug 2005 13:13:20 -0000	1.2
@@ -8,10 +8,10 @@
 --
 
 create table scholarship_fund_grants (
-	grant_id		serial primary key,
-	fund_id			integer references scholarship_fund on delete cascade not null,
-	user_id			integer references users on delete cascade not null,
-	grant_date		timestamp default current_timestamp not null,
-	gift_certificate_id 	integer references ec_gift_certificates not null,
-	grant_amount		float not null
+	grant_id serial primary key,
+	fund_id integer not null,
+	user_id integer references users on delete cascade not null,
+	grant_date timestamp default current_timestamp not null,
+	gift_certificate_id integer references ec_gift_certificates not null,
+	grant_amount float not null
 );
\ No newline at end of file
Index: openacs-4/packages/scholarship-fund/tcl/scholarship-funds-install-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/scholarship-fund/tcl/scholarship-funds-install-procs.tcl,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/scholarship-fund/tcl/scholarship-funds-install-procs.tcl	4 Aug 2005 00:07:14 -0000	1.5
+++ openacs-4/packages/scholarship-fund/tcl/scholarship-funds-install-procs.tcl	6 Aug 2005 13:13:20 -0000	1.6
@@ -48,6 +48,8 @@
         -pretty_name "Amount in Fund" \
         -pretty_plural "Amount in Fund" \
         -column_spec "float"
+
+     db_dml "alter_foreign_key" "alter table scholarship_fund_grants add constraint fund_id_fk foreign key (fund_id) references scholarship_fund (fund_id) on delete cascade"
 }
 
 ad_proc -private sf::install::after_instantiate {