updated DDL to in-table binary types