Improve performance of PostgreSQL for large databases.

[quassel.git] / src / core / SQL / PostgreSQL / 20 / setup_050_buffer.sql

diff --git a/src/core/SQL/PostgreSQL/19/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
similarity index 92%
rename from src/core/SQL/PostgreSQL/19/setup_050_buffer.sql
rename to src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
index a4b0ce5..bbf8ab6 100644 (file)
--- a/src/core/SQL/PostgreSQL/19/setup_050_buffer.sql
+++ b/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
@@ -6,6 +6,7 @@ create TABLE buffer (
        buffername varchar(128) NOT NULL,
        buffercname varchar(128) NOT NULL, -- CANONICAL BUFFER NAME (lowercase version)
        buffertype integer NOT NULL DEFAULT 0,
        buffername varchar(128) NOT NULL,
        buffercname varchar(128) NOT NULL, -- CANONICAL BUFFER NAME (lowercase version)
        buffertype integer NOT NULL DEFAULT 0,

+        lastmsgid integer NOT NULL DEFAULT 0,

        lastseenmsgid integer NOT NULL DEFAULT 0,
        markerlinemsgid integer NOT NULL DEFAULT 0,
        key varchar(128),
        lastseenmsgid integer NOT NULL DEFAULT 0,
        markerlinemsgid integer NOT NULL DEFAULT 0,
        key varchar(128),