common: Allow skipping negotiation of IRCv3 caps

[quassel.git] / src / core / SQL / PostgreSQL / setup_060_backlog.sql

diff --git a/src/core/SQL/PostgreSQL/setup_060_backlog.sql b/src/core/SQL/PostgreSQL/setup_060_backlog.sql
index 4c75e09..4352f2e 100644 (file)
--- a/src/core/SQL/PostgreSQL/setup_060_backlog.sql
+++ b/src/core/SQL/PostgreSQL/setup_060_backlog.sql
@@ -1,10 +1,10 @@
 CREATE TABLE backlog (
 CREATE TABLE backlog (

-       messageid serial PRIMARY KEY,
+       messageid bigserial PRIMARY KEY,

        time timestamp NOT NULL,
        bufferid integer NOT NULL REFERENCES buffer (bufferid) ON DELETE CASCADE,
        type integer NOT NULL,
        flags integer NOT NULL,
        time timestamp NOT NULL,
        bufferid integer NOT NULL REFERENCES buffer (bufferid) ON DELETE CASCADE,
        type integer NOT NULL,
        flags integer NOT NULL,

-       senderid integer NOT NULL REFERENCES sender (senderid) ON DELETE SET NULL,
+       senderid bigint NOT NULL REFERENCES sender (senderid) ON DELETE SET NULL,

        senderprefixes TEXT,
        message TEXT
 )
        senderprefixes TEXT,
        message TEXT
 )