Initial Stripe payment rejection support * Store rejected transactions * Command...

[hcoop/portal.git] / create-stripe-tables.sql

diff --git a/create-stripe-tables.sql b/create-stripe-tables.sql
index 0adc68d..be8d414 100644 (file)
--- a/create-stripe-tables.sql
+++ b/create-stripe-tables.sql
@@ -28,4 +28,16 @@ CREATE TABLE stripe_processed
        foreign key (stripe_charge_id) references stripe_payment (charge_id)
 );
 
+CREATE TABLE stripe_rejected
+(
+       stripe_charge_id text not null primary key,
+       refunded_on date not null,
+       reason text not null,
+
+       foreign key (stripe_charge_id) references stripe_payment (charge_id)
+);
+
+CREATE VIEW stripe_handled AS
+       (select stripe_charge_id from stripe_processed) union (select stripe_charge_id from stripe_rejected);
+
 COMMIT;