Polls

[nic-hartley]

Goal

Exactly what the title says. Polls. Used by the admins to gauge relative interest in a set of options.

Description

Allow admins to create a poll, and allow users (anyone signed-in or just donators?) to vote on the poll. Since admins are making them, we can probably trust them with unfiltered HTML input, and polls will be rare enough that we can run them all by a dev before they're posted just in case.

Additional notes

Tables will probably look like this:

CREATE TABLE polls (
  pid SERIAL PRIMARY KEY,
  title TEXT NOT NULL,
  description TEXT NOT NULL,
  options TEXT ARRAY NOT NULL
)

CREATE TABLE poll_votes (
  vid SERIAL PRIMARY KEY,
  voter SERIAL REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE,
  vote SERIAL
)

Creating a poll will require the user to be an admin; creating a poll_vote will only require the user to be signed in (or possibly a donator?)