cashless2ecash

cashless2ecash: pay with cards for digital cash (experimental)
Log | Files | Refs | README

0001-c2ec_add_confirmed_id.sql (704B)

      1 BEGIN;
      2 
      3 SELECT _v.register_patch('0001-c2ec-add-confirmed-id', ARRAY['0001-c2ec-schema'], NULL);
      4 
      5 SET search_path TO c2ec;
      6 
      7 ALTER TABLE withdrawal
      8     ADD confirmed_row_id INT8 DEFAULT 0;
      9 COMMENT ON COLUMN withdrawal.confirmed_row_id
     10   IS 'Used by the wire-gateway API do not mess up confirmed and unconfirmed transactions row ids.';
     11 
     12 ALTER TABLE transfer
     13     ADD transferred_row_id INT8 DEFAULT 0;
     14 COMMENT ON COLUMN transfer.transferred_row_id
     15   IS 'Used by the wire-gateway API do not mess up pending and succeeded transfers.';
     16 
     17 UPDATE withdrawal SET confirmed_row_id=withdrawal_row_id WHERE withdrawal_status='confirmed';
     18 UPDATE transfer SET transferred_row_id=row_id WHERE transfer_status=0;
     19 
     20 COMMIT;