1 files changed, 22 insertions, 0 deletions
diff --git a/util/updates/update_2.26.sql b/util/updates/update_2.26.sql
index 6900d080..691fdca7 100644
--- a/util/updates/update_2.26.sql
+++ b/util/updates/update_2.26.sql
@@ -7,3 +7,25 @@ UPDATE users SET passwd = '' WHERE length(passwd) = 41;
 -- Need to regenerate all relation graphs in the switch to HTML5
 UPDATE vn SET rgraph = NULL;
 UPDATE producers SET rgraph = NULL;
+
+
+-- Polls
+ALTER TABLE threads ADD COLUMN poll_question varchar(100);
+ALTER TABLE threads ADD COLUMN poll_max_options smallint NOT NULL DEFAULT 1;
+ALTER TABLE threads ADD COLUMN poll_preview boolean NOT NULL DEFAULT FALSE;
+ALTER TABLE threads ADD COLUMN poll_recast boolean NOT NULL DEFAULT FALSE;
+CREATE TABLE threads_poll_options (
+  id     SERIAL PRIMARY KEY,
+  tid    integer NOT NULL,
+  option varchar(100) NOT NULL
+);
+CREATE TABLE threads_poll_votes (
+  tid   integer NOT NULL,
+  uid   integer NOT NULL,
+  optid integer NOT NULL,
+  PRIMARY KEY (tid, uid, optid)
+);
+ALTER TABLE threads_poll_options     ADD CONSTRAINT threads_poll_options_tid_fkey      FOREIGN KEY (tid)       REFERENCES threads       (id) ON DELETE CASCADE;
+ALTER TABLE threads_poll_votes       ADD CONSTRAINT threads_poll_votes_tid_fkey        FOREIGN KEY (tid)       REFERENCES threads       (id) ON DELETE CASCADE;
+ALTER TABLE threads_poll_votes       ADD CONSTRAINT threads_poll_votes_uid_fkey        FOREIGN KEY (uid)       REFERENCES users         (id) ON DELETE CASCADE;
+ALTER TABLE threads_poll_votes       ADD CONSTRAINT threads_poll_votes_optid_fkey      FOREIGN KEY (optid)     REFERENCES threads_poll_options (id) ON DELETE CASCADE;