add indexes to foreign keys and slugs