WCF icon indicating copy to clipboard operation
WCF copied to clipboard

Disallow creating unnamend (= autogenerated names) indices with the PHP DDL API

Open TimWolla opened this issue 4 years ago • 0 comments

Autogenerated names for database indices are pretty messy, because the legacy API did not handle them consistently depending on whether the INDEX was included in the initial CREATE TABLE (unnamed, implicitly named after the first column by MySQL) or added after the fact using ALTER TABLE (autogenerated by WoltLab Suite).

The PHP DDL API should require an explicit name for all newly created indices to ensure a consistent and explicit result going forward. It needs to be discussed how to handle existing packages without explicit names.

Related #4360

TimWolla avatar Sep 21 '21 14:09 TimWolla