update with latest schema and schematic