-
Type: Refactoring
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.3.0-B1
-
Component/s: Database
-
Labels:
-
Change Log Group:Changed
-
Change Log Message:Replaced dual-column unique indexes with actual single column primary auto-increment keys.
-
Story Points:2
-
Sprint:In-Portal's First Sprint, In-Portal's 2nd Sprint
-
Copy Issue Key:
-
Patch Instructions:
-
BC Break Details:
Plan:
- Locate database tables, that don't have a primary key (e.g. CategoryItems, UserGroupRelations)
- For each of such tables add primary key column called Id, with auto-increment flag set, as first table column
- in PHP code search for changed database table usage cases, where combination of existing 2 or more columns were used to uniquely identify records in the table
- change each found usage (where it makes sense) to use newly added Id column instead