CREATE TABLE IF NOT EXISTS polls (
    id TEXT NOT NULL PRIMARY KEY,
    owner TEXT NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    created BIGINT NOT NULL,
    expires INT NOT NULL DEFAULT 86400000, -- expires in a day by default
    option_a TEXT NOT NULL,
    option_b TEXT NOT NULL,
    option_c TEXT NOT NULL,
    option_d TEXT NOT NULL,
    votes_a INT NOT NULL DEFAULT 0,
    votes_b INT NOT NULL DEFAULT 0,
    votes_c INT NOT NULL DEFAULT 0,
    votes_d INT NOT NULL DEFAULT 0
)
