CREATE TABLE IF NOT EXISTS meeting_open_ballot_votes (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  meeting_id INT UNSIGNED NOT NULL,
  meeting_owner_id INT UNSIGNED NOT NULL,
  candidate_key INT UNSIGNED NOT NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  CONSTRAINT fk_open_ballot_votes_meeting
    FOREIGN KEY (meeting_id) REFERENCES meetings(id)
    ON DELETE CASCADE,
  CONSTRAINT fk_open_ballot_votes_owner
    FOREIGN KEY (meeting_owner_id) REFERENCES meeting_owners(id)
    ON DELETE CASCADE,
  UNIQUE KEY uniq_open_ballot_vote (meeting_owner_id, candidate_key),
  KEY idx_open_ballot_votes_meeting (meeting_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;