diff options
| author | Vicențiu Ciorbaru <cvicentiu@gmail.com> | 2013-10-17 15:06:09 -0700 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-10-17 15:06:09 -0700 |
| commit | 071c4ce88b04347c7d4933b1f6974f16981c0169 (patch) | |
| tree | a871a35ac81a9735e2aa37673600083e14d2ea16 /scripts/mysql_system_tables.sql | |
| parent | ee1e66468f9e514fa6c5b1a140393654fd71b352 (diff) | |
| download | mariadb-git-071c4ce88b04347c7d4933b1f6974f16981c0169.tar.gz | |
Removed no longer needed RoleHostFK as it is not used to link to a Role.
Also removed code that loads that column into memory.
Diffstat (limited to 'scripts/mysql_system_tables.sql')
| -rw-r--r-- | scripts/mysql_system_tables.sql | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/scripts/mysql_system_tables.sql b/scripts/mysql_system_tables.sql index bb397e495a9..de6c33fb4f9 100644 --- a/scripts/mysql_system_tables.sql +++ b/scripts/mysql_system_tables.sql @@ -44,10 +44,7 @@ set @had_user_table= @@warning_count != 0; CREATE TABLE IF NOT EXISTS roles_mapping ( HostFk char(60) binary DEFAULT '' NOT NULL, UserFk char(16) binary DEFAULT '' NOT NULL, - RoleHostFK char(60) binary DEFAULT '' NOT NULL, - RoleUserFk char(16) binary DEFAULT '' NOT NULL, - CONSTRAINT FOREIGN KEY (HostFk, UserFk) REFERENCES user (Host, User), - CONSTRAINT FOREIGN KEY (RoleHostFk, RoleUserFk) REFERENCES user (Host, User) + RoleFk char(16) binary DEFAULT '' NOT NULL ); |