core: Separate SQL current and upgrade scripts

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

diff --git a/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql b/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
deleted file mode 100644 (file)
index a9206ac..0000000
--- a/src/core/SQL/PostgreSQL/20/setup_050_buffer.sql
+++ /dev/null
@@ -1,16 +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,
-       lastmsgid 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),
-       CHECK (buffer.lastseenmsgid <= buffer.lastmsgid)
-)