search

znuny / Znuny

Znuny/Znuny LTS is a fork of the ((OTRS)) Community Edition, one of the most flexible web-based ticketing systems used for Customer Service, Help Desk, IT Service Management.
https://www.znuny.org
GNU General Public License v3.0
343 stars 83 forks source link

Bug - Some schema names not updated on upgrade #421

Open pboguslawski opened 1 year ago

pboguslawski commented 1 year ago

Environment

Expected behaviour

Schema object names after upgrading 6.0 LTS to 6.5 LTS identical with schema names in fresh 6.5 LTS installation.

Actual behaviour

After upgrading exiting 6.0.48 to 6.5.2 (source method), some FKs names was left unotuched in MariaDB (Debian 11):

KEY `FK_groups_create_by_id` (`create_by`),
KEY `FK_groups_change_by_id` (`change_by`),
KEY `FK_groups_valid_id_id` (`valid_id`),
CONSTRAINT `FK_groups_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
CONSTRAINT `FK_groups_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
CONSTRAINT `FK_groups_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`)

Same objects have different name in fresh 6.5 install:

KEY `FK_permission_groups_create_by_id` (`create_by`),
KEY `FK_permission_groups_change_by_id` (`change_by`),
KEY `FK_permission_groups_valid_id_id` (`valid_id`),
CONSTRAINT `FK_permission_groups_change_by_id` FOREIGN KEY (`change_by`) REFERENCES `users` (`id`),
CONSTRAINT `FK_permission_groups_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`),
CONSTRAINT `FK_permission_groups_valid_id_id` FOREIGN KEY (`valid_id`) REFERENCES `valid` (`id`)