Thread: db indexes
View Single Post
Old 12-17-2004, 10:07 AM   #2
Charter
Head Mole
 
Charter's Avatar
 
Join Date: May 2003
Posts: 2,539
Run the following queries to drop the duplicate index:
Code:
ALTER TABLE phpdig_excludes DROP INDEX ex_id;
ALTER TABLE phpdig_includes DROP INDEX in_id;
ALTER TABLE phpdig_keywords DROP INDEX key_id;
ALTER TABLE phpdig_logs DROP INDEX l_id;
ALTER TABLE phpdig_sites DROP INDEX site_id;
ALTER TABLE phpdig_spider DROP INDEX spider_id;
ALTER TABLE phpdig_tempspider DROP INDEX id;
__________________
Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.
Charter is offline   Reply With Quote