aboutsummaryrefslogtreecommitdiff
path: root/sql/pg.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--sql/pg.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/pg.sql b/sql/pg.sql
index 16456fe0f..4863cb721 100644
--- a/sql/pg.sql
+++ b/sql/pg.sql
@@ -254,8 +254,8 @@ CREATE TABLE pubsub_item (
nodeid bigint REFERENCES pubsub_node(nodeid) ON DELETE CASCADE,
itemid text NOT NULL,
publisher text NOT NULL,
- creation text NOT NULL,
- modification text NOT NULL,
+ creation varchar(32) NOT NULL,
+ modification varchar(32) NOT NULL,
payload text NOT NULL DEFAULT ''
);
CREATE INDEX i_pubsub_item_itemid ON pubsub_item USING btree (itemid);