The migrations are created semi-automatically by editing south --auto migrations. South is creating an index for all foreign keys as [it is useful](http://stackoverflow.com/a/836215/1247955). This part is commented out since there is a [problem with sqllite](http://south.aeracode.org/ticket/1172) when field is given foreign key constraint. I have checked and in mysql after migration title_id is index.