Test Database fails to initialize

Rails
1

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?

2

On 22 Apr 2008, at 18:27, CapnRegex wrote:

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…

Switch from using the ruby schema dumper to the sql one (it’s an
option in environment.rb)

3

Yay, that worked, thanks…

just for the record, I added in

Rails::Initializer.run do |config|
… stuff that was already there …
config.active_record.schema_format = :sql
end

On Apr 22, 11:54 am, Frederick C. [email protected]