models: adds index on version_id and bucket_id

inveniosoftware / invenio-files-rest

REST API for uploading/downloading files for Invenio.

https://invenio-files-rest.readthedocs.io

MIT License

9 stars 67 forks source link

models: adds index on version_id and bucket_id #304

Open jrcastro2 opened 8 months ago

jrcastro2 commented 8 months ago

adds alembic recipe
closes zenodo/rdm-project#640

slint commented 7 months ago

Apparently MySQL anyways automatically creates indices on FKs and dropping the index is not allowed.

@jrcastro2 can you look into if it's possible to conditionally in the downgrade recipe to not drop the index if we're on MySQL? If this isn't easy then we can remove mysql from the test matrix and open an issue.