GUACAMOLE-220: Correct documentation of update script. The UNIQUE constraint is being added once the column is expected to be unique, not necessarily because it should safely point to entries of a particular table.
Project: http://git-wip-us.apache.org/repos/asf/guacamole-client/repo Commit: http://git-wip-us.apache.org/repos/asf/guacamole-client/commit/bb6e8bc1 Tree: http://git-wip-us.apache.org/repos/asf/guacamole-client/tree/bb6e8bc1 Diff: http://git-wip-us.apache.org/repos/asf/guacamole-client/diff/bb6e8bc1 Branch: refs/heads/staging/1.0.0 Commit: bb6e8bc1c74e5aab7978fe8c2ca70c84a929f924 Parents: 7521cdc Author: Michael Jumper <mjum...@apache.org> Authored: Thu Sep 27 20:15:23 2018 -0700 Committer: Michael Jumper <mjum...@apache.org> Committed: Thu Sep 27 20:15:23 2018 -0700 ---------------------------------------------------------------------- .../guacamole-auth-jdbc-mysql/schema/upgrade/upgrade-pre-1.0.0.sql | 2 +- .../schema/upgrade/upgrade-pre-1.0.0.sql | 2 +- .../schema/upgrade/upgrade-pre-1.0.0.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/guacamole-client/blob/bb6e8bc1/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/schema/upgrade/upgrade-pre-1.0.0.sql ---------------------------------------------------------------------- diff --git a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/schema/upgrade/upgrade-pre-1.0.0.sql b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/schema/upgrade/upgrade-pre-1.0.0.sql index 8332d7f..0fccb61 100644 --- a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/schema/upgrade/upgrade-pre-1.0.0.sql +++ b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-mysql/schema/upgrade/upgrade-pre-1.0.0.sql @@ -145,7 +145,7 @@ UPDATE guacamole_user SET entity_id = ( -- The entity_id column should now be safely non-NULL ALTER TABLE guacamole_user MODIFY entity_id int(11) NOT NULL; --- The entity_id column should now safely point to guacamole_entity entries +-- The entity_id column should now be unique for each user ALTER TABLE guacamole_user ADD CONSTRAINT guacamole_user_single_entity UNIQUE (entity_id); http://git-wip-us.apache.org/repos/asf/guacamole-client/blob/bb6e8bc1/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-postgresql/schema/upgrade/upgrade-pre-1.0.0.sql ---------------------------------------------------------------------- diff --git a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-postgresql/schema/upgrade/upgrade-pre-1.0.0.sql b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-postgresql/schema/upgrade/upgrade-pre-1.0.0.sql index dd341dc..83dfa86 100644 --- a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-postgresql/schema/upgrade/upgrade-pre-1.0.0.sql +++ b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-postgresql/schema/upgrade/upgrade-pre-1.0.0.sql @@ -155,7 +155,7 @@ UPDATE guacamole_user SET entity_id = ( ALTER TABLE guacamole_user ALTER COLUMN entity_id SET NOT NULL; --- The entity_id column should now safely point to guacamole_entity entries +-- The entity_id column should now be unique for each user ALTER TABLE guacamole_user ADD CONSTRAINT guacamole_user_single_entity UNIQUE (entity_id); http://git-wip-us.apache.org/repos/asf/guacamole-client/blob/bb6e8bc1/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/upgrade/upgrade-pre-1.0.0.sql ---------------------------------------------------------------------- diff --git a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/upgrade/upgrade-pre-1.0.0.sql b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/upgrade/upgrade-pre-1.0.0.sql index 6e9133a..7b4fc88 100644 --- a/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/upgrade/upgrade-pre-1.0.0.sql +++ b/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-sqlserver/schema/upgrade/upgrade-pre-1.0.0.sql @@ -202,7 +202,7 @@ GO ALTER TABLE [guacamole_user] ALTER COLUMN [entity_id] [int] NOT NULL; --- The entity_id column should now safely point to guacamole_entity entries +-- The entity_id column should now be unique for each user ALTER TABLE [guacamole_user] ADD CONSTRAINT [AK_guacamole_user_single_entity] UNIQUE ([entity_id]);