ALTER TABLE program_v1
  RENAME COLUMN invoice_sender_address_id TO venue_address_id;

ALTER TABLE program_v1
  DROP CONSTRAINT IF EXISTS fk_program_invoice_address;

ALTER TABLE program_v1
  ADD CONSTRAINT fk_program_venue_address FOREIGN KEY (venue_address_id)
    REFERENCES hdb_address(address_id);

ALTER TABLE program_v1
  ADD COLUMN invoice_sender_address TEXT;

ALTER TABLE program_session
  RENAME COLUMN invoice_sender_address_id TO venue_address_id;

ALTER TABLE program_session
  DROP CONSTRAINT IF EXISTS fk_session_invoice_address;

ALTER TABLE program_session
  ADD CONSTRAINT fk_session_venue_address FOREIGN KEY (venue_address_id)
    REFERENCES hdb_address(address_id);

ALTER TABLE program_session
  ADD COLUMN invoice_sender_address TEXT;


