ALTER TABLE opportunities MODIFY deadline DATE NULL;
ALTER TABLE opportunities MODIFY value DECIMAL(15,2) NULL;
CREATE TABLE IF NOT EXISTS opportunity_sources (
  opportunity_id BIGINT UNSIGNED PRIMARY KEY,
  external_id VARCHAR(100) NOT NULL UNIQUE,
  official_url VARCHAR(500) NOT NULL,
  published_at VARCHAR(40) NULL,
  status VARCHAR(120) NOT NULL,
  modality VARCHAR(120) NOT NULL,
  uf VARCHAR(2) NULL,
  payload JSON NOT NULL,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  FOREIGN KEY (opportunity_id) REFERENCES opportunities(id)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS collection_status (
  source VARCHAR(30) PRIMARY KEY,
  value JSON NOT NULL
) ENGINE=InnoDB;