@Override public String getCustomColumnDefinition(Table table) { if (!needsClusteredColumn(table)) { return null; } return String.format("[%s] BIGINT NOT NULL IDENTITY", CLUSTER_INDEX_COL); }
@Override public List<String> getCustomPostCreateSqls(Table table, Model model) { if (!needsClusteredColumn(table)) { return Collections.emptyList(); } String quotedIndexName = getIndexName(table.getKey(), Collections.singletonList(CLUSTER_INDEX_COL)); String sql = String.format("CREATE UNIQUE CLUSTERED INDEX [%s] ON %s ([%s])", quotedIndexName, table.getQuotedName(), CLUSTER_INDEX_COL); return Collections.singletonList(sql); }