X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_050_buffer.sql;h=0d92f43c891a6caf840c0102a7b4d8aa4b9c336a;hp=a10265b51a08278d54cf36c703ad24a8c3d04c9c;hb=c382e0c11f80fb37307ecc42c487aa433c97ad8c;hpb=899709300734acc2bac01b1d57a1fd8fe2a6d923 diff --git a/src/core/SQL/PostgreSQL/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/setup_050_buffer.sql index a10265b5..0d92f43c 100644 --- a/src/core/SQL/PostgreSQL/setup_050_buffer.sql +++ b/src/core/SQL/PostgreSQL/setup_050_buffer.sql @@ -12,6 +12,7 @@ create TABLE buffer ( bufferactivity integer NOT NULL DEFAULT 0, key varchar(128), joined boolean NOT NULL DEFAULT FALSE, -- BOOL + cipher TEXT, UNIQUE(userid, networkid, buffercname), CHECK (buffer.lastseenmsgid <= buffer.lastmsgid) )