Skip to content

Change name of acl "groups" table due to conflict with MySQL reserved words #873

@hatfieldjm4

Description

@hatfieldjm4

This was discovered in the guidance given after the MySQL 8.4 upgrade in the dev environment. There are some MySQL "reserved" words that should be avoided for table names because of potential conflicts, confusion, and syntax errors for other developers or future system upgrades. One of these table names is "groups" which we have in our gear_acl schema.

I think we should rename this table and all references to it as "roles" instead of "groups".

Metadata

Metadata

Labels

applicationA task/issue involving work on the application codedatabaseA task/issue involving work on the database

Type

Projects

Status

Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions