making use of postgres timestamps

[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
index 1f281b0..0523fcd 100644 (file)
--- a/src/core/SQL/PostgreSQL/14/setup_060_backlog.sql
+++ b/src/core/SQL/PostgreSQL/14/setup_060_backlog.sql
@@ -1,6 +1,6 @@
 CREATE TABLE backlog (
        messageid serial PRIMARY KEY,
-       time 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,