Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing index names #252

Open
PVince81 opened this issue Nov 15, 2018 · 0 comments
Open

Missing index names #252

PVince81 opened this issue Nov 15, 2018 · 0 comments
Labels
Milestone

Comments

@PVince81
Copy link
Contributor

oc_notifications have indices with missing names when setup from scratch:

  KEY `IDX_16B80748C96E70CF` (`app`),
  KEY `IDX_16B807488D93D649` (`user`),
  KEY `IDX_16B80748A5D6E63E` (`timestamp`),
  KEY `IDX_16B8074811CB6B3A232D562B` (`object_type`,`object_id`)

should be, which appears only when upgrading

  KEY `oc_notifications_app` (`app`),
  KEY `oc_notifications_user` (`user`),
  KEY `oc_notifications_timestamp` (`timestamp`),
  KEY `oc_notifications_object` (`object_type`,`object_id`)

Something might be wrong with the migrations.

We should add an extra migration to properly create the indices with names for initial setup, which should not affect performance.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant