add transactions to ddl