kiosk: update scheme and sql implementation