Firstly I'd like to say that axmls is great, I'm working with it on a few different projects and finding it extremely useful.
Anyway, my question is with regard to dropping indexes, on MySQL if I use upgradeSchema the generated sql will attempt to drop all indexes before creation, this causes problems if they do not already exist.
I am not quite sure the best way to implement it, but it seems there is a need for a function to either find out if a specified index exists or get a list of defined indexes. Then it would be possible to only drop those indexes that exist and avoid the nasty errors that result when you try to drop a nonexistent index.
Dan Cech
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Firstly I'd like to say that axmls is great, I'm working with it on a few different projects and finding it extremely useful.
Anyway, my question is with regard to dropping indexes, on MySQL if I use upgradeSchema the generated sql will attempt to drop all indexes before creation, this causes problems if they do not already exist.
I am not quite sure the best way to implement it, but it seems there is a need for a function to either find out if a specified index exists or get a list of defined indexes. Then it would be possible to only drop those indexes that exist and avoid the nasty errors that result when you try to drop a nonexistent index.
Dan Cech