removed ruby 192
added indices
updated schema