Indexes for primary tables & search fields
Added indexes for common queries, MySQL enum types for db schema

* MySQL's enum type should help control the size of the tables and
  performs better than varchar columns