updated repo impl after schema changes.
updated main 2.3 scripts, added 2 columns based on repo changes.