dc.executeUpdate(new UpdateScript() {
@Override
public void run(UpdateCallback cb) {
ColumnCreationBuilder createTableBuilder = cb.createTable(schema, "test_table").withColumn("id")
.ofType(ColumnType.INTEGER).withColumn("code").ofType(ColumnType.CHAR).ofSize(1);
String sql = createTableBuilder.toSql();
assertTrue(sql, sql.indexOf("test_table (id INTEGER,code CHAR(1))") != -1);
Table table = createTableBuilder.execute();
cb.insertInto(table).value("id", 1).value("code", 'P').execute();
cb.insertInto(table).value("id", 2).value("code", 'O').execute();