Separate persistency for marker line (backend only)

[quassel.git] / src / core / SQL / PostgreSQL / 14 / setup_050_buffer.sql

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 (file)
index d620a76..0000000
--- 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)
-)