[sung]

Originally Posted by entertain

@digitalpoint:
I didn't want to change the database structure, because maybe vbenhancer is going to release v3 with the old structures and this would make an update to v3 very, very difficult.

If he was changing the table schema you'd be correct, however changing the indexes won't have any effect on that since you can just rebuild them.

To make his changes you'd just put the following queries in the install/upgrade code:

alter table itrader drop index rateid;
alter table itrader drop index rateduserid;
alter table itrader add index rateid (rateid);
alter table itrader add index rateduserid (rateduserid, dateline);
alter table itrader add index rateduserid2 (rateduserid, buyselltrade);

And to go back to the previous indexes:

alter table itrader drop index rateid;
alter table itrader drop index rateduserid;
alter table itrader drop index rateduserid2;
alter table itrader add index rateid (rateid, dateline);
alter table itrader add index rateduserid (rateid, dateline);

Unless you have some inside knowledge about a 3.x release, no sense in making the current version slower for no reason.