Only list threads with posts in the last 50 days as new and unread

[ndwebbie.git] / database / ndawn.sql

diff --git a/database/ndawn.sql b/database/ndawn.sql
index 54ede3a5c10269a2c966b8f2863d1630813f239f..1853e4fc014b2cb5449d05721d8c884a9f2aa834 100644 (file)
--- a/database/ndawn.sql
+++ b/database/ndawn.sql
@@ -1462,10 +1462,10 @@ CREATE TABLE email_change (
     id text DEFAULT md5(((now() + (random() * '100 years'::interval)))::text) NOT NULL,
     uid integer NOT NULL,
     email text NOT NULL,
-    confirmed boolean DEFAULT false NOT NULL
+    confirmed boolean DEFAULT false NOT NULL,
+    time timestamptz DEFAULT now()
 );
 
-
 ALTER TABLE email_change OWNER TO ndawn;
 
 --
@@ -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
 --