From 61dee97738f6f6459a9b5cb26ae29c3e27db7dd9 Mon Sep 17 00:00:00 2001
From: Christophe Romain <christophe.romain@process-one.net>
Date: Tue, 24 Apr 2018 14:44:52 +0200
Subject: Pubsub creation/modification use varchar (#2397)

---
 sql/mysql.new.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'sql/mysql.new.sql')

diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql
index d9c4cb915..395a8aa64 100644
--- a/sql/mysql.new.sql
+++ b/sql/mysql.new.sql
@@ -274,8 +274,8 @@ CREATE TABLE pubsub_item (
   nodeid bigint,
   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
 ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 CREATE INDEX i_pubsub_item_itemid ON pubsub_item(itemid(36));
-- 
cgit v1.2.3

