Repository: ranger Updated Branches: refs/heads/ranger-0.7 fd6047c45 -> 9381159d6
RANGER-1788:Install Ranger admin failure. Signed-off-by: Colm O hEigeartaigh <cohei...@apache.org> Project: http://git-wip-us.apache.org/repos/asf/ranger/repo Commit: http://git-wip-us.apache.org/repos/asf/ranger/commit/9381159d Tree: http://git-wip-us.apache.org/repos/asf/ranger/tree/9381159d Diff: http://git-wip-us.apache.org/repos/asf/ranger/diff/9381159d Branch: refs/heads/ranger-0.7 Commit: 9381159d671a5804fcb3a4a116e0d73566771a49 Parents: fd6047c Author: peng.jianhua <peng.jian...@zte.com.cn> Authored: Mon Sep 18 10:26:10 2017 +0800 Committer: Colm O hEigeartaigh <cohei...@apache.org> Committed: Tue Sep 19 15:00:04 2017 +0100 ---------------------------------------------------------------------- .../mysql/patches/028-add-unique-constraint-on-table-x_group.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ranger/blob/9381159d/security-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql b/security-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql index 2c5be73..078fb99 100644 --- a/security-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql +++ b/security-admin/db/mysql/patches/028-add-unique-constraint-on-table-x_group.sql @@ -23,7 +23,7 @@ DECLARE loginID bigint(20); /* check unique constraint exist on group_name column or not */ if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_group' and column_name='group_name' and column_key='UNI') then if not exists (select * from information_schema.table_constraints where table_schema=database() and table_name = 'x_group' and constraint_name='x_group_UK_group_name') then - ALTER IGNORE TABLE x_group ADD UNIQUE INDEX x_group_UK_group_name(group_name(767)); + ALTER TABLE x_group ADD UNIQUE INDEX x_group_UK_group_name(group_name(767)); -- ALTER TABLE x_group MODIFY COLUMN group_name varchar(767) NOT NULL, ADD CONSTRAINT x_group_UK_group_name UNIQUE(group_name(767)); end if; end if; @@ -32,7 +32,7 @@ DECLARE loginID bigint(20); if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_group_users' and column_name='user_id') then /* check unique constraint exist on group_name column or not */ if not exists (select * from information_schema.table_constraints where table_schema=database() and table_name = 'x_group_users' and constraint_name='x_group_users_UK_uid_gname') then - ALTER IGNORE TABLE x_group_users ADD UNIQUE INDEX x_group_users_UK_uid_gname(user_id,group_name(740)); + ALTER TABLE x_group_users ADD UNIQUE INDEX x_group_users_UK_uid_gname(user_id,group_name(740)); -- ALTER TABLE x_group_users MODIFY COLUMN group_name varchar(767), ADD CONSTRAINT x_group_users_UK_uid_gname UNIQUE(user_id,group_name(767)); end if; end if;
