summaryrefslogtreecommitdiff
path: root/util/dump.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-10-10 15:51:57 +0200
committerYorhel <git@yorhel.nl>2009-10-10 15:51:57 +0200
commit5ce2ce4c494feef5940c032549472a52b5282ad1 (patch)
tree89efb88dc1fc0afbb2d4ba3b29a37e154453edeb /util/dump.sql
parent1e125f67ab50a5de477c538b3f7dd27a9ec3c62f (diff)
Display number of unread posts in user menu
Instead of displaying the total number of threads. Posts are marked as read when the thread is opened.
Diffstat (limited to 'util/dump.sql')
-rw-r--r--util/dump.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 10d13b9d..c952c162 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -240,6 +240,7 @@ CREATE TABLE threads_boards (
tid integer NOT NULL DEFAULT 0,
type character(2) NOT NULL DEFAULT 0,
iid integer NOT NULL DEFAULT 0,
+ lastread smallint NOT NULL,
PRIMARY KEY(tid, type, iid)
);