many database things, not really related to subforums but it's probably better to do all these things at the same time

1 files changed, 7 insertions, 0 deletions

diff --git a/apioforum/db.py b/apioforum/db.py
index 84f268d..7dd635e 100644
--- a/apioforum/db.py
+++ b/apioforum/db.py
@@ -110,6 +110,13 @@ ALTER TABLE threads_new RENAME TO threads;
 COMMIT;
 PRAGMA foreign_keys = on;
 """,
+"""
+CREATE VIEW most_recent_posts AS
+    SELECT max(id), * FROM posts GROUP BY thread;
+
+CREATE VIEW number_of_posts AS
+    SELECT thread, count(*) AS num_replies FROM posts GROUP BY thread;
+""",
     
 ]