X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;ds=sidebyside;f=src%2Fcore%2FSQL%2FPostgreSQL%2F14%2Fsetup_050_buffer.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F14%2Fsetup_050_buffer.sql;h=0000000000000000000000000000000000000000;hb=18cda6df43b5960686256fb6a899a63baebff70d;hp=d620a76127d026a4a08b006ad5d09964da35b6ee;hpb=91361e82b8cd46e7c4bfc4475e6ecb1d0b268310;p=quassel.git diff --git a/src/core/SQL/PostgreSQL/14/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/14/setup_050_buffer.sql deleted file mode 100644 index d620a761..00000000 --- a/src/core/SQL/PostgreSQL/14/setup_050_buffer.sql +++ /dev/null @@ -1,13 +0,0 @@ -create TABLE buffer ( - bufferid serial PRIMARY KEY, - userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE, - groupid integer, - networkid integer NOT NULL REFERENCES network (networkid) ON DELETE CASCADE, - buffername varchar(128) NOT NULL, - buffercname varchar(128) NOT NULL, -- CANONICAL BUFFER NAME (lowercase version) - buffertype integer NOT NULL DEFAULT 0, - lastseenmsgid integer NOT NULL DEFAULT 0, - key varchar(128), - joined boolean NOT NULL DEFAULT FALSE, -- BOOL - UNIQUE(userid, networkid, buffercname) -)