summaryrefslogtreecommitdiff
path: root/database/database.pgsql
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2003-08-12 18:32:54 +0000
committerDries Buytaert <dries@buytaert.net>2003-08-12 18:32:54 +0000
commit7af49ab274e7ea650abfecb323ae4b510960b5c3 (patch)
tree7e9e586af70bd817262aac501c73c6b545f5911b /database/database.pgsql
parentab6db2867158923f17601edfd9718151dbfb304a (diff)
downloadbrdo-7af49ab274e7ea650abfecb323ae4b510960b5c3.tar.gz
brdo-7af49ab274e7ea650abfecb323ae4b510960b5c3.tar.bz2
- Committed Marco's comment module patch:
+ Dramatically improves performance of large discussions/threads: only very few SQL queries are required. + Replaces custom pager with standard pager. Modifications by me: + Reworded some code comments. + Removed dependencies on pager internals.
Diffstat (limited to 'database/database.pgsql')
-rw-r--r--database/database.pgsql1
1 files changed, 1 insertions, 0 deletions
diff --git a/database/database.pgsql b/database/database.pgsql
index 2e26a9f4f..9c8232514 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -123,6 +123,7 @@ CREATE TABLE comments (
link varchar(16) NOT NULL default '',
score integer NOT NULL default '0',
status smallint NOT NULL default '0',
+ thread vharchar(255) NOT NULL,
users text default '',
PRIMARY KEY (cid)
);