-- Gateway tokens of saved cards are stored encrypted with the app key; a hash keeps them unique.
ALTER TABLE client_paymethods DROP INDEX method, MODIFY customer_ref TEXT NOT NULL, MODIFY method_ref TEXT NOT NULL,
  ADD method_hash CHAR(64) NOT NULL DEFAULT '' AFTER method_ref, ADD UNIQUE KEY method (gateway, method_hash);