summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2022-06-20 09:50:19 +0200
committerTor Andersson <tor@ccxvii.net>2022-06-21 12:25:52 +0200
commit97f041de8cb593d46ccb15141d92e1984d9847d1 (patch)
tree4826a72780bbd7546a20590e0b6e9ecbb81572f0 /schema.sql
parent28dbcd115dc23d920bf30de512a63efed8eeb58f (diff)
downloadserver-97f041de8cb593d46ccb15141d92e1984d9847d1.tar.gz
Some more mobile friendly layout tuning.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/schema.sql b/schema.sql
index 4527b9b..f3d5d02 100644
--- a/schema.sql
+++ b/schema.sql
@@ -180,12 +180,12 @@ create view thread_view as
author.name as author_name,
(
select
- count(*) - 1
+ count(*)
from
posts
where
posts.thread_id = threads.thread_id
- ) as replies,
+ ) as count,
(
select
max(posts.mtime)