221
221
String schema = "test";
222
222
String table = "defaults";
223
223
builder.userTable(schema, table);
224
builder.column(schema, table, "col1", 0, "VARCHAR", 10L, null, false, false, null, null, "fred");
225
builder.column(schema, table, "col2", 1, "VARCHAR", 10L, null, false, false, null, null, "");
226
builder.column(schema, table, "col3", 2, "BIGINT", null, null, false, false, null, null, "0");
224
builder.column(schema, table, "col1", 0, "VARCHAR", 10L, null, false, false, null, null, "fred", null);
225
builder.column(schema, table, "col2", 1, "VARCHAR", 10L, null, false, false, null, null, "", null);
226
builder.column(schema, table, "col3", 2, "BIGINT", null, null, false, false, null, null, "0", null);
227
builder.column(schema, table, "col4", 3, "DATE", null, null, false, false, null, null, null, "current_date");
227
228
builder.createGroup(table, schema);
228
229
builder.addTableToGroup(table, schema, table);
432
433
{ "test", "defaults", "col1", 0L, "varchar", false, 10L, null, null, 1L, I_S, VARCHAR, I_S, VARCHAR, null, null, null, null, null, null, null, null, "fred", LONG},
433
434
{ "test", "defaults", "col2", 1L, "varchar", false, 10L, null, null, 1L, I_S, VARCHAR, I_S, VARCHAR, null, null, null, null, null, null, null, null, "", LONG},
434
435
{ "test", "defaults", "col3", 2L, "bigint", false, 8L, null, null, 0L, null, null, null, null, null, null, null, null, null, null, null, null, "0", LONG},
436
{ "test", "defaults", "col4", 3L, "date", false, 3L, null, null, 0L, null, null, null, null, null, null, null, null, null, null, null, null, "current_date()", LONG},
435
437
{ "test", "foo", "c1", 0L, "int", false, 4L, null, null, 0L, null, null, null, null, null, null, null, null, null, null, null, null, null,LONG},
436
438
{ "test", "foo", "c2", 1L, "double", true, 8L, null, null, 0L, null, null, null, null, null, null, null, null, null, null, null, null, null,LONG},
437
439
{ "test", "seq-table", "col", 0L, "bigint", false, 8L, null, null, 0L, null, null, null, null, "test", "_col_sequence", "BY DEFAULT", 1L, 1L, 0L, 1000L, "NO", null, LONG},