( project_id, user_id, credit_to_type, credit_to_address

              ( project_id, user_id, credit_to_type, credit_to_network, credit_to_address

      , renderNetworkId nid

              (event_id, amended_at, credit_to_type, credit_to_btc_addr)

              (event_id, amended_at, credit_to_type, credit_to_network, credit_to_address)

        , renderNetworkId nid

  WHERE credit_to_address IS NOT NULL;

    WHERE credit_to_address IS NOT NULL;
  ALTER TABLE event_credit_to_amendments RENAME COLUMN credit_to_btc_addr TO credit_to_address;
  ALTER TABLE event_credit_to_amendments ADD COLUMN credit_to_network text;
  UPDATE event_credit_to_amendments SET credit_to_network = 'btc' 
    WHERE credit_to_address IS NOT NULL;

  ALTER TABLE event_credit_to_amendments RENAME COLUMN credit_to_address TO credit_to_btc_addr;
  ALTER TABLE event_credit_to_amendments DROP COLUMN credit_to_network;