Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Normal
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: Schema change, 2016-05-23
-
Component/s: Database setup, Schema Change
-
Labels:None
Description
When places were introduced, the schema change upgrade scripts didn't create primary key constraints on the new tables (place, edit_place, l_X_place, place_alias, etc.). Consequently, slaves that were set up before still don't have these.
This also means there is no index on the id columns, or on (edit, place) for edit_place, which might lead to performance issues, especially as the number of places in the database grows.
The missing constraints/indexes should be added at the next schema change.
Attachments
Issue Links
- is related to
-
MBH-421 Bring the production database into sync with the specification
-
- Decision Required
-