X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_060_backlog.sql;h=4352f2ebe4e08c40c5a5e38694a1577dcfe70192;hp=1711b231455eeb5f0fc871885cd090c95e707b29;hb=6a835281b265df6a06b7f41109ad2d449899fed0;hpb=dba66762993507168b1a3de25cfd2d7bff0ff969 diff --git a/src/core/SQL/PostgreSQL/setup_060_backlog.sql b/src/core/SQL/PostgreSQL/setup_060_backlog.sql index 1711b231..4352f2eb 100644 --- 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 ( - 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, - senderid integer NOT NULL REFERENCES sender (senderid) ON DELETE SET NULL, - senderprefixes TEXT, + senderid bigint NOT NULL REFERENCES sender (senderid) ON DELETE SET NULL, + senderprefixes TEXT, message TEXT )