tidy up schema ddl for demos and ceda.