protected Column newColumn(String columnName, ColumnType type) { Column column = table.addColumn(columnName, type, columnName, model); if (type == ColumnType.NODEID) { // column.setIdentity(true); if idGenPolicy identity column.setNullable(false); column.setPrimary(true); } if (type == ColumnType.NODEIDFK || type == ColumnType.NODEIDPK) { column.setNullable(false); column.setPrimary(true); } if (type == ColumnType.NODEIDFKMUL) { column.setNullable(false); table.addIndex(columnName); } if (type == ColumnType.NODEIDFK || type == ColumnType.NODEIDFKNP || type == ColumnType.NODEIDFKNULL || type == ColumnType.NODEIDFKMUL) { column.setReferences(database.getTable(Model.HIER_TABLE_NAME), Model.MAIN_KEY); } return column; }
column.setIdentity(true); column.setPrimary(true); column.setNullable(false); idColumn = column;
protected void getTable(Connection connection, String tbl) throws SQLException { String tablePhysicalName = dialect.getTableName(tbl); table = new TableImpl(dialect, tablePhysicalName, tablePhysicalName); keyCol = addColumn(KEY_COL, ColumnType.SYSNAME); keyCol.setPrimary(true); keyCol.setNullable(false); longCol = addColumn(LONG_COL, ColumnType.LONG); stringCol = addColumn(STRING_COL, ColumnType.CLOB); bytesCol = addColumn(BYTES_COL, ColumnType.BLOB); ttlCol = addColumn(TTL_COL, ColumnType.LONG); table.addIndex(TTL_COL); tableName = table.getQuotedName(); keyColName = keyCol.getQuotedName(); longColName = longCol.getQuotedName(); stringColName = stringCol.getQuotedName(); bytesColName = bytesCol.getQuotedName(); ttlColName = ttlCol.getQuotedName(); if (!tableExists(connection)) { createTable(connection); } checkColumns(connection); }