* REPLACE Considered harmful.

  CREATE TABLE poll_question (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    question TEXT
  );

  CREATE TABLE poll_answer (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    question_id INTEGER,
    answer TEXT,
    ord  INTEGER
  );
  CREATE UNIQUE INDEX udx_answer ON poll_answer(question_id, ord);

  CREATE TABLE poll_results (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    question_id INTEGER,
    answer_id    INTEGER    
  );

  INSERT INTO poll_question (question)
  VALUES ('What is your favorite color?');

  INSERT INTO poll_answer (answer, question_id, ord)
  VALUES ('blue', 1,  1);
  INSERT INTO poll_answer (answer, question_id, ord)
  VALUES ('red', 1,   2);
  INSERT INTO poll_answer (answer, question_id, ord)
  VALUES ('green', 1, 3);
  INSERT INTO poll_answer (answer, question_id, ord)
  VALUES ('purple', 1, 4);

  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 1);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 1);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 1);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 2);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 2);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 3);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 3);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 3);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 3);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 4);
  INSERT INTO poll_results (question_id, answer_id)
  VALUES (1, 4);

  REPLACE INTO poll_answer (answer, question_id, ord)
  VALUES  ('red', 1, 1);
  REPLACE INTO poll_answer (answer, question_id, ord)
  VALUES  ('purple', 1, 2);
  REPLACE INTO poll_answer (answer, question_id, ord)
  VALUES  ('blue', 1, 3);
  REPLACE INTO poll_answer (answer, question_id, ord)
  VALUES  ('green', 1, 4);