update DDL and reference data files and also demo dumps with latest schema and core reports work.