X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F19%2Fsetup_050_buffer.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F19%2Fsetup_050_buffer.sql;h=0000000000000000000000000000000000000000;hp=a4b0ce56b02fa6b264cef9e17fb62ed5e2884711;hb=d682289cc69fac3a5776ef29059cc1f54d8d37d4;hpb=97a9b1646bb0d6362cef14bac3a577481cc01e49

diff --git a/src/core/SQL/PostgreSQL/19/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/19/setup_050_buffer.sql
deleted file mode 100644
index a4b0ce56..00000000
--- a/src/core/SQL/PostgreSQL/19/setup_050_buffer.sql
+++ /dev/null
@@ -1,14 +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,
-	markerlinemsgid integer NOT NULL DEFAULT 0,
-	key varchar(128),
-	joined boolean NOT NULL DEFAULT FALSE, -- BOOL
-	UNIQUE(userid, networkid, buffercname)
-)