X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fndawn.sql;h=1853e4fc014b2cb5449d05721d8c884a9f2aa834;hp=2da8987c6f2f16ad7bcd5e16dee86e169be1783e;hb=aa93c4baf476e9fa421e1a5ce0d97e9527d33417;hpb=612f5232bc9d8966b209da8f04cf0fb5619f867e

diff --git a/database/ndawn.sql b/database/ndawn.sql
index 2da8987..1853e4f 100644
--- a/database/ndawn.sql
+++ b/database/ndawn.sql
@@ -3316,6 +3316,8 @@ CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
 
 
+CREATE INDEX forum_threads_mtime_index ON forum_threads USING btree (mtime);
+
 --
 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: ndawn
 --