Index: openacs-4/packages/sample-gateway/sql/postgresql/sample-gateway-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/sample-gateway/sql/postgresql/sample-gateway-create.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/sample-gateway/sql/postgresql/sample-gateway-create.sql	24 Apr 2006 14:57:18 -0000	1.2
@@ -0,0 +1,21 @@
+-- 
+-- packages/sample-gateway/sql/postgresql/sample-gateway-create.sql
+-- 
+-- @author Deds Castillo (deds@i-manila.com.ph)
+-- @creation-date 2005-01-24
+-- @arch-tag: cdccfb8f-0a0f-4c00-98ef-d1505f50048a
+-- @cvs-id $Id: sample-gateway-create.sql,v 1.2 2006/04/24 14:57:18 daveb Exp $
+--
+
+create table sample_gateway_result_log (
+  transaction_id 		    varchar(20) not null,
+  txn_attempted_type        varchar(25),
+  txn_attempted_time        timestamptz,
+  txn_returned_type         varchar(25),
+  errmsg                    varchar(200),
+  auth_code                 varchar(25),
+  avs_code                  varchar(3),
+  amount                    numeric not null
+);
+
+\i sample-gateway-sc-create.sql