first version of postgres backend

[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
new file mode 100644 (file)
index 0000000..d620a76
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/14/setup_050_buffer.sql
@@ -0,0 +1,13 @@
+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)
+)