aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorJérôme Sautret <jerome.sautret@process-one.net>2020-04-10 16:20:43 +0200
committerGitHub <noreply@github.com>2020-04-10 16:20:43 +0200
commitb02506eaaf55e1da86ab258d074d888e1a498339 (patch)
tree8ae110f7747453ce72e9226b46cd984af654f649 /sql
parentMinor fixes in doc (diff)
parentchange publisher from text to varchar for mssql (diff)
Merge pull request #3132 from area-42/publisher_mssql_text_to_varchar
change PubSub publisher from text to varchar for mssql
Diffstat (limited to 'sql')
-rw-r--r--sql/mssql.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/mssql.sql b/sql/mssql.sql
index c54f1ab35..1a0587d97 100644
--- a/sql/mssql.sql
+++ b/sql/mssql.sql
@@ -209,7 +209,7 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW
CREATE TABLE [dbo].[pubsub_item] (
[nodeid] [bigint] NULL,
[itemid] [varchar] (255) NOT NULL,
- [publisher] [text] NOT NULL,
+ [publisher] [varchar] (250) NOT NULL,
[creation] [varchar] (32) NOT NULL,
[modification] [varchar] (32) NOT NULL,
[payload] [text] NOT NULL DEFAULT ''