Retracing my problem leads me to believe I never successfully created fulltext indexes for MySQL 3.23.58 MyISAM tables. I went to the MySQL manual and was able - or so I thought - to create them, however, my fulltext search queries fail in 3.23.58 but the exact queries (with same data) work perfectly in 4.0.10.
-- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- File: INDEXES.SQL
-- Created: 6/29/2004
-- Modified: 6/29/2004
-- Purpose: Create IVC table indexes
-- Dependencies: MySQL 3.23+ Database
-- Privacy Scope: SQL file. Be sure to render lockdown on /sql folder to prevent viewing/downloading of this script
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
ALTER TABLE image ADD INDEX ix_image_path (image_path);
ALTER TABLE image ADD FULLTEXT ix_search (image_name, image_alt, image_location_city, image_location_state, image_location_country);
ALTER TABLE album ADD INDEX ix_album_name (album_name);
ALTER TABLE department ADD INDEX ix_department_name (department_name);
ALTER TABLE department ADD INDEX ix_department_parent_id (department_parent_id);
ALTER TABLE person ADD INDEX ix_department_id (department_id);
ALTER TABLE person ADD FULLTEXT ix_search (first_name, last_name);
ALTER TABLE keyword ADD FULLTEXT ix_search (keyword_name);
ALTER TABLE event ADD FULLTEXT ix_search (event_name);
ALTER TABLE placement ADD FULLTEXT ix_search (placement_name);
This results in what I thought would be fulltext indexes for each table called "ix_search" but what it creates are indexes with COMMENTS of "fulltext", not INDEX_TYPE of "FULLTEXT".
Could someone show me how to do this right for 3.23.58?
Thanx
Phil
