jevstrudel.git / worker / migrations / 0001_votes.sql
1-- "Do you agree with Jev?" votes (src/votes.ts): a count per (a, b, pick),
2-- and nothing else: no time, no address, no visitor. votes.ts validates a
3-- vote against the deploy's song list before it gets here; the checks below
4-- hold what cannot depend on that list.
5CREATE TABLE votes (
6  a TEXT NOT NULL,
7  b TEXT NOT NULL,
8  pick TEXT NOT NULL,
9  n INTEGER NOT NULL CHECK (n > 0),
10  PRIMARY KEY (a, b, pick),
11  CHECK (a <> b),
12  CHECK (pick IN (a, b))
13) STRICT;