updated DDLs and DMLs