add echo and more comments to update_local_db.sh
fix column type of tiid
make new /collection endpoints