Add Index on categories.parent_id to Accelerate Query

Created by: wtune

Problem

Missing index on table categories column parent_id might make the underlying query issued via CategoryServiceImpl#listByParentId slow. Since table categories is mostly read and sometimes inserted or updated, the performance impact for write operations is acceptable under common cases.

Possible Solution

Add Index on categories.parent_id