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
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/scholarship-fund/sql/postgresql/scholarship-fund-create.sql	3 Aug 2005 22:49:48 -0000	1.1
@@ -0,0 +1,17 @@
+-- 
+-- packages/scholarship-fund/sql/postgresql/scholarship-fund-create.sql
+-- 
+-- @author Roel Canicula (roelmc@pldtdsl.net)
+-- @creation-date 2005-08-03
+-- @arch-tag: 904b71ab-89cf-4c36-af73-7fc85414a6bc
+-- @cvs-id $Id: scholarship-fund-create.sql,v 1.1 2005/08/03 22:49:48 roelc Exp $
+--
+
+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
+);
\ No newline at end of file
Index: openacs-4/packages/scholarship-fund/sql/postgresql/upgrade/upgrade-0.1d-0.1d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/scholarship-fund/sql/postgresql/upgrade/Attic/upgrade-0.1d-0.1d1.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/scholarship-fund/sql/postgresql/upgrade/upgrade-0.1d-0.1d1.sql	3 Aug 2005 22:49:48 -0000	1.1
@@ -0,0 +1,17 @@
+-- 
+-- packages/scholarship-fund/sql/postgresql/upgrade-0.1d-0.1d1.sql
+-- 
+-- @author Roel Canicula (roelmc@pldtdsl.net)
+-- @creation-date 2005-08-03
+-- @arch-tag: abd54f8f-d9cc-4590-8f1c-c23cd8587484
+-- @cvs-id $Id: upgrade-0.1d-0.1d1.sql,v 1.1 2005/08/03 22:49:48 roelc Exp $
+--
+
+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
+);
\ No newline at end of file