phorge-phorge/resources/sql/autopatches/20141007.phortunecartmerchant.sql at master - revi-archive/phorge-phorge - SiliconForest Atelier

revi-archive/phorge-phorge

mirror of https://we.phorge.it/source/phorge.git synced 2024-11-09 16:32:39 +01:00

epriestley 9c4b8a0fb2 Adjust payment workflows to deal with merchants and configurable providers in Phortune

Summary:
Ref T2787. Builds on D10649 by rebining existing objects (carts, charges, etc) to merchantPHIDs and providerPHIDs instead of an implicit global merchant and weird global artifacts (providerType / providerKey).

Basically:

  - When you create something that users can pay for, you specify a merchant to control where the payment goes.
  - Accounts are install-wide, but payment methods are bound to merchants. This seems to do a reasonable job of balancing usability and technical concerns.
  - Replace a bunch of weird links between objects with standard PHIDs.
  - Improve "add payment method" flow.

Test Plan: Went through the Fund flow with Stripe and WePay, funding an initiative.

Reviewers: btrahan

Reviewed By: btrahan

Subscribers: epriestley

Maniphest Tasks: T2787

Differential Revision: https://secure.phabricator.com/D10652

2014-10-07 14:41:59 -07:00

5 lines

181 B

SQL

Raw Permalink Blame History

 ALTER TABLE {$NAMESPACE}_phortune.phortune_cart
   ADD merchantPHID VARBINARY(64) NOT NULL;
 ALTER TABLE {$NAMESPACE}_phortune.phortune_cart
   ADD KEY `key_merchant` (merchantPHID);