fix ddl script and added more test harness