Re: Problem with index and left join

[Erland Isaksson]

Apachez wrote:
> Since you seem locked by that external product
> perhaps you can still add a second column to the
> "external product table" ?
>

This would be a good idea if I only had to care about my own installation. The problem is that my code is actually a plugin to the external product, so my plugin will also be installed by other users. There are some problems related to this:

1.
The external product will regulary drop the tracks table and recreate it. I could patch the SQL scripts but that would complicate the installation which today just includes unzipping a file.

2.
The external product will regulary add new rows to the table and I guess this means that the external product would be need to be patched so it calculates a md5 sum for the new column when it inserts a new row. It might be possible to solve with a trigger but the problem is that it must be possible to run on mysql 4.0 besides 4.1 and 5.0 and I don't think 4.0 supports triggers.

3.
I would prefer if my plugin wasn't required to modify the external product tables since I feel that I might not have control of them in the other users installations. The database structure is also not an external interface for the product so I think its a good idea not to depend on it to much.