GUACAMOLE-363: Do not declare custom types as default "NOT NULL". Rely on column definitions for such semantics.
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 16525c0..91ba377 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
@@ -27,7 +27,7 @@
);
GO
-CREATE TYPE [guacamole_connection_group_type] FROM [nvarchar](16) NOT NULL;
+CREATE TYPE [guacamole_connection_group_type] FROM [nvarchar](16);
EXEC sp_bindrule
'guacamole_connection_group_type_list',
'guacamole_connection_group_type';
@@ -45,7 +45,7 @@
);
GO
-CREATE TYPE [guacamole_object_permission] FROM [nvarchar](16) NOT NULL;
+CREATE TYPE [guacamole_object_permission] FROM [nvarchar](16);
EXEC sp_bindrule
'guacamole_object_permission_list',
'guacamole_object_permission';
@@ -64,7 +64,7 @@
);
GO
-CREATE TYPE [guacamole_system_permission] FROM [nvarchar](32) NOT NULL;
+CREATE TYPE [guacamole_system_permission] FROM [nvarchar](32);
EXEC sp_bindrule
'guacamole_system_permission_list',
'guacamole_system_permission';
@@ -80,7 +80,7 @@
);
GO
-CREATE TYPE [guacamole_proxy_encryption_method] FROM [nvarchar](8) NOT NULL;
+CREATE TYPE [guacamole_proxy_encryption_method] FROM [nvarchar](8);
EXEC sp_bindrule
'guacamole_proxy_encryption_method_list',
'guacamole_proxy_encryption_method';
