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/mssql.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'sql/mssql.sql')

diff --git a/sql/mssql.sql b/sql/mssql.sql
index 2dbe473c0..648dfb9ed 100644
--- a/sql/mssql.sql
+++ b/sql/mssql.sql
@@ -220,8 +220,8 @@ CREATE TABLE [dbo].[pubsub_item] (
         [nodeid] [bigint] NULL,
         [itemid] [varchar] (255) NOT NULL,
         [publisher] [text] NOT NULL,
-        [creation] [text] NOT NULL,
-        [modification] [varchar] (255) NOT NULL,
+        [creation] [varchar] (32) NOT NULL,
+        [modification] [varchar] (32) NOT NULL,
         [payload] [text] NOT NULL DEFAULT ''
 ) TEXTIMAGE_ON [PRIMARY];
 
-- 
cgit v1.2.3

