Index: openacs-4/packages/payment-gateway/sql/postgresql/payment-gateway-sc-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/payment-gateway/sql/postgresql/payment-gateway-sc-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/payment-gateway/sql/postgresql/payment-gateway-sc-create.sql 6 Jun 2002 02:48:13 -0000 1.2 +++ openacs-4/packages/payment-gateway/sql/postgresql/payment-gateway-sc-create.sql 6 Sep 2008 09:56:09 -0000 1.3 @@ -7,7 +7,7 @@ -- this is done when the order is placed, to verify that the card is good. select acs_sc_msg_type__new ( 'PaymentGateway.Authorize.InputType', - 'transaction_id:integer,amount:string,card_type:string,card_number:string,card_exp_month:string,card_exp_year:string,card_name:string,billing_street:string,billing_city:string,billing_state:string,billing_zip:string,billing_country:string' + 'transaction_id:integer,amount:string,card_type:string,card_number:string,card_exp_month:string,card_exp_year:string,card_code:string,card_name:string,billing_street:string,billing_city:string,billing_state:string,billing_zip:string,billing_country:string' ); select acs_sc_msg_type__new ( @@ -36,7 +36,7 @@ -- should not be called directly by the end user. select acs_sc_msg_type__new ( 'PaymentGateway.ChargeCard.InputType', - 'transaction_id:integer,amount:string,card_type:string,card_number:string,card_exp_month:string,card_exp_year:string,card_name:string,billing_street:string,billing_city:string,billing_state:string,billing_zip:string,billing_country:string' + 'transaction_id:integer,amount:string,card_type:string,card_number:string,card_exp_month:string,card_exp_year:string,card_code:string,card_name:string,billing_street:string,billing_city:string,billing_state:string,billing_zip:string,billing_country:string' ); select acs_sc_msg_type__new ( @@ -61,7 +61,7 @@ -- needed select acs_sc_msg_type__new ( 'PaymentGateway.Return.InputType', - 'transaction_id:integer,amount:string,card_type:string,card_number:string,card_exp_month:string,card_exp_year:string,card_name:string,billing_street:string,billing_city:string,billing_state:string,billing_zip:string,billing_country:string' + 'transaction_id:integer,amount:string,card_type:string,card_number:string,card_exp_month:string,card_exp_year:string,card_code:string,card_name:string,billing_street:string,billing_city:string,billing_state:string,billing_zip:string,billing_country:string' ); select acs_sc_msg_type__new ( 'PaymentGateway.Return.OutputType', @@ -82,7 +82,7 @@ -- Void is probably the least commonly supported, but it does exist. select acs_sc_msg_type__new ( 'PaymentGateway.Void.InputType', - 'transaction_id:integer,amount:string,card_type:string,card_number:string,card_exp_month:string,card_exp_year:string,card_name:string,billing_street:string,billing_city:string,billing_state:string,billing_zip:string,billing_country:string' + 'transaction_id:integer,amount:string,card_type:string,card_number:string,card_exp_month:string,card_exp_year:string,card_code:string,card_name:string,billing_street:string,billing_city:string,billing_state:string,billing_zip:string,billing_country:string' ); select acs_sc_msg_type__new (