added autoincremented ids for schemas