Test-db on SQLite: getting "index xx already exists" error

Rails
1

Hi all

I wanted to speed up my tests, so I changed my test environment from
MySQL to SQLite. I’m on OSX 10.4 so SQLite3 is already installed.

I changed the test env to the following:

SQLite3::SQLException: index name_unique already exists: CREATE UNIQUE
INDEX “name_unique” ON link_categories (“name”)

But after running rake db:test:prepare I got the following error:

SQLite3::SQLException: index name_unique already exists: CREATE UNIQUE
INDEX “name_unique” ON link_categories (“name”)

After changing back to MySQL everything worked again. What’s wrong
here?!

Thanks
Josh