  * The sharing_profile table stores profiles that allow
  * connections to be shared amongst multiple users.
  */
-SET ANSI_NULLS ON;
-SET QUOTED_IDENTIFIER ON;
 CREATE TABLE [guacamole_sharing_profile](
     [sharing_profile_id] [int] IDENTITY(1,1) NOT NULL,
     [sharing_profile_name] [nvarchar](128) NOT NULL,
     [primary_connection_id] [int] NOT NULL,
 
     CONSTRAINT [PK_guacamole_sharing_profile] PRIMARY KEY CLUSTERED 
-        ([sharing_profile_id] ASC)
-        WITH (PAD_INDEX = OFF,
-            STATISTICS_NORECOMPUTE = OFF,
-            IGNORE_DUP_KEY = OFF,
-            ALLOW_ROW_LOCKS = ON,
-            ALLOW_PAGE_LOCKS = ON)
-        ON [PRIMARY]
+        ([sharing_profile_id] ASC) ON [PRIMARY]
 ) ON [PRIMARY];
 
 /**

 * The connection_group_permission table stores permission mappings for
 * connection_group objects.
 */
SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
CREATE TABLE [guacamole_connection_group_permission](
    [user_id] [int] NOT NULL,
    [connection_group_id] [int] NOT NULL,
    [permission] [guacamole_permission] NOT NULL,

    CONSTRAINT [PK_guacamole_connection_group_permission] PRIMARY KEY CLUSTERED 
        ([user_id] ASC,	[connection_group_id] ASC, [permission] ASC)
        WITH (PAD_INDEX = OFF,
            STATISTICS_NORECOMPUTE = OFF,
            IGNORE_DUP_KEY = OFF,
            ALLOW_ROW_LOCKS = ON,
            ALLOW_PAGE_LOCKS = ON) 
        ON [PRIMARY]
) ON [PRIMARY];

/**

 * The sharing_profile_permission table stores permission
 * mappings for sharing_profile objects.
 */
CREATE TABLE [guacamole_sharing_profile_permission](
    [user_id] [int] NOT NULL,
    [sharing_profile_id] [int] NOT NULL,
    [permission] [guacamole_permission] NOT NULL,

    CONSTRAINT [PK_guacamole_sharing_profile_permission] PRIMARY KEY CLUSTERED 
        ([user_id] ASC, [sharing_profile_id] ASC, [permission] ASC) ON [PRIMARY]
) ON [PRIMARY];

/**
