docs: Move SQL schema to README.md, add more help

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

diff --git a/src/core/SQL/PostgreSQL/setup_060_backlog.sql b/src/core/SQL/PostgreSQL/setup_060_backlog.sql
index 0523fcd..4352f2e 100644 (file)
--- a/src/core/SQL/PostgreSQL/setup_060_backlog.sql
+++ b/src/core/SQL/PostgreSQL/setup_060_backlog.sql
@@ -1,9 +1,10 @@
 CREATE TABLE backlog (
 CREATE TABLE backlog (

-       messageid serial PRIMARY KEY,
+       messageid bigserial PRIMARY KEY,

        time timestamp NOT NULL,
        bufferid integer NOT NULL REFERENCES buffer (bufferid) ON DELETE CASCADE,
        type integer NOT NULL,
        flags integer NOT NULL,
        time timestamp 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,
+       senderid bigint NOT NULL REFERENCES sender (senderid) ON DELETE SET NULL,
+       senderprefixes TEXT,

        message TEXT
 )
        message TEXT
 )