this was a particularly horrible merge conflict but i think it all works now

1 files changed, 4 insertions, 0 deletions

diff --git a/apioforum/db.py b/apioforum/db.py
index 97bd0e2..abcd774 100644
--- a/apioforum/db.py
+++ b/apioforum/db.py
@@ -151,6 +151,10 @@ CREATE VIEW most_recent_posts AS
 CREATE VIEW number_of_posts AS
     SELECT thread, count(*) AS num_replies FROM posts GROUP BY thread;
 """,
+"""
+CREATE VIEW total_vote_counts AS
+    SELECT poll, count(*) AS total_votes FROM votes WHERE current AND NOT is_retraction GROUP BY poll;
+""",
 ]
 
 def init_db():