From 7af49ab274e7ea650abfecb323ae4b510960b5c3 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 12 Aug 2003 18:32:54 +0000
Subject: - 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.
---
 database/database.mssql | 1 +
 database/database.pgsql | 1 +
 2 files changed, 2 insertions(+)

(limited to 'database')

diff --git a/database/database.mssql b/database/database.mssql
index a5f1a698e..25eb3a1f9 100644
--- a/database/database.mssql
+++ b/database/database.mssql
@@ -83,6 +83,7 @@ CREATE TABLE [dbo].[comments] (
   [link] [varchar] (16) NULL ,
   [score] [int] NOT NULL ,
   [status] [tinyint] NOT NULL ,
+  [thread] [varchar] (255) NOT NULL ,
   [users] [varchar] (8000) NULL
 ) ON [PRIMARY]
 GO
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)
 );
-- 
cgit v1.2.3