first version of postgres backend

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

diff --git a/src/core/SQL/PostgreSQL/14/setup_060_backlog.sql b/src/core/SQL/PostgreSQL/14/setup_060_backlog.sql
new file mode 100644 (file)
index 0000000..1f281b0
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/14/setup_060_backlog.sql
@@ -0,0 +1,9 @@
+CREATE TABLE backlog (
+       messageid serial PRIMARY KEY,
+       time integer NOT NULL,
+       bufferid integer NOT NULL REFERENCES buffer (bufferid) ON DELETE CASCADE,
+       type integer NOT NULL,
+       flags integer NOT NULL,
+       senderid integer NOT NULL REFERENCES sender (senderid) ON DELETE SET NULL,
+       message TEXT
+)