Test Database fails to initialize

CapnRegex
2008-04-22T17:27:29Z

Hi, yes, I''m still using rails 1.2.6, as I haven''t made the
time to
migrate.

when I try to do run tests using rake, it fails to initialize the
database correctly..

I create the database using migrations, and I wanted to index a text
field in mysql.
The default
add_index command does not handle adding the index correctly, as mysql
requires a length for indexing a test field, for how much of the text
field to index.

so, in my migration I have a

Model.connection.execute(''CREATE INDEX index_name ON table_name
( field1, field2, text_field(20) )'')

however, rails records that in the schema.rb as

add_index "table",
["field1","field2","text_field"], :name =>
"index_name"

which fails.

I don''t want to eliminate the index, as it gives me a considerable
speed increase when looking for an exact match in the text_field..

Ideas?