1 Commits (mr13.3)

Author	SHA1	Message	Date
Kirill Solomko	2c7b59aab1	MT#59836 fix voip_preferences_enum preference_id key ... base/8629.up introduced voip_preferences_enum with auto named foreign key as "FOREIGN KEY (preference_id) REFERENCES voip_preferences (id)" which auto created a missing index as `preference_id` (`preference_id`). diff/15787.up re-created the foreign key as named "ADD CONSTRAINT `pref_id_fk` FOREIGN KEY (`preference_id`) ... " which normally should cause the auto created `preference_id` key to be renamed to `pref_id_fk`. but customers who had their database re-synced, had that index turned from "auto created" to "permanent" and therefore, causing diff/15787.up to keep the original index name as `preference_id`. that in turn, caused ngcp-mysql-compare-dbs to report db inconsistencies as the default schema/.sql files are built with `pref_id_fk`. the current fix addresses the index issue by dropping it as either `preference_id` or `pref_id_fk` and creating it as a named index `pref_id_idx`, so that it wont be affected by the issue anymore. (cherry picked from commit 49f3d915eb) Change-Id: I4c777902251f915a1b07e92744d78e81087d607c	8 months ago