Question: Im trying to add a full-text index to a table in my migrations, but I cant get it working. the code I've tried dosen't error and even works when run in my SQL manager, but does not create an index when I call migrate command.

The commands below are the file thats last in the list to be run.

Ive tried the following, commented and uncommented:

```
public function up()
{
    //DB::raw('create index qsearch on questions (question)');
    DB::raw('CREATE INDEX question_fulltext_idx ON questions USING gin(to_tsvector("english", question))');
}

```

The table is `questions`, the column is `question`.

What am I doing wrong?

Answer: 
Seems I was using the wrong quotes, this now works:

```
DB::statement("CREATE INDEX question_fulltext_idx ON questions USING gin(to_tsvector('english', question))");

```
I don't know about the `CREATE INDEX ..` query itself. But you're not actually running the query agains the database.

This "creates" a raw query:

```
DB::raw('CREATE INDEX question_fulltext_idx ON questions USING gin(to_tsvector("english", question))');

```

The newly created raw query would then be used inside another query.

This actually runs your statement against the database:

```
DB::statement('CREATE INDEX question_fulltext_idx ON questions USING gin(to_tsvector("english", question))');

```

I hope this helps you!