Index type should become before table name.

MySQL versions prior to v5.1 do not support type clause
at the end of the statement.

git-svn-id: http://textpattern.googlecode.com/svn/development/4.x@5448 2fea6a4d-a838-0410-917b-93a53c48e9d2