additions and modifications for DDL