You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

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
..
base	MT#59386 address foreign key handling in 6425.up/down	2 years ago
diff	MT#59836 fix voip_preferences_enum preference_id key	8 months ago
init	…