GUACAMOLE-363: Switch to 4000 for nvarchar size instead of max.
Project: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/commit/7ecd3915 Tree: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/tree/7ecd3915 Diff: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/diff/7ecd3915 Branch: refs/heads/master Commit: 7ecd3915c6a65a94c57b3d2c181501626e0595d7 Parents: 82d1b14 Author: Nick Couchman <vn...@apache.org> Authored: Wed Sep 27 08:56:28 2017 -0400 Committer: Nick Couchman <vn...@apache.org> Committed: Thu Sep 28 07:00:52 2017 -0400 ---------------------------------------------------------------------- .../guacamole-auth-jdbc-sqlserver/schema/001-create-schema.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-guacamole-client/blob/7ecd3915/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/001-create-schema.sql ---------------------------------------------------------------------- diff --git a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/001-create-schema.sql b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/001-create-schema.sql index 6c3cd7b..5bb2f8a 100644 --- a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/001-create-schema.sql +++ b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/001-create-schema.sql @@ -223,7 +223,7 @@ SET QUOTED_IDENTIFIER ON; CREATE TABLE [guacamole_connection_parameter]( [connection_id] [int] NOT NULL, [parameter_name] [nvarchar](128) NOT NULL, - [parameter_value] [nvarchar](max) NOT NULL, + [parameter_value] [nvarchar](4000) NOT NULL, CONSTRAINT [PK_guacamole_connection_parameter] PRIMARY KEY CLUSTERED ([connection_id] ASC, [parameter_name] ASC) @@ -256,7 +256,7 @@ SET QUOTED_IDENTIFIER ON; CREATE TABLE [guacamole_sharing_profile_parameter]( [sharing_profile_id] [int] NOT NULL, [parameter_name] [nvarchar](128) NOT NULL, - [parameter_value] [nvarchar](max) NOT NULL, + [parameter_value] [nvarchar](4000) NOT NULL, CONSTRAINT [PK_guacamole_sharing_profile_parameter] PRIMARY KEY CLUSTERED ([sharing_profile_id] ASC, [parameter_name] ASC)