text: -- +goose Up
  CREATE TABLE vrf_specs (
      id BIGSERIAL PRIMARY KEY,
      public_key text NOT NULL,
      coordinator_address bytea NOT NULL,
      confirmations bigint NOT NULL,
      created_at timestamp with time zone NOT NULL,
      updated_at timestamp with time zone NOT NULL
      CONSTRAINT coordinator_address_len_chk CHECK (octet_length(coordinator_address) = 20)
  );
  ALTER TABLE jobs ADD COLUMN vrf_spec_id INT REFERENCES vrf_specs(id),
  DROP CONSTRAINT chk_only_one_spec,
  ADD CONSTRAINT chk_only_one_spec CHECK (
      num_nonnulls(offchainreporting_oracle_spec_id, direct_request_spec_id, flux_monitor_spec_id, keeper_spec_id, cron_spec_id, vrf_spec_id) = 1
  );
  
  -- +goose Down
  ALTER TABLE jobs DROP CONSTRAINT chk_only_one_spec,
  ADD CONSTRAINT chk_only_one_spec CHECK (
      num_nonnulls(offchainreporting_oracle_spec_id, direct_request_spec_id, flux_monitor_spec_id, keeper_spec_id, cron_spec_id) = 1
  );
  
  ALTER TABLE jobs DROP COLUMN vrf_spec_id;
  DROP TABLE IF EXISTS vrf_specs;