more spotschema, bookings, and functions
index fixes